Facebook Cookbook - Jay Goldman [130]
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., Eastern Daylight Time is stored as −4).
religion
string
User-created string.
birthday
string
String version of the date (“September 27, 1901”).
sex
string
male, female, or empty string if unspecified.
hometown_location
array
An array containing the city, state, country, and zip code of this user’s home town.
meeting_sex
array
An array containing the genders of other users that this user is interested in meeting.
meeting_for
array
An array containing some combination of “Friendship”, “Networking”, “Dating”, or “A Relationship”.
relationship_status
string
String with one of the following values: “Single”, “In a Relationship”, “Engaged”, “Married”, “It’s Complicated”, “In an Open Relationship”, or an empty string if unspecified.
significant_other_id
int
uid (user ID) of this user’s significant other, if specified.
political
string
Users can enter anything they’d like into this field, but it also presents an autocomplete list of options based on the party names of each country.
current_location
array
An array containing the city, state, country, and zip code of the user’s current locations.
activities
string
User-created string.
interests
string
User-created string.
music
string
User-created string.
tv
string
User-created string.
movies
string
User-created string.
books
string
User-created string.
quotes
string
User-created string.
about_me
string
User-created string.
hs_info
array
An array of high school records containing the name, grad_year, and id of each high school.
education_history
array
An array of degrees that this user has earned, containing the name, year, degree, and array of concentrations for each school.
work_history
array
An array containing the company_name, position, description, start_date, end_date, and location array (city, state, country) for each position.
notes_count
int
Count of the notes that this user has posted.
wall_count
int
Count of the posts on this user’s Wall.
status
array
An array containing this user’s current message and time (epoch seconds timestamp for when the status was entered; see Formatting Relative Time for more about epoch seconds).
has_added_app
bool
Does this user have your app installed?
is_app_user
bool
Has this user logged into your app?
online_presence
string
One of active, idle, offline, or an empty string.
Note that only the fields marked as “Index” in this table can be used in an FQL query’s WHERE clause, but any of the fields can appear in the SELECT.
Discussion
If you’d rather use the API to access users, try the