app_course

0 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_approval.course Defined in XML R
app_approval_workflow.course_id Defined in XML R
app_badge.courseid Defined in XML R
app_competency_coursecomp.courseid Defined in XML R
app_competency_coursecompsetting.courseid Defined in XML R
app_course_completion_defaults.course Defined in XML R
app_course_completion_history.courseid Defined in XML R
app_course_completion_log.courseid Defined in XML R
app_course_format_options.courseid Defined in XML R
app_course_info_data.courseid Defined in XML R
app_dp_plan_course_assign.courseid Defined in XML R
app_enrol.courseid Defined in XML R
app_enrol_flatfile.courseid Defined in XML R
app_enrol_paypal.courseid Defined in XML R
app_facetoface.course Defined in XML R
app_facetoface_notification.courseid Defined in XML R
app_grade_categories.courseid Defined in XML R
app_grade_categories_history.courseid Defined in XML R
app_grade_items.courseid Defined in XML R
app_grade_items_history.courseid Defined in XML R
app_grade_outcomes.courseid Defined in XML R
app_grade_outcomes_courses.courseid Defined in XML R
app_grade_outcomes_history.courseid Defined in XML R
app_grade_settings.courseid Defined in XML R
app_groupings.courseid Defined in XML R
app_groups.courseid Defined in XML R
app_lti_tool_settings.course Defined in XML R
app_ltiservice_gradebookservices.courseid Defined in XML R
app_prog_completion_history.recurringcourseid Defined in XML R
app_prog_courseset_course.courseid Defined in XML R
app_prog_recurrence.currentcourseid Defined in XML R
app_prog_recurrence.nextcourseid Defined in XML R
app_scale_history.courseid Defined in XML R
app_tool_recyclebin_course.courseid Defined in XML R
app_totara_connect_client_courses.courseid Defined in XML R
app_totara_core_course_vis_map.courseid Defined in XML R
app_totara_mobile_compatible_courses.courseid Defined in XML R
app_workshop.course Defined in XML R
app_workspace.course_id Defined in XML R
app_workspace_discussion.course_id Defined in XML R
app_workspace_member_request.course_id Defined in XML R
app_workspace_off_notification.course_id Defined in XML R
category int8 19 0
sortorder int8 19 0
fullname varchar 1333 ''::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
enddate 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 0
icon varchar 255 √ null
containertype varchar 255 'container_course'::character varying
duedate int8 19 √ null
duedateoffsetamount int2 5 √ null
duedateoffsetunit int2 5 √ null

Indexes

Constraint Name Type Sort Column(s)
app_cour_id_pk Primary key Asc id
app_cour_aud_ix Performance Asc audiencevisible
app_cour_catsor_ix Performance Asc/Asc category + sortorder
app_cour_con_ix Performance Asc containertype
app_cour_idn_ix Performance Asc idnumber
app_cour_sho_ix Performance Asc shortname
app_cour_sor_ix Performance Asc sortorder
app_cour_tim2_ix Performance Asc timemodified
app_cour_tim_ix Performance Asc timecreated

Relationships

Close relationships within degrees of separation