Scribd
Upload
464 views1 page

Facebook Schema

Uploaded by

Siddhartha Ghosh

The document describes Facebook Query Language (FQL) table schemas, including tables for statuses, links, connections, streams, users, pages, posts, comments, friends, events, photos, and metrics. It lists the primary keys and fields for each table.

Copyright:

Attribution Non-Commercial (BY-NC)
Download as PDF, TXT or read online from Scribd
Download as pdf or txt

Facebook Schema

Uploaded by

Siddhartha Ghosh
464 views1 page
The document describes Facebook Query Language (FQL) table schemas, including tables for statuses, links, connections, streams, users, pages, posts, comments, friends, events, photos, and metrics. It lists the primary keys and fields for each table.

Copyright

© Attribution Non-Commercial (BY-NC)

Available Formats

PDF, TXT or read online from Scribd

Did you find this document useful?

Is this content inappropriate?

The document describes Facebook Query Language (FQL) table schemas, including tables for statuses, links, connections, streams, users, pages, posts, comments, friends, events, photos, and metrics. It lists the primary keys and fields for each table.

Copyright:

Attribution Non-Commercial (BY-NC)
Download as PDF, TXT or read online from Scribd
Download as pdf or txt
464 views1 page

Facebook Schema

Uploaded by

Siddhartha Ghosh
The document describes Facebook Query Language (FQL) table schemas, including tables for statuses, links, connections, streams, users, pages, posts, comments, friends, events, photos, and metrics. It lists the primary keys and fields for each table.

Copyright:

Attribution Non-Commercial (BY-NC)
Download as PDF, TXT or read online from Scribd
Download as pdf or txt
You are on page 1/ 1

FQL Table Schema

status

link
PK link_id owner created_time title summary url image_urls

connection

stream_filter

stream

uid status_id time source message

source_id target_id target_type is_following updated_time is_deleted

uid filter_key name rank icon_url is_visible type value

group
PK gid name nid pic_small pic_big pic description group_type group_subtype recent_news creator update_time office website venue privacy

cookies

user
PK uid first_name last_name name pic_small pic_big pic_square pic affiliations profile_update_time timezone religion birthday birthday_date sex hometown_location meeting_sex meeting_for relationship_status significant_other_id political current_location activities interests is_app_user music tv movies books quotes about_me hs_info education_history work_history notes_count wall_count status has_added_app online_presence locale proxied_email profile_url email_hashes pic_small_with_logo pic_bit_with_logo pic_square_with_logo pic_with_logo allowed_restrictions verified profile_blurb family

page
PK page_id name pic_small pic_big pic_square pic pic_large page_url type website has_added_app founded company_overview mission products location parking public_transit hours attire payment_options culinary_team general_manager price_range restaurant_services restaurant_specialties release_date genre starring screenplay_by directed_by produced_by studio awards plot_outline network season schedule written_by band_members hometown current_location record_label booking_agent press_contact artists_we_like influences brand_interests bio affiliation birthday personal_info personal_interests members built features mpg general_info fan_count

post_id viewer_id app_id source_id updated_time created_time filter_key attribution actor_id target_id message app_data action_links attachment comments likes privacy

uid name value expires path

standard_user_info

note
PK note_id uid created_time updated_time content title

uid first_name last_name name locale affiliations profile_url timezone birthday sex proxied_email

comment

profile

xid post_id fromid time text id username reply_xid

id name url pic pic_square pic_small pic_big type

event

friend_request

page_admin

uid_from uid_to

uid page_id type

friend
group_member

page_fan

uid1 uid2
uid gid positions

uid page_id type

eid name tagline nid pic_small pic_big pic host description event_type event_subtype start_time end_time creator update_time location venue privacy hide_guest_list

event_member

album

photo

aid owner cover_pid name created modified description location size link visible modified_major

pid aid owner src_small src_big src link caption created modified
photo_tag

uid eid rsvp_status

metrics

friendlist_member

permissions

flid uid

pid subject text xcoord ycoord created

friendlist

flid name owner

uid status_update photo_upload sms create_listing offline_access email create_event rsvp_event publish_stream read_stream share_item create_note

end_time period active_users api_calls unique_api_calls canvas_page_views unique_canvas_page_views canvas_http_request_time_avg canvas_fbml_render_time_avg unique_adds unique_removes unique_blocks unique_unblocks canvas_page_views_http_code_0 canvas_page_views_http_code_200 canvas_page_views_http_code_200ND canvas_page_views-http_code_404

You might also like