121 Foreign Key Constraints:

Constraint Name	Child Column	Parent Column	Delete Rule
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_campus_code_fkey	cal_course_label.campus_code	uw_campus.campus_code	Restrict delete
cal_course_label_course_id_fkey	cal_course_label.course_id cal_course_label.course_as_of cal_course_label.label_seq	cal_course_label_history.course_id cal_course_label_history.course_as_of cal_course_label_history.label_seq	Restrict delete
cal_course_label_group_code_fkey	cal_course_label.group_code	uw_group.group_code	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_course_id_fkey	cal_course_label_history.course_id	cal_course.course_id	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_group_code_fkey	cal_course_label_history.group_code	uw_group.group_code	Restrict delete
cal_course_label_history_requisite_id_fkey	cal_course_label_history.requisite_id	cal_requisite.requisite_id	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_unit_code_fkey	cal_course_label_history.unit_code	uw_unit.unit_code	Restrict delete
cal_course_label_requisite_id_fkey	cal_course_label.requisite_id	cal_requisite.requisite_id	Restrict delete
cal_course_label_subject_code_fkey	cal_course_label.subject_code	cal_subject.subject_code	Restrict delete
cal_course_label_unit_code_fkey	cal_course_label.unit_code	uw_unit.unit_code	Restrict delete
cal_course_topic_course_id_fkey	cal_course_topic.course_id	cal_course.course_id	Restrict delete
cal_course_topic_course_id_fkey1	cal_course_topic.course_id cal_course_topic.course_as_of cal_course_topic.topic_seq	cal_course_topic_history.course_id cal_course_topic_history.course_as_of cal_course_topic_history.topic_seq	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
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
cal_subject_history_unit_code_fkey	cal_subject_history.unit_code	uw_unit.unit_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
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_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
off_course_as_of_term_id_fkey	off_course_as_of.term_id	uw_term.term_id	Restrict delete
off_course_section_note_note_id_fkey	off_course_section_note.note_id	off_default_note.note_id	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_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_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_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_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_fkey4	off_course_section.term_id off_course_section.section_id	off_instruct_section.term_id off_instruct_section.section_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
off_instruct_section_campus_code_fkey	off_instruct_section.campus_code	uw_campus.campus_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
off_instruct_section_location_code_fkey	off_instruct_section.location_code	uw_location.location_code	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
off_instruct_section_term_id_fkey	off_instruct_section.term_id	uw_term.term_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_plan_degree_code_fkey	pps_plan.degree_code	pps_degree.degree_code	Restrict delete
pps_plan_first_valid_term_id_fkey	pps_plan.first_valid_term_id	uw_term.term_id	Restrict delete
pps_plan_history_degree_code_fkey	pps_plan_history.degree_code	pps_degree.degree_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_last_admit_term_id_fkey	pps_plan_history.last_admit_term_id	uw_term.term_id	Restrict delete
pps_plan_history_program_code_fkey	pps_plan_history.program_code	pps_program.program_code	Restrict delete
pps_plan_history_unit_code_fkey	pps_plan_history.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_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_program_code_fkey	pps_plan.program_code	pps_program.program_code	Restrict delete
pps_plan_unit_code_fkey	pps_plan.unit_code	uw_unit.unit_code	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_history_first_valid_term_id_fkey	pps_program_history.first_valid_term_id	uw_term.term_id	Restrict delete
pps_program_history_group_code_fkey	pps_program_history.group_code	uw_group.group_code	Restrict delete
pps_program_history_unit_code_fkey	pps_program_history.unit_code	uw_unit.unit_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_unit_code_fkey	pps_program.unit_code	uw_unit.unit_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
pps_service_indicator_reason_service_indicator_code_fkey	pps_service_indicator_reason.service_indicator_code	pps_service_indicator.service_indicator_code	Restrict delete
pps_subplan_first_valid_term_id_fkey	pps_subplan.first_valid_term_id	uw_term.term_id	Restrict delete
pps_subplan_history_first_valid_term_id_fkey	pps_subplan_history.first_valid_term_id	uw_term.term_id	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_plan_code_fkey	pps_subplan_history.plan_code	pps_plan.plan_code	Restrict delete
pps_subplan_last_admit_term_id_fkey	pps_subplan.last_admit_term_id	uw_term.term_id	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
std_address_uw_id_fkey	std_address.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_honour_uw_id_fkey	std_degree_honour.uw_id std_degree_honour.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
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_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_degree_uw_id_fkey	std_degree.uw_id	std_student.uw_id	Restrict delete
std_photo_uw_id_fkey	std_photo.uw_id	std_student.uw_id	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_program_history_campus_code_fkey	std_program_history.campus_code	uw_campus.campus_code	Restrict delete
std_program_history_program_code_fkey	std_program_history.program_code	pps_program.program_code	Restrict delete
std_program_history_uw_id_fkey	std_program_history.uw_id	std_student.uw_id	Restrict delete
std_program_milestone_program_code_fkey	std_program_milestone.program_code	pps_program.program_code	Restrict delete
std_program_milestone_uw_id_fkey	std_program_milestone.uw_id	std_student.uw_id	Restrict delete
std_program_plan_milestone_plan_code_fkey	std_program_plan_milestone.plan_code	pps_plan.plan_code	Restrict delete
std_program_plan_milestone_program_code_fkey	std_program_plan_milestone.program_code	pps_program.program_code	Restrict delete
std_program_plan_milestone_uw_id_fkey	std_program_plan_milestone.uw_id	std_student.uw_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_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
std_term_course_demand_term_id_fkey	std_term_course_demand.term_id	uw_term.term_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_term_id_fkey	std_term_course.term_id std_term_course.class_id	off_course.term_id off_course.class_id	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_plan_plan_code_fkey	std_term_plan.plan_code	pps_plan.plan_code	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
std_term_program_campus_code_fkey	std_term_program.campus_code	uw_campus.campus_code	Restrict delete
std_term_program_program_code_fkey	std_term_program.program_code	pps_program.program_code	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_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
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_standing_code_fkey	std_term.standing_code	pps_standing.standing_code	Restrict delete
std_term_standing_program_code_fkey	std_term.standing_program_code	pps_program.program_code	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
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
std_transfer_credit_detail_course_id_fkey	std_transfer_credit_detail.course_id	cal_course.course_id	Restrict delete
std_transfer_credit_detail_uw_id_fkey	std_transfer_credit_detail.uw_id	std_student.uw_id	Restrict delete
std_transfer_credit_school_uw_id_fkey	std_transfer_credit_school.uw_id	std_student.uw_id	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
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_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_history_location_code_fkey	uw_campus_history.location_code	uw_location.location_code	Restrict delete
uw_campus_location_code_fkey	uw_campus.location_code	uw_location.location_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
uw_location_country_code_fkey	uw_location.country_code	uw_country.country_code	Restrict delete
uw_location_history_country_code_fkey	uw_location_history.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
uw_room_unit_code_fkey	uw_room.unit_code	uw_unit.unit_code	Restrict delete
uw_unit_campus_code_fkey	uw_unit.campus_code	uw_campus.campus_code	Restrict delete
uw_unit_group_code_fkey	uw_unit.group_code	uw_group.group_code	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
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

Check Constraints:

Table	Constraint Name	Constraint
None detected