Table odyssey_test._quest.std_term_section 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_section_uw_id_fkey R
term_id quest_term_id 2147483647
off_course_section.term_id std_term_section_term_id_fkey R
std_term.term_id std_term_section_uw_id_fkey R
off_course_section_reserve.term_id std_term_section_term_id_fkey1 R
class_id int4 10
off_course_section.class_id std_term_section_term_id_fkey R
off_course_section_reserve.class_id std_term_section_term_id_fkey1 R
course_id quest_course_id 2147483647
cal_course.course_id Implied Constraint R
enrolment_status quest_student_enrol_status 2147483647
permission_number int4 10  √  null
reserve_id int4 10  √  null
off_course_section_reserve.reserve_id std_term_section_term_id_fkey1 R
add_date date 13
drop_date date 13  √  null
last_update timestamp 29,6  √  null
last_enrolment_change timestamp 29,6  √  null
last_drop timestamp 29,6  √  null

Table contained 5,842,041 rows at Wed Feb 19 10:30 EST 2014

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

Close relationships  within of separation: