EN
Español
English
Português
    APMO_SPRINT_ITEM

    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