EN
Español
English
Português
    APMO_KANBAN_COLUMN

    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