Constraints

10 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

sensors_device_id_foreign

sensors.device_id

devices.device_id

Cascade on delete

device_relationship_child_device_id_fk

device_relationships.child_device_id

devices.device_id

Cascade on delete

device_relationship_parent_device_id_fk

device_relationships.parent_device_id

devices.device_id

Cascade on delete

component_statuslog_ibfk_1

component_statuslog.component_id

Cascade on delete

sensors_to_state_indexes_sensor_id_foreign

sensors_to_state_indexes.sensor_id

sensors.sensor_id

Cascade on delete

sensors_to_state_indexes_ibfk_1

sensors_to_state_indexes.state_index_id

state_indexes.state_index_id

Restrict delete

wireless_sensors_device_id_foreign

wireless_sensors.device_id

devices.device_id

Cascade on delete

component_prefs_ibfk_1

component_prefs.component

Cascade on delete

device_group_device_device_group_id_foreign

device_group_device.device_group_id

device_groups.id

Cascade on delete

device_group_device_device_id_foreign

device_group_device.device_id

devices.device_id

Cascade on delete

Check Constraints

Table	Constraint Name	Constraint