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

eid

int

eid (event ID) of this event.

name

string

 

Name of this event.

tagline

string

 

Tagline of this event.

nid

int

 

nid (network ID) of the network, as set by the creator when the event was created.

pic_small

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.

pic_big

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.

pic

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.

host

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, not a gid.

description

string

 

Description of this event.

event_type

string

 

Type of this event. Can be any one of Party, Causes, ...

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