devices

-1 rows


Description

Hardware devices managed by the device manager at a facility.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
automations.device_id automations_device_id_fkey C
devices.parent_id devices_parent_id_fkey R
timeseries.device_id timeseries_device_id_fkey C
facility_id int8 19 null
facilities.id devices_facility_id_fkey C
name text 2147483647 null
device_type text 2147483647 null
make text 2147483647 null
model text 2147483647 null
protocol text 2147483647 √ null
address text 2147483647 √ null
port int4 10 √ null
enabled bool 1 true
settings jsonb 2147483647 √ null
parent_id int8 19 √ null
devices.id devices_parent_id_fkey R
created_by int8 19 null
users.id devices_created_by_fkey R
modified_by int8 19 null
users.id devices_modified_by_fkey R
verbosity int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
device_pkey Primary key Asc id

Check Constraints

Constraint Name Constraint
devices_protocol_check (protocol !~ similar_to_escape(' *'::text))
devices_address_check (address !~ similar_to_escape(' *'::text))

Relationships

Close relationships within degrees of separation