Table odyssey_test._quest.std_term_units 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.uw_id std_term_units_uw_id_fkey R
term_id quest_term_id 2147483647
std_term.term_id std_term_units_uw_id_fkey R
override_max_units bool 1
max_total_unit_load numeric 5,2
max_nogpa_unit_load numeric 5,2
term_academic_units_attempted numeric 8,3
term_academic_units_passed numeric 8,3
term_units_attempted_in_gpa numeric 8,3
term_units_passed_in_gpa numeric 8,3
term_units_attempted_not_in_gpa numeric 8,3 Includes non-academic (PD) courses.
term_units_passed_not_in_gpa numeric 8,3
term_units_in_progress_towards_gpa numeric 8,3
term_units_in_progress_not_towards_gpa numeric 8,3
term_grade_points numeric 9,3
term_units_audited numeric 8,3
term_units_transferred numeric 8,3
term_units_total numeric 8,3
transferred_units_attempted_towards_gpa numeric 8,3
transferred_units_attempted_not_towards_gpa numeric 8,3
transferred_units_passed_in_gpa numeric 8,3
transferred_units_passed_not_in_gpa numeric 8,3
transferred_grade_points numeric 9,3
reset_cum_stats bool 1
cum_academic_units_attempted numeric 8,3
cum_academic_units_passed numeric 8,3 Does not include transfer credits.
cum_units_attempted_in_gpa numeric 8,3
cum_units_passed_in_gpa numeric 8,3
cum_units_attempted_not_in_gpa numeric 8,3
cum_units_passed_not_in_gpa numeric 8,3
cum_units_in_progress_towards_gpa numeric 8,3
cum_units_in_progress_not_towards_gpa numeric 8,3
cum_units_audited numeric 8,3
cum_units_transferred numeric 8,3
cum_units_total numeric 8,3
cum_grade_points numeric 9,3
resident_terms_credited numeric 6,3
resident_terms_adjustment numeric 6,3
cum_resident_terms numeric 6,3

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_units_pkey

Close relationships  within of separation: