Table odyssey_test._quest.off_course_as_of 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_association.term_id off_association_term_id_fkey R
off_course_section.term_id off_course_section_term_id_fkey R
uw_term.term_id off_course_as_of_term_id_fkey R
course_id quest_course_id 2147483647
off_association.course_id off_association_term_id_fkey R
off_course_section.course_id off_course_section_term_id_fkey R
cal_course_history.course_id off_course_as_of_course_id_fkey R
course_as_of date 13
cal_course_history.course_as_of off_course_as_of_course_id_fkey R

Table contained 161,475 rows at Wed Feb 19 10:30 EST 2014

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

Close relationships  within of separation: