O'Reilly logo

Facebook Cookbook by Jay Goldman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Page Table

Problem

What’s the schema for the page table?

Solution

The page table records information about Facebook Pages. Its fields are listed in Table 8-14. Queries to this table will only return data the current user is allowed to see (i.e., you can’t request pages that the current loggedinuser can’t see). More information about this table, including an up-to-date listing of fields, can be found at http://wiki.developers.facebook.com/index.php/Page_(FQL).

Table 8-14. page table fields

Name

Type

Index

Description

page_id

int

Page ID of this Page.

name

string

Name of this Page.

pic_small

string

 

URL of the small picture for this Page (max width of 50 px and max height of 150 px). Might be empty if this field wasn’t set by the creator.

pic_big

string

 

URL of the big picture for this Page (max width of 200 px and max height of 600 px). Might be empty if this field wasn’t set by the creator.

pic_square

string

 

URL of the square picture for this Page (max width and height of 50 px). Might be empty if this field wasn’t set by the creator.

pic

string

 

URL of the picture for this Page (max width of 100 px and max height of 300 px). Might be empty if this field wasn’t set by the creator.

pic_large

string

 

URL of the large picture for this Page (max width of 396 px and max height of 1188 px). Might be empty if this field wasn’t set by the creator.

type

string

 

Type of this Page.

website

string

 

External URL for the subject of this Page.

has_added_app

bool

 

Indicates whether this Page has your application ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required