v_incident_report_people_address

v_incident_report_people_address

Purpose

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

    • Referenced through created_by




Table



Column

Type

Description

id

integer

Primary key

client_code

varchar(28)

Organization ID

incident_report_people_id

integer

Person reference

address_type

text

Address type

address

varchar(255)

Street address

unit

varchar(80)

Unit/apartment

city

varchar(255)

City

state_code

varchar(3)

State code

zip

varchar(15)

ZIP code

created_by

integer

Creator reference

created_at

timestamp

Creation time




    • Related Articles

    • 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_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 ...
    • Completing an Incident Report - Response

      Purpose To explain how to complete the Response section of an Incident Report. Related Articles Completing an Incident Report - Response (this article) Completing an Incident Report - Size-up Completing an Incident Report - Operations Completing an ...
    • 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 ...