Constraints

9 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
divisions_ibfk_1
divisions.financial_record_id
financial_records.id
Restrict delete
festival_items_ibfk_1
festival_items.division_id
divisions.id
Restrict delete
user_groups_ibfk_1
user_groups.user_id
users.id
Restrict delete
user_groups_ibfk_2
user_groups.group_id
divisions.id
Restrict delete
financial_records_ibfk_1
financial_records.year_id
years.id
Restrict delete
item_budgets_ibfk_1
item_budgets.festival_item_id
festival_items.id
Restrict delete
buy_statuses_ibfk_1
buy_statuses.buy_report_id
buy_reports.id
Cascade on delete
buy_reports_ibfk_1
buy_reports.festival_item_id
festival_items.id
Restrict delete
payment_receipts_ibfk_1
payment_receipts.buy_report_id
buy_reports.id
Cascade on delete

Check Constraints

Table Constraint Name Constraint