v_preplan_unit_history

v_preplan_unit_history

Purpose

  1. Historical pre-plan unit information.


Relationships

  • v_preplan_unit: Many-to-One (N:1)

    • Many history records link to one current unit

    • Referenced through matching attributes



Table



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




    • Related Articles

    • v_preplan_unit

      Purpose Pre-plan unit information. Relationships 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 ...
    • v_preplan_expiring_unit

      Purpose Expiring pre-plan unit information. Relationships 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 ...
    • v_preplan_hazmat_history

      Purpose Historical hazardous materials records. Relationships v_preplan_hazmat: Many-to-One (N:1) Many history records link to one current hazmat record Referenced through matching attributes v_occupancy: Many-to-One (N:1) Many hazmat histories link ...
    • v_occupancy_history

      Purpose Historical occupancy information. Relationships v_occupancy: Many-to-One (N:1) Many history records link to one occupancy Referenced through place_id Table Column Type Description id integer Primary key place_id integer Location reference ...
    • v_preplan_last_completed

      Purpose Last completed pre-plan information. Relationships v_personnel: Many-to-One (N:1) Many completions done by one personnel Referenced through preplan_last_completed_by v_occupancy: One-to-One (1:1) One completion links to one location ...