Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each automation rule, auto-incrementing integer |
|
| Name | nvarchar | 510 | null |
|
|
Rule name - Human-readable name for the automation rule used in administration (required field) |
||
| Description | nvarchar | 1073741823 | √ | null |
|
|
Rule description - Detailed explanation of what the rule does and when it executes |
|
| DataSourceID | uniqueidentifier | 16 | √ | null |
|
|
Data source reference - Unique identifier linking to data source that triggers or provides data for the rule |
|
| Status | int | 4 | √ | null |
|
|
Rule status - Current status of the rule (e.g., Active, Inactive, Testing) controlling execution |
|
| Criteria | nvarchar | 1073741823 | √ | null |
|
|
Execution criteria - JSON or structured definition of conditions that must be met for rule execution |
|
| TriggerType | int | 4 | √ | null |
|
|
Trigger mechanism - Type of event or condition that initiates rule execution (e.g., Data Change, Schedule, Manual) |
|
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation timestamp - When the automation rule was first created for audit trail |
|
| CreatedBy | int | 4 | √ | null |
|
|
Creator user ID - Reference to user who created the rule for accountability |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Last modification timestamp - Most recent update to rule configuration |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Last modifier user ID - Reference to user who made the most recent update |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Soft delete timestamp - When rule was logically deleted while preserving configuration history |
|
| FormId | int | 4 | √ | null |
|
|
Associated form - Optional reference to form that triggers or is affected by this rule |
|
| Rules | nvarchar | 1073741823 | √ | null |
|
|
Rule definition - JSON or structured definition of actions and logic executed by the automation rule |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_AutomationRules | Primary key | Asc | ID |