Table odyssey_test._quest.std_term_course_demand 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_student.uw_id std_term_course_demand_uw_id_fkey R
term_id quest_term_id 2147483647
uw_term.term_id std_term_course_demand_term_id_fkey R
career_code quest_career 2147483647
class_id int4 10
instruction_mode quest_instruction_mode 2147483647  √  null
instruction_mode_optional quest_option 2147483647  √  null
priority int4 10  √  null
location text 2147483647  √  null
campus text 2147483647  √  null
campus_optional quest_option 2147483647  √  null
apply_ng_grade bool 1  √  null
demand_as_of timestamp 29,6  √  null

Table contained 951,819 rows at Wed Feb 19 10:30 EST 2014

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

Close relationships  within of separation: