Table odyssey_test._quest_raw.ps_trns_crse_dtl 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
emplid varchar 2147483647
ps_person_sa.emplid Implied Constraint R
acad_career varchar 2147483647
institution varchar 2147483647
model_nbr int4 10
articulation_term varchar 2147483647
trnsfr_eqvlncy_grp int4 10
trnsfr_eqvlncy_seq int4 10
term_year int4 10  √  null
ext_term varchar 2147483647  √  null
school_subject varchar 2147483647  √  null
school_crse_nbr varchar 2147483647  √  null
descr varchar 2147483647  √  null
unt_taken numeric 5,2  √  null
crse_grade_input varchar 2147483647  √  null
crse_id varchar 2147483647  √  null
crse_offer_nbr int4 10  √  null
grading_basis varchar 2147483647  √  null
unt_trnsfr numeric 8,3  √  null
crse_grade_off varchar 2147483647  √  null
earn_credit varchar 2147483647  √  null
include_in_gpa varchar 2147483647  √  null
units_attempted varchar 2147483647  √  null
rqmnt_designtn varchar 2147483647  √  null
valid_attempt varchar 2147483647  √  null
grade_category varchar 2147483647  √  null
comments varchar 2147483647  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
emplid + acad_career + institution + model_nbr + articulation_term + trnsfr_eqvlncy_grp + trnsfr_eqvlncy_seq Primary key Asc/Asc/Asc/Asc/Asc/Asc/Asc ps_trns_crse_dtl_pkey

Close relationships: