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

Event Member Table

Problem

What’s the schema of the event_member table?

Solution

The event_member table records the relationships between events and users, as well as their RSVP status. Its fields are listed in Table 8-6. Queries to this table will only return data the current user is allowed to see (meaning you can’t request events for users the current user isn’t friends with). More information about this table, including an up-to-date listing of fields, can be found at http://wiki.developers.facebook.com/index.php/Event_member_(FQL).

Table 8-6. event_member table fields

Name

Type

Index

Description

eid

int

eid (Event ID) of this event.

uid

int

uid (User ID) of the Facebook user whose RSVP status is recorded in this entry.

rsvp_status

string

 

The user’s RSVP status. Can be one of attending, declined, unsure, or not_replied.

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 event_members, try the Events.get() and Events.getMembers() methods.

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