ERD for Facebook Pages

10 tables

Loading diagram…

post

string

page_id

string

actions

string

admin_creator_id

string

admin_creator_name

string

application_id

string

backdated_time

date

call_to_action

string

can_reply_privately

boolean

coordinates

string

created_time

date

event_id

string

expanded_height

double

expanded_width

double

feed_targeting

string

from_id

string

full_picture

string

height

double

icon

string

instagram_eligibility

string

is_eligible_for_promotion

boolean

is_expired

boolean

is_hidden

boolean

is_inline_created

boolean

is_instagram_eligible

boolean

is_popular

boolean

is_published

boolean

is_spherical

boolean

message

string

message_tags

string

multi_share_end_card

boolean

multi_share_optimized

boolean

parent_id

string

permalink_url

string

place_id

string

place_name

string

place_overall_rating

string

place_location_city

string

place_location_country

string

place_location_country_code

string

place_location_latitude

double

place_location_located_in

string

place_location_longitude

double

place_location_name

string

place_location_region

string

place_location_state

string

place_location_street

string

place_location_zip

string

privacy_allow

string

privacy_deny

string

privacy_description

string

privacy_friends

string

privacy_networks

string

privacy_value

string

promotable_id

string

properties

string

scheduled_publish_time

double

shares_count

double

status_type

string

story

string

story_tags

string

subscribed

boolean

target_id

string

targeting

string

timeline_visibility

string

updated_time

date

via_id

string

video_buying_eligibility

string

width

double

_weld_synced

date

post_comment

string

post_id

string

attachment_media_image_height

string

attachment_media_image_src

string

attachment_media_image_width

string

attachment_target_id

string

attachment_target_url

string

attachment_type

string

attachment_url

string

can_comment

boolean

can_remove

boolean

can_hide

boolean

can_like

boolean

can_reply_privately

boolean

comment_count

double

created_time

date

from_name

string

from_id

string

like_count

double

message

string

message_tags

string

object_id

string

object_created_time

date

parent_id

string

permalink_url

string

user_likes

boolean

index

double

post_reaction

string

post_id

string

name

string

type

string

index

double

post_lifetime_insights

string

post_id

string

name

string

period

string

type

string

value

double

post_daily_insights

string

post_id

string

name

string

period

string

type

string

value

double

end_time

date

video

string

page_id

string

filepath

string

slideshow_spec

string

updated_time

date

content_category

string

created_time

date

description

string

embed_html

string

embeddable

boolean

event_id

string

format

string

from_name

string

from_id

string

icon

string

is_crosspost_video

boolean

is_episode

boolean

is_instagram_eligible

boolean

length

double

permalink_url

string

picture

string

published

boolean

source

string

views

double

_weld_synced

date

video_lifetime_insights

string

video_id

string

name

string

period

string

type

string

value

double

page_lifetime_insights

string

page_id

string

name

string

period

string

type

string

value

double

_weld_synced

date

page

string

about

string

ad_campaign_id

string

affiliation

string

app_id

string

artists_we_like

string

attire

string

available_promo_offer_ids

string

awards

string

band_interests

string

band_members

string

best_page_id

string

bio

string

birthday

string

booking_agent

string

built

string

can_checkin

boolean

can_post

boolean

category

string

category_list

string

checkins

double

company_overview

string

connected_instagram_account_id

string

connected_page_backed_instagram_account_id

string

contact_address_id

string

contact_address_city

string

contact_address_country

string

contact_address_postal_code

string

contact_address_region

string

contact_address_street1

string

contact_address_street2

string

country_page_likes

double

cover_id

string

cover_offset_x

double

cover_offset_y

double

cover_source

string

culinary_team

string

current_location

string

delivery_and_pickup_option_info

string

description

string

description_html

string

differently_open_offerings

string

directed_by

string

display_subtext

string

displayed_message_response_time

string

does_viewer_have_page_permission_link_ig

boolean

emails

string

engagement_count

double

engagement_count_string

string

engagement_count_string_with_like

string

engagement_count_string_without_like

string

engagement_social_sentence

string

engagement_social_sentence_with_like

string

engagement_social_sentence_without_like

string

fan_count

double

features

string

followers_count

double

food_styles

string

founded

string

general_info

string

general_manager

string

genre

string

global_brand_page_name

string

global_brand_root_id

string

has_added_app

boolean

has_transitioned_to_new_page_experience

boolean

has_whatsapp_business_number

boolean

has_whatsapp_number

boolean

hometown

string

hours

string

impressum

string

influences

string

instagram_business_account_id

string

is_chain

boolean

is_community_page

boolean

is_eligible_for_branded_content

boolean

is_eligible_for_disable_connect_ig_btn_for_non_page_admin_am_web

boolean

is_messenger_bot_get_started_enabled

boolean

is_messenger_platform_bot

boolean

is_owned

boolean

is_permanently_closed

boolean

is_published

boolean

is_unclaimed

boolean

is_webhooks_subscribed

boolean

leadgen_tos_acceptance_time

date

leadgen_tos_accepted

boolean

link

string

location_city

string

location_city_id

double

location_country

string

location_country_code

string

location_latitude

double

location_located_in

string

location_longitude

double

location_name

string

location_region

string

location_region_id

double

location_state

string

location_street

string

location_zip

string

members

string

merchant_review_status

string

messenger_ads_default_icebreakers

string

messenger_ads_default_quick_replies

string

messenger_ads_quick_replies_type

string

mission

string

mpg

string

name

string

name_with_location_descriptor

string

network

string

new_like_count

double

offer_eligible

boolean

overall_star_rating

double

page_token

string

parent_page_id

string

parking_lot

double

parking_street

double

parking_valet

double

payment_options

string

personal_info

string

personal_interests

string

pharma_safety_info

string

phone

string

pickup_options

string

place_type

string

plot_outline

string

press_contact

string

price_range

string

privacy_info_url

string

produced_by

string

products

string

promotion_eligible

boolean

promotion_ineligible_reason

string

public_transit

string

rating_count

double

record_label

string

release_date

string

restaurant_services

string

restaurant_specialties

string

schedule

string

screenplay_by

string

season

string

single_line_address

string

starring

string

start_info_date_day

double

start_info_date_month

double

start_info_date_year

double

start_info_type

string

store_code

string

store_location_descriptor

string

store_number

double

studio

string

supports_donate_button_in_live_video

boolean

talking_about_count

double

temporary_status

string

unread_message_count

double

unread_notif_count

double

unseen_message_count

double

user_access_expire_time

date

username

string

verification_status

string

voip_info_has_mobile_app

boolean

voip_info_has_permission

boolean

voip_info_is_callable

boolean

voip_info_is_callable_webrtc

boolean

voip_info_is_pushable

boolean

voip_info_reason_code

double

voip_info_reason_description

string

website

string

were_here_count

double

whatsapp_number

string

written_by

string

_weld_synced

date

page_daily_insights

string

page_id

string

name

string

period

string

type

string

value

double

end_time

date

_weld_synced

date

Table

Sub table