target_area_candidate


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
target_area_document.candidate_id FK_4ygvyo4h37a4mv2jxwh20g7p3 R
version BIGINT 19 null
address VARCHAR 50 √ null
city VARCHAR 30 √ null
frontage_width DECIMAL 19,2 √ null
index_number INT 10 null
stores_non_branded.number Implied Constraint R
nnn_psf DECIMAL 19,2 √ null
rent_psf DECIMAL 19,2 √ null
space_status_id INT 10 √ null
sqft INT 10 √ null
state VARCHAR 2 √ null
storefront_url VARCHAR 4096 √ null
target_area_id INT 10 null
target_area.id FK_liik6h8882h4tcsqnkjcwhc2d R
turnover_condition_id INT 10 √ null
zip VARCHAR 10 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
unique_index_number Must be unique Asc/Asc target_area_id + index_number

Relationships

Close relationships within degrees of separation