off_course_section


Description

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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
term_id "_quest"."quest_term_id" 2147483647 null
off_course_section.term_id off_course_section_term_id_fkey3R
off_course_section_note.term_id off_course_section_note_term_id_fkeyR
off_course_section_reserve.term_id off_course_section_reserve_term_id_fkeyR
std_term_course_demand.term_id std_term_course_demand_term_id_fkeyR
std_term_section.term_id std_term_section_term_id_fkeyR
off_course_as_of.term_id off_course_section_term_id_fkeyR
off_course_section.term_id off_course_section_term_id_fkey3R
off_instruct_section.term_id off_course_section_term_id_fkey4R
off_association.term_id off_course_section_term_id_fkey1R
class_id int4 10 null
off_course_section_note.class_id off_course_section_note_term_id_fkeyR
off_course_section_reserve.class_id off_course_section_reserve_term_id_fkeyR
std_term_course_demand.class_id std_term_course_demand_term_id_fkeyR
std_term_section.class_id std_term_section_term_id_fkeyR
section_id int4 10 null
off_instruct_section.section_id off_course_section_term_id_fkey4R
course_id "_quest"."quest_course_id" 2147483647 null
off_course_section.course_id off_course_section_term_id_fkey3R
off_course_as_of.course_id off_course_section_term_id_fkeyR
off_association.course_id off_course_section_term_id_fkey1R
off_course_section.course_id off_course_section_term_id_fkey3R
topic_seq int4 10 null
label_seq int4 10 null
off_course_section.label_seq off_course_section_term_id_fkey3R
off_association.label_seq off_course_section_term_id_fkey1R
off_course_section.label_seq off_course_section_term_id_fkey3R
session_code "_quest"."quest_session" 2147483647 null
off_course_section.session_code off_course_section_term_id_fkey3R
off_course_section.session_code off_course_section_term_id_fkey3R
off_association.session_code off_course_section_term_id_fkey1R
section_code text 2147483647 null
off_course_section.auto_enroll_1_section_code off_course_section_term_id_fkey2R
off_course_section.auto_enroll_2_section_code off_course_section_term_id_fkey3R
component_code text 2147483647 null
cal_component.component_code off_course_section_component_code_fkeyR
cs_add_consent "_quest"."quest_consent" 2147483647 null
cs_drop_consent "_quest"."quest_consent" 2147483647 null
cs_closed bool 1 null
association_id int4 10 √ null
off_association.association_id off_course_section_term_id_fkey1R
auto_enroll_1_section_code text 2147483647 √ null
off_course_section.section_code off_course_section_term_id_fkey2R
auto_enroll_2_section_code text 2147483647 √ null
off_course_section.section_code off_course_section_term_id_fkey3R
cs_schedule_print bool 1 null
cs_enrol_limit int4 10 null
cs_enrol_total int4 10 null
cs_capacity_request int4 10 null

Table contained 353749 rows

Indexes

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

Relationships

Close relationships within degrees of separation