std_term


Description

Summary of each academic term; mostly from ps_stdnt_car_term.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
uw_id "_quest"."quest_uw_id" 2147483647 null
std_term_course.uw_id std_term_course_uw_id_fkeyR
std_term_program.uw_id std_term_program_uw_id_fkeyR
std_term_section.uw_id std_term_section_uw_id_fkeyR
std_term_units.uw_id std_term_units_uw_id_fkeyR
std_transfer_credit_detail.uw_id std_transfer_credit_detail_uw_id_fkey1R
std_student.uw_id std_term_uw_id_fkeyR
term_id "_quest"."quest_term_id" 2147483647 null
std_term_course.term_id std_term_course_uw_id_fkeyR
std_term_program.term_id std_term_program_uw_id_fkeyR
std_term_section.term_id std_term_section_uw_id_fkeyR
std_term_units.term_id std_term_units_uw_id_fkeyR
std_transfer_credit_detail.term_id std_transfer_credit_detail_uw_id_fkey1R
uw_term.term_id std_term_term_id_fkeyR
career_code "_quest"."quest_career" 2147483647 null
career_num int4 10 null
registration_status "_quest"."quest_registration_status" 2147483647 √ null
eligible_to_enrol bool 1 null
withdraw_code "_quest"."quest_withdraw_code" 2147483647 null
withdraw_reason text 2147483647 √ null
withdraw_date date 13 √ null
uw_date.date Implied ConstraintR
last_date_attended date 13 √ null
approved_load "_quest"."quest_load" 2147483647 null
actual_load "_quest"."quest_load" 2147483647 null
projected_level text 2147483647 √ null
form_of_study text 2147483647 null
study_agreement text 2147483647 √ null
term_gpa numeric 8,3 null
cumulative_gpa numeric 8,3 null
coop_term_type_code text 2147483647 √ null
uw_coop_term_type.coop_term_type_code Implied ConstraintR
coop_workterm_status text 2147483647 √ null
standing_action_date date 13 √ null
uw_date.date Implied ConstraintR
standing_code text 2147483647 √ null
pps_standing.standing_code std_term_standing_code_fkeyR
standing_program_code text 2147483647 √ null
pps_program.program_code std_term_standing_program_code_fkeyR
standing_status_code text 2147483647 √ null
pps_standing_status.standing_status_code std_term_standing_status_code_fkeyR
transcript_text text 2147483647 √ null
has_classes bool 1 null
has_transfer_credits bool 1 null

Table contained 2096452 rows

Indexes

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

Relationships

Close relationships within degrees of separation