pps_program


Columns

Column Type Size Nulls Auto Default Children Parents Comments
program_code text 2147483647 null
adm_appl_program.program_code adm_appl_program_program_code_fkeyR
adm_appl_program_history.program_code adm_appl_program_history_program_code_fkeyR
pps_plan.program_code pps_plan_program_code_fkeyR
pps_plan_history.program_code pps_plan_history_program_code_fkeyR
std_grad_supervisor.program_code std_grad_supervisor_program_code_fkeyR
std_milestone.program_code std_milestone_program_code_fkeyR
std_program_history.program_code std_program_history_program_code_fkeyR
std_term.standing_program_code std_term_standing_program_code_fkeyR
std_term_plan_plus.program_code Implied ConstraintR
std_term_program.program_code std_term_program_program_code_fkeyR
std_term_program_plus.program_code Implied ConstraintR
std_transfer_credit_school.program_code std_transfer_credit_school_program_code_fkeyR
std_transfer_credit_school_plus.program_code Implied ConstraintR
pps_program_history.program_code pps_program_program_code_fkeyR
program_as_of date 13 null
pps_program_history.program_as_of pps_program_program_code_fkeyR
program_active bool 1 null
program_title text 2147483647 null
program_short_title text 2147483647 null
career_code "_quest"."quest_career" 2147483647 null
group_code text 2147483647 null
uw_group.group_code pps_program_group_code_fkeyR
unit_code text 2147483647 null
uw_unit.unit_code pps_program_unit_code_fkeyR
level_load_rule_code text 2147483647 null
first_valid_term_id "_quest"."quest_term_id" 2147483647 √ null
uw_term.term_id pps_program_first_valid_term_id_fkeyR

Table contained 147 rows

Indexes

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

Relationships

Close relationships within degrees of separation