Constraints

29 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

activity_sponsor_style_links_ibfk_2

activity_sponsor_style_links.sponsor_style_id

sponsor_styles.id

Cascade on delete

activity_sponsor_style_links_ibfk_1

activity_sponsor_style_links.sponsorship_activity_id

sponsorship_activities.id

Cascade on delete

divisions_ibfk_1

divisions.financial_record_id

financial_records.id

Cascade on delete

campus_donations_ibfk_3

campus_donations.teacher_id

Cascade on delete

campus_donations_ibfk_1

campus_donations.year_id

Cascade on delete

campus_donations_ibfk_2

campus_donations.user_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

financial_records_ibfk_1

financial_records.year_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

item_budgets_ibfk_1

item_budgets.festival_item_id

festival_items.id

Cascade on delete

sponsorship_activities_ibfk_1

sponsorship_activities.year_periods_id

year_periods.id

Cascade on delete

sponsorship_activities_ibfk_2

sponsorship_activities.sponsor_id

Cascade on delete

sponsorship_activities_ibfk_3

sponsorship_activities.user_id

Cascade on delete

buy_statuses_ibfk_1

buy_statuses.buy_report_id

Cascade on delete

rooms_building_id_foreign_key

rooms.building_id

Cascade on 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

paid_by_user_id_foreign_key

buy_reports.paid_by_user_id

Null 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