Table odyssey_test._quest.off_course_section
A course section in which students may be registered and are all eligible to receive the same credit upon completion

 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
off_course_section.term_id off_course_section_term_id_fkey2 R
off_course_section_note.term_id off_course_section_note_term_id_fkey R
off_course_section_reserve.term_id off_course_section_reserve_term_id_fkey R
std_term_section.term_id std_term_section_term_id_fkey R
off_association.term_id off_course_section_term_id_fkey1 R
off_course_section.term_id off_course_section_term_id_fkey2 R
off_course_as_of.term_id off_course_section_term_id_fkey R
off_instruct_section.term_id off_course_section_term_id_fkey4 R
class_id int4 10
off_course_section_note.class_id off_course_section_note_term_id_fkey R
off_course_section_reserve.class_id off_course_section_reserve_term_id_fkey R
std_term_section.class_id std_term_section_term_id_fkey R
section_id int4 10
off_instruct_section.section_id off_course_section_term_id_fkey4 R
course_id quest_course_id 2147483647
off_course_section.course_id off_course_section_term_id_fkey3 R
off_association.course_id off_course_section_term_id_fkey1 R
off_course_as_of.course_id off_course_section_term_id_fkey R
off_course_section.course_id off_course_section_term_id_fkey3 R
topic_seq int4 10  √  null
label_seq int4 10
off_course_section.label_seq off_course_section_term_id_fkey3 R
off_course_section.label_seq off_course_section_term_id_fkey3 R
off_association.label_seq off_course_section_term_id_fkey1 R
session_code quest_session 2147483647
off_course_section.session_code off_course_section_term_id_fkey3 R
off_association.session_code off_course_section_term_id_fkey1 R
off_course_section.session_code off_course_section_term_id_fkey3 R
section_code text 2147483647
off_course_section.auto_enroll_1_section_code off_course_section_term_id_fkey2 R
off_course_section.auto_enroll_2_section_code off_course_section_term_id_fkey3 R
component_code text 2147483647
section_add_consent quest_consent 2147483647
section_drop_consent quest_consent 2147483647
section_enrol_status quest_course_enrol_status 2147483647
association_id int4 10  √  null
off_association.association_id off_course_section_term_id_fkey1 R
auto_enroll_1_section_code text 2147483647  √  null
off_course_section.section_code off_course_section_term_id_fkey2 R
auto_enroll_2_section_code text 2147483647  √  null
off_course_section.section_code off_course_section_term_id_fkey3 R
section_schedule_print bool 1
course_section_enrol_limit int4 10
course_section_enrol_total int4 10
course_section_room_capacity int4 10

Table contained 263,584 rows at Wed Feb 19 10:30 EST 2014

Indexes:
Column(s) Type Sort Constraint Name
term_id + class_id Primary key Asc/Asc off_course_section_pkey
term_id + course_id + label_seq + session_code + section_code Must be unique Asc/Asc/Asc/Asc/Asc off_course_section_term_id_course_id_label_seq_session_code_key

Close relationships  within of separation: