Constraints

22 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

divisions_ibfk_1

divisions.financial_record_id

financial_records.id

Cascade on delete

festival_items_ibfk_1

festival_items.division_id

Cascade on delete

user_groups_ibfk_1

user_groups.user_id

Cascade on delete

user_groups_ibfk_2

user_groups.group_id

Cascade on delete

buy_report_income_expenditure_managements_ibfk_2

buy_report_income_expenditure_managements.income_expenditure_management_id

income_expenditure_managements.id

Cascade on delete

buy_report_income_expenditure_managements_ibfk_1

buy_report_income_expenditure_managements.buy_report_id

Cascade on delete

floors_ibfk_1

floors.building_unit_id

building_units.id

Restrict delete

building_units_ibfk_1

building_units.building_id

Restrict delete

financial_records_ibfk_1

financial_records.year_id

Cascade on delete

item_budgets_ibfk_1

item_budgets.festival_item_id

festival_items.id

Cascade on delete

income_income_expenditure_managements_ibfk_1

income_income_expenditure_managements.income_expenditure_id

income_expenditure_managements.id

Cascade on delete

income_income_expenditure_managements_ibfk_2

income_income_expenditure_managements.income_id

Cascade on delete

buy_statuses_ibfk_1

buy_statuses.buy_report_id

Cascade on delete

rooms_ibfk_1

rooms.floor_id

Restrict delete

spot_sponsor_names_ibfk_1

spot_sponsor_names.income_expenditure_id

income_expenditure_managements.id

Cascade on delete

income_expenditure_managements_ibfk_1

income_expenditure_managements.year_id

Cascade on delete

room_teachers_ibfk_2

room_teachers.teacher_id

Cascade on delete

room_teachers_ibfk_1

room_teachers.room_id

Cascade on delete

buy_reports_ibfk_1

buy_reports.festival_item_id

festival_items.id

Cascade on delete

sponsor_activity_balance_managements_ibfk_1

sponsor_activity_balance_managements.sponsor_activity_id

Cascade on delete

sponsor_activity_balance_managements_ibfk_2

sponsor_activity_balance_managements.income_expenditure_management_id

income_expenditure_managements.id

Cascade on delete

payment_receipts_ibfk_1

payment_receipts.buy_report_id

Cascade on delete

Check Constraints

Table	Constraint Name	Constraint