251 Foreign Key Constraints
Constraint Name | Child Column | Parent Column | Delete Rule | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
adm_std_language_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
adm_std_language_language_code_fkey |
|
|
Restrict delete | ||||||||||||
std_term_section_enrolment_reason_code_fkey |
|
|
Restrict delete | ||||||||||||
std_term_section_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
std_term_section_enrolment_status_code_fkey |
|
|
Restrict delete | ||||||||||||
std_term_section_term_id_fkey |
|
|
Restrict delete | ||||||||||||
std_term_section_term_id_fkey1 |
|
|
Restrict delete | ||||||||||||
adm_std_email_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
uw_room_unit_code_fkey |
|
|
Restrict delete | ||||||||||||
uw_room_building_id_fkey |
|
|
Restrict delete | ||||||||||||
uw_room_facility_type_code_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_appl_last_school_org_id_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_appl_application_method_fkey |
|
|
Restrict delete | ||||||||||||
off_instruct_section_instructor_term_id_fkey |
|
|
Restrict delete | ||||||||||||
uw_building_building_id_fkey |
|
|
Restrict delete | ||||||||||||
std_student_gender_code_fkey |
|
|
Restrict delete | ||||||||||||
off_course_section_term_id_fkey4 |
|
|
Restrict delete | ||||||||||||
off_course_section_term_id_fkey2 |
|
|
Restrict delete | ||||||||||||
off_course_section_term_id_fkey3 |
|
|
Restrict delete | ||||||||||||
off_course_section_term_id_fkey1 |
|
|
Restrict delete | ||||||||||||
off_course_section_term_id_fkey |
|
|
Restrict delete | ||||||||||||
off_course_section_component_code_fkey |
|
|
Restrict delete | ||||||||||||
uw_country_citizenship_citizenship_code_fkey |
|
|
Restrict delete | ||||||||||||
uw_country_citizenship_country_code_fkey |
|
|
Restrict delete | ||||||||||||
off_course_section_reserve_requisite_id_fkey |
|
|
Restrict delete | ||||||||||||
off_course_section_reserve_term_id_fkey |
|
|
Restrict delete | ||||||||||||
off_default_note_note_id_fkey |
|
|
Restrict delete | ||||||||||||
std_service_indicator_active_term_fkey |
|
|
Restrict delete | ||||||||||||
std_service_indicator_service_indicator_code_fkey |
|
|
Restrict delete | ||||||||||||
std_service_indicator_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
std_degree_honour_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_program_history_admit_term_id_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_program_history_program_action_code_fkey1 |
|
|
Restrict delete | ||||||||||||
adm_appl_program_history_program_code_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_program_history_program_status_code_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_program_history_program_action_code_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_program_history_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_program_history_campus_code_fkey |
|
|
Restrict delete | ||||||||||||
adm_std_test_test_component_code_fkey |
|
|
Restrict delete | ||||||||||||
adm_std_test_test_type_code_fkey |
|
|
Restrict delete | ||||||||||||
adm_std_test_test_source_code_fkey |
|
|
Restrict delete | ||||||||||||
adm_std_test_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
adm_std_test_ext_academic_level_code_fkey |
|
|
Restrict delete | ||||||||||||
std_subplan_history_requirement_term_id_fkey |
|
|
Restrict delete | ||||||||||||
std_subplan_history_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
adm_std_academic_gpa_ext_gpa_type_code_fkey |
|
|
Restrict delete | ||||||||||||
adm_std_academic_gpa_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
adm_std_academic_ext_org_id_fkey |
|
|
Restrict delete | ||||||||||||
adm_std_academic_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
std_term_subplan_gpa_plan_code_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_study_agreement_ext_org_id_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_study_agreement_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_study_agreement_term_id_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_study_agreement_study_agreement_code_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_study_agreement_country_code_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_referee_referee_country_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_referee_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
off_association_term_id_fkey |
|
|
Restrict delete | ||||||||||||
off_association_component_code_fkey |
|
|
Restrict delete | ||||||||||||
off_association_primary_component_code_fkey |
|
|
Restrict delete | ||||||||||||
off_association_grading_basis_code_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_plan_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_plan_plan_code_fkey |
|
|
Restrict delete | ||||||||||||
uw_unit_campus_code_fkey |
|
|
Restrict delete | ||||||||||||
uw_unit_unit_code_fkey |
|
|
Restrict delete | ||||||||||||
uw_unit_group_code_fkey |
|
|
Restrict delete | ||||||||||||
pps_service_indicator_reason_service_indicator_code_fkey |
|
|
Restrict delete | ||||||||||||
off_course_section_note_term_id_fkey |
|
|
Restrict delete | ||||||||||||
off_course_section_note_note_id_fkey |
|
|
Restrict delete | ||||||||||||
std_plan_history_plan_code_fkey |
|
|
Restrict delete | ||||||||||||
std_plan_history_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
std_plan_history_requirement_term_id_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_program_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_program_admit_term_id_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_program_program_code_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_program_program_status_code_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_program_campus_code_fkey |
|
|
Restrict delete | ||||||||||||
pps_service_indicator_impact_service_indicator_code_fkey |
|
|
Restrict delete | ||||||||||||
std_term_course_demand_campus_code_fkey |
|
|
Restrict delete | ||||||||||||
std_term_course_demand_term_id_fkey |
|
|
Restrict delete | ||||||||||||
std_term_course_demand_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
std_term_course_demand_location_code_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_program_financial_aid_history_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_program_financial_aid_history_aid_status_code_fkey |
|
|
Restrict delete | ||||||||||||
off_course_as_of_term_id_fkey |
|
|
Restrict delete | ||||||||||||
off_course_as_of_course_id_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_condition_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_condition_condition_code_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_condition_condition_status_code_fkey |
|
|
Restrict delete | ||||||||||||
update_run_notification_process_code_fkey |
|
|
Restrict delete | ||||||||||||
update_run_notification_run_id_fkey |
|
|
Restrict delete | ||||||||||||
uw_program_reason_program_action_code_fkey |
|
|
Restrict delete | ||||||||||||
uw_date_term_id_fkey |
|
|
Restrict delete | ||||||||||||
uw_date_holiday_code_fkey |
|
|
Restrict delete | ||||||||||||
std_transfer_credit_detail_uw_id_fkey1 |
|
|
Restrict delete | ||||||||||||
std_transfer_credit_detail_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
std_transfer_credit_detail_course_id_fkey |
|
|
Restrict delete | ||||||||||||
std_transfer_credit_detail_grading_basis_code_fkey |
|
|
Restrict delete | ||||||||||||
std_term_coop_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
std_citizenship_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
std_citizenship_country_code_fkey |
|
|
Restrict delete | ||||||||||||
std_citizenship_country_code_fkey1 |
|
|
Restrict delete | ||||||||||||
adm_appl_program_evaluation_cmp_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
std_milestone_milestone_code_fkey |
|
|
Restrict delete | ||||||||||||
std_milestone_program_code_fkey |
|
|
Restrict delete | ||||||||||||
std_milestone_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
std_milestone_plan_code_fkey |
|
|
Restrict delete | ||||||||||||
std_term_course_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
std_term_course_grading_basis_code_fkey |
|
|
Restrict delete | ||||||||||||
std_term_course_term_id_fkey |
|
|
Restrict delete | ||||||||||||
cal_course_course_id_fkey |
|
|
Restrict delete | ||||||||||||
cal_course_label_history_campus_code_fkey |
|
|
Restrict delete | ||||||||||||
cal_course_label_history_group_code_fkey |
|
|
Restrict delete | ||||||||||||
cal_course_label_history_unit_code_fkey |
|
|
Restrict delete | ||||||||||||
cal_course_label_history_course_id_fkey1 |
|
|
Restrict delete | ||||||||||||
cal_course_label_history_subject_code_fkey |
|
|
Restrict delete | ||||||||||||
cal_course_label_history_course_id_fkey |
|
|
Restrict delete | ||||||||||||
cal_course_label_history_requisite_id_fkey |
|
|
Restrict delete | ||||||||||||
pps_degree_degree_code_fkey |
|
|
Restrict delete | ||||||||||||
pps_subplan_history_last_admit_term_id_fkey |
|
|
Restrict delete | ||||||||||||
pps_subplan_history_subplan_type_fkey |
|
|
Restrict delete | ||||||||||||
pps_subplan_history_plan_code_fkey |
|
|
Restrict delete | ||||||||||||
pps_subplan_history_first_valid_term_id_fkey |
|
|
Restrict delete | ||||||||||||
std_term_program_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
std_term_program_requirement_term_id_fkey |
|
|
Restrict delete | ||||||||||||
std_term_program_campus_code_fkey |
|
|
Restrict delete | ||||||||||||
std_term_program_completion_term_id_fkey |
|
|
Restrict delete | ||||||||||||
std_term_program_program_code_fkey |
|
|
Restrict delete | ||||||||||||
std_term_program_program_status_code_fkey |
|
|
Restrict delete | ||||||||||||
std_term_program_expected_grad_term_id_fkey |
|
|
Restrict delete | ||||||||||||
std_term_program_admit_term_id_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_subplan_plan_code_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_subplan_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
uw_location_country_code_fkey |
|
|
Restrict delete | ||||||||||||
uw_location_location_code_fkey |
|
|
Restrict delete | ||||||||||||
std_term_plan_plan_code_fkey |
|
|
Restrict delete | ||||||||||||
std_term_plan_requirement_term_id_fkey |
|
|
Restrict delete | ||||||||||||
std_term_plan_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
uw_campus_history_location_code_fkey |
|
|
Restrict delete | ||||||||||||
std_program_history_program_status_code_fkey |
|
|
Restrict delete | ||||||||||||
std_program_history_program_action_code_fkey |
|
|
Restrict delete | ||||||||||||
std_program_history_program_action_code_fkey1 |
|
|
Restrict delete | ||||||||||||
std_program_history_admit_term_id_fkey |
|
|
Restrict delete | ||||||||||||
std_program_history_expected_grad_term_id_fkey |
|
|
Restrict delete | ||||||||||||
std_program_history_program_code_fkey |
|
|
Restrict delete | ||||||||||||
std_program_history_requirement_term_id_fkey |
|
|
Restrict delete | ||||||||||||
std_program_history_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
std_program_history_completion_term_id_fkey |
|
|
Restrict delete | ||||||||||||
std_program_history_campus_code_fkey |
|
|
Restrict delete | ||||||||||||
std_term_plan_gpa_plan_code_fkey |
|
|
Restrict delete | ||||||||||||
adm_std_employment_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
adm_std_employment_country_code_fkey |
|
|
Restrict delete | ||||||||||||
uw_campus_campus_code_fkey |
|
|
Restrict delete | ||||||||||||
uw_campus_location_code_fkey |
|
|
Restrict delete | ||||||||||||
cal_course_topic_history_course_id_fkey |
|
|
Restrict delete | ||||||||||||
std_degree_subplan_plan_code_fkey |
|
|
Restrict delete | ||||||||||||
std_degree_subplan_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
std_transfer_credit_school_plan_code_fkey |
|
|
Restrict delete | ||||||||||||
std_transfer_credit_school_program_code_fkey |
|
|
Restrict delete | ||||||||||||
std_transfer_credit_school_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
off_instruct_section_meet_facility_id_fkey |
|
|
Restrict delete | ||||||||||||
off_instruct_section_meet_term_id_fkey |
|
|
Restrict delete | ||||||||||||
pps_standing_standing_status_code_fkey |
|
|
Restrict delete | ||||||||||||
off_instruct_section_campus_code_fkey |
|
|
Restrict delete | ||||||||||||
off_instruct_section_term_id_fkey |
|
|
Restrict delete | ||||||||||||
off_instruct_section_location_code_fkey |
|
|
Restrict delete | ||||||||||||
cal_subject_subject_code_fkey |
|
|
Restrict delete | ||||||||||||
cal_subject_unit_code_fkey |
|
|
Restrict delete | ||||||||||||
pps_plan_type_mtcu_level_code_fkey |
|
|
Restrict delete | ||||||||||||
pps_plan_type_degree_level_code_fkey |
|
|
Restrict delete | ||||||||||||
pps_plan_type_qualification_type_code_fkey |
|
|
Restrict delete | ||||||||||||
pps_plan_type_program_type_code_fkey |
|
|
Restrict delete | ||||||||||||
uw_group_group_code_fkey |
|
|
Restrict delete | ||||||||||||
cal_course_component_component_code_fkey |
|
|
Restrict delete | ||||||||||||
cal_course_component_course_id_fkey |
|
|
Restrict delete | ||||||||||||
cal_requisite_requisite_id_fkey |
|
|
Restrict delete | ||||||||||||
std_name_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
uw_unit_history_campus_code_fkey |
|
|
Restrict delete | ||||||||||||
uw_unit_history_group_code_fkey |
|
|
Restrict delete | ||||||||||||
cal_subject_history_unit_code_fkey |
|
|
Restrict delete | ||||||||||||
std_term_units_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
uw_location_history_country_code_fkey |
|
|
Restrict delete | ||||||||||||
adm_std_academic_degree_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
adm_std_academic_degree_degree_status_code_fkey |
|
|
Restrict delete | ||||||||||||
adm_std_academic_degree_degree_code_fkey |
|
|
Restrict delete | ||||||||||||
adm_std_academic_attendance_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
adm_std_academic_attendance_ext_career_code_fkey |
|
|
Restrict delete | ||||||||||||
pps_plan_unit_code_fkey |
|
|
Restrict delete | ||||||||||||
pps_plan_last_admit_term_id_fkey |
|
|
Restrict delete | ||||||||||||
pps_plan_program_code_fkey |
|
|
Restrict delete | ||||||||||||
pps_plan_first_valid_term_id_fkey |
|
|
Restrict delete | ||||||||||||
pps_plan_plan_code_fkey |
|
|
Restrict delete | ||||||||||||
pps_plan_plan_type_code_fkey |
|
|
Restrict delete | ||||||||||||
pps_plan_degree_code_fkey |
|
|
Restrict delete | ||||||||||||
std_address_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
std_address_address_type_code_fkey |
|
|
Restrict delete | ||||||||||||
std_term_standing_program_code_fkey |
|
|
Restrict delete | ||||||||||||
std_term_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
std_term_study_agreement_code_fkey |
|
|
Restrict delete | ||||||||||||
std_term_standing_status_code_fkey |
|
|
Restrict delete | ||||||||||||
std_term_term_id_fkey |
|
|
Restrict delete | ||||||||||||
std_term_coop_term_type_code_fkey |
|
|
Restrict delete | ||||||||||||
std_term_coop_workterm_status_code_fkey |
|
|
Restrict delete | ||||||||||||
std_term_form_of_study_code_fkey |
|
|
Restrict delete | ||||||||||||
std_term_standing_code_fkey |
|
|
Restrict delete | ||||||||||||
adm_std_academic_course_ext_term_code_fkey |
|
|
Restrict delete | ||||||||||||
adm_std_academic_course_grading_basis_code_fkey |
|
|
Restrict delete | ||||||||||||
adm_std_academic_course_ext_subject_code_fkey |
|
|
Restrict delete | ||||||||||||
adm_std_academic_course_ext_academic_level_code_fkey |
|
|
Restrict delete | ||||||||||||
adm_std_academic_course_ext_course_type_code_fkey |
|
|
Restrict delete | ||||||||||||
adm_std_academic_course_ext_term_type_code_fkey |
|
|
Restrict delete | ||||||||||||
adm_std_academic_course_course_level_code_fkey |
|
|
Restrict delete | ||||||||||||
uw_ext_org_country_code_fkey |
|
|
Restrict delete | ||||||||||||
std_term_subplan_requirement_term_id_fkey |
|
|
Restrict delete | ||||||||||||
std_term_subplan_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
pps_program_history_first_valid_term_id_fkey |
|
|
Restrict delete | ||||||||||||
pps_program_history_unit_code_fkey |
|
|
Restrict delete | ||||||||||||
pps_program_history_group_code_fkey |
|
|
Restrict delete | ||||||||||||
std_term_award_award_code_fkey |
|
|
Restrict delete | ||||||||||||
std_term_award_term_id_fkey |
|
|
Restrict delete | ||||||||||||
std_term_award_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
std_grad_supervisor_plan_code_fkey |
|
|
Restrict delete | ||||||||||||
std_grad_supervisor_supervisor_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
std_grad_supervisor_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
std_grad_supervisor_program_code_fkey |
|
|
Restrict delete | ||||||||||||
update_notification_run_id_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_program_comment_adm_comment_code_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_program_comment_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
std_phone_phone_type_code_fkey |
|
|
Restrict delete | ||||||||||||
std_phone_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
std_degree_degree_code_fkey |
|
|
Restrict delete | ||||||||||||
std_degree_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
std_degree_completion_term_id_fkey |
|
|
Restrict delete | ||||||||||||
std_degree_plan_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
std_degree_plan_plan_code_fkey |
|
|
Restrict delete | ||||||||||||
adm_appl_program_evaluation_uw_id_fkey |
|
|
Restrict delete | ||||||||||||
pps_plan_history_program_code_fkey |
|
|
Restrict delete | ||||||||||||
pps_plan_history_degree_code_fkey |
|
|
Restrict delete | ||||||||||||
pps_plan_history_last_admit_term_id_fkey |
|
|
Restrict delete | ||||||||||||
pps_plan_history_unit_code_fkey |
|
|
Restrict delete | ||||||||||||
pps_plan_history_first_valid_term_id_fkey |
|
|
Restrict delete | ||||||||||||
pps_plan_history_plan_type_code_fkey |
|
|
Restrict delete | ||||||||||||
pps_program_program_code_fkey |
|
|
Restrict delete | ||||||||||||
pps_program_first_valid_term_id_fkey |
|
|
Restrict delete | ||||||||||||
pps_program_group_code_fkey |
|
|
Restrict delete | ||||||||||||
pps_program_unit_code_fkey |
|
|
Restrict delete | ||||||||||||
pps_subplan_subplan_type_fkey |
|
|
Restrict delete | ||||||||||||
pps_subplan_plan_code_fkey |
|
|
Restrict delete | ||||||||||||
pps_subplan_last_admit_term_id_fkey |
|
|
Restrict delete | ||||||||||||
pps_subplan_first_valid_term_id_fkey |
|
|
Restrict delete |
Check Constraints
Table | Constraint Name | Constraint |
---|