off_association


Columns

Column Type Size Nulls Auto Default Children Parents Comments
term_id "_quest"."quest_term_id" 2147483647 null
off_course_section.term_id off_course_section_term_id_fkey1R
off_course_as_of.term_id off_association_term_id_fkeyR
course_id "_quest"."quest_course_id" 2147483647 null
off_course_section.course_id off_course_section_term_id_fkey1R
off_course_as_of.course_id off_association_term_id_fkeyR
label_seq int4 10 null
off_course_section.label_seq off_course_section_term_id_fkey1R
session_code "_quest"."quest_session" 2147483647 null
off_course_section.session_code off_course_section_term_id_fkey1R
association_id int4 10 null
off_course_section.association_id off_course_section_term_id_fkey1R
course_take_units numeric 5,2 null
course_ap_units numeric 5,2 null
grade_basis_code text 2147483647 null
requirement_designation text 2147483647 √ null
component_code text 2147483647 null
cal_component.component_code off_association_component_code_fkeyR
primary_component_code text 2147483647 √ null
cal_component.component_code off_association_primary_component_code_fkeyR

Table contained 298055 rows

Indexes

Constraint Name Type Sort Column(s)
off_association_pkey Primary key Asc/Asc/Asc/Asc/Asc term_id + course_id + label_seq + session_code + association_id

Relationships

Close relationships within degrees of separation