SchemaSpy - Table odyssey_test._quest.std

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_degree_honour.uw_id	std_degree_honour_uw_id_fkey R
std_degree_plan.uw_id	std_degree_plan_uw_id_fkey R

std_degree_uw_id_fkey R

degree_id

quest_degree_id

2147483647

std_degree_honour.degree_id	std_degree_honour_uw_id_fkey R
std_degree_plan.degree_id	std_degree_plan_uw_id_fkey R

degree_code

text

2147483647

pps_degree.degree_code

std_degree_degree_code_fkey R

career_code

quest_career

2147483647

completion_term_id

quest_term_id

2147483647

degree_conferral_date

date

degree_revoked

bool

Table contained 69,572 rows at Wed Feb 19 10:30 EST 2014

Indexes:

Column(s)	Type	Sort	Constraint Name
uw_id + degree_id	Primary key	Asc/Asc	std_degree_pkey