Skip to end of metadata
Go to start of metadata
You are viewing an old version of this content. View the current version.
Compare with Current
View Version History
« Previous
Version 16
Next »
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.
Overview
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" |
|