What’s the schema for the
listing table stores the
listings created in the Facebook Marketplace application. Its fields
are listed in Table 8-13. Queries to this
table will only return data the current user is allowed to see (i.e.,
you can’t request
listing that the
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/Listings_(FQL).
Table 8-13. listing table fields
Listing ID of this listing.
URL pointing to this listing on Facebook.
Title of this listing.
Description of this listing.
Price of this item as a string (rather than a float).
User ID of the user who posted this item.
The last time this item was updated in epoch seconds. For more info about epoch seconds, see Formatting Relative Time.
categories for listings are
Subcategories are the level below the category. Each category has about five subs (e.g., “For Sale” breaks down into “Books”, “Furniture”, “Tickets”, “Electronics”, “Cars”, and “Other”).
An array of the images uploaded to this listing. Users can add four images when they create the listing and can add more after it’s been created (which is a really effective user ...