device_groups

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
device_group_device.device_group_id device_group_device_device_group_id_foreignC
name VARCHAR 255 ''
desc VARCHAR 255 √ ''
type VARCHAR 16 'dynamic'
rules TEXT 65535 √ NULL
pattern TEXT 65535 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
device_groups_name_unique Must be unique Asc name

Relationships

Close relationships within degrees of separation