Course Completion Aggr Methd Table Schema (course_completion_aggr_methd)


Description

Course completion aggregation methods for criteria

course_completion_aggr_methd table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
course BIGINT 19 0
course.id coursecomplaggrmeth_cou_fk R
criteriatype BIGINT 19 null

The criteria type we are aggregating, or NULL if complete course aggregation

method BIT 0 0

1 = all, 2 = any, 3 = fraction, 4 = unit

value DECIMAL 10,5 null

NULL = all/any, 0..1 for method 'fraction', > 0 for method 'unit'

Table contained -1 rows

course_completion_aggr_methd table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
courcompaggrmeth_cou_ix Performance Asc course
courcompaggrmeth_coucri_uix Must be unique Asc/Asc course + criteriatype
courcompaggrmeth_cri_ix Performance Asc criteriatype

course_completion_aggr_methd table relationships