app_course

1 rows


Description

Central course table

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_course_id_seq'::regclass)
app_badge.courseid Defined in XMLR
app_course_completion_history.courseid Defined in XMLR
app_course_format_options.courseid Defined in XMLR
app_dp_plan_course_assign.courseid Defined in XMLR
app_enrol.courseid Defined in XMLR
app_enrol_flatfile.courseid Defined in XMLR
app_facetoface.course Defined in XMLR
app_facetoface_notification.courseid Defined in XMLR
app_grade_categories.courseid Defined in XMLR
app_grade_categories_history.courseid Defined in XMLR
app_grade_items.courseid Defined in XMLR
app_grade_items_history.courseid Defined in XMLR
app_grade_outcomes.courseid Defined in XMLR
app_grade_outcomes_courses.courseid Defined in XMLR
app_grade_outcomes_history.courseid Defined in XMLR
app_grade_settings.courseid Defined in XMLR
app_groupings.courseid Defined in XMLR
app_groups.courseid Defined in XMLR
app_prog_completion_history.recurringcourseid Defined in XMLR
app_prog_courseset_course.courseid Defined in XMLR
app_prog_recurrence.currentcourseid Defined in XMLR
app_prog_recurrence.nextcourseid Defined in XMLR
app_scale_history.courseid Defined in XMLR
app_workshop.course Defined in XMLR
category int8 19 0
sortorder int8 19 0
fullname varchar 254 ''::character varying
shortname varchar 255 ''::character varying
idnumber varchar 100 ''::character varying
summary text 2147483647 √ null
summaryformat int2 5 0
format varchar 21 'topics'::character varying
showgrades int2 5 1
newsitems int4 10 1
startdate int8 19 0
marker int8 19 0
maxbytes int8 19 0
legacyfiles int2 5 0
showreports int2 5 0
visible int2 5 1
visibleold int2 5 1
groupmode int2 5 0
groupmodeforce int2 5 0
defaultgroupingid int8 19 0
lang varchar 30 ''::character varying
calendartype varchar 30 ''::character varying
theme varchar 50 ''::character varying
timecreated int8 19 0
timemodified int8 19 0
requested int2 5 0
enablecompletion int2 5 0
completionstartonenrol int2 5 0
completionprogressonview int2 5 0
completionnotify int2 5 0
audiencevisible int2 5 2
cacherev int8 19 0
coursetype int2 5 √ null
icon varchar 255 √ null

Indexes

Constraint Name Type Sort Column(s)
app_cour_id_pk Primary key Asc id
app_cour_cat_ix Performance Asc category
app_cour_idn_ix Performance Asc idnumber
app_cour_sho_ix Performance Asc shortname
app_cour_sor_ix Performance Asc sortorder

Relationships

Close relationships within degrees of separation