# Aha! schema ERD

Table and field reference for the Fivetran Aha! connector.

## Table & Field Reference

### release_phase

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| release_id | Unknown | FK |
| created_at | Unknown |  |
| description_attachment | Json |  |
| description_body | Unknown |  |
| description_created_at | Unknown |  |
| description_id | Unknown |  |
| duration_source | Unknown |  |
| end_on | Unknown |  |
| name | Unknown |  |
| progress | Unknown |  |
| progress_source | Unknown |  |
| start_on | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### release_integration_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| release_id | Unknown | PK, FK |
| created_at | Unknown |  |
| integration_id | Unknown |  |
| name | Unknown |  |
| service_name | Unknown |  |
| value | Unknown |  |

### release_initiative

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

### release_goal

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

### release_custom_field_score_fact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| release_custom_field_id | Unknown | PK, FK |
| release_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### release_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| release_id | Unknown | PK, FK |
| attachments | Json |  |
| body | Unknown |  |
| created_at | Unknown |  |
| email_value | Unknown |  |
| key | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| value | Json |  |

### release

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| owner_id | Unknown | FK |
| parent_id | Unknown | FK |
| product_id | Unknown | FK |
| workflow_status_id | Unknown | FK |
| comments_count | Unknown |  |
| created_at | Unknown |  |
| created_by_user_id | Unknown |  |
| development_started_on | Unknown |  |
| duration_source | Unknown |  |
| end_date | Unknown |  |
| external_date_resolution | Unknown |  |
| external_release_date | Unknown |  |
| external_release_date_description | Unknown |  |
| master_release | Unknown |  |
| name | Unknown |  |
| original_estimate | Unknown |  |
| parking_lot | Unknown |  |
| position | Unknown |  |
| progress | Unknown |  |
| progress_source | Unknown |  |
| project_created_at | Unknown |  |
| project_id | Unknown |  |
| project_name | Unknown |  |
| project_product_line | Unknown |  |
| project_reference_prefix | Unknown |  |
| project_workspace_type | Unknown |  |
| reference_num | Unknown |  |
| release_date | Unknown |  |
| released | Unknown |  |
| released_on | Unknown |  |
| remaining_estimate | Unknown |  |
| resource | Unknown |  |
| start_date | Unknown |  |
| status_changed_on | Unknown |  |
| theme_attachments | Json |  |
| theme_body | Unknown |  |
| theme_created_at | Unknown |  |
| theme_id | Unknown |  |
| theme_updated_at | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |
| work_done | Unknown |  |
| work_units | Unknown |  |
| workflow_status_times | Json |  |

### strategic_model_component

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| strategic_model_id | Unknown | PK, FK |
| description | Unknown |  |
| name | Unknown |  |

### strategic_model

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| kind | Unknown |  |
| name | Unknown |  |
| project_created_at | Unknown |  |
| project_id | Unknown |  |
| project_name | Unknown |  |
| project_product_line | Unknown |  |
| project_reference_prefix | Unknown |  |
| project_workspace_type | Unknown |  |
| resource | Unknown |  |
| url | Unknown |  |

### persona

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | FK |
| created_at | Unknown |  |
| name | Unknown |  |

### goal_parent

| Column | Type | Keys |
| --- | --- | --- |
| goal_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| name | Unknown |  |

### goal_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| goal_id | Unknown | PK, FK |
| content_type | Unknown |  |
| created_at | Unknown |  |
| download_url | Unknown |  |
| file_name | Unknown |  |
| file_size | Unknown |  |
| original_file_size | Unknown |  |
| updated_at | Unknown |  |

### goal_integration_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| goal_id | Unknown | PK, FK |
| goal_initiative_id | Unknown | PK, FK |
| created_at | Unknown |  |
| integration_id | Unknown |  |
| name | Unknown |  |
| service_name | Unknown |  |
| value | Unknown |  |

### goal_initiative

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

### goal_feature

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

### goal_release

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

### goal_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| goal_id | Unknown | PK, FK |
| key | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| value | Unknown |  |

### goal_workflow_status_time

| Column | Type | Keys |
| --- | --- | --- |
| status_id | Unknown | PK |
| goal_id | Unknown | PK, FK |
| ended_at | Unknown |  |
| started_at | Unknown |  |
| status_name | Unknown |  |

### goal

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | FK |
| success_metric_workflow_status_id | Unknown | FK |
| comments_count | Unknown |  |
| created_at | Unknown |  |
| description_body | Unknown |  |
| description_created_at | Unknown |  |
| description_id | Unknown |  |
| effort | Unknown |  |
| name | Unknown |  |
| position | Unknown |  |
| progress | Unknown |  |
| progress_source | Unknown |  |
| project_created_at | Unknown |  |
| project_id | Unknown |  |
| project_name | Unknown |  |
| project_product_line | Unknown |  |
| project_reference_prefix | Unknown |  |
| project_workspace_type | Unknown |  |
| reference_num | Unknown |  |
| resource | Unknown |  |
| success_metric_description_attachment | Json |  |
| success_metric_description_body | Unknown |  |
| success_metric_description_created_at | Unknown |  |
| success_metric_description_id | Unknown |  |
| success_metric_name | Unknown |  |
| time_frame_id | Unknown |  |
| time_frame_name | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |
| value | Unknown |  |

### workflow_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workflow_id | Unknown | PK, FK |
| color | Unknown |  |
| complete | Unknown |  |
| name | Unknown |  |
| position | Unknown |  |

### workflow_kind

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workflow_id | Unknown | PK, FK |
| name | Unknown |  |

### workflow

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | FK |
| name | Unknown |  |
| statusable_type | Unknown |  |
| transitions_only | Unknown |  |

### epic_custom_field_score_fact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| epic_custom_field_id | Unknown | PK, FK |
| epic_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### epic_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| epic_id | Unknown | PK, FK |
| attachments | Json |  |
| body | Unknown |  |
| created_at | Unknown |  |
| email_value | Unknown |  |
| key | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| value | Unknown |  |

### epic_workflow_status_time

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| epic_id | Unknown | PK, FK |
| ended_at | Unknown |  |
| id | Unknown |  |
| started_at | Unknown |  |
| status_name | Unknown |  |

### epic

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_user_id | Unknown | FK |
| owner_id | Unknown | FK |
| product_id | Unknown | FK |
| release_id | Unknown | FK |
| workflow_status_id | Unknown | FK |
| assigned_to_user | Unknown |  |
| attachments | Json |  |
| comments_count | Unknown |  |
| created_at | Unknown |  |
| description_attachments | Json |  |
| description_body | Unknown |  |
| description_created_at | Unknown |  |
| description_id | Unknown |  |
| description_updated_at | Unknown |  |
| due_date | Unknown |  |
| duration_source | Unknown |  |
| epic_links | Json |  |
| epic_only_original_estimate | Unknown |  |
| epic_only_remaining_estimate | Unknown |  |
| epic_only_work_done | Unknown |  |
| features | Json |  |
| full_tags | Json |  |
| goals | Json |  |
| initial_estimate | Unknown |  |
| initiative_reference_num | Unknown |  |
| integration_fields | Json |  |
| master_feature_only_original_estimate | Unknown |  |
| master_feature_only_remaining_estimate | Unknown |  |
| master_feature_only_work_done | Unknown |  |
| name | Unknown |  |
| original_estimate | Unknown |  |
| owner_created_at | Unknown |  |
| owner_email | Unknown |  |
| owner_name | Unknown |  |
| owner_updated_at | Unknown |  |
| position | Unknown |  |
| progress | Unknown |  |
| progress_source | Unknown |  |
| project_created_at | Unknown |  |
| project_id | Unknown |  |
| project_name | Unknown |  |
| project_product_line | Unknown |  |
| project_reference_prefix | Unknown |  |
| project_url | Unknown |  |
| project_workspace_type | Unknown |  |
| reference_num | Unknown |  |
| release_created_at | Unknown |  |
| release_integration_fields | Json |  |
| release_name | Unknown |  |
| release_parking_lot | Unknown |  |
| release_product_id | Unknown |  |
| release_reference_num | Unknown |  |
| release_resource | Unknown |  |
| release_url | Unknown |  |
| remaining_estimate | Unknown |  |
| resource | Unknown |  |
| score | Unknown |  |
| score_facts | Json |  |
| start_date | Unknown |  |
| status_changed_on | Unknown |  |
| tags | Json |  |
| time_tracking_events | Json |  |
| updated_at | Unknown |  |
| url | Unknown |  |
| use_feature_estimates | Unknown |  |
| work_done | Unknown |  |
| work_units | Unknown |  |
| workflow_status_color | Unknown |  |
| workflow_status_complete | Unknown |  |
| workflow_status_name | Unknown |  |
| workflow_status_position | Unknown |  |

### record_link

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| child_record_id | Unknown | FK |
| feature_id | Unknown | FK |
| parent_record_id | Unknown | FK |
| child_record_created_at | Unknown |  |
| child_record_name | Unknown |  |
| child_record_product_id | Unknown |  |
| child_record_reference_num | Unknown |  |
| child_record_resource | Unknown |  |
| child_record_type | Unknown |  |
| child_record_url | Unknown |  |
| created_at | Unknown |  |
| link_type | Unknown |  |
| link_type_id | Unknown |  |
| parent | Unknown |  |
| parent_record_created_at | Unknown |  |
| parent_record_name | Unknown |  |
| parent_record_product_id | Unknown |  |
| parent_record_reference_num | Unknown |  |
| parent_record_resource | Unknown |  |
| parent_record_type | Unknown |  |
| parent_record_url | Unknown |  |

### user_product_role

| Column | Type | Keys |
| --- | --- | --- |
| product_id | Unknown | PK, FK |
| users_id | Unknown | PK, FK |
| product_name | Unknown |  |
| role | Unknown |  |
| role_description | Unknown |  |

### user_role

| Column | Type | Keys |
| --- | --- | --- |
| role_id | Unknown | PK |
| users_id | Unknown | PK, FK |
| name | Unknown |  |
| scope_id | Unknown |  |
| scope_name | Unknown |  |
| scope_type | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| accessed_at | Unknown |  |
| administer_account | Unknown |  |
| administer_billing | Unknown |  |
| administer_configuration | Unknown |  |
| administrator | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| enabled | Unknown |  |
| identity_provider_name | Unknown |  |
| identity_provider_type | Unknown |  |
| name | Unknown |  |
| paid_seat | Unknown |  |
| paid_seat_group_id | Unknown |  |
| paid_seat_group_name | Unknown |  |
| updated_at | Unknown |  |

### task_assigned_to_user

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| task_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| status | Unknown |  |

### task_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| task_id | Unknown | PK, FK |
| content_type | Unknown |  |
| created_at | Unknown |  |
| download_url | Unknown |  |
| file_name | Unknown |  |
| file_size | Unknown |  |
| original_file_size | Unknown |  |
| updated_at | Unknown |  |

### task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_user_id | Unknown | FK |
| product_id | Unknown | FK |
| body | Unknown |  |
| comments_count | Unknown |  |
| created_at | Unknown |  |
| due_date | Unknown |  |
| name | Unknown |  |
| position | Unknown |  |
| resource | Unknown |  |
| status | Unknown |  |
| taskable_id | Unknown |  |
| taskable_name | Unknown |  |
| taskable_reference_num | Unknown |  |
| taskable_resource | Unknown |  |
| taskable_type | Unknown |  |
| taskable_url | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |

### strategic_vision_component

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| strategic_vision_id | Unknown | PK, FK |
| name | Unknown |  |
| title | Unknown |  |

### strategic_vision

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| project_created_at | Unknown |  |
| project_id | Unknown |  |
| project_name | Unknown |  |
| project_product_line | Unknown |  |
| project_reference_prefix | Unknown |  |
| project_workspace_type | Unknown |  |
| resource | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |

### integration

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| name | Unknown |  |
| service_name | Unknown |  |

### idea_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| idea_id | Unknown | PK, FK |
| attachments | Unknown |  |
| body | Unknown |  |
| created_at | Unknown |  |
| editor_version | Unknown |  |
| email_value | Unknown |  |
| key | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| value | Json |  |

### idea_workflow_status_time

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| idea_id | Unknown | PK, FK |
| ended_at | Unknown |  |
| started_at | Unknown |  |
| status_id | Unknown |  |
| status_name | Unknown |  |

### idea

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assigned_to_user_id | Unknown | FK |
| created_by_idea_user_id | Unknown | FK |
| created_by_user_id | Unknown | FK |
| epic_id | Unknown | FK |
| master_feature_id | Unknown | FK |
| product_id | Unknown | FK |
| workflow_status_id | Unknown | FK |
| categories | Json |  |
| created_at | Unknown |  |
| created_by_portal_user_created_at | Unknown |  |
| created_by_portal_user_email | Unknown |  |
| created_by_portal_user_id | Unknown |  |
| created_by_portal_user_name | Unknown |  |
| description_attachments | Json |  |
| description_body | Unknown |  |
| description_created_at | Unknown |  |
| description_editor_version | Unknown |  |
| description_id | Unknown |  |
| description_notable_id | Unknown |  |
| description_notable_type | Unknown |  |
| description_updated_at | Unknown |  |
| endorsements_count | Unknown |  |
| full_tags | Json |  |
| initial_votes | Unknown |  |
| integration_fields | Json |  |
| name | Unknown |  |
| reference_num | Unknown |  |
| resource | Unknown |  |
| score | Unknown |  |
| score_facts | Json |  |
| status_changed_at | Unknown |  |
| submitted_idea_portal_record_url | Unknown |  |
| tags | Json |  |
| updated_at | Unknown |  |
| url | Unknown |  |
| visibility | Unknown |  |

### idea_user_organizations

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| idea_user_id | Unknown | PK, FK |
| id | Unknown | FK |

### idea_user

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| custom_fields | Json |  |
| discovery_interview_count | Unknown |  |
| discovery_last_interview | Unknown |  |
| discovery_last_invite | Unknown |  |
| discovery_next_interview | Unknown |  |
| email | Unknown |  |
| integration_fields | Json |  |
| name | Unknown |  |

### strategic_component

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| strategic_position_id | Unknown | PK, FK |
| description | Unknown |  |
| name | Unknown |  |

### strategic_position

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| kind | Unknown |  |
| name | Unknown |  |
| project_created_at | Unknown |  |
| project_id | Unknown |  |
| project_name | Unknown |  |
| project_product_line | Unknown |  |
| project_reference_prefix | Unknown |  |
| project_workspace_type | Unknown |  |
| resource | Unknown |  |
| url | Unknown |  |

### idea_subscription

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| idea_id | Unknown | FK |
| workflow_status_id | Unknown | FK |
| created_at | Unknown |  |
| description_attachments | Json |  |
| description_body | Unknown |  |
| description_created_at | Unknown |  |
| description_editor_version | Unknown |  |
| description_id | Unknown |  |
| description_notable_id | Unknown |  |
| description_notable_type | Unknown |  |
| description_updated_at | Unknown |  |
| portal_user_created_at | Unknown |  |
| portal_user_email | Unknown |  |
| portal_user_id | Unknown |  |
| portal_user_name | Unknown |  |

### feature_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| feature_id | Unknown | PK, FK |
| key | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| value | Unknown |  |

### feature

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | FK |
| release_id | Unknown | FK |
| workflow_id | Unknown | FK |
| created_at | Unknown |  |
| created_by_user_id | Unknown |  |
| description_attachment | Json |  |
| description_body | Unknown |  |
| description_created_at | Unknown |  |
| description_id | Unknown |  |
| description_updated_at | Unknown |  |
| due_date | Unknown |  |
| epic_reference_num | Unknown |  |
| feature_only_original_estimate | Unknown |  |
| feature_only_remaining_estimate | Unknown |  |
| feature_only_work_done | Unknown |  |
| goal_id | Unknown |  |
| initial_estimate | Unknown |  |
| initiative_id | Unknown |  |
| initiative_reference_num | Unknown |  |
| name | Unknown |  |
| original_estimate | Unknown |  |
| position | Unknown |  |
| progress | Unknown |  |
| progress_source | Unknown |  |
| reference_num | Unknown |  |
| release_reference_num | Unknown |  |
| remaining_estimate | Unknown |  |
| requirement_id | Unknown |  |
| resource | Unknown |  |
| score | Unknown |  |
| start_date | Unknown |  |
| status_changed_on | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |
| use_requirements_estimates | Unknown |  |
| work_done | Unknown |  |
| work_units | Unknown |  |

### release_feature

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

### competitor

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | FK |
| created_at | Unknown |  |
| name | Unknown |  |

### idea_comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| idea_commenter_idea_user_id | Unknown | FK |
| idea_commenter_user_id | Unknown | FK |
| idea_id | Unknown | FK |
| workflow_status_id | Unknown | FK |
| attachments | Json |  |
| body | Unknown |  |
| created_at | Unknown |  |
| description_attachments | Json |  |
| description_body | Unknown |  |
| description_created_at | Unknown |  |
| description_editor_version | Unknown |  |
| description_id | Unknown |  |
| description_updated_at | Unknown |  |
| idea_commenter_portal_user_created_at | Unknown |  |
| idea_commenter_portal_user_email | Unknown |  |
| idea_commenter_portal_user_id | Unknown |  |
| idea_commenter_portal_user_name | Unknown |  |
| parent_idea_comment_id | Unknown |  |
| visibility | Unknown |  |

### idea_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | PK, FK |
| created_at | Unknown |  |
| description_attachments | Json |  |
| description_body | Unknown |  |
| description_created_at | Unknown |  |
| description_editor_version | Unknown |  |
| description_id | Unknown |  |
| description_notable_id | Unknown |  |
| description_notable_type | Unknown |  |
| description_updated_at | Unknown |  |
| name | Unknown |  |
| parent_id | Unknown |  |
| project_id | Unknown |  |

### idea_organization

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_user_id | Unknown | FK |
| created_at | Unknown |  |
| custom_fields | Json |  |
| description_attachments | Json |  |
| description_body | Unknown |  |
| description_created_at | Unknown |  |
| description_editor_version | Unknown |  |
| description_id | Unknown |  |
| description_notable_id | Unknown |  |
| description_notable_type | Unknown |  |
| description_updated_at | Unknown |  |
| email_domains | Unknown |  |
| endorsements_count | Unknown |  |
| integration_fields | Json |  |
| name | Unknown |  |
| reference_num | Unknown |  |
| revenue | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |

### creative_brief

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product_id | Unknown | FK |
| created_at | Unknown |  |
| name | Unknown |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_id | Unknown | FK |
| capacity_planning_enabled | Unknown |  |
| children | Json |  |
| created_at | Unknown |  |
| default_capacity_units | Unknown |  |
| description_attachments | Json |  |
| description_body | Unknown |  |
| description_created_at | Unknown |  |
| description_id | Unknown |  |
| description_updated_at | Unknown |  |
| enhanced_capacity_planning_enabled | Unknown |  |
| has_epics | Unknown |  |
| has_ideas | Unknown |  |
| has_master_features | Unknown |  |
| name | Unknown |  |
| product_line | Unknown |  |
| product_line_type | Unknown |  |
| reference_prefix | Unknown |  |
| resource | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |
| workspace_type | Unknown |  |
| custom_** |  |  |

### initiative_custom_field_score_fact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| initiative_custom_field_id | Unknown | PK, FK |
| initiative_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### initiative_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| initiative_id | Unknown | PK, FK |
| attachments | Json |  |
| body | Unknown |  |
| created_at | Unknown |  |
| email_value | Unknown |  |
| key | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| value | Json |  |

### initiative_epic

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

### attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| initiative_id | Unknown | PK, FK |
| content_type | Unknown |  |
| created_at | Unknown |  |
| download_url | Unknown |  |
| file_name | Unknown |  |
| file_size | Unknown |  |
| original_file_size | Unknown |  |
| updated_at | Unknown |  |

### master_feature

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

### initiative_feature

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| initiative_id | Unknown | PK, FK |
| product_id | Unknown | FK |
| created_at | Unknown |  |
| name | Unknown |  |
| reference_num | Unknown |  |
| resource | Unknown |  |
| url | Unknown |  |

### workflow_status_time

| Column | Type | Keys |
| --- | --- | --- |
| initiative_id | Unknown | PK, FK |
| status_id | Unknown | PK, FK |
| ended_at | Unknown |  |
| started_at | Unknown |  |
| status_name | Unknown |  |

### initiative_integration_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| initiative_id | Unknown | PK, FK |
| created_at | Unknown |  |
| integration_id | Unknown |  |
| name | Unknown |  |
| service_name | Unknown |  |
| value | Unknown |  |

### initiative

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assigned_to_user_id | Unknown | FK |
| created_by_user_id | Unknown | FK |
| product_id | Unknown | FK |
| workflow_status_id | Unknown | FK |
| attachment | Json |  |
| color | Unknown |  |
| comments_count | Unknown |  |
| created_at | Unknown |  |
| description_body | Unknown |  |
| description_created_at | Unknown |  |
| description_id | Unknown |  |
| duration_source | Unknown |  |
| effort | Unknown |  |
| end_date | Unknown |  |
| initial_estimate | Unknown |  |
| name | Unknown |  |
| original_estimate | Unknown |  |
| position | Unknown |  |
| presented | Unknown |  |
| progress | Unknown |  |
| progress_source | Unknown |  |
| project_created_at | Unknown |  |
| project_id | Unknown |  |
| project_name | Unknown |  |
| project_product_line | Unknown |  |
| project_reference_prefix | Unknown |  |
| project_workspace_type | Unknown |  |
| reference_num | Unknown |  |
| remaining_estimate | Unknown |  |
| resource | Unknown |  |
| score | Unknown |  |
| score_facts | Json |  |
| start_date | Unknown |  |
| status | Unknown |  |
| time_frame_id | Unknown |  |
| time_frame_name | Unknown |  |
| time_tracking_events | Json |  |
| updated_at | Unknown |  |
| url | Unknown |  |
| value | Unknown |  |
| work_done | Unknown |  |
| work_units | Unknown |  |

### idea_vote

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| endorsed_by_idea_user_id | Unknown | FK |
| idea_id | Unknown | FK |
| idea_organization_id | Unknown | FK |
| workflow_status_id | Unknown | FK |
| created_at | Unknown |  |
| custom_fields | Json |  |
| description_attachments | Json |  |
| description_body | Unknown |  |
| description_created_at | Unknown |  |
| description_editor_version | Unknown |  |
| description_id | Unknown |  |
| description_notable_id | Unknown |  |
| description_notable_type | Unknown |  |
| description_updated_at | Unknown |  |
| endorsed_by_portal_user_created_at | Unknown |  |
| endorsed_by_portal_user_email | Unknown |  |
| endorsed_by_portal_user_id | Unknown |  |
| endorsed_by_portal_user_name | Unknown |  |
| idea_description_attachments | Json |  |
| idea_description_body | Unknown |  |
| idea_description_created_at | Unknown |  |
| idea_description_editor_version | Unknown |  |
| idea_description_id | Unknown |  |
| idea_description_notable_id | Unknown |  |
| idea_description_notable_type | Unknown |  |
| idea_description_updated_at | Unknown |  |
| integration_fields | Json |  |
| link | Unknown |  |
| updated_at | Unknown |  |
| value | Unknown |  |
| weight | Unknown |  |

### release_epic

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

### requirement_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| requirement_id | Unknown | PK, FK |
| key | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| value | Unknown |  |

### requirement_integration_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| requirement_id | Unknown | PK, FK |
| created_at | Unknown |  |
| integration_id | Unknown |  |
| name | Unknown |  |
| service_name | Unknown |  |
| value | Unknown |  |

### requirement

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assigned_to_user_id | Unknown | FK |
| created_by_user_id | Unknown | FK |
| feature_id | Unknown | FK |
| release_id | Unknown | FK |
| workflow_status_id | Unknown | FK |
| attachment | Json |  |
| comments_count | Unknown |  |
| created_at | Unknown |  |
| description_attachment | Json |  |
| description_body | Unknown |  |
| description_created_at | Unknown |  |
| description_id | Unknown |  |
| full_tags | Json |  |
| name | Unknown |  |
| position | Unknown |  |
| reference_num | Unknown |  |
| resource | Unknown |  |
| tags | Json |  |
| updated_at | Unknown |  |
| url | Unknown |  |

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| automatically_calculate_team_members_count | Unknown |  |
| capacity | Unknown |  |
| color | Unknown |  |
| custom_fieldo | Json |  |
| end_date | Unknown |  |
| hourly_rate | Unknown |  |
| name | Unknown |  |
| project_id | Unknown |  |
| project_name | Unknown |  |
| project_product_line | Unknown |  |
| project_reference_prefix | Unknown |  |
| project_workspace_type | Unknown |  |
| schedule_hours_per_day | Unknown |  |
| schedule_id | Unknown |  |
| schedule_name | Unknown |  |
| schedule_story_points_per_day | Unknown |  |
| schedule_velocity | Unknown |  |
| start_date | Unknown |  |
| team_members_count | Unknown |  |
| team_members_email | Unknown |  |
| team_members_id | Unknown |  |
| team_members_name | Unknown |  |
| team_members_user_id | Unknown |  |
| team_members_virtual | Unknown |  |

## Relationships

- release_phase(release_id) → release(id)
- release_integration_field(release_id) → release(id)
- release_initiative(initiative_id) → initiative(id)
- release_initiative(release_id) → release(id)
- release_goal(goal_id) → goal(id)
- release_goal(release_id) → release(id)
- release_custom_field_score_fact(release_id) → release_custom_field(release_id)
- release_custom_field_score_fact(release_custom_field_id) → release_custom_field(id)
- release_custom_field(release_id) → release(id)
- release(product_id) → product(id)
- release(owner_id) → users(id)
- release(parent_id) → release(id)
- release(workflow_status_id) → workflow_status(id)
- strategic_model_component(strategic_model_id) → strategic_model(id)
- persona(product_id) → product(id)
- goal_parent(id) → goal(id)
- goal_parent(goal_id) → goal(id)
- goal_attachment(goal_id) → goal(id)
- goal_integration_field(goal_id) → goal(id)
- goal_integration_field(goal_initiative_id) → goal_initiative(id)
- goal_initiative(id) → initiative(id)
- goal_initiative(goal_id) → goal(id)
- goal_feature(id) → feature(id)
- goal_feature(goal_id) → goal(id)
- goal_release(id) → release(id)
- goal_release(goal_id) → goal(id)
- goal_custom_field(goal_id) → goal(id)
- goal_workflow_status_time(goal_id) → goal(id)
- goal(product_id) → product(id)
- goal(success_metric_workflow_status_id) → workflow_status(id)
- workflow_status(workflow_id) → workflow(id)
- workflow_kind(workflow_id) → workflow(id)
- workflow(product_id) → product(id)
- epic_custom_field_score_fact(epic_id) → epic_custom_field(epic_id)
- epic_custom_field_score_fact(epic_custom_field_id) → epic_custom_field(id)
- epic_custom_field(epic_id) → epic(id)
- epic_workflow_status_time(epic_id) → epic(id)
- epic(product_id) → product(id)
- epic(created_by_user_id) → users(id)
- epic(workflow_status_id) → workflow_status(id)
- epic(release_id) → release(id)
- epic(owner_id) → users(id)
- record_link(parent_record_id) → record_link(id)
- record_link(child_record_id) → record_link(id)
- record_link(feature_id) → feature(id)
- user_product_role(product_id) → product(id)
- user_product_role(users_id) → users(id)
- user_role(users_id) → users(id)
- task_assigned_to_user(user_id) → users(id)
- task_assigned_to_user(task_id) → task(id)
- task_attachment(task_id) → task(id)
- task(product_id) → product(id)
- task(created_by_user_id) → users(id)
- strategic_vision_component(strategic_vision_id) → strategic_vision(id)
- idea_custom_field(idea_id) → idea(id)
- idea_workflow_status_time(idea_id) → idea(id)
- idea(product_id) → product(id)
- idea(workflow_status_id) → workflow_status(id)
- idea(assigned_to_user_id) → users(id)
- idea(created_by_idea_user_id) → idea_user(id)
- idea(master_feature_id) → master_feature(id)
- idea(epic_id) → epic(id)
- idea(created_by_user_id) → users(id)
- idea_user_organizations(id) → idea_organization(id)
- idea_user_organizations(idea_user_id) → idea_user(id)
- strategic_component(strategic_position_id) → strategic_position(id)
- idea_subscription(idea_id) → idea(id)
- idea_subscription(workflow_status_id) → workflow_status(id)
- feature_custom_field(feature_id) → feature(id)
- feature(product_id) → product(id)
- feature(release_id) → release(id)
- feature(workflow_id) → workflow(id)
- release_feature(feature_id) → feature(id)
- release_feature(product_id) → product(id)
- release_feature(release_id) → release(id)
- competitor(product_id) → product(id)
- idea_comment(idea_id) → idea(id)
- idea_comment(idea_commenter_user_id) → users(id)
- idea_comment(idea_commenter_idea_user_id) → idea_user(id)
- idea_comment(workflow_status_id) → workflow_status(id)
- idea_category(product_id) → product(id)
- idea_organization(created_by_user_id) → users(id)
- creative_brief(product_id) → product(id)
- product(parent_id) → product(id)
- initiative_custom_field_score_fact(initiative_id) → initiative_custom_field(initiative_id)
- initiative_custom_field_score_fact(initiative_custom_field_id) → initiative_custom_field(id)
- initiative_custom_field(initiative_id) → initiative(id)
- initiative_epic(epic_id) → epic(id)
- initiative_epic(initiative_id) → initiative(id)
- attachment(initiative_id) → initiative(id)
- master_feature(initiative_id) → initiative(id)
- initiative_feature(product_id) → product(id)
- initiative_feature(initiative_id) → initiative(id)
- workflow_status_time(status_id) → workflow_status(id)
- workflow_status_time(initiative_id) → initiative(id)
- initiative_integration_field(id) → integration(id)
- initiative_integration_field(initiative_id) → initiative(id)
- initiative(product_id) → product(id)
- initiative(created_by_user_id) → users(id)
- initiative(assigned_to_user_id) → users(id)
- initiative(workflow_status_id) → workflow_status(id)
- idea_vote(idea_id) → idea(id)
- idea_vote(endorsed_by_idea_user_id) → idea_user(id)
- idea_vote(idea_organization_id) → idea_organization(id)
- idea_vote(workflow_status_id) → workflow_status(id)
- release_epic(epic_id) → epic(id)
- release_epic(release_id) → release(id)
- requirement_custom_field(requirement_id) → requirement(id)
- requirement_integration_field(id) → integration(id)
- requirement_integration_field(requirement_id) → requirement(id)
- requirement(created_by_user_id) → users(id)
- requirement(release_id) → release(id)
- requirement(feature_id) → feature(id)
- requirement(assigned_to_user_id) → users(id)
- requirement(workflow_status_id) → workflow_status(id)