device_profile_peripheral


Columns

Column Type Size Nulls Auto Default Children Parents Comments
iddevice_profile_peripheral serial 10 √ nextval('device_profile_peripheral_iddevice_profile_peripheral_seq'::regclass)
iddevice_profile int4 10 null
device_profile.iddevice_profile fk_device_profile_peripheral_iddevice_profile R
idperipheral_template int4 10 null
peripheral_template.idperipheral_template fk_device_profile_peripheral_idperipheral_template R
idperipheral_type int4 10 √ null
icon_low int4 10 √ null
icon_high int4 10 √ null
idserial_index int4 10 √ null
iddigital_index int4 10 √ null
enabled bool 1 √ null
icon_serial int4 10 √ null
alias_port varchar 2147483647 √ null
alias_high varchar 2147483647 √ null
alias_low varchar 2147483647 √ null
iddigitaloutput_index int4 10 √ null
serialicon int4 10 √ null
send_separate bool 1 √ null
pulse_based bool 1 √ null
blink_active bool 1 √ null
blink_type int4 10 √ null
set_label text 2147483647 √ null
clear_label text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
device_profile_peripheral_pkey Primary key Asc iddevice_profile_peripheral

Relationships

Close relationships within degrees of separation