v_occupancy: Many-to-One (N:1)
Many units link to one location
Referenced through preplan relationship
v_preplan_expiring_unit: One-to-One (1:1)
Each unit may have one expiring record
Referenced through matching attributes
v_preplan_unit_history: One-to-Many (1:N)
One unit can have many history records
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 |
connection_size | varchar(64) | Connection size |
standpipe_type | varchar(128) | Standpipe type |
standpipe_location | varchar(1024) | Standpipe location |
suppression_system_type | varchar(128) | Suppression type |
sprinkler_system_type | varchar(128) | Sprinkler type |
alarm_panel_type | varchar(128) | Panel type |
alarm_panel_location | varchar(1024) | Panel location |
alarm_system_type | varchar(128) | System type |
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 |
has_fire_alarm | boolean | Alarm status |
preplan_id | integer | Pre-plan reference |
client_code | varchar(28) | Organization ID |
latitude | numeric(9,7) | GPS latitude |
longitude | numeric(10,7) | GPS longitude |