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

program_code

text

2147483647

pps_plan.program_code	pps_plan_program_code_fkey R
pps_plan_history.program_code	pps_plan_history_program_code_fkey R
std_program_history.program_code	std_program_history_program_code_fkey R
std_program_milestone.program_code	std_program_milestone_program_code_fkey R
std_program_plan_milestone.program_code	std_program_plan_milestone_program_code_fkey R
std_term.standing_program_code	std_term_standing_program_code_fkey R
std_term_plan_plus.program_code	Implied Constraint R
std_term_program.program_code	std_term_program_program_code_fkey R
std_term_program_plus.program_code	Implied Constraint R
std_transfer_credit_school.program_code	Implied Constraint R

pps_program_history.program_code

pps_program_program_code_fkey R

program_as_of

date

pps_program_history.program_as_of

pps_program_program_code_fkey R

program_active

bool

program_title

text

2147483647

program_short_title

text

2147483647

career_code

quest_career

2147483647

group_code

text

2147483647

uw_group.group_code

pps_program_group_code_fkey R

unit_code

text

2147483647

uw_unit.unit_code

pps_program_unit_code_fkey R

level_load_rule_code

text

2147483647

first_valid_term_id

quest_term_id

2147483647

√

null

uw_term.term_id

pps_program_first_valid_term_id_fkey R

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

Indexes:

Column(s)	Type	Sort	Constraint Name
program_code	Primary key	Asc	pps_program_pkey