commandexec


Description

Records commands sent to a device and their status

Columns

Column Type Size Nulls Auto Default Children Parents Comments
idcmdexe int8 19 null
binarymsg.idcmdexe fk_binarymsg_commandexec R
commandexec_port_dynamic.idcmdexe commandexec_port_dynamic_idcmdexe_fkey R
vw_commandexec.idcmdexe Implied Constraint R
iduser int8 19 null
mayauser.idmayauser FK_commandexec_user R
idcommand int8 19 null
command.idcommand FK_commandexec_command R
laststatusdate timestamptz 35,6 null
senddate timestamptz 35,6 √ null
confirmeddate timestamptz 35,6 √ null
enabled bool 1 true
iddevice int4 10 null
device.iddevice FK_commandexec_device R
status int4 10 0
lastmodifiedbyuser int4 10 √ null
switches varchar 5 √ null
creationdate timestamptz 35,6 √ now()

Indexes

Constraint Name Type Sort Column(s)
PK_cmdexe Primary key Asc idcmdexe
idx_commandexec_idcommand Performance Asc idcommand
idx_commandexec_iddevice Performance Asc iddevice
idx_commandexec_iduser Performance Asc iduser
idx_commandexec_senddate Performance Asc senddate
idx_commandexec_status Performance Asc status
UQ_cmdexe_idcmdexe Must be unique Asc idcmdexe

Relationships

Close relationships within degrees of separation