Committed items in a sprint (sprint - work item relationship) with planning order and committed points
Data model
Fields
| Field | Type | Description |
|---|---|---|
| committed_points* | INT | Story points committed when planning |
| is_active* | BIT | Logical deletion: 1 = active log, 0 = retired (item returned to backlog) |
| sprint_id* | UNIQUEIDENTIFIER | Sprint to which the item commits |
| sprint_item_id* | UNIQUEIDENTIFIER | Unique identifier of the sprint relationship - work item |
| sprint_order* | INT | Planning order within the sprint |
| work_item_id* | UNIQUEIDENTIFIER | Work item committed in the sprint |
Primary Key
| PK_APMO_SPRINT_ITEM |
|---|
| sprint_item_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| sprint_id* | dbo.APMO_SPRINT | sprint_id | FK01_APMO_SPRINT_ITEM |
| work_item_id* | dbo.APMO_WORK_ITEM | work_item_id | FK02_APMO_SPRINT_ITEM |