SchemaSpy - Table odyssey_test._quest.off_association

Generated by
SchemaSpy

Legend:

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_term_id_fkey1 R

off_course_as_of.term_id

off_association_term_id_fkey R

course_id

quest_course_id

2147483647

off_course_section.course_id

off_course_section_term_id_fkey1 R

off_course_as_of.course_id

off_association_term_id_fkey R

label_seq

int4

10

off_course_section.label_seq

off_course_section_term_id_fkey1 R

session_code

quest_session

2147483647

off_course_section.session_code

off_course_section_term_id_fkey1 R

association_id

int4

10

off_course_section.association_id

off_course_section_term_id_fkey1 R

course_take_units

numeric

5,2

course_ap_units

numeric

5,2

grade_basis_code

text

2147483647

requirement_designation

text

2147483647

√

null

component_code

text

2147483647

primary_component_code

text

2147483647

√

null

Table contained 225,109 rows at Wed Feb 19 10:30 EST 2014

Indexes:

Column(s)	Type	Sort	Constraint Name
term_id + course_id + label_seq + session_code + association_id	Primary key	Asc/Asc/Asc/Asc/Asc	off_association_pkey