v_preplan_unit: Many-to-One (N:1)
Many history records link to one current unit
Referenced through matching attributes
Column | Type | Description |
id | integer | Primary key |
preplan_unit_history_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_system_type | varchar(128) | Alarm system |
fire_pump_type | varchar(128) | Pump type |
last_test_date | date | Last test date |
preplan_id | integer | Pre-plan reference |
client_code | varchar(28) | Organization ID |
latitude | numeric(9,7) | GPS latitude |
longitude | numeric(10,7) | GPS longitude |
unique_id | varchar | Unique identifier |