The page documents the TO-BE data model. The model of the current release does not necessarily match this one as long as the first major release is under development.
...
| Drawio |
|---|
| baseUrl | https://taskana.atlassian.net/wiki |
|---|
| diagramName | TASKANA_DATA_MODEL |
|---|
| width | 1859 |
|---|
| zoom | 1 |
|---|
| pageId | 200572994 |
|---|
| lbox | 1 |
|---|
| height | 1243.5 |
|---|
| revision | 1314 |
|---|
|
Description of the tables and fields
Common
TASKANA_SCHEMA_VERSION
| COLUMN | TYPE | DESCRIPTION | EXAMPLE VALUE |
|---|
| ID | CHAR(40) | Unique ID |
|
| VERSION | VARCHAR(255) | The version of the TASKANA schema | 0.0.1 |
TaskService
TASK
| COLUMN | TYPE | DESCRIPTION | EXAMPLE VALUE |
|---|
| ID | CHAR(40) | Unique ID |
|
| CREATED | TIMESTAMP | The creation timestamp of the task in the system. | "2017-12-01 13:39:20" |
| CLAIMED | TIMESTAMP | The timestamp of the last claim-operation on the task |
|
| COMPLETED | TIMESTAMP | The timestamp of the completion of the task |
|
| MODIFIED | TIMESTAMP | Timestamp of the last modification of the task |
|
| PLANNED | TIMESTAMP | Planned start of the task.
The actual completion of the task should be between PLANNED and DUE. |
|
| DUE | TIMESTAMP | Timestamp when the task is due.
The actual completion of the task should be between PLANNED and DUE. |
|
| NAME | VARCHAR(1024) | The name of the task | "Inspect application" |
| DESCRIPTION | VARCHAR(4096) | The description of the task |
|
| PRIORITY | INT | The priority of the task |
|
| STATE | VARCHAR(20) | The state of the task. See (...) |
|
| CLASSIFICATION_ID | CHAR(40) | The classified type of the task. Reference the classifications in the ClassificationService. | "Approval" |
| WORKBASKET_ID | CHAR(40) | The workbasket id of the workbasket, the tasks resides in. | "CLAIM_INBOUND" |
| OWNER | VARCHAR(255) | The owner of the tasks. The owner is set upon claiming of the task. |
|
| PRIMARY_OBJ_REF_ID | CHAR(40) | The primary business object the task is associated with. Could be a customer, partner, contract, policy, and so on. The business object is referenced by an entry in the OBJECT_REFERENCE table |
|
| IS_READ | BOOLEAN | Indicator if the task has been read |
|
| IS_TRANSFERRED | BOOLEAN | Indicator if the task has been transferred |
|
| CUSTOM_ATTRIBUTES | BLOB | A container for all additional information on the task |
|
| CP_1 | VARCHAR(255) | A custom property with name "1" |
|
| CP_2 | VARCHAR(255) | A custom property with name "2" |
|
| CP_3 | VARCHAR(255) | A custom property with name "3" |
|
| CP_4 | VARCHAR(255) | A custom property with name "4" |
|
| CP_5 | VARCHAR(255) | A custom property with name "5" |
|
| CP_6 | VARCHAR(255) | A custom property with name "6" |
|
| CP_7 | VARCHAR(255) | A custom property with name "7" |
|
| CP_8 | VARCHAR(255) | A custom property with name "8" |
|
| CP_9 | VARCHAR(255) | A custom property with name "9" |
|
| CP_10 | VARCHAR(255) | A custom property with name "10" |
|
OBJECT_REFERENCE
| COLUMN | TYPE | DESCRIPTION | EXAMPLE VALUE |
|---|
| ID | CHAR(40) | Unique ID |
|
| COMPANY | VARCHAR(32) | The name of the company the referenced business object belongs to | "ABC" |
| SYSTEM | VARCHAR(32) | The name of the system containing the object | "XYZ_CLAIM_SYSTEM" |
| SYSTEM_INSTANCE | VARCHAR(32) | The instance of the system (to distinguish between multiple installations of the same system | "33" |
| TYPE | VARCHAR(32) | The type of the referenced business object | "CLAIM" |
| VALUE | VARCHAR(128) | The id of the referenced business object | "1234567" |
ATTACHMENT
| COLUMN | TYPE | DESCRIPTION | EXAMPLE VALUE |
|---|
| ID | CHAR(40) | Unique ID |
|
| TASK_ID | CHAR(40) | The task the attachment belongs to |
|
| CREATED | TIMESTAMP |
|
|
| MODIFIED | TIMESTAMP |
|
|
| CLASSIFICATION_ID | CHAR(40) | The classification of the attachment (if applicable) |
|
| REFERENCE_ID | CHAR(40) | The reference to the actual attachment (e.g. a reference to an archiving system) |
|
| CHANNEL | VARCHAR(64) | The channel through which the attachment has been received |
|
| RECEIVED | TIMESTAMP | The timestamp on which the attachment has been received. This must not match the creation timestamp if for example a physical document is received on Friday but entered in the system on Monday. |
|
| CUSTOM_PROPERTIES | BLOB | A container for all additional information on the attachment |
|
WorkbasketService
WORKBASKET
| COLUMN | TYPE | DESCRIPTION | EXAMPLE VALUE |
|---|
| ID | CHAR(40) | Unique ID |
|
| CREATED | TIMESTAMP | The creation timestamp of the workbasket in the system. | "2017-12-01 13:39:20" |
| MODIFIED | TIMESTAMP | Timestamp of the last modification of the workbasket |
|
| NAME | VARCHAR(255) | The name of the workbasket |
|
| DESCRIPTION | VARCHAR(255) | The description of the workbasket |
|
| OWNER | VARCHAR(255) | The owner of the workbasket. The owner is responsible for the on-time completion of all tasks in the workbasket. |
|
| CUSTOM_ATTRIBUTES | BLOB | A container for all additional information on the task |
|
| CP_1 | VARCHAR(255) | A custom property with name "1" |
|
| CP_2 | VARCHAR(255) | A custom property with name "2" |
|
| CP_3 | VARCHAR(255) | A custom property with name "3" |
|
| CP_4 | VARCHAR(255) | A custom property with name "4" |
|
| CP_5 | VARCHAR(255) | A custom property with name "5" |
|
| CP_6 | VARCHAR(255) | A custom property with name "6" |
|
| CP_7 | VARCHAR(255) | A custom property with name "7" |
|
| CP_8 | VARCHAR(255) | A custom property with name "8" |
|
WORKBASKET_ACCESS_LIST
| COLUMN | TYPE | DESCRIPTION | EXAMPLE VALUE |
|---|
| ID | CHAR(40) | Unique ID |
|
| WORKBASKET_ID | CHAR(40) | The workbasket |
|
| USER_ID | VARCHAR(255) |
|
|
| GROUP_ID | VARCHAR(255) |
|
|
| PERM_READ | BOOLEAN | The permission to read the information about the workbasket |
|
| PERM_OPEN | BOOLEAN | The permission to view the content (the tasks) of a workbasket |
|
| PERM_APPEND | BOOLEAN | The permission to add tasks to the workbasket (required for creation and tranferring of tasks) |
|
| PERM_TRANSFER | BOOLEAN | The permission to transfer tasks (out of the current workbasket) |
|
| PERM_DISTRIBUTE | BOOLEAN | The permission to distribute tasks from the workbasket |
|
| PERM_CUSTOM_1 | BOOLEAN |
|
|
| PERM_CUSTOM_2 | BOOLEAN |
|
|
| PERM_CUSTOM_3 | BOOLEAN |
|
|
| PERM_CUSTOM_4 | BOOLEAN |
|
|
| PERM_CUSTOM_5 | BOOLEAN |
|
|
| PERM_CUSTOM_6 | BOOLEAN |
|
|
| PERM_CUSTOM_7 | BOOLEAN |
|
|
| PERM_CUSTOM_8 | BOOLEAN |
|
|
DISTRIBUTION_TARGETS
| COLUMN | TYPE | DESCRIPTION | EXAMPLE VALUE |
|---|
| SOURCE_ID | CHAR(40) | The workbasket ID of the workbasket which serves as source for the distribution |
|
| TARGET_ID | CHAR(40) | The workbasket ID of the workbasket which serves as target for the distribution |
|
ClassificationService
CLASSIFICATION
| COLUMN | TYPE | DESCRIPTION | EXAMPLE VALUE |
|---|
| ID | CHAR(40) | Unique ID |
|
| PARENT_CLASSIFICATION_ID | CHAR(40) | The parent classification. Empty string ("") if this is a root classification. |
|
| CREATED | TIMESTAMP | The creation timestamp of the workbasket in the system. | "2017-12-01 13:39:20" |
| MODIFIED | TIMESTAMP | Timestamp of the last modification of the workbasket |
|
| NAME | VARCHAR(255) | The name of the classification |
|
| DESCRIPTION | VARCHAR(255) | The description of the classification |
|
| CP_1 | VARCHAR(255) | A custom property with name "1" |
|
| CP_2 | VARCHAR(255) | A custom property with name "2" |
|
| CP_3 | VARCHAR(255) | A custom property with name "3" |
|
| CP_4 | VARCHAR(255) | A custom property with name "4" |
|
| CP_5 | VARCHAR(255) | A custom property with name "5" |
|
| CP_6 | VARCHAR(255) | A custom property with name "6" |
|
| CP_7 | VARCHAR(255) | A custom property with name "7" |
|
| CP_8 | VARCHAR(255) | A custom property with name "8" |
|
...