SchemaSpy - Table odyssey_test._quest.pps_plan

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

plan_code

text

2147483647

pps_subplan_history.plan_code	pps_subplan_history_plan_code_fkey R
std_degree_plan.plan_code	std_degree_plan_plan_code_fkey R
std_plan_history.plan_code	Implied Constraint R
std_program_plan_milestone.plan_code	std_program_plan_milestone_plan_code_fkey R
std_term_plan.plan_code	std_term_plan_plan_code_fkey R
std_term_plan_gpa.plan_code	Implied Constraint R
std_term_plan_plus.plan_code	Implied Constraint R
std_term_subplan_gpa.plan_code	Implied Constraint R
std_transfer_credit_school.plan_code	Implied Constraint R

pps_plan_history.plan_code

pps_plan_plan_code_fkey R

plan_as_of

date

13

pps_plan_history.plan_as_of

pps_plan_plan_code_fkey R

plan_active

bool

1

plan_title

text

2147483647

plan_short_title

text

2147483647

plan_comment

text

2147483647

√

null

plan_diploma_description

text

2147483647

√

null

plan_transcript_description

text

2147483647

degree_code

text

2147483647

√

null

pps_degree.degree_code

pps_plan_degree_code_fkey R

program_code

text

2147483647

√

null

pps_program.program_code

pps_plan_program_code_fkey R

career_code

quest_career

2147483647

√

null

unit_code

text

2147483647

uw_unit.unit_code

pps_plan_unit_code_fkey R

plan_type_code

text

2147483647

first_valid_term_id

quest_term_id

2147483647

√

null

uw_term.term_id

pps_plan_first_valid_term_id_fkey R

last_admit_term_id

quest_term_id

2147483647

√

null

uw_term.term_id

pps_plan_last_admit_term_id_fkey R

Table contained 2,217 rows at Wed Feb 19 10:30 EST 2014

Indexes:

Column(s)	Type	Sort	Constraint Name
plan_code	Primary key	Asc	pps_plan_pkey