SchemaSpy - Table odyssey_test._quest.pps

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

degree_code

text

2147483647

pps_plan.degree_code	pps_plan_degree_code_fkey R
pps_plan_history.degree_code	pps_plan_history_degree_code_fkey R
std_degree.degree_code	std_degree_degree_code_fkey R
std_term_plan_plus.degree_code	Implied Constraint R

pps_degree_history.degree_code

pps_degree_degree_code_fkey R

degree_as_of

date

pps_degree_history.degree_as_of

pps_degree_degree_code_fkey R

degree_active

bool

degree_full_title

text

2147483647

degree_title

text

2147483647

degree_short_title

text

2147483647

degree_years

int4

degree_level

text

2147483647

√

null

degree_internal

bool

Table contained 204 rows at Wed Feb 19 10:30 EST 2014

Indexes:

Column(s)	Type	Sort	Constraint Name
degree_code	Primary key	Asc	pps_degree_pkey