v_occupancy: Many-to-One (N:1)
Many history records link to one occupancy
Referenced through place_id
Column | Type | Description |
id | integer | Primary key |
place_id | integer | Location reference |
address1 | varchar(255) | Primary address |
address2 | varchar(255) | Secondary address |
location_cache | text | Location details |
street_name | varchar(128) | Street name |
client_code | varchar(28) | Organization ID |
place_status_code | varchar(20) | Status code |
city | varchar(255) | City |
state_code | varchar(3) | State code |
zip | varchar(15) | ZIP code |
preplan_status_code | varchar(25) | Pre-plan status |
preplan_business_name | varchar(128) | Business name |
preplan_business_phone | varchar(50) | Business phone |
preplan_property_class | varchar(255) | Property class |
preplan_business_type | varchar(128) | Business type |
preplan_building_use | varchar(2048) | Building use |
preplan_building_height_feet | integer | Height in feet |
preplan_occupancy_load | varchar(128) | Occupant load |
preplan_risk_score | smallint | Risk score |
tce_premise_ids | text | Premise IDs |
premise_code | varchar(25) | Premise code |