v_preplan_last_completed

v_preplan_last_completed

Purpose

  1. 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

    • Referenced through location matching




Table



Column

Type

Description

id

integer

Primary key

client_code

varchar(28)

Organization ID

preplan_location_cache

text

Location details

preplan_last_completed_by

integer

Completer reference

preplan_last_completed_at

timestamp

Completion time




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

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