Fivetran documentation

Search the docs

/

Orbit

Explore the interactive ERD

Table & Field Reference

member_activity_in_an_organization_tag

Column	Type	Keys
`tags`	String	PK
`member_activity_id`	String	PKFK

member_activity_organization_property

Column	Type	Keys
`name`	Unknown	PK
`member_activity_in_an_organization_id`	String	PKFK
`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	PKFK

member_activity_property

Column	Type	Keys
`name`	Unknown	PK
`member_activity_id`	String	PKFK
`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	PKFK

workspace_activity_property

Column	Type	Keys
`name`	Unknown	PK
`workspace_activity_id`	String	PKFK
`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	PKFK
`organization_id`	String	PKFK
`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	PKFK

member_identity

Column	Type	Keys
`identity_id`	Unknown	PKFK
`member_id`	String	PKFK

member_in_workspace_tag_list

Column	Type	Keys
`tag_list`	String	PK
`member_id`	String	PKFK

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