v_incident_report_personnel

v_incident_report_personnel

Purpose

  1. Personnel response records for incidents.


Relationships

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

    • Many personnel link to one apparatus response

    • Referenced through incident_report_apparatus_id

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

    • Many responses link to one personnel

    • Referenced through personnel_id




Table



Column

Type

Description

id

integer

Primary key

incident_report_apparatus_id

integer

Apparatus response reference

personnel_id

integer

Personnel reference

created_at

timestamp

Creation time

public_name

varchar(255)

Personnel name

client_code

varchar(28)

Organization ID

user_id

integer

User reference

personnel_actions_taken

text[]

Actions performed




    • Related Articles

    • v_incident_report_apparatus

      Purpose Apparatus response details for incidents. Relationships v_incident_report: Many-to-One (N:1) Many apparatus responses link to one incident Referenced through incident_report_id v_apparatus: Many-to-One (N:1) Many responses link to one ...
    • v_incident_report_station_response

      Purpose Station response records for incidents. Relationships v_incident_report: Many-to-One (N:1) Many station responses link to one incident Referenced through incident_report_id v_personnel: Many-to-One (N:1) Many responses link to one personnel ...
    • v_incident_report_people_address

      Purpose Address records for incident-involved people. Relationships v_incident_report_people: Many-to-One (N:1) Many addresses link to one person Referenced through incident_report_people_id v_personnel: Many-to-One (N:1) Many addresses created by ...
    • v_incident_report_payroll_summary

      Purpose Incident-related payroll records. Relationships v_incident_report: Many-to-One (N:1) Many payroll records link to one incident Referenced through incident_report_id v_personnel: Many-to-One (N:1) Many payroll records link to one personnel ...
    • v_incident_report_people_insurance

      Purpose Insurance information for incident-involved people. Relationships v_incident_report_people: Many-to-One (N:1) Many insurance records link to one person Referenced through incident_report_people_id v_personnel: Many-to-One (N:1) Many insurance ...