Database Properties
Database Type: PostgreSQL - 17.4 (Debian 17.4-1.pgdg110+2)
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| facility_connection_states | 1 | 0 | 2 | -1 | Table | (Enum) Progress of the configuration of a device manager for a facility. |
| device_template_categories | 1 | 0 | 2 | -1 | Table | (Enum) User-facing categories of device templates; used to show templates for a particular class of devices where the physical device type may differ from one entry to the next. |
| facilities | 8 | 2 | 22 | -1 | Table | Physical locations at a site. For example, each seed bank and each nursery is a facility. |
| organizations | 5 | 0 | 14 | -1 | Table | Top-level information about organizations. |
| device_managers | 0 | 1 | 13 | -1 | Table | Information about device managers. This is a combination of information from the Balena API and locally-generated values. |
| devices | 3 | 2 | 15 | -1 | Table | Hardware devices managed by the device manager at a facility. |
| timeseries_types | 1 | 0 | 2 | -1 | Table | (Enum) Data formats of the values of a timeseries. |
| device_templates | 0 | 1 | 12 | -1 | Table | Canned device configurations for use in cases where we want to show a list of possible devices to the user and create the selected device with the correct settings so that the device manager can talk to it. |
| timeseries_values | 0 | 1 | 3 | -1 | Table | Individual data points on a timeseries. For example, each time the temperature is read from a thermometer, the reading is inserted here. |
| automations | 0 | 2 | 15 | -1 | Table | Configuration of automatic processes run by the device manager. |
| timeseries | 1 | 2 | 10 | -1 | Table | Properties of a series of values collected from a device. Each device metric is represented as a timeseries. |