Dp Plan Course Assign Table Schema (dp_plan_course_assign)


Description

Stores courses assigned to a particular plan

dp_plan_course_assign table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
planid BIGINT 19 null
dp_plan.id dpplancourassi_pla2_fk R

Identifies the plan this course is attached to
courseid BIGINT 19 null
course.id dpplancourassi_cou2_fk R

Identifies the course being assigned
priority BIGINT 19 √ null
dp_priority_scale_value.id dpplancourassi_pri2_fk R

Identifies the priority of this course within the current plan.
duedate BIGINT 19 √ null

Timestamp of the date this course is due to be completed.
approved SMALLINT 5 0

Indicates if the course has been accepted as part of a plan, or is awaiting approval.
reasonfordecision LONGTEXT 2147483647 √ null

The reason for approving/declining the request
completionstatus BIGINT 19 √ null
course_completions.id dpplancourassi_com2_fk R

Stores the course completion status at the moment the plan is marked as complete. Set to null before the plan is complete.
grade DECIMAL 10,5 √ null

Stores the course grade at the moment the plan is marked as complete. Set to null for active plans.
manual BIT 1 0

Was this assignment made manually

Table contained -1 rows

dp_plan_course_assign table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
dpplancourassi_com_ix Performance Asc completionstatus
dpplancourassi_cou_ix Performance Asc courseid
dpplancourassi_pla_ix Performance Asc planid
dpplancourassi_placou_uix Must be unique Asc/Asc planid + courseid
dpplancourassi_pri_ix Performance Asc priority

dp_plan_course_assign table relationships

Close relationships within degrees of separation