std_term_course


Columns

Column Type Size Nulls Auto Default Children Parents Comments
uw_id "_quest"."quest_uw_id" 2147483647 null
std_term.uw_id std_term_course_uw_id_fkeyR
term_id "_quest"."quest_term_id" 2147483647 null
std_term.term_id std_term_course_uw_id_fkeyR
off_course.term_id std_term_course_term_id_fkeyR
class_id int4 10 null
off_course.class_id std_term_course_term_id_fkeyR
course_grade text 2147483647 √ null
earn_credit bool 1 null
include_in_gpa bool 1 null
requirement_designation text 2147483647 √ null
requirement_designation_grade text 2147483647 √ null
units_attempted_code "_quest"."quest_completion_code" 2147483647 null
grade_points numeric 9,3 null
student_take_units numeric 5,2 null
student_ap_units numeric 5,2 null
grading_basis text 2147483647 null
valid_attempt bool 1 √ null
grade_category text 2147483647 √ null
grade_submission_date date 13 √ null
uw_date.date Implied ConstraintR
transcript_note text 2147483647 √ null

Table contained 5969478 rows

Indexes

Constraint Name Type Sort Column(s)
std_term_course_pkey Primary key Asc/Asc/Asc uw_id + term_id + class_id
std_term_course_term_id_class_id_idx Performance Asc/Asc term_id + class_id

Relationships

Close relationships within degrees of separation