Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| recent_falls | int4 |
|
|
|
| medications | int4 |
|
|
|
| psychological_status | int4 |
|
|
|
| cognitive_status | int4 |
|
|
|
| recent_changes | bool |
|
|
|
| dizziness | bool |
|
|
|
| risk_vision | bool |
|
|
|
| risk_mobility | bool |
|
|
|
| risk_transfers | bool |
|
|
|
| risk_behaviours | bool |
|
|
|
| risk_unsafe_behaviours | bool |
|
|
|
| risk_unsafe_equipment_use | bool |
|
|
|
| risk_unsafe_clothing | bool |
|
|
|
| risk_environment | bool |
|
|
|
| risk_nutrition | bool |
|
|
|
| risk_continence | bool |
|
|
|
| risk_other | bool |
|
|
|
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| 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) |
|---|---|---|---|
| b81d756d7ac7d6fb9ac73ea601f4ebba | Performance | Asc | company_id |