v_occupancy_contact: One-to-Many (1:N)
One occupancy can have many contacts
Referenced through place_id
f_fire_inspection: One-to-Many (1:N)
One occupancy can have many inspections
Referenced through place_id
v_fire_inspection_violation: One-to-Many (1:N)
One occupancy can have many violations
Referenced through place_id
v_fd_permit: One-to-Many (1:N)
One occupancy can have many permits
Referenced through location relationship
Column | Type | Description |
id | integer | Primary key |
created_by | integer | Creator 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 |
preplan_id | integer | Pre-plan reference |
place_status_code | varchar(20) | Status code |
parent_id | integer | Parent location |
city | varchar(255) | City |
state_code | varchar(3) | State code |
zip | varchar(15) | ZIP code |
latitude | numeric(9,7) | GPS latitude |
longitude | numeric(10,7) | GPS longitude |
preplan_business_name | varchar(128) | Business name |
preplan_business_phone | varchar(50) | Business phone |
preplan_is_high_rise | boolean | High-rise flag |
preplan_property_class | varchar(255) | Property class |
preplan_building_use | varchar(2048) | Building use |
preplan_building_height_feet | integer | Height in feet |
preplan_building_area_squarefeet | varchar(64) | Floor area |
preplan_number_floors | varchar(64) | Floor count |
preplan_occupancy_load | varchar(128) | Occupant load |
fire_zone | integer | Fire zone |
fire_zone_name | varchar(255) | Zone name |