Table odyssey_test._quest.off_course_section_note 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_course_section.term_id off_course_section_note_term_id_fkey R
class_id int4 10
off_course_section.class_id off_course_section_note_term_id_fkey R
section_note_id int4 10  √  null
note_id int4 10  √  null
off_default_note.note_id off_course_section_note_note_id_fkey R
note_text text 2147483647  √  null

Table contained 16,985 rows at Wed Feb 19 10:30 EST 2014

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

Close relationships  within of separation: