Table odyssey_test._quest.off_course_section_reserve 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
term_id quest_term_id 2147483647
std_term_section.term_id std_term_section_term_id_fkey1 R
off_course_section.term_id off_course_section_reserve_term_id_fkey R
class_id int4 10
std_term_section.class_id std_term_section_term_id_fkey1 R
off_course_section.class_id off_course_section_reserve_term_id_fkey R
reserve_id int4 10
std_term_section.reserve_id std_term_section_term_id_fkey1 R
reserve_enrol_limit int4 10
reserve_enrol_total int4 10
reserve_start_date date 13
requisite_id int4 10
cal_requisite.requisite_id off_course_section_reserve_requisite_id_fkey R

Table contained 33,565 rows at Wed Feb 19 10:30 EST 2014

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

Close relationships  within of separation: