std_grad_supervisor


Description

Assignment of a graduate supervisor to a graduate student

Columns

Column Type Size Nulls Auto Default Children Parents Comments
uw_id "_quest"."quest_uw_id" 2147483647 null
std_grad_supervision_history.uw_id std_grad_supervisor_uw_id_fkeyR
supervisor_effective date 13 null
std_grad_supervision_history.supervisor_effective std_grad_supervisor_uw_id_fkeyR
supervisor_uw_id "_quest"."quest_uw_id" 2147483647 null
supervisor_seq int4 10 null

The position of the supervisor for this student
program_code text 2147483647 null
pps_program.program_code std_grad_supervisor_program_code_fkeyR

The program for which the supervisor is assigned
plan_code text 2147483647 √ null
pps_plan.plan_code std_grad_supervisor_plan_code_fkeyR

The plan for which the supervisor is assigned

Table contained 29040 rows

Indexes

Constraint Name Type Sort Column(s)
std_grad_supervisor_pkey Primary key Asc/Asc/Asc uw_id + supervisor_effective + supervisor_uw_id
std_grad_supervisor_supervisor_uw_id_idx Performance Asc supervisor_uw_id

Relationships

Close relationships within degrees of separation