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 |
---|---|---|---|
| int | • | User ID of this user. |
| string | First name of this user. | |
| string | Last name of this user. | |
| string | • | Full name of this user, including any initials. |
| string | URL of the small picture for this user (max width of 50 px and max height of 150 px). Might be empty. | |
| string | URL of the big picture for this user (max width of 200 px and max height of 600 px). Might be empty. | |
| string | URL of the square picture for this user (max width and height of 50 px). Might be empty. | |
| string | URL of the picture for this group (max width of 100 px and max height of 300 px). Might be empty. | |
| array | Array of networks that
this user is a member of. Includes the | |
| string | Timestamp of the last update to this Profile, in epoch seconds. See Formatting Relative Time for more about epoch seconds. | |
| string | Time zone the user is in, measured in offset from GMT (e.g., ... |
Get Facebook Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.