Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkCheckListItemID | int identity | 4 | √ | null |
|
|
Checklist item primary key - Unique identifier for each checklist item |
|
| fkChecklistID | int | 4 | null |
|
|
Checklist reference - Links to CheckList table for the parent checklist |
||
| CheckListItemName | nvarchar | 1073741823 | √ | null |
|
|
Item name - Name or title of the checklist item |
|
| CheckListItemDesc | nvarchar | 1073741823 | √ | null |
|
|
Item description - Detailed description of the checklist item |
|
| CheckListItemType | nvarchar | 100 | √ | null |
|
|
Item type - Type of checklist item (Task, Document, Approval, etc.) |
|
| IsRequired | bit | 1 | √ | null |
|
|
Required flag - Indicates if this item is required for checklist completion |
|
| OrderBy | int | 4 | √ | null |
|
|
Sort order - Order in which this item appears in the checklist |
|
| Deleted | bit | 1 | √ | null |
|
|
Deleted flag - Indicates if this item has been deleted |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created this item |
|
| DateCreated | smalldatetime | 16 | √ | null |
|
|
Creation date - Date when this item was created |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated this item |
|
| DateUpdated | smalldatetime | 16 | √ | null |
|
|
Last update date - Date when this item was last updated |
|
| AssignedID | int | 4 | √ | null |
|
|
Assignment ID - Identifier for assignment configuration |
|
| AssignedUserID | int | 4 | √ | null |
|
|
Assigned user - UserID of the person assigned to complete this item |
|
| AutoComplete | bit | 1 | √ | null |
|
|
Auto complete flag - Indicates if this item can be automatically completed |
|
| isRequiredValue | bit | 1 | √ | null |
|
|
Required value flag - Indicates if a value is required for this item |
|
| isDueDateCalculation | bit | 1 | √ | null |
|
|
Due date calculation flag - Indicates if due date should be automatically calculated |
|
| DueDateValue | varchar | 100 | √ | null |
|
|
Due date value - Value used in due date calculation |
|
| DueDateDays | varchar | 50 | √ | null |
|
|
Due date days - Number of days for due date calculation |
|
| DueDateBAO | varchar | 50 | √ | null |
|
|
Due date BAO - Before/After/On indicator for due date calculation |
|
| DueDateSelectedField | int | 4 | √ | null |
|
|
Due date field reference - Field used as basis for due date calculation |
|
| isUserDueDate | bit | 1 | √ | null |
|
|
User due date flag - Indicates if user can set custom due date |
|
| ChoiceValue | varchar | 100 | √ | null |
|
|
Choice value - Value for choice-type checklist items |
|
| Query | varchar | 255 | √ | null |
|
|
Query - SQL query for dynamic checklist items |
|
| QueryColumns | varchar | 255 | √ | null |
|
|
Query columns - Columns to display from query results |
|
| ChoiceOption | varchar | 10 | √ | null |
|
|
Choice option - Option configuration for choice-type items |
|
| fkLibChecklistItemID | int | 4 | √ | null |
|
|
Library item reference - Links to library checklist item template |
|
| Custom | varchar | 100 | √ | null |
|
|
Custom configuration - Custom configuration settings for the item |
|
| DueDate | smalldatetime | 16 | √ | null |
|
|
Due date - Specific due date for this item |
|
| isRepeat | bit | 1 | √ | null |
|
|
Repeat flag - Indicates if this item repeats on a schedule |
|
| SystemDateType | varchar | 100 | √ | null |
|
|
System date type - Type of system date to use for calculations |
|
| ShowAsTask | bit | 1 | ((1)) |
|
|
Show as task flag - Indicates if this item should appear as a task |
||
| AssignedUsers | nvarchar | 1073741823 | √ | null |
|
|
Assigned users - List of users assigned to this item |
|
| AssignedTeams | nvarchar | 1073741823 | √ | null |
|
|
Assigned teams - List of teams assigned to this item |
|
| AssignedRoles | nvarchar | 1073741823 | √ | null |
|
|
Assigned roles - List of roles assigned to this item |
|
| IsPausePoint | bit | 1 | ((0)) |
|
|
Pause point flag - Indicates if workflow should pause at this item |
||
| IsNonApplicable | bit | 1 | √ | null |
|
|
Non-applicable flag - Indicates if this item can be marked as non-applicable |
|
| Reoccurs | bit | 1 | √ | ((0)) |
|
|
Reoccurs flag - Indicates if this item reoccurs periodically |
|
| DueDateDataSourceField | nvarchar | 1073741823 | √ | null |
|
|
Due date data source field - Field from data source used for due date calculation |
|
| DueDateDataSourceFieldConfig | nvarchar | 1073741823 | √ | null |
|
|
Due date data source config - Configuration for data source field used in due date calculation |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_CheckListFields | Primary key | Asc | pkCheckListItemID |
| IX_fkChecklistID | Performance | Asc/Asc | fkChecklistID + fkLibChecklistItemID |
| IX_ShowAsTask | Performance | Asc | ShowAsTask |
Relationships
Close relationships within degrees of separation
