device_relationships

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
parent_device_id INT UNSIGNED 10 0
devices.device_id device_relationship_parent_device_id_fkC
child_device_id INT UNSIGNED 10 null
devices.device_id device_relationship_child_device_id_fkC

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc parent_device_id + child_device_id
device_relationships_child_device_id_index Performance Asc child_device_id

Relationships

Close relationships within degrees of separation