View odyssey_test._quest.off_course_section_plus
off_course_section enhanced with fields related to the course labels and topics

 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
course_id quest_course_id 2147483647  √  null
cal_course.course_id Implied Constraint R
course_as_of date 13  √  null
topic_seq int4 10  √  null
label_seq int4 10  √  null
term_id quest_term_id 2147483647  √  null
uw_term.term_id Implied Constraint R
class_id int4 10  √  null
section_id int4 10  √  null
session_code quest_session 2147483647  √  null
section_code text 2147483647  √  null
component_code text 2147483647  √  null
section_add_consent quest_consent 2147483647  √  null
section_drop_consent quest_consent 2147483647  √  null
section_enrol_status quest_course_enrol_status 2147483647  √  null
association_id int4 10  √  null
auto_enroll_1_section_code text 2147483647  √  null
auto_enroll_2_section_code text 2147483647  √  null
section_schedule_print bool 1  √  null
course_section_enrol_limit int4 10  √  null
course_section_enrol_total int4 10  √  null
course_section_room_capacity int4 10  √  null
subject_code text 2147483647  √  null
cal_subject.subject_code Implied Constraint R
catalog text 2147483647  √  null
campus_code text 2147483647  √  null
uw_campus.campus_code Implied Constraint R
group_code text 2147483647  √  null
uw_group.group_code Implied Constraint R
unit_code text 2147483647  √  null
uw_unit.unit_code Implied Constraint R
career_code quest_career 2147483647  √  null
requisite_id quest_requisite_id 2147483647  √  null
label_schedule_print bool 1  √  null
topic_short_title text 2147483647  √  null
topic_title text 2147483647  √  null

Analyzed at Wed Feb 19 10:30 EST 2014


Close relationships: