course_completion_aggr_methd

Columns

Related columns Constraint Comments

Search:

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’

Showing 1 to 5 of 5 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
courcompaggrmeth_cou2_ix	Performance	Asc	course
courcompaggrmeth_coucri2_uix	Must be unique	Asc/Asc	course + criteriatype
courcompaggrmeth_cri2_ix	Performance	Asc	criteriatype

Showing 1 to 4 of 4 entries

Description

Columns

Indexes

Relationships

Close relationships within degrees of separation