Constraints

251 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
adm_std_language_uw_id_fkey
adm_std_language.uw_id
std_student.uw_id
Restrict delete
adm_std_language_language_code_fkey
adm_std_language.language_code
iso_639_3_language.language_code
Restrict delete
std_term_section_enrolment_reason_code_fkey
std_term_section.enrolment_reason_code
uw_enrolment_reason.enrolment_reason_code
Restrict delete
std_term_section_uw_id_fkey
std_term_section.uw_id
std_term_section.term_id
std_term.uw_id
std_term.term_id
Restrict delete
std_term_section_enrolment_status_code_fkey
std_term_section.enrolment_status_code
uw_enrolment_status.enrolment_status_code
Restrict delete
std_term_section_term_id_fkey
std_term_section.term_id
std_term_section.class_id
off_course_section.term_id
off_course_section.class_id
Restrict delete
std_term_section_term_id_fkey1
std_term_section.term_id
std_term_section.class_id
std_term_section.reserve_id
off_course_section_reserve.term_id
off_course_section_reserve.class_id
off_course_section_reserve.reserve_id
Restrict delete
adm_std_email_uw_id_fkey
adm_std_email.uw_id
std_student.uw_id
Restrict delete
uw_room_unit_code_fkey
uw_room.unit_code
uw_unit.unit_code
Restrict delete
uw_room_building_id_fkey
uw_room.building_id
uw_building.building_id
Restrict delete
uw_room_facility_type_code_fkey
uw_room.facility_type_code
uw_facility_type.facility_type_code
Restrict delete
adm_appl_uw_id_fkey
adm_appl.uw_id
std_student.uw_id
Restrict delete
adm_appl_appl_last_school_org_id_fkey
adm_appl.appl_last_school_org_id
uw_ext_org.ext_org_id
Restrict delete
adm_appl_appl_application_method_fkey
adm_appl.appl_application_method
uw_appl_method.appl_method_code
Restrict delete
off_instruct_section_instructor_term_id_fkey
off_instruct_section_instructor.term_id
off_instruct_section_instructor.section_id
off_instruct_section.term_id
off_instruct_section.section_id
Restrict delete
uw_building_building_id_fkey
uw_building.building_id
uw_building.building_as_of
uw_building_history.building_id
uw_building_history.building_as_of
Restrict delete
std_student_gender_code_fkey
std_student.gender_code
uw_gender.gender_code
Restrict delete
off_course_section_term_id_fkey4
off_course_section.term_id
off_course_section.section_id
off_instruct_section.term_id
off_instruct_section.section_id
Restrict delete
off_course_section_term_id_fkey2
off_course_section.term_id
off_course_section.course_id
off_course_section.label_seq
off_course_section.session_code
off_course_section.auto_enroll_1_section_code
off_course_section.term_id
off_course_section.course_id
off_course_section.label_seq
off_course_section.session_code
off_course_section.section_code
Restrict delete
off_course_section_term_id_fkey3
off_course_section.term_id
off_course_section.course_id
off_course_section.label_seq
off_course_section.session_code
off_course_section.auto_enroll_2_section_code
off_course_section.term_id
off_course_section.course_id
off_course_section.label_seq
off_course_section.session_code
off_course_section.section_code
Restrict delete
off_course_section_term_id_fkey1
off_course_section.term_id
off_course_section.course_id
off_course_section.label_seq
off_course_section.session_code
off_course_section.association_id
off_association.term_id
off_association.course_id
off_association.label_seq
off_association.session_code
off_association.association_id
Restrict delete
off_course_section_term_id_fkey
off_course_section.term_id
off_course_section.course_id
off_course_as_of.term_id
off_course_as_of.course_id
Restrict delete
off_course_section_component_code_fkey
off_course_section.component_code
cal_component.component_code
Restrict delete
uw_country_citizenship_citizenship_code_fkey
uw_country_citizenship.citizenship_code
uw_citizenship.citizenship_code
Restrict delete
uw_country_citizenship_country_code_fkey
uw_country_citizenship.country_code
uw_country.country_code
Restrict delete
off_course_section_reserve_requisite_id_fkey
off_course_section_reserve.requisite_id
cal_requisite.requisite_id
Restrict delete
off_course_section_reserve_term_id_fkey
off_course_section_reserve.term_id
off_course_section_reserve.class_id
off_course_section.term_id
off_course_section.class_id
Restrict delete
off_default_note_note_id_fkey
off_default_note.note_id
off_default_note.note_as_of
off_default_note_history.note_id
off_default_note_history.note_as_of
Restrict delete
std_service_indicator_active_term_fkey
std_service_indicator.active_term
uw_term.term_id
Restrict delete
std_service_indicator_service_indicator_code_fkey
std_service_indicator.service_indicator_code
std_service_indicator.service_indicator_reason
pps_service_indicator_reason.service_indicator_code
pps_service_indicator_reason.service_indicator_reason
Restrict delete
std_service_indicator_uw_id_fkey
std_service_indicator.uw_id
std_student.uw_id
Restrict delete
std_degree_honour_uw_id_fkey
std_degree_honour.uw_id
std_degree_honour.degree_id
std_degree.uw_id
std_degree.degree_id
Restrict delete
adm_appl_program_history_admit_term_id_fkey
adm_appl_program_history.admit_term_id
uw_term.term_id
Restrict delete
adm_appl_program_history_program_action_code_fkey1
adm_appl_program_history.program_action_code
adm_appl_program_history.program_reason_code
uw_program_reason.program_action_code
uw_program_reason.program_reason_code
Restrict delete
adm_appl_program_history_program_code_fkey
adm_appl_program_history.program_code
pps_program.program_code
Restrict delete
adm_appl_program_history_program_status_code_fkey
adm_appl_program_history.program_status_code
uw_program_status.program_status_code
Restrict delete
adm_appl_program_history_program_action_code_fkey
adm_appl_program_history.program_action_code
uw_program_action.program_action_code
Restrict delete
adm_appl_program_history_uw_id_fkey
adm_appl_program_history.uw_id
adm_appl_program_history.appl_id
adm_appl_program_history.program_order
adm_appl_program.uw_id
adm_appl_program.appl_id
adm_appl_program.program_order
Restrict delete
adm_appl_program_history_campus_code_fkey
adm_appl_program_history.campus_code
uw_campus.campus_code
Restrict delete
adm_std_test_test_component_code_fkey
adm_std_test.test_component_code
uw_test_component.test_component_code
Restrict delete
adm_std_test_test_type_code_fkey
adm_std_test.test_type_code
uw_test_type.test_type_code
Restrict delete
adm_std_test_test_source_code_fkey
adm_std_test.test_source_code
uw_test_source.test_source_code
Restrict delete
adm_std_test_uw_id_fkey
adm_std_test.uw_id
std_student.uw_id
Restrict delete
adm_std_test_ext_academic_level_code_fkey
adm_std_test.ext_academic_level_code
uw_ext_academic_level.ext_academic_level_code
Restrict delete
std_subplan_history_requirement_term_id_fkey
std_subplan_history.requirement_term_id
uw_term.term_id
Restrict delete
std_subplan_history_uw_id_fkey
std_subplan_history.uw_id
std_subplan_history.career_code
std_subplan_history.career_num
std_subplan_history.program_as_of
std_subplan_history.program_sequence
std_subplan_history.plan_code
std_plan_history.uw_id
std_plan_history.career_code
std_plan_history.career_num
std_plan_history.program_as_of
std_plan_history.program_sequence
std_plan_history.plan_code
Restrict delete
adm_std_academic_gpa_ext_gpa_type_code_fkey
adm_std_academic_gpa.ext_gpa_type_code
uw_ext_gpa_type.ext_gpa_type_code
Restrict delete
adm_std_academic_gpa_uw_id_fkey
adm_std_academic_gpa.uw_id
adm_std_academic_gpa.ext_org_id
adm_std_academic_gpa.ext_career_code
adm_std_academic_gpa.ext_career_seq
adm_std_academic_attendance.uw_id
adm_std_academic_attendance.ext_org_id
adm_std_academic_attendance.ext_career_code
adm_std_academic_attendance.ext_career_seq
Restrict delete
adm_std_academic_ext_org_id_fkey
adm_std_academic.ext_org_id
uw_ext_org.ext_org_id
Restrict delete
adm_std_academic_uw_id_fkey
adm_std_academic.uw_id
std_student.uw_id
Restrict delete
std_term_subplan_gpa_plan_code_fkey
std_term_subplan_gpa.plan_code
std_term_subplan_gpa.subplan_code
pps_subplan.plan_code
pps_subplan.subplan_code
Restrict delete
adm_appl_study_agreement_ext_org_id_fkey
adm_appl_study_agreement.ext_org_id
uw_ext_org.ext_org_id
Restrict delete
adm_appl_study_agreement_uw_id_fkey
adm_appl_study_agreement.uw_id
adm_appl_study_agreement.appl_id
adm_appl.uw_id
adm_appl.appl_id
Restrict delete
adm_appl_study_agreement_term_id_fkey
adm_appl_study_agreement.term_id
uw_term.term_id
Restrict delete
adm_appl_study_agreement_study_agreement_code_fkey
adm_appl_study_agreement.study_agreement_code
uw_study_agreement.study_agreement_code
Restrict delete
adm_appl_study_agreement_country_code_fkey
adm_appl_study_agreement.country_code
uw_country.country_code
Restrict delete
adm_appl_referee_referee_country_fkey
adm_appl_referee.referee_country
uw_country.country_code
Restrict delete
adm_appl_referee_uw_id_fkey
adm_appl_referee.uw_id
adm_appl_referee.appl_id
adm_appl.uw_id
adm_appl.appl_id
Restrict delete
off_association_term_id_fkey
off_association.term_id
off_association.course_id
off_course_as_of.term_id
off_course_as_of.course_id
Restrict delete
off_association_component_code_fkey
off_association.component_code
cal_component.component_code
Restrict delete
off_association_primary_component_code_fkey
off_association.primary_component_code
cal_component.component_code
Restrict delete
off_association_grading_basis_code_fkey
off_association.grading_basis_code
uw_grading_basis.grading_basis_code
Restrict delete
adm_appl_plan_uw_id_fkey
adm_appl_plan.uw_id
adm_appl_plan.appl_id
adm_appl_plan.program_order
adm_appl_plan.program_as_of
adm_appl_plan.program_sequence
adm_appl_program_history.uw_id
adm_appl_program_history.appl_id
adm_appl_program_history.program_order
adm_appl_program_history.program_as_of
adm_appl_program_history.program_sequence
Restrict delete
adm_appl_plan_plan_code_fkey
adm_appl_plan.plan_code
pps_plan.plan_code
Restrict delete
uw_unit_campus_code_fkey
uw_unit.campus_code
uw_campus.campus_code
Restrict delete
uw_unit_unit_code_fkey
uw_unit.unit_code
uw_unit.unit_as_of
uw_unit_history.unit_code
uw_unit_history.unit_as_of
Restrict delete
uw_unit_group_code_fkey
uw_unit.group_code
uw_group.group_code
Restrict delete
pps_service_indicator_reason_service_indicator_code_fkey
pps_service_indicator_reason.service_indicator_code
pps_service_indicator.service_indicator_code
Restrict delete
off_course_section_note_term_id_fkey
off_course_section_note.term_id
off_course_section_note.class_id
off_course_section.term_id
off_course_section.class_id
Restrict delete
off_course_section_note_note_id_fkey
off_course_section_note.note_id
off_default_note.note_id
Restrict delete
std_plan_history_plan_code_fkey
std_plan_history.plan_code
pps_plan.plan_code
Restrict delete
std_plan_history_uw_id_fkey
std_plan_history.uw_id
std_plan_history.career_code
std_plan_history.career_num
std_plan_history.program_as_of
std_plan_history.program_sequence
std_program_history.uw_id
std_program_history.career_code
std_program_history.career_num
std_program_history.program_as_of
std_program_history.program_sequence
Restrict delete
std_plan_history_requirement_term_id_fkey
std_plan_history.requirement_term_id
uw_term.term_id
Restrict delete
adm_appl_program_uw_id_fkey
adm_appl_program.uw_id
adm_appl_program.appl_id
adm_appl.uw_id
adm_appl.appl_id
Restrict delete
adm_appl_program_admit_term_id_fkey
adm_appl_program.admit_term_id
uw_term.term_id
Restrict delete
adm_appl_program_program_code_fkey
adm_appl_program.program_code
pps_program.program_code
Restrict delete
adm_appl_program_program_status_code_fkey
adm_appl_program.program_status_code
uw_program_status.program_status_code
Restrict delete
adm_appl_program_campus_code_fkey
adm_appl_program.campus_code
uw_campus.campus_code
Restrict delete
pps_service_indicator_impact_service_indicator_code_fkey
pps_service_indicator_impact.service_indicator_code
pps_service_indicator.service_indicator_code
Restrict delete
std_term_course_demand_campus_code_fkey
std_term_course_demand.campus_code
uw_campus.campus_code
Restrict delete
std_term_course_demand_term_id_fkey
std_term_course_demand.term_id
std_term_course_demand.class_id
off_course_section.term_id
off_course_section.class_id
Restrict delete
std_term_course_demand_uw_id_fkey
std_term_course_demand.uw_id
std_student.uw_id
Restrict delete
std_term_course_demand_location_code_fkey
std_term_course_demand.location_code
uw_location.location_code
Restrict delete
adm_appl_program_financial_aid_history_uw_id_fkey
adm_appl_program_financial_aid_history.uw_id
adm_appl_program_financial_aid_history.appl_id
adm_appl_program_financial_aid_history.program_order
adm_appl_program.uw_id
adm_appl_program.appl_id
adm_appl_program.program_order
Restrict delete
adm_appl_program_financial_aid_history_aid_status_code_fkey
adm_appl_program_financial_aid_history.aid_status_code
uw_aid_status.aid_status_code
Restrict delete
off_course_as_of_term_id_fkey
off_course_as_of.term_id
uw_term.term_id
Restrict delete
off_course_as_of_course_id_fkey
off_course_as_of.course_id
off_course_as_of.course_as_of
cal_course_history.course_id
cal_course_history.course_as_of
Restrict delete
adm_appl_condition_uw_id_fkey
adm_appl_condition.uw_id
adm_appl_condition.appl_id
adm_appl.uw_id
adm_appl.appl_id
Restrict delete
adm_appl_condition_condition_code_fkey
adm_appl_condition.condition_code
uw_condition.condition_code
Restrict delete
adm_appl_condition_condition_status_code_fkey
adm_appl_condition.condition_status_code
uw_condition_status.condition_status_code
Restrict delete
update_run_notification_process_code_fkey
update_run_notification.process_code
update_process.process_code
Restrict delete
update_run_notification_run_id_fkey
update_run_notification.run_id
update_run.run_id
Restrict delete
uw_program_reason_program_action_code_fkey
uw_program_reason.program_action_code
uw_program_action.program_action_code
Restrict delete
uw_date_term_id_fkey
uw_date.term_id
uw_term.term_id
Restrict delete
uw_date_holiday_code_fkey
uw_date.holiday_code
uw_holiday_type.holiday_code
Restrict delete
std_transfer_credit_detail_uw_id_fkey1
std_transfer_credit_detail.uw_id
std_transfer_credit_detail.term_id
std_term.uw_id
std_term.term_id
Restrict delete
std_transfer_credit_detail_uw_id_fkey
std_transfer_credit_detail.uw_id
std_transfer_credit_detail.career_code
std_transfer_credit_detail.transfer_group
std_transfer_credit_school.uw_id
std_transfer_credit_school.career_code
std_transfer_credit_school.transfer_group
Restrict delete
std_transfer_credit_detail_course_id_fkey
std_transfer_credit_detail.course_id
cal_course.course_id
Restrict delete
std_transfer_credit_detail_grading_basis_code_fkey
std_transfer_credit_detail.grading_basis_code
uw_grading_basis.grading_basis_code
Restrict delete
std_term_coop_uw_id_fkey
std_term_coop.uw_id
std_student.uw_id
Restrict delete
std_citizenship_uw_id_fkey
std_citizenship.uw_id
std_student.uw_id
Restrict delete
std_citizenship_country_code_fkey
std_citizenship.country_code
uw_country.country_code
Restrict delete
std_citizenship_country_code_fkey1
std_citizenship.country_code
std_citizenship.citizenship_code
uw_country_citizenship.country_code
uw_country_citizenship.citizenship_code
Restrict delete
adm_appl_program_evaluation_cmp_uw_id_fkey
adm_appl_program_evaluation_cmp.uw_id
adm_appl_program_evaluation_cmp.appl_id
adm_appl_program_evaluation_cmp.program_order
adm_appl_program_evaluation_cmp.evaluation_code
adm_appl_program_evaluation_cmp.evaluation_num
adm_appl_program_evaluation.uw_id
adm_appl_program_evaluation.appl_id
adm_appl_program_evaluation.program_order
adm_appl_program_evaluation.evaluation_code
adm_appl_program_evaluation.evaluation_num
Restrict delete
std_milestone_milestone_code_fkey
std_milestone.milestone_code
pps_milestone.milestone_code
Restrict delete
std_milestone_program_code_fkey
std_milestone.program_code
pps_program.program_code
Restrict delete
std_milestone_uw_id_fkey
std_milestone.uw_id
std_student.uw_id
Restrict delete
std_milestone_plan_code_fkey
std_milestone.plan_code
pps_plan.plan_code
Restrict delete
std_term_course_uw_id_fkey
std_term_course.uw_id
std_term_course.term_id
std_term.uw_id
std_term.term_id
Restrict delete
std_term_course_grading_basis_code_fkey
std_term_course.grading_basis_code
uw_grading_basis.grading_basis_code
Restrict delete
std_term_course_term_id_fkey
std_term_course.term_id
std_term_course.class_id
off_course.term_id
off_course.class_id
Restrict delete
cal_course_course_id_fkey
cal_course.course_id
cal_course.course_as_of
cal_course_history.course_id
cal_course_history.course_as_of
Restrict delete
cal_course_label_history_campus_code_fkey
cal_course_label_history.campus_code
uw_campus.campus_code
Restrict delete
cal_course_label_history_group_code_fkey
cal_course_label_history.group_code
uw_group.group_code
Restrict delete
cal_course_label_history_unit_code_fkey
cal_course_label_history.unit_code
uw_unit.unit_code
Restrict delete
cal_course_label_history_course_id_fkey1
cal_course_label_history.course_id
cal_course_label_history.course_as_of
cal_course_history.course_id
cal_course_history.course_as_of
Restrict delete
cal_course_label_history_subject_code_fkey
cal_course_label_history.subject_code
cal_subject.subject_code
Restrict delete
cal_course_label_history_course_id_fkey
cal_course_label_history.course_id
cal_course.course_id
Restrict delete
cal_course_label_history_requisite_id_fkey
cal_course_label_history.requisite_id
cal_requisite.requisite_id
Restrict delete
pps_degree_degree_code_fkey
pps_degree.degree_code
pps_degree.degree_as_of
pps_degree_history.degree_code
pps_degree_history.degree_as_of
Restrict delete
pps_subplan_history_last_admit_term_id_fkey
pps_subplan_history.last_admit_term_id
uw_term.term_id
Restrict delete
pps_subplan_history_subplan_type_fkey
pps_subplan_history.subplan_type
pps_subplan_type.subplan_type_code
Restrict delete
pps_subplan_history_plan_code_fkey
pps_subplan_history.plan_code
pps_plan.plan_code
Restrict delete
pps_subplan_history_first_valid_term_id_fkey
pps_subplan_history.first_valid_term_id
uw_term.term_id
Restrict delete
std_term_program_uw_id_fkey
std_term_program.uw_id
std_term_program.term_id
std_term.uw_id
std_term.term_id
Restrict delete
std_term_program_requirement_term_id_fkey
std_term_program.requirement_term_id
uw_term.term_id
Restrict delete
std_term_program_campus_code_fkey
std_term_program.campus_code
uw_campus.campus_code
Restrict delete
std_term_program_completion_term_id_fkey
std_term_program.completion_term_id
uw_term.term_id
Restrict delete
std_term_program_program_code_fkey
std_term_program.program_code
pps_program.program_code
Restrict delete
std_term_program_program_status_code_fkey
std_term_program.program_status_code
uw_program_status.program_status_code
Restrict delete
std_term_program_expected_grad_term_id_fkey
std_term_program.expected_grad_term_id
uw_term.term_id
Restrict delete
std_term_program_admit_term_id_fkey
std_term_program.admit_term_id
uw_term.term_id
Restrict delete
adm_appl_subplan_plan_code_fkey
adm_appl_subplan.plan_code
adm_appl_subplan.subplan_code
pps_subplan.plan_code
pps_subplan.subplan_code
Restrict delete
adm_appl_subplan_uw_id_fkey
adm_appl_subplan.uw_id
adm_appl_subplan.appl_id
adm_appl_subplan.program_order
adm_appl_subplan.program_as_of
adm_appl_subplan.program_sequence
adm_appl_subplan.plan_code
adm_appl_plan.uw_id
adm_appl_plan.appl_id
adm_appl_plan.program_order
adm_appl_plan.program_as_of
adm_appl_plan.program_sequence
adm_appl_plan.plan_code
Restrict delete
uw_location_country_code_fkey
uw_location.country_code
uw_country.country_code
Restrict delete
uw_location_location_code_fkey
uw_location.location_code
uw_location.location_as_of
uw_location_history.location_code
uw_location_history.location_as_of
Restrict delete
std_term_plan_plan_code_fkey
std_term_plan.plan_code
pps_plan.plan_code
Restrict delete
std_term_plan_requirement_term_id_fkey
std_term_plan.requirement_term_id
uw_term.term_id
Restrict delete
std_term_plan_uw_id_fkey
std_term_plan.uw_id
std_term_plan.term_id
std_term_program.uw_id
std_term_program.term_id
Restrict delete
uw_campus_history_location_code_fkey
uw_campus_history.location_code
uw_location.location_code
Restrict delete
std_program_history_program_status_code_fkey
std_program_history.program_status_code
uw_program_status.program_status_code
Restrict delete
std_program_history_program_action_code_fkey
std_program_history.program_action_code
uw_program_action.program_action_code
Restrict delete
std_program_history_program_action_code_fkey1
std_program_history.program_action_code
std_program_history.program_reason_code
uw_program_reason.program_action_code
uw_program_reason.program_reason_code
Restrict delete
std_program_history_admit_term_id_fkey
std_program_history.admit_term_id
uw_term.term_id
Restrict delete
std_program_history_expected_grad_term_id_fkey
std_program_history.expected_grad_term_id
uw_term.term_id
Restrict delete
std_program_history_program_code_fkey
std_program_history.program_code
pps_program.program_code
Restrict delete
std_program_history_requirement_term_id_fkey
std_program_history.requirement_term_id
uw_term.term_id
Restrict delete
std_program_history_uw_id_fkey
std_program_history.uw_id
std_student.uw_id
Restrict delete
std_program_history_completion_term_id_fkey
std_program_history.completion_term_id
uw_term.term_id
Restrict delete
std_program_history_campus_code_fkey
std_program_history.campus_code
uw_campus.campus_code
Restrict delete
std_term_plan_gpa_plan_code_fkey
std_term_plan_gpa.plan_code
pps_plan.plan_code
Restrict delete
adm_std_employment_uw_id_fkey
adm_std_employment.uw_id
std_student.uw_id
Restrict delete
adm_std_employment_country_code_fkey
adm_std_employment.country_code
uw_country.country_code
Restrict delete
uw_campus_campus_code_fkey
uw_campus.campus_code
uw_campus.campus_as_of
uw_campus_history.campus_code
uw_campus_history.campus_as_of
Restrict delete
uw_campus_location_code_fkey
uw_campus.location_code
uw_location.location_code
Restrict delete
cal_course_topic_history_course_id_fkey
cal_course_topic_history.course_id
cal_course_topic_history.course_as_of
cal_course_history.course_id
cal_course_history.course_as_of
Restrict delete
std_degree_subplan_plan_code_fkey
std_degree_subplan.plan_code
std_degree_subplan.subplan_code
pps_subplan.plan_code
pps_subplan.subplan_code
Restrict delete
std_degree_subplan_uw_id_fkey
std_degree_subplan.uw_id
std_degree_subplan.degree_id
std_degree_subplan.plan_code
std_degree_plan.uw_id
std_degree_plan.degree_id
std_degree_plan.plan_code
Restrict delete
std_transfer_credit_school_plan_code_fkey
std_transfer_credit_school.plan_code
pps_plan.plan_code
Restrict delete
std_transfer_credit_school_program_code_fkey
std_transfer_credit_school.program_code
pps_program.program_code
Restrict delete
std_transfer_credit_school_uw_id_fkey
std_transfer_credit_school.uw_id
std_student.uw_id
Restrict delete
off_instruct_section_meet_facility_id_fkey
off_instruct_section_meet.facility_id
uw_room.facility_id
Restrict delete
off_instruct_section_meet_term_id_fkey
off_instruct_section_meet.term_id
off_instruct_section_meet.section_id
off_instruct_section.term_id
off_instruct_section.section_id
Restrict delete
pps_standing_standing_status_code_fkey
pps_standing.standing_status_code
pps_standing_status.standing_status_code
Restrict delete
off_instruct_section_campus_code_fkey
off_instruct_section.campus_code
uw_campus.campus_code
Restrict delete
off_instruct_section_term_id_fkey
off_instruct_section.term_id
uw_term.term_id
Restrict delete
off_instruct_section_location_code_fkey
off_instruct_section.location_code
uw_location.location_code
Restrict delete
cal_subject_subject_code_fkey
cal_subject.subject_code
cal_subject.subject_as_of
cal_subject_history.subject_code
cal_subject_history.subject_as_of
Restrict delete
cal_subject_unit_code_fkey
cal_subject.unit_code
uw_unit.unit_code
Restrict delete
pps_plan_type_mtcu_level_code_fkey
pps_plan_type.mtcu_level_code
pps_mtcu_level.mtcu_level_code
Restrict delete
pps_plan_type_degree_level_code_fkey
pps_plan_type.degree_level_code
pps_degree_level.degree_level_code
Restrict delete
pps_plan_type_qualification_type_code_fkey
pps_plan_type.qualification_type_code
pps_qualification_type.qualification_type_code
Restrict delete
pps_plan_type_program_type_code_fkey
pps_plan_type.program_type_code
pps_program_type.program_type_code
Restrict delete
uw_group_group_code_fkey
uw_group.group_code
uw_group.group_as_of
uw_group_history.group_code
uw_group_history.group_as_of
Restrict delete
cal_course_component_component_code_fkey
cal_course_component.component_code
cal_component.component_code
Restrict delete
cal_course_component_course_id_fkey
cal_course_component.course_id
cal_course_component.course_as_of
cal_course_history.course_id
cal_course_history.course_as_of
Restrict delete
cal_requisite_requisite_id_fkey
cal_requisite.requisite_id
cal_requisite.requisite_as_of
cal_requisite_history.requisite_id
cal_requisite_history.requisite_as_of
Restrict delete
std_name_uw_id_fkey
std_name.uw_id
std_student.uw_id
Restrict delete
uw_unit_history_campus_code_fkey
uw_unit_history.campus_code
uw_campus.campus_code
Restrict delete
uw_unit_history_group_code_fkey
uw_unit_history.group_code
uw_group.group_code
Restrict delete
cal_subject_history_unit_code_fkey
cal_subject_history.unit_code
uw_unit.unit_code
Restrict delete
std_term_units_uw_id_fkey
std_term_units.uw_id
std_term_units.term_id
std_term.uw_id
std_term.term_id
Restrict delete
uw_location_history_country_code_fkey
uw_location_history.country_code
uw_country.country_code
Restrict delete
adm_std_academic_degree_uw_id_fkey
adm_std_academic_degree.uw_id
adm_std_academic_degree.ext_org_id
adm_std_academic_degree.ext_career_code
adm_std_academic_degree.ext_career_seq
adm_std_academic_attendance.uw_id
adm_std_academic_attendance.ext_org_id
adm_std_academic_attendance.ext_career_code
adm_std_academic_attendance.ext_career_seq
Restrict delete
adm_std_academic_degree_degree_status_code_fkey
adm_std_academic_degree.degree_status_code
uw_ext_degree_status.degree_status_code
Restrict delete
adm_std_academic_degree_degree_code_fkey
adm_std_academic_degree.degree_code
pps_degree.degree_code
Restrict delete
adm_std_academic_attendance_uw_id_fkey
adm_std_academic_attendance.uw_id
adm_std_academic_attendance.ext_org_id
adm_std_academic.uw_id
adm_std_academic.ext_org_id
Restrict delete
adm_std_academic_attendance_ext_career_code_fkey
adm_std_academic_attendance.ext_career_code
uw_ext_career.ext_career_code
Restrict delete
pps_plan_unit_code_fkey
pps_plan.unit_code
uw_unit.unit_code
Restrict delete
pps_plan_last_admit_term_id_fkey
pps_plan.last_admit_term_id
uw_term.term_id
Restrict delete
pps_plan_program_code_fkey
pps_plan.program_code
pps_program.program_code
Restrict delete
pps_plan_first_valid_term_id_fkey
pps_plan.first_valid_term_id
uw_term.term_id
Restrict delete
pps_plan_plan_code_fkey
pps_plan.plan_code
pps_plan.plan_as_of
pps_plan_history.plan_code
pps_plan_history.plan_as_of
Restrict delete
pps_plan_plan_type_code_fkey
pps_plan.plan_type_code
pps_plan_type.plan_type_code
Restrict delete
pps_plan_degree_code_fkey
pps_plan.degree_code
pps_degree.degree_code
Restrict delete
std_address_uw_id_fkey
std_address.uw_id
std_student.uw_id
Restrict delete
std_address_address_type_code_fkey
std_address.address_type_code
uw_address_type.address_type_code
Restrict delete
std_term_standing_program_code_fkey
std_term.standing_program_code
pps_program.program_code
Restrict delete
std_term_uw_id_fkey
std_term.uw_id
std_student.uw_id
Restrict delete
std_term_study_agreement_code_fkey
std_term.study_agreement_code
uw_study_agreement.study_agreement_code
Restrict delete
std_term_standing_status_code_fkey
std_term.standing_status_code
pps_standing_status.standing_status_code
Restrict delete
std_term_term_id_fkey
std_term.term_id
uw_term.term_id
Restrict delete
std_term_coop_term_type_code_fkey
std_term.coop_term_type_code
uw_coop_term_type.coop_term_type_code
Restrict delete
std_term_coop_workterm_status_code_fkey
std_term.coop_workterm_status_code
uw_coop_workterm_status.coop_workterm_status_code
Restrict delete
std_term_form_of_study_code_fkey
std_term.form_of_study_code
uw_form_of_study.form_of_study_code
Restrict delete
std_term_standing_code_fkey
std_term.standing_code
pps_standing.standing_code
Restrict delete
adm_std_academic_course_ext_term_code_fkey
adm_std_academic_course.ext_term_code
uw_ext_term.ext_term_code
Restrict delete
adm_std_academic_course_grading_basis_code_fkey
adm_std_academic_course.grading_basis_code
uw_grading_basis.grading_basis_code
Restrict delete
adm_std_academic_course_ext_subject_code_fkey
adm_std_academic_course.ext_subject_code
uw_ext_subject.ext_subject_code
Restrict delete
adm_std_academic_course_ext_academic_level_code_fkey
adm_std_academic_course.ext_academic_level_code
uw_ext_academic_level.ext_academic_level_code
Restrict delete
adm_std_academic_course_ext_course_type_code_fkey
adm_std_academic_course.ext_course_type_code
uw_ext_course_type.ext_course_type_code
Restrict delete
adm_std_academic_course_ext_term_type_code_fkey
adm_std_academic_course.ext_term_type_code
uw_ext_term_type.ext_term_type_code
Restrict delete
adm_std_academic_course_course_level_code_fkey
adm_std_academic_course.course_level_code
uw_course_level.course_level_code
Restrict delete
uw_ext_org_country_code_fkey
uw_ext_org.country_code
uw_country.country_code
Restrict delete
std_term_subplan_requirement_term_id_fkey
std_term_subplan.requirement_term_id
uw_term.term_id
Restrict delete
std_term_subplan_uw_id_fkey
std_term_subplan.uw_id
std_term_subplan.term_id
std_term_subplan.plan_code
std_term_plan.uw_id
std_term_plan.term_id
std_term_plan.plan_code
Restrict delete
pps_program_history_first_valid_term_id_fkey
pps_program_history.first_valid_term_id
uw_term.term_id
Restrict delete
pps_program_history_unit_code_fkey
pps_program_history.unit_code
uw_unit.unit_code
Restrict delete
pps_program_history_group_code_fkey
pps_program_history.group_code
uw_group.group_code
Restrict delete
std_term_award_award_code_fkey
std_term_award.award_code
pps_term_award.award_code
Restrict delete
std_term_award_term_id_fkey
std_term_award.term_id
uw_term.term_id
Restrict delete
std_term_award_uw_id_fkey
std_term_award.uw_id
std_student.uw_id
Restrict delete
std_grad_supervisor_plan_code_fkey
std_grad_supervisor.plan_code
pps_plan.plan_code
Restrict delete
std_grad_supervisor_supervisor_uw_id_fkey
std_grad_supervisor.supervisor_uw_id
std_student.uw_id
Restrict delete
std_grad_supervisor_uw_id_fkey
std_grad_supervisor.uw_id
std_grad_supervisor.supervisor_effective
std_grad_supervision_history.uw_id
std_grad_supervision_history.supervisor_effective
Restrict delete
std_grad_supervisor_program_code_fkey
std_grad_supervisor.program_code
pps_program.program_code
Restrict delete
update_notification_run_id_fkey
update_notification.run_id
update_notification.process_code
update_run_notification.run_id
update_run_notification.process_code
Restrict delete
adm_appl_program_comment_adm_comment_code_fkey
adm_appl_program_comment.adm_comment_code
uw_adm_comment.adm_comment_code
Restrict delete
adm_appl_program_comment_uw_id_fkey
adm_appl_program_comment.uw_id
adm_appl_program_comment.appl_id
adm_appl_program_comment.program_order
adm_appl_program.uw_id
adm_appl_program.appl_id
adm_appl_program.program_order
Restrict delete
std_phone_phone_type_code_fkey
std_phone.phone_type_code
uw_phone_type.phone_type_code
Restrict delete
std_phone_uw_id_fkey
std_phone.uw_id
std_student.uw_id
Restrict delete
std_degree_degree_code_fkey
std_degree.degree_code
pps_degree.degree_code
Restrict delete
std_degree_uw_id_fkey
std_degree.uw_id
std_student.uw_id
Restrict delete
std_degree_completion_term_id_fkey
std_degree.completion_term_id
uw_term.term_id
Restrict delete
std_degree_plan_uw_id_fkey
std_degree_plan.uw_id
std_degree_plan.degree_id
std_degree.uw_id
std_degree.degree_id
Restrict delete
std_degree_plan_plan_code_fkey
std_degree_plan.plan_code
pps_plan.plan_code
Restrict delete
adm_appl_program_evaluation_uw_id_fkey
adm_appl_program_evaluation.uw_id
adm_appl_program_evaluation.appl_id
adm_appl_program_evaluation.program_order
adm_appl_program.uw_id
adm_appl_program.appl_id
adm_appl_program.program_order
Restrict delete
pps_plan_history_program_code_fkey
pps_plan_history.program_code
pps_program.program_code
Restrict delete
pps_plan_history_degree_code_fkey
pps_plan_history.degree_code
pps_degree.degree_code
Restrict delete
pps_plan_history_last_admit_term_id_fkey
pps_plan_history.last_admit_term_id
uw_term.term_id
Restrict delete
pps_plan_history_unit_code_fkey
pps_plan_history.unit_code
uw_unit.unit_code
Restrict delete
pps_plan_history_first_valid_term_id_fkey
pps_plan_history.first_valid_term_id
uw_term.term_id
Restrict delete
pps_plan_history_plan_type_code_fkey
pps_plan_history.plan_type_code
pps_plan_type.plan_type_code
Restrict delete
pps_program_program_code_fkey
pps_program.program_code
pps_program.program_as_of
pps_program_history.program_code
pps_program_history.program_as_of
Restrict delete
pps_program_first_valid_term_id_fkey
pps_program.first_valid_term_id
uw_term.term_id
Restrict delete
pps_program_group_code_fkey
pps_program.group_code
uw_group.group_code
Restrict delete
pps_program_unit_code_fkey
pps_program.unit_code
uw_unit.unit_code
Restrict delete
pps_subplan_subplan_type_fkey
pps_subplan.subplan_type
pps_subplan_type.subplan_type_code
Restrict delete
pps_subplan_plan_code_fkey
pps_subplan.plan_code
pps_subplan.subplan_code
pps_subplan.subplan_as_of
pps_subplan_history.plan_code
pps_subplan_history.subplan_code
pps_subplan_history.subplan_as_of
Restrict delete
pps_subplan_last_admit_term_id_fkey
pps_subplan.last_admit_term_id
uw_term.term_id
Restrict delete
pps_subplan_first_valid_term_id_fkey
pps_subplan.first_valid_term_id
uw_term.term_id
Restrict delete

Check Constraints

Table Constraint Name Constraint