Cohort Rules Table Schema (cohort_rules)


Description

Rules within a ruleset

cohort_rules table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
cohort_rule_params.ruleid cohorulepara_rul2_fk R
rulesetid BIGINT 19 null
cohort_rulesets.id cohorule_rul4_fk R
ruletype VARCHAR 255
name VARCHAR 255
sortorder BIGINT 19 √ null
timecreated BIGINT 19 null
timemodified BIGINT 19 null
modifierid BIGINT 19 null
user.id cohorule_mod4_fk R

Table contained -1 rows

cohort_rules table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
cohorule_mod2_ix Performance Asc modifierid
cohorule_rul2_ix Performance Asc rulesetid

cohort_rules table relationships

Close relationships within degrees of separation