v_occupancy: Many-to-One (N:1)
Many units link to one location
Referenced through preplan relationship
v_preplan_unit: One-to-One (1:1)
Each expiring unit links to one unit record
Referenced through matching attributes
Column | Type | Description |
id | integer | Primary key |
preplan_unit_type_code | varchar(50) | Unit type |
bda_radio_type | varchar(255) | Radio type |
fdc_type | varchar(128) | FDC type |
fdc_location | varchar(1024) | FDC location |
connection_type | varchar(128) | Connection type |
standpipe_type | varchar(128) | Standpipe type |
suppression_system_type | varchar(128) | Suppression type |
alarm_panel_type | varchar(128) | Panel type |
alarm_panel_location | varchar(1024) | Panel location |
fire_pump_type | varchar(128) | Pump type |
fire_pump_location | varchar(128) | Pump location |
operating_pressure | varchar(64) | Operating pressure |
flow_capacity | varchar(64) | Flow capacity |
last_test_date | date | Last test date |
expiration_date | date | Expiry date |
expiration_action | varchar(10) | Required action |
has_fire_alarm | boolean | Alarm status |
preplan_id | integer | Pre-plan reference |
client_code | varchar(28) | Organization ID |
expiration_status_code | text | Status code |