Table odyssey_test._quest.std_transfer_credit_detail
Transfer credit details. Some corrections are done in ps_correction.sql upon load.

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_student.uw_id std_transfer_credit_detail_uw_id_fkey R
career_code quest_career 2147483647
transfer_group int4 10
seq_num int4 10
course_id int4 10
cal_course.course_id std_transfer_credit_detail_course_id_fkey R
articulation_term quest_term_id 2147483647
external_term text 2147483647  √  null
external_subject text 2147483647  √  null
external_catalog text 2147483647  √  null
external_descr text 2147483647  √  null
units_taken numeric 5,2  √  null
external_grade text 2147483647  √  null
label_seq int4 10
grading_basis text 2147483647
units_transferred numeric 8,3
course_grade text 2147483647
earn_credit bool 1
include_in_gpa bool 1
units_attempted_code quest_completion_code 2147483647
requirement_designation text 2147483647  √  null
valid_attempt bool 1
grade_category text 2147483647

Table contained 115,154 rows at Wed Feb 19 10:30 EST 2014

Indexes:
Column(s) Type Sort Constraint Name
uw_id + career_code + transfer_group + seq_num Primary key Asc/Asc/Asc/Asc std_transfer_credit_detail_pkey

Close relationships  within of separation: