SchemaSpy - Table odyssey_test._quest.cal_course

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

course_id

quest_course_id

2147483647

cal_course.course_id	cal_course_course_id_fkey R
cal_course_label_history.course_id	cal_course_label_history_course_id_fkey1 R
cal_course_topic_history.course_id	cal_course_topic_history_course_id_fkey R
off_course_as_of.course_id	off_course_as_of_course_id_fkey R

course_as_of

date

cal_course.course_as_of	cal_course_course_id_fkey R
cal_course_label_history.course_as_of	cal_course_label_history_course_id_fkey1 R
cal_course_topic_history.course_as_of	cal_course_topic_history_course_id_fkey R
off_course_as_of.course_as_of	off_course_as_of_course_id_fkey R

course_active

bool

course_short_title

text

2147483647

course_title

text

2147483647

course_description

text

2147483647

√

null

course_take_units

numeric

5,2

course_ap_units

numeric

5,2

course_add_consent

quest_consent

2147483647

course_drop_consent

quest_consent

2147483647

Table contained 58,997 rows at Wed Feb 19 10:30 EST 2014

Indexes:

Column(s)	Type	Sort	Constraint Name
course_id + course_as_of	Primary key	Asc/Asc	cal_course_history_pkey