Constraints

10 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
fk47ikjj5b5f2ojsrxhgkvlal3e
movements.transit_id
transits.transit_id
Cascade on delete
fkrktppka7cjdkx2u65xx2k71eg
aggregated_movements.area_id
monitored_areas.id
Restrict delete
fkim5dj1mwupcrqq235tmsob2rq
monitored_areas.detection_parameters_id
detection_parameters.id
Restrict delete
fk6gbtmqat4r3ec93933aqmffq8
monitored_areas.device_id
device.id
Restrict delete
fkgb4r2hly4ntx8xuwvsrnuog74
statistics.zone_sequence_id
zone_sequences.zone_sequence_id
Cascade on delete
fkmy94ykomgw3uebmjhgowb2crn
screenshots.area_id
monitored_areas.id
Restrict delete
fke2ivrb0ke7nhlf9dto4sn5hr4
zone_sequences.monitored_area_id
monitored_areas.id
Restrict delete
fkk7uyctqapp9grsaf050yk007a
zones.area_id
monitored_areas.id
Restrict delete
fk3vbktm4gsgnj6xkw3uq8n966a
transits.zone_sequence_id
zone_sequences.zone_sequence_id
Cascade on delete
fkkaevl15e8hps569eu2xwjv94t
aggregated_trajectories.area_id
monitored_areas.id
Restrict delete

Check Constraints

Table Constraint Name Constraint
None detected