command


Description

Catalog of commands that devices accept

Columns

Column Type Size Nulls Auto Default Children Parents Comments
idcommand int8 19 null
alertconf_command.idcommand FK_alertconf_command_command R
command_devicemodel.idcommand FK_command_modeldevice_command R
commandexec.idcommand FK_commandexec_command R
coverage_command.idcommand FK_coverage_command_command R
shipperconf_command.idcommand FK_sharedview_command_command R
alias varchar 100 null
description varchar 200 √ null
cmdconfmetadata varchar 500 √ null
enabled bool 1 true
is_operative bool 1 √ null
commandtype int4 10 null
command_commandtype.id fk_command_commandtype R

Indexes

Constraint Name Type Sort Column(s)
PK_catcommand Primary key Asc idcommand
UQ_command_idcommand Must be unique Asc idcommand

Relationships

Close relationships within degrees of separation