# Rollbar schema ERD

Table and field reference for the Fivetran Rollbar connector.

## Table & Field Reference

### user_project

| Column | Type | Keys |
| --- | --- | --- |
| project_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| slug | Unknown |  |

### team_project

| Column | Type | Keys |
| --- | --- | --- |
| project_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |

### project_version

| Column | Type | Keys |
| --- | --- | --- |
| version | Unknown | PK |
| project_id | Unknown | PK, FK |

### project_global

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| project_id | Unknown | PK, FK |
| condition | Json |  |
| fingerprint | Unknown |  |
| title | Unknown |  |

### project_ai

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| project_id | Unknown | PK, FK |
| condition | Json |  |
| fingerprint | Unknown |  |
| title | Unknown |  |

### project_setting_data_custom

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| project_id | Unknown | PK, FK |
| value | Unknown |  |

### project

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown |  |
| auto_upgrade | Unknown |  |
| date_created | Unknown |  |
| date_modified | Unknown |  |
| encryption_at_rest_enabled | Unknown |  |
| encryption_at_rest_enabled_at | Unknown |  |
| encryption_at_rest_enabled_at_creation | Unknown |  |
| encryption_at_rest_key | Unknown |  |
| integrations_additional_prop | Json |  |
| integrations_asana_api_key_user_id | Unknown |  |
| integrations_asana_enabled | Unknown |  |
| integrations_asana_project_id | Unknown |  |
| integrations_asana_team_id | Unknown |  |
| integrations_asana_workspace_id | Unknown |  |
| integrations_azuredevops | Json |  |
| integrations_bitbucket | Json |  |
| integrations_campfire | Json |  |
| integrations_ciscospark | Json |  |
| integrations_clubhouse | Json |  |
| integrations_datadog | Json |  |
| integrations_email_enabled | Unknown |  |
| integrations_email_scrub_params | Unknown |  |
| integrations_flowdock | Json |  |
| integrations_github_default_branch | Unknown |  |
| integrations_github_project_root | Unknown |  |
| integrations_github_scm_owner_access_token_user_id | Unknown |  |
| integrations_gitlab | Json |  |
| integrations_hipchat | Json |  |
| integrations_jira_credentials_user_id | Unknown |  |
| integrations_jira_custom_fields | Json |  |
| integrations_jira_default_create_credentials | Unknown |  |
| integrations_jira_enabled | Unknown |  |
| integrations_jira_issue_active_status | Unknown |  |
| integrations_jira_issue_resolved_status | Unknown |  |
| integrations_jira_issue_type | Unknown |  |
| integrations_jira_project_key | Unknown |  |
| integrations_launchdarkly | Json |  |
| integrations_lightstep | Json |  |
| integrations_pagerduty_enabled | Unknown |  |
| integrations_pivotal | Json |  |
| integrations_slack_access_token_user_id | Unknown |  |
| integrations_slack_bot_token_team_id | Unknown |  |
| integrations_slack_channel_id | Unknown |  |
| integrations_slack_default_actions_enabled | Unknown |  |
| integrations_slack_enabled | Unknown |  |
| integrations_sprintly | Json |  |
| integrations_trello | Json |  |
| integrations_victorops | Json |  |
| integrations_webhook | Json |  |
| name | Unknown |  |
| settings_data_scm_provider | Unknown |  |
| settings_data_time_format | Unknown |  |
| settings_data_timezone | Unknown |  |
| status | Unknown |  |

### item_occurrence

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| item_id | Unknown | FK |
| project_id | Unknown | FK |
| billable | Unknown |  |
| data | Json |  |
| timestamps | Unknown |  |
| version | Unknown |  |

### environment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | FK |
| environment | Unknown |  |
| visible | Unknown |  |

### query_language_job

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| project_id | Unknown | FK |
| date_created | Unknown |  |
| date_modified | Unknown |  |
| job_hash | Unknown |  |
| query_string | Unknown |  |
| status | Unknown |  |

### team_user

| Column | Type | Keys |
| --- | --- | --- |
| team_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |

### invitation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| from_user_id | Unknown | FK |
| team_id | Unknown | FK |
| date_created | Unknown |  |
| date_redeemed | Unknown |  |
| status | Unknown |  |
| to_email | Unknown |  |

### item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| activating_occurrence_id | Unknown | FK |
| assigned_user_id | Unknown | FK |
| environment | Unknown | FK |
| first_occurrence_id | Unknown | FK |
| group_item_id | Unknown | FK |
| last_occurrence_id | Unknown | FK |
| project_id | Unknown | FK |
| public_item_id | Unknown | FK |
| resolved_in_version | Unknown | FK |
| controlling_id | Unknown |  |
| counter | Unknown |  |
| first_occurrence_timestamp | Unknown |  |
| framework | Unknown |  |
| group_status | Unknown |  |
| hash | Unknown |  |
| integrations_data | Unknown |  |
| last_activated_timestamp | Unknown |  |
| last_modified_by | Unknown |  |
| last_occurrence_timestamp | Unknown |  |
| last_resolved_timestamp | Unknown |  |
| level | Unknown |  |
| level_lock | Unknown |  |
| platform | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| title_lock | Unknown |  |
| total_occurrences | Unknown |  |
| unique_occurrences | Unknown |  |

### project_occurrence

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| item_id | Unknown | FK |
| project_id | Unknown | FK |
| billable | Unknown |  |
| data | Json |  |
| timestamps | Unknown |  |
| version | Unknown |  |

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| access_level | Unknown |  |
| name | Unknown |  |

### deploy

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| environment | Unknown | FK |
| project_id | Unknown | FK |
| user_id | Unknown | FK |
| comment | Unknown |  |
| finish_time | Unknown |  |
| revision | Unknown |  |
| start_time | Unknown |  |
| status | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| email | Unknown |  |
| username | Unknown |  |

## Relationships

- user_project(project_id) → project(id)
- user_project(user_id) → users(id)
- team_project(team_id) → team(id)
- team_project(project_id) → project(id)
- project_version(project_id) → project(id)
- project_global(project_id) → project(id)
- project_ai(project_id) → project(id)
- project_setting_data_custom(project_id) → project(id)
- item_occurrence(project_id) → project(id)
- item_occurrence(item_id) → item(id)
- environment(project_id) → project(id)
- query_language_job(project_id) → project(id)
- team_user(team_id) → team(id)
- team_user(user_id) → users(id)
- invitation(from_user_id) → users(id)
- invitation(team_id) → team(id)
- item(assigned_user_id) → users(id)
- item(public_item_id) → item(id)
- item(last_occurrence_id) → item_occurrence(id)
- item(activating_occurrence_id) → item_occurrence(id)
- item(environment) → environment(environment)
- item(project_id) → project(id)
- item(resolved_in_version) → project_version(version)
- item(group_item_id) → item(id)
- item(first_occurrence_id) → item_occurrence(id)
- project_occurrence(project_id) → project(id)
- project_occurrence(item_id) → item(id)
- team(account_id) → project(account_id)
- deploy(user_id) → users(id)
- deploy(environment) → environment(environment)
- deploy(project_id) → project(id)