off_instruct_section


Description

An instructional section in which students may be registered and will be managed together as one group

Columns

Column Type Size Nulls Auto Default Children Parents Comments
term_id "_quest"."quest_term_id" 2147483647 null
ro_exam_section.term_id ro_exam_section_term_id_fkey1R
ro_line_section_id.term_id ro_line_section_id_term_id_fkey1C
ro_load_match.term_id ro_load_match_term_id_fkey1C
teaching_admin_section_mapping.term_id teaching_admin_section_mapping_term_id_fkey1C
teaching_admin_term_approved_section.term_id teaching_admin_term_approved_section_term_id_fkeyR
teaching_admin_term_remove_section.term_id teaching_admin_term_remove_section_term_id_fkey1C
off_course_section.term_id off_course_section_term_id_fkey4R
off_instruct_section_instructor.term_id off_instruct_section_instructor_term_id_fkeyR
off_instruct_section_meet.term_id off_instruct_section_meet_term_id_fkeyR
uw_term.term_id off_instruct_section_term_id_fkeyR
section_id int4 10 null
ro_exam_section.section_id ro_exam_section_term_id_fkey1R
ro_line_section_id.section_id ro_line_section_id_term_id_fkey1C
ro_load_match.section_id ro_load_match_term_id_fkey1C
teaching_admin_section_mapping.section_id teaching_admin_section_mapping_term_id_fkey1C
teaching_admin_term_approved_section.section_id teaching_admin_term_approved_section_term_id_fkeyR
teaching_admin_term_remove_section.section_id teaching_admin_term_remove_section_term_id_fkey1C
off_course_section.section_id off_course_section_term_id_fkey4R
off_instruct_section_instructor.section_id off_instruct_section_instructor_term_id_fkeyR
off_instruct_section_meet.section_id off_instruct_section_meet_term_id_fkeyR
session_code "_quest"."quest_session" 2147483647 null

The session of the section
is_enrolment bool 1 null

Whether the section is an enrolment (primary) section
is_status "_quest"."quest_section_status" 2147483647 null

The status of the section
is_enrol_limit int4 10 null
is_enrol_total int4 10 null
is_capacity_request int4 10 null
is_combined_type "_quest"."quest_combined_type" 2147483647 √ null
campus_code text 2147483647 null
uw_campus.campus_code off_instruct_section_campus_code_fkeyR
location_code text 2147483647 null
uw_location.location_code off_instruct_section_location_code_fkeyR
instruction_mode_code "_quest"."quest_instruction_mode" 2147483647 null

Table contained 340715 rows

Indexes

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

Relationships

Close relationships within degrees of separation