Constraints

24 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

FK_9BEEE2F981C06096

activity_execution.activity_id

Cascade on delete

FK_9BEEE2F952A96A69

activity_execution.event_timeslot_id

event_timeslot.id

Cascade on delete

FK_25AC3C1481C06096

activity_event.activity_id

Cascade on delete

FK_25AC3C1471F7E88B

activity_event.event_id

Cascade on delete

FK_3BE452F79C24126

timeslot.day_id

day.id

Cascade on delete

FK_472E5446FED90CCA

user_permission.permission_id

Cascade on delete

FK_472E5446A76ED395

user_permission.user_id

Cascade on delete

FK_7D08BB27F920B9E9

event_timeslot.timeslot_id

Cascade on delete

FK_7D08BB2771F7E88B

event_timeslot.event_id

Cascade on delete

FK_8D93D649D60322AC

user.role_id

Restrict delete

FK_3BAE0AA764D218E

event.location_id

Null on delete

FK_89ED456564D218E

location_assignment.location_id

Cascade on delete

FK_89ED4565A76ED395

location_assignment.user_id

Cascade on delete

FK_7DDD2B8D8E834A7A

info_page_role.info_page_id

Cascade on delete

FK_7DDD2B8DD60322AC

info_page_role.role_id

Cascade on delete

FK_65277AB2A76ED395

activity_assignment.user_id

Cascade on delete

FK_65277AB25EAA9705

activity_assignment.activity_execution_id

activity_execution.id

Cascade on delete

FK_6F7DF886D60322AC

role_permission.role_id

Cascade on delete

FK_6F7DF886FED90CCA

role_permission.permission_id

Cascade on delete

FK_30C544BAA76ED395

assignment.user_id

Cascade on delete

FK_30C544BA52A96A69

assignment.event_timeslot_id

event_timeslot.id

Cascade on delete

FK_AC74095A64D218E

activity.location_id

Restrict delete

FK_E00CEDDEA76ED395

booking.user_id

Cascade on delete

FK_E00CEDDE5EAA9705

booking.activity_execution_id

activity_execution.id

Cascade on delete

Check Constraints

Table	Constraint Name	Constraint