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 26 null
date_modified DATETIME 26 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_triggershells.id Defined in XMLR
workflow_alerts.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