Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| incident_id | int8 |
|
|
|
| likelihood | varchar |
|
|
|
| impact | varchar |
|
|
|
| severity | varchar |
|
|
|
| client_review_at | date |
|
|
|
| referral_at | date |
|
|
|
| update_help_plan_at | date |
|
|
|
| debrief_at | date |
|
|
|
| coaching_at | date |
|
|
|
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| reported_to_aged_care_quality_and_safety_commission_at | date |
|
|
|
| reported_to_child_safety_at | date |
|
|
|
| reported_to_ndis_quality_and_safequards_commission_at | date |
|
|
|
| reported_to_office_of_australian_information_commissioner_at | date |
|
|
|
| reported_to_police_at | date |
|
|
|
| date |
|
|
||
| reported_to_next_of_kin_at | date |
|
|
|
| reported_to_enduring_power_of_attorney_at | date |
|
|
|
| reported_to_other_at | date |
|
|
|
| other_action_at | date |
|
|
|
| whs_category | varchar |
|
|
|
| whs_severity | varchar |
|
|
|
| company_id | int8 |
|
|
The owning tenant’s ID. @example 1. |
| created_at_in_company_tz | timestamp |
|
|
|
| updated_at_in_company_tz | timestamp |
|
|
|
| company_timezone | varchar |
|
|
The company timezone. E.g. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| edge_incident_actions_pkey | Primary key | Asc | id |
| idx_edge_incident_actions_company_id | Performance | Asc | company_id |
| idx_edge_incident_actions_incident_id | Performance | Asc | incident_id |