uw_group


Description

An academic group (faculty, affiliated college, or other group), as of the most recent update to that group in uw_group_history

Columns

Column Type Size Nulls Auto Default Children Parents Comments
group_code text 2147483647 null
work_application_instance.group_code work_application_instance_group_code_fkeyR
teaching_admin_group.group_code teaching_admin_group_group_code_fkeyR
cal_course_label_history.group_code cal_course_label_history_group_code_fkeyR
off_course_section_complete.group_code Implied ConstraintR
off_course_section_plus.group_code Implied ConstraintR
pps_program.group_code pps_program_group_code_fkeyR
pps_program_history.group_code pps_program_history_group_code_fkeyR
std_term_course_plus.group_code Implied ConstraintR
uw_unit.group_code uw_unit_group_code_fkeyR
uw_unit_history.group_code uw_unit_history_group_code_fkeyR
uw_group_history.group_code uw_group_group_code_fkeyR
group_as_of date 13 null
uw_group_history.group_as_of uw_group_group_code_fkeyR
group_active bool 1 null
group_quest_name text 2147483647 null

Table contained 14 rows

Indexes

Constraint Name Type Sort Column(s)
uw_group_pkey Primary key Asc group_code

Relationships

Close relationships within degrees of separation