Cohort Rule Collections Table Schema (cohort_rule_collections)


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 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 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