Table odyssey_test._quest.std_term_course 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
uw_id quest_uw_id 2147483647
std_term.uw_id std_term_course_uw_id_fkey R
term_id quest_term_id 2147483647
off_course.term_id std_term_course_term_id_fkey R
std_term.term_id std_term_course_uw_id_fkey R
class_id int4 10
off_course.class_id std_term_course_term_id_fkey R
course_id quest_course_id 2147483647
cal_course.course_id Implied Constraint R
label_seq int4 10
course_grade text 2147483647  √  null
earn_credit bool 1
include_in_gpa bool 1
requirement_designation text 2147483647  √  null
requirement_designation_grade text 2147483647  √  null
units_attempted_code quest_completion_code 2147483647
grade_points numeric 9,3
units_attempted numeric 5,2
units_for_progress numeric 5,2
units_earned numeric 5,2
grading_basis text 2147483647
valid_attempt bool 1  √  null
grade_category text 2147483647  √  null
grade_submission_date date 13  √  null
transcript_note text 2147483647  √  null

Table contained 4,014,700 rows at Wed Feb 19 10:30 EST 2014

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

Close relationships  within of separation: