Cohort Rule Collections Table Schema (cohort_rule_collections)


Description

Collections of rulesets & rules for a dynamic cohort

cohort_rule_collections table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
cohort_rulesets.rulecollectionid cohorule_rul3_fk R
cohortid BIGINT 19 null
cohort.id cohorulecoll_coh2_fk R
rulesetoperator TINYINT 3 0
addnewmembers BIT 1 1

Determines if members are added to the audience when they qualify
removeoldmembers BIT 1 1

Determines if members are removed when they no longer qualify for the audience.
status BIGINT 19 null
timecreated BIGINT 19 null
timemodified BIGINT 19 null
modifierid BIGINT 19 null
user.id cohorulecoll_mod2_fk R

Table contained -1 rows

cohort_rule_collections table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
cohorulecoll_coh_ix Performance Asc cohortid
cohorulecoll_mod_ix Performance Asc modifierid

cohort_rule_collections table relationships

Close relationships within degrees of separation