View
 

Common Objects::Schema

 

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
}