Connection (FQL)
From Facebook Developer Wiki
Description
The FQL connection table. Query this table to return a user's friends and the Facebook Pages to which the user is connected. These are all the entities whose streams the specified user can consume.
To structure your query, use the table name (connection in this case) in the FROM clause. The items in the Name column correspond to columns in the table that can be referenced in the SELECT and WHERE clauses.
In order to make your query indexable, the WHERE in your query should contain an = or IN clause for one of the columns marked with a * in the Indexable column of the table.
Columns
| Indexable | Name | Type | Description | |
| * | source_id | int | The ID of the user, the source of the connection. | |
|---|---|---|---|---|
| target_id | int | The target(s) of the connection. The ID of the friend or Facebook Page with whom the specified user is either a friend or fan/supporter. | ||
| target_type | string | Indicates whether the target is a user or a Page. | ||
| is_following | bool | Indicates whether the source is connected to the target Page (for example, if the source is a supporter or fan). | ||
| updated_time | time | The most recent time the connection was updated. | ||
| is_deleted | bool | Indicates whether the source severed the connection. |
