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 |
