Jira Align
Explore the interactive ERD
Table & Field Reference
dependency_link
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
dependency_id | Unknown | PKFK |
link | Unknown | |
name | Unknown |
dependency_story
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
dependency_id | Unknown | PKFK |
story_id | Unknown | FK |
dependency
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
depends_on_program_id | Unknown | FK |
depends_on_team_id | Unknown | FK |
epic_id | Unknown | FK |
feature_id | Unknown | FK |
release_id | Unknown | FK |
requesting_program_id | Unknown | FK |
requesting_team_id | Unknown | FK |
blocked | Unknown | |
blocked_reason | Unknown | |
capability_id | Unknown | |
commit_date | Unknown | |
committed | Unknown | |
committed_by_sprint_id | Unknown | |
committed_sync_sprint_id | Unknown | |
create_date | Unknown | |
created_by | Unknown | |
custom_fields | Unknown | |
delivered | Unknown | |
dependency_type | Unknown | |
depends_on_external_id | Unknown | |
description | Unknown | |
has_no_work | Unknown | |
is_blocked | Unknown | |
is_committed | Unknown | |
is_delivered | Unknown | |
is_proposed | Unknown | |
is_rejected | Unknown | |
is_response_blocked | Unknown | |
last_updated_by | Unknown | |
last_updated_date | Instant | |
needed_by | Unknown | |
needed_by_sprint_id | Unknown | |
no_work | Unknown | |
no_work_reason | Unknown | |
proposed | Unknown | |
rejected | Unknown | |
related_dependency_id | Unknown | |
response_blocked | Unknown | |
response_blocked_reason | Unknown | |
self | Unknown | |
status | Unknown | |
title | Unknown | |
type_id | Unknown |
customer
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
last_updated_date | Instant | |
name | Unknown | |
self | Unknown |
epic_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
epic_id | Unknown | PKFK |
field_name | Unknown | |
value | Unknown |
epic_point
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
epic_id | Unknown | PKFK |
release_id | Unknown | FK |
estimation_system | Unknown | |
estimation_value | Unknown |
epic_customer
| Column | Type | Keys |
|---|---|---|
customer_id | Unknown | PKFK |
epic_id | Unknown | PKFK |
epic
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
accepted_user_id | Unknown | FK |
created_by | Unknown | FK |
in_progress_by | Unknown | FK |
last_updated_by | Unknown | FK |
not_started_by | Unknown | FK |
owner_id | Unknown | FK |
primary_program_id | Unknown | FK |
theme_id | Unknown | FK |
ability_to_exec | Unknown | |
accepted_date | Unknown | |
additional_process_step_id | Json | |
additional_program_id | Json | |
budget | Unknown | |
business_impact | Unknown | |
capitalized | Unknown | |
connector_id | Unknown | |
create_date | Unknown | |
description | Unknown | |
design_stage | Unknown | |
discount_rate | Unknown | |
efficiency_dividend | Unknown | |
effort_swag | Unknown | |
epic_object_id | Unknown | |
estimate_at_completion | Unknown | |
external_cap_ex | Unknown | |
external_id | Unknown | |
external_key | Unknown | |
external_op_ex | Unknown | |
external_project | Unknown | |
failure_impact | Unknown | |
failure_probability | Unknown | |
fcast_share | Unknown | |
forecast_years | Unknown | |
funding_stage | Unknown | |
hypothesis | Unknown | |
in_progress_date | Unknown | |
in_progress_date_end | Unknown | |
initial_investment | Unknown | |
investment_type | Unknown | |
is_canceled | Unknown | |
is_recycled | Unknown | |
is_split | Unknown | |
it_risk | Unknown | |
last_updated_date | Instant | |
lean_ux_canvas | Unknown | |
links | Json | |
mvp | Unknown | |
not_started_date | Unknown | |
not_started_date_end | Unknown | |
parent_split_id | Unknown | |
planning_mode | Unknown | |
portfolio_ask_date | Unknown | |
process_step_id | Unknown | |
proto_type | Unknown | |
quadrant | Unknown | |
report_color | Unknown | |
revenue_assurance | Unknown | |
risk_appetite | Unknown | |
roi | Unknown | |
self | Unknown | |
spend_to_date | Unknown | |
start_initiation_date | Unknown | |
state | Unknown | |
strategic_driver | Unknown | |
strategic_horizon | Unknown | |
strategic_value_score | Unknown | |
tags | Unknown | |
target_completion_date | Unknown | |
title | Unknown | |
total_cap_ex | Unknown | |
total_op_ex | Unknown | |
type | Unknown | |
work_code_created_date | Unknown | |
work_code_deleted_date | Unknown | |
work_code_description | Unknown | |
work_code_external_id | Unknown | |
work_code_id | Unknown | |
work_code_is_active | Unknown | |
work_code_name | Unknown | |
work_code_type_id | Unknown | |
yearly_cash_flow | Unknown |
release_region
| Column | Type | Keys |
|---|---|---|
region_id | Unknown | PKFK |
release_id | Unknown | PKFK |
release_product
| Column | Type | Keys |
|---|---|---|
product_id | Unknown | PKFK |
release_id | Unknown | PKFK |
release_program
| Column | Type | Keys |
|---|---|---|
program_id | Unknown | PKFK |
release_id | Unknown | PKFK |
release_anchor_sprint
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
release_id | Unknown | PKFK |
defect_allocation | Unknown | |
end_date | Unknown | |
max_allocation | Unknown | |
name | Unknown | |
short | Unknown | |
sprint_schedule | Unknown | |
start_date | Unknown | |
test_suite_iteration | Unknown | |
type | Unknown |
release
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
division_id | Unknown | FK |
last_updated_by | Unknown | FK |
portfolio_id | Unknown | FK |
blended_hourly_rate | Unknown | |
budget | Unknown | |
create_date | Unknown | |
description | Unknown | |
end_date | Unknown | |
health | Unknown | |
last_updated_date | Instant | |
predecessor_id | Unknown | |
release_number | Unknown | |
roadmap | Unknown | |
schedule_type | Unknown | |
score_1 | Unknown | |
score_2 | Unknown | |
score_3 | Unknown | |
score_4 | Unknown | |
self | Unknown | |
short_name | Unknown | |
start_date | Unknown | |
status | Unknown | |
test_suite | Unknown | |
title | Unknown | |
type | Unknown |
capability_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
capability_id | Unknown | PKFK |
field_name | Unknown | |
value | Unknown |
capability_link
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
capability_id | Unknown | PKFK |
link | Unknown | |
name | Unknown |
capability_point
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
capability_id | Unknown | PKFK |
release_id | Unknown | FK |
estimation_system | Unknown | |
estimation_value | Unknown |
capability_country
| Column | Type | Keys |
|---|---|---|
country_id | Unknown | PK |
capability_id | Unknown | PKFK |
capability_process_step
| Column | Type | Keys |
|---|---|---|
process_step_id | Unknown | PK |
capability_id | Unknown | PKFK |
capability_program
| Column | Type | Keys |
|---|---|---|
capability_id | Unknown | PKFK |
program_id | Unknown | PKFK |
capability_customer
| Column | Type | Keys |
|---|---|---|
capability_id | Unknown | PKFK |
customer_id | Unknown | PKFK |
capability_release
| Column | Type | Keys |
|---|---|---|
capability_id | Unknown | PKFK |
release_id | Unknown | PKFK |
capability
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
accepted_user_id | Unknown | FK |
created_by | Unknown | FK |
last_updated_by | Unknown | FK |
owner_id | Unknown | FK |
parent_id | Unknown | FK |
primary_program_id | Unknown | FK |
accepted_date | Unknown | |
connector_id | Unknown | |
create_date | Unknown | |
description | Unknown | |
design_stage | Unknown | |
effort_swag | Unknown | |
external_id | Unknown | |
external_key | Unknown | |
external_project | Unknown | |
hypothesis | Unknown | |
is_canceled | Unknown | |
is_recycled | Unknown | |
is_split | Unknown | |
last_updated_date | Instant | |
lean_ux_canvas | Unknown | |
mvp | Unknown | |
parent_split_id | Unknown | |
portfolio_ask_date | Unknown | |
process_step_id | Unknown | |
proto_type | Unknown | |
quadrant | Unknown | |
report_color | Unknown | |
self | Unknown | |
start_initiation_date | Unknown | |
state | Unknown | |
strategic_horizon | Unknown | |
strategic_value_score | Unknown | |
tags | Unknown | |
target_completion_date | Unknown | |
title | Unknown | |
type | Unknown |
region
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
last_updated_date | Instant | |
name | Unknown | |
self | Unknown |
goal_link
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
goal_id | Unknown | PKFK |
link | Unknown | |
name | Unknown |
goal_snap_shot
| Column | Type | Keys |
|---|---|---|
goal_id | Unknown | PKFK |
snapshot_id | Unknown | PKFK |
goal
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
division_id | Unknown | FK |
owner_id | Unknown | FK |
create_date | Unknown | |
description | Unknown | |
feasibility | Unknown | |
importance | Unknown | |
last_updated_date | Instant | |
market_assessment | Unknown | |
measurement | Unknown | |
parent_id | Unknown | |
percent_complete | Unknown | |
reference | Unknown | |
self | Unknown | |
target_date | Unknown | |
type | Unknown |
users_team
| Column | Type | Keys |
|---|---|---|
team_id | Unknown | PKFK |
user_id | Unknown | PKFK |
role_id | Unknown | FK |
role
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | FK |
create_date | Unknown | |
description | Unknown | |
is_system_role | Unknown | |
is_time_tracking | Unknown | |
name | Unknown | |
self | Unknown | |
type | Unknown | |
update_date | Unknown |
division
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | FK |
category | Unknown | |
company_code | Unknown | |
name | Unknown | |
parent_id | Unknown | |
product_id | Unknown |
users_time_track_role
| Column | Type | Keys |
|---|---|---|
time_track_role | Unknown | PK |
user_id | Unknown | PKFK |
users
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
city_id | Unknown | FK |
division_id | Unknown | FK |
holiday_city_id | Unknown | FK |
holiday_region_id | Unknown | FK |
manager_id | Unknown | FK |
region_id | Unknown | FK |
role_id | Unknown | FK |
company | Unknown | |
company_id | Unknown | |
connector_id | Unknown | |
cost_center_description | Unknown | |
cost_center_external_key | Unknown | |
cost_center_id | Unknown | |
cost_center_name | Unknown | |
cost_center_owner | Unknown | |
cost_center_upload_flag | Unknown | |
create_date | Unknown | |
email | Unknown | |
employee_classification | Unknown | |
employee_id | Unknown | |
enterprise_hierarchy | Unknown | |
external_id | Unknown | |
first_name | Unknown | |
full_name | Unknown | |
holiday_calendar_id | Unknown | |
holiday_calendar_last_updated_date | Unknown | |
holiday_calendar_name | Unknown | |
holiday_calendar_self | Unknown | |
include_hours | Unknown | |
is_compliance_manager | Unknown | |
is_external | Unknown | |
is_locked | Unknown | |
is_time_tracking | Unknown | |
is_user_manager | Unknown | |
last_login_date | Unknown | |
last_name | Unknown | |
last_updated_date | Instant | |
notes | Unknown | |
password | Unknown | |
self | Unknown | |
status | Unknown | |
time_approver_id | Unknown | |
time_tracking_start_date | Unknown | |
time_zone | Unknown | |
title | Unknown | |
uid | Unknown | |
user_end_date | Unknown | |
user_start_date | Unknown | |
user_type | Unknown | |
view_public_ers | Unknown |
program
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
portfolio_id | Unknown | FK |
region_id | Unknown | FK |
team_id | Unknown | FK |
case_development_id | Unknown | |
intake_form_id | Unknown | |
is_solution | Unknown | |
last_updated_date | Instant | |
score_card_id | Unknown | |
self | Unknown | |
solution_id | Unknown | |
team_description | Unknown | |
title | Unknown |
theme_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
last_updated_by | Unknown | FK |
parent_goal_id | Unknown | FK |
active | Unknown | |
description | Unknown | |
last_updated_date | Instant | |
name | Unknown | |
non_edit | Unknown | |
rank | Unknown | |
self | Unknown |
objective_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
objective_id | Unknown | PKFK |
field_name | Unknown | |
value | Unknown |
objective_link
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
objective_id | Unknown | PKFK |
link | Unknown | |
name | Unknown |
objective_team
| Column | Type | Keys |
|---|---|---|
objective_id | Unknown | PKFK |
team_id | Unknown | PKFK |
objective_dependency
| Column | Type | Keys |
|---|---|---|
dependency_id | Unknown | PK |
objective_id | Unknown | PKFK |
id | Unknown | FK |
objective_risk
| Column | Type | Keys |
|---|---|---|
objective_id | Unknown | PKFK |
risk_id | Unknown | PKFK |
objective_impediment
| Column | Type | Keys |
|---|---|---|
impediment_id | Unknown | PK |
objective_id | Unknown | PKFK |
objective_feature
| Column | Type | Keys |
|---|---|---|
feature_id | Unknown | PKFK |
objective_id | Unknown | PKFK |
objective_epic
| Column | Type | Keys |
|---|---|---|
epic_id | Unknown | PKFK |
objective_id | Unknown | PKFK |
objective_release
| Column | Type | Keys |
|---|---|---|
objective_id | Unknown | PKFK |
release_id | Unknown | PKFK |
objective_program
| Column | Type | Keys |
|---|---|---|
objective_id | Unknown | PKFK |
program_id | Unknown | PKFK |
objective
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
goal_id | Unknown | FK |
last_updated_by | Unknown | FK |
owner_id | Unknown | FK |
parent_id | Unknown | FK |
portfolio_id | Unknown | FK |
program_id | Unknown | FK |
theme_id | Unknown | FK |
blocked_reason | Unknown | |
category | Unknown | |
create_date | Unknown | |
delivered_value | Unknown | |
description | Unknown | |
end_date | Unknown | |
health | Unknown | |
is_blocked | Unknown | |
last_updated_date | Instant | |
name | Unknown | |
note | Unknown | |
notification_frequency | Unknown | |
notification_start_date | Unknown | |
planned_value | Unknown | |
portfolio_ask_date | Unknown | |
reference | Unknown | |
score | Unknown | |
self | Unknown | |
solution_id | Unknown | |
start_initiation_date | Unknown | |
status | Unknown | |
target_completion_date | Unknown | |
target_sync_sprint_id | Unknown | |
tier | Unknown |
release_vehicle_feature
| Column | Type | Keys |
|---|---|---|
feature_id | Unknown | PKFK |
release_vehicle_id | Unknown | PKFK |
release_vehicle_story
| Column | Type | Keys |
|---|---|---|
release_vehicle_id | Unknown | PKFK |
story_id | Unknown | PKFK |
release_vehicle_program
| Column | Type | Keys |
|---|---|---|
program_id | Unknown | PKFK |
release_vehicle_id | Unknown | PKFK |
release_vehicle_defect
| Column | Type | Keys |
|---|---|---|
defect_id | Unknown | PKFK |
release_vehicle_id | Unknown | PKFK |
release_vehicle_team
| Column | Type | Keys |
|---|---|---|
release_vehicle_id | Unknown | PKFK |
team_id | Unknown | PKFK |
release_vehicle
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
owner_id | Unknown | FK |
release_id | Unknown | FK |
closed_date | Unknown | |
connector_id | Unknown | |
create_date | Unknown | |
external_id | Unknown | |
external_project_id | Unknown | |
go_live_date | Unknown | |
health | Unknown | |
is_time_tracking_only | Unknown | |
jira_project_key | Unknown | |
last_updated_date | Instant | |
name | Unknown | |
self | Unknown | |
ship_date | Unknown | |
start_date | Unknown | |
status | Unknown | |
type | Unknown |
theme_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
theme_id | Unknown | PKFK |
field_name | Unknown | |
value | Unknown |
strategy
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
strategy_id | Unknown | PK |
division_id | Unknown | FK |
goal_id | Unknown | FK |
theme_id | Unknown | FK |
competitive | Unknown | |
description | Unknown | |
feasibility | Unknown | |
goal_parent | Unknown | |
goal_quarter | Unknown | |
goal_state | Unknown | |
goal_type | Unknown | |
goal_year | Unknown | |
importance | Unknown | |
link | Unknown | |
measurement | Unknown | |
owner | Unknown | |
percent_comp | Unknown | |
rank | Unknown | |
strategy_date | Unknown | |
strategy_type | Unknown | |
strategy_value | Unknown | |
target_date | Unknown |
theme_link
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
theme_id | Unknown | PKFK |
link | Unknown | |
name | Unknown |
theme_release
| Column | Type | Keys |
|---|---|---|
release_id | Unknown | PKFK |
theme_id | Unknown | PKFK |
theme_program
| Column | Type | Keys |
|---|---|---|
program_id | Unknown | PKFK |
theme_id | Unknown | PKFK |
theme
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
created_by_user_id | Unknown | FK |
external_release_id | Unknown | FK |
goal_id | Unknown | FK |
theme_group_id | Unknown | FK |
connector_id | Unknown | |
create_date | Unknown | |
description | Unknown | |
external_id | Unknown | |
external_key | Unknown | |
external_project | Unknown | |
is_active | Unknown | |
is_import | Unknown | |
is_major | Unknown | |
last_updated_date | Instant | |
owner | Unknown | |
planned_budget | Unknown | |
portfolio_ask_date | Unknown | |
process_step_id | Unknown | |
rank | Unknown | |
report_color | Unknown | |
self | Unknown | |
start_initiation_date | Unknown | |
state | Unknown | |
strategic | Unknown | |
target_completion_date | Unknown | |
theme_story | Unknown | |
title | Unknown | |
unassigned_theme_bucket | Unknown |
snap_shot_member
| Column | Type | Keys |
|---|---|---|
snap_shot_id | Unknown | PKFK |
user_id | Unknown | PKFK |
snap_shot_release
| Column | Type | Keys |
|---|---|---|
release_id | Unknown | PKFK |
snap_shot_id | Unknown | PKFK |
snap_shot_division
| Column | Type | Keys |
|---|---|---|
division_id | Unknown | PKFK |
snapshot_id | Unknown | PKFK |
snap_shot_product
| Column | Type | Keys |
|---|---|---|
product_id | Unknown | PKFK |
snap_shot_id | Unknown | PKFK |
snap_shot_funding_level
| Column | Type | Keys |
|---|---|---|
division_id | Unknown | PKFK |
snapshot_id | Unknown | PKFK |
fund | Unknown |
snap_shot
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
owner_id | Unknown | FK |
budget | Unknown | |
description | Unknown | |
enable_snapshot_notification | Unknown | |
enable_strategy_notification | Unknown | |
end_date | Instant | |
horizon_percentage_1 | Unknown | |
horizon_percentage_2 | Unknown | |
horizon_percentage_3 | Unknown | |
self | Unknown | |
start_date | Unknown | |
title | Unknown |
story_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
story_id | Unknown | PKFK |
field_name | Unknown | |
value | Unknown |
story_release_vehicle
| Column | Type | Keys |
|---|---|---|
release_vehicle_id | Unknown | PKFK |
story_id | Unknown | PKFK |
story_link
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
story_id | Unknown | PKFK |
link | Unknown | |
name | Unknown |
story
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
accepted_by | Unknown | FK |
created_by | Unknown | FK |
feature_id | Unknown | FK |
iteration_id | Unknown | FK |
last_updated_by | Unknown | FK |
owner_id | Unknown | FK |
program_id | Unknown | FK |
release_id | Unknown | FK |
team_id | Unknown | FK |
accepted_date | Unknown | |
assumption | Unknown | |
automation | Unknown | |
connector_id | Unknown | |
create_date | Unknown | |
description | Unknown | |
effort_points | Unknown | |
external_id | Unknown | |
external_key | Unknown | |
external_project | Unknown | |
is_accepted | Unknown | |
is_canceled | Unknown | |
is_parent_split | Unknown | |
is_recycled | Unknown | |
item_to_sync_date | Unknown | |
jira_project_key | Unknown | |
last_updated_date | Instant | |
mmf | Unknown | |
parent_split_id | Unknown | |
persona_id | Unknown | |
process_step_id | Unknown | |
self | Unknown | |
split_reason | Unknown | |
split_type | Unknown | |
state | Unknown | |
tags | Unknown | |
title | Unknown | |
type | Unknown | |
value_points | Unknown |
city
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
region_id | Unknown | FK |
apply_time_tracking | Unknown | |
last_updated_date | Instant | |
name | Unknown | |
self | Unknown |
team_community
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
team_id | Unknown | PKFK |
posted_by | Unknown | FK |
link | Unknown | |
posted | Unknown | |
text | Unknown | |
title | Unknown | |
type | Unknown |
team
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
owner_id | Unknown | FK |
program_id | Unknown | FK |
region_id | Unknown | FK |
track_by | Unknown | FK |
allow_task_deletion | Unknown | |
allow_team_to_run_standup | Unknown | |
auto_estimate_value | Unknown | |
create_date | Unknown | |
description | Unknown | |
enable_auto_estimate | Unknown | |
is_active | Unknown | |
is_kanban_team | Unknown | |
last_updated_date | Instant | |
max_allocation | Unknown | |
name | Unknown | |
rank | Unknown | |
self | Unknown | |
short_name | Unknown | |
sprint_prefix | Unknown | |
through_put | Unknown | |
type | Unknown |
defect_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
defect_id | Unknown | PKFK |
field_name | Unknown | |
value | Unknown |
defect_release_vehicle
| Column | Type | Keys |
|---|---|---|
defect_id | Unknown | PKFK |
release_vehicle_id | Unknown | PKFK |
defect
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
closed_by | Unknown | FK |
created_by | Unknown | FK |
fixed_by | Unknown | FK |
iteration_id | Unknown | FK |
program_id | Unknown | FK |
release_id | Unknown | FK |
story_id | Unknown | FK |
team_id | Unknown | FK |
actual_results | Unknown | |
assigned_to | Unknown | |
blocked_reason | Unknown | |
browser | Unknown | |
category | Unknown | |
close_date | Unknown | |
connector_id | Unknown | |
create_date | Unknown | |
database | Unknown | |
defect_story_id_convert | Unknown | |
defect_suite_id | Unknown | |
description | Unknown | |
duplicate_of | Unknown | |
expected_results | Unknown | |
external_id | Unknown | |
external_key | Unknown | |
external_project | Unknown | |
fix_results | Unknown | |
fixed_build | Unknown | |
found_build | Unknown | |
frequency | Unknown | |
functional_area | Unknown | |
hours_estimate | Unknown | |
hours_remaining | Unknown | |
impact | Unknown | |
is_affecting_doc | Unknown | |
is_blocked | Unknown | |
is_commercialized | Unknown | |
is_customer_issue | Unknown | |
is_duplicate | Unknown | |
is_pm_reviewed | Unknown | |
is_recycled | Unknown | |
is_status_open | Unknown | |
item_to_sync_date | Unknown | |
kanban_status | Unknown | |
last_updated_date | Instant | |
notify | Unknown | |
os_client | Unknown | |
os_server | Unknown | |
points_estimate | Unknown | |
priority | Unknown | |
self | Unknown | |
severity | Unknown | |
state | Unknown | |
steps_to_reproduce | Unknown | |
tags | Unknown | |
title | Unknown | |
verified_build | Unknown | |
version | Unknown |
key_result_value_update
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
key_result_id | Unknown | FK |
score_by | Unknown | FK |
score_date | Unknown | |
score_note | Unknown | |
score_value | Double | |
status | Unknown |
key_result_score_override
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
key_result_id | Unknown | FK |
override_by | Unknown | FK |
override_date | Unknown | |
override_note | Unknown | |
override_value | Unknown |
key_result
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
owner_id | Unknown | FK |
parent_id | Unknown | FK |
baseline_value | Unknown | |
create_date | Unknown | |
description | Unknown | |
is_score_overidden | Unknown | |
last_updated_date | Instant | |
parent_type | Unknown | |
score | Unknown | |
self | Unknown | |
target_date | Unknown | |
target_value | Unknown | |
type | Unknown | |
weight | Unknown |
product_snap_shot
| Column | Type | Keys |
|---|---|---|
product_id | Unknown | PKFK |
snapshot_id | Unknown | PKFK |
product_competitor
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
product_id | Unknown | PKFK |
product_personal
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
product_id | Unknown | PKFK |
product
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
division_id | Unknown | FK |
parent_product_id | Unknown | FK |
is_active | Unknown | |
last_updated_date | Instant | |
self | Unknown | |
short_name | Unknown | |
title | Unknown |
iteration
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
anchor_sprint_id | Unknown | FK |
program_id | Unknown | FK |
region_id | Unknown | FK |
release_id | Unknown | FK |
team_id | Unknown | FK |
actual_end_date | Unknown | |
begin_date | Unknown | |
color | Unknown | |
create_date | Unknown | |
defect_allocation | Unknown | |
description | Unknown | |
end_date | Unknown | |
goal | Unknown | |
is_locked | Unknown | |
last_updated_date | Instant | |
max_allocation | Unknown | |
override_velocity | Unknown | |
regression_hours | Unknown | |
schedule | Unknown | |
self | Unknown | |
short_name | Unknown | |
state | Unknown | |
title | Unknown | |
type | Unknown |
task_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
task_id | Unknown | PKFK |
field_name | Unknown | |
value | Unknown |
task
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
last_updated_by | Unknown | FK |
owner_id | Unknown | FK |
qa_task_id | Unknown | FK |
story_id | Unknown | FK |
completed_date | Unknown | |
connector_id | Unknown | |
create_date | Unknown | |
dependency_id | Unknown | |
description | Unknown | |
effort_hours | Unknown | |
external_id | Unknown | |
external_key | Unknown | |
external_project | Unknown | |
in_progress_date | Unknown | |
is_assigned | Unknown | |
is_automation_task | Unknown | |
is_blocked | Unknown | |
is_import | Unknown | |
is_recycled | Unknown | |
iteration_completed | Unknown | |
last_updated_date | Instant | |
not_started_date | Unknown | |
notes | Unknown | |
post_add | Unknown | |
rank | Unknown | |
reviewed | Unknown | |
self | Unknown | |
sequence | Unknown | |
state | Unknown | |
test_task_id | Unknown | |
tested_date | Unknown | |
tester_uid | Unknown | |
title | Unknown | |
total_hours | Unknown | |
type | Unknown | |
unassigned_date | Unknown |
feature_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
feature_id | Unknown | PKFK |
field_name | Unknown | |
value | Unknown |
feature_link
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
feature_id | Unknown | PKFK |
link | Unknown | |
name | Unknown |
feature_process_step
| Column | Type | Keys |
|---|---|---|
process_step_id | Unknown | PK |
feature_id | Unknown | PKFK |
feature_test_category
| Column | Type | Keys |
|---|---|---|
test_category_id | Unknown | PK |
feature_id | Unknown | PKFK |
feature_affected_country
| Column | Type | Keys |
|---|---|---|
country_id | Unknown | PK |
feature_id | Unknown | PKFK |
feature_customer
| Column | Type | Keys |
|---|---|---|
customer_id | Unknown | PKFK |
feature_id | Unknown | PKFK |
feature_objective
| Column | Type | Keys |
|---|---|---|
feature_id | Unknown | PKFK |
objective_id | Unknown | PKFK |
feature_additional_program
| Column | Type | Keys |
|---|---|---|
feature_id | Unknown | PKFK |
program_id | Unknown | PKFK |
feature_release_vehicle
| Column | Type | Keys |
|---|---|---|
feature_id | Unknown | PKFK |
release_vehicle_id | Unknown | PKFK |
feature
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
accepted_user_id | Unknown | FK |
created_by | Unknown | FK |
dev_complete_by | Unknown | FK |
in_progress_by | Unknown | FK |
last_updated_by | Unknown | FK |
owner_id | Unknown | FK |
parent_id | Unknown | FK |
pending_approval_by | Unknown | FK |
primary_program_id | Unknown | FK |
product_id | Unknown | FK |
release_id | Unknown | FK |
test_complete_by | Unknown | FK |
theme_id | Unknown | FK |
vehicle_id | Unknown | FK |
work_code_id | Unknown | FK |
accepted_date | Unknown | |
associated_ticket | Unknown | |
benefits | Unknown | |
blocked_reason | Unknown | |
budget | Unknown | |
business_driver | Unknown | |
business_impact | Unknown | |
business_value | Unknown | |
capitalized | Unknown | |
category | Unknown | |
complexity | Unknown | |
connector_id | Unknown | |
create_date | Unknown | |
description | Unknown | |
description_rich | Unknown | |
design_stage | Unknown | |
dev_complete_date | Unknown | |
discount_rate | Unknown | |
end_sprint_id | Unknown | |
estimate_at_completion | Unknown | |
estimate_tshirt | Unknown | |
estimation_effort_percent | Unknown | |
expense_savings | Unknown | |
external_cap_ex | Unknown | |
external_id | Unknown | |
external_key | Unknown | |
external_op_ex | Unknown | |
external_project | Unknown | |
external_user | Unknown | |
failure_impact | Unknown | |
failure_probability | Unknown | |
feature_rank | Unknown | |
feature_summary | Unknown | |
forecast_years | Unknown | |
functional_area | Unknown | |
hypothesis | Unknown | |
in_progress_date | Unknown | |
in_scope | Unknown | |
initial_investment | Unknown | |
is_blocked | Unknown | |
is_canceled | Unknown | |
is_import | Unknown | |
is_multi_program | Unknown | |
is_recycled | Unknown | |
is_split | Unknown | |
it_risk | Unknown | |
item_to_sync_date | Unknown | |
iteration_sort | Unknown | |
jira_project_key | Unknown | |
last_updated_date | Instant | |
lean_ux_canvas | Unknown | |
man_weeks | Unknown | |
mmf | Unknown | |
parent_split_id | Unknown | |
pending_approval_date | Unknown | |
points | Unknown | |
portfolio_ask_date | Unknown | |
priority | Unknown | |
process_step_id | Unknown | |
prototype | Unknown | |
ready_to_start_by | Unknown | |
ready_to_start_date | Unknown | |
report_color | Unknown | |
requester_id | Unknown | |
revenue_growth | Unknown | |
risk_appetite | Unknown | |
score | Unknown | |
self | Unknown | |
source | Unknown | |
spend_to_date | Unknown | |
start_initiation_date | Unknown | |
start_sprint_id | Unknown | |
state | Unknown | |
tags | Unknown | |
target_completion_date | Unknown | |
test_complete_date | Unknown | |
title | Unknown | |
total_cap_ex | Unknown | |
total_op_ex | Unknown | |
type | Unknown |
milestone_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
milestone_id | Unknown | PKFK |
field_name | Unknown | |
value | Unknown |
milestone_link
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
milestone_id | Unknown | PKFK |
link | Unknown | |
name | Unknown |
milestone_team
| Column | Type | Keys |
|---|---|---|
milestone_id | Unknown | PKFK |
team_id | Unknown | PKFK |
milestone_dependency
| Column | Type | Keys |
|---|---|---|
dependency_id | Unknown | PK |
milestone_id | Unknown | PKFK |
milestone_risk
| Column | Type | Keys |
|---|---|---|
milestone_id | Unknown | PKFK |
risk_id | Unknown | PKFK |
milestone_impediment
| Column | Type | Keys |
|---|---|---|
impediment_id | Unknown | PK |
milestone_id | Unknown | PKFK |
milestone_feature
| Column | Type | Keys |
|---|---|---|
feature_id | Unknown | PKFK |
milestone_id | Unknown | PKFK |
milestone_epic
| Column | Type | Keys |
|---|---|---|
epic_id | Unknown | PKFK |
milestone_id | Unknown | PKFK |
milestone_release
| Column | Type | Keys |
|---|---|---|
milestone_id | Unknown | PKFK |
release_id | Unknown | PKFK |
milestone_program
| Column | Type | Keys |
|---|---|---|
milestone_id | Unknown | PKFK |
program_id | Unknown | PKFK |
milestone
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
goal_id | Unknown | FK |
last_updated_by | Unknown | FK |
owner_id | Unknown | FK |
parent_id | Unknown | FK |
portfolio_id | Unknown | FK |
program_id | Unknown | FK |
theme_id | Unknown | FK |
blocked_reason | Unknown | |
category | Unknown | |
create_date | Unknown | |
delivered_value | Unknown | |
description | Unknown | |
end_date | Unknown | |
health | Unknown | |
is_blocked | Unknown | |
last_updated_date | Instant | |
name | Unknown | |
note | Unknown | |
notification_frequency | Unknown | |
notification_start_date | Unknown | |
planned_value | Unknown | |
portfolio_ask_date | Unknown | |
reference | Unknown | |
score | Unknown | |
self | Unknown | |
solution_id | Unknown | |
start_initiation_date | Unknown | |
status | Unknown | |
target_completion_date | Unknown | |
target_sync_sprint_id | Unknown | |
tier | Unknown |
idea
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
owner_id | Unknown | FK |
product_id | Unknown | FK |
category_id | Unknown | |
company_id | Unknown | |
create_date | Unknown | |
description | Unknown | |
group_id | Unknown | |
is_external | Unknown | |
is_public | Unknown | |
last_updated_date | Instant | |
self | Unknown | |
status | Unknown | |
title | Unknown |
portfolio
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
division_id | Unknown | FK |
organization_product_id | Unknown | FK |
region_id | Unknown | FK |
team_id | Unknown | FK |
case_development_id | Unknown | |
description | Unknown | |
intake_form_id | Unknown | |
is_active | Unknown | |
is_private | Unknown | |
last_updated_date | Instant | |
organization_company_code | Unknown | |
organization_cost_center | Unknown | |
organization_division_category | Unknown | |
organization_id | Unknown | |
organization_name | Unknown | |
organization_parent_id | Unknown | |
score_card_id | Unknown | |
self | Unknown | |
team_description | Unknown | |
title | Unknown |
process_step_wip_limit
| Column | Type | Keys |
|---|---|---|
process_step_id | Unknown | PKFK |
program_id | Unknown | PKFK |
program_value_stream_relation_id | Unknown | |
wip_limit | Unknown |
value_stream_process_step
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
portfolio_id | Unknown | FK |
value_stream_id | Unknown | FK |
efficiency_hour | Unknown | |
function_id | Unknown | |
is_active | Unknown | |
mapped_state_id | Unknown | |
mapped_state_name | Unknown | |
name | Unknown | |
send_email | Unknown | |
sort_order | Unknown | |
step_type | Unknown |
value_stream_customer
| Column | Type | Keys |
|---|---|---|
customer_id | Unknown | PKFK |
value_stream_id | Unknown | PKFK |
value_stream_program
| Column | Type | Keys |
|---|---|---|
program_id | Unknown | PKFK |
value_stream_id | Unknown | PKFK |
value_stream
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
region_id | Unknown | FK |
team_id | Unknown | FK |
is_active | Unknown | |
last_updated_date | Instant | |
level | Unknown | |
map_to_state | Unknown | |
name | Unknown | |
self | Unknown | |
team_description | Unknown | |
type | Unknown |
risk_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
risk_id | Unknown | PKFK |
field_name | Unknown | |
value | Unknown |
risk_notify
| Column | Type | Keys |
|---|---|---|
email | Unknown | PKFK |
risk_id | Unknown | PKFK |
risk_link
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
risk_id | Unknown | PKFK |
link | Unknown | |
name | Unknown |
risk
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
closed_by | Unknown | FK |
created_by | Unknown | FK |
last_updated_by | Unknown | FK |
owner_id | Unknown | FK |
program_id | Unknown | FK |
release_id | Unknown | FK |
close_date | Unknown | |
consequence | Unknown | |
contingency | Unknown | |
create_date | Unknown | |
critical_path | Unknown | |
description | Unknown | |
exposure | Unknown | |
external_id | Unknown | |
external_key | Unknown | |
impact | Unknown | |
last_updated_date | Instant | |
mitigation | Unknown | |
notify_send_email_date | Unknown | |
notify_send_email_update | Unknown | |
occurrence | Unknown | |
rank | Unknown | |
related_item_id | Unknown | |
relationship | Unknown | |
resolution_method | Unknown | |
resolution_status | Unknown | |
risk_type | Unknown | |
self | Unknown | |
status | Unknown | |
tags | Unknown | |
target_resolution_date | Unknown | |
title | Unknown |