table_name
column_name
data_type
comments
id
uuid
comments
pull_request_review_id
uuid
comments
organization_id
uuid
comments
contributor_id
uuid
comments
pull_request_id
uuid
comments
body
text
comments
external_id
text
comments
external_created_at
timestamp without time zone
comments
created_at
timestamp without time zone
comments
updated_at
timestamp without time zone
comments
did_lead_to_pr_iteration
boolean
commits
id
uuid
commits
repository_id
uuid
commits
contributor_id
uuid
commits
sha
text
commits
message
text
commits
authored_at
timestamp without time zone
commits
file_changes
jsonb
commits
created_at
timestamp without time zone
commits
updated_at
timestamp without time zone
commits
soft_deleted_at
timestamp without time zone
commits
from_api_only
boolean
commits
impact
double precision
commits
help_others
integer
commits
churn
integer
commits
new_work
integer
commits
legacy_refactor
integer
commits
lines_changed_finished_ingested_at
timestamp without time zone
commits
lines_changed_metrics_computed_at
timestamp without time zone
commits
ignored_files_for_calculation
jsonb
commits
ignored_lines
integer
commits
isolated_removals
integer
commits
is_impact_outlier
boolean
commits
original_authored_at
timestamp without time zone
commits
organization_id
uuid
commits
is_merged
boolean
commits
number_of_added_lines_total
integer
commits
number_of_added_lines_not_filtered_out
integer
commits
number_of_added_test_lines_total
integer
commits
number_of_added_test_lines_not_filtered_out
integer
commits
number_of_removed_lines_total
integer
commits
number_of_removed_lines_not_filtered_out
integer
commits
number_of_removed_test_lines_total
integer
commits
number_of_removed_test_lines_not_filtered_out
integer
commits
simple_work
integer
contributor_parent_teams
id
uuid
contributor_parent_teams
team_id
uuid
contributor_parent_teams
contributor_parent_id
uuid
contributor_parent_teams
created_at
timestamp without time zone
contributor_parent_teams
updated_at
timestamp without time zone
contributor_parent_teams
organization_id
uuid
contributor_parents
id
uuid
contributor_parents
organization_id
uuid
contributor_parents
created_at
timestamp without time zone
contributor_parents
updated_at
timestamp without time zone
contributor_parents
name
text
contributor_parents
aasm_state
character varying
contributors
id
uuid
contributors
name
text
contributors
username
character varying
contributors
avatar_url
text
contributors
created_at
timestamp without time zone
contributors
updated_at
timestamp without time zone
contributors
contributor_parent_id
uuid
contributors
organization_id
uuid
contributors
email
character varying
custom_data_points
id
uuid
custom_data_points
tag
text
custom_data_points
datetime
timestamp without time zone
custom_data_points
decimal
numeric
custom_data_points
boolean
boolean
custom_data_points
metadata
text
custom_data_points
organization_id
uuid
custom_data_points
created_at
timestamp without time zone
custom_data_points
updated_at
timestamp without time zone
issue_assignees
id
uuid
issue_assignees
organization_id
uuid
issue_assignees
repository_id
uuid
issue_assignees
issue_id
uuid
issue_assignees
contributor_id
uuid
issue_assignees
created_at
timestamp without time zone
issue_assignees
updated_at
timestamp without time zone
issue_labels
id
uuid
issue_labels
organization_id
uuid
issue_labels
repository_id
uuid
issue_labels
issue_id
uuid
issue_labels
label_id
uuid
issue_labels
created_at
timestamp without time zone
issue_labels
updated_at
timestamp without time zone
issues
id
uuid
issues
organization_id
uuid
issues
repository_id
uuid
issues
contributor_id
uuid
issues
title
text
issues
body
text
issues
state
text
issues
external_id
text
issues
external_number
text
issues
external_created_at
timestamp without time zone
issues
external_updated_at
timestamp without time zone
issues
external_closed_at
timestamp without time zone
issues
created_at
timestamp without time zone
issues
updated_at
timestamp without time zone
labels
id
uuid
labels
organization_id
uuid
labels
repository_id
uuid
labels
external_id
text
labels
name
text
labels
created_at
timestamp without time zone
labels
updated_at
timestamp without time zone
pull_request_commits
id
uuid
pull_request_commits
pull_request_id
uuid
pull_request_commits
commit_id
uuid
pull_request_commits
created_at
timestamp without time zone
pull_request_commits
updated_at
timestamp without time zone
pull_request_commits
organization_id
uuid
pull_request_commits
is_pr_iteration
boolean
pull_request_reviews
id
uuid
pull_request_reviews
contributor_id
uuid
pull_request_reviews
pull_request_id
uuid
pull_request_reviews
external_id
text
pull_request_reviews
submitted_at
timestamp without time zone
pull_request_reviews
created_at
timestamp without time zone
pull_request_reviews
updated_at
timestamp without time zone
pull_request_reviews
state
text
pull_request_reviews
organization_id
uuid
pull_requests
id
uuid
pull_requests
repository_id
uuid
pull_requests
contributor_id
uuid
pull_requests
external_id
text
pull_requests
external_number
text
pull_requests
external_created_at
timestamp without time zone
pull_requests
external_updated_at
timestamp without time zone
pull_requests
created_at
timestamp without time zone
pull_requests
updated_at
timestamp without time zone
pull_requests
title
text
pull_requests
external_merged_at
timestamp without time zone
pull_requests
base_branch_name
text
pull_requests
head_branch_name
text
pull_requests
time_to_first_review
integer
pull_requests
time_to_approval
integer
pull_requests
time_to_merge
integer
pull_requests
time_to_open
integer
pull_requests
time_to_open_including_squashed_commits
integer
pull_requests
cycle_time
integer
pull_requests
cycle_time_including_squashed_commits
integer
pull_requests
approval_to_merge_time
integer
pull_requests
state
text
pull_requests
external_closed_at
timestamp without time zone
pull_requests
working_hours_cycle_time
integer
pull_requests
working_hours_time_to_open
integer
pull_requests
working_hours_time_to_first_review
integer
pull_requests
working_hours_time_to_approval
integer
pull_requests
working_hours_time_to_merge
integer
pull_requests
working_hours_approval_to_merge_time
integer
pull_requests
body
text
pull_requests
head_sha
text
pull_requests
base_sha
text
pull_requests
ignore_for_workflow
boolean
pull_requests
organization_id
uuid
repositories
id
uuid
repositories
organization_id
uuid
repositories
full_name
text
repositories
external_id
text
repositories
created_at
timestamp without time zone
repositories
updated_at
timestamp without time zone
repositories
aasm_state
character varying
repositories
provider
text
repositories
full_ingest_batch_id
text
repositories
historical_ingestion_started_at
timestamp without time zone
repositories
historical_ingestion_finished_at
timestamp without time zone
repositories
historical_ingest_workflow_id
uuid
repositories
ignored_filename_regex
text
repositories
merged_branch_regex
text
repositories
test_filename_regex
text
repositories
line_filter_regex
text
repositories
issues_enabled
boolean
repositories
latest_ingest_workflow_id
uuid
repositories
last_ingestion_was_automatic
boolean
teams
id
uuid
teams
name
text
teams
organization_id
uuid
teams
created_at
timestamp without time zone
teams
updated_at
timestamp without time zone
Share