Table odyssey_test._quest_raw.ps_trns_crse_sch 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
acad_prog varchar 2147483647  √  null
acad_plan varchar 2147483647  √  null
ls_school_type varchar 2147483647  √  null
src_org_name varchar 2147483647  √  null
model_status varchar 2147483647  √  null
unt_taken numeric 5,2  √  null
unt_trnsfr numeric 8,3  √  null
trf_taken_gpa numeric 8,3  √  null
trf_taken_nogpa numeric 8,3  √  null
trf_passed_gpa numeric 8,3  √  null
trf_passed_nogpa numeric 8,3  √  null
trf_grade_points numeric 9,3  √  null
trf_gpa numeric 8,3  √  null
include_in_gpa varchar 2147483647  √  null
comments varchar 2147483647  √  null

Table contained 21,199 rows at Wed Feb 19 10:31 EST 2014

Indexes:
Column(s) Type Sort Constraint Name
emplid + acad_career + institution + model_nbr Primary key Asc/Asc/Asc/Asc ps_trns_crse_sch_pkey

Close relationships: