# Jira Align schema ERD

Table and field reference for the Fivetran Jira Align connector.

## Table & Field Reference

### dependency_link

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| dependency_id | Unknown | PK, FK |
| link | Unknown |  |
| name | Unknown |  |

### dependency_story

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| dependency_id | Unknown | PK, FK |
| 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 | PK, FK |
| field_name | Unknown |  |
| value | Unknown |  |

### epic_point

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| epic_id | Unknown | PK, FK |
| release_id | Unknown | FK |
| estimation_system | Unknown |  |
| estimation_value | Unknown |  |

### epic_customer

| Column | Type | Keys |
| --- | --- | --- |
| customer_id | Unknown | PK, FK |
| epic_id | Unknown | PK, FK |

### 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 | PK, FK |
| release_id | Unknown | PK, FK |

### release_product

| Column | Type | Keys |
| --- | --- | --- |
| product_id | Unknown | PK, FK |
| release_id | Unknown | PK, FK |

### release_program

| Column | Type | Keys |
| --- | --- | --- |
| program_id | Unknown | PK, FK |
| release_id | Unknown | PK, FK |

### release_anchor_sprint

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| release_id | Unknown | PK, FK |
| 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 | PK, FK |
| field_name | Unknown |  |
| value | Unknown |  |

### capability_link

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| capability_id | Unknown | PK, FK |
| link | Unknown |  |
| name | Unknown |  |

### capability_point

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| capability_id | Unknown | PK, FK |
| release_id | Unknown | FK |
| estimation_system | Unknown |  |
| estimation_value | Unknown |  |

### capability_country

| Column | Type | Keys |
| --- | --- | --- |
| country_id | Unknown | PK |
| capability_id | Unknown | PK, FK |

### capability_process_step

| Column | Type | Keys |
| --- | --- | --- |
| process_step_id | Unknown | PK |
| capability_id | Unknown | PK, FK |

### capability_program

| Column | Type | Keys |
| --- | --- | --- |
| capability_id | Unknown | PK, FK |
| program_id | Unknown | PK, FK |

### capability_customer

| Column | Type | Keys |
| --- | --- | --- |
| capability_id | Unknown | PK, FK |
| customer_id | Unknown | PK, FK |

### capability_release

| Column | Type | Keys |
| --- | --- | --- |
| capability_id | Unknown | PK, FK |
| release_id | Unknown | PK, FK |

### 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 | PK, FK |
| link | Unknown |  |
| name | Unknown |  |

### goal_snap_shot

| Column | Type | Keys |
| --- | --- | --- |
| goal_id | Unknown | PK, FK |
| snapshot_id | Unknown | PK, FK |

### 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 | PK, FK |
| user_id | Unknown | PK, FK |
| 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 | PK, FK |

### 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 | PK, FK |
| field_name | Unknown |  |
| value | Unknown |  |

### objective_link

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| objective_id | Unknown | PK, FK |
| link | Unknown |  |
| name | Unknown |  |

### objective_team

| Column | Type | Keys |
| --- | --- | --- |
| objective_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |

### objective_dependency

| Column | Type | Keys |
| --- | --- | --- |
| dependency_id | Unknown | PK |
| objective_id | Unknown | PK, FK |
| id | Unknown | FK |

### objective_risk

| Column | Type | Keys |
| --- | --- | --- |
| objective_id | Unknown | PK, FK |
| risk_id | Unknown | PK, FK |

### objective_impediment

| Column | Type | Keys |
| --- | --- | --- |
| impediment_id | Unknown | PK |
| objective_id | Unknown | PK, FK |

### objective_feature

| Column | Type | Keys |
| --- | --- | --- |
| feature_id | Unknown | PK, FK |
| objective_id | Unknown | PK, FK |

### objective_epic

| Column | Type | Keys |
| --- | --- | --- |
| epic_id | Unknown | PK, FK |
| objective_id | Unknown | PK, FK |

### objective_release

| Column | Type | Keys |
| --- | --- | --- |
| objective_id | Unknown | PK, FK |
| release_id | Unknown | PK, FK |

### objective_program

| Column | Type | Keys |
| --- | --- | --- |
| objective_id | Unknown | PK, FK |
| program_id | Unknown | PK, FK |

### 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 | PK, FK |
| release_vehicle_id | Unknown | PK, FK |

### release_vehicle_story

| Column | Type | Keys |
| --- | --- | --- |
| release_vehicle_id | Unknown | PK, FK |
| story_id | Unknown | PK, FK |

### release_vehicle_program

| Column | Type | Keys |
| --- | --- | --- |
| program_id | Unknown | PK, FK |
| release_vehicle_id | Unknown | PK, FK |

### release_vehicle_defect

| Column | Type | Keys |
| --- | --- | --- |
| defect_id | Unknown | PK, FK |
| release_vehicle_id | Unknown | PK, FK |

### release_vehicle_team

| Column | Type | Keys |
| --- | --- | --- |
| release_vehicle_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |
| link | Unknown |  |
| name | Unknown |  |

### theme_release

| Column | Type | Keys |
| --- | --- | --- |
| release_id | Unknown | PK, FK |
| theme_id | Unknown | PK, FK |

### theme_program

| Column | Type | Keys |
| --- | --- | --- |
| program_id | Unknown | PK, FK |
| theme_id | Unknown | PK, FK |

### 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 | PK, FK |
| user_id | Unknown | PK, FK |

### snap_shot_release

| Column | Type | Keys |
| --- | --- | --- |
| release_id | Unknown | PK, FK |
| snap_shot_id | Unknown | PK, FK |

### snap_shot_division

| Column | Type | Keys |
| --- | --- | --- |
| division_id | Unknown | PK, FK |
| snapshot_id | Unknown | PK, FK |

### snap_shot_product

| Column | Type | Keys |
| --- | --- | --- |
| product_id | Unknown | PK, FK |
| snap_shot_id | Unknown | PK, FK |

### snap_shot_funding_level

| Column | Type | Keys |
| --- | --- | --- |
| division_id | Unknown | PK, FK |
| snapshot_id | Unknown | PK, FK |
| 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 | PK, FK |
| field_name | Unknown |  |
| value | Unknown |  |

### story_release_vehicle

| Column | Type | Keys |
| --- | --- | --- |
| release_vehicle_id | Unknown | PK, FK |
| story_id | Unknown | PK, FK |

### story_link

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| story_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| field_name | Unknown |  |
| value | Unknown |  |

### defect_release_vehicle

| Column | Type | Keys |
| --- | --- | --- |
| defect_id | Unknown | PK, FK |
| release_vehicle_id | Unknown | PK, FK |

### 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 | PK, FK |
| snapshot_id | Unknown | PK, FK |

### product_competitor

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | PK, FK |

### product_personal

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |
| field_name | Unknown |  |
| value | Unknown |  |

### feature_link

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| feature_id | Unknown | PK, FK |
| link | Unknown |  |
| name | Unknown |  |

### feature_process_step

| Column | Type | Keys |
| --- | --- | --- |
| process_step_id | Unknown | PK |
| feature_id | Unknown | PK, FK |

### feature_test_category

| Column | Type | Keys |
| --- | --- | --- |
| test_category_id | Unknown | PK |
| feature_id | Unknown | PK, FK |

### feature_affected_country

| Column | Type | Keys |
| --- | --- | --- |
| country_id | Unknown | PK |
| feature_id | Unknown | PK, FK |

### feature_customer

| Column | Type | Keys |
| --- | --- | --- |
| customer_id | Unknown | PK, FK |
| feature_id | Unknown | PK, FK |

### feature_objective

| Column | Type | Keys |
| --- | --- | --- |
| feature_id | Unknown | PK, FK |
| objective_id | Unknown | PK, FK |

### feature_additional_program

| Column | Type | Keys |
| --- | --- | --- |
| feature_id | Unknown | PK, FK |
| program_id | Unknown | PK, FK |

### feature_release_vehicle

| Column | Type | Keys |
| --- | --- | --- |
| feature_id | Unknown | PK, FK |
| release_vehicle_id | Unknown | PK, FK |

### 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 | PK, FK |
| field_name | Unknown |  |
| value | Unknown |  |

### milestone_link

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| milestone_id | Unknown | PK, FK |
| link | Unknown |  |
| name | Unknown |  |

### milestone_team

| Column | Type | Keys |
| --- | --- | --- |
| milestone_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |

### milestone_dependency

| Column | Type | Keys |
| --- | --- | --- |
| dependency_id | Unknown | PK |
| milestone_id | Unknown | PK, FK |

### milestone_risk

| Column | Type | Keys |
| --- | --- | --- |
| milestone_id | Unknown | PK, FK |
| risk_id | Unknown | PK, FK |

### milestone_impediment

| Column | Type | Keys |
| --- | --- | --- |
| impediment_id | Unknown | PK |
| milestone_id | Unknown | PK, FK |

### milestone_feature

| Column | Type | Keys |
| --- | --- | --- |
| feature_id | Unknown | PK, FK |
| milestone_id | Unknown | PK, FK |

### milestone_epic

| Column | Type | Keys |
| --- | --- | --- |
| epic_id | Unknown | PK, FK |
| milestone_id | Unknown | PK, FK |

### milestone_release

| Column | Type | Keys |
| --- | --- | --- |
| milestone_id | Unknown | PK, FK |
| release_id | Unknown | PK, FK |

### milestone_program

| Column | Type | Keys |
| --- | --- | --- |
| milestone_id | Unknown | PK, FK |
| program_id | Unknown | PK, FK |

### 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 | PK, FK |
| program_id | Unknown | PK, FK |
| 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 | PK, FK |
| value_stream_id | Unknown | PK, FK |

### value_stream_program

| Column | Type | Keys |
| --- | --- | --- |
| program_id | Unknown | PK, FK |
| value_stream_id | Unknown | PK, FK |

### 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 | PK, FK |
| field_name | Unknown |  |
| value | Unknown |  |

### risk_notify

| Column | Type | Keys |
| --- | --- | --- |
| email | Unknown | PK, FK |
| risk_id | Unknown | PK, FK |

### risk_link

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| risk_id | Unknown | PK, FK |
| 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 |  |

## Relationships

- dependency_link(dependency_id) → dependency(id)
- dependency_story(story_id) → story(id)
- dependency_story(dependency_id) → dependency(id)
- dependency(requesting_team_id) → team(id)
- dependency(depends_on_program_id) → program(id)
- dependency(release_id) → release(id)
- dependency(feature_id) → feature(id)
- dependency(epic_id) → epic(id)
- dependency(requesting_program_id) → program(id)
- dependency(depends_on_team_id) → team(id)
- epic_custom_field(epic_id) → epic(id)
- epic_point(release_id) → release(id)
- epic_point(epic_id) → epic(id)
- epic_customer(customer_id) → customer(id)
- epic_customer(epic_id) → epic(id)
- epic(primary_program_id) → program(id)
- epic(accepted_user_id) → users(id)
- epic(last_updated_by) → users(id)
- epic(created_by) → users(id)
- epic(not_started_by) → users(id)
- epic(in_progress_by) → users(id)
- epic(owner_id) → users(id)
- epic(theme_id) → theme(id)
- release_region(region_id) → region(id)
- release_region(release_id) → release(id)
- release_product(product_id) → product(id)
- release_product(release_id) → release(id)
- release_program(program_id) → program(id)
- release_program(release_id) → release(id)
- release_anchor_sprint(release_id) → release(id)
- release(portfolio_id) → portfolio(id)
- release(last_updated_by) → users(id)
- release(division_id) → division(id)
- capability_custom_field(capability_id) → capability(id)
- capability_link(capability_id) → capability(id)
- capability_point(release_id) → release(id)
- capability_point(capability_id) → capability(id)
- capability_country(capability_id) → capability(id)
- capability_process_step(capability_id) → capability(id)
- capability_program(program_id) → program(id)
- capability_program(capability_id) → capability(id)
- capability_customer(customer_id) → customer(id)
- capability_customer(capability_id) → capability(id)
- capability_release(release_id) → release(id)
- capability_release(capability_id) → capability(id)
- capability(primary_program_id) → program(id)
- capability(accepted_user_id) → users(id)
- capability(last_updated_by) → users(id)
- capability(created_by) → users(id)
- capability(owner_id) → users(id)
- capability(parent_id) → capability(id)
- goal_link(goal_id) → goal(id)
- goal_snap_shot(snapshot_id) → snap_shot(id)
- goal_snap_shot(goal_id) → goal(id)
- goal(owner_id) → goal(id)
- goal(division_id) → division(id)
- users_team(team_id) → team(id)
- users_team(role_id) → role(id)
- users_team(user_id) → users(id)
- role(user_id) → users(id)
- division(user_id) → users(id)
- users_time_track_role(user_id) → users(id)
- users(holiday_region_id) → region(id)
- users(manager_id) → users(id)
- users(division_id) → division(id)
- users(role_id) → role(id)
- users(region_id) → region(id)
- users(holiday_city_id) → city(id)
- users(city_id) → city(id)
- program(portfolio_id) → portfolio(id)
- program(team_id) → team(id)
- program(region_id) → region(id)
- theme_group(parent_goal_id) → goal(id)
- theme_group(last_updated_by) → users(id)
- objective_custom_field(objective_id) → objective(id)
- objective_link(objective_id) → objective(id)
- objective_team(team_id) → team(id)
- objective_team(objective_id) → objective(id)
- objective_dependency(id) → dependency(id)
- objective_dependency(objective_id) → objective(id)
- objective_risk(risk_id) → risk(id)
- objective_risk(objective_id) → objective(id)
- objective_impediment(objective_id) → objective(id)
- objective_feature(feature_id) → feature(id)
- objective_feature(objective_id) → objective(id)
- objective_epic(epic_id) → epic(id)
- objective_epic(objective_id) → objective(id)
- objective_release(release_id) → release(id)
- objective_release(objective_id) → objective(id)
- objective_program(program_id) → program(id)
- objective_program(objective_id) → objective(id)
- objective(portfolio_id) → portfolio(id)
- objective(last_updated_by) → users(id)
- objective(owner_id) → users(id)
- objective(program_id) → program(id)
- objective(goal_id) → goal(id)
- objective(parent_id) → objective(id)
- objective(theme_id) → theme(id)
- release_vehicle_feature(feature_id) → feature(id)
- release_vehicle_feature(release_vehicle_id) → release_vehicle(id)
- release_vehicle_story(story_id) → story(id)
- release_vehicle_story(release_vehicle_id) → release_vehicle(id)
- release_vehicle_program(program_id) → program(id)
- release_vehicle_program(release_vehicle_id) → release_vehicle(id)
- release_vehicle_defect(defect_id) → defect(id)
- release_vehicle_defect(release_vehicle_id) → release_vehicle(id)
- release_vehicle_team(team_id) → team(id)
- release_vehicle_team(release_vehicle_id) → release_vehicle(id)
- release_vehicle(release_id) → release(id)
- release_vehicle(owner_id) → users(id)
- theme_custom_field(theme_id) → theme(id)
- strategy(division_id) → division(id)
- strategy(goal_id) → goal(id)
- strategy(theme_id) → theme(id)
- theme_link(theme_id) → theme(id)
- theme_release(release_id) → release(id)
- theme_release(theme_id) → theme(id)
- theme_program(program_id) → program(id)
- theme_program(theme_id) → theme(id)
- theme(created_by_user_id) → users(id)
- theme(created_by) → users(id)
- theme(theme_group_id) → theme_group(id)
- theme(goal_id) → goal(id)
- theme(external_release_id) → release(id)
- snap_shot_member(user_id) → users(id)
- snap_shot_member(snap_shot_id) → snap_shot(id)
- snap_shot_release(release_id) → release(id)
- snap_shot_release(snap_shot_id) → snap_shot(id)
- snap_shot_division(division_id) → division(id)
- snap_shot_division(snapshot_id) → snap_shot(id)
- snap_shot_product(product_id) → product(id)
- snap_shot_product(snap_shot_id) → snap_shot(id)
- snap_shot_funding_level(division_id) → division(id)
- snap_shot_funding_level(snapshot_id) → snap_shot(id)
- snap_shot(owner_id) → users(id)
- story_custom_field(story_id) → story(id)
- story_release_vehicle(release_vehicle_id) → release_vehicle(id)
- story_release_vehicle(story_id) → story(id)
- story_link(story_id) → story(id)
- story(last_updated_by) → users(id)
- story(release_id) → release(id)
- story(team_id) → team(id)
- story(feature_id) → feature(id)
- story(created_by) → users(id)
- story(accepted_by) → users(id)
- story(owner_id) → users(id)
- story(program_id) → program(id)
- story(iteration_id) → iteration(id)
- city(region_id) → region(id)
- team_community(posted_by) → users(id)
- team_community(team_id) → team(id)
- team(owner_id) → users(id)
- team(program_id) → program(id)
- team(track_by) → users(id)
- team(region_id) → region(id)
- defect_custom_field(defect_id) → defect(id)
- defect_release_vehicle(release_vehicle_id) → release_vehicle(id)
- defect_release_vehicle(defect_id) → defect(id)
- defect(release_id) → release(id)
- defect(team_id) → team(id)
- defect(created_by) → users(id)
- defect(closed_by) → users(id)
- defect(program_id) → program(id)
- defect(iteration_id) → iteration(id)
- defect(fixed_by) → users(id)
- defect(story_id) → story(id)
- key_result_value_update(score_by) → users(id)
- key_result_value_update(key_result_id) → key_result(id)
- key_result_score_override(override_by) → users(id)
- key_result_score_override(key_result_id) → key_result(id)
- key_result(owner_id) → users(id)
- key_result(parent_id) → key_result(id)
- product_snap_shot(snapshot_id) → snap_shot(id)
- product_snap_shot(product_id) → product(id)
- product_competitor(product_id) → product(id)
- product_personal(product_id) → product(id)
- product(parent_product_id) → product(id)
- product(division_id) → division(id)
- iteration(anchor_sprint_id) → release_anchor_sprint(id)
- iteration(release_id) → release(id)
- iteration(team_id) → team(id)
- iteration(program_id) → program(id)
- iteration(region_id) → region(id)
- task_custom_field(task_id) → task(id)
- task(last_updated_by) → users(id)
- task(created_by) → users(id)
- task(owner_id) → users(id)
- task(story_id) → story(id)
- task(qa_task_id) → task(id)
- feature_custom_field(feature_id) → feature(id)
- feature_link(feature_id) → feature(id)
- feature_process_step(feature_id) → feature(id)
- feature_test_category(feature_id) → feature(id)
- feature_affected_country(feature_id) → feature(id)
- feature_customer(customer_id) → customer(id)
- feature_customer(feature_id) → feature(id)
- feature_objective(objective_id) → objective(id)
- feature_objective(feature_id) → feature(id)
- feature_additional_program(program_id) → program(id)
- feature_additional_program(feature_id) → feature(id)
- feature_release_vehicle(release_vehicle_id) → release_vehicle(id)
- feature_release_vehicle(feature_id) → feature(id)
- feature(product_id) → product(id)
- feature(primary_program_id) → program(id)
- feature(accepted_user_id) → users(id)
- feature(last_updated_by) → users(id)
- feature(release_id) → release(id)
- feature(pending_approval_by) → users(id)
- feature(created_by) → users(id)
- feature(in_progress_by) → users(id)
- feature(owner_id) → users(id)
- feature(test_complete_by) → users(id)
- feature(dev_complete_by) → users(id)
- feature(work_code_id) → epic(work_code_id)
- feature(parent_id) → epic(id)
- feature(theme_id) → theme(id)
- feature(vehicle_id) → release_vehicle(id)
- milestone_custom_field(milestone_id) → milestone(id)
- milestone_link(milestone_id) → milestone(id)
- milestone_team(team_id) → team(id)
- milestone_team(milestone_id) → milestone(id)
- milestone_dependency(milestone_id) → milestone(id)
- milestone_risk(risk_id) → risk(id)
- milestone_risk(milestone_id) → milestone(id)
- milestone_impediment(milestone_id) → milestone(id)
- milestone_feature(feature_id) → feature(id)
- milestone_feature(milestone_id) → milestone(id)
- milestone_epic(epic_id) → epic(id)
- milestone_epic(milestone_id) → milestone(id)
- milestone_release(release_id) → release(id)
- milestone_release(milestone_id) → milestone(id)
- milestone_program(program_id) → program(id)
- milestone_program(milestone_id) → milestone(id)
- milestone(portfolio_id) → portfolio(id)
- milestone(last_updated_by) → users(id)
- milestone(owner_id) → users(id)
- milestone(program_id) → program(id)
- milestone(goal_id) → goal(id)
- milestone(parent_id) → milestone(id)
- milestone(theme_id) → theme(id)
- idea(product_id) → product(id)
- idea(created_by) → users(id)
- idea(owner_id) → users(id)
- portfolio(team_id) → team(id)
- portfolio(division_id) → division(id)
- portfolio(region_id) → region(id)
- portfolio(organization_product_id) → product(id)
- process_step_wip_limit(program_id) → program(id)
- process_step_wip_limit(process_step_id) → value_stream_process_step(id)
- value_stream_process_step(portfolio_id) → portfolio(id)
- value_stream_process_step(value_stream_id) → value_stream(id)
- value_stream_customer(customer_id) → customer(id)
- value_stream_customer(value_stream_id) → value_stream(id)
- value_stream_program(program_id) → program(id)
- value_stream_program(value_stream_id) → value_stream(id)
- value_stream(team_id) → team(id)
- value_stream(region_id) → region(id)
- risk_custom_field(risk_id) → risk(id)
- risk_notify(email) → users(email)
- risk_notify(risk_id) → risk(id)
- risk_link(risk_id) → risk(id)
- risk(last_updated_by) → users(id)
- risk(release_id) → release(id)
- risk(created_by) → users(id)
- risk(closed_by) → users(id)
- risk(owner_id) → users(id)
- risk(program_id) → program(id)