Task Related Entities

Table 10.1. Task

Field Description Null Foreign Key

id The primary key of the task identity

priority The priority of the task

allowedtodelegate The group this task

may be delegated to

status The status of the task

previousstatus The previous status of the task

actualowner_id The ID of the

organizational entity who owns the task

createdby_id The ID of the

organizational entity who created the task

createdon The timestamp describing when this task was created

activationtim e The timestamp describing when this task was activated

expirationtim e The timestamp describing when this task will expire

skipable Whether or not this task may be skipped

workitem id The ID of the work item associated with this task (see jBPM core schema)

processinstanceid The ID of the process instance associated with this task (see jBPM core schema)

docum entaccesstyp e

How a document associated with the task can be accessed

docum enttype The type of data in the document

docum entcontentid The ID of the content

entity containing the document data

outputaccesstype How the output document associated with the task can be accessed

outputtype The type of data in the output document

outputcontentid The ID of the content entity containing the output document data

faultnam e The name of the fault generated, if a fault occurs

faultaccesstype How the document associated with the fault can be accessed

faulttype The type of data in the fault document

faultcontentid The ID of the content entity containing the fault document data

parentid This is the ID of the parent task

processid The name (ID) of the associated process

processsessionid The ID of the

associated (knowledge) session

taskinitiator_id The ID of the

organizational entity who created the task

The subtasksstrategy entity is used to save the strategy that describes how parent and sub-tasks should react when either parent or sub-tasks are ended.

Table 10.2. SubTasksStrategy

Field Description Null Foreign Key

id The primary key

dtype A discriminator column

nam e The name of the

strategy

task_id The primary key of the associated task

The organizationalentity entity is extended to represent the different people assignments that are part of the task.

Table 10.3. OrganizationalEntity

Field Description Null

id The primary key

dtype The discriminator column

The attachment entity describes attachments that have been added to the task.

Table 10.4 . Attachment

Field Description Null Foreign Key

id The primary key

nam e The (file) name of the attachment

accesstype How the attachment can be accessed

attachedat When the attachment was attached to the task

attachm ent_size The size (in bytes) of the attachment

attachm entcontent id

The ID of the content entity storing the raw data of the attachment

contenttype The MIME type of the attachment data

attachedby_id The ID of the

organizationalent ity entity that attached

the attachment

taskdata_attachm e nts_id

The ID of the task entity to which this attachment belongs

Table 10.5. task_comment

Field Description Null Foreign Key

id The primary key

addedat The timestamp of when the comment was added to the task

text The text of the comment

addedby_id The primary key of the associated

organizationalent ity entity

taskdata_com m ents _id

The primary key of the associated task entity

The delegation_delegates table is a join table for relationships between the task entity and the

organizationalentity.

Table 10.6. delegation_delegates

Field Description Null Foreign Key

task_id The primary key of the associated task

entity_id The primary key of the associated

organizationalent ity

The peopleassignments_stakeholders table is a join table that describes which

organizationalentity entities are task stakeholders of a particular task. Table 10.7. peopleassignments_stakeholders

Field Description Null Foreign Key

task_id The primary key of the associated task entity

entity_id The primary key of the associated

organizationalent ity entity

The peopleassignments_potowners table is a join table that describes which

Table 10.8. peopleassignments_potowners

Field Description Null Foreign Key

task_id The primary key of the associated task entity

entity_id The primary key of the associated

organizationalent ity entity

The peopleassignments_exclowners table is a join table that describes which

organizationalentity entities are the excluded owners of a particular task. Table 10.9. peopleassignments_exclowners

Field Description Null Foreign Key

task_id The primary key of the associated task entity

entity_id The primary key of the associated

organizationalent ity entity

The peopleassignments_bas table is a join table that describes which organizationalentity entities are business administrators of a particular task.

Table 10.10. peopleassignments_bas

Field Description Null Foreign Key

task_id The primary key of the associated task entity

entity_id The primary key of the associated

organizationalent ity entity

The peopleassignments_recipients table is a join table that describes which

organizationalentity entities are notification recipients for a particular task. Table 10.11. peopleassignments_recipients

Field Description Null Foreign Key

task_id The primary key of the associated task entity

entity_id The primary key of the associated

organizationalent ity entity

Report a bug