SchemaSpy - Table odyssey_test._quest.std_term

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_term_subplan.uw_id

std_term_subplan_uw_id_fkey R

std_term_program.uw_id

std_term_plan_uw_id_fkey R

term_id

quest_term_id

2147483647

std_term_subplan.term_id

std_term_subplan_uw_id_fkey R

std_term_program.term_id

std_term_plan_uw_id_fkey R

plan_code

text

2147483647

std_term_subplan.plan_code

std_term_subplan_uw_id_fkey R

pps_plan.plan_code

std_term_plan_plan_code_fkey R

plan_position

int4

requirement_term_id

quest_term_id

2147483647

degree_id

quest_degree_id

2147483647

√

null

Table contained 1,284,564 rows at Wed Feb 19 10:30 EST 2014

Indexes:

Column(s)	Type	Sort	Constraint Name
uw_id + term_id + plan_code	Primary key	Asc/Asc/Asc	std_term_plan_pkey
uw_id + term_id + plan_position	Must be unique	Asc/Asc/Asc	std_term_plan_uw_id_term_id_plan_position_key