Task
Purpose
Contains a list of tasks.
Diagram of relationships between routing tables
List of columns
| Key | Name | Type | Required | Description |
| PK | Id | int | yes | Identifier of a task. |
| BatchId | int | no | Batch identifier. Corresponds to the entry identifier in the Batch table. | |
| EditSessionId | int | yes | Identifier of the editing session. Is the same as the record identifier in the EditSession table | |
| Attributes | int | yes | Flags that describe a task's status. | |
| Comment | nvarchar | no | Comment on a task. | |
| CreationDate | datetime | yes | Date and time of the creation of a task. | |
| CreatorId | int | yes | Identifier of the user that created a task. | |
| IsManuallyCreated | bit | yes | Indicates that a task was created by an Operator. | |
| IterationCounter | int | yes | Not used. | |
| ModificationDate | datetime | yes | Date and time of the last status change of a task. | |
| PostponedTaskOwner | int | no | Identifier of the user that postponed the dask. Is the same as the record identifier in the Principal table. | |
| Priority | int | yes | Priority of a task. Possible values are listed in the Priority table. | |
| ProcessingStageId | int | yes | Identifier of the processing stage during which a task was created. Corresponds to an entry identifier in the ProcessingStage table. | |
| Progress | int | yes | Not used. | |
| ProhibitedUserId | int | yes | Identifier of a user or user group that is prohibited from processing a task. | |
| ProjectId | int | yes | Project identifier. | |
| State | int | yes | Status of a task. Possible values are listed in the Task Status table. | |
| UserId | int | no | Identifier of a user or user group to whom the task was assigned. Corresponds to an entry identifier in the Principal table. |
4/12/2024 6:16:01 PM