Dp Plan Course Assign Table Schema (dp_plan_course_assign)


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