CUSTOMFORMRULEACTION

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
NUMID	int
RULEACTIONCOMPARISONCODE	tinyint		Default = 0
RULEACTIONCOMPARISON	nvarchar(6) (Computed)	yes	CASE [RULEACTIONCOMPARISONCODE] WHEN 0 THEN N'Equals' END
RULEACTIONVALUE1	nvarchar(255)		Default = ''
RULEACTIONVALUE2	nvarchar(255)		Default = ''
DATEADDED	datetime		Default = getdate()
DATECHANGED	datetime		Default = getdate()
TS	timestamp
TSLONG	bigint (Computed)	yes	CONVERT(bigint, TS)

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
FORMID	uniqueidentifier		CustomFormElement.Guid
RULEACTIONFIELDID	uniqueidentifier		CustomFormElement.Guid
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID
CUSTOMFORMFEEID	uniqueidentifier	yes	CUSTOMFORMFEE.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_CUSTOMFORMRULEACTION_DATEADDED	DATEADDED			yes
IX_CUSTOMFORMRULEACTION_DATECHANGED	DATECHANGED
IX_CUSTOMFORMRULEACTION_NUMID	NUMID	yes
PK_CUSTOMFORMRULEACTION	ID	yes	yes

Triggers

Trigger Name	Description
TR_CUSTOMFORMRULEACTION_AUDIT_UPDATE
TR_CUSTOMFORMRULEACTION_AUDIT_DELETE

Referenced by

Referenced by	Field
CUSTOMFORMRULETARGET	RULEACTIONID