Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for the automation rule |
|
| Name | nvarchar | 510 | null |
|
|
Rule name - Descriptive name of the automation rule |
||
| Description | nvarchar | 1073741823 | √ | null |
|
|
Rule description - Detailed description of what the automation rule does |
|
| DataSourceID | uniqueidentifier | 16 | √ | null |
|
|
Data source identifier - Links to the data source this rule operates on |
|
| Status | int | 4 | √ | null |
|
|
Rule status - Current status of the automation rule (Active, Inactive, Testing, etc.) |
|
| Criteria | nvarchar | 1073741823 | √ | null |
|
|
Rule criteria - Conditions that must be met for the rule to trigger |
|
| TriggerType | int | 4 | √ | null |
|
|
Trigger type - Type of event that triggers the rule (Data Change, Schedule, Manual, etc.) |
|
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation date - Date when the automation rule was created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - User ID of the person who created the rule |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Update date - Date when the automation rule was last modified |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - User ID of the person who last modified the rule |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Date when the rule was deleted (soft delete) |
|
| FormId | int | 4 | √ | null |
|
|
Form identifier - Links to specific form if rule is form-related |
|
| Rules | nvarchar | 1073741823 | √ | null |
|
|
Rule definition - Detailed rule logic and actions to be performed |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_AutomationRules | Primary key | Asc | ID |
Relationships
Close relationships within degrees of separation
