Table odyssey_test._quest.std_program_plan_milestone Generated by
SchemaSpy
Legend: SourceForge.net
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_student.uw_id std_program_plan_milestone_uw_id_fkey R
career_code quest_career 2147483647  √  null
program_code text 2147483647
pps_program.program_code std_program_plan_milestone_program_code_fkey R
plan_code text 2147483647
pps_plan.plan_code std_program_plan_milestone_plan_code_fkey R
milestone_id int4 10
milestone_code text 2147483647
short_description text 2147483647
formal_description text 2147483647
milestone_title text 2147483647  √  null
milestone_complete quest_completion_code 2147483647
date_completed date 13  √  null
comments text 2147483647  √  null

Table contained 64,373 rows at Wed Feb 19 10:30 EST 2014

Indexes:
Column(s) Type Sort Constraint Name
uw_id + program_code + plan_code + milestone_id Primary key Asc/Asc/Asc/Asc std_program_plan_milestone_pkey

Close relationships  within of separation: