std_milestone


Columns

Column Type Size Nulls Auto Default Children Parents Comments
uw_id "_quest"."quest_uw_id" 2147483647 null
std_student.uw_id std_milestone_uw_id_fkeyR
program_code text 2147483647 null
pps_program.program_code std_milestone_program_code_fkeyR
milestone_order int4 10 null
plan_code text 2147483647 √ null
pps_plan.plan_code std_milestone_plan_code_fkeyR
milestone_code text 2147483647 null
pps_milestone.milestone_code std_milestone_milestone_code_fkeyR
milestone_title text 2147483647 √ null
milestone_complete "_quest"."quest_completion_code" 2147483647 null
date_completed date 13 √ null
milestone_comments text 2147483647 √ null

Table contained 796852 rows

Indexes

Constraint Name Type Sort Column(s)
std_milestone_pkey Primary key Asc/Asc/Asc uw_id + program_code + milestone_order

Relationships

Close relationships within degrees of separation