Data Model

The KADAI data model is built around three core business entities — Task, Workbasket, and Classification — with supporting structures for access control, user management, job scheduling, and audit history.

Overview

Core Entities

Task, Workbasket & Classification

Task Sub-Entities

Access Control

User Management

System & Scheduling

Audit History

Entity Descriptions

Entity	Description
TASK	The central entity representing a unit of work. Holds all business data including state, priority, owner, timestamps, and up to 16 string and 8 integer custom fields.
WORKBASKET	A container that organizes Tasks. Can be a personal or group basket. Supports organizational hierarchy via ORG_LEVEL_* fields.
CLASSIFICATION	Hierarchical taxonomy for categorizing Tasks and Attachments. Defines the service level (SLA) and drives priority calculations.
ATTACHMENT	A secondary object reference attached to a Task, with its own Classification and object reference fields.
OBJECT_REFERENCE	An additional external-system reference on a Task (beyond the primary object reference embedded in TASK).
TASK_COMMENT	A user-created note appended to a Task. Deleted automatically when the parent Task is deleted.
WORKBASKET_ACCESS_LIST	Defines which users or groups can access a Workbasket and which operations they are permitted to perform.
DISTRIBUTION_TARGETS	Maps a source Workbasket to one or more target Workbaskets for Task distribution.
USER_INFO	Stores user profile data including contact details and organizational hierarchy levels.
GROUP_INFO	Maps a user to a group, enabling group-based Workbasket access.
PERMISSION_INFO	Maps a user to a named permission used for fine-grained access decisions.
SCHEDULED_JOB	Tracks background jobs (e.g. cleanup, priority recalculation) managed by the KADAI job framework.
CONFIGURATION	Single-row system configuration record, including the ENFORCE_SECURITY flag.
KADAI_SCHEMA_VERSION	Records the current schema version for migration management.
TASK_HISTORY_EVENT	Immutable audit log entry for every state change or modification on a Task.
WORKBASKET_HISTORY_EVENT	Immutable audit log entry for every change to a Workbasket.
CLASSIFICATION_HISTORY_EVENT	Immutable audit log entry for every change to a Classification.