AGILE_DATA_BACKLOG_ITEMS

Note: All the tables prefixed with AGILE_DATA store data of agile projects that are running in the agile tools such as ALM Octane and Atlassian JIRA.

This table stores backlog items information of agile projects.

Foreign Keys

There are no foreign keys for this table.

Column Descriptions

Column Name

Null?

Data Type

Description

BACKLOG_ITEM_ID

NOT NULL

VARCHAR2 (100)

Backlog item identifier

BACKLOG_TYPE

NULLABLE

VARCHAR2 (50)

Backlog item type

RANK

NULLABLE

NUMBER

Rank of the backlog item

NAME

NULLABLE

VARCHAR2 (2000)

Backlog item name

ASSIGN_TO

NULLABLE

VARCHAR2 (200)

Email address of the user that is assigned to the backlog item

STORY_POINTS

NULLABLE

NUMBER

Story points of the backlog item

STATUS

NULLABLE

VARCHAR2 (50)

Backlog item status

RELEASE_ID

NULLABLE

VARCHAR2 (100)

Identifier of the release where the backlog item belongs

TEAM_ID

NULLABLE

VARCHAR2 (100)

Identifier of the team to which the backlog item is assigned

EPIC_ID

NULLABLE

VARCHAR2 (100)

Identifier of the epic where the backlog item belongs

FEATURE_ID

NULLABLE

VARCHAR2 (100)

Identifier of the feature where the backlog item belongs

SPRINT_ID

NULLABLE

VARCHAR2 (100)

Identifier of the sprint where the backlog item belongs

AUTHOR

NULLABLE

VARCHAR2 (200)

Email address of the author of the backlog item

PRIORITY

NULLABLE

VARCHAR2 (50)

Priority of the backlog item

LAST_MODIFIED

NULLABLE

VARCHAR2 (200)

Date and time when the backlog was last modified

NUMBER_OF_TASKS

NULLABLE

NUMBER

Number of tasks the backlog item includes

DEFECT_STATUS

NULLABLE

VARCHAR2 (50)

 

INSTANCE_ID

NULLABLE

VARCHAR2 (100)

Identifier of instance where the backlog item exists

PROJECT_ID

NULLABLE

VARCHAR2 (100)

Identifier of the project where the backlog item belongs

SEVERITY

NULLABLE

VARCHAR2(50)

Severity of the backlog item

DETECTED_IN_RELEASE

NULLABLE

VARCHAR2(50)

Relase whenr the backlog item belongs

Indexes

There are no indexes for this table.