pps_program_history


Columns

Column Type Size Nulls Auto Default Children Parents Comments
program_code text 2147483647 null
pps_program.program_code pps_program_program_code_fkeyR
program_as_of date 13 null
pps_program.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_history_group_code_fkeyR
unit_code text 2147483647 null
uw_unit.unit_code pps_program_history_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_history_first_valid_term_id_fkeyR

Table contained 376 rows

Indexes

Constraint Name Type Sort Column(s)
pps_program_history_pkey Primary key Asc/Asc program_code + program_as_of

Relationships

Close relationships within degrees of separation