Cohort Rulesets Table Schema (cohort_rulesets)


Description

Rulesets for dynamic cohorts

cohort_rulesets table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
cohort_rules.rulesetid cohorule_rul4_fk R
rulecollectionid BIGINT 19 null
cohort_rule_collections.id cohorule_rul3_fk R
name VARCHAR 255
operator BIGINT 19 null
sortorder BIGINT 19 √ null
timecreated BIGINT 19 null
timemodified BIGINT 19 null
modifierid BIGINT 19 null
user.id cohorule_mod3_fk R

Table contained -1 rows

cohort_rulesets table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
cohorule_mod_ix Performance Asc modifierid
cohorule_rul_ix Performance Asc rulecollectionid

cohort_rulesets table relationships

Close relationships within degrees of separation