v_incident_report_personnel
Purpose
- Personnel response records for incidents.
Relationships
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 ...