Description

The following provides a description of the schema for a subset of the tables that can be automatically generated using the techniques discussed here.

Links

How to create and update database tables from list actions

Tables

Table

Columns

Keys

bamboo_builds

Column	Data Type	Nullable
project	text	YES
project_name	text	YES
plan	text	YES
name	text	YES
build	text	NO
number	bigint	YES
state	text	YES
build_reason	text	YES
test_summary	text	YES
tests_successful	bigint	YES
tests_failed	bigint	YES
tests_skipped	bigint	YES
tests_quarantined	bigint	YES
started	timestamp with time zone	YES
completed	timestamp with time zone	YES
relative_time	text	YES
duration	numeric	YES
duration_seconds	bigint	YES
duration_description	text	YES
issues	text	YES
revisions	text	YES
url	text	YES
refreshed	timestamp with time zone	NO

Column
build

bamboo_plans

Column	Data Type	Nullable
project	text	YES
project_name	text	YES
plan	text	NO
name	text	YES
description	text	YES
short_key	text	YES
full_name	text	YES
enabled	boolean	YES
active	boolean	YES
building	boolean	YES
favorite	boolean	YES
average_build_time	numeric	YES
url	text	YES
build	text	YES
number	bigint	YES
state	text	YES
build_reason	text	YES
test_summary	text	YES
tests_successful	bigint	YES
tests_failed	bigint	YES
tests_skipped	bigint	YES
tests_quarantined	bigint	YES
started	timestamp with time zone	YES
completed	timestamp with time zone	YES
relative_time	text	YES
duration	numeric	YES
duration_seconds	bigint	YES
duration_description	text	YES
labels	text	YES
issues	text	YES
revisions	text	YES
build_url	text	YES
refreshed	timestamp with time zone	NO

Column
plan

bamboo_projects

Column	Data Type	Nullable
key	text	NO
name	text	YES
description	text	YES
plan_count	bigint	YES
refreshed	timestamp with time zone	NO

Column
key

bitbucketcloud_repositories

Column	Data Type	Nullable
project	text	YES
project_name	text	YES
slug	text	NO
name	text	YES
description	text	YES
owner	text	NO
scm	text	YES
public	boolean	YES
forkable	boolean	YES
refreshed	timestamp with time zone	NO

Column
slug
owner

bitbucket_commits

Column	Data Type	Nullable
project	text	NO
repository	text	NO
id	text	NO
display_id	text	YES
author	text	YES
author_name	text	YES
commit_date	timestamp with time zone	YES
message	text	YES
parents	text	YES
jira_keys	text	YES
refreshed	timestamp with time zone	NO

Column
project
repository
id

bitbucket_projects

Column	Data Type	Nullable
key	text	NO
name	text	YES
description	text	YES
id	bigint	YES
type	text	YES
public	boolean	YES
link	text	YES
url	text	YES
refreshed	timestamp with time zone	NO

Column
key

bitbucket_pull_requests

Column	Data Type	Nullable
project	text	NO
repository	text	NO
id	bigint	NO
version	bigint	YES
name	text	YES
description	text	YES
state	text	YES
created	timestamp with time zone	YES
updated	timestamp with time zone	YES
from	text	YES
to	text	YES
author	text	YES
reviewers	text	YES
participants	text	YES
url	text	YES
refreshed	timestamp with time zone	NO

Column
project
repository
id

bitbucket_repositories

Column	Data Type	Nullable
project	text	NO
slug	text	NO
name	text	YES
id	bigint	YES
scm	text	YES
state	text	YES
status	text	YES
public	boolean	YES
forkable	boolean	YES
clone_url	text	YES
clone_ssh_url	text	YES
link	text	YES
url	text	YES
refreshed	timestamp with time zone	NO

Column
project
slug

confluence_attachments

Column	Data Type	Nullable
space	text	YES
title	text	YES
id	bigint	NO
alternate_id	text	YES
parent_title	text	YES
parent_type	text	YES
parent_id	bigint	YES
version_number	bigint	YES
file_name	text	YES
file_size	bigint	YES
content_type	text	YES
comment	text	YES
creator	text	YES
created	timestamp with time zone	YES
url	text	YES
refreshed	timestamp with time zone	NO

Column
id

confluence_blogs

Column	Data Type	Nullable
space	text	YES
title	text	YES
id	bigint	NO
author	text	YES
created	timestamp with time zone	YES
modifier	text	YES
modified	timestamp with time zone	YES
version	bigint	YES
url	text	YES
content	text	YES
refreshed	timestamp with time zone	NO

Column
id

confluence_comments

Column	Data Type	Nullable
space	text	YES
title	text	YES
page_id	bigint	YES
parent_id	bigint	YES
id	bigint	NO
author	text	YES
created	timestamp with time zone	YES
modifier	text	YES
updated	timestamp with time zone	YES
content	text	YES
refreshed	timestamp with time zone	NO

Column
id

confluence_pages

Column	Data Type	Nullable
space	text	YES
title	text	YES
id	bigint	NO
parent_id	bigint	YES
author	text	YES
created	timestamp with time zone	YES
modifier	text	YES
modified	timestamp with time zone	YES
version	bigint	YES
url	text	YES
content	text	YES
refreshed	timestamp with time zone	NO

Column
id

confluence_permissions

Column	Data Type	Nullable
view	text	YES
refreshed	timestamp with time zone	NO

Column

confluence_questions

Column	Data Type	Nullable
id	bigint	NO
title	text	YES
date_asked	timestamp with time zone	YES
author	text	YES
author_name	text	YES
answers	bigint	YES
votes	bigint	YES
content	text	YES
refreshed	timestamp with time zone	NO

Column
id

confluence_space_permissions

Column	Data Type	Nullable
space	text	NO
space_name	text	YES
space_type	text	YES
id_type	text	NO
id	text	NO
view	boolean	YES
delete_own	boolean	YES
pages_add	boolean	YES
pages_delete	boolean	YES
blog_add	boolean	YES
blog_delete	boolean	YES
attachments_add	boolean	YES
attachments_delete	boolean	YES
comments_add	boolean	YES
comments_remove	boolean	YES
restrictions	boolean	YES
mail_delete	boolean	YES
space_export	boolean	YES
admin	boolean	YES
refreshed	timestamp with time zone	NO

Column
space
id_type
id

confluence_spaces

Column	Data Type	Nullable
key	text	NO
name	text	YES
description	text	YES
id	bigint	YES
home_page	text	YES
home_page_id	bigint	YES
type	text	YES
categories	text	YES
url	text	YES
refreshed	timestamp with time zone	NO

Column
key

confluence_topics

Column	Data Type	Nullable
name	text	YES
id	bigint	NO
description	text	YES
featured	boolean	YES
watching	boolean	YES
number_of_questions	bigint	YES
refreshed	timestamp with time zone	NO

Column
id

confluence_trash

Column	Data Type	Nullable
id	bigint	NO
type	text	YES
space	text	YES
title	text	YES
created	timestamp with time zone	YES
creator	text	YES
modified	timestamp with time zone	YES
modifier	text	YES
refreshed	timestamp with time zone	NO

Column
id

confluence_users

Column	Data Type	Nullable
user	text	YES
user_key	text	YES
name	text	YES
email	text	YES
type	text	YES
url	text	YES
refreshed	timestamp with time zone	NO

Column

confluence_watches

Column	Data Type	Nullable
space	text	NO
title	text	YES
id	bigint	NO
user_id	text	NO
refreshed	timestamp with time zone	NO

Column
space
id
user_id

hipchat_rooms

Column	Data Type	Nullable
id	bigint	NO
name	text	YES
topic	text	YES
xmpp_id	text	YES
access	text	YES
created	timestamp with time zone	YES
owner_id	bigint	YES
owner_name	text	YES
owner_mention_name	text	YES
members_url	text	YES
participants_url	text	YES
statistics_url	text	YES
guest_access_url	text	YES
guest_access	boolean	YES
archived	boolean	YES
message_count	bigint	YES
last_active	timestamp with time zone	YES
refreshed	timestamp with time zone	NO

Column
id

jira_application_links

Column	Data Type	Nullable
name	text	YES
type	text	YES
id	text	NO
primary	boolean	YES
system	boolean	YES
url	text	YES
application_url	text	YES
working	boolean	YES
error_category	text	YES
error_type	text	YES
local_authentication_outgoing	text	YES
local_authentication_incoming	text	YES
remote_authentication_outgoing	text	YES
remote_authentication_incoming	text	YES
refreshed	timestamp with time zone	NO

Column
id

jira_attachments

Column	Data Type	Nullable
issue	text	NO
id	bigint	NO
name	text	YES
mime_type	text	YES
size	bigint	YES
date_created	timestamp with time zone	YES
author	text	YES
refreshed	timestamp with time zone	NO

Column
issue
id

jira_boards

Column	Data Type	Nullable
name	text	YES
id	bigint	NO
description	text	YES
type	text	YES
filter_id	bigint	YES
refreshed	timestamp with time zone	NO

Column
id

jira_comments

Column	Data Type	Nullable
issue	text	NO
id	bigint	NO
author	text	YES
created	timestamp with time zone	YES
update_author	text	YES
updated	text	YES
visibility	text	YES
comment	text	YES
refreshed	timestamp with time zone	NO

Column
issue
id

jira_components

Column	Data Type	Nullable
project	text	YES
id	bigint	YES
name	text	YES
description	text	YES
lead	text	YES
assignee_type	text	YES
refreshed	timestamp with time zone	NO

Column

jira_custom_fields

Column	Data Type	Nullable
id	text	NO
name	text	YES
description	text	YES
orderable	boolean	YES
navigable	boolean	YES
searchable	boolean	YES
custom	boolean	YES
custom_id	bigint	YES
custom_type	text	YES
type	text	YES
item_type	text	YES
refreshed	timestamp with time zone	NO

Column
id

jira_groups

Column	Data Type	Nullable
name	text	NO
refreshed	timestamp with time zone	NO

Column
name

jira_issue_histories

Column	Data Type	Nullable
issue	text	NO
history_id	bigint	NO
author	text	YES
created	timestamp with time zone	YES
field	text	YES
type	text	NO
from	bigint	YES
from_string	text	YES
to	bigint	YES
to_string	text	YES
refreshed	timestamp with time zone	NO

Column
issue
history_id
type

jira_issue_history

Column	Data Type	Nullable
issue	text	NO
history_id	bigint	NO
author	text	YES
created	timestamp with time zone	YES
field	text	NO
type	text	NO
from_string	text	YES
to_string	text	YES
from	text	YES
to	text	YES
refreshed	timestamp with time zone	NO

Column
issue
history_id
field
type

jira_issues

Column	Data Type	Nullable
key	text	NO
id	bigint	YES
project	text	YES
project_id	bigint	YES
parent	text	YES
parent_id	text	YES
type	text	YES
type_id	bigint	YES
status	text	YES
status_id	bigint	YES
priority	text	YES
priority_id	bigint	YES
resolution	text	YES
resolution_id	bigint	YES
assignee	text	YES
reporter	text	YES
created	timestamp with time zone	YES
updated	timestamp with time zone	YES
due	text	YES
resolution_date	timestamp with time zone	YES
summary	text	YES
description	text	YES
environment	text	YES
components	text	YES
component_ids	text	YES
affects_versions	text	YES
affects_version_ids	text	YES
fix_versions	text	YES
fix_version_ids	text	YES
original_estimate	text	YES
current_estimate	text	YES
time_spent	text	YES
aggregate_original_estimate	text	YES
aggregate_current_estimate	text	YES
aggregate_time_spent	text	YES
vote_count	bigint	YES
watch_count	bigint	YES
labels	text	YES
subtasks	text	YES
link_keys	text	YES
link_ids	text	YES
link_type_ids	text	YES
link_names	text	YES
link_directional_names	text	YES
link_directions	text	YES
security_level	text	YES
security_level_id	text	YES
addon_name	text	YES
addon_version	text	YES
approvals	text	YES
approvers	text	YES
business_value	text	YES
change_completion_date	text	YES
change_reason	text	YES
change_risk	text	YES
change_start_date	text	YES
change_type	text	YES
customer_request_type	text	YES
d	text	YES
development	text	YES
epic_colour	text	YES
epic_link	text	YES
epic_name	text	YES
epic_status	text	YES
epictheme	text	YES
flagged	text	YES
host_product_version	text	YES
impact	text	YES
impeded	text	YES
jira_capture_browser	text	YES
jira_capture_document_mode	text	YES
jira_capture_operating_system	text	YES
jira_capture_screen_resolution	text	YES
jira_capture_url	text	YES
jira_capture_user_agent	text	YES
jira_capture_jquery_version	text	YES
message_field_for_edit_1	text	YES
organizations	text	YES
parent_link	text	YES
raised_during	text	YES
rank	text	YES
release_version_history	text	YES
request_language	text	YES
request_participants	text	YES
s	text	YES
satisfaction	text	YES
satisfaction_date	text	YES
sprint	text	YES
story_points	text	YES
support_entitlement	text	YES
team	text	YES
test_sessions	text	YES
testing_status	text	YES
time_to_first_response	text	YES
time_to_resolution	text	YES
chart_date_of_first_response	text	YES
chart_time_in_status	text	YES
refreshed	timestamp with time zone	NO

Column
key

jira_issue_types

Column	Data Type	Nullable
id	bigint	NO
subtask	boolean	YES
name	text	YES
description	text	YES
icon	text	YES
refreshed	timestamp with time zone	NO

Column
id

jira_links

Column	Data Type	Nullable
issue	text	NO
to_issue	text	NO
type_name	text	YES
type_id	bigint	NO
link_description	text	YES
link_direction	text	YES
link_id	bigint	YES
refreshed	timestamp with time zone	NO

Column
issue
to_issue
type_id

jira_link_types

Column	Data Type	Nullable
id	bigint	NO
name	text	YES
inward	text	YES
outward	text	YES
refreshed	timestamp with time zone	NO

Column
id

jira_project_categories

Column	Data Type	Nullable
id	bigint	YES
category	text	NO
description	text	YES
projects	text	YES
refreshed	timestamp with time zone	NO

Column
category

jira_project_roles

Column	Data Type	Nullable
name	text	YES
description	text	YES
id	bigint	NO
actors	text	YES
refreshed	timestamp with time zone	NO

Column
id

jira_projects

Column	Data Type	Nullable
key	text	NO
id	bigint	YES
name	text	YES
description	text	YES
lead	text	YES
default_assignee	text	YES
project_type	text	YES
project_url	text	YES
jira_url	text	YES
issue_security_scheme	text	YES
notification_scheme	text	YES
permission_scheme	text	YES
category	text	YES
refreshed	timestamp with time zone	NO

Column
key

jira_remote_links

Column	Data Type	Nullable
issue	text	NO
id	bigint	NO
name	text	YES
link	text	YES
global_id	text	YES
application	text	YES
type	text	YES
url	text	YES
information	text	YES
refreshed	timestamp with time zone	NO

Column
issue
id

jira_screens

Column	Data Type	Nullable
id	bigint	NO
name	text	YES
description	text	YES
delete_enabled	boolean	YES
screen_schemes	text	YES
workflows	text	YES
refreshed	timestamp with time zone	NO

Column
id

jira_security_levels

Column	Data Type	Nullable
project	text	NO
id	bigint	NO
name	text	YES
description	text	YES
refreshed	timestamp with time zone	NO

Column
project
id

jira_statuses

Column	Data Type	Nullable
id	bigint	NO
status	text	YES
description	text	YES
category_id	bigint	YES
category_key	text	YES
category_color	text	YES
refreshed	timestamp with time zone	NO

Column
id

jira_status

Column	Data Type	Nullable
id	bigint	NO
name	text	YES
description	text	YES
category_id	bigint	YES
category_name	text	YES
category_key	text	YES
category_color	text	YES
refreshed	timestamp with time zone	NO

Column
id

jira_transitions

Column	Data Type	Nullable
issue	text	NO
id	bigint	NO
name	text	YES
description	text	YES
to_status	text	YES
to_status_id	bigint	YES
field_names	text	YES
field_ids	text	YES
required_field_names	text	YES
required_field_ids	text	YES
refreshed	timestamp with time zone	NO

Column
issue
id

jira_users

Column	Data Type	Nullable
user	text	YES
key	text	NO
name	text	YES
email	text	YES
time_zone	text	YES
avatar_url	text	YES
active	boolean	YES
groups	text	YES
last_active_in_jira	timestamp with time zone	YES
last_active_in_confluence	timestamp with time zone	YES
access_jira_core	text	YES
access_jira_software	text	YES
access_jira_service_desk	text	YES
access_jira_admin	text	YES
access_confluence	text	YES
refreshed	timestamp with time zone	NO

Column
key

jira_versions

Column	Data Type	Nullable
project	text	NO
id	bigint	NO
name	text	YES
sequence	bigint	YES
released	boolean	YES
release_date	date	YES
start_date	text	YES
description	text	YES
refreshed	timestamp with time zone	NO

Column
project
id

jira_voters

Column	Data Type	Nullable
issue	text	NO
voter	text	YES
key	text	NO
name	text	YES
avatar_url	boolean	YES
refreshed	timestamp with time zone	NO

Column
issue
key

jira_watchers

Column	Data Type	Nullable
issue	text	NO
watcher	text	YES
key	text	NO
name	text	YES
avatar_url	boolean	YES
refreshed	timestamp with time zone	NO

Column
issue
key

jira_workflow_schemes

Column	Data Type	Nullable
id	bigint	NO
name	text	YES
description	text	YES
default_workflow	text	YES
draft	boolean	YES
refreshed	timestamp with time zone	NO

Column
id

jira_workflows

Column	Data Type	Nullable
name	text	NO
description	text	YES
last_modified	text	YES
last_modifier	text	YES
step_count	bigint	YES
default	boolean	YES
refreshed	timestamp with time zone	NO

Column
name

jira_work

Column	Data Type	Nullable
issue	text	YES
id	bigint	YES
start	timestamp with time zone	YES
time_spent	text	YES
time_spent_seconds	bigint	YES
author	text	YES
update_author	text	YES
created	timestamp with time zone	YES
updated	timestamp with time zone	YES
comment	text	YES
visibility	text	YES
refreshed	timestamp with time zone	NO

Column

jira_works

Column	Data Type	Nullable
issue	text	YES
id	bigint	YES
start	timestamp with time zone	YES
time_spent	text	YES
time_spent_seconds	bigint	YES
author	text	YES
update_author	text	YES
created	timestamp with time zone	YES
updated	timestamp with time zone	YES
comment	text	YES
visibility	text	YES
refreshed	timestamp with time zone	NO

Column

servicedesk_fields

Column	Data Type	Nullable
service_desk_id	bigint	NO
project_key	text	YES
project_id	bigint	YES
type_id	bigint	YES
type_name	text	YES
field_id	text	NO
name	text	YES
required	boolean	YES
type	text	YES
item_type	text	YES
system_field	text	YES
values	text	YES
value_labels	text	YES
refreshed	timestamp with time zone	NO

Column
service_desk_id
field_id

servicedesk_projects

Column	Data Type	Nullable
id	bigint	NO
project_key	text	YES
project_id	bigint	YES
name	text	YES
description	text	YES
refreshed	timestamp with time zone	NO

Column
id

servicedesk_request_types

Column	Data Type	Nullable
service_desk_id	bigint	YES
project_key	text	YES
project_id	bigint	YES
id	bigint	NO
name	text	YES
description	text	YES
help_text	text	YES
request_type_groups	text	YES
refreshed	timestamp with time zone	NO

Column
id