v_incident_report_question

v_incident_report_question

Purpose

  1. Incident report question responses.


Relationships

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

    • Many questions link to one incident

    • Referenced through incident_report_id

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

    • Many questions link to one apparatus response

    • Referenced through incident_report_apparatus_id

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

    • Many questions link to one person

    • Referenced through incident_report_people_id




Table



Column

Type

Description

id

integer

Primary key

incident_report_id

integer

Incident reference

client_code

varchar(28)

Organization ID

ir_question_id

integer

Question reference

ir_question_value

text

Response value

ir_question_code

varchar(10)

Question code

ir_question_name

varchar(255)

Question text

incident_report_apparatus_id

integer

Apparatus reference

incident_report_station_response_id

integer

Station response reference

incident_report_people_id

integer

Person reference

question_value

text

Response detail




    • Related Articles

    • v_incident_report_personnel

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

      Purpose People involved in incidents. Relationships v_incident_report: Many-to-One (N:1) Many people link to one incident Referenced through incident_report_id v_incident_report_people_address: One-to-Many (1:N) One person can have many addresses ...
    • 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 ...
    • Completing an Incident Report - Completing and Authorizing

      Purpose This article will guide you through Completing and Authorizing an Incident Report. Related Articles Completing an Incident Report - Response Completing an Incident Report - Size-up Completing an Incident Report - People Involved Completing an ...
    • Completing an Incident Report - Size Up

      Purpose This article will guide you through the Size-up section of an Incident Report. Related Articles Completing an Incident Report - Response Completing an Incident Report - People Involved Completing an Incident Report - Operations Completing an ...