Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| recent_falls | int4 |
|
|
|
| recent_fall_injuries | int4 |
|
|
|
| medications | int4 |
|
|
|
| medication_impacts | int4 |
|
|
|
| medical_conditions | int4 |
|
|
|
| vision_loss | bool |
|
|
|
| somato_sensory_loss | bool |
|
|
|
| foot_problems | bool |
|
|
|
| unsafe_footwear | bool |
|
|
|
| cognitive_status | int4 |
|
|
|
| incontinence | bool |
|
|
|
| nocturia | bool |
|
|
|
| dietary_status | int4 |
|
|
|
| weight_loss | int4 |
|
|
|
| alcohol_consumption | int4 |
|
|
|
| environmental_hazards | int4 |
|
|
|
| functional_behaviour | int4 |
|
|
|
| personal_care_assistance | int4 |
|
|
|
| personal_care_assistance_changed | bool |
|
|
|
| instrumental_activities_assistance | int4 |
|
|
|
| instrumental_activities_assistance_changed | bool |
|
|
|
| balance | int4 |
|
|
|
| home_walking_safety | int4 |
|
|
|
| community_walking_safety | int4 |
|
|
|
| physical_activity | int4 |
|
|
|
| physical_activity_changed | 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) |
|---|---|---|---|
| 8fea92adafc886b699d7d8506d09c49f | Performance | Asc | company_id |