# Orbit schema ERD

Table and field reference for the Fivetran Orbit connector.

## Table & Field Reference

### member_activity_in_an_organization_tag

| Column | Type | Keys |
| --- | --- | --- |
| tags | String | PK |
| member_activity_id | String | PK, FK |

### member_activity_organization_property

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| member_activity_in_an_organization_id | String | PK, FK |
| value | Unknown |  |

### member_activity_in_an_organization

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| member_id | String | FK |
| organization_id | String | FK |
| workspace_activity_type_id | Unknown | FK |
| workspace_id | String | FK |
| action | String |  |
| activity_link | String |  |
| activity_type_id | String |  |
| attribute_type | Unknown |  |
| created_at | Instant |  |
| key | String |  |
| occurred_at | Instant |  |
| orbit_url | String |  |
| type | String |  |
| updated_at | Instant |  |
| weight | Unknown |  |

### member_activity_tag

| Column | Type | Keys |
| --- | --- | --- |
| tags | String | PK |
| member_activity_id | String | PK, FK |

### member_activity_property

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| member_activity_id | String | PK, FK |
| value | Unknown |  |

### member_activity

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| member_id | String | FK |
| workspace_activity_type_id | Unknown | FK |
| workspace_id | String | FK |
| action | String |  |
| activity_type_id | String |  |
| attribute_type | Unknown |  |
| created_at | Instant |  |
| key | String |  |
| occurred_at | Instant |  |
| orbit_url | String |  |
| type | String |  |
| updated_at | Instant |  |
| weight | Unknown |  |

### workspace_activity_tag

| Column | Type | Keys |
| --- | --- | --- |
| tags | String | PK |
| activity_id | String | PK, FK |

### workspace_activity_property

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| workspace_activity_id | String | PK, FK |
| value | Unknown |  |

### workspace_activity

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| member_id | String | FK |
| workspace_activity_type_id | Unknown | FK |
| workspace_id | String | FK |
| action | String |  |
| activity_link | String |  |
| activity_type_id | String |  |
| attribute_type | Unknown |  |
| created_at | Instant |  |
| g_created_at | Instant |  |
| g_html_url | String |  |
| g_merged | Boolean |  |
| g_merged_at | Instant |  |
| g_merged_by | String |  |
| g_number | Unknown |  |
| g_title | String |  |
| is_pull_request | Boolean |  |
| key | String |  |
| occurred_at | Instant |  |
| orbit_url | String |  |
| repository_id | String |  |
| repository_type | String |  |
| type | String |  |
| weight | Unknown |  |

### report

| Column | Type | Keys |
| --- | --- | --- |
| timeframe_end_date | Unknown | PK |
| timeframe_start_date | Unknown | PK |
| workspace_id | String | PK |
| id | Unknown | FK |
| activity_foo_activity_active_count | Unknown |  |
| activity_foo_activity_active_delta | Unknown |  |
| activity_foo_activity_count | Unknown |  |
| activity_foo_activity_delta | Unknown |  |
| activity_foo_activity_new_count | Unknown |  |
| activity_foo_activity_new_delta | Unknown |  |
| activity_foo_activity_returning_count | Unknown |  |
| activity_foo_activity_returning_delta | Unknown |  |
| activity_foo_activity_source | Unknown |  |
| activity_spec_activity_active_count | Unknown |  |
| activity_spec_activity_active_delta | Unknown |  |
| activity_spec_activity_count | Unknown |  |
| activity_spec_activity_delta | Unknown |  |
| activity_spec_activity_new_count | Unknown |  |
| activity_spec_activity_new_delta | Unknown |  |
| activity_spec_activity_returning_count | Unknown |  |
| activity_spec_activity_returning_delta | Unknown |  |
| activity_spec_activity_source | Unknown |  |
| activity_total_count | Unknown |  |
| activity_total_delta | Unknown |  |
| member_active_count | Unknown |  |
| member_active_delta | Unknown |  |
| member_new_count | Unknown |  |
| member_new_delta | Unknown |  |
| member_returning_count | Unknown |  |
| member_returning_delta | Unknown |  |
| overview_members_on_orbit_level_1_count | Unknown |  |
| overview_members_on_orbit_level_2_count | Unknown |  |
| overview_members_on_orbit_level_3_count | Unknown |  |
| overview_members_on_orbit_level_4_count | Unknown |  |
| overview_members_on_orbit_level_none_count | Unknown |  |
| overview_total_members_count | Unknown |  |
| timeframe_end_date_last | Unknown |  |
| timeframe_start_date_last | Unknown |  |

### member_in_an_organisation

| Column | Type | Keys |
| --- | --- | --- |
| member_id | String | PK, FK |
| organization_id | String | PK, FK |
| workspace_id | String | FK |

### member_in_workspace_identity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workspace_id | String | FK |
| email | Unknown |  |
| name | Unknown |  |
| source | Unknown |  |
| source_host | Unknown |  |
| type | Unknown |  |
| uid | Unknown |  |
| username | Unknown |  |

### organization

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| workspace_id | String | FK |
| active_since | String |  |
| created_at | Instant |  |
| crunchbase | String |  |
| email_addresses | String |  |
| employees_count | Unknown |  |
| estimated_annual_revenue | String |  |
| facebook | String |  |
| facebook_followers | Unknown |  |
| founded_in | Unknown |  |
| industry | String |  |
| last_active | String |  |
| linkedin | String |  |
| location | String |  |
| members_count | Unknown |  |
| name | String |  |
| organization_type | String |  |
| updated_at | Instant |  |
| website | String |  |

### note

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| member_id | String | FK |
| workspace_id | String | FK |
| body | String |  |
| created_at | Instant |  |
| updated_at | Instant |  |
| user_id | String |  |

### member_in_workspace_tag

| Column | Type | Keys |
| --- | --- | --- |
| tags | String | PK |
| member_id | String | PK, FK |

### member_identity

| Column | Type | Keys |
| --- | --- | --- |
| identity_id | Unknown | PK, FK |
| member_id | String | PK, FK |

### member_in_workspace_tag_list

| Column | Type | Keys |
| --- | --- | --- |
| tag_list | String | PK |
| member_id | String | PK, FK |

### member_in_workspace

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| workspace_id | String | FK |
| activities_count | Unknown |  |
| activities_score | Unknown |  |
| avatar_url | String |  |
| bio | String |  |
| birthday | String |  |
| company | String |  |
| created | Boolean |  |
| created_at | Instant |  |
| deleted_at | Instant |  |
| devto | String |  |
| discord | String |  |
| discourse | String |  |
| email | String |  |
| first_activity_occurred_at | Instant |  |
| github | String |  |
| github_followers | Unknown |  |
| languages | String |  |
| last_activity_occurred_at | Instant |  |
| linkedin | String |  |
| location | String |  |
| love | Double |  |
| merged_at | Instant |  |
| name | String |  |
| orbit_level | Unknown |  |
| orbit_url | String |  |
| pronouns | String |  |
| reach | Unknown |  |
| shipping_address | String |  |
| slug | String |  |
| source | String |  |
| teammate | Boolean |  |
| title | String |  |
| topics | String |  |
| tshirt | String |  |
| updated_at | Instant |  |
| url | String |  |

### workspace

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| member_id | String | FK |
| workspace_activity_id | String | FK |
| created_at | Instant |  |
| name | String |  |
| repository_data | Json |  |
| slug | String |  |
| updated_at | Instant |  |

### workspace_activity_type

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| workspace_id | String | FK |
| channel | String |  |
| key | String |  |
| name | String |  |
| short_name | String |  |
| source | String |  |
| weight | Unknown |  |

## Relationships

- member_activity_in_an_organization_tag(member_activity_id) → member_activity_in_an_organization(id)
- member_activity_organization_property(member_activity_in_an_organization_id) → member_activity_in_an_organization(id)
- member_activity_in_an_organization(member_id) → member_in_workspace(id)
- member_activity_in_an_organization(workspace_id) → workspace(id)
- member_activity_in_an_organization(organization_id) → organization(id)
- member_activity_in_an_organization(workspace_activity_type_id) → workspace_activity_type(id)
- member_activity_tag(member_activity_id) → member_activity(id)
- member_activity_property(member_activity_id) → member_activity(id)
- member_activity(member_id) → member_in_workspace(id)
- member_activity(workspace_id) → workspace(id)
- member_activity(workspace_activity_type_id) → workspace_activity_type(id)
- workspace_activity_tag(activity_id) → workspace_activity(id)
- workspace_activity_property(workspace_activity_id) → workspace_activity(id)
- workspace_activity(member_id) → member_in_workspace(id)
- workspace_activity(workspace_id) → workspace(id)
- workspace_activity(workspace_activity_type_id) → workspace_activity_type(id)
- report(id) → workspace(id)
- member_in_an_organisation(member_id) → member_in_workspace(id)
- member_in_an_organisation(workspace_id) → workspace(id)
- member_in_an_organisation(organization_id) → organization(id)
- member_in_workspace_identity(workspace_id) → workspace(id)
- organization(workspace_id) → workspace(id)
- note(member_id) → member_in_workspace(id)
- note(workspace_id) → workspace(id)
- member_in_workspace_tag(member_id) → member_in_workspace(id)
- member_identity(identity_id) → member_in_workspace_identity(id)
- member_identity(member_id) → member_in_workspace(id)
- member_in_workspace_tag_list(member_id) → member_in_workspace(id)
- member_in_workspace(workspace_id) → workspace(id)
- workspace(member_id) → member_in_workspace(id)
- workspace(workspace_activity_id) → workspace_activity(id)
- workspace_activity_type(workspace_id) → workspace(id)