{
"metainfo": {},
"parameter": [
{
"name" : "table_name",
"value" : "ssurgo.mucropyld",
"description" : "Table name"
}
]
}
|
{
"metainfo": {
"status": "Finished",
"suid": "6958047c-8753-11e6-ab76-3b090d13f41e",
"cloud_node": "10.2.228.74",
"tstamp": "2016-09-30 15:18:20",
"service_url": "http://localhost:8080/csip-crms/m/dataupdate/listtables/1.0",
"request_ip": "0:0:0:0:0:0:0:1",
"csip-crms.version": "$version: abort: no repository found in '/home/robert/NetBeansProjects/csip-crms' (.hg not found)!, built at 2016-09-30 15:17 by robert$",
"csip.version": "$version: 2.1.97 30953ed8a942 2016-08-15 od, built at 2016-09-30 15:17 by robert$",
"cpu_time": 1717,
"expiration_date": "2016-09-30 15:18:51"
},
"parameter": [
{
"name": "table_name",
"value": "ssurgo.mucropyld",
"description": "Table name"
}
],
"result": [
{
"name": "table_schema",
"value": "ssurgo",
"description": "Table schema."
},
{
"name": "table_name",
"value": "mucropyld",
"description": "Table name."
},
{
"name": "column_list",
"value": [
{
"name": "column_desc",
"value": [
{
"name": "column_name",
"value": "cropname",
"description": "Column name."
},
{
"name": "column_type",
"value": "varchar",
"description": "Column type."
},
{
"name": "length",
"value": "508",
"description": "Character Length."
},
{
"name": "column_null",
"value": "YES",
"description": "Column nullable."
}
],
"description": "Column description"
},
{
"name": "column_desc",
"value": [
{
"name": "column_name",
"value": "yldunits",
"description": "Column name."
},
{
"name": "column_type",
"value": "varchar",
"description": "Column type."
},
{
"name": "length",
"value": "508",
"description": "Character Length."
},
{
"name": "column_null",
"value": "YES",
"description": "Column nullable."
}
],
"description": "Column description"
},
{
"name": "column_desc",
"value": [
{
"name": "column_name",
"value": "nonirryield_l",
"description": "Column name."
},
{
"name": "column_type",
"value": "numeric",
"description": "Column type."
},
{
"name": "precision",
"value": "18",
"description": "Numeric precision."
},
{
"name": "column_null",
"value": "YES",
"description": "Column nullable."
}
],
"description": "Column description"
},
{
"name": "column_desc",
"value": [
{
"name": "column_name",
"value": "nonirryield_r",
"description": "Column name."
},
{
"name": "column_type",
"value": "numeric",
"description": "Column type."
},
{
"name": "precision",
"value": "18",
"description": "Numeric precision."
},
{
"name": "column_null",
"value": "YES",
"description": "Column nullable."
}
],
"description": "Column description"
},
{
"name": "column_desc",
"value": [
{
"name": "column_name",
"value": "nonirryield_h",
"description": "Column name."
},
{
"name": "column_type",
"value": "numeric",
"description": "Column type."
},
{
"name": "precision",
"value": "18",
"description": "Numeric precision."
},
{
"name": "column_null",
"value": "YES",
"description": "Column nullable."
}
],
"description": "Column description"
},
{
"name": "column_desc",
"value": [
{
"name": "column_name",
"value": "irryield_l",
"description": "Column name."
},
{
"name": "column_type",
"value": "numeric",
"description": "Column type."
},
{
"name": "precision",
"value": "18",
"description": "Numeric precision."
},
{
"name": "column_null",
"value": "YES",
"description": "Column nullable."
}
],
"description": "Column description"
},
{
"name": "column_desc",
"value": [
{
"name": "column_name",
"value": "irryield_r",
"description": "Column name."
},
{
"name": "column_type",
"value": "numeric",
"description": "Column type."
},
{
"name": "precision",
"value": "18",
"description": "Numeric precision."
},
{
"name": "column_null",
"value": "YES",
"description": "Column nullable."
}
],
"description": "Column description"
},
{
"name": "column_desc",
"value": [
{
"name": "column_name",
"value": "irryield_h",
"description": "Column name."
},
{
"name": "column_type",
"value": "numeric",
"description": "Column type."
},
{
"name": "precision",
"value": "18",
"description": "Numeric precision."
},
{
"name": "column_null",
"value": "YES",
"description": "Column nullable."
}
],
"description": "Column description"
},
{
"name": "column_desc",
"value": [
{
"name": "column_name",
"value": "mukey",
"description": "Column name."
},
{
"name": "column_type",
"value": "varchar",
"description": "Column type."
},
{
"name": "length",
"value": "60",
"description": "Character Length."
},
{
"name": "primary_key",
"value": true,
"description": "Column is primary key."
},
{
"name": "column_null",
"value": "YES",
"description": "Column nullable."
}
],
"description": "Column description"
},
{
"name": "column_desc",
"value": [
{
"name": "column_name",
"value": "mucrpyldkey",
"description": "Column name."
},
{
"name": "column_type",
"value": "varchar",
"description": "Column type."
},
{
"name": "length",
"value": "60",
"description": "Character Length."
},
{
"name": "column_null",
"value": "YES",
"description": "Column nullable."
}
],
"description": "Column description"
}
],
"description": "List of columns in table."
},
{
"name": "ssurgo.mucropyld.csv",
"value": "http://localhost:8080/csip-crms/q/6958047c-8753-11e6-ab76-3b090d13f41e/ssurgo.mucropyld.csv"
}
]
}
|