Event Table
Problem
What’s the schema for the event
table?
Solution
The event
table holds all of
the events created in the Facebook Events application. Its fields are
listed in Table 8-5. 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_(FQL).
Table 8-5. event table fields
Name | Type | Index | Description |
---|---|---|---|
| int | • |
|
| string | Name of this event. | |
| string | Tagline of this event. | |
| int |
| |
| string | URL of the small picture for this event, which has a maximum width of 50 px and a maximum height of 150 px. Might be empty if this field wasn’t set by the creator. | |
| string | URL of the big picture for this event (max width of 200 px, max height of 600 px). Might be empty if this field wasn’t set by the creator. | |
| string | URL of the picture for this event (max width of 100 px, max height of 300 px). Might be empty if this field wasn’t set by the creator. | |
| string | Name of the host of the
event. Note that this can be set to a group when the event is
created, but this will return only a | |
| string | Description of this event. | |
| string | Type of this event. Can be any one of Party, Causes, ... |
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.