AGILE_DATA_TEAMS

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 the agile teams information.

Foreign Keys

There are no foreign keys for this table.

Column Descriptions

Column Name

Null?

Data Type

Description

TEAM_ID

NOT NULL

VARCHAR2(100)

Team identifier

NAME

NULLABLE

VARCHAR2(2000)

Team name

TEAM_LEADER

NULLABLE

VARCHAR2(200)

Email address of the team leader

MEMBERS_CAPACITY

NULLABLE

NUMBER

The sum of the team members' capacity

NUM_OF_MEMBERS

NULLABLE

NUMBER

The number of the team members

ESTIMATED_VELOCITY

NULLABLE

NUMBER

The team's estimated velocity

INSTANCE_ID

NOT NULL

VARCHAR2(100)

Instance identifier

 

 

PROJECT_ID

NULLABLE

VARCHAR2(100)

Identifier of the project where the team is assigned to

 

Indexes

There are no indexes for this table.