Aha!
Explore the interactive ERD
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 | PKFK |
created_at | Unknown | |
integration_id | Unknown | |
name | Unknown | |
service_name | Unknown | |
value | Unknown |
release_initiative
| Column | Type | Keys |
|---|---|---|
initiative_id | Unknown | PKFK |
release_id | Unknown | PKFK |
release_goal
| Column | Type | Keys |
|---|---|---|
goal_id | Unknown | PKFK |
release_id | Unknown | PKFK |
release_custom_field_score_fact
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
release_custom_field_id | Unknown | PKFK |
release_id | Unknown | PKFK |
name | Unknown | |
value | Unknown |
release_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
release_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
id | Unknown | PKFK |
name | Unknown |
goal_attachment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
goal_id | Unknown | PKFK |
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 | PKFK |
goal_initiative_id | Unknown | PKFK |
created_at | Unknown | |
integration_id | Unknown | |
name | Unknown | |
service_name | Unknown | |
value | Unknown |
goal_initiative
| Column | Type | Keys |
|---|---|---|
goal_id | Unknown | PKFK |
id | Unknown | PKFK |
goal_feature
| Column | Type | Keys |
|---|---|---|
goal_id | Unknown | PKFK |
id | Unknown | PKFK |
goal_release
| Column | Type | Keys |
|---|---|---|
goal_id | Unknown | PKFK |
id | Unknown | PKFK |
goal_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
goal_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
color | Unknown | |
complete | Unknown | |
name | Unknown | |
position | Unknown |
workflow_kind
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
workflow_id | Unknown | PKFK |
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 | PKFK |
epic_id | Unknown | PKFK |
name | Unknown | |
value | Unknown |
epic_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
epic_id | Unknown | PKFK |
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 | PKFK |
ended_at | Unknown | |
started_at | Unknown | |
status_id | 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 | PKFK |
users_id | Unknown | PKFK |
product_name | Unknown | |
role | Unknown | |
role_description | Unknown |
user_role
| Column | Type | Keys |
|---|---|---|
role_id | Unknown | PK |
users_id | Unknown | PKFK |
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 | PKFK |
user_id | Unknown | FK |
status | Unknown |
task_attachment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
task_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 |
|---|---|---|
status_id | Unknown | PK |
idea_id | Unknown | PKFK |
ended_at | Unknown | |
started_at | 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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
initiative_id | Unknown | PKFK |
name | Unknown | |
value | Unknown |
initiative_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
initiative_id | Unknown | PKFK |
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 | PKFK |
initiative_id | Unknown | PKFK |
attachment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
initiative_id | Unknown | PKFK |
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 | PKFK |
initiative_feature
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
initiative_id | Unknown | PKFK |
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 | PKFK |
status_id | Unknown | PKFK |
ended_at | Unknown | |
started_at | Unknown | |
status_name | Unknown |
initiative_integration_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
initiative_id | Unknown | PKFK |
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 | PKFK |
release_id | Unknown | FK |
requirement_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
requirement_id | Unknown | PKFK |
key | Unknown | |
name | Unknown | |
type | Unknown | |
updated_at | Unknown | |
value | Unknown |
requirement_integration_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
requirement_id | Unknown | PKFK |
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 |