目录搜索

暂无相关搜索结果！

本文档使用 MinDoc 发布

数据资产管理

原型预览
接口功能(APIJSON集成)
新增数据接口
修改数据接口
删除数据接口
查询数据接口
图表类型列表
资产列表
资产详情列表
图表1：访问数
查询接口地址：
新增接口地址：
修改接口地址：
删除接口地址：
图表2：分时走势图
查询接口地址：
新增接口地址：
修改接口地址：
删除接口地址：
图表3：7日留存分析
查询接口地址：
新增接口地址：
修改接口地址：
删除接口地址：
图表4：词云
查询接口地址：
新增接口地址：
修改接口地址：
删除接口地址：
图表5：页面访问排行
查询接口地址：
新增接口地址：
修改接口地址：
删除接口地址：
图表6：用户访问数排行
查询接口地址：
新增接口地址：
修改接口地址：
删除接口地址：
图表7：漏斗分析
查询接口地址：
新增接口地址：
修改接口地址：
删除接口地址：
图表8：雷达图分析
查询接口地址：
新增接口地址：
修改接口地址：
删除接口地址：
图表9：饼图分析
查询接口地址：
新增接口地址：
修改接口地址：
删除接口地址：
图表10：仪表指数
查询接口地址：
新增接口地址：
修改接口地址：
删除接口地址：
图表11：散点图分析
查询接口地址：
新增接口地址：
修改接口地址：
删除接口地址：
新增表reload接口
初始化数据库表

原型预览

接口功能(APIJSON集成)

新增数据接口

接口地址：http://pai.flyrise.cn/data-manager-api/data/post

请求参数：

{
    "DataTopicChart[]": [
        {
            "user_id": "1",
            "topic_id": "1",
            "name": "测试3",
            "icon_url": "",
            "table_name": "",
            "table_create_sql": "data_chart_",
            "table_data_sql": "",
            "table_query_sql": "",
            "order": 12,
            "show": false,
            "create_time": "2021-09-02 19:15:24",
            "update_time": "2021-09-02 19:15:24"
        },
        {
            "user_id": "1",
            "topic_id": "1",
            "name": "测试4",
            "icon_url": "",
            "table_name": "",
            "table_create_sql": "data_chart_",
            "table_data_sql": "",
            "table_query_sql": "",
            "order": 12,
            "show": false,
            "create_time": "2021-09-02 19:15:24",
            "update_time": "2021-09-02 19:15:24"
        }
    ],
    "tag": "DataTopicChart"
}

返回数据：

{
    "DataTopicChart": {
        "ok": true,
        "code": 200,
        "msg": "success",
        "count": 2,
        "id[]": [
            1599269806010,
            1599269806060
        ]
    },
    "tag": "DataTopicChart",
    "ok": true,
    "code": 200,
    "msg": "success",
    "sql:generate|cache|execute|maxExecute": "2|0|2|200",
    "depth:count|max": "2|5",
    "time:start|duration|end": "1599269857112|77|1599269857189"
}

修改数据接口

接口地址：http://pai.flyrise.cn/data-manager-api/data/put

请求参数：

{
    "DataTopicChart[]": [
        {
            "id": 1599269806010,
            "user_id": "121212",
            "topic_id": "1",
            "name": "测试111",
            "icon_url": "",
            "table_name": "",
            "table_create_sql": "data_chart_",
            "table_data_sql": "",
            "table_query_sql": "",
            "order": 12,
            "show": true,
            "create_time": "2021-09-02 19:15:24",
            "update_time": "2021-09-02 19:15:24"
        },
        {
            "id": 1599269806060,
            "user_id": "121212",
            "topic_id": "1",
            "name": "测试222",
            "icon_url": "",
            "table_name": "",
            "table_create_sql": "data_chart_",
            "table_data_sql": "",
            "table_query_sql": "",
            "order": 12,
            "show": true,
            "create_time": "2021-09-02 19:15:24",
            "update_time": "2021-09-02 19:15:24"
        }
    ],
    "tag": "DataTopicChart"
}

返回数据：

{
    "DataTopicChart": {
        "ok": true,
        "code": 200,
        "msg": "success",
        "count": 2,
        "id[]": [
            1599269806010,
            1599269806060
        ]
    },
    "tag": "DataTopicChart",
    "ok": true,
    "code": 200,
    "msg": "success",
    "sql:generate|cache|execute|maxExecute": "2|0|2|200",
    "depth:count|max": "2|5",
    "time:start|duration|end": "1599269857112|77|1599269857189"
}

删除数据接口

接口地址：http://pai.flyrise.cn/data-manager-api/data/delete

请求参数：

{
    "DataTopicChart": {
        "id{}": [
            1599269806010,
            1599269806060
        ]
    },
    "tag": "DataTopicChart"
}

返回数据：

{
    "DataTopicChart": {
        "ok": true,
        "code": 200,
        "msg": "success",
        "count": 2,
        "id[]": [
            1599269806010,
            1599269806060
        ]
    },
    "tag": "DataTopicChart",
    "ok": true,
    "code": 200,
    "msg": "success",
    "sql:generate|cache|execute|maxExecute": "1|0|1|200",
    "depth:count|max": "1|5",
    "time:start|duration|end": "1599269958785|56|1599269958841"
}

查询数据接口

图表类型列表

接口地址：http://pai.flyrise.cn/data-manager-api/data/get

请求参数：

{
    "DataChartType[]": {
        "page": 0,
        "count": 10,
        "DataChartType": {
            "@column":"id,en_name,cn_name",
            "@order":"id+"
        }
    }
}

返回数据：

{
    "DataChartType[]": [
        {
            "id": 1,
            "en_name": "text_data",
            "cn_name": "文本数据图"
        },
        {
            "id": 2,
            "en_name": "line_hours",
            "cn_name": "折线分时走势图"
        },
        {
            "id": 3,
            "en_name": "table_retain",
            "cn_name": "留存表格图"
        },
        {
            "id": 4,
            "en_name": "text_words",
            "cn_name": "词云"
        },
        {
            "id": 5,
            "en_name": "bar_y",
            "cn_name": "Y轴柱状图"
        },
        {
            "id": 6,
            "en_name": "bar_x",
            "cn_name": "X轴柱状图"
        },
        {
            "id": 7,
            "en_name": "funnel",
            "cn_name": "漏斗图"
        },
        {
            "id": 8,
            "en_name": "radar",
            "cn_name": "雷达图"
        },
        {
            "id": 9,
            "en_name": "pie",
            "cn_name": "饼表"
        },
        {
            "id": 10,
            "en_name": "gauge",
            "cn_name": "仪表图"
        }
    ],
    "ok": true,
    "code": 200,
    "msg": "success",
    "sql:generate|cache|execute|maxExecute": "10|9|1|200",
    "depth:count|max": "3|5",
    "time:start|duration|end": "1599537251424|37|1599537251461"
}

资产列表

接口地址：http://pai.flyrise.cn/data-manager-api/data/get

请求参数：

{
    "DataTopic[]": {
        "page": 0,
        "count": 10,
        "DataTopic": {
            "show": true,
            "@column":"id,name",
            "@order":"order+"
        }
    }
}

返回数据：

{
    "DataTopic[]": [
        {
            "id": 1,
            "name": "用户行为"
        },
        {
            "id": 2,
            "name": "智慧通行"
        },
        {
            "id": 3,
            "name": "综合安防"
        }
    ],
    "ok": true,
    "code": 200,
    "msg": "success",
    "sql:generate|cache|execute|maxExecute": "4|3|1|200",
    "depth:count|max": "3|5",
    "time:start|duration|end": "1599118165369|183|1599118165552"
}

资产详情列表

接口地址：http://pai.flyrise.cn/data-manager-api/data/get

请求参数：

{
    "DataTopicChart[]": {
        "page": 0,
        "count": 10,
        "DataTopicChart": {
            "topic_id": 1,
            "show": true,
            "@column": "id,user_id,name,icon_url,table_name,table_query_sql,chart_type_id,table_field_json",
            "@order": "order+"
        },
        "query": 2
    },
    "total@": "/DataTopicChart[]/total"
}

返回数据：

{
    "DataTopicChart[]": [
        {
            "id": 1,
            "user_id": "1",
            "name": "访问数分析",
            "icon_url": "",
            "table_name": "data_chart_1",
            "table_query_sql": "{\r\n    \"DataChart1[]\": {\r\n        \"page\": 0,\r\n        \"count\": 10,\r\n        \"DataChart1\": {\r\n            \"user_id\": 1,\r\n            \"@column\":\"id,name,value,rate\",\r\n            \"@order\":\"id+\"\r\n        }\r\n    }\r\n}",
            "chart_type_id": 1,
            "table_field_json": "{\r\n\t\"table\": \"COLUMNS\",\r\n\t\"rows\":\r\n\t[\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"id\",\r\n\t\t\t\"column_comment\": \"id\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"user_id\",\r\n\t\t\t\"column_comment\": \"开发者id\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"name\",\r\n\t\t\t\"column_comment\": \"统计名称\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"rate\",\r\n\t\t\t\"column_comment\": \"昨日增长率\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"value\",\r\n\t\t\t\"column_comment\": \"数量\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"create_time\",\r\n\t\t\t\"column_comment\": \"创建时间\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"update_time\",\r\n\t\t\t\"column_comment\": \"修改时间\"\r\n\t\t}\r\n\t]\r\n}"
        },
        {
            "id": 2,
            "user_id": "1",
            "name": "分时走势分析",
            "icon_url": "",
            "table_name": "data_chart_2",
            "table_query_sql": "{\r\n    \"DataChart2[]\": {\r\n        \"page\": 0,\r\n        \"count\": 23,\r\n        \"DataChart2\": {\r\n            \"user_id\": 1,\r\n            \"@column\": \"id,date_hour,value\",\r\n            \"@order\": \"date_hour+\"\r\n        }\r\n    }\r\n}",
            "chart_type_id": 2,
            "table_field_json": "{\r\n\t\"table\": \"COLUMNS\",\r\n\t\"rows\":\r\n\t[\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"id\",\r\n\t\t\t\"column_comment\": \"\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"user_id\",\r\n\t\t\t\"column_comment\": \"开发者id\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"date_hour\",\r\n\t\t\t\"column_comment\": \"小时\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"value\",\r\n\t\t\t\"column_comment\": \"访问数\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"create_time\",\r\n\t\t\t\"column_comment\": \"创建时间\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"update_time\",\r\n\t\t\t\"column_comment\": \"更新时间\"\r\n\t\t}\r\n\t]\r\n}"
        },
        {
            "id": 3,
            "user_id": "1",
            "name": "7日留存分析",
            "icon_url": "",
            "table_name": "data_chart_3",
            "table_query_sql": "{\r\n    \"DataChart3[]\": {\r\n        \"page\": 0,\r\n        \"count\": 7,\r\n        \"DataChart3\": {\r\n            \"user_id\": 1,\r\n            \"@column\": \"id,date,value,value_day_1,value_day_2,value_day_3,value_day_4,value_day_5,value_day_6,value_day_7\",\r\n            \"@order\": \"date+\"\r\n        }\r\n    }\r\n}",
            "chart_type_id": 3,
            "table_field_json": "{\r\n\t\"table\": \"COLUMNS\",\r\n\t\"rows\":\r\n\t[\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"id\",\r\n\t\t\t\"column_comment\": \"\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"user_id\",\r\n\t\t\t\"column_comment\": \"开发者id\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"date\",\r\n\t\t\t\"column_comment\": \"日期\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"value\",\r\n\t\t\t\"column_comment\": \"留存数\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"value_day_1\",\r\n\t\t\t\"column_comment\": \"1日留存数\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"value_day_2\",\r\n\t\t\t\"column_comment\": \"2日留存数\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"value_day_3\",\r\n\t\t\t\"column_comment\": \"3日留存数\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"value_day_4\",\r\n\t\t\t\"column_comment\": \"4日留存数\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"value_day_5\",\r\n\t\t\t\"column_comment\": \"5日留存数\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"value_day_6\",\r\n\t\t\t\"column_comment\": \"6日留存数\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"value_day_7\",\r\n\t\t\t\"column_comment\": \"7日留存数\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"create_time\",\r\n\t\t\t\"column_comment\": \"创建时间\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"update_time\",\r\n\t\t\t\"column_comment\": \"更新时间\"\r\n\t\t}\r\n\t]\r\n}"
        },
        {
            "id": 4,
            "user_id": "1",
            "name": "词云分析",
            "icon_url": "",
            "table_name": "data_chart_4",
            "table_query_sql": "{\r\n    \"DataChart4[]\": {\r\n        \"page\": 0,\r\n        \"count\": 10,\r\n        \"DataChart4\": {\r\n            \"user_id\": 1,\r\n            \"@column\": \"id,word,count\",\r\n            \"@order\": \"count-\"\r\n        }\r\n    }\r\n}",
            "chart_type_id": 4,
            "table_field_json": "{\r\n\t\"table\": \"COLUMNS\",\r\n\t\"rows\":\r\n\t[\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"id\",\r\n\t\t\t\"column_comment\": \"\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"user_id\",\r\n\t\t\t\"column_comment\": \"开发者id\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"word\",\r\n\t\t\t\"column_comment\": \"词\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"count\",\r\n\t\t\t\"column_comment\": \"数量\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"create_time\",\r\n\t\t\t\"column_comment\": \"创建时间\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"update_time\",\r\n\t\t\t\"column_comment\": \"更新时间\"\r\n\t\t}\r\n\t]\r\n}"
        },
        {
            "id": 5,
            "user_id": "1",
            "name": "页面访问排行",
            "icon_url": "",
            "table_name": "data_chart_5",
            "table_query_sql": "{\r\n    \"DataChart5[]\": {\r\n        \"page\": 0,\r\n        \"count\": 10,\r\n        \"DataChart5\": {\r\n            \"user_id\": 1,\r\n            \"@column\": \"id,name,value\",\r\n            \"@order\": \"value-\"\r\n        }\r\n    }\r\n}",
            "chart_type_id": 5,
            "table_field_json": "{\r\n\t\"table\": \"COLUMNS\",\r\n\t\"rows\":\r\n\t[\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"id\",\r\n\t\t\t\"column_comment\": \"\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"user_id\",\r\n\t\t\t\"column_comment\": \"开发者id\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"name\",\r\n\t\t\t\"column_comment\": \"名称\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"value\",\r\n\t\t\t\"column_comment\": \"数量\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"create_time\",\r\n\t\t\t\"column_comment\": \"创建时间\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"update_time\",\r\n\t\t\t\"column_comment\": \"更新时间\"\r\n\t\t}\r\n\t]\r\n}"
        },
        {
            "id": 6,
            "user_id": "1",
            "name": "用户访问数排行",
            "icon_url": "",
            "table_name": "data_chart_6",
            "table_query_sql": "{\r\n    \"DataChart6[]\": {\r\n        \"page\": 0,\r\n        \"count\": 10,\r\n        \"DataChart6\": {\r\n            \"user_id\": 1,\r\n            \"@column\": \"id,name,value\",\r\n            \"@order\": \"value-\"\r\n        }\r\n    }\r\n}",
            "chart_type_id": 6,
            "table_field_json": "{\r\n\t\"table\": \"COLUMNS\",\r\n\t\"rows\":\r\n\t[\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"id\",\r\n\t\t\t\"column_comment\": \"\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"user_id\",\r\n\t\t\t\"column_comment\": \"开发者id\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"name\",\r\n\t\t\t\"column_comment\": \"名称\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"value\",\r\n\t\t\t\"column_comment\": \"数量\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"create_time\",\r\n\t\t\t\"column_comment\": \"创建时间\"\r\n\t\t},\r\n\t\t{\r\n\t\t\t\"COLUMN_NAME\": \"update_time\",\r\n\t\t\t\"column_comment\": \"更新时间\"\r\n\t\t}\r\n\t]\r\n}"
        }
    ],
    "total": 6,
    "ok": true,
    "code": 200,
    "msg": "success",
    "sql:generate|cache|execute|maxExecute": "7|6|1|200",
    "depth:count|max": "3|5",
    "time:start|duration|end": "1599553650236|27|1599553650263"
}

图表1：访问数

查询接口地址：

http://pai.flyrise.cn/data-manager-api/data/get

请求参数：

{
> 
        "page": 0,
        "count": 10,
        "DataChart1": {
            "user_id": 1,
            "@column":"id,name,value,rate",
            "@order":"id+"
        }
    }
}

"DataChart1[]": {
    "page": 0,
    "count": 10,
    "DataChart1": {
        "user_id": 1,
        "@column":"id,name,value,rate",
        "@order":"id+"
    }
}

}


返回数据：
```json
{
    "DataChart1[]": [
        {
            "name": "新增用户",
            "value": 3,
            "rate": 20.00
        },
        {
            "name": "新增账户",
            "value": 2,
            "rate": 100.00
        },
        {
            "name": "活跃账户",
            "value": 0,
            "rate": 0.00
        },
        {
            "name": "启动次数",
            "value": 100,
            "rate": 50.00
        },
        {
            "name": "页面访问数",
            "value": 200,
            "rate": 50.00
        }
    ],
    "ok": true,
    "code": 200,
    "msg": "success",
    "sql:generate|cache|execute|maxExecute": "6|5|1|200",
    "depth:count|max": "3|5",
    "time:start|duration|end": "1599119079700|244|1599119079944"
}

新增接口地址：

http://pai.flyrise.cn/data-manager-api/data/post

请求参数：

{
    "DataChart1[]": [
        {
            "user_id": "1",
            "name": "新增用户",
            "rate": 20.00,
            "value": 3,
            "create_time": "2020-09-02 20:01:11",
            "update_time": "2020-09-02 20:01:13"
        },
        {
            "user_id": "1",
            "name": "新增账户",
            "rate": 100.00,
            "value": 2,
            "create_time": "2020-09-02 20:01:41",
            "update_time": "2020-09-02 20:01:42"
        }
    ],
    "tag": "DataChart1"
}

修改接口地址：

http://pai.flyrise.cn/data-manager-api/data/put

请求参数：

{
    "DataChart1[]": [
        {
            "id": 10,
            "user_id": "1",
            "name": "新增用户",
            "rate": 20.00,
            "value": 3,
            "create_time": "2020-09-02 20:01:11",
            "update_time": "2020-09-02 20:01:13"
        },
        {
            "id": 11,
            "user_id": "1",
            "name": "新增账户",
            "rate": 100.00,
            "value": 2,
            "create_time": "2020-09-02 20:01:41",
            "update_time": "2020-09-02 20:01:42"
        }
    ],
    "tag": "DataChart1"
}

删除接口地址：

http://pai.flyrise.cn/data-manager-api/data/delete

请求参数：

{
    "DataChart1": {
        "id{}": [10,11]
    },
    "tag": "DataChart1"
}

图表2：分时走势图

查询接口地址：

http://pai.flyrise.cn/data-manager-api/data/get

请求参数：

{
    "DataChart2[]": {
        "page": 0,
        "count": 23,
        "DataChart2": {
            "user_id": 1,
            "@column": "id,date_hour,value",
            "@order": "date_hour+"
        }
    }
}

返回数据：

{
    "DataChart2[]": [
        {
            "date_hour": "2020-09-02 00:00:00.0",
            "value": 0
        },
        {
            "date_hour": "2020-09-02 01:00:00.0",
            "value": 0
        },
        {
            "date_hour": "2020-09-02 02:00:00.0",
            "value": 0
        },
        {
            "date_hour": "2020-09-02 03:00:00.0",
            "value": 0
        },
        {
            "date_hour": "2020-09-02 04:00:00.0",
            "value": 0
        },
        {
            "date_hour": "2020-09-02 05:00:00.0",
            "value": 0
        },
        {
            "date_hour": "2020-09-02 06:00:00.0",
            "value": 0
        },
        {
            "date_hour": "2020-09-02 07:00:00.0",
            "value": 0
        },
        {
            "date_hour": "2020-09-02 08:00:00.0",
            "value": 10
        },
        {
            "date_hour": "2020-09-02 09:00:00.0",
            "value": 0
        },
        {
            "date_hour": "2020-09-02 10:00:00.0",
            "value": 0
        },
        {
            "date_hour": "2020-09-02 11:00:00.0",
            "value": 20
        },
        {
            "date_hour": "2020-09-02 12:00:00.0",
            "value": 100
        },
        {
            "date_hour": "2020-09-02 13:00:00.0",
            "value": 0
        },
        {
            "date_hour": "2020-09-02 14:00:00.0",
            "value": 5
        },
        {
            "date_hour": "2020-09-02 15:00:00.0",
            "value": 0
        },
        {
            "date_hour": "2020-09-02 16:00:00.0",
            "value": 1
        },
        {
            "date_hour": "2020-09-02 17:00:00.0",
            "value": 0
        },
        {
            "date_hour": "2020-09-02 18:00:00.0",
            "value": 0
        },
        {
            "date_hour": "2020-09-02 19:00:00.0",
            "value": 30
        },
        {
            "date_hour": "2020-09-02 20:00:00.0",
            "value": 120
        },
        {
            "date_hour": "2020-09-02 21:00:00.0",
            "value": 0
        },
        {
            "date_hour": "2020-09-02 22:00:00.0",
            "value": 20
        }
    ],
    "ok": true,
    "code": 200,
    "msg": "success",
    "sql:generate|cache|execute|maxExecute": "23|22|1|200",
    "depth:count|max": "3|5",
    "time:start|duration|end": "1599119210937|250|1599119211187"
}

新增接口地址：

http://pai.flyrise.cn/data-manager-api/data/post

请求参数：

{
    "DataChart2[]": [
        {
            "user_id": "1",
            "date_hour": "2020-09-02 00:00:00",
            "value": 0,
            "create_time": "2020-09-02 20:06:39",
            "update_time": "2020-09-02 20:06:40"
        },
        {
            "user_id": "1",
            "date_hour": "2020-09-02 01:00:00",
            "value": 0,
            "create_time": "2020-09-02 20:06:39",
            "update_time": "2020-09-02 20:06:40"
        }
    ],
    "tag": "DataChart2"
}

修改接口地址：

http://pai.flyrise.cn/data-manager-api/data/put

请求参数：

{
    "DataChart2[]": [
        {
            "id": 1,
            "user_id": "1",
            "date_hour": "2020-09-02 00:00:00",
            "value": 0,
            "create_time": "2020-09-02 20:06:39",
            "update_time": "2020-09-02 20:06:40"
        },
        {
            "id": 2,
            "user_id": "1",
            "date_hour": "2020-09-02 01:00:00",
            "value": 0,
            "create_time": "2020-09-02 20:06:39",
            "update_time": "2020-09-02 20:06:40"
        }
    ],
    "tag": "DataChart2"
}

删除接口地址：

http://pai.flyrise.cn/data-manager-api/data/delete

请求参数：

{
    "DataChart2": {
        "id{}": [10,11]
    },
    "tag": "DataChart2"
}

图表3：7日留存分析

查询接口地址：

http://pai.flyrise.cn/data-manager-api/data/get

请求参数：

{
    "DataChart3[]": {
        "page": 0,
        "count": 7,
        "DataChart3": {
            "user_id": 1,
            "@column": "id,date,value,value_day_1,value_day_2,value_day_3,value_day_4,value_day_5,value_day_6,value_day_7",
            "@order": "date+"
        }
    }
}

返回数据：

{
    "DataChart3[]": [
        {
            "date": "2020-08-24",
            "value": 100,
            "value_day_1": 50,
            "value_day_2": 60,
            "value_day_3": 80,
            "value_day_4": 10,
            "value_day_5": 15,
            "value_day_6": 0,
            "value_day_7": 60
        },
        {
            "date": "2020-08-25",
            "value": 100,
            "value_day_1": 50,
            "value_day_2": 60,
            "value_day_3": 80,
            "value_day_4": 10,
            "value_day_5": 15,
            "value_day_6": 10,
            "value_day_7": 0
        },
        {
            "date": "2020-08-26",
            "value": 100,
            "value_day_1": 50,
            "value_day_2": 60,
            "value_day_3": 80,
            "value_day_4": 10,
            "value_day_5": 10,
            "value_day_6": 0,
            "value_day_7": 0
        },
        {
            "date": "2020-08-27",
            "value": 100,
            "value_day_1": 50,
            "value_day_2": 60,
            "value_day_3": 80,
            "value_day_4": 20,
            "value_day_5": 0,
            "value_day_6": 0,
            "value_day_7": 0
        },
        {
            "date": "2020-08-28",
            "value": 100,
            "value_day_1": 50,
            "value_day_2": 60,
            "value_day_3": 30,
            "value_day_4": 0,
            "value_day_5": 0,
            "value_day_6": 0,
            "value_day_7": 0
        },
        {
            "date": "2020-08-29",
            "value": 100,
            "value_day_1": 50,
            "value_day_2": 10,
            "value_day_3": 0,
            "value_day_4": 0,
            "value_day_5": 0,
            "value_day_6": 0,
            "value_day_7": 0
        },
        {
            "date": "2020-08-30",
            "value": 100,
            "value_day_1": 50,
            "value_day_2": 0,
            "value_day_3": 0,
            "value_day_4": 0,
            "value_day_5": 0,
            "value_day_6": 0,
            "value_day_7": 0
        }
    ],
    "ok": true,
    "code": 200,
    "msg": "success",
    "sql:generate|cache|execute|maxExecute": "7|6|1|200",
    "depth:count|max": "3|5",
    "time:start|duration|end": "1599119733257|179|1599119733436"
}

新增接口地址：

http://pai.flyrise.cn/data-manager-api/data/post

请求参数：

{
    "DataChart3[]": [
       {
            "user_id": "1",
            "date": "2020-08-24",
            "value": 100,
            "value_day_1": 50,
            "value_day_2": 60,
            "value_day_3": 80,
            "value_day_4": 10,
            "value_day_5": 15,
            "value_day_6": 0,
            "value_day_7": 60,
            "create_time": "2020-09-03 10:50:58",
            "update_time": "2020-09-03 10:51:03"
        },
        {
            "user_id": "1",
            "date": "2020-08-25",
            "value": 100,
            "value_day_1": 50,
            "value_day_2": 60,
            "value_day_3": 80,
            "value_day_4": 10,
            "value_day_5": 15,
            "value_day_6": 10,
            "value_day_7": 0,
            "create_time": "2020-09-03 10:50:58",
            "update_time": "2020-09-03 10:51:03"
        }
    ],
    "tag": "DataChart3"
}

修改接口地址：

http://pai.flyrise.cn/data-manager-api/data/put

请求参数：

{
    "DataChart3[]": [
       {
            "id": 1,
            "user_id": "1",
            "date": "2020-08-24",
            "value": 100,
            "value_day_1": 50,
            "value_day_2": 60,
            "value_day_3": 80,
            "value_day_4": 10,
            "value_day_5": 15,
            "value_day_6": 0,
            "value_day_7": 60,
            "create_time": "2020-09-03 10:50:58",
            "update_time": "2020-09-03 10:51:03"
        },
        {
            "id": 2,
            "user_id": "1",
            "date": "2020-08-25",
            "value": 100,
            "value_day_1": 50,
            "value_day_2": 60,
            "value_day_3": 80,
            "value_day_4": 10,
            "value_day_5": 15,
            "value_day_6": 10,
            "value_day_7": 0,
            "create_time": "2020-09-03 10:50:58",
            "update_time": "2020-09-03 10:51:03"
        }
    ],
    "tag": "DataChart3"
}

删除接口地址：

http://pai.flyrise.cn/data-manager-api/data/delete

请求参数：

{
    "DataChart3": {
        "id{}": [10,11]
    },
    "tag": "DataChart3"
}

图表4：词云

查询接口地址：

http://pai.flyrise.cn/data-manager-api/data/get

请求参数：

{
    "DataChart4[]": {
        "page": 0,
        "count": 10,
        "DataChart4": {
            "user_id": 1,
            "@column": "id,word,count",
            "@order": "count-"
        }
    }
}

返回数据：

{
    "DataChart4[]": [
        {
            "word": "AI",
            "count": 1000
        },
        {
            "word": "大数据",
            "count": 900
        },
        {
            "word": "云计算",
            "count": 800
        },
        {
            "word": "数据中台",
            "count": 700
        },
        {
            "word": "业务中台",
            "count": 500
        },
        {
            "word": "技术平台",
            "count": 300
        },
        {
            "word": "IOT",
            "count": 200
        },
        {
            "word": "5G",
            "count": 100
        }
    ],
    "ok": true,
    "code": 200,
    "msg": "success",
    "sql:generate|cache|execute|maxExecute": "9|8|1|200",
    "depth:count|max": "3|5",
    "time:start|duration|end": "1599119823474|208|1599119823682"
}

新增接口地址：

http://pai.flyrise.cn/data-manager-api/data/post

请求参数：

{
    "DataChart4[]": [
        {
            "user_id": "1",
            "word": "AI",
            "count": 1000,
            "create_time": "2020-09-03 11:00:23",
            "update_time": "2020-09-03 11:00:24"
        },
        {
            "user_id": "1",
            "word": "大数据",
            "count": 900,
            "create_time": "2020-09-03 11:00:23",
            "update_time": "2020-09-03 11:00:24"
        }
    ],
    "tag": "DataChart4"
}

修改接口地址：

http://pai.flyrise.cn/data-manager-api/data/put

请求参数：

{
    "DataChart4[]": [
        {
            "id": 1,
            "user_id": "1",
            "word": "AI",
            "count": 1000,
            "create_time": "2020-09-03 11:00:23",
            "update_time": "2020-09-03 11:00:24"
        },
        {
            "id": 2,
            "user_id": "1",
            "word": "大数据",
            "count": 900,
            "create_time": "2020-09-03 11:00:23",
            "update_time": "2020-09-03 11:00:24"
        }
    ],
    "tag": "DataChart4"
}

删除接口地址：

http://pai.flyrise.cn/data-manager-api/data/delete

请求参数：

{
    "DataChart4": {
        "id{}": [10,11]
    },
    "tag": "DataChart4"
}

图表5：页面访问排行

查询接口地址：

http://pai.flyrise.cn/data-manager-api/data/get

请求参数：

{
    "DataChart5[]": {
        "page": 0,
        "count": 10,
        "DataChart5": {
            "user_id": 1,
            "@column": "id,name,value",
            "@order": "value-"
        }
    }
}

返回数据：

{
    "DataChart5[]": [
        {
            "name": "主页",
            "value": 100
        },
        {
            "name": "登录页",
            "value": 90
        },
        {
            "name": "支付页",
            "value": 80
        },
        {
            "name": "广场活动页",
            "value": 50
        },
        {
            "name": "投票活动页",
            "value": 20
        },
        {
            "name": "车广告页",
            "value": 10
        },
        {
            "name": "优惠页",
            "value": 3
        }
    ],
    "ok": true,
    "code": 200,
    "msg": "success",
    "sql:generate|cache|execute|maxExecute": "8|7|1|200",
    "depth:count|max": "3|5",
    "time:start|duration|end": "1599119912996|272|1599119913268"
}

新增接口地址：

http://pai.flyrise.cn/data-manager-api/data/post

请求参数：

{
    "DataChart5[]": [
       {
            "user_id": "1",
            "name": "主页",
            "value": 100,
            "create_time": "2020-09-03 11:04:36",
            "update_time": "2020-09-03 11:04:37"
        },
        {
            "user_id": "1",
            "name": "登录页",
            "value": 90,
            "create_time": "2020-09-03 11:04:36",
            "update_time": "2020-09-03 11:04:37"
        }
    ],
    "tag": "DataChart5"
}

修改接口地址：

http://pai.flyrise.cn/data-manager-api/data/put

请求参数：

{
    "DataChart5[]": [
        {
            "id": 1,
            "user_id": "1",
            "name": "主页",
            "value": 100,
            "create_time": "2020-09-03 11:04:36",
            "update_time": "2020-09-03 11:04:37"
        },
        {
            "id": 2,
            "user_id": "1",
            "name": "登录页",
            "value": 90,
            "create_time": "2020-09-03 11:04:36",
            "update_time": "2020-09-03 11:04:37"
        }
    ],
    "tag": "DataChart5"
}

删除接口地址：

http://pai.flyrise.cn/data-manager-api/data/delete

请求参数：

{
    "DataChart5": {
        "id{}": [10,11]
    },
    "tag": "DataChart5"
}

图表6：用户访问数排行

查询接口地址：

http://pai.flyrise.cn/data-manager-api/data/get

请求参数：

{
    "DataChart6[]": {
        "page": 0,
        "count": 10,
        "DataChart6": {
            "user_id": 1,
            "@column": "id,name,value",
            "@order": "value-"
        }
    }
}

返回数据：

{
    "DataChart6[]": [
        {
            "name": "张三",
            "value": 100
        },
        {
            "name": "李四",
            "value": 90
        },
        {
            "name": "王五",
            "value": 80
        },
        {
            "name": "孙六",
            "value": 70
        },
        {
            "name": "赵七",
            "value": 68
        },
        {
            "name": "公孙八",
            "value": 55
        },
        {
            "name": "九九",
            "value": 40
        },
        {
            "name": "十十",
            "value": 31
        },
        {
            "name": "十一",
            "value": 22
        },
        {
            "name": "十二",
            "value": 6
        }
    ],
    "ok": true,
    "code": 200,
    "msg": "success",
    "sql:generate|cache|execute|maxExecute": "10|9|1|200",
    "depth:count|max": "3|5",
    "time:start|duration|end": "1599119954991|261|1599119955252"
}

新增接口地址：

http://pai.flyrise.cn/data-manager-api/data/post

请求参数：

{
    "DataChart6[]": [
        {
            "user_id": "1",
            "name": "张三",
            "value": 100,
            "create_time": "2020-09-03 11:09:27",
            "update_time": "2020-09-03 11:09:28"
        },
        {
            "user_id": "1",
            "name": "李四",
            "value": 90,
            "create_time": "2020-09-03 11:09:27",
            "update_time": "2020-09-03 11:09:28"
        }
    ],
    "tag": "DataChart6"
}

修改接口地址：

http://pai.flyrise.cn/data-manager-api/data/put

请求参数：

{
    "DataChart6[]": [
        {
            "id": 1,
            "user_id": "1",
            "name": "张三",
            "value": 100,
            "create_time": "2020-09-03 11:09:27",
            "update_time": "2020-09-03 11:09:28"
        },
        {
            "id": 2,
            "user_id": "1",
            "name": "李四",
            "value": 90,
            "create_time": "2020-09-03 11:09:27",
            "update_time": "2020-09-03 11:09:28"
        }
    ],
    "tag": "DataChart6"
}

删除接口地址：

http://pai.flyrise.cn/data-manager-api/data/delete

请求参数：

{
    "DataChart6": {
        "id{}": [10,11]
    },
    "tag": "DataChart6"
}

图表7：漏斗分析

查询接口地址：

http://pai.flyrise.cn/data-manager-api/data/get

请求参数：

{
    "DataChart7[]": {
        "page": 0,
        "count": 10,
        "DataChart7": {
            "user_id": 1,
            "@column": "id,name,value",
            "@order": "value-"
        }
    }
}

返回数据：


{
    "DataChart7[]": [
        {
            "name": "访问率",
            "value": 100
        },
        {
            "name": "点击率",
            "value": 80
        },
        {
            "name": "咨询率",
            "value": 60
        },
        {
            "name": "成单率",
            "value": 40
        }
    ],
    "ok": true,
    "code": 200,
    "msg": "success",
    "sql:generate|cache|execute|maxExecute": "5|4|1|200",
    "depth:count|max": "3|5",
    "time:start|duration|end": "1599119999727|168|1599119999895"
}

新增接口地址：

http://pai.flyrise.cn/data-manager-api/data/post

请求参数：

{
    "DataChart7[]": [
        {
            "user_id": "1",
            "name": "访问率",
            "value": 100,
            "create_time": "2020-09-03 11:16:11",
            "update_time": "2020-09-03 11:16:12"
        },
        {
            "user_id": "1",
            "name": "点击率",
            "value": 80,
            "create_time": "2020-09-03 11:16:11",
            "update_time": "2020-09-03 11:16:12"
        }
    ],
    "tag": "DataChart7"
}

修改接口地址：

http://pai.flyrise.cn/data-manager-api/data/put

请求参数：

{
    "DataChart7[]": [
        {
            "id": 1,
            "user_id": "1",
            "name": "访问率",
            "value": 100,
            "create_time": "2020-09-03 11:16:11",
            "update_time": "2020-09-03 11:16:12"
        },
        {
            "id": 2,
            "user_id": "1",
            "name": "点击率",
            "value": 80,
            "create_time": "2020-09-03 11:16:11",
            "update_time": "2020-09-03 11:16:12"
        }
    ],
    "tag": "DataChart7"
}

删除接口地址：

http://pai.flyrise.cn/data-manager-api/data/delete

请求参数：

{
    "DataChart7": {
        "id{}": [10,11]
    },
    "tag": "DataChart7"
}

图表8：雷达图分析

查询接口地址：

http://pai.flyrise.cn/data-manager-api/data/get

请求参数：

{
    "DataChart8[]": {
        "page": 0,
        "count": 6,
        "DataChart8": {
            "user_id": 1,
            "@column": "id,name,value_dimension_1,value_dimension_2,value_dimension_3,value_dimension_4,value_dimension_5,value_dimension_6",
            "@order": "id+"
        }
    }
}

返回数据：

{
    "DataChart8[]": [
        {
            "name": "预估标准",
            "value_dimension_1": 100,
            "value_dimension_2": 90,
            "value_dimension_3": 80,
            "value_dimension_4": 90,
            "value_dimension_5": 80,
            "value_dimension_6": 80
        },
        {
            "name": "实际测量",
            "value_dimension_1": 70,
            "value_dimension_2": 60,
            "value_dimension_3": 50,
            "value_dimension_4": 60,
            "value_dimension_5": 70,
            "value_dimension_6": 80
        }
    ],
    "ok": true,
    "code": 200,
    "msg": "success",
    "sql:generate|cache|execute|maxExecute": "3|2|1|200",
    "depth:count|max": "3|5",
    "time:start|duration|end": "1599120081203|181|1599120081384"
}

新增接口地址：

http://pai.flyrise.cn/data-manager-api/data/post

请求参数：

{
    "DataChart8[]": [
        {
            "user_id": "1",
            "name": "预估标准",
            "value_dimension_1": 100,
            "value_dimension_2": 90,
            "value_dimension_3": 80,
            "value_dimension_4": 90,
            "value_dimension_5": 80,
            "value_dimension_6": 80,
            "create_time": "2020-09-03 11:26:03",
            "update_time": "2020-09-03 11:26:12"
        },
        {
            "user_id": "1",
            "name": "实际测量",
            "value_dimension_1": 70,
            "value_dimension_2": 60,
            "value_dimension_3": 50,
            "value_dimension_4": 60,
            "value_dimension_5": 70,
            "value_dimension_6": 80,
            "create_time": "2020-09-03 11:26:03",
            "update_time": "2020-09-03 11:26:12"
        }
    ],
    "tag": "DataChart8"
}

修改接口地址：

http://pai.flyrise.cn/data-manager-api/data/put

请求参数：

{
    "DataChart8[]": [
       {
            "id": 1,
            "user_id": "1",
            "name": "预估标准",
            "value_dimension_1": 100,
            "value_dimension_2": 90,
            "value_dimension_3": 80,
            "value_dimension_4": 90,
            "value_dimension_5": 80,
            "value_dimension_6": 80,
            "create_time": "2020-09-03 11:26:03",
            "update_time": "2020-09-03 11:26:12"
        },
        {
            "id": 2,
            "user_id": "1",
            "name": "实际测量",
            "value_dimension_1": 70,
            "value_dimension_2": 60,
            "value_dimension_3": 50,
            "value_dimension_4": 60,
            "value_dimension_5": 70,
            "value_dimension_6": 80,
            "create_time": "2020-09-03 11:26:03",
            "update_time": "2020-09-03 11:26:12"
        }
    ],
    "tag": "DataChart8"
}

删除接口地址：

http://pai.flyrise.cn/data-manager-api/data/delete

请求参数：

{
    "DataChart8": {
        "id{}": [10,11]
    },
    "tag": "DataChart8"
}

图表9：饼图分析

查询接口地址：

http://pai.flyrise.cn/data-manager-api/data/get

请求参数：

{
    "DataChart9[]": {
        "page": 0,
        "count": 10,
        "DataChart9": {
            "user_id": 1,
            "@column": "id,name,value",
            "@order": "value-"
        }
    }
}

返回数据：

{
    "DataChart9[]": [
        {
            "name": "本科",
            "value": 800
        },
        {
            "name": "博士",
            "value": 500
        },
        {
            "name": "高中及以下",
            "value": 500
        },
        {
            "name": "大专",
            "value": 400
        },
        {
            "name": "硕士",
            "value": 50
        }
    ],
    "ok": true,
    "code": 200,
    "msg": "success",
    "sql:generate|cache|execute|maxExecute": "6|5|1|200",
    "depth:count|max": "3|5",
    "time:start|duration|end": "1599120304174|161|1599120304335"
}

新增接口地址：

http://pai.flyrise.cn/data-manager-api/data/post

请求参数：

{
    "DataChart9[]": [
        {
            "user_id": "1",
            "name": "博士",
            "value": 500,
            "create_time": "2020-09-03 11:30:41",
            "update_time": "2020-09-03 11:30:42"
        },
        {
            "user_id": "1",
            "name": "硕士",
            "value": 50,
            "create_time": "2020-09-03 11:30:41",
            "update_time": "2020-09-03 11:30:42"
        }
    ],
    "tag": "DataChart9"
}

修改接口地址：

http://pai.flyrise.cn/data-manager-api/data/put

请求参数：

{
    "DataChart9[]": [
        {
            "id": 1,
            "user_id": "1",
            "name": "博士",
            "value": 500,
            "create_time": "2020-09-03 11:30:41",
            "update_time": "2020-09-03 11:30:42"
        },
        {
            "id": 2,
            "user_id": "1",
            "name": "硕士",
            "value": 50,
            "create_time": "2020-09-03 11:30:41",
            "update_time": "2020-09-03 11:30:42"
        }
    ],
    "tag": "DataChart9"
}

删除接口地址：

http://pai.flyrise.cn/data-manager-api/data/delete

请求参数：

{
    "DataChart9": {
        "id{}": [10,11]
    },
    "tag": "DataChart9"
}

图表10：仪表指数

查询接口地址：

http://pai.flyrise.cn/data-manager-api/data/get

请求参数：

{
    "DataChart10[]": {
        "page": 0,
        "count": 1,
        "DataChart10": {
            "user_id": 1,
            "@column": "id,name,value",
            "@order": "id+"
        }
    }
}

返回数据：

{
    "DataChart10[]": [
        {
            "name": "温度",
            "value": "39.8"
        }
    ],
    "ok": true,
    "code": 200,
    "msg": "success",
    "sql:generate|cache|execute|maxExecute": "2|1|1|200",
    "depth:count|max": "3|5",
    "time:start|duration|end": "1599120365304|202|1599120365506"
}

新增接口地址：

http://pai.flyrise.cn/data-manager-api/data/post

请求参数：

{
    "DataChart10[]": [
        {
            "user_id": "1",
            "name": "温度",
            "value": "39.8",
            "create_time": "2020-09-03 11:35:28",
            "update_time": "2020-09-03 11:35:29"
        }
    ],
    "tag": "DataChart10"
}

修改接口地址：

http://pai.flyrise.cn/data-manager-api/data/put

请求参数：

{
    "DataChart10[]": [
        {
            "id": 1,
            "user_id": "1",
            "name": "温度",
            "value": "39.8",
            "create_time": "2020-09-03 11:35:28",
            "update_time": "2020-09-03 11:35:29"
        }
    ],
    "tag": "DataChart10"
}

删除接口地址：

http://pai.flyrise.cn/data-manager-api/data/delete

请求参数：

{
    "DataChart10": {
        "id{}": [10,11]
    },
    "tag": "DataChart10"
}

图表11：散点图分析

查询接口地址：

http://pai.flyrise.cn/data-manager-api/data/get

请求参数：

{
    "DataChart11[]": {
        "page": 0,
        "count": 10,
        "DataChart11": {
            "user_id": 1,
            "@column": "id,name,value_x,value_y,value",
            "@order": "id+"
        }
    }
}

返回数据：


{
    "DataChart11[]": [
        {
            "name": "南方软件园",
            "value_x": "10",
            "value_y": "20",
            "value": "50"
        },
        {
            "name": "清华园",
            "value_x": "8",
            "value_y": "20",
            "value": "250"
        },
        {
            "name": "大洲科技园",
            "value_x": "10",
            "value_y": "10",
            "value": "150"
        },
        {
            "name": "格力园区",
            "value_x": "5",
            "value_y": "5",
            "value": "500"
        }
    ],
    "ok": true,
    "code": 200,
    "msg": "success",
    "sql:generate|cache|execute|maxExecute": "5|4|1|200",
    "depth:count|max": "3|5",
    "time:start|duration|end": "1599120556465|179|1599120556644"
}

新增接口地址：

http://pai.flyrise.cn/data-manager-api/data/post

请求参数：

{
    "DataChart11[]": [
        {
            "user_id": "1",
            "name": "南方软件园",
            "value_x": "12",
            "value_y": "2000",
            "value": "5",
            "create_time": "2020-09-03 11:44:46",
            "update_time": "2020-09-03 11:44:47"
        },
        {
            "user_id": "1",
            "name": "清华园",
            "value_x": "12",
            "value_y": "2000",
            "value": "2.5",
            "create_time": "2020-09-03 11:44:46",
            "update_time": "2020-09-03 11:44:47"
        }
    ],
    "tag": "DataChart11"
}

修改接口地址：

http://pai.flyrise.cn/data-manager-api/data/put

请求参数：

{
    "DataChart11[]": [
        {
            "id": 1,
            "user_id": "1",
            "name": "南方软件园",
            "value_x": "12",
            "value_y": "2000",
            "value": "5",
            "create_time": "2020-09-03 11:44:46",
            "update_time": "2020-09-03 11:44:47"
        },
        {
            "id": 2,
            "user_id": "1",
            "name": "清华园",
            "value_x": "12",
            "value_y": "2000",
            "value": "2.5",
            "create_time": "2020-09-03 11:44:46",
            "update_time": "2020-09-03 11:44:47"
        }
    ],
    "tag": "DataChart11"
}

删除接口地址：

http://pai.flyrise.cn/data-manager-api/data/delete

请求参数：

{
    "DataChart11": {
        "id{}": [10,11]
    },
    "tag": "DataChart11"
}

新增表reload接口

接口地址：http://pai.flyrise.cn/data-manager-api/data/reload

请求参数：

{
    "type": "ACCESS" 
}

返回数据：

{
    "ok": true,
    "code": 200,
    "msg": "success",
    "Access": {
        "Access[]": [
            {
                "id": 1,
                "debug": 0,
                "name": "Access",
                "alias": null,
                "get": "[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]",
                "head": "[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]",
                "gets": "[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]",
                "heads": "[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]",
                "post": "[\"UNKNOWN\"]",
                "put": "[\"UNKNOWN\"]",
                "delete": "[\"UNKNOWN\"]",
                "date": "2019-07-21 20:21:36.0"
            },
            {
                "id": 4,
                "debug": 0,
                "name": "Function",
                "alias": null,
                "get": "[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]",
                "head": "[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]",
                "gets": "[\"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]",
                "heads": "[\"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]",
                "post": "[]",
                "put": "[]",
                "delete": "[]",
                "date": "2018-11-29 00:38:15.0"
            },
            {
                "id": 5,
                "debug": 0,
                "name": "Request",
                "alias": null,
                "get": "[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]",
                "head": "[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]",
                "gets": "[\"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]",
                "heads": "[\"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]",
                "post": "[]",
                "put": "[]",
                "delete": "[]",
                "date": "2018-11-29 00:38:14.0"
            },
            {
                "id": 12,
                "debug": 0,
                "name": "Login",
                "alias": null,
                "get": "[]",
                "head": "[]",
                "gets": "[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]",
                "heads": "[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]",
                "post": "[ \"ADMIN\"]",
                "put": "[ \"ADMIN\"]",
                "delete": "[\"ADMIN\"]",
                "date": "2018-11-29 00:29:48.0"
            },
            {
                "id": 13,
                "debug": 0,
                "name": "Verify",
                "alias": null,
                "get": "[]",
                "head": "[]",
                "gets": "[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]",
                "heads": "[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]",
                "post": "[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]",
                "put": "[ \"ADMIN\"]",
                "delete": "[\"ADMIN\"]",
                "date": "2018-11-29 00:29:48.0"
            },
            {
                "id": 14,
                "debug": 0,
                "name": "apijson_user",
                "alias": "User",
                "get": "[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]",
                "head": "[\"UNKNOWN\", \"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]",
                "gets": "[\"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]",
                "heads": "[\"LOGIN\", \"CONTACT\", \"CIRCLE\", \"OWNER\", \"ADMIN\"]",
                "post": "[\"UNKNOWN\",\"LOGIN\",\"OWNER\", \"ADMIN\"]",
                "put": "[\"OWNER\", \"ADMIN\"]",
                "delete": "[\"ADMIN\"]",
                "date": "2018-11-29 00:28:53.0"
            },
            {
                "id": 15,
                "debug": 0,
                "name": "apijson_privacy",
                "alias": "Privacy",
                "get": "[]",
                "head": "[]",
                "gets": "[\"OWNER\", \"ADMIN\"]",
                "heads": "[\"OWNER\", \"ADMIN\"]",
                "post": "[\"UNKNOWN\",\"LOGIN\",\"OWNER\", \"ADMIN\"]",
                "put": "[\"OWNER\", \"ADMIN\"]",
                "delete": "[\"ADMIN\"]",
                "date": "2018-11-29 00:29:48.0"
            },
            {
                "id": 26,
                "debug": 0,
                "name": "data_topic",
                "alias": "DataTopic",
                "get": "[\"UNKNOWN\"]",
                "head": "[\"UNKNOWN\"]",
                "gets": "[\"UNKNOWN\"]",
                "heads": "[\"UNKNOWN\"]",
                "post": "[\"UNKNOWN\"]",
                "put": "[\"UNKNOWN\"]",
                "delete": "[\"UNKNOWN\"]",
                "date": "2020-09-03 15:09:41.0"
            },
            {
                "id": 27,
                "debug": 0,
                "name": "data_topic_chart",
                "alias": "DataTopicChart",
                "get": "[\"UNKNOWN\"]",
                "head": "[\"UNKNOWN\"]",
                "gets": "[\"UNKNOWN\"]",
                "heads": "[\"UNKNOWN\"]",
                "post": "[\"UNKNOWN\"]",
                "put": "[\"UNKNOWN\"]",
                "delete": "[\"UNKNOWN\"]",
                "date": "2020-09-03 15:09:41.0"
            },
            {
                "id": 28,
                "debug": 0,
                "name": "data_chart_1",
                "alias": "DataChart1",
                "get": "[\"UNKNOWN\"]",
                "head": "[\"UNKNOWN\"]",
                "gets": "[\"UNKNOWN\"]",
                "heads": "[\"UNKNOWN\"]",
                "post": "[\"UNKNOWN\"]",
                "put": "[\"UNKNOWN\"]",
                "delete": "[\"UNKNOWN\"]",
                "date": "2020-09-03 15:11:55.0"
            },
            {
                "id": 29,
                "debug": 0,
                "name": "data_chart_2",
                "alias": "DataChart2",
                "get": "[\"UNKNOWN\"]",
                "head": "[\"UNKNOWN\"]",
                "gets": "[\"UNKNOWN\"]",
                "heads": "[\"UNKNOWN\"]",
                "post": "[\"UNKNOWN\"]",
                "put": "[\"UNKNOWN\"]",
                "delete": "[\"UNKNOWN\"]",
                "date": "2020-09-03 15:11:55.0"
            },
            {
                "id": 30,
                "debug": 0,
                "name": "data_chart_3",
                "alias": "DataChart3",
                "get": "[\"UNKNOWN\"]",
                "head": "[\"UNKNOWN\"]",
                "gets": "[\"UNKNOWN\"]",
                "heads": "[\"UNKNOWN\"]",
                "post": "[\"UNKNOWN\"]",
                "put": "[\"UNKNOWN\"]",
                "delete": "[\"UNKNOWN\"]",
                "date": "2020-09-03 15:11:55.0"
            },
            {
                "id": 31,
                "debug": 0,
                "name": "data_chart_4",
                "alias": "DataChart4",
                "get": "[\"UNKNOWN\"]",
                "head": "[\"UNKNOWN\"]",
                "gets": "[\"UNKNOWN\"]",
                "heads": "[\"UNKNOWN\"]",
                "post": "[\"UNKNOWN\"]",
                "put": "[\"UNKNOWN\"]",
                "delete": "[\"UNKNOWN\"]",
                "date": "2020-09-03 15:11:55.0"
            },
            {
                "id": 32,
                "debug": 0,
                "name": "data_chart_5",
                "alias": "DataChart5",
                "get": "[\"UNKNOWN\"]",
                "head": "[\"UNKNOWN\"]",
                "gets": "[\"UNKNOWN\"]",
                "heads": "[\"UNKNOWN\"]",
                "post": "[\"UNKNOWN\"]",
                "put": "[\"UNKNOWN\"]",
                "delete": "[\"UNKNOWN\"]",
                "date": "2020-09-03 15:11:55.0"
            },
            {
                "id": 33,
                "debug": 0,
                "name": "data_chart_6",
                "alias": "DataChart6",
                "get": "[\"UNKNOWN\"]",
                "head": "[\"UNKNOWN\"]",
                "gets": "[\"UNKNOWN\"]",
                "heads": "[\"UNKNOWN\"]",
                "post": "[\"UNKNOWN\"]",
                "put": "[\"UNKNOWN\"]",
                "delete": "[\"UNKNOWN\"]",
                "date": "2020-09-03 15:11:55.0"
            },
            {
                "id": 34,
                "debug": 0,
                "name": "data_chart_7",
                "alias": "DataChart7",
                "get": "[\"UNKNOWN\"]",
                "head": "[\"UNKNOWN\"]",
                "gets": "[\"UNKNOWN\"]",
                "heads": "[\"UNKNOWN\"]",
                "post": "[\"UNKNOWN\"]",
                "put": "[\"UNKNOWN\"]",
                "delete": "[\"UNKNOWN\"]",
                "date": "2020-09-03 15:11:55.0"
            },
            {
                "id": 35,
                "debug": 0,
                "name": "data_chart_8",
                "alias": "DataChart8",
                "get": "[\"UNKNOWN\"]",
                "head": "[\"UNKNOWN\"]",
                "gets": "[\"UNKNOWN\"]",
                "heads": "[\"UNKNOWN\"]",
                "post": "[\"UNKNOWN\"]",
                "put": "[\"UNKNOWN\"]",
                "delete": "[\"UNKNOWN\"]",
                "date": "2020-09-03 15:11:56.0"
            },
            {
                "id": 36,
                "debug": 0,
                "name": "data_chart_9",
                "alias": "DataChart9",
                "get": "[\"UNKNOWN\"]",
                "head": "[\"UNKNOWN\"]",
                "gets": "[\"UNKNOWN\"]",
                "heads": "[\"UNKNOWN\"]",
                "post": "[\"UNKNOWN\"]",
                "put": "[\"UNKNOWN\"]",
                "delete": "[\"UNKNOWN\"]",
                "date": "2020-09-03 15:11:56.0"
            },
            {
                "id": 37,
                "debug": 0,
                "name": "data_chart_10",
                "alias": "DataChart10",
                "get": "[\"UNKNOWN\"]",
                "head": "[\"UNKNOWN\"]",
                "gets": "[\"UNKNOWN\"]",
                "heads": "[\"UNKNOWN\"]",
                "post": "[\"UNKNOWN\"]",
                "put": "[\"UNKNOWN\"]",
                "delete": "[\"UNKNOWN\"]",
                "date": "2020-09-03 15:11:56.0"
            },
            {
                "id": 38,
                "debug": 0,
                "name": "data_chart_11",
                "alias": "DataChart11",
                "get": "[\"UNKNOWN\"]",
                "head": "[\"UNKNOWN\"]",
                "gets": "[\"UNKNOWN\"]",
                "heads": "[\"UNKNOWN\"]",
                "post": "[\"UNKNOWN\"]",
                "put": "[\"UNKNOWN\"]",
                "delete": "[\"UNKNOWN\"]",
                "date": "2020-09-03 15:11:56.0"
            },
            {
                "id": 39,
                "debug": 0,
                "name": "data_chart_12",
                "alias": "DataChart12",
                "get": "[\"UNKNOWN\"]",
                "head": "[\"UNKNOWN\"]",
                "gets": "[\"UNKNOWN\"]",
                "heads": "[\"UNKNOWN\"]",
                "post": "[\"UNKNOWN\"]",
                "put": "[\"UNKNOWN\"]",
                "delete": "[\"UNKNOWN\"]",
                "date": "2020-09-03 15:11:56.0"
            }
        ],
        "ok": true,
        "code": 200,
        "msg": "success",
        "sql:generate|cache|execute|maxExecute": "22|21|1|200",
        "depth:count|max": "3|5",
        "time:start|duration|end": "1599269011863|66|1599269011929"
    }
}

初始化数据库表

-- --------------------------------------------------------
-- 主机:                           8.129.13.162
-- 服务器版本:                        5.7.29-log - Source distribution
-- 服务器操作系统:                      Linux
-- HeidiSQL 版本:                  11.0.0.5919
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


-- 导出  表 pai-data-manager.Access 结构
CREATE TABLE IF NOT EXISTS `Access` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `debug` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否为调试表，只允许在开发环境使用，测试和线上环境禁用',
  `name` varchar(50) NOT NULL COMMENT '实际表名，例如 apijson_user',
  `alias` varchar(20) DEFAULT NULL COMMENT '外部调用的表别名，例如 User',
  `get` varchar(100) NOT NULL DEFAULT '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]' COMMENT '允许 get 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]\n用 JSON 类型不能设置默认值，反正权限对应的需求是明确的，也不需要自动转 JSONArray。\nTODO: 直接 LOGIN,CONTACT,CIRCLE,OWNER 更简单，反正是开发内部用，不需要复杂查询。',
  `head` varchar(100) NOT NULL DEFAULT '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]' COMMENT '允许 head 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]',
  `gets` varchar(100) NOT NULL DEFAULT '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]' COMMENT '允许 gets 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]',
  `heads` varchar(100) NOT NULL DEFAULT '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]' COMMENT '允许 heads 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]',
  `post` varchar(100) NOT NULL DEFAULT '["OWNER", "ADMIN"]' COMMENT '允许 post 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]',
  `put` varchar(100) NOT NULL DEFAULT '["OWNER", "ADMIN"]' COMMENT '允许 put 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]',
  `delete` varchar(100) NOT NULL DEFAULT '["OWNER", "ADMIN"]' COMMENT '允许 delete 的角色列表，例如 ["LOGIN", "CONTACT", "CIRCLE", "OWNER"]',
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_UNIQUE` (`name`),
  UNIQUE KEY `alias_UNIQUE` (`alias`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COMMENT='权限配置';

-- 正在导出表  pai-data-manager.Access 的数据：~21 rows (大约)
/*!40000 ALTER TABLE `Access` DISABLE KEYS */;
INSERT INTO `Access` (`id`, `debug`, `name`, `alias`, `get`, `head`, `gets`, `heads`, `post`, `put`, `delete`, `date`) VALUES
    (1, 0, 'Access', NULL, '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '[]', '[]', '[]', '2019-07-21 20:21:36'),
    (4, 0, 'Function', NULL, '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '[]', '[]', '[]', '2018-11-29 00:38:15'),
    (5, 0, 'Request', NULL, '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '[]', '[]', '[]', '2018-11-29 00:38:14'),
    (12, 0, 'Login', NULL, '[]', '[]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '[ "ADMIN"]', '[ "ADMIN"]', '["ADMIN"]', '2018-11-29 00:29:48'),
    (13, 0, 'Verify', NULL, '[]', '[]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '[ "ADMIN"]', '["ADMIN"]', '2018-11-29 00:29:48'),
    (14, 0, 'apijson_user', 'User', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN","LOGIN","OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '["ADMIN"]', '2018-11-29 00:28:53'),
    (15, 0, 'apijson_privacy', 'Privacy', '[]', '[]', '["OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '["UNKNOWN","LOGIN","OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '["ADMIN"]', '2018-11-29 00:29:48'),
    (26, 0, 'data_topic', 'DataTopic', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '2020-09-03 15:09:41'),
    (27, 0, 'data_topic_chart', 'DataTopicChart', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '2020-09-03 15:09:41'),
    (28, 0, 'data_chart_1', 'DataChart1', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '2020-09-03 15:11:55'),
    (29, 0, 'data_chart_2', 'DataChart2', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '2020-09-03 15:11:55'),
    (30, 0, 'data_chart_3', 'DataChart3', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '2020-09-03 15:11:55'),
    (31, 0, 'data_chart_4', 'DataChart4', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '2020-09-03 15:11:55'),
    (32, 0, 'data_chart_5', 'DataChart5', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '2020-09-03 15:11:55'),
    (33, 0, 'data_chart_6', 'DataChart6', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '2020-09-03 15:11:55'),
    (34, 0, 'data_chart_7', 'DataChart7', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '2020-09-03 15:11:55'),
    (35, 0, 'data_chart_8', 'DataChart8', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '2020-09-03 15:11:56'),
    (36, 0, 'data_chart_9', 'DataChart9', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '2020-09-03 15:11:56'),
    (37, 0, 'data_chart_10', 'DataChart10', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '2020-09-03 15:11:56'),
    (38, 0, 'data_chart_11', 'DataChart11', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '["UNKNOWN"]', '2020-09-03 15:11:56');
/*!40000 ALTER TABLE `Access` ENABLE KEYS */;

-- 导出  表 pai-data-manager.apijson_privacy 结构
CREATE TABLE IF NOT EXISTS `apijson_privacy` (
  `id` bigint(20) NOT NULL COMMENT '唯一标识',
  `certified` tinyint(4) NOT NULL DEFAULT '0' COMMENT '已认证',
  `phone` bigint(20) NOT NULL COMMENT '手机号，仅支持 11 位数的。不支持 +86 这种国家地区开头的。如果要支持就改为 VARCHAR(14)',
  `balance` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '余额',
  `__password` varchar(20) NOT NULL COMMENT '登录密码',
  `__payPassword` int(11) NOT NULL DEFAULT '123456' COMMENT '支付密码',
  PRIMARY KEY (`id`),
  UNIQUE KEY `phone_UNIQUE` (`phone`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户隐私信息表。\n对安全要求高，不想泄漏真实名称。对外名称为 Privacy';

-- 正在导出表  pai-data-manager.apijson_privacy 的数据：~2 rows (大约)
/*!40000 ALTER TABLE `apijson_privacy` DISABLE KEYS */;
INSERT INTO `apijson_privacy` (`id`, `certified`, `phone`, `balance`, `__password`, `__payPassword`) VALUES
    (38710, 1, 13000038710, 33376.00, '666666', 123456),
    (70793, 0, 13000070793, 56000.00, 'apijson', 123456);
/*!40000 ALTER TABLE `apijson_privacy` ENABLE KEYS */;

-- 导出  表 pai-data-manager.apijson_user 结构
CREATE TABLE IF NOT EXISTS `apijson_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一标识',
  `sex` tinyint(4) NOT NULL DEFAULT '0' COMMENT '性别：\n0-男\n1-女',
  `name` varchar(20) DEFAULT NULL COMMENT '名称',
  `tag` varchar(45) DEFAULT NULL COMMENT '标签',
  `head` varchar(300) DEFAULT 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png' COMMENT '头像url',
  `contactIdList` json DEFAULT NULL COMMENT '联系人id列表',
  `pictureList` json DEFAULT NULL COMMENT '照片列表',
  `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=70794 DEFAULT CHARSET=utf8 COMMENT='用户公开信息表。\n对安全要求高，不想泄漏真实名称。对外名称为 User';

-- 正在导出表  pai-data-manager.apijson_user 的数据：~2 rows (大约)
/*!40000 ALTER TABLE `apijson_user` DISABLE KEYS */;
INSERT INTO `apijson_user` (`id`, `sex`, `name`, `tag`, `head`, `contactIdList`, `pictureList`, `date`) VALUES
    (38710, 0, 'TommyLemon', 'Android&Java', 'http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000', '[82003, 82005, 90814, 82004, 82009, 82002, 82044, 93793, 70793]', '["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]', '2017-02-01 19:21:50'),
    (70793, 0, 'Strong', 'djdj', 'http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000', '[38710, 82002]', '["http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg", "http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg", "https://camo.githubusercontent.com/788c0a7e11a", "https://camo.githubusercontent.com/f513f67"]', '2017-02-01 19:21:50');
/*!40000 ALTER TABLE `apijson_user` ENABLE KEYS */;

-- 导出  表 pai-data-manager.data_chart_1 结构
CREATE TABLE IF NOT EXISTS `data_chart_1` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_id` varchar(1024) NOT NULL COMMENT '开发者id',
  `name` varchar(128) NOT NULL COMMENT '统计名称',
  `rate` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '昨日增长率',
  `value` int(11) NOT NULL DEFAULT '0' COMMENT '数量',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='数据图表1：访问数';

-- 正在导出表  pai-data-manager.data_chart_1 的数据：~5 rows (大约)
/*!40000 ALTER TABLE `data_chart_1` DISABLE KEYS */;
INSERT INTO `data_chart_1` (`id`, `user_id`, `name`, `rate`, `value`, `create_time`, `update_time`) VALUES
    (1, '1', '新增用户', 20.00, 3, '2020-09-02 20:01:11', '2020-09-02 20:01:13'),
    (2, '1', '新增账户', 100.00, 2, '2020-09-02 20:01:41', '2020-09-02 20:01:42'),
    (3, '1', '活跃账户', 0.00, 0, '2020-09-02 20:02:13', '2020-09-02 20:02:15'),
    (4, '1', '启动次数', 50.00, 100, '2020-09-02 20:02:37', '2020-09-02 20:02:40'),
    (5, '1', '页面访问数', 50.00, 200, '2020-09-02 20:04:20', '2020-09-02 20:04:21');
/*!40000 ALTER TABLE `data_chart_1` ENABLE KEYS */;

-- 导出  表 pai-data-manager.data_chart_10 结构
CREATE TABLE IF NOT EXISTS `data_chart_10` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(1024) NOT NULL DEFAULT '0' COMMENT '开发者id',
  `name` varchar(128) NOT NULL DEFAULT '0' COMMENT '名称',
  `value` varchar(128) NOT NULL DEFAULT '0' COMMENT '值',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='图表10：仪表指数';

-- 正在导出表  pai-data-manager.data_chart_10 的数据：~0 rows (大约)
/*!40000 ALTER TABLE `data_chart_10` DISABLE KEYS */;
INSERT INTO `data_chart_10` (`id`, `user_id`, `name`, `value`, `create_time`, `update_time`) VALUES
    (1, '1', '温度', '39.8', '2020-09-03 11:35:28', '2020-09-03 11:35:29');
/*!40000 ALTER TABLE `data_chart_10` ENABLE KEYS */;

-- 导出  表 pai-data-manager.data_chart_11 结构
CREATE TABLE IF NOT EXISTS `data_chart_11` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(1024) NOT NULL DEFAULT '0' COMMENT '开发者id',
  `name` varchar(1024) NOT NULL DEFAULT '0' COMMENT '名称',
  `value_x` varchar(1024) NOT NULL DEFAULT '0' COMMENT 'x轴值',
  `value_y` varchar(1024) NOT NULL DEFAULT '0' COMMENT 'y轴值',
  `value` varchar(1024) NOT NULL DEFAULT '0' COMMENT '值',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='图表11：散点图分析';

-- 正在导出表  pai-data-manager.data_chart_11 的数据：~4 rows (大约)
/*!40000 ALTER TABLE `data_chart_11` DISABLE KEYS */;
INSERT INTO `data_chart_11` (`id`, `user_id`, `name`, `value_x`, `value_y`, `value`, `create_time`, `update_time`) VALUES
    (1, '1', '南方软件园', '10', '20', '50', '2020-09-03 11:44:46', '2020-09-03 11:44:47'),
    (2, '1', '清华园', '8', '20', '250', '2020-09-03 11:44:46', '2020-09-03 11:44:47'),
    (3, '1', '大洲科技园', '10', '10', '150', '2020-09-03 11:44:46', '2020-09-03 11:44:47'),
    (4, '1', '格力园区', '5', '5', '500', '2020-09-03 11:44:46', '2020-09-03 11:44:47');
/*!40000 ALTER TABLE `data_chart_11` ENABLE KEYS */;

-- 导出  表 pai-data-manager.data_chart_2 结构
CREATE TABLE IF NOT EXISTS `data_chart_2` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(1024) NOT NULL DEFAULT '0' COMMENT '开发者id',
  `date_hour` datetime NOT NULL COMMENT '小时',
  `value` int(11) NOT NULL DEFAULT '0' COMMENT '访问数',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COMMENT='图表2：分时走势图';

-- 正在导出表  pai-data-manager.data_chart_2 的数据：~24 rows (大约)
/*!40000 ALTER TABLE `data_chart_2` DISABLE KEYS */;
INSERT INTO `data_chart_2` (`id`, `user_id`, `date_hour`, `value`, `create_time`, `update_time`) VALUES
    (1, '1', '2020-09-02 00:00:00', 0, '2020-09-02 20:06:39', '2020-09-02 20:06:40'),
    (2, '1', '2020-09-02 01:00:00', 0, '2020-09-02 20:06:39', '2020-09-02 20:06:40'),
    (3, '1', '2020-09-02 02:00:00', 0, '2020-09-02 20:06:39', '2020-09-02 20:06:40'),
    (4, '1', '2020-09-02 03:00:00', 0, '2020-09-02 20:06:39', '2020-09-02 20:06:40'),
    (5, '1', '2020-09-02 04:00:00', 0, '2020-09-02 20:06:39', '2020-09-02 20:06:40'),
    (6, '1', '2020-09-02 05:00:00', 0, '2020-09-02 20:06:39', '2020-09-02 20:06:40'),
    (7, '1', '2020-09-02 06:00:00', 0, '2020-09-02 20:06:39', '2020-09-02 20:06:40'),
    (8, '1', '2020-09-02 07:00:00', 0, '2020-09-02 20:06:39', '2020-09-02 20:06:40'),
    (9, '1', '2020-09-02 08:00:00', 10, '2020-09-02 20:06:39', '2020-09-02 20:06:40'),
    (10, '1', '2020-09-02 09:00:00', 0, '2020-09-02 20:06:39', '2020-09-02 20:06:40'),
    (11, '1', '2020-09-02 10:00:00', 0, '2020-09-02 20:06:39', '2020-09-02 20:06:40'),
    (12, '1', '2020-09-02 11:00:00', 20, '2020-09-02 20:06:39', '2020-09-02 20:06:40'),
    (13, '1', '2020-09-02 12:00:00', 100, '2020-09-02 20:06:39', '2020-09-02 20:06:40'),
    (14, '1', '2020-09-02 13:00:00', 0, '2020-09-02 20:06:39', '2020-09-02 20:06:40'),
    (15, '1', '2020-09-02 14:00:00', 5, '2020-09-02 20:06:39', '2020-09-02 20:06:40'),
    (16, '1', '2020-09-02 15:00:00', 0, '2020-09-02 20:06:39', '2020-09-02 20:06:40'),
    (17, '1', '2020-09-02 16:00:00', 1, '2020-09-02 20:06:39', '2020-09-02 20:06:40'),
    (18, '1', '2020-09-02 17:00:00', 0, '2020-09-02 20:06:39', '2020-09-02 20:06:40'),
    (19, '1', '2020-09-02 18:00:00', 0, '2020-09-02 20:06:39', '2020-09-02 20:06:40'),
    (20, '1', '2020-09-02 19:00:00', 30, '2020-09-02 20:06:39', '2020-09-02 20:06:40'),
    (21, '1', '2020-09-02 20:00:00', 120, '2020-09-02 20:06:39', '2020-09-02 20:06:40'),
    (22, '1', '2020-09-02 21:00:00', 0, '2020-09-02 20:06:39', '2020-09-02 20:06:40'),
    (23, '1', '2020-09-02 22:00:00', 20, '2020-09-02 20:06:39', '2020-09-02 20:06:40'),
    (24, '1', '2020-09-02 23:00:00', 0, '2020-09-02 20:06:39', '2020-09-02 20:06:40');
/*!40000 ALTER TABLE `data_chart_2` ENABLE KEYS */;

-- 导出  表 pai-data-manager.data_chart_3 结构
CREATE TABLE IF NOT EXISTS `data_chart_3` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(1024) NOT NULL DEFAULT '0' COMMENT '开发者id',
  `date` date NOT NULL COMMENT '日期',
  `value` int(11) NOT NULL DEFAULT '0' COMMENT '留存数',
  `value_day_1` int(11) DEFAULT '0' COMMENT '1日留存数',
  `value_day_2` int(11) DEFAULT '0' COMMENT '2日留存数',
  `value_day_3` int(11) DEFAULT '0' COMMENT '3日留存数',
  `value_day_4` int(11) DEFAULT '0' COMMENT '4日留存数',
  `value_day_5` int(11) DEFAULT '0' COMMENT '5日留存数',
  `value_day_6` int(11) DEFAULT '0' COMMENT '6日留存数',
  `value_day_7` int(11) DEFAULT '0' COMMENT '7日留存数',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COMMENT='图表3：7日留存分析';

-- 正在导出表  pai-data-manager.data_chart_3 的数据：~7 rows (大约)
/*!40000 ALTER TABLE `data_chart_3` DISABLE KEYS */;
INSERT INTO `data_chart_3` (`id`, `user_id`, `date`, `value`, `value_day_1`, `value_day_2`, `value_day_3`, `value_day_4`, `value_day_5`, `value_day_6`, `value_day_7`, `create_time`, `update_time`) VALUES
    (1, '1', '2020-08-24', 100, 50, 60, 80, 10, 15, 0, 60, '2020-09-03 10:50:58', '2020-09-03 10:51:03'),
    (2, '1', '2020-08-25', 100, 50, 60, 80, 10, 15, 10, 0, '2020-09-03 10:50:58', '2020-09-03 10:51:03'),
    (3, '1', '2020-08-26', 100, 50, 60, 80, 10, 10, 0, 0, '2020-09-03 10:50:58', '2020-09-03 10:51:03'),
    (4, '1', '2020-08-27', 100, 50, 60, 80, 20, 0, 0, 0, '2020-09-03 10:50:58', '2020-09-03 10:51:03'),
    (5, '1', '2020-08-28', 100, 50, 60, 30, 0, 0, 0, 0, '2020-09-03 10:50:58', '2020-09-03 10:51:03'),
    (6, '1', '2020-08-29', 100, 50, 10, 0, 0, 0, 0, 0, '2020-09-03 10:50:58', '2020-09-03 10:51:03'),
    (7, '1', '2020-08-30', 100, 50, 0, 0, 0, 0, 0, 0, '2020-09-03 10:50:58', '2020-09-03 10:51:03');
/*!40000 ALTER TABLE `data_chart_3` ENABLE KEYS */;

-- 导出  表 pai-data-manager.data_chart_4 结构
CREATE TABLE IF NOT EXISTS `data_chart_4` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(1024) NOT NULL DEFAULT '0' COMMENT '开发者id',
  `word` varchar(128) NOT NULL DEFAULT '0' COMMENT '词',
  `count` int(11) NOT NULL DEFAULT '0' COMMENT '数量',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COMMENT='图表4：词云';

-- 正在导出表  pai-data-manager.data_chart_4 的数据：~8 rows (大约)
/*!40000 ALTER TABLE `data_chart_4` DISABLE KEYS */;
INSERT INTO `data_chart_4` (`id`, `user_id`, `word`, `count`, `create_time`, `update_time`) VALUES
    (1, '1', 'AI', 1000, '2020-09-03 11:00:23', '2020-09-03 11:00:24'),
    (2, '1', '大数据', 900, '2020-09-03 11:00:23', '2020-09-03 11:00:24'),
    (3, '1', '云计算', 800, '2020-09-03 11:00:23', '2020-09-03 11:00:24'),
    (4, '1', '数据中台', 700, '2020-09-03 11:00:23', '2020-09-03 11:00:24'),
    (5, '1', '业务中台', 500, '2020-09-03 11:00:23', '2020-09-03 11:00:24'),
    (6, '1', '技术平台', 300, '2020-09-03 11:00:23', '2020-09-03 11:00:24'),
    (7, '1', '5G', 100, '2020-09-03 11:00:23', '2020-09-03 11:00:24'),
    (8, '1', 'IOT', 200, '2020-09-03 11:00:23', '2020-09-03 11:00:24');
/*!40000 ALTER TABLE `data_chart_4` ENABLE KEYS */;

-- 导出  表 pai-data-manager.data_chart_5 结构
CREATE TABLE IF NOT EXISTS `data_chart_5` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(1024) NOT NULL DEFAULT '0' COMMENT '开发者id',
  `name` varchar(128) NOT NULL DEFAULT '0' COMMENT '名称',
  `value` int(11) NOT NULL DEFAULT '0' COMMENT '数量',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COMMENT='图表5：页面访问排行';

-- 正在导出表  pai-data-manager.data_chart_5 的数据：~7 rows (大约)
/*!40000 ALTER TABLE `data_chart_5` DISABLE KEYS */;
INSERT INTO `data_chart_5` (`id`, `user_id`, `name`, `value`, `create_time`, `update_time`) VALUES
    (1, '1', '主页', 100, '2020-09-03 11:04:36', '2020-09-03 11:04:37'),
    (2, '1', '登录页', 90, '2020-09-03 11:04:36', '2020-09-03 11:04:37'),
    (3, '1', '支付页', 80, '2020-09-03 11:04:36', '2020-09-03 11:04:37'),
    (4, '1', '广场活动页', 50, '2020-09-03 11:04:36', '2020-09-03 11:04:37'),
    (5, '1', '投票活动页', 20, '2020-09-03 11:04:36', '2020-09-03 11:04:37'),
    (6, '1', '车广告页', 10, '2020-09-03 11:04:36', '2020-09-03 11:04:37'),
    (7, '1', '优惠页', 3, '2020-09-03 11:04:36', '2020-09-03 11:04:37');
/*!40000 ALTER TABLE `data_chart_5` ENABLE KEYS */;

-- 导出  表 pai-data-manager.data_chart_6 结构
CREATE TABLE IF NOT EXISTS `data_chart_6` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(1024) NOT NULL DEFAULT '0' COMMENT '开发者id',
  `name` varchar(128) NOT NULL DEFAULT '0' COMMENT '名称',
  `value` int(11) NOT NULL DEFAULT '0' COMMENT '数量',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COMMENT='图表6：用户访问数排行';

-- 正在导出表  pai-data-manager.data_chart_6 的数据：~10 rows (大约)
/*!40000 ALTER TABLE `data_chart_6` DISABLE KEYS */;
INSERT INTO `data_chart_6` (`id`, `user_id`, `name`, `value`, `create_time`, `update_time`) VALUES
    (1, '1', '张三', 100, '2020-09-03 11:09:27', '2020-09-03 11:09:28'),
    (2, '1', '李四', 90, '2020-09-03 11:09:27', '2020-09-03 11:09:28'),
    (3, '1', '王五', 80, '2020-09-03 11:09:27', '2020-09-03 11:09:28'),
    (4, '1', '孙六', 70, '2020-09-03 11:09:27', '2020-09-03 11:09:28'),
    (5, '1', '赵七', 68, '2020-09-03 11:09:27', '2020-09-03 11:09:28'),
    (6, '1', '公孙八', 55, '2020-09-03 11:09:27', '2020-09-03 11:09:28'),
    (7, '1', '九九', 40, '2020-09-03 11:09:27', '2020-09-03 11:09:28'),
    (8, '1', '十十', 31, '2020-09-03 11:09:27', '2020-09-03 11:09:28'),
    (9, '1', '十一', 22, '2020-09-03 11:09:27', '2020-09-03 11:09:28'),
    (10, '1', '十二', 6, '2020-09-03 11:09:27', '2020-09-03 11:09:28');
/*!40000 ALTER TABLE `data_chart_6` ENABLE KEYS */;

-- 导出  表 pai-data-manager.data_chart_7 结构
CREATE TABLE IF NOT EXISTS `data_chart_7` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(1024) NOT NULL DEFAULT '0' COMMENT '开发者id',
  `name` varchar(128) NOT NULL DEFAULT '0' COMMENT '名称',
  `value` int(11) NOT NULL DEFAULT '0' COMMENT '数量',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='图表7：漏斗分析';

-- 正在导出表  pai-data-manager.data_chart_7 的数据：~4 rows (大约)
/*!40000 ALTER TABLE `data_chart_7` DISABLE KEYS */;
INSERT INTO `data_chart_7` (`id`, `user_id`, `name`, `value`, `create_time`, `update_time`) VALUES
    (1, '1', '访问率', 100, '2020-09-03 11:16:11', '2020-09-03 11:16:12'),
    (2, '1', '点击率', 80, '2020-09-03 11:16:11', '2020-09-03 11:16:12'),
    (3, '1', '咨询率', 60, '2020-09-03 11:16:11', '2020-09-03 11:16:12'),
    (4, '1', '成单率', 40, '2020-09-03 11:16:11', '2020-09-03 11:16:12');
/*!40000 ALTER TABLE `data_chart_7` ENABLE KEYS */;

-- 导出  表 pai-data-manager.data_chart_8 结构
CREATE TABLE IF NOT EXISTS `data_chart_8` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(1024) NOT NULL DEFAULT '0' COMMENT '开发者id',
  `name` varchar(128) NOT NULL DEFAULT '0' COMMENT '名称',
  `value_dimension_1` int(11) NOT NULL DEFAULT '0' COMMENT '维度1值',
  `value_dimension_2` int(11) NOT NULL DEFAULT '0' COMMENT '维度2值',
  `value_dimension_3` int(11) NOT NULL DEFAULT '0' COMMENT '维度3值',
  `value_dimension_4` int(11) NOT NULL DEFAULT '0' COMMENT '维度4值',
  `value_dimension_5` int(11) NOT NULL DEFAULT '0' COMMENT '维度5值',
  `value_dimension_6` int(11) NOT NULL DEFAULT '0' COMMENT '维度6值',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='图表8：雷达图分析';

-- 正在导出表  pai-data-manager.data_chart_8 的数据：~2 rows (大约)
/*!40000 ALTER TABLE `data_chart_8` DISABLE KEYS */;
INSERT INTO `data_chart_8` (`id`, `user_id`, `name`, `value_dimension_1`, `value_dimension_2`, `value_dimension_3`, `value_dimension_4`, `value_dimension_5`, `value_dimension_6`, `create_time`, `update_time`) VALUES
    (1, '1', '预估标准', 100, 90, 80, 90, 80, 80, '2020-09-03 11:26:03', '2020-09-03 11:26:12'),
    (2, '1', '实际测量', 70, 60, 50, 60, 70, 80, '2020-09-03 11:26:03', '2020-09-03 11:26:12');
/*!40000 ALTER TABLE `data_chart_8` ENABLE KEYS */;

-- 导出  表 pai-data-manager.data_chart_9 结构
CREATE TABLE IF NOT EXISTS `data_chart_9` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(1024) NOT NULL DEFAULT '0' COMMENT '开发者id',
  `name` varchar(128) NOT NULL DEFAULT '0' COMMENT '类型',
  `value` int(11) NOT NULL DEFAULT '0' COMMENT '值',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='图表9：饼图分析';

-- 正在导出表  pai-data-manager.data_chart_9 的数据：~5 rows (大约)
/*!40000 ALTER TABLE `data_chart_9` DISABLE KEYS */;
INSERT INTO `data_chart_9` (`id`, `user_id`, `name`, `value`, `create_time`, `update_time`) VALUES
    (1, '1', '博士', 500, '2020-09-03 11:30:41', '2020-09-03 11:30:42'),
    (2, '1', '硕士', 50, '2020-09-03 11:30:41', '2020-09-03 11:30:42'),
    (3, '1', '本科', 800, '2020-09-03 11:30:41', '2020-09-03 11:30:42'),
    (4, '1', '大专', 400, '2020-09-03 11:30:41', '2020-09-03 11:30:42'),
    (5, '1', '高中及以下', 500, '2020-09-03 11:30:41', '2020-09-03 11:30:42');
/*!40000 ALTER TABLE `data_chart_9` ENABLE KEYS */;

-- 导出  表 pai-data-manager.data_topic 结构
CREATE TABLE IF NOT EXISTS `data_topic` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(128) NOT NULL COMMENT '名称',
  `order` int(11) NOT NULL COMMENT '排序',
  `show` bit(1) NOT NULL DEFAULT b'1' COMMENT '是否显示',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `order` (`order`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='数据主题';

-- 正在导出表  pai-data-manager.data_topic 的数据：~3 rows (大约)
/*!40000 ALTER TABLE `data_topic` DISABLE KEYS */;
INSERT INTO `data_topic` (`id`, `name`, `order`, `show`, `create_time`, `update_time`) VALUES
    (1, '用户行为', 1, b'1', '2021-09-02 19:13:38', '2021-09-02 19:13:43'),
    (2, '智慧通行', 2, b'1', '2021-09-02 19:14:05', '2020-09-02 19:14:07'),
    (3, '综合安防', 3, b'1', '2020-09-02 19:14:33', '2020-09-02 19:14:35');
/*!40000 ALTER TABLE `data_topic` ENABLE KEYS */;

-- 导出  表 pai-data-manager.data_topic_chart 结构
CREATE TABLE IF NOT EXISTS `data_topic_chart` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(1024) NOT NULL DEFAULT '1' COMMENT '创建者id',
  `topic_id` int(11) NOT NULL COMMENT '数据主题id',
  `name` varchar(128) NOT NULL COMMENT '图表名',
  `icon_url` varchar(128) DEFAULT NULL COMMENT '图标图片',
  `table_name` varchar(128) DEFAULT NULL COMMENT '表名',
  `table_create_sql` text COMMENT '表创建sql',
  `table_data_sql` text COMMENT '表初始数据sql',
  `table_query_sql` text COMMENT '表查询sql',
  `order` int(11) NOT NULL COMMENT '排序',
  `show` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否显示',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1599205490388 DEFAULT CHARSET=utf8mb4 COMMENT='数据主题内容图表';

-- 正在导出表  pai-data-manager.data_topic_chart 的数据：~13 rows (大约)
/*!40000 ALTER TABLE `data_topic_chart` DISABLE KEYS */;
INSERT INTO `data_topic_chart` (`id`, `user_id`, `topic_id`, `name`, `icon_url`, `table_name`, `table_create_sql`, `table_data_sql`, `table_query_sql`, `order`, `show`, `create_time`, `update_time`) VALUES
    (1, '1', 1, '访问数', '', 'data_chart_1', 'CREATE TABLE `data_chart_1` (\r\n    `id` INT(11) NOT NULL AUTO_INCREMENT COMMENT \'id\',\r\n    `user_id` VARCHAR(1024) NOT NULL COMMENT \'开发者id\' COLLATE \'utf8mb4_general_ci\',\r\n    `name` VARCHAR(128) NOT NULL COMMENT \'统计名称\' COLLATE \'utf8mb4_general_ci\',\r\n    `rate` DECIMAL(10,2) NOT NULL DEFAULT \'0.00\' COMMENT \'昨日增长率\',\r\n    `value` INT(11) NOT NULL DEFAULT \'0\' COMMENT \'数量\',\r\n    `create_time` DATETIME NOT NULL COMMENT \'创建时间\',\r\n    `update_time` DATETIME NOT NULL COMMENT \'修改时间\',\r\n    PRIMARY KEY (`id`) USING BTREE\r\n)\r\nCOMMENT=\'数据图表1\'\r\nCOLLATE=\'utf8mb4_general_ci\'\r\nENGINE=InnoDB\r\n;\r\n', 'INSERT INTO `data_chart_1` (`user_id`, `name`, `rate`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'新增用户\', 20.00, 3, \'2020-09-02 20:01:11\', \'2020-09-02 20:01:13\');\r\nINSERT INTO `data_chart_1` (`user_id`, `name`, `rate`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'新增账户\', 100.00, 2, \'2020-09-02 20:01:41\', \'2020-09-02 20:01:42\');\r\nINSERT INTO `data_chart_1` (`user_id`, `name`, `rate`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'活跃账户\', 0.00, 0, \'2020-09-02 20:02:13\', \'2020-09-02 20:02:15\');\r\nINSERT INTO `data_chart_1` (`user_id`, `name`, `rate`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'启动次数\', 50.00, 100, \'2020-09-02 20:02:37\', \'2020-09-02 20:02:40\');\r\nINSERT INTO `data_chart_1` (`user_id`, `name`, `rate`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'页面访问数\', 50.00, 200, \'2020-09-02 20:04:20\', \'2020-09-02 20:04:21\');\r\n', '{\r\n    "DataChart1[]": {\r\n        "page": 0,\r\n        "count": 10,\r\n        "DataChart1": {\r\n            "user_id": 1,\r\n            "@column":"name,value,rate",\r\n            "@order":"id+"\r\n        }\r\n    }\r\n}', 1, b'1', '2021-09-02 19:15:24', '2021-09-02 19:15:27'),
    (2, '1', 1, '分时走势图', '', 'data_chart_2', 'CREATE TABLE `data_chart_2` (\r\n    `id` INT(11) NOT NULL AUTO_INCREMENT,\r\n    `user_id` VARCHAR(1024) NOT NULL DEFAULT \'0\' COMMENT \'开发者id\' COLLATE \'utf8mb4_general_ci\',\r\n    `date_hour` DATETIME NOT NULL COMMENT \'小时\',\r\n    `value` INT(11) NOT NULL DEFAULT \'0\' COMMENT \'访问数\',\r\n    `create_time` DATETIME NOT NULL COMMENT \'创建时间\',\r\n    `update_time` DATETIME NOT NULL COMMENT \'更新时间\',\r\n    PRIMARY KEY (`id`) USING BTREE\r\n)\r\nCOMMENT=\'图表2\'\r\nCOLLATE=\'utf8mb4_general_ci\'\r\nENGINE=InnoDB\r\n;', 'INSERT INTO `data_chart_2` (`user_id`, `date_hour`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'2020-09-02 00:00:00\', 0, \'2020-09-02 20:06:39\', \'2020-09-02 20:06:40\');\r\nINSERT INTO `data_chart_2` (`user_id`, `date_hour`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'2020-09-02 01:00:00\', 0, \'2020-09-02 20:06:39\', \'2020-09-02 20:06:40\');\r\nINSERT INTO `data_chart_2` (`user_id`, `date_hour`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'2020-09-02 02:00:00\', 0, \'2020-09-02 20:06:39\', \'2020-09-02 20:06:40\');\r\nINSERT INTO `data_chart_2` (`user_id`, `date_hour`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'2020-09-02 03:00:00\', 0, \'2020-09-02 20:06:39\', \'2020-09-02 20:06:40\');\r\nINSERT INTO `data_chart_2` (`user_id`, `date_hour`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'2020-09-02 04:00:00\', 0, \'2020-09-02 20:06:39\', \'2020-09-02 20:06:40\');\r\nINSERT INTO `data_chart_2` (`user_id`, `date_hour`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'2020-09-02 05:00:00\', 0, \'2020-09-02 20:06:39\', \'2020-09-02 20:06:40\');\r\nINSERT INTO `data_chart_2` (`user_id`, `date_hour`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'2020-09-02 06:00:00\', 0, \'2020-09-02 20:06:39\', \'2020-09-02 20:06:40\');\r\nINSERT INTO `data_chart_2` (`user_id`, `date_hour`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'2020-09-02 07:00:00\', 0, \'2020-09-02 20:06:39\', \'2020-09-02 20:06:40\');\r\nINSERT INTO `data_chart_2` (`user_id`, `date_hour`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'2020-09-02 08:00:00\', 10, \'2020-09-02 20:06:39\', \'2020-09-02 20:06:40\');\r\nINSERT INTO `data_chart_2` (`user_id`, `date_hour`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'2020-09-02 09:00:00\', 0, \'2020-09-02 20:06:39\', \'2020-09-02 20:06:40\');\r\nINSERT INTO `data_chart_2` (`user_id`, `date_hour`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'2020-09-02 10:00:00\', 0, \'2020-09-02 20:06:39\', \'2020-09-02 20:06:40\');\r\nINSERT INTO `data_chart_2` (`user_id`, `date_hour`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'2020-09-02 11:00:00\', 20, \'2020-09-02 20:06:39\', \'2020-09-02 20:06:40\');\r\nINSERT INTO `data_chart_2` (`user_id`, `date_hour`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'2020-09-02 12:00:00\', 100, \'2020-09-02 20:06:39\', \'2020-09-02 20:06:40\');\r\nINSERT INTO `data_chart_2` (`user_id`, `date_hour`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'2020-09-02 13:00:00\', 0, \'2020-09-02 20:06:39\', \'2020-09-02 20:06:40\');\r\nINSERT INTO `data_chart_2` (`user_id`, `date_hour`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'2020-09-02 14:00:00\', 5, \'2020-09-02 20:06:39\', \'2020-09-02 20:06:40\');\r\nINSERT INTO `data_chart_2` (`user_id`, `date_hour`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'2020-09-02 15:00:00\', 0, \'2020-09-02 20:06:39\', \'2020-09-02 20:06:40\');\r\nINSERT INTO `data_chart_2` (`user_id`, `date_hour`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'2020-09-02 16:00:00\', 1, \'2020-09-02 20:06:39\', \'2020-09-02 20:06:40\');\r\nINSERT INTO `data_chart_2` (`user_id`, `date_hour`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'2020-09-02 17:00:00\', 0, \'2020-09-02 20:06:39\', \'2020-09-02 20:06:40\');\r\nINSERT INTO `data_chart_2` (`user_id`, `date_hour`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'2020-09-02 18:00:00\', 0, \'2020-09-02 20:06:39\', \'2020-09-02 20:06:40\');\r\nINSERT INTO `data_chart_2` (`user_id`, `date_hour`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'2020-09-02 19:00:00\', 30, \'2020-09-02 20:06:39\', \'2020-09-02 20:06:40\');\r\nINSERT INTO `data_chart_2` (`user_id`, `date_hour`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'2020-09-02 20:00:00\', 120, \'2020-09-02 20:06:39\', \'2020-09-02 20:06:40\');\r\nINSERT INTO `data_chart_2` (`user_id`, `date_hour`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'2020-09-02 21:00:00\', 0, \'2020-09-02 20:06:39\', \'2020-09-02 20:06:40\');\r\nINSERT INTO `data_chart_2` (`user_id`, `date_hour`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'2020-09-02 22:00:00\', 20, \'2020-09-02 20:06:39\', \'2020-09-02 20:06:40\');\r\nINSERT INTO `data_chart_2` (`user_id`, `date_hour`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'2020-09-02 23:00:00\', 0, \'2020-09-02 20:06:39\', \'2020-09-02 20:06:40\');\r\n', '{\r\n    "DataChart2[]": {\r\n        "page": 0,\r\n        "count": 23,\r\n        "DataChart2": {\r\n            "user_id": 1,\r\n            "@column": "date_hour,value",\r\n            "@order": "date_hour+"\r\n        }\r\n    }\r\n}', 2, b'1', '2021-09-02 19:16:20', '2020-09-02 19:16:21'),
    (3, '1', 1, '7日留存图', '', 'data_chart_3', 'CREATE TABLE `data_chart_3` (\r\n    `id` INT(11) NOT NULL AUTO_INCREMENT,\r\n    `user_id` VARCHAR(1024) NOT NULL DEFAULT \'0\' COMMENT \'开发者id\' COLLATE \'utf8mb4_general_ci\',\r\n    `date` DATE NOT NULL COMMENT \'日期\',\r\n    `value` INT(11) NOT NULL DEFAULT \'0\' COMMENT \'留存数\',\r\n    `value_day_1` INT(11) NULL DEFAULT \'0\' COMMENT \'1日留存数\',\r\n    `value_day_2` INT(11) NULL DEFAULT \'0\' COMMENT \'2日留存数\',\r\n    `value_day_3` INT(11) NULL DEFAULT \'0\' COMMENT \'3日留存数\',\r\n    `value_day_4` INT(11) NULL DEFAULT \'0\' COMMENT \'4日留存数\',\r\n    `value_day_5` INT(11) NULL DEFAULT \'0\' COMMENT \'5日留存数\',\r\n    `value_day_6` INT(11) NULL DEFAULT \'0\' COMMENT \'6日留存数\',\r\n    `value_day_7` INT(11) NULL DEFAULT \'0\' COMMENT \'7日留存数\',\r\n    `create_time` DATETIME NOT NULL COMMENT \'创建时间\',\r\n    `update_time` DATETIME NOT NULL COMMENT \'更新时间\',\r\n    PRIMARY KEY (`id`) USING BTREE\r\n)\r\nCOMMENT=\'图表3：7日留存分析\'\r\nCOLLATE=\'utf8mb4_general_ci\'\r\nENGINE=InnoDB;\r\n', 'INSERT INTO `data_chart_3` (`user_id`, `date`, `value`, `value_day_1`, `value_day_2`, `value_day_3`, `value_day_4`, `value_day_5`, `value_day_6`, `value_day_7`, `create_time`, `update_time`) VALUES (\'1\', \'2020-08-24\', 100, 50, 60, 80, 10, 15, 0, 60, \'2020-09-03 10:50:58\', \'2020-09-03 10:51:03\');\r\nINSERT INTO `data_chart_3` (`user_id`, `date`, `value`, `value_day_1`, `value_day_2`, `value_day_3`, `value_day_4`, `value_day_5`, `value_day_6`, `value_day_7`, `create_time`, `update_time`) VALUES (\'1\', \'2020-08-25\', 100, 50, 60, 80, 10, 15, 10, 0, \'2020-09-03 10:50:58\', \'2020-09-03 10:51:03\');\r\nINSERT INTO `data_chart_3` (`user_id`, `date`, `value`, `value_day_1`, `value_day_2`, `value_day_3`, `value_day_4`, `value_day_5`, `value_day_6`, `value_day_7`, `create_time`, `update_time`) VALUES (\'1\', \'2020-08-26\', 100, 50, 60, 80, 10, 10, 0, 0, \'2020-09-03 10:50:58\', \'2020-09-03 10:51:03\');\r\nINSERT INTO `data_chart_3` (`user_id`, `date`, `value`, `value_day_1`, `value_day_2`, `value_day_3`, `value_day_4`, `value_day_5`, `value_day_6`, `value_day_7`, `create_time`, `update_time`) VALUES (\'1\', \'2020-08-27\', 100, 50, 60, 80, 20, 0, 0, 0, \'2020-09-03 10:50:58\', \'2020-09-03 10:51:03\');\r\nINSERT INTO `data_chart_3` (`user_id`, `date`, `value`, `value_day_1`, `value_day_2`, `value_day_3`, `value_day_4`, `value_day_5`, `value_day_6`, `value_day_7`, `create_time`, `update_time`) VALUES (\'1\', \'2020-08-28\', 100, 50, 60, 30, 0, 0, 0, 0, \'2020-09-03 10:50:58\', \'2020-09-03 10:51:03\');\r\nINSERT INTO `data_chart_3` (`user_id`, `date`, `value`, `value_day_1`, `value_day_2`, `value_day_3`, `value_day_4`, `value_day_5`, `value_day_6`, `value_day_7`, `create_time`, `update_time`) VALUES (\'1\', \'2020-08-29\', 100, 50, 10, 0, 0, 0, 0, 0, \'2020-09-03 10:50:58\', \'2020-09-03 10:51:03\');\r\nINSERT INTO `data_chart_3` (`user_id`, `date`, `value`, `value_day_1`, `value_day_2`, `value_day_3`, `value_day_4`, `value_day_5`, `value_day_6`, `value_day_7`, `create_time`, `update_time`) VALUES (\'1\', \'2020-08-30\', 100, 50, 0, 0, 0, 0, 0, 0, \'2020-09-03 10:50:58\', \'2020-09-03 10:51:03\');', '{\r\n    "DataChart3[]": {\r\n        "page": 0,\r\n        "count": 7,\r\n        "DataChart3": {\r\n            "user_id": 1,\r\n            "@column": "date,value,value_day_1,value_day_2,value_day_3,value_day_4,value_day_5,value_day_6,value_day_7",\r\n            "@order": "date+"\r\n        }\r\n    }\r\n}', 3, b'1', '2020-09-02 19:16:48', '2020-09-02 19:16:49'),
    (4, '1', 1, '词云', '', 'data_chart_4', 'CREATE TABLE `data_chart_4` (\r\n    `id` INT(11) NOT NULL AUTO_INCREMENT,\r\n    `user_id` VARCHAR(1024) NOT NULL DEFAULT \'0\' COMMENT \'开发者id\' COLLATE \'utf8mb4_general_ci\',\r\n    `word` VARCHAR(128) NOT NULL DEFAULT \'0\' COMMENT \'词\' COLLATE \'utf8mb4_general_ci\',\r\n    `count` INT(11) NOT NULL DEFAULT \'0\' COMMENT \'数量\',\r\n    `create_time` DATETIME NOT NULL COMMENT \'创建时间\',\r\n    `update_time` DATETIME NOT NULL COMMENT \'更新时间\',\r\n    PRIMARY KEY (`id`) USING BTREE\r\n)\r\nCOMMENT=\'图表4：词云\'\r\nCOLLATE=\'utf8mb4_general_ci\'\r\nENGINE=InnoDB\r\n;\r\n', 'INSERT INTO `data_chart_4` (`user_id`, `word`, `count`, `create_time`, `update_time`) VALUES (\'1\', \'AI\', 1000, \'2020-09-03 11:00:23\', \'2020-09-03 11:00:24\');\r\nINSERT INTO `data_chart_4` (`user_id`, `word`, `count`, `create_time`, `update_time`) VALUES (\'1\', \'大数据\', 900, \'2020-09-03 11:00:23\', \'2020-09-03 11:00:24\');\r\nINSERT INTO `data_chart_4` (`user_id`, `word`, `count`, `create_time`, `update_time`) VALUES (\'1\', \'云计算\', 800, \'2020-09-03 11:00:23\', \'2020-09-03 11:00:24\');\r\nINSERT INTO `data_chart_4` (`user_id`, `word`, `count`, `create_time`, `update_time`) VALUES (\'1\', \'数据中台\', 700, \'2020-09-03 11:00:23\', \'2020-09-03 11:00:24\');\r\nINSERT INTO `data_chart_4` (`user_id`, `word`, `count`, `create_time`, `update_time`) VALUES (\'1\', \'业务中台\', 500, \'2020-09-03 11:00:23\', \'2020-09-03 11:00:24\');\r\nINSERT INTO `data_chart_4` (`user_id`, `word`, `count`, `create_time`, `update_time`) VALUES (\'1\', \'技术平台\', 300, \'2020-09-03 11:00:23\', \'2020-09-03 11:00:24\');\r\nINSERT INTO `data_chart_4` (`user_id`, `word`, `count`, `create_time`, `update_time`) VALUES (\'1\', \'5G\', 100, \'2020-09-03 11:00:23\', \'2020-09-03 11:00:24\');\r\nINSERT INTO `data_chart_4` (`user_id`, `word`, `count`, `create_time`, `update_time`) VALUES (\'1\', \'IOT\', 200, \'2020-09-03 11:00:23\', \'2020-09-03 11:00:24\');\r\n', '{\r\n    "DataChart4[]": {\r\n        "page": 0,\r\n        "count": 10,\r\n        "DataChart4": {\r\n            "user_id": 1,\r\n            "@column": "word,count",\r\n            "@order": "count-"\r\n        }\r\n    }\r\n}', 4, b'1', '2020-09-02 19:17:52', '2020-09-02 19:17:54'),
    (5, '1', 1, '页面访问排行', '', 'data_chart_5', 'CREATE TABLE `data_chart_5` (\r\n    `id` INT(11) NOT NULL AUTO_INCREMENT,\r\n    `user_id` VARCHAR(1024) NOT NULL DEFAULT \'0\' COMMENT \'开发者id\' COLLATE \'utf8mb4_general_ci\',\r\n    `name` VARCHAR(128) NOT NULL DEFAULT \'0\' COMMENT \'名称\' COLLATE \'utf8mb4_general_ci\',\r\n    `value` INT(11) NOT NULL DEFAULT \'0\' COMMENT \'数量\',\r\n    `create_time` DATETIME NOT NULL COMMENT \'创建时间\',\r\n    `update_time` DATETIME NOT NULL COMMENT \'更新时间\',\r\n    PRIMARY KEY (`id`) USING BTREE\r\n)\r\nCOMMENT=\'图表5：页面访问排行\'\r\nCOLLATE=\'utf8mb4_general_ci\'\r\nENGINE=InnoDB\r\n;\r\n', 'INSERT INTO `data_chart_5` (`user_id`, `name`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'主页\', 100, \'2020-09-03 11:04:36\', \'2020-09-03 11:04:37\');\r\nINSERT INTO `data_chart_5` (`user_id`, `name`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'登录页\', 90, \'2020-09-03 11:04:36\', \'2020-09-03 11:04:37\');\r\nINSERT INTO `data_chart_5` (`user_id`, `name`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'支付页\', 80, \'2020-09-03 11:04:36\', \'2020-09-03 11:04:37\');\r\nINSERT INTO `data_chart_5` (`user_id`, `name`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'广场活动页\', 50, \'2020-09-03 11:04:36\', \'2020-09-03 11:04:37\');\r\nINSERT INTO `data_chart_5` (`user_id`, `name`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'投票活动页\', 20, \'2020-09-03 11:04:36\', \'2020-09-03 11:04:37\');\r\nINSERT INTO `data_chart_5` (`user_id`, `name`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'车广告页\', 10, \'2020-09-03 11:04:36\', \'2020-09-03 11:04:37\');\r\nINSERT INTO `data_chart_5` (`user_id`, `name`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'优惠页\', 3, \'2020-09-03 11:04:36\', \'2020-09-03 11:04:37\');\r\n', '{\r\n    "DataChart5[]": {\r\n        "page": 0,\r\n        "count": 10,\r\n        "DataChart5": {\r\n            "user_id": 1,\r\n            "@column": "name,value",\r\n            "@order": "value-"\r\n        }\r\n    }\r\n}', 5, b'1', '2020-09-02 19:19:50', '2020-09-02 19:19:51'),
    (6, '1', 1, '用户访问数排行', '', 'data_chart_6', 'CREATE TABLE `data_chart_6` (\r\n    `id` INT(11) NOT NULL AUTO_INCREMENT,\r\n    `user_id` VARCHAR(1024) NOT NULL DEFAULT \'0\' COMMENT \'开发者id\' COLLATE \'utf8mb4_general_ci\',\r\n    `name` VARCHAR(128) NOT NULL DEFAULT \'0\' COMMENT \'名称\' COLLATE \'utf8mb4_general_ci\',\r\n    `value` INT(11) NOT NULL DEFAULT \'0\' COMMENT \'数量\',\r\n    `create_time` DATETIME NOT NULL COMMENT \'创建时间\',\r\n    `update_time` DATETIME NOT NULL COMMENT \'更新时间\',\r\n    PRIMARY KEY (`id`) USING BTREE\r\n)\r\nCOMMENT=\'图表6：用户访问数排行\'\r\nCOLLATE=\'utf8mb4_general_ci\'\r\nENGINE=InnoDB\r\n;\r\n', 'INSERT INTO `data_chart_6` (`user_id`, `name`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'张三\', 100, \'2020-09-03 11:09:27\', \'2020-09-03 11:09:28\');\r\nINSERT INTO `data_chart_6` (`user_id`, `name`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'李四\', 90, \'2020-09-03 11:09:27\', \'2020-09-03 11:09:28\');\r\nINSERT INTO `data_chart_6` (`user_id`, `name`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'王五\', 80, \'2020-09-03 11:09:27\', \'2020-09-03 11:09:28\');\r\nINSERT INTO `data_chart_6` (`user_id`, `name`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'孙六\', 70, \'2020-09-03 11:09:27\', \'2020-09-03 11:09:28\');\r\nINSERT INTO `data_chart_6` (`user_id`, `name`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'赵七\', 68, \'2020-09-03 11:09:27\', \'2020-09-03 11:09:28\');\r\nINSERT INTO `data_chart_6` (`user_id`, `name`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'公孙八\', 55, \'2020-09-03 11:09:27\', \'2020-09-03 11:09:28\');\r\nINSERT INTO `data_chart_6` (`user_id`, `name`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'九九\', 40, \'2020-09-03 11:09:27\', \'2020-09-03 11:09:28\');\r\nINSERT INTO `data_chart_6` (`user_id`, `name`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'十十\', 31, \'2020-09-03 11:09:27\', \'2020-09-03 11:09:28\');\r\nINSERT INTO `data_chart_6` (`user_id`, `name`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'十一\', 22, \'2020-09-03 11:09:27\', \'2020-09-03 11:09:28\');\r\nINSERT INTO `data_chart_6` (`user_id`, `name`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'十二\', 6, \'2020-09-03 11:09:27\', \'2020-09-03 11:09:28\');\r\n', '{\r\n    "DataChart6[]": {\r\n        "page": 0,\r\n        "count": 10,\r\n        "DataChart6": {\r\n            "user_id": 1,\r\n            "@column": "name,value",\r\n            "@order": "value-"\r\n        }\r\n    }\r\n}', 6, b'1', '2020-09-02 19:20:40', '2020-09-02 19:20:43'),
    (7, '1', 2, '漏斗分析', '', 'data_chart_7', 'CREATE TABLE `data_chart_7` (\r\n    `id` INT(11) NOT NULL AUTO_INCREMENT,\r\n    `user_id` VARCHAR(1024) NOT NULL DEFAULT \'0\' COMMENT \'开发者id\' COLLATE \'utf8mb4_general_ci\',\r\n    `name` VARCHAR(128) NOT NULL DEFAULT \'0\' COMMENT \'名称\' COLLATE \'utf8mb4_general_ci\',\r\n    `value` INT(11) NOT NULL DEFAULT \'0\' COMMENT \'数量\',\r\n    `create_time` DATETIME NOT NULL COMMENT \'创建时间\',\r\n    `update_time` DATETIME NOT NULL COMMENT \'更新时间\',\r\n    PRIMARY KEY (`id`) USING BTREE\r\n)\r\nCOMMENT=\'图表7：漏斗分析\'\r\nCOLLATE=\'utf8mb4_general_ci\'\r\nENGINE=InnoDB\r\n;\r\n', 'INSERT INTO `data_chart_7` (`user_id`, `name`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'访问率\', 100, \'2020-09-03 11:16:11\', \'2020-09-03 11:16:12\');\r\nINSERT INTO `data_chart_7` (`user_id`, `name`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'点击率\', 80, \'2020-09-03 11:16:11\', \'2020-09-03 11:16:12\');\r\nINSERT INTO `data_chart_7` (`user_id`, `name`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'咨询率\', 60, \'2020-09-03 11:16:11\', \'2020-09-03 11:16:12\');\r\nINSERT INTO `data_chart_7` (`user_id`, `name`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'成单率\', 40, \'2020-09-03 11:16:11\', \'2020-09-03 11:16:12\');\r\n', '{\r\n    "DataChart7[]": {\r\n        "page": 0,\r\n        "count": 10,\r\n        "DataChart7": {\r\n            "user_id": 1,\r\n            "@column": "name,value",\r\n            "@order": "value-"\r\n        }\r\n    }\r\n}', 7, b'1', '2020-09-02 19:21:31', '2020-09-02 19:21:32'),
    (8, '1', 2, '雷达图分析', '', 'data_chart_8', 'CREATE TABLE `data_chart_8` (\r\n    `id` INT(11) NOT NULL AUTO_INCREMENT,\r\n    `user_id` VARCHAR(1024) NOT NULL DEFAULT \'0\' COMMENT \'开发者id\' COLLATE \'utf8mb4_general_ci\',\r\n    `name` VARCHAR(128) NOT NULL DEFAULT \'0\' COMMENT \'名称\' COLLATE \'utf8mb4_general_ci\',\r\n    `value_dimension_1` INT(11) NOT NULL DEFAULT \'0\' COMMENT \'维度1值\',\r\n    `value_dimension_2` INT(11) NOT NULL DEFAULT \'0\' COMMENT \'维度2值\',\r\n    `value_dimension_3` INT(11) NOT NULL DEFAULT \'0\' COMMENT \'维度3值\',\r\n    `value_dimension_4` INT(11) NOT NULL DEFAULT \'0\' COMMENT \'维度4值\',\r\n    `value_dimension_5` INT(11) NOT NULL DEFAULT \'0\' COMMENT \'维度5值\',\r\n    `value_dimension_6` INT(11) NOT NULL DEFAULT \'0\' COMMENT \'维度6值\',\r\n    `create_time` DATETIME NOT NULL COMMENT \'创建时间\',\r\n    `update_time` DATETIME NOT NULL COMMENT \'更新时间\',\r\n    PRIMARY KEY (`id`) USING BTREE\r\n)\r\nCOMMENT=\'图表8：雷达图分析\'\r\nCOLLATE=\'utf8mb4_general_ci\'\r\nENGINE=InnoDB\r\n;\r\n', 'INSERT INTO `data_chart_8` (`user_id`, `name`, `value_dimension_1`, `value_dimension_2`, `value_dimension_3`, `value_dimension_4`, `value_dimension_5`, `value_dimension_6`, `create_time`, `update_time`) VALUES (\'1\', \'预估标准\', 100, 90, 80, 90, 80, 80, \'2020-09-03 11:26:03\', \'2020-09-03 11:26:12\');\r\nINSERT INTO `data_chart_8` (`user_id`, `name`, `value_dimension_1`, `value_dimension_2`, `value_dimension_3`, `value_dimension_4`, `value_dimension_5`, `value_dimension_6`, `create_time`, `update_time`) VALUES (\'1\', \'实际测量\', 70, 60, 50, 60, 70, 80, \'2020-09-03 11:26:03\', \'2020-09-03 11:26:12\');\r\n', '{\r\n    "DataChart8[]": {\r\n        "page": 0,\r\n        "count": 6,\r\n        "DataChart8": {\r\n            "user_id": 1,\r\n            "@column": "name,value_dimension_1,value_dimension_2,value_dimension_3,value_dimension_4,value_dimension_5,value_dimension_6",\r\n            "@order": "id+"\r\n        }\r\n    }\r\n}', 8, b'1', '2020-09-02 19:22:16', '2020-09-02 19:22:17'),
    (9, '1', 3, '饼图分析', '', 'data_chart_9', 'CREATE TABLE `data_chart_9` (\r\n    `id` INT(11) NOT NULL AUTO_INCREMENT,\r\n    `user_id` VARCHAR(1024) NOT NULL DEFAULT \'0\' COMMENT \'开发者id\' COLLATE \'utf8mb4_general_ci\',\r\n    `name` VARCHAR(128) NOT NULL DEFAULT \'0\' COMMENT \'类型\' COLLATE \'utf8mb4_general_ci\',\r\n    `value` INT(11) NOT NULL DEFAULT \'0\' COMMENT \'值\',\r\n    `create_time` DATETIME NOT NULL COMMENT \'创建时间\',\r\n    `update_time` DATETIME NOT NULL COMMENT \'更新时间\',\r\n    PRIMARY KEY (`id`) USING BTREE\r\n)\r\nCOMMENT=\'图表9：饼图分析\'\r\nCOLLATE=\'utf8mb4_general_ci\'\r\nENGINE=InnoDB\r\n;\r\n', 'INSERT INTO `data_chart_9` (`user_id`, `name`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'博士\', 500, \'2020-09-03 11:30:41\', \'2020-09-03 11:30:42\');\r\nINSERT INTO `data_chart_9` (`user_id`, `name`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'硕士\', 50, \'2020-09-03 11:30:41\', \'2020-09-03 11:30:42\');\r\nINSERT INTO `data_chart_9` (`user_id`, `name`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'本科\', 800, \'2020-09-03 11:30:41\', \'2020-09-03 11:30:42\');\r\nINSERT INTO `data_chart_9` (`user_id`, `name`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'大专\', 400, \'2020-09-03 11:30:41\', \'2020-09-03 11:30:42\');\r\nINSERT INTO `data_chart_9` (`user_id`, `name`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'高中及以下\', 500, \'2020-09-03 11:30:41\', \'2020-09-03 11:30:42\');\r\n', '{\r\n    "DataChart9[]": {\r\n        "page": 0,\r\n        "count": 10,\r\n        "DataChart9": {\r\n            "user_id": 1,\r\n            "@column": "name,value",\r\n            "@order": "value-"\r\n        }\r\n    }\r\n}', 9, b'1', '2020-09-02 19:22:55', '2020-09-02 19:22:58'),
    (10, '1', 3, '仪表指数', '', 'data_chart_10', 'CREATE TABLE `data_chart_10` (\r\n    `id` INT(11) NOT NULL AUTO_INCREMENT,\r\n    `user_id` VARCHAR(1024) NOT NULL DEFAULT \'0\' COMMENT \'开发者id\' COLLATE \'utf8mb4_general_ci\',\r\n    `name` VARCHAR(128) NOT NULL DEFAULT \'0\' COMMENT \'名称\' COLLATE \'utf8mb4_general_ci\',\r\n    `value` VARCHAR(128) NOT NULL DEFAULT \'0\' COMMENT \'值\' COLLATE \'utf8mb4_general_ci\',\r\n    `create_time` DATETIME NOT NULL COMMENT \'创建时间\',\r\n    `update_time` DATETIME NOT NULL COMMENT \'更新时间\',\r\n    PRIMARY KEY (`id`) USING BTREE\r\n)\r\nCOMMENT=\'图表10：仪表指数\'\r\nCOLLATE=\'utf8mb4_general_ci\'\r\nENGINE=InnoDB\r\nAUTO_INCREMENT=2\r\n;\r\n', 'INSERT INTO `data_chart_10` (`user_id`, `name`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'温度\', \'39.8\', \'2020-09-03 11:35:28\', \'2020-09-03 11:35:29\');\r\n', '{\r\n    "DataChart10[]": {\r\n        "page": 0,\r\n        "count": 1,\r\n        "DataChart10": {\r\n            "user_id": 1,\r\n            "@column": "name,value",\r\n            "@order": "id+"\r\n        }\r\n    }\r\n}', 10, b'1', '2020-09-02 19:23:20', '2020-09-02 19:23:21'),
    (11, '1', 3, '散点图分析', '', 'data_chart_11', 'CREATE TABLE `data_chart_11` (\r\n    `id` INT(11) NOT NULL AUTO_INCREMENT,\r\n    `user_id` VARCHAR(1024) NOT NULL DEFAULT \'0\' COMMENT \'开发者id\' COLLATE \'utf8mb4_general_ci\',\r\n    `name` VARCHAR(1024) NOT NULL DEFAULT \'0\' COMMENT \'名称\' COLLATE \'utf8mb4_general_ci\',\r\n    `value_x` VARCHAR(1024) NOT NULL DEFAULT \'0\' COMMENT \'x轴值\' COLLATE \'utf8mb4_general_ci\',\r\n    `value_y` VARCHAR(1024) NOT NULL DEFAULT \'0\' COMMENT \'y轴值\' COLLATE \'utf8mb4_general_ci\',\r\n    `value` VARCHAR(1024) NOT NULL DEFAULT \'0\' COMMENT \'值\' COLLATE \'utf8mb4_general_ci\',\r\n    `create_time` DATETIME NOT NULL COMMENT \'创建时间\',\r\n    `update_time` DATETIME NOT NULL COMMENT \'更新时间\',\r\n    PRIMARY KEY (`id`) USING BTREE\r\n)\r\nCOMMENT=\'图表11：散点图分析\'\r\nCOLLATE=\'utf8mb4_general_ci\'\r\nENGINE=InnoDB\r\n;\r\n', 'INSERT INTO `data_chart_11` (`user_id`, `name`, `value_x`, `value_y`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'南方软件园\', \'10\', \'20\', \'50\', \'2020-09-03 11:44:46\', \'2020-09-03 11:44:47\');\r\nINSERT INTO `data_chart_11` (`user_id`, `name`, `value_x`, `value_y`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'清华园\', \'8\', \'20\', \'250\', \'2020-09-03 11:44:46\', \'2020-09-03 11:44:47\');\r\nINSERT INTO `data_chart_11` (`user_id`, `name`, `value_x`, `value_y`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'大洲科技园\', \'10\', \'10\', \'150\', \'2020-09-03 11:44:46\', \'2020-09-03 11:44:47\');\r\nINSERT INTO `data_chart_11` (`user_id`, `name`, `value_x`, `value_y`, `value`, `create_time`, `update_time`) VALUES (\'1\', \'格力园区\', \'5\', \'5\', \'500\', \'2020-09-03 11:44:46\', \'2020-09-03 11:44:47\');\r\n', '{\r\n    "DataChart11[]": {\r\n        "page": 0,\r\n        "count": 10,\r\n        "DataChart11": {\r\n            "user_id": 1,\r\n            "@column": "name,value_x,value_y,value",\r\n            "@order": "id+"\r\n        }\r\n    }\r\n}', 11, b'1', '2020-09-02 19:24:31', '2020-09-02 19:24:32');
/*!40000 ALTER TABLE `data_topic_chart` ENABLE KEYS */;

-- 导出  表 pai-data-manager.Function 结构
CREATE TABLE IF NOT EXISTS `Function` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `userId` bigint(20) NOT NULL COMMENT '管理员用户Id',
  `name` varchar(50) NOT NULL COMMENT '方法名',
  `arguments` varchar(100) DEFAULT NULL COMMENT '参数列表，每个参数的类型都是 String。\n用 , 分割的字符串 比 [JSONArray] 更好，例如 array,item ，更直观，还方便拼接函数。',
  `demo` json NOT NULL COMMENT '可用的示例。\nTODO 改成 call，和返回值示例 back 对应。',
  `detail` varchar(1000) NOT NULL COMMENT '详细描述',
  `type` varchar(50) NOT NULL DEFAULT 'Object' COMMENT '返回值类型。TODO RemoteFunction 校验 type 和 back',
  `version` tinyint(4) NOT NULL DEFAULT '0' COMMENT '允许的最低版本号，只限于GET,HEAD外的操作方法。\nTODO 使用 requestIdList 替代 version,tag,methods',
  `tag` varchar(20) DEFAULT NULL COMMENT '允许的标签.\nnull - 允许全部\nTODO 使用 requestIdList 替代 version,tag,methods',
  `methods` varchar(50) DEFAULT NULL COMMENT '允许的操作方法。\nnull - 允许全部\nTODO 使用 requestIdList 替代 version,tag,methods',
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `back` varchar(45) DEFAULT NULL COMMENT '返回值示例',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 COMMENT='远程函数。强制在启动时校验所有demo是否能正常运行通过';

-- 正在导出表  pai-data-manager.Function 的数据：~17 rows (大约)
/*!40000 ALTER TABLE `Function` DISABLE KEYS */;
INSERT INTO `Function` (`id`, `userId`, `name`, `arguments`, `demo`, `detail`, `type`, `version`, `tag`, `methods`, `date`, `back`) VALUES
    (3, 0, 'countArray', 'array', '{"array": [1, 2, 3]}', '获取数组长度。没写调用键值对，会自动补全 "result()": "countArray(array)"', 'Object', 0, NULL, NULL, '2018-10-13 16:23:23', NULL),
    (4, 0, 'countObject', 'object', '{"object": {"key0": 1, "key1": 2}}', '获取对象长度。', 'Object', 0, NULL, NULL, '2018-10-13 16:23:23', NULL),
    (5, 0, 'isContain', 'array,value', '{"array": [1, 2, 3], "value": 2}', '判断是否数组包含值。', 'Object', 0, NULL, NULL, '2018-10-13 16:23:23', NULL),
    (6, 0, 'isContainKey', 'object,key', '{"key": "id", "object": {"id": 1}}', '判断是否对象包含键。', 'Object', 0, NULL, NULL, '2018-10-13 16:30:31', NULL),
    (7, 0, 'isContainValue', 'object,value', '{"value": 1, "object": {"id": 1}}', '判断是否对象包含值。', 'Object', 0, NULL, NULL, '2018-10-13 16:30:31', NULL),
    (8, 0, 'getFromArray', 'array,position', '{"array": [1, 2, 3], "result()": "getFromArray(array,1)"}', '根据下标获取数组里的值。position 传数字时直接作为值，而不是从所在对象 request 中取值', 'Object', 0, NULL, NULL, '2018-10-13 16:30:31', NULL),
    (9, 0, 'getFromObject', 'object,key', '{"key": "id", "object": {"id": 1}}', '根据键获取对象里的值。', 'Object', 0, NULL, NULL, '2018-10-13 16:30:31', NULL),
    (11, 0, 'verifyIdList', 'array', '{"array": [1, 2, 3], "result()": "verifyIdList(array)"}', '校验类型为 id 列表', 'Object', 0, NULL, NULL, '2019-08-18 03:58:33', NULL),
    (12, 0, 'verifyURLList', 'array', '{"array": ["http://123.com/1.jpg", "http://123.com/a.png", "http://www.abc.com/test.gif"], "result()": "verifyURLList(array)"}', '校验类型为 URL 列表', 'Object', 0, NULL, NULL, '2019-08-18 03:58:33', NULL),
    (13, 0, 'getWithDefault', 'value,defaultValue', '{"value": null, "defaultValue": 1}', '如果 value 为 null，则返回 defaultValue', 'Object', 0, NULL, NULL, '2019-08-20 23:26:36', NULL),
    (14, 0, 'removeKey', 'key', '{"key": "s", "key2": 2}', '从对象里移除 key', 'Object', 0, NULL, NULL, '2019-08-20 23:26:36', NULL),
    (15, 0, 'getFunctionDemo', NULL, '{}', '获取远程函数的 Demo', 'Object', 0, NULL, NULL, '2019-08-20 23:26:36', NULL),
    (16, 0, 'getFunctionDetail', NULL, '{}', '获取远程函数的详情', 'Object', 0, NULL, NULL, '2019-08-20 23:26:36', NULL),
    (17, 0, 'getMethodArguments', 'methodArgs', '{"methodArgs": "methodArgs"}', '获取方法参数', 'Object', 0, NULL, NULL, '2020-04-06 01:44:07', NULL),
    (18, 0, 'getMethodDefination', 'method,arguments,type,exceptions,language', '{"method": "method"}', '获取方法定义', 'Object', 0, NULL, NULL, '2020-04-06 01:44:07', NULL),
    (19, 0, 'getMethodRequest', NULL, '{}', '获取方法请求', 'Object', 0, NULL, NULL, '2020-04-06 01:44:07', NULL);
/*!40000 ALTER TABLE `Function` ENABLE KEYS */;

-- 导出  表 pai-data-manager.Login 结构
CREATE TABLE IF NOT EXISTS `Login` (
  `id` bigint(20) NOT NULL COMMENT '唯一标识',
  `userId` bigint(20) NOT NULL COMMENT '用户id',
  `type` tinyint(4) NOT NULL COMMENT '类型\n0-密码登录\n1-验证码登录',
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='@deprecated，登录信息存session';

-- 正在导出表  pai-data-manager.Login 的数据：~7 rows (大约)
/*!40000 ALTER TABLE `Login` DISABLE KEYS */;
INSERT INTO `Login` (`id`, `userId`, `type`, `date`) VALUES
    (1490863617907, 70793, 1, '2017-03-30 16:47:12'),
    (1490863735458, 70793, 0, '2017-03-30 16:48:55'),
    (1490974212206, 70793, 0, '2017-03-31 23:30:27'),
    (1490974347168, 70793, 0, '2017-03-31 23:32:27'),
    (1491015064227, 70793, 0, '2017-04-01 10:57:27'),
    (1491137175159, 70793, 0, '2017-04-02 20:46:27'),
    (1493891806372, 38710, 1, '2017-05-04 17:56:46');
/*!40000 ALTER TABLE `Login` ENABLE KEYS */;

-- 导出  表 pai-data-manager.Request 结构
CREATE TABLE IF NOT EXISTS `Request` (
  `id` bigint(20) NOT NULL COMMENT '唯一标识',
  `version` tinyint(4) NOT NULL DEFAULT '1' COMMENT 'GET,HEAD可用任意结构访问任意开放内容，不需要这个字段。\n其它的操作因为写入了结构和内容，所以都需要，按照不同的version选择对应的structure。\n\n自动化版本管理：\nRequest JSON最外层可以传  “version”:Integer 。\n1.未传或 <= 0，用最新版。 “@order”:”version-“\n2.已传且 > 0，用version以上的可用版本的最低版本。 “@order”:”version+”, “version{}”:”>={version}”',
  `method` varchar(10) DEFAULT 'GETS' COMMENT '只限于GET,HEAD外的操作方法。',
  `tag` varchar(20) NOT NULL COMMENT '标签',
  `structure` json NOT NULL COMMENT '结构。\nTODO 里面的 PUT 改为 UPDATE，避免和请求 PUT 搞混。',
  `detail` varchar(10000) DEFAULT NULL COMMENT '详细说明',
  `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='最好编辑完后删除主键，这样就是只读状态，不能随意更改。需要更改就重新加上主键。\n\n每次启动服务器时加载整个表到内存。\n这个表不可省略，model内注解的权限只是客户端能用的，其它可以保证即便服务端代码错误时也不会误删数据。';

-- 正在导出表  pai-data-manager.Request 的数据：~14 rows (大约)
/*!40000 ALTER TABLE `Request` DISABLE KEYS */;
INSERT INTO `Request` (`id`, `version`, `method`, `tag`, `structure`, `detail`, `date`) VALUES
    (1, 1, 'POST', 'register', '{"User": {"UPDATE": {"id@": "Privacy/id"}, "DISALLOW": "id", "NECESSARY": "name"}, "Privacy": {"UNIQUE": "phone", "VERIFY": {"phone~": "PHONE"}, "DISALLOW": "id", "NECESSARY": "_password,phone"}}', 'UNIQUE校验phone是否已存在。VERIFY校验phone是否符合手机号的格式', '2017-02-01 19:19:51'),
    (4, 1, 'PUT', 'User', '{"INSERT": {"@role": "OWNER"}, "DISALLOW": "phone", "NECESSARY": "id"}', '必须传id，不允许传phone。INSERT当没传@role时用OWNER补全', '2017-02-01 19:19:51'),
    (8, 1, 'PUT', 'User-phone', '{"User": {"INSERT": {"@role": "OWNER"}, "UPDATE": {"@combine": "_password"}, "DISALLOW": "!", "NECESSARY": "id,phone,_password"}}', '! 表示其它所有，这里指necessary所有未包含的字段', '2017-02-01 19:19:51'),
    (14, 1, 'POST', 'Verify', '{"DISALLOW": "!", "NECESSARY": "phone,verify"}', '必须传phone,verify，其它都不允许传', '2017-02-18 22:20:43'),
    (15, 1, 'GETS', 'Verify', '{"NECESSARY": "phone"}', '必须传phone', '2017-02-18 22:20:43'),
    (16, 1, 'HEADS', 'Verify', '{}', '允许任意内容', '2017-02-18 22:20:43'),
    (21, 1, 'HEADS', 'Login', '{"DISALLOW": "!", "NECESSARY": "userId,type"}', NULL, '2017-02-18 22:20:43'),
    (22, 1, 'GETS', 'User', '{}', '允许传任何内容，除了表对象', '2017-02-18 22:20:43'),
    (23, 1, 'PUT', 'Privacy', '{"INSERT": {"@role": "OWNER"}, "NECESSARY": "id"}', 'INSERT当没传@role时用OWNER补全', '2017-02-01 19:19:51'),
    (29, 1, 'GETS', 'login', '{"Privacy": {"DISALLOW": "id", "NECESSARY": "phone,_password"}}', NULL, '2017-10-15 18:04:52'),
    (30, 1, 'PUT', 'balance+', '{"Privacy": {"VERIFY": {"balance+&{}": ">=1,<=100000"}, "DISALLOW": "!", "NECESSARY": "id,balance+"}}', '验证balance+对应的值是否满足>=1且<=100000', '2017-10-21 16:48:34'),
    (31, 1, 'PUT', 'balance-', '{"Privacy": {"UPDATE": {"@combine": "_password"}, "VERIFY": {"balance-&{}": ">=1,<=10000"}, "DISALLOW": "!", "NECESSARY": "id,balance-,_password"}}', 'UPDATE强制把_password作为WHERE条件', '2017-10-21 16:48:34'),
    (32, 2, 'GETS', 'Privacy', '{"INSERT": {"@role": "OWNER"}, "DISALLOW": "_password,_payPassword", "NECESSARY": "id"}', NULL, '2017-06-13 00:05:51'),
    (33, 2, 'GETS', 'Privacy-CIRCLE', '{"Privacy": {"UPDATE": {"@role": "CIRCLE", "@column": "phone"}, "DISALLOW": "!", "NECESSARY": "id"}}', NULL, '2017-06-13 00:05:51');
/*!40000 ALTER TABLE `Request` ENABLE KEYS */;

-- 导出  表 pai-data-manager.Verify 结构
CREATE TABLE IF NOT EXISTS `Verify` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一标识',
  `type` int(11) NOT NULL DEFAULT '0' COMMENT '类型：\n0-登录\n1-注册\n2-修改登录密码\n3-修改支付密码',
  `phone` bigint(20) NOT NULL COMMENT '手机号',
  `verify` int(11) NOT NULL COMMENT '验证码',
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1586707565183 DEFAULT CHARSET=utf8;

-- 正在导出表  pai-data-manager.Verify 的数据：~2 rows (大约)
/*!40000 ALTER TABLE `Verify` DISABLE KEYS */;
INSERT INTO `Verify` (`id`, `type`, `phone`, `verify`, `date`) VALUES
    (1579406819458, 2, 13000038710, 9601, '2020-01-19 12:06:59'),
    (1586707565181, 1, 13000038710, 1883, '2020-04-13 00:06:05');
/*!40000 ALTER TABLE `Verify` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

文档更新时间: 2022-05-19 17:18 作者：伍润源