expressions


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
expressions.parent_exp_id Defined in XMLR
deleted BIT 1 √ 0
date_entered DATETIME 19 √ null
date_modified DATETIME 19 √ null
modified_user_id CHAR 36 √ null
created_by CHAR 36 √ null
lhs_type VARCHAR 15 √ null
lhs_field VARCHAR 50 √ null
lhs_module VARCHAR 50 √ null
lhs_value VARCHAR 100 √ null
lhs_group_type VARCHAR 10 √ null
operator VARCHAR 15 √ null
rhs_group_type VARCHAR 10 √ null
rhs_type VARCHAR 15 √ null
rhs_field VARCHAR 50 √ null
rhs_module VARCHAR 50 √ null
rhs_value VARCHAR 255 √ null
parent_id CHAR 36 null
workflow_alerts.id Defined in XMLR
workflow_triggershells.id Defined in XMLR
workflow_actionshells.id Defined in XMLR
exp_type VARCHAR 100 √ null
exp_order INT 10 √ null
parent_type VARCHAR 255 √ null
parent_exp_id CHAR 36 √ null
expressions.id Defined in XMLR
parent_exp_side INT 10 √ null
ext1 VARCHAR 50 √ null
ext2 VARCHAR 50 √ null
ext3 VARCHAR 50 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_exp Performance Asc/Asc parent_id + deleted

Relationships

Close relationships within degrees of separation