timeseries

0 rows


Description

Properties of a series of values collected from a device. Each device metric is represented as a timeseries.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 null
timeseries_values.timeseries_id timeseries_values_timeseries_id_fkeyC
type_id int4 10 null
timeseries_types.id timeseries_type_id_fkeyR
device_id int8 19 √ null
devices.id timeseries_device_id_fkeyC
name text 2147483647 null
units text 2147483647 √ null

For numeric timeseries, the units represented by the values; unit names should be short (possibly abbreviations) and in the default language of the site.
decimal_places int4 10 √ null

For numeric timeseries, the number of digits after the decimal point to display.
created_time timestamptz 35,6 now()
modified_time timestamptz 35,6 now()
created_by int8 19 null
users.id timeseries_created_by_fkeyR
modified_by int8 19 null
users.id timeseries_modified_by_fkeyR

Indexes

Constraint Name Type Sort Column(s)
timeseries_pkey Primary key Asc id
timeseries_unique_name_per_device Must be unique Asc/Asc device_id + name

Check Constraints

Constraint Name Constraint
timeseries_decimal_places_check ((decimal_places >= 0))
timeseries_units_check ((units !~ similar_to_escape(' *'::text)))

Relationships

Close relationships within degrees of separation