Facebook Cookbook

User Table

Problem

What’s the schema for the user table?

Solution

The user table stores all the Facebook users. Its fields are listed in Table 8-18. Queries to this table will only return data the current user is allowed to see (meaning you can’t request users 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/User_(FQL).

Table 8-18. user table fields

Name	Type	Index	Description
uid	int	•	User ID of this user.
first_name	string		First name of this user.
last_name	string		Last name of this user.
name	string	•	Full name of this user, including any initials.
pic_small	string		URL of the small picture for this user (max width of 50 px and max height of 150 px). Might be empty.
pic_big	string		URL of the big picture for this user (max width of 200 px and max height of 600 px). Might be empty.
pic_square	string		URL of the square picture for this user (max width and height of 50 px). Might be empty.
pic	string		URL of the picture for this group (max width of 100 px and max height of 300 px). Might be empty.
affiliations	array		Array of networks that this user is a member of. Includes the nid (network ID), name, type (work, region, etc.), status, and year.
profile_update_time	string		Timestamp of the last update to this Profile, in epoch seconds. See Formatting Relative Time for more about epoch seconds.
timezone	string		Time zone the user is in, measured in offset from GMT (e.g., ...