Table odyssey_test._quest.off_instruct_section
An instructional section in which students may be registered and will be managed together as one group

 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_fkey4 R
off_instruct_section_instructor.term_id off_instruct_section_instructor_term_id_fkey R
off_instruct_section_meet.term_id off_instruct_section_meet_term_id_fkey R
uw_term.term_id off_instruct_section_term_id_fkey R
section_id int4 10
off_course_section.section_id off_course_section_term_id_fkey4 R
off_instruct_section_instructor.section_id off_instruct_section_instructor_term_id_fkey R
off_instruct_section_meet.section_id off_instruct_section_meet_term_id_fkey R
session_code quest_session 2147483647 The session of the section
section_enrolment bool 1 Whether the section is an enrolment (primary) section
section_status quest_section_status 2147483647  √  null The status of the section
instruct_section_enrol_limit int4 10
instruct_section_enrol_total int4 10
instruct_section_capacity_request int4 10
section_combined_type quest_combined_type 2147483647  √  null
campus_code text 2147483647
uw_campus.campus_code off_instruct_section_campus_code_fkey R
location_code text 2147483647
uw_location.location_code off_instruct_section_location_code_fkey R
instruction_mode_code quest_instruction_mode 2147483647

Table contained 255,134 rows at Wed Feb 19 10:30 EST 2014

Indexes:
Column(s) Type Sort Constraint Name
term_id + section_id Primary key Asc/Asc off_instruct_section_pkey

Close relationships  within of separation: