adm_std_academic_course


Description

A course obtained from a previous institution by an applicant

Columns

Column Type Size Nulls Auto Default Children Parents Comments
uw_id "_quest"."quest_uw_id" 2147483647 null
ext_org_id "_quest"."quest_org_id" 2147483647 null
ext_career_code text 2147483647 null
ext_career_seq int4 10 null
ext_course_seq int4 10 null
ext_course_type_code text 2147483647 null
uw_ext_course_type.ext_course_type_code adm_std_academic_course_ext_course_type_code_fkeyR
begin_date date 13 √ null
uw_date.date Implied ConstraintR
end_date date 13 √ null
uw_date.date Implied ConstraintR
ext_term_type_code text 2147483647 √ null
uw_ext_term_type.ext_term_type_code adm_std_academic_course_ext_term_type_code_fkeyR
student_take_units numeric 5,2 null
grading_basis_code text 2147483647 null
uw_grading_basis.grading_basis_code adm_std_academic_course_grading_basis_code_fkeyR
course_level_code text 2147483647 √ null
uw_course_level.course_level_code adm_std_academic_course_course_level_code_fkeyR
course_grade text 2147483647 null
school_course_number text 2147483647 null
ext_subject_code text 2147483647 null
uw_ext_subject.ext_subject_code adm_std_academic_course_ext_subject_code_fkeyR
ext_term_code text 2147483647 null
uw_ext_term.ext_term_code adm_std_academic_course_ext_term_code_fkeyR
term_year int4 10 null
course_description text 2147483647 null
ext_academic_level_code text 2147483647 √ null
uw_ext_academic_level.ext_academic_level_code adm_std_academic_course_ext_academic_level_code_fkeyR
last_update timestamp 29,6 √ null

Table contained 1746167 rows

Indexes

Constraint Name Type Sort Column(s)
adm_std_academic_course_pkey Primary key Asc/Asc/Asc/Asc/Asc uw_id + ext_org_id + ext_career_code + ext_career_seq + ext_course_seq

Relationships

Close relationships within degrees of separation