10.4. Human Task Persistence

10.4.1. Human Task Persistence

The model below is an entity relationship diagram (ERD) that shows the persistent entities used by the Human Task service.
Human Tasks Service data Model

Figure 10.1. Human Task Service Data Model

The data model above is organized around 2 groups of entities:
  • The task entity which represents the main information for a task. (See the right-hand side of the ERD above.)
  • The deadline, escalation, and notification entities represent deadlines and escalations for tasks and notifications associated with those deadlines. (See the left-hand side of the ERD above.)
Two other important entities in the data model are the i18ntext and organizationalentity.
  • The i18ntext entity is used to store text which may be language related, such as names or descriptions entered by users.
  • The organizationalentity entity represents a user.
The foreign key column in the tables in Section 10.4.2, “Task Related Entities” indicate whether or not a column in a database table has a foreign key constraint on it. The null column describes whether or not the database table column being describe can be null.
Please note, that if an entry is described as not allowing a null value and there is no associated entry, the column will contain the value -1 or 0.