Kanban board columns associated with a module workflow (order, WIP boundary, and color)
Data model
Fields
| Field | Type | Description |
|---|---|---|
| column_color | VARCHAR (20) | Column color (e.g. #RRGGBB) |
| column_name* | VARCHAR (100) | Column Name |
| column_order* | INT | Column order on the dashboard |
| is_active* | BIT | Logical Deletion: 1 = Active Record, 0 = Retired |
| kanban_column_id* | UNIQUEIDENTIFIER | Unique identifier of the Kanban column |
| status_id* | UNIQUEIDENTIFIER | Catalog status representing the column (module catalog GUID) |
| wip_limit | INT | WIP (work in progress) limit of the column; NULL = no limit |
| workflow_id* | UNIQUEIDENTIFIER | Workflow to which the column belongs |
Primary Key
| PK_APMO_KANBAN_COLUMN |
|---|
| kanban_column_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| workflow_id* | dbo.APMO_WORKFLOW | workflow_id | FK01_APMO_KANBAN_COLUMN |