Schema Object
| |
Type |
Description |
Examples |
| key |
string |
object key of the corresponding table or view |
CIGf9f |
| name |
string |
name of the object |
California Restaurants |
| fields |
array |
array of field objects |
|
| total_row_count |
integer |
the most recently cached row count |
|
| rating |
float |
table rating |
|
| created_at |
datetime |
date and time table was created |
|
| updated_at |
datetime |
date and time the schema was last changed |
|
| created_by_user_id |
integer |
|
|
| creator |
factual username |
|
|
| is_private |
boolean |
|
|
| description |
string |
|
|
| source |
string |
|
|
Example Schema Object
{
"fields":
[
{"name":"Restaurant","is_primary":true,"id":3231768,"datatype":"String"},
{"name":"Street Address","is_primary":true,"id":3231769,"datatype":"String"},
{"name":"City","is_primary":false,"id":3231771,"datatype":"String"},
{"name":"State","is_primary":false,"id":3231772,"datatype":"String"},
],
"key":"CIGf9f",
"created_at":"2009/10/11 22:47:03 +0000",
"total_row_count":53914,
"description":null,
"updated_at":"2009/10/11 22:50:09 +0000",
"name":"California Restaurants",
"source":null,
"creator":"factualstaff",
"rating":1.0,
"is_private":false,
"created_by_user_id":186
}