# LinkedIn Company Pages schema ERD

Table and field reference for the Fivetran LinkedIn Company Pages connector.

## Table & Field Reference

### time_bound_follower_statistic

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| day | Instant | PK |
| follower_gains_organic_follower_gain | Int |  |
| follower_gains_paid_follower_gain | Int |  |
| organization_entity | String |  |

### comment_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| last_modified_time | Instant | PK |
| actor | String |  |
| agent | String |  |
| content | Json |  |
| created_actor | String |  |
| created_time | Instant |  |
| last_modified_actor | String |  |
| message_text | String |  |
| object | String |  |
| urn | String |  |

### post_multi_image

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| _fivetran_id | String | PK, FK |
| alt_text | String |  |
| title | String |  |

### post_distribution_target_seniorities

| Column | Type | Keys |
| --- | --- | --- |
| last_modified_time | Instant | PK, FK |
| post_id | String | PK, FK |
| seniority_id | Long | PK, FK |

### organization_localized_specialties

| Column | Type | Keys |
| --- | --- | --- |
| organization_id | Long | PK, FK |
| specialty | String |  |

### ugc_post_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| last_modified_time | Instant | PK |
| author | String |  |
| commentary | String |  |
| container_entity | String |  |
| content_call_to_action_label | String |  |
| content_landing_page | String |  |
| created_time | Instant |  |
| distribution_external_distribution_channels | Json |  |
| distribution_feed_distribution | String |  |
| first_published_at | Instant |  |
| is_reshare_disabled_by_author | Boolean |  |
| lifecycle_state | String |  |
| lifecycle_state_info_content_status | String |  |
| lifecycle_state_info_is_edited_by_author | Boolean |  |
| lifecycle_state_info_review_status | String |  |
| response_context_parent | String |  |
| response_context_root | String |  |
| visibility | String |  |
| ad_context_** |  |  |

### time_bound_video_analytics

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| day | Instant | PK |
| entity | String | FK |
| statistics_type | String |  |
| value | Long |  |

### share_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| last_modified_time | Instant | PK |
| author | String |  |
| commentary | String |  |
| container_entity | String |  |
| content_call_to_action_label | String |  |
| content_landing_page | String |  |
| created_time | Instant |  |
| distribution_external_distribution_channels | Json |  |
| distribution_feed_distribution | String |  |
| first_published_at | Instant |  |
| is_reshare_disabled_by_author | Boolean |  |
| lifecycle_state | String |  |
| lifecycle_state_info_content_status | String |  |
| lifecycle_state_info_is_edited_by_author | Boolean |  |
| lifecycle_state_info_review_status | String |  |
| response_context_parent | String |  |
| response_context_root | String |  |
| visibility | String |  |
| ad_context_** |  |  |

### followers_by_seniority

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| seniority_id | Long | FK |
| _organization_entity_urn | String |  |
| follower_counts_organic_follower_count | Int |  |
| follower_counts_paid_follower_count | Int |  |

### share_statistic

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| _organization_entity_urn | String |  |
| _share_entity_urn | String |  |
| click_count | Int |  |
| comment_count | Int |  |
| engagement | Double |  |
| impression_count | Int |  |
| like_count | Int |  |
| share_count | Int |  |

### page_statistic_by_geo_country

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| geo_id | String | FK |
| _organization_entity_urn | String |  |
| about_page_views | Int |  |
| all_desktop_page_views | Int |  |
| all_mobile_page_views | Int |  |
| all_page_views | Int |  |
| careers_page_views | Int |  |
| desktop_about_page_views | Int |  |
| desktop_careers_page_views | Int |  |
| desktop_insights_page_views | Int |  |
| desktop_jobs_page_views | Int |  |
| desktop_life_at_page_views | Int |  |
| desktop_overview_page_views | Int |  |
| desktop_people_page_views | Int |  |
| desktop_products_page_views | Int |  |
| insights_page_views | Int |  |
| jobs_page_views | Int |  |
| life_at_page_views | Int |  |
| mobile_about_page_views | Int |  |
| mobile_careers_page_views | Int |  |
| mobile_insights_page_views | Int |  |
| mobile_jobs_page_views | Int |  |
| mobile_life_at_page_views | Int |  |
| mobile_overview_page_views | Int |  |
| mobile_people_page_views | Int |  |
| mobile_products_page_views | Int |  |
| overview_page_views | Int |  |
| people_page_views | Int |  |
| products_page_views | Int |  |

### organization_groups

| Column | Type | Keys |
| --- | --- | --- |
| organization_id | Long | PK, FK |
| group_urn | String |  |

### organization_alternative_names

| Column | Type | Keys |
| --- | --- | --- |
| organization_id | Long | PK, FK |
| locale_country | String |  |
| locale_language | String |  |
| name | String |  |

### page_statistic_by_geo

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| geo_id | String | FK |
| _organization_entity_urn | String |  |
| about_page_views | Int |  |
| all_desktop_page_views | Int |  |
| all_mobile_page_views | Int |  |
| all_page_views | Int |  |
| careers_page_views | Int |  |
| desktop_about_page_views | Int |  |
| desktop_careers_page_views | Int |  |
| desktop_insights_page_views | Int |  |
| desktop_jobs_page_views | Int |  |
| desktop_life_at_page_views | Int |  |
| desktop_overview_page_views | Int |  |
| desktop_people_page_views | Int |  |
| desktop_products_page_views | Int |  |
| insights_page_views | Int |  |
| jobs_page_views | Int |  |
| life_at_page_views | Int |  |
| mobile_about_page_views | Int |  |
| mobile_careers_page_views | Int |  |
| mobile_insights_page_views | Int |  |
| mobile_jobs_page_views | Int |  |
| mobile_life_at_page_views | Int |  |
| mobile_overview_page_views | Int |  |
| mobile_people_page_views | Int |  |
| mobile_products_page_views | Int |  |
| overview_page_views | Int |  |
| people_page_views | Int |  |
| products_page_views | Int |  |

### time_bound_share_statistic

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| day | Instant | PK |
| click_count | Int |  |
| comment_count | Int |  |
| comment_mentions_count | Int |  |
| engagement | Double |  |
| impression_count | Int |  |
| like_count | Int |  |
| organization_entity | String |  |
| share_count | Int |  |
| share_mentions_count | Int |  |
| unique_impressions_count | Int |  |

### share_carousel_card

| Column | Type | Keys |
| --- | --- | --- |
| media_id | String | PK |
| _fivetran_id | String | PK, FK |
| landing_page | String |  |
| media_alt_text | String |  |
| media_title | String |  |

### share_distribution_target_locations

| Column | Type | Keys |
| --- | --- | --- |
| location | String | PK |
| last_modified_time | Instant | PK, FK |
| share_id | Long | PK, FK |

### followers_by_region

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| region_id | Long | FK |
| _organization_entity_urn | String |  |
| follower_counts_organic_follower_count | Int |  |
| follower_counts_paid_follower_count | Int |  |

### followers_by_geo_country

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| geo | String | FK |
| _organization_entity_urn | String |  |
| follower_counts_organic_follower_count | Int |  |
| follower_counts_paid_follower_count | Int |  |

### post_distribution_target_interface_locales

| Column | Type | Keys |
| --- | --- | --- |
| last_modified_time | Instant | PK, FK |
| post_id | String | PK, FK |
| country | String |  |
| language | String |  |

### post_content

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| post_id | String | PK, FK |
| carousel_id | Long |  |
| media_alt_text | String |  |
| media_id | String |  |
| media_title | String |  |
| multi_image_alt_text | String |  |
| poll_question | String |  |
| poll_settings_duration | String |  |
| poll_settings_is_voter_visible_to_author | Boolean |  |
| poll_settings_vote_selection_type | String |  |
| poll_unique_voters_count | Long |  |
| reference_id | String |  |
| type | String |  |
| article_** |  |  |

### followers_by_association_type

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| _organization_entity_urn | String |  |
| association_type | String |  |
| follower_counts_organic_follower_count | Int |  |
| follower_counts_paid_follower_count | Int |  |

### followers_by_staff_count_range

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| _organization_entity_urn | String |  |
| follower_counts_organic_follower_count | Int |  |
| follower_counts_paid_follower_count | Int |  |
| staff_count_range | String |  |

### organization_industries

| Column | Type | Keys |
| --- | --- | --- |
| industry_id | Long | PK, FK |
| organization_id | Long | PK, FK |

### function

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| name | String |  |

### share_content_poll_option

| Column | Type | Keys |
| --- | --- | --- |
| text | String | PK |
| _fivetran_id | String | PK, FK |
| is_voted_by_viewer | Boolean |  |
| vote_count | Long |  |

### followers_by_country

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| country_id | String | FK |
| _organization_entity_urn | String |  |
| follower_counts_organic_follower_count | Int |  |
| follower_counts_paid_follower_count | Int |  |

### page_statistic_by_country

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| country_id | String | FK |
| _organization_entity_urn | String |  |
| about_page_views | Int |  |
| all_desktop_page_views | Int |  |
| all_mobile_page_views | Int |  |
| all_page_views | Int |  |
| careers_page_views | Int |  |
| desktop_about_page_views | Int |  |
| desktop_careers_page_views | Int |  |
| desktop_insights_page_views | Int |  |
| desktop_jobs_page_views | Int |  |
| desktop_life_at_page_views | Int |  |
| desktop_overview_page_views | Int |  |
| desktop_people_page_views | Int |  |
| desktop_products_page_views | Int |  |
| insights_page_views | Int |  |
| jobs_page_views | Int |  |
| life_at_page_views | Int |  |
| mobile_about_page_views | Int |  |
| mobile_careers_page_views | Int |  |
| mobile_insights_page_views | Int |  |
| mobile_jobs_page_views | Int |  |
| mobile_life_at_page_views | Int |  |
| mobile_overview_page_views | Int |  |
| mobile_people_page_views | Int |  |
| mobile_products_page_views | Int |  |
| overview_page_views | Int |  |
| people_page_views | Int |  |
| products_page_views | Int |  |

### total_share_statistic

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| _organization_entity_urn | String |  |
| click_count | Int |  |
| comment_count | Int |  |
| comment_mentions_count | Int |  |
| engagement | Double |  |
| impression_count | Int |  |
| like_count | Int |  |
| share_count | Int |  |
| share_mentions_count | Int |  |
| unique_impressions_count | Int |  |

### geo

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| value | String |  |

### post_carousel_card

| Column | Type | Keys |
| --- | --- | --- |
| media_id | String | PK |
| _fivetran_id | String | PK, FK |
| landing_page | String |  |
| media_alt_text | String |  |
| media_title | String |  |

### time_bound_page_statistic

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| day | Instant | PK |
| about_page_views | Int |  |
| about_unique_page_views | Int |  |
| all_desktop_page_views | Int |  |
| all_desktop_unique_page_views | Int |  |
| all_mobile_page_views | Int |  |
| all_mobile_unique_page_views | Int |  |
| all_page_views | Int |  |
| all_unique_page_views | Int |  |
| careers_page_banner_promo_clicks | Int |  |
| careers_page_employees_clicks | Int |  |
| careers_page_jobs_clicks | Int |  |
| careers_page_promo_links_clicks | Int |  |
| careers_page_views | Int |  |
| careers_unique_page_views | Int |  |
| desktop_about_page_views | Int |  |
| desktop_about_unique_page_views | Int |  |
| desktop_careers_page_views | Int |  |
| desktop_careers_unique_page_views | Int |  |
| desktop_insights_page_views | Int |  |
| desktop_insights_unique_page_views | Int |  |
| desktop_jobs_page_views | Int |  |
| desktop_jobs_unique_page_views | Int |  |
| desktop_life_at_page_views | Int |  |
| desktop_life_at_unique_page_views | Int |  |
| desktop_overview_page_views | Int |  |
| desktop_overview_unique_page_views | Int |  |
| desktop_people_page_views | Int |  |
| desktop_people_unique_page_views | Int |  |
| desktop_products_page_views | Int |  |
| desktop_products_unique_page_views | Int |  |
| insights_page_views | Int |  |
| insights_unique_page_views | Int |  |
| jobs_page_views | Int |  |
| jobs_unique_page_views | Int |  |
| life_at_page_views | Int |  |
| life_at_unique_page_views | Int |  |
| mobile_about_page_views | Int |  |
| mobile_about_unique_page_views | Int |  |
| mobile_careers_page_employees_clicks | Int |  |
| mobile_careers_page_jobs_clicks | Int |  |
| mobile_careers_page_promo_links_clicks | Int |  |
| mobile_careers_page_views | Int |  |
| mobile_careers_unique_page_views | Int |  |
| mobile_insights_page_views | Int |  |
| mobile_insights_unique_page_views | Int |  |
| mobile_jobs_page_views | Int |  |
| mobile_jobs_unique_page_views | Int |  |
| mobile_life_at_page_views | Int |  |
| mobile_life_at_unique_page_views | Int |  |
| mobile_overview_page_views | Int |  |
| mobile_overview_unique_page_views | Int |  |
| mobile_people_page_views | Int |  |
| mobile_people_unique_page_views | Int |  |
| mobile_products_page_views | Int |  |
| mobile_products_unique_page_views | Int |  |
| organization_entity | String |  |
| overview_page_views | Int |  |
| overview_unique_page_views | Int |  |
| people_page_views | Int |  |
| people_unique_page_views | Int |  |
| products_page_views | Int |  |
| products_unique_page_views | Int |  |

### brand_localized_specialties

| Column | Type | Keys |
| --- | --- | --- |
| brand_id | Long | PK, FK |
| specialty | String |  |

### social_metadata_summary

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| comment_summary_count | Int |  |
| comment_summary_top_level_count | Int |  |
| comments_state | String |  |
| entity | String |  |
| reaction_appreciation_count | Int |  |
| reaction_appreciation_reaction_type | String |  |
| reaction_celebration_count | Int |  |
| reaction_celebration_reaction_type | String |  |
| reaction_empathy_count | Int |  |
| reaction_empathy_reaction_type | String |  |
| reaction_interest_count | Int |  |
| reaction_interest_reaction_type | String |  |
| reaction_like_count | Int |  |
| reaction_like_reaction_type | String |  |
| reaction_maybe_count | Int |  |
| reaction_maybe_reaction_type | String |  |
| reaction_praise_count | Int |  |
| reaction_praise_reaction_type | String |  |

### total_page_statistic

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| _organization_entity_urn | String |  |
| about_page_views | Int |  |
| all_desktop_page_views | Int |  |
| all_mobile_page_views | Int |  |
| all_page_views | Int |  |
| careers_page_banner_promo_clicks | Int |  |
| careers_page_employees_clicks | Int |  |
| careers_page_jobs_clicks | Int |  |
| careers_page_promo_links_clicks | Int |  |
| careers_page_views | Int |  |
| desktop_about_page_views | Int |  |
| desktop_careers_page_views | Int |  |
| desktop_insights_page_views | Int |  |
| desktop_jobs_page_views | Int |  |
| desktop_life_at_page_views | Int |  |
| desktop_overview_page_views | Int |  |
| desktop_people_page_views | Int |  |
| desktop_products_page_views | Int |  |
| insights_page_views | Int |  |
| jobs_page_views | Int |  |
| life_at_page_views | Int |  |
| mobile_about_page_views | Int |  |
| mobile_careers_page_employees_clicks | Int |  |
| mobile_careers_page_jobs_clicks | Int |  |
| mobile_careers_page_promo_links_clicks | Int |  |
| mobile_careers_page_views | Int |  |
| mobile_insights_page_views | Int |  |
| mobile_jobs_page_views | Int |  |
| mobile_life_at_page_views | Int |  |
| mobile_overview_page_views | Int |  |
| mobile_people_page_views | Int |  |
| mobile_products_page_views | Int |  |
| overview_page_views | Int |  |
| people_page_views | Int |  |
| products_page_views | Int |  |

### post_content_poll_option

| Column | Type | Keys |
| --- | --- | --- |
| text | String | PK |
| _fivetran_id | String | PK, FK |
| is_voted_by_viewer | Boolean |  |
| vote_count | Long |  |

### followers_by_industry

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| industry_id | Long | FK |
| _organization_entity_urn | String |  |
| follower_counts_organic_follower_count | Int |  |
| follower_counts_paid_follower_count | Int |  |

### post_distribution_target_job_functions

| Column | Type | Keys |
| --- | --- | --- |
| function_id | Long | PK, FK |
| last_modified_time | Instant | PK, FK |
| post_id | String | PK, FK |

### brand_industries

| Column | Type | Keys |
| --- | --- | --- |
| brand_id | Long | PK, FK |
| industry_id | Long | PK, FK |

### country

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| country_group | String |  |
| name | String |  |

### page_statistic_by_seniority

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| seniority_id | Long | FK |
| _organization_entity_urn | String |  |
| about_page_views | Int |  |
| all_desktop_page_views | Int |  |
| all_mobile_page_views | Int |  |
| all_page_views | Int |  |
| careers_page_views | Int |  |
| desktop_about_page_views | Int |  |
| desktop_careers_page_views | Int |  |
| desktop_insights_page_views | Int |  |
| desktop_jobs_page_views | Int |  |
| desktop_life_at_page_views | Int |  |
| desktop_overview_page_views | Int |  |
| desktop_people_page_views | Int |  |
| desktop_products_page_views | Int |  |
| insights_page_views | Int |  |
| jobs_page_views | Int |  |
| life_at_page_views | Int |  |
| mobile_about_page_views | Int |  |
| mobile_careers_page_views | Int |  |
| mobile_insights_page_views | Int |  |
| mobile_jobs_page_views | Int |  |
| mobile_life_at_page_views | Int |  |
| mobile_overview_page_views | Int |  |
| mobile_people_page_views | Int |  |
| mobile_products_page_views | Int |  |
| overview_page_views | Int |  |
| people_page_views | Int |  |
| products_page_views | Int |  |

### post_distribution_target_industries

| Column | Type | Keys |
| --- | --- | --- |
| industry_id | Long | PK, FK |
| last_modified_time | Instant | PK, FK |
| post_id | String | PK, FK |

### page_statistic_by_region

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| region_id | Long | FK |
| _organization_entity_urn | String |  |
| about_page_views | Int |  |
| all_desktop_page_views | Int |  |
| all_mobile_page_views | Int |  |
| all_page_views | Int |  |
| careers_page_views | Int |  |
| desktop_about_page_views | Int |  |
| desktop_careers_page_views | Int |  |
| desktop_insights_page_views | Int |  |
| desktop_jobs_page_views | Int |  |
| desktop_life_at_page_views | Int |  |
| desktop_overview_page_views | Int |  |
| desktop_people_page_views | Int |  |
| desktop_products_page_views | Int |  |
| insights_page_views | Int |  |
| jobs_page_views | Int |  |
| life_at_page_views | Int |  |
| mobile_about_page_views | Int |  |
| mobile_careers_page_views | Int |  |
| mobile_insights_page_views | Int |  |
| mobile_jobs_page_views | Int |  |
| mobile_life_at_page_views | Int |  |
| mobile_overview_page_views | Int |  |
| mobile_people_page_views | Int |  |
| mobile_products_page_views | Int |  |
| overview_page_views | Int |  |
| people_page_views | Int |  |
| products_page_views | Int |  |

### page_statistic_by_industry

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| industry_id | Long | FK |
| _organization_entity_urn | String |  |
| about_page_views | Int |  |
| all_desktop_page_views | Int |  |
| all_mobile_page_views | Int |  |
| all_page_views | Int |  |
| careers_page_views | Int |  |
| desktop_about_page_views | Int |  |
| desktop_careers_page_views | Int |  |
| desktop_insights_page_views | Int |  |
| desktop_jobs_page_views | Int |  |
| desktop_life_at_page_views | Int |  |
| desktop_overview_page_views | Int |  |
| desktop_people_page_views | Int |  |
| desktop_products_page_views | Int |  |
| insights_page_views | Int |  |
| jobs_page_views | Int |  |
| life_at_page_views | Int |  |
| mobile_about_page_views | Int |  |
| mobile_careers_page_views | Int |  |
| mobile_insights_page_views | Int |  |
| mobile_jobs_page_views | Int |  |
| mobile_life_at_page_views | Int |  |
| mobile_overview_page_views | Int |  |
| mobile_people_page_views | Int |  |
| mobile_products_page_views | Int |  |
| overview_page_views | Int |  |
| people_page_views | Int |  |
| products_page_views | Int |  |

### share_distribution_target_interface_locales

| Column | Type | Keys |
| --- | --- | --- |
| last_modified_time | Instant | PK, FK |
| share_id | Long | PK, FK |
| country | String |  |
| language | String |  |

### page_statistic_by_staff_count_range

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| _organization_entity_urn | String |  |
| about_page_views | Int |  |
| all_desktop_page_views | Int |  |
| all_mobile_page_views | Int |  |
| all_page_views | Int |  |
| careers_page_views | Int |  |
| desktop_about_page_views | Int |  |
| desktop_careers_page_views | Int |  |
| desktop_insights_page_views | Int |  |
| desktop_jobs_page_views | Int |  |
| desktop_life_at_page_views | Int |  |
| desktop_overview_page_views | Int |  |
| desktop_people_page_views | Int |  |
| desktop_products_page_views | Int |  |
| insights_page_views | Int |  |
| jobs_page_views | Int |  |
| life_at_page_views | Int |  |
| mobile_about_page_views | Int |  |
| mobile_careers_page_views | Int |  |
| mobile_insights_page_views | Int |  |
| mobile_jobs_page_views | Int |  |
| mobile_life_at_page_views | Int |  |
| mobile_overview_page_views | Int |  |
| mobile_people_page_views | Int |  |
| mobile_products_page_views | Int |  |
| overview_page_views | Int |  |
| people_page_views | Int |  |
| products_page_views | Int |  |
| staff_count_range | String |  |

### share_content

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| share_id | Long | PK, FK |
| carousel_id | Long |  |
| media_alt_text | String |  |
| media_id | String |  |
| media_title | String |  |
| multi_image_alt_text | String |  |
| poll_question | String |  |
| poll_settings_duration | String |  |
| poll_settings_is_voter_visible_to_author | Boolean |  |
| poll_settings_vote_selection_type | String |  |
| poll_unique_voters_count | Long |  |
| reference_id | String |  |
| type | String |  |
| article_** |  |  |

### organization_locations

| Column | Type | Keys |
| --- | --- | --- |
| organization_id | Long | PK, FK |
| description_localized | Json |  |
| description_preferred_locale_country | String |  |
| description_preferred_locale_language | String |  |
| geo_location | Long |  |
| localized_description | String |  |
| location_type | String |  |
| street_address_field_state | String |  |
| address_** |  |  |

### brand_alternative_names

| Column | Type | Keys |
| --- | --- | --- |
| brand_id | Long | PK, FK |
| locale_country | String |  |
| locale_language | String |  |
| name | String |  |

### share_multi_image

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| _fivetran_id | String | PK, FK |
| alt_text | String |  |
| title | String |  |

### followers_by_geo

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| geo | String | FK |
| _organization_entity_urn | String |  |
| follower_counts_organic_follower_count | Int |  |
| follower_counts_paid_follower_count | Int |  |

### page_statistic_by_function

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| function_id | Long | FK |
| _organization_entity_urn | String |  |
| about_page_views | Int |  |
| all_desktop_page_views | Int |  |
| all_mobile_page_views | Int |  |
| all_page_views | Int |  |
| careers_page_views | Int |  |
| desktop_about_page_views | Int |  |
| desktop_careers_page_views | Int |  |
| desktop_insights_page_views | Int |  |
| desktop_jobs_page_views | Int |  |
| desktop_life_at_page_views | Int |  |
| desktop_overview_page_views | Int |  |
| desktop_people_page_views | Int |  |
| desktop_products_page_views | Int |  |
| insights_page_views | Int |  |
| jobs_page_views | Int |  |
| life_at_page_views | Int |  |
| mobile_about_page_views | Int |  |
| mobile_careers_page_views | Int |  |
| mobile_insights_page_views | Int |  |
| mobile_jobs_page_views | Int |  |
| mobile_life_at_page_views | Int |  |
| mobile_overview_page_views | Int |  |
| mobile_people_page_views | Int |  |
| mobile_products_page_views | Int |  |
| overview_page_views | Int |  |
| people_page_views | Int |  |
| products_page_views | Int |  |

### share_distribution_target_industries

| Column | Type | Keys |
| --- | --- | --- |
| industry_id | Long | PK, FK |
| last_modified_time | Instant | PK, FK |
| share_id | Long | PK, FK |

### region

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| country | String |  |
| name | String |  |

### brand

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| organization_id | Long | PK, FK |
| parent_relationship_parent_id | Long | FK |
| auto_created | Boolean |  |
| cover_photo_v_2_crop_info_height | Int |  |
| cover_photo_v_2_crop_info_width | Int |  |
| cover_photo_v_2_crop_info_x | Int |  |
| cover_photo_v_2_crop_info_y | Int |  |
| cover_photo_v_2_cropped | String |  |
| cover_photo_v_2_original | String |  |
| default_locale_country | String |  |
| default_locale_language | String |  |
| description_localized | Json |  |
| description_preferred_locale_country | String |  |
| description_preferred_locale_language | String |  |
| founded_on_day | Int |  |
| founded_on_month | Int |  |
| founded_on_year | Int |  |
| localized_description | String |  |
| localized_name | String |  |
| localized_website | String |  |
| logo_v_2_crop_info_height | Int |  |
| logo_v_2_crop_info_width | Int |  |
| logo_v_2_crop_info_x | Int |  |
| logo_v_2_crop_info_y | Int |  |
| logo_v_2_cropped | String |  |
| logo_v_2_original | String |  |
| name_localized | Json |  |
| name_preferred_locale_country | String |  |
| name_preferred_locale_language | String |  |
| parent_relationship_status | String |  |
| parent_relationship_type | String |  |
| pinned_post | String |  |
| vanity_name | String |  |
| version_tag | String |  |
| website_localized | Json |  |
| website_preferred_locale_country | String |  |
| website_preferred_locale_language | String |  |

### organization

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| parent_relationship_parent_id | Long | FK |
| cover_photo_v_2_crop_info_height | Int |  |
| cover_photo_v_2_crop_info_width | Int |  |
| cover_photo_v_2_crop_info_x | Int |  |
| cover_photo_v_2_crop_info_y | Int |  |
| cover_photo_v_2_cropped | String |  |
| cover_photo_v_2_original | String |  |
| default_locale_country | String |  |
| default_locale_language | String |  |
| description_localized | Json |  |
| description_preferred_locale_country | String |  |
| description_preferred_locale_language | String |  |
| founded_on_day | Int |  |
| founded_on_month | Int |  |
| founded_on_year | Int |  |
| localized_description | String |  |
| localized_name | String |  |
| localized_website | String |  |
| logo_v_2_crop_info_height | Int |  |
| logo_v_2_crop_info_width | Int |  |
| logo_v_2_crop_info_x | Int |  |
| logo_v_2_crop_info_y | Int |  |
| logo_v_2_cropped | String |  |
| logo_v_2_original | String |  |
| name_localized | Json |  |
| name_preferred_locale_country | String |  |
| name_preferred_locale_language | String |  |
| organization_status | String |  |
| organization_type | String |  |
| overview_photo_v_2_crop_info_height | Int |  |
| overview_photo_v_2_crop_info_width | Int |  |
| overview_photo_v_2_crop_info_x | Int |  |
| overview_photo_v_2_crop_info_y | Int |  |
| overview_photo_v_2_cropped | String |  |
| overview_photo_v_2_original | String |  |
| parent_relationship_status | String |  |
| parent_relationship_type | String |  |
| primary_organization_type | String |  |
| staff_count_range | String |  |
| vanity_name | String |  |
| version_tag | String |  |
| website_localized | Json |  |
| website_preferred_locale_country | String |  |
| website_preferred_locale_language | String |  |
| school_attributes_** |  |  |

### seniority

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| name | String |  |

### share_distribution_target_seniorities

| Column | Type | Keys |
| --- | --- | --- |
| last_modified_time | Instant | PK, FK |
| seniority_id | Long | PK, FK |
| share_id | Long | PK, FK |

### post_distribution_target_staff_count_ranges

| Column | Type | Keys |
| --- | --- | --- |
| staff_count_range | String | PK |
| last_modified_time | Instant | PK, FK |
| post_id | String | PK, FK |

### share_distribution_target_job_functions

| Column | Type | Keys |
| --- | --- | --- |
| function_id | Long | PK, FK |
| last_modified_time | Instant | PK, FK |
| share_id | Long | PK, FK |

### industry

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| name | String |  |

### post_distribution_target_locations

| Column | Type | Keys |
| --- | --- | --- |
| location | String | PK |
| last_modified_time | Instant | PK, FK |
| post_id | String | PK, FK |

### followers_by_function

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| function_id | Long | FK |
| _organization_entity_urn | String |  |
| follower_counts_organic_follower_count | Int |  |
| follower_counts_paid_follower_count | Int |  |

### share_distribution_target_staff_count_ranges

| Column | Type | Keys |
| --- | --- | --- |
| staff_count_range | String | PK |
| last_modified_time | Instant | PK, FK |
| share_id | Long | PK, FK |

### total_follower_statistic

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| _organization_entity_urn | String |  |
| day | Instant |  |
| first_degree_size | Int |  |

## Relationships

- post_multi_image(_fivetran_id) → post_content(post_id)
- post_distribution_target_seniorities(post_id) → ugc_post_history(id)
- post_distribution_target_seniorities(last_modified_time) → ugc_post_history(id)
- post_distribution_target_seniorities(seniority_id) → seniority(id)
- organization_localized_specialties(organization_id) → organization(id)
- time_bound_video_analytics(entity) → ugc_post_history(id)
- followers_by_seniority(seniority_id) → seniority(id)
- page_statistic_by_geo_country(geo_id) → geo(id)
- organization_groups(organization_id) → organization(id)
- organization_alternative_names(organization_id) → organization(id)
- page_statistic_by_geo(geo_id) → geo(id)
- share_carousel_card(_fivetran_id) → post_content(post_id)
- share_distribution_target_locations(share_id) → share_history(id)
- share_distribution_target_locations(last_modified_time) → share_history(id)
- followers_by_region(region_id) → region(id)
- followers_by_geo_country(geo) → geo(id)
- post_distribution_target_interface_locales(post_id) → ugc_post_history(id)
- post_distribution_target_interface_locales(last_modified_time) → ugc_post_history(id)
- post_content(post_id) → ugc_post_history(id)
- organization_industries(industry_id) → industry(id)
- organization_industries(organization_id) → organization(id)
- share_content_poll_option(_fivetran_id) → share_content(share_id)
- followers_by_country(country_id) → country(id)
- page_statistic_by_country(country_id) → country(id)
- post_carousel_card(_fivetran_id) → post_content(post_id)
- brand_localized_specialties(brand_id) → brand(id)
- post_content_poll_option(_fivetran_id) → post_content(post_id)
- followers_by_industry(industry_id) → industry(id)
- post_distribution_target_job_functions(post_id) → ugc_post_history(id)
- post_distribution_target_job_functions(last_modified_time) → ugc_post_history(id)
- post_distribution_target_job_functions(function_id) → function(id)
- brand_industries(industry_id) → industry(id)
- brand_industries(brand_id) → brand(id)
- page_statistic_by_seniority(seniority_id) → seniority(id)
- post_distribution_target_industries(post_id) → ugc_post_history(id)
- post_distribution_target_industries(last_modified_time) → ugc_post_history(id)
- post_distribution_target_industries(industry_id) → industry(id)
- page_statistic_by_region(region_id) → region(id)
- page_statistic_by_industry(industry_id) → industry(id)
- share_distribution_target_interface_locales(share_id) → share_history(id)
- share_distribution_target_interface_locales(last_modified_time) → share_history(id)
- share_content(share_id) → share_history(id)
- organization_locations(organization_id) → organization(id)
- brand_alternative_names(brand_id) → brand(id)
- share_multi_image(_fivetran_id) → post_content(post_id)
- followers_by_geo(geo) → geo(id)
- page_statistic_by_function(function_id) → function(id)
- share_distribution_target_industries(share_id) → share_history(id)
- share_distribution_target_industries(last_modified_time) → share_history(id)
- share_distribution_target_industries(industry_id) → industry(id)
- brand(parent_relationship_parent_id) → organization(id)
- brand(organization_id) → organization(id)
- organization(parent_relationship_parent_id) → organization(id)
- share_distribution_target_seniorities(share_id) → share_history(id)
- share_distribution_target_seniorities(last_modified_time) → share_history(id)
- share_distribution_target_seniorities(seniority_id) → seniority(id)
- post_distribution_target_staff_count_ranges(post_id) → ugc_post_history(id)
- post_distribution_target_staff_count_ranges(last_modified_time) → ugc_post_history(id)
- share_distribution_target_job_functions(share_id) → share_history(id)
- share_distribution_target_job_functions(last_modified_time) → share_history(id)
- share_distribution_target_job_functions(function_id) → function(id)
- post_distribution_target_locations(post_id) → ugc_post_history(id)
- post_distribution_target_locations(last_modified_time) → ugc_post_history(id)
- followers_by_function(function_id) → function(id)
- share_distribution_target_staff_count_ranges(share_id) → share_history(id)
- share_distribution_target_staff_count_ranges(last_modified_time) → share_history(id)