Facebook Cookbook

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 ...