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

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

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