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
Referenced through incident_report_people_id
v_incident_report_people_insurance: One-to-Many (1:N)
One person can have many insurance records
Referenced through incident_report_people_id
Column | Type | Description |
id | integer | Primary key |
client_code | varchar(28) | Organization ID |
incident_report_id | integer | Incident reference |
name_prefix | varchar(50) | Name prefix |
first_name | varchar(100) | First name |
middle_initial | varchar(1) | Middle initial |
last_name | varchar(100) | Last name |
name_suffix | varchar(50) | Name suffix |
age | integer | Age |
gender | varchar(1) | Gender code |
race | varchar(2) | Race code |
ethnicity | varchar(50) | Ethnicity |
phone_number | text | Contact phone |
emails | text | Contact email |
involvement | text | Role/involvement |
created_by | integer | Creator reference |
created_at | timestamp | Creation time |
note | text | Additional notes |
dob | date | Birth date |
ssn | varchar(9) | SSN |
driver_license_number | varchar(255) | License number |
driver_license_state | varchar(255) | License state |
is_homeless | boolean | Housing status |