course_completion_aggr_methd

0 rows


Description

Course completion aggregation methods for criteria

Columns

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

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

method BIT 1 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’

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

Relationships