std_term_section


Columns

Column Type Size Nulls Auto Default Children Parents Comments
uw_id "_quest"."quest_uw_id" 2147483647 null
std_term.uw_id std_term_section_uw_id_fkeyR
term_id "_quest"."quest_term_id" 2147483647 null
std_term.term_id std_term_section_uw_id_fkeyR
off_course_section_reserve.term_id std_term_section_term_id_fkey1R
off_course_section.term_id std_term_section_term_id_fkeyR
class_id int4 10 null
off_course_section_reserve.class_id std_term_section_term_id_fkey1R
off_course_section.class_id std_term_section_term_id_fkeyR
enrolment_status_code text 2147483647 null
uw_enrolment_status.enrolment_status_code std_term_section_enrolment_status_code_fkeyR
enrolment_reason_code text 2147483647 null
uw_enrolment_reason.enrolment_reason_code std_term_section_enrolment_reason_code_fkeyR
permission_number int4 10 √ null
reserve_id int4 10 √ null
off_course_section_reserve.reserve_id std_term_section_term_id_fkey1R
add_date date 13 null
uw_date.date Implied ConstraintR
drop_date date 13 √ null
uw_date.date Implied ConstraintR
last_update timestamp 29,6 √ null
last_enrolment_change timestamp 29,6 √ null
last_drop timestamp 29,6 √ null

Table contained 8817446 rows

Indexes

Constraint Name Type Sort Column(s)
std_term_section_pkey Primary key Asc/Asc/Asc uw_id + term_id + class_id
std_term_section_term_id_class_id_idx Performance Asc/Asc term_id + class_id

Relationships

Close relationships within degrees of separation