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

Groups Table

Problem

What’s the schema for the group table?

Solution

The group table stores the groups that have been created in the Facebook Groups app. Its fields are listed in Table 8-11. Queries to this table will only return data the current user is allowed to see (meaning you can’t request groups 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/Group_(FQL).

Table 8-11. group table fields

Name

Type

Index

Description

gid

int

Group ID of this group.

name

string

 

Name of this group.

nid

int

 

Network ID that this group belongs to, if any.

pic_small

string

 

URL of the small picture for this group (max width of 50 px and max 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 group (max width of 200 px and 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 group (max width of 100 px and max height of 300 px). Might be empty if this field wasn’t set by the creator.

description

string

 

Description of this group.

group_type

string

 

Type of group. Can be any one of Business, Common Interest, Entertainment & Arts, Geography, Internet & Technology, Just for Fun, Music, Organizations, Sports & Recreation, or Student Groups.

group_subtype

string

 

Subtype of this group. Subtypes are tied to the type, and each has between 3 and 20 options. ...

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