View odyssey_test._quest.std_term_plan_plus Generated by
SchemaSpy
Legend: SourceForge.net
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
plan_code text 2147483647  √  null
pps_plan.plan_code Implied Constraint R
uw_id quest_uw_id 2147483647  √  null
std_student.uw_id Implied Constraint R
term_id quest_term_id 2147483647  √  null
uw_term.term_id Implied Constraint R
plan_position int4 10  √  null
requirement_term_id quest_term_id 2147483647  √  null
degree_id quest_degree_id 2147483647  √  null
plan_as_of date 13  √  null
plan_active bool 1  √  null
plan_title text 2147483647  √  null
plan_short_title text 2147483647  √  null
plan_comment text 2147483647  √  null
plan_diploma_description text 2147483647  √  null
plan_transcript_description text 2147483647  √  null
degree_code text 2147483647  √  null
pps_degree.degree_code Implied Constraint R
program_code text 2147483647  √  null
pps_program.program_code Implied Constraint R
career_code quest_career 2147483647  √  null
unit_code text 2147483647  √  null
uw_unit.unit_code Implied Constraint R
plan_type_code text 2147483647  √  null
first_valid_term_id quest_term_id 2147483647  √  null
last_admit_term_id quest_term_id 2147483647  √  null

Analyzed at Wed Feb 19 10:30 EST 2014


Close relationships: