Table commands


Physical Name:
commands

Constraint:



Attribute Summary
PK FK Logical Name Physical Name Type UNIQUE NOT NULL
    id  id  serial    NOT NULL 
    commandtxt  commandtxt  varchar(180)    NOT NULL 
    sent  sent  boolean    NOT NULL 
    device_fk  device_fk  int     

Foreign Key
Attribute Referenced Table Referenced Key ON UPDATE ON DELETE Cardinality of parent Cardinality of child
device_fk  devices  id  NO ACTION  NO ACTION  0..1  1..n 

Referenced Key
Attribute Table Foreign Key ON UPDATE ON DELETE Cardinality of parent Cardinality of child

Complex Unique Key
 

Index Summary
Index Name Type UNIQUE

Attribute Detail

id

id


	

UNIQUE : FALSE
NOT NULL : TRUE
Type : serial
AUTO INCREMENT : TRUE
Default Value :
Constraint :


commandtxt

commandtxt


	

UNIQUE : FALSE
NOT NULL : TRUE
Type : varchar(180)
AUTO INCREMENT : FALSE
Default Value :
Constraint :


sent

sent


	

UNIQUE : FALSE
NOT NULL : TRUE
Type : boolean
AUTO INCREMENT : FALSE
Default Value :
Constraint :


device_fk

device_fk


	

UNIQUE : FALSE
NOT NULL : FALSE
Type : int
AUTO INCREMENT : FALSE
Default Value :
Constraint :