v_preplan_hazmat_history

v_preplan_hazmat_history

Purpose

  1. 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 to one location

    • Referenced through address_id




Table



Column

Type

Description

id

integer

Primary key

hm_un_code

varchar(25)

UN code

chemical_name

varchar(1000)

Chemical name

health_hazard_code

smallint

Health hazard

fire_hazard_code

smallint

Fire hazard

reactivity_code

smallint

Reactivity

special_hazard_code

varchar(4)

Special hazard

quantity

varchar(64)

Quantity




    • Related Articles

    • v_preplan_expiring_hazmat

      Purpose Expiring hazardous materials in pre-plans. Relationships v_occupancy: Many-to-One (N:1) Many hazmat records link to one location Referenced through address_id v_preplan_hazmat: One-to-One (1:1) Each expiring hazmat links to one hazmat record ...
    • v_preplan_hazmat

      Purpose Hazardous materials in pre-plans. Relationships v_occupancy: Many-to-One (N:1) Many hazmat records link to one location Referenced through address_id v_preplan_expiring_hazmat: One-to-One (1:1) Each hazmat record may have one expiring record ...
    • v_preplan_unit_history

      Purpose 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 ...
    • 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_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 ...