SchemaSpy - Table odyssey_test._quest.std_term_subplan

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

uw_id

quest_uw_id

2147483647

std_student.uw_id

Implied Constraint R

term_id

quest_term_id

2147483647

uw_term.term_id

Implied Constraint R

plan_code

text

2147483647

pps_plan.plan_code

Implied Constraint R

subplan_code

text

2147483647

gpa_type_code

text

2147483647

gpa

numeric

8,3

√

null

gpa_date

date

√

null

Table contained 3,296 rows at Wed Feb 19 10:30 EST 2014

Indexes:

Column(s)	Type	Sort	Constraint Name
uw_id + term_id + plan_code + subplan_code + gpa_type_code	Primary key	Asc/Asc/Asc/Asc/Asc	std_term_subplan_gpa_pkey