wlyy2.0/svr/svr-iot/sql-scripts/body_health_data_es.txt

创建索引
POST  http://172.26.0.112:9200/body_health_data

给索引加mapping
POST http://172.26.0.112:9200/body_health_data/signs_data/_mapping
{
    "signs_data": {
        "properties": {
            "device_name": {
                "type": "string",
                "index": "not_analyzed"
            },
            "del": {
                "type": "string",
                "index": "not_analyzed"
            },
            "rid": {
                "type": "string",
                "index": "not_analyzed"
            },
            "status": {
                "type": "string",
                "index": "not_analyzed"
            },
            "measure_data": {
                "properties": {
                    "type": {
                        "type": "string",
                        "index": "not_analyzed"
                    },
                    "measure_time": {
                        "type": "string",
                        "index": "not_analyzed"
                    },
                     "sign_name": {
                         "type": "string",
                         "index": "not_analyzed"
                     },
                     "sign_value": {
                         "type": "string",
                         "index": "not_analyzed"
                     },
                     "sign_unit": {
                         "type": "string",
                         "index": "not_analyzed"
                     },
                      "explain": {
                          "type": "string",
                          "index": "not_analyzed"
                      },
                      "filepath": {
                          "type": "string",
                          "index": "not_analyzed"
                      },
                      "reference": {
                          "type": "string",
                          "index": "not_analyzed"
                      }
                }
            },
            "position_data": {
                "properties": {
                    "location": {
                        "type": "geo_point"
                    },
                    "altitude": {
                        "type": "string",
                        "index": "not_analyzed"
                    },
                    "position": {
                        "type": "string",
                        "index": "not_analyzed"
                    }
                }
            },
            "device_model": {
                "type": "string",
                "index": "not_analyzed"
            },
            "ext_code": {
                "type": "string",
                "index": "not_analyzed"
            },
            "idcard": {
                "type": "string",
                "index": "not_analyzed"
            },
            "idcard_type": {
                "type": "string",
                "index": "not_analyzed"
            },
            "sn": {
                "type": "string",
                "index": "not_analyzed"
            },
            "usercode": {
                "type": "string",
                "index": "not_analyzed"
            },
            "data_source": {
                "type": "string",
                "index": "not_analyzed"
            },
            "username": {
                "type": "string",
                "index": "not_analyzed"
            }
        }
    }
}