Hierarchical backlog work items (Epic, Feature, UserStory, Task, Bug) with parent auto-reference
Data model
Fields
| Field | Type | Description |
|---|---|---|
| acceptance_criteria | NVARCHAR (MAX) | Work item acceptance criteria |
| assigned_to | INT | ASMS user assigned (AFW_USERS.user_id, no physical FK to core) |
| backlog_order* | INT | Order of the item within the backlog |
| block_reason | NVARCHAR (MAX) | Reason for the block |
| business_value | INT | Business value of the work item |
| description | NVARCHAR (MAX) | Detailed description of the work item |
| due_date | DATE | Work item commitment date |
| estimated_hours* | DECIMAL | Estimated hours (0 = unestimated) |
| is_active* | BIT | Logical Deletion: 1 = Active Record, 0 = Retired |
| is_blocked* | BIT | Indicates if the item is locked |
| parent_work_item_id | UNIQUEIDENTIFIER | Parent Work Item in Hierarchy (NULL = root level) |
| priority_id* | UNIQUEIDENTIFIER | Work item priority (module catalog GUID, type Priority) |
| project_id* | UNIQUEIDENTIFIER | Project to which the work item belongs |
| remaining_hours | DECIMAL | Hours remaining to complete the item |
| start_date | DATE | Planned start date (Gantt view) |
| status_id* | UNIQUEIDENTIFIER | Work item status (module catalog GUID, type WorkItemStatus) |
| story_points | INT | Estimated Story Points |
| title* | VARCHAR (300) | Title of the work item |
| work_item_code* | VARCHAR (50) | Unique work item code |
| work_item_id* | UNIQUEIDENTIFIER | Unique identifier of the work item |
| work_item_type_id* | VARCHAR (20) | Canonical type of the work item: Epic, Feature, UserStory, Task, or Bug |
Primary Key
| PK_APMO_WORK_ITEM |
|---|
| work_item_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| parent_work_item_id | dbo.APMO_WORK_ITEM | work_item_id | FK02_APMO_WORK_ITEM |
| project_id* | dbo.APMO_PROJECT | project_id | FK01_APMO_WORK_ITEM |