Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | √ | null |
|
|
|||||
| balena_id | int8 | 19 | null |
|
|
Balena-assigned device identifier. |
|||||
| balena_modified_time | timestamptz | 35,6 | null |
|
|
Last modification timestamp from Balena. This is distinct from |
|||||
| device_name | text | 2147483647 | null |
|
|
||||||
| is_online | bool | 1 | null |
|
|
||||||
| last_connectivity_event | timestamptz | 35,6 | √ | null |
|
|
|||||
| update_progress | int4 | 10 | √ | null |
|
|
Percent complete of software download and installation (0-100). Null if no software update is in progress. |
||||
| sensor_kit_id | text | 2147483647 | null |
|
|
ID code that is physically printed on the sensor kit and set as a tag value in the Balena device configuration. |
|||||
| user_id | int8 | 19 | √ | null |
|
|
|||||
| facility_id | int8 | 19 | √ | null |
|
|
|||||
| created_time | timestamptz | 35,6 | null |
|
|
When this device manager was added to the local database. The Balena device may have been created earlier. |
|||||
| refreshed_time | timestamptz | 35,6 | null |
|
|
||||||
| balena_uuid | text | 2147483647 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| device_managers_pkey | Primary key | Asc | id |
| device_managers_balena_id_unique | Must be unique | Asc | balena_id |
| device_managers_balena_uuid_unique | Must be unique | Asc | balena_uuid |
| device_managers_facility_id_key | Must be unique | Asc | facility_id |
| device_managers_short_code_key | Must be unique | Asc | sensor_kit_id |
| device_managers_user_id_idx | Performance | Asc | user_id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| device_managers_user_iff_facility | (((user_id IS NOT NULL) AND (facility_id IS NOT NULL)) OR ((user_id IS NULL) AND (facility_id IS NULL))) |