ChecklistConditions


Description

Checklist conditional logic defining conditional rules and actions for dynamic checklist behavior. This table manages conditional logic that determines when checklist items should be shown, hidden, required, or automatically completed based on other checklist responses or system conditions.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ChecklistLevel nvarchar 200 null

Condition level - Level or scope where the condition applies
Action nvarchar 20 null

Condition action - Action to take when condition is met (Show, Hide, Require, Complete, etc.)
ChecklistItemIDs nvarchar 1073741823 √ null

Target items - List of checklist item IDs affected by this condition
ConditionLogic Unknown 0 null

Condition logic - Logical expression or rule that defines the condition
ConditionType Unknown 0 null

Condition type - Type of condition (Show, Hide, Require, Complete, etc.)
ConditionValue Unknown 0 null

Condition value - Value or threshold used in condition evaluation
ID int identity 4 √ null

Primary key - Unique identifier for each condition
fkChecklistID int 4 null

Checklist reference - Links to CheckList table for the checklist with conditions
Criteria nvarchar 1073741823 √ null

Condition criteria - Criteria or rules that trigger the condition
IsActive Unknown 0 null

Active status - Boolean flag indicating if the condition is currently active
Order int 4 √ null

Execution order - Order in which conditions are evaluated
pkConditionID Unknown 0 null

Primary key - Unique identifier for each condition
Priority Unknown 0 null

Condition priority - Priority order for evaluating multiple conditions

Indexes

Constraint Name Type Sort Column(s)
PK_ChecklistConditions Primary key Asc ID
IX_ChecklistID Performance Asc fkChecklistID

Relationships

Close relationships within degrees of separation