SchemaSpy - Table odyssey_test._quest.uw

An academic term

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

term_id

quest_term_id

2147483647

off_course.term_id	Implied Constraint R
off_course_as_of.term_id	off_course_as_of_term_id_fkey R
off_course_section_complete.term_id	Implied Constraint R
off_course_section_plus.term_id	Implied Constraint R
off_instruct_section.term_id	off_instruct_section_term_id_fkey R
off_instruct_section_instructor_plus.term_id	Implied Constraint R
off_instruct_section_meet_plus.term_id	Implied Constraint R
pps_plan.first_valid_term_id	pps_plan_first_valid_term_id_fkey R
pps_plan.last_admit_term_id	pps_plan_last_admit_term_id_fkey R
pps_plan_history.first_valid_term_id	pps_plan_history_first_valid_term_id_fkey R
pps_plan_history.last_admit_term_id	pps_plan_history_last_admit_term_id_fkey R
pps_program.first_valid_term_id	pps_program_first_valid_term_id_fkey R
pps_program_history.first_valid_term_id	pps_program_history_first_valid_term_id_fkey R
pps_subplan.first_valid_term_id	pps_subplan_first_valid_term_id_fkey R
pps_subplan.last_admit_term_id	pps_subplan_last_admit_term_id_fkey R
pps_subplan_history.first_valid_term_id	pps_subplan_history_first_valid_term_id_fkey R
pps_subplan_history.last_admit_term_id	pps_subplan_history_last_admit_term_id_fkey R
std_term.term_id	Implied Constraint R
std_term_course_demand.term_id	std_term_course_demand_term_id_fkey R
std_term_plan_gpa.term_id	Implied Constraint R
std_term_plan_plus.term_id	Implied Constraint R
std_term_program_plus.term_id	Implied Constraint R
std_term_subplan_gpa.term_id	Implied Constraint R

term_dates

daterange

2147483647

term_class_dates

daterange

2147483647

term_exam_dates

daterange

2147483647

√

null

Table contained 191 rows at Wed Feb 19 10:30 EST 2014

Indexes:

Column(s)	Type	Sort	Constraint Name
term_id	Primary key	Asc	uw_term_pkey