Table odyssey_test._quest.std_term
Summary of each academic term; mostly from ps_stdnt_car_term.

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
uw_id quest_uw_id 2147483647
std_term_course.uw_id std_term_course_uw_id_fkey R
std_term_program.uw_id std_term_program_uw_id_fkey R
std_term_section.uw_id std_term_section_uw_id_fkey R
std_term_units.uw_id std_term_units_uw_id_fkey R
std_student.uw_id Implied Constraint R
term_id quest_term_id 2147483647
std_term_course.term_id std_term_course_uw_id_fkey R
std_term_program.term_id std_term_program_uw_id_fkey R
std_term_section.term_id std_term_section_uw_id_fkey R
std_term_units.term_id std_term_units_uw_id_fkey R
uw_term.term_id Implied Constraint R
career_code quest_career 2147483647
career_num int4 10
registration_status quest_registration_status 2147483647  √  null
eligible_to_enrol bool 1
withdraw_code quest_withdraw_code 2147483647
withdraw_reason text 2147483647  √  null
withdraw_date date 13  √  null
last_date_attended date 13  √  null
primary_program_code text 2147483647
approved_load text 2147483647
actual_load text 2147483647
projected_level text 2147483647  √  null
form_of_study text 2147483647
study_agreement text 2147483647  √  null
term_gpa numeric 8,3
cumulative_gpa numeric 8,3
coop_term_type_code text 2147483647  √  null
coop_workterm_status text 2147483647  √  null
standing_action_date date 13  √  null
standing_code text 2147483647  √  null
pps_standing.standing_code std_term_standing_code_fkey R
standing_program_code text 2147483647  √  null
pps_program.program_code std_term_standing_program_code_fkey R
standing_status quest_standing_status 2147483647  √  null
transcript_text text 2147483647  √  null

Table contained 1,166,424 rows at Wed Feb 19 10:30 EST 2014

Indexes:
Column(s) Type Sort Constraint Name
uw_id + term_id Primary key Asc/Asc std_term_pkey

Close relationships  within of separation: