Referential Integrity

ZIPADD

zipid zip* state


ZIPSTATE

zip state

STREETDESIG

desid description


JURISDICTION

jurisid jurisname lastname firstname middlei street zipid* phone email

USAGE

usageid usage

TYPE

typeid type

CONTAMINANTS

contid description

ZONING

zoneid code description jurisid*


BROKER

brokerid lastname firstname middlei phone email street zipid*


OWNER

ownerid lastname firstname middlei phone email street zipid*

EMPLOYEE

employeeid lastname firstname middlei phone email street zipid* ssn

DEVELOPER

developerid lastname firstname middleim phone email street zipid*

PROPERTY

PropID Sold Phase1 Phase2 Phase3 RailAccess MapCoords PropSize AssesNum sitename GPD devpot incentives Comments streetaddress zipid* desid* zoneid* ownerid*


ENVSTAT

PropID* contlevel contamination

USAGEITEM

propid* typeid* usageid*


CONITEM

contid* propid*


DEVSEARCHRESULT

devsearchid searchdate developerid* propid*


TAXINFO

taxid taxyear assessed percentage taxamount status tra exempt improvement landamount propid*

FININFO

finid buyer seller lender lastrans saledate saleamnt firsttd addl docno dolsqft loantype prevdate prevamnt propid*

EMPACTIVITY

actid actdate employeeid propid*