View Name
|
Description
|
Capability Attachment
|
Attachment information:
- [Attachment ID] INT NOT NULL PRIMARY KEY
- [Attachment Name] NVARCHAR(500) NULL
- [Attachment Size] BIGINT NULL
- [Attachment Type] NVARCHAR(MAX) NULL
- [Date Added] DATETIME NULL
- [FK Capability ID] INT NOT NULL
- [FK User Uploaded by ID] INT NOT NULL
|
Defect Attachment
|
Attachment information:
- [Attachment ID] INT NOT NULL PRIMARY KEY
- [Attachment Name] NVARCHAR(500) NULL
- [Attachment Size] BIGINT NULL
- [Attachment Type] NVARCHAR(MAX) NULL
- [Date Added] DATETIME NULL
- [FK Defect ID] INT NOT NULL
- [FK User Uploaded by ID] INT NOT NULL
|
Dependency Attachment
|
Attachment information:
- [Attachment ID] INT NOT NULL PRIMARY KEY
- [Attachment Name] NVARCHAR(500) NULL
- [Attachment Size] BIGINT NULL
- [Attachment Type] NVARCHAR(MAX) NULL
- [Date Added] DATETIME NULL
- [FK Dependency ID] INT NOT NULL
- [FK User Uploaded by ID] INT NOT NULL
|
Epic Attachment
|
Attachment information:
- [Attachment ID] INT NOT NULL PRIMARY KEY
- [Attachment Name] NVARCHAR(500) NULL
- [Attachment Size] BIGINT NULL
- [Attachment Type] NVARCHAR(MAX) NULL
- [Date Added] DATETIME NULL
- [FK Epic ID] INT NOT NULL
- [FK User Uploaded by ID] INT NOT NULL
|
Feature Attachment
|
Attachment information:
- [Attachment ID] INT NOT NULL PRIMARY KEY
- [Attachment Name] NVARCHAR(500) NULL
- [Attachment Size] BIGINT NULL
- [Attachment Type] NVARCHAR(MAX) NULL
- [Date Added] DATETIME NULL
- [FK Feature ID] INT NOT NULL
- [FK User Uploaded by ID] INT NOT NULL
|
Goal Attachment
|
Attachment information:
- [Attachment ID] INT NOT NULL PRIMARY KEY
- [Attachment Name] NVARCHAR(500) NULL
- [Attachment Size] BIGINT NULL
- [Attachment Type] NVARCHAR(MAX) NULL
- [Date Added] DATETIME NULL
- [FK Goal ID] INT NOT NULL
- [FK User Uploaded by ID] INT NOT NULL
|
Idea Attachment
|
Attachment information:
- [Attachment ID] INT NOT NULL PRIMARY KEY
- [Attachment Name] NVARCHAR(500) NULL
- [Attachment Size] BIGINT NULL
- [Attachment Type] NVARCHAR(MAX) NULL
- [Date Added] DATETIME NULL
- [FK Idea ID] INT NOT NULL
- [FK User Uploaded by ID] INT NOT NULL
|
Impediment Attachment
|
Attachment information:
- [Attachment ID] INT NOT NULL PRIMARY KEY
- [Attachment Name] NVARCHAR(500) NULL
- [Attachment Size] BIGINT NULL
- [Attachment Type] NVARCHAR(MAX) NULL
- [Date Added] DATETIME NULL
- [FK Impediment ID] INT NOT NULL
- [FK User Uploaded by ID] INT NOT NULL
|
Risk Attachment
|
Attachment information:
- [Attachment ID] INT NOT NULL PRIMARY KEY
- [Attachment Name] NVARCHAR(500) NULL
- [Attachment Size] BIGINT NULL
- [Attachment Type] NVARCHAR(MAX) NULL
- [Date Added] DATETIME NULL
- [FK Risk ID] INT NOT NULL
- [FK User Uploaded by ID] INT NOT NULL
|
Strategic Snapshot Attachment
|
Attachment information:
- [Attachment ID] INT NOT NULL PRIMARY KEY
- [Attachment Name] NVARCHAR(500) NULL
- [Attachment Size] BIGINT NULL
- [Attachment Type] NVARCHAR(MAX) NULL
- [Date Added] DATETIME NULL
- [FK Strategic Snapshot ID] INT NOT NULL
- [FK User Uploaded by ID] INT NOT NULL
|
Story Attachment
|
Attachment information:
- [Attachment ID] INT NOT NULL PRIMARY KEY
- [Attachment Name] NVARCHAR(500) NULL
- [Attachment Size] BIGINT NULL
- [Attachment Type] NVARCHAR(MAX) NULL
- [Date Added] DATETIME NULL
- [FK Story ID] INT NOT NULL
- [FK User Uploaded by ID] INT NOT NULL
|
Test Case Attachment
|
Attachment information:
- [Attachment ID] INT NOT NULL PRIMARY KEY
- [Attachment Name] NVARCHAR(500) NULL
- [Attachment Size] BIGINT NULL
- [Attachment Type] NVARCHAR(MAX) NULL
- [Date Added] DATETIME NULL
- [FK Test Case ID] INT NOT NULL
- [FK User Uploaded by ID] INT NOT NULL
|
Theme Attachment
|
Attachment information:
- [Attachment ID] INT NOT NULL PRIMARY KEY
- [Attachment Name] NVARCHAR(500) NULL
- [Attachment Size] BIGINT NULL
- [Attachment Type] NVARCHAR(MAX) NULL
- [Date Added] DATETIME NULL
- [FK Theme ID] INT NOT NULL
- [FK User Uploaded by ID] INT NOT NULL
|
Capability Rank Program
|
Program Rank for capabilities:
- [FK Capability ID] INT NOT NULL
- [FK Program ID] INT NOT NULL
- [Rank] INT NULL
- [Rank ID] INT NOT NULL PRIMARY KEY
|
Epic Rank Program
|
Program Rank for epics:
- [FK Epic ID] INT NOT NULL
- [FK Program ID] INT NOT NULL
- [Rank] INT NULL
- [Rank ID] INT NOT NULL PRIMARY KEY
|
Feature Rank Program
|
Program Rank for features:
- [FK Feature ID] INT NOT NULL
- [FK Program ID] INT NOT NULL
- [Rank] INT NULL
- [Rank ID] INT NOT NULL PRIMARY KEY
|
Hierarchy
|
Custom Hierarchy Table -- tree table containing custom hierarchy:
- [Custom Hierarchy ID] INT NOT NULL
- [Custom Hierarchy Name] NVARCHAR(MAX) NULL
- [FK Hierarchy Parent ID] INT NULL
- [FK User Owner ID] INT NOT NULL
- [Hierarchy Description] NVARCHAR(MAX) NOT NULL
- [Hierarchy ID] INT NOT NULL PRIMARY KEY
- [Hierarchy Level] INT NULL
- [Hierarchy Level Name] NVARCHAR(MAX) NULL
- [Hierarchy Name] NVARCHAR(MAX) NULL
- [Hierarchy Structure Path] HIERARCHYID NULL
|
MAP Hierarchy to Capability
|
Mapping table for a hierarchy to epic:
- [FK Epic ID] INT NOT NULL
- [FK Hierarchy ID] INT NOT NULL
- [MAP Hierarchy Epic ID] INT NOT NULL PRIMARY KEY
|
MAP Hierarchy to Feature
|
Mapping table for a hierarchy to feature:
- [FK Feature ID] INT NOT NULL
- [FK Hierarchy ID] INT NOT NULL
- [MAP Hierarchy Feature ID] INT NOT NULL PRIMARY KEY
|
MAP Hierarchy to Portfolio
|
Mapping table for a hierarchy to portfolio:
- [FK Portfolio ID] INT NOT NULL
- [FK Hierarchy ID] INT NOT NULL
- [MAP Hierarchy Portfolio ID] INT NOT NULL PRIMARY KEY
|
MAP Hierarchy to Program
|
Mapping table for a hierarchy to program:
- [FK Program ID] INT NOT NULL
- [FK Hierarchy ID] INT NOT NULL
- [MAP Hierarchy Program ID] INT NOT NULL PRIMARY KEY
|
MAP Hierarchy to Team
|
Mapping table for a hierarchy to team:
- [FK Team ID] INT NOT NULL
- [FK Hierarchy ID] INT NOT NULL
- [MAP Hierarchy Team ID] INT NOT NULL PRIMARY KEY
|
Skill
|
Master table for skill:
- [Skill Group Name] NVARCHAR(500) NULL
- [Skill ID] INT NOT NULL PRIMARY KEY
- [Skill Name] NVARCHAR(500) NULL
|
MAP User to Skill
|
Mapping table for user skills:
- [FK Skill ID] INT NOT NULL
- [FK User ID] INT NOT NULL
- [MAP User Skill ID] INT NOT NULL PRIMARY KEY
- [Skill Level] INT NULL
|
Sprint Discipline Time Fact
|
Time table for defect and discipline times entered in the sprint team meeting:
- [Program ID] INT NOT NULL
- [Team ID] INT NOT NULL
- [Date Created] DATETIME NULL
- [Date Time Recorded] DATETIME NULL
- [Discipline Name] NVARCHAR(200) NULL
- [Discipline Time Spent] FLOAT NULL
- [Done] INT NULL
- [FK Sprint ID] INT NOT NULL
- [FK User ID] INT NOT NULL
- [Sprint Discipline Time ID] INT NOT NULL PRIMARY KEY
|
Join the Atlassian Community!
The Atlassian Community is a unique, highly collaborative space where customers and Atlassians come together. Ask questions and get answers, start discussions, and collaborate with thousands of other Jira Align customers. Visit the Jira Align Community Collection today.
Need to contact Jira Align Support? Please open a support request.