美文网首页
API FOR REST

API FOR REST

作者: 秦淮河的风 | 来源:发表于2016-07-26 10:04 被阅读0次

    1. 海警

    1.1. 查询海警信息记录

    URL：

    http://127.0.0.1:8096/haijing/

    Request Type：

    get

    Example：

    输入
    .GET /ais/ HTTP/1.1
Host: 127.0.0.1:8096
Cache-Control: no-cache
Postman-Token: 5f2fd9d3-c9d0-b1fe-97aa-8f43177542a2
    海警查询输入
    输出
    {
    "flag": 0,
    "data": [
        {
            "id": 1,
            "latitude": 128.123,
            "longitude": 32.001,
            "updated": "2016-07-24 18:00:09",
            "status": 0,
            "shipno": "No.55243852",
            "cdma": "18950826997",
            "inmc": "INMC.07026",
            "speed": 18,
            "heading": 258
        }
    ]
}
    海警查询输出

    1.2. 批量插入海警信息记录

    URL：

    http://127.0.0.1:8096/haijing/create/

    Request Type：

    post

    Example：

    输入
    POST /ais/create/ HTTP/1.1
Host: 127.0.0.1:8096
Content-Type: application/json
Cache-Control: no-cache
Postman-Token: 4084ec6a-0ee2-e32a-f4ef-6417f94589c1
[
        {
            "latitude": 128.123,   //纬度  DECIMAL(20,16) 
            "longitude": 32.001, //经度 DECIMAL(20,16)
            "updated": "2016-07-24 18:00:09", //更新时间 DATETIME
            "status": 0, //不需要关注，可选
            "shipno": "No.55243852",  //船只编号 VARCHAR(50)
            "cdma": "18950826997",//CDMA编号 VARCHAR(20)
            "inmc": "INMC.07026", //INMC编号 VARCHAR(50)
            "speed": 18,//航速 DECIMAL(8,4)
            "heading": 258//航向  DECIMAL(8,4)
        }
]
    海警批量插入输入
    输出
    {
    "flag": 0,
    "data": [
        {
            "id": 2,
            "latitude": 128.123,
            "longitude": 32.001,
            "updated": "2016-07-24 18:00:09",
            "status": 0,
            "shipno": "No.55243852",
            "cdma": "18950826997",
            "inmc": "INMC.07026",
            "speed": 18,
            "heading": 258
        }
    ]
}
    海警批量插入输出

    1.3. 分页查询海警信息记录

    URL：

    http://127.0.0.1:8096/haijing/page?pn=1&ps=3

    Request Type：

    get

    Example：

    输入
    .GET /ais/ HTTP/1.1
Host: 127.0.0.1:8096
Cache-Control: no-cache
Postman-Token: 5f2fd9d3-c9d0-b1fe-97aa-8f43177542a2
    海警分页查询输入
    输出
    {
    "flag": 0,
    "data": {
        "content": [
            {
                "id": 4,
                "latitude": 128.123,
                "longitude": 32.001,
                "updated": "2016-07-24 18:00:09",
                "status": 1,
                "shipno": "No.55243852",
                "cdma": "18950826997",
                "inmc": "INMC.07026",
                "speed": 18,
                "heading": 258
            },
            {
                "id": 5,
                "latitude": 128.123,
                "longitude": 32.001,
                "updated": "2016-07-24 18:00:09",
                "status": 1,
                "shipno": "No.552438525",
                "cdma": "18950826997",
                "inmc": "INMC.07026",
                "speed": 18,
                "heading": 258
            }
        ],
        "totalPages": 1,
        "totalElements": 2,
        "last": true,
        "size": 3,
        "number": 0,
        "first": true,
        "sort": [
            {
                "direction": "DESC",
                "property": "updated",
                "ignoreCase": false,
                "nullHandling": "NATIVE",
                "ascending": false
            }
        ],
        "numberOfElements": 2
    }
}

    海警分页查询输出

    2. 融合

    2.1. 查询融合信息记录

    URL：

    http://127.0.0.1:8096/ronghe/

    Request Type：

    get

    Example：

    输入
    GET /ais/ HTTP/1.1
Host: 127.0.0.1:8096
Cache-Control: no-cache
Postman-Token: 5f2fd9d3-c9d0-b1fe-97aa-8f43177542a2
    融合查询输入
    输出
    {
    "flag": 0,
    "data": [
        {
            "id": 1,
            "latitude": 125.123,
            "longitude": 33.001,
            "updated": "2016-07-24 18:00:09",
            "status": 0,
            "rongheno": "RH.53273943"
        }
    ]
}
    融合查询输出

    2.2. 批量插入融合信息记录

    URL：

    http://127.0.0.1:8096/ronghe/create/

    Request Type：

    post

    Example：

    输入
    POST /ais/create/ HTTP/1.1
Host: 127.0.0.1:8096
Content-Type: application/json
Cache-Control: no-cache
Postman-Token: 4084ec6a-0ee2-e32a-f4ef-6417f94589c1

 [
        {
            "latitude": 125.123, //纬度  DECIMAL(20,16) 
            "longitude": 33.001, //经度  DECIMAL(20,16) 
            "updated": "2016-07-24 18:00:09", //更新时间 DATETIME
            "status": 0, //不需要关注，可选
            "rongheno": "RH.53273943" //融合编号 VARCHAR(50)
        }
 ]
    融合批量插入输入
    输出
    {
    "flag": 0,
    "data": [
        {
            "id": 2,
            "latitude": 125.123,
            "longitude": 33.001,
            "updated": "2016-07-24 18:00:09",
            "status": 0,
            "rongheno": "RH.53273943"
        }
    ]
}
    融合批量插入输出

    2.3. 分页查询融合信息记录

    URL：

    http://127.0.0.1:8096/ronghe/page?pn=1&ps=3

    Request Type：

    get

    Example：

    输入
    .GET /ais/ HTTP/1.1
Host: 127.0.0.1:8096
Cache-Control: no-cache
Postman-Token: 5f2fd9d3-c9d0-b1fe-97aa-8f43177542a2
    融合信息分页查询输入
    输出
    {
    "flag": 0,
    "data": {
        "content": [
            {
                "id": 3,
                "latitude": 125.123,
                "longitude": 33.001,
                "updated": "2016-07-24 18:00:09",
                "status": 1,
                "rongheno": "RH.53273943"
            }
        ],
        "totalPages": 1,
        "totalElements": 1,
        "last": true,
        "size": 3,
        "number": 0,
        "first": true,
        "sort": [
            {
                "direction": "DESC",
                "property": "updated",
                "ignoreCase": false,
                "nullHandling": "NATIVE",
                "ascending": false
            }
        ],
        "numberOfElements": 1
    }
}

    融合信息分页查询输出

    3. AIS

    3.1. 查询 AIS 信息记录

    URL：

    http://127.0.0.1:8096/ais/

    Request Type：

    get

    Example：

    输入
    GET /ais/ HTTP/1.1
Host: 127.0.0.1:8096
Cache-Control: no-cache
Postman-Token: 5f2fd9d3-c9d0-b1fe-97aa-8f43177542a2
    AIS查询输入
    输出
    {
    "flag": 0,
    "data": [
        {
            "id": 1,
            "latitude": 128.123,
            "longitude": 32.001,
            "updated": "2016-07-24 18:00:09",
            "status": 1,
            "aisno": "hk.8923",
            "shipname": "北极1号",
            "radiocallsign": "pjyo",
            "speed": 19,
            "heading": 279.7,
            "channel": 347.2
        }
    ]
}
    AIS查询输出

    3.2.批量插入 AIS 信息记录

    URL：

    http://127.0.0.1:8096/ais/create/

    Request Type：

    post

    Example：

    输入
    POST /ais/create/ HTTP/1.1
Host: 127.0.0.1:8096
Content-Type: application/json
Cache-Control: no-cache
Postman-Token: 4084ec6a-0ee2-e32a-f4ef-6417f94589c1

[{
    "aisno": "hk.8923", //AIS编号 VARCHAR(50) 
    "shipname": "钓鱼岛1号", //船名 VARCHAR(50) 
    "radiocallsign": "axyx01", //呼号 VARCHAR(50)
    "latitude": 32.001,  //纬度  DECIMAL(20,16) 
    "longitude": 128.123004, //经度 DECIMAL(20,16)
    "speed": 55.245, //航速 DECIMAL(8,4)
    "heading": 220, //航向  DECIMAL(8,4)
    "channel": 110, // 船道向 DECIMAL(8,4)
    "updated": "2016-07-25 00:02:00", //更新时间 DATETIME
    "status": 0 //不需要关注，可选
},{
    "aisno": "hk.8955",
    "shipname": "钓鱼岛5号",
    "radiocallsign": "axyx05",
    "latitude": 32.3432,
    "longitude": 128.1263,
    "speed": 44.12,
    "heading": 105,
    "channel": 85,
    "updated": "2016-07-25 00:02:00",
    "status": 0
}]
    AIS批量插入输入
    输出
    {
    "flag": 0,
    "data": [
        {
            "id": 2,
            "latitude": 32.001,
            "longitude": 128.123004,
            "updated": "2016-07-25 00:02:00",
            "status": 0,
            "aisno": "hk.8923",
            "shipname": "钓鱼岛1号",
            "radiocallsign": "axyx01",
            "speed": 55.245,
            "heading": 220,
            "channel": 110
        },
        {
            "id": 3,
            "latitude": 32.3432,
            "longitude": 128.1263,
            "updated": "2016-07-25 00:02:00",
            "status": 0,
            "aisno": "hk.8955",
            "shipname": "钓鱼岛5号",
            "radiocallsign": "axyx05",
            "speed": 44.12,
            "heading": 105,
            "channel": 85
        }
    ]
}
    AIS批量插入输出

    3.3. 分页查询AIS信息记录

    URL：

    http://127.0.0.1:8096/ais/page?pn=1&ps=3

    Request Type：

    get

    Example：

    输入
    .GET /ais/ HTTP/1.1
Host: 127.0.0.1:8096
Cache-Control: no-cache
Postman-Token: 5f2fd9d3-c9d0-b1fe-97aa-8f43177542a2
    AIS分页查询输入
    输出
    {
    "flag": 0,
    "data": {
        "content": [
            {
                "id": 6,
                "latitude": 128.123,
                "longitude": 32.001,
                "updated": "2016-07-24 18:00:09",
                "status": 1,
                "aisno": "hk.8923",
                "shipname": "北极2号",
                "radiocallsign": "pjyo",
                "speed": 19,
                "heading": 279.7,
                "channel": 347.2
            },
            {
                "id": 7,
                "latitude": 128.123,
                "longitude": 32.001,
                "updated": "2016-07-24 18:00:09",
                "status": 1,
                "aisno": "3",
                "shipname": "北极2号",
                "radiocallsign": "pjyo",
                "speed": 19,
                "heading": 279.7,
                "channel": 347.2
            },
            {
                "id": 9,
                "latitude": 128.123,
                "longitude": 32.001,
                "updated": "2016-07-24 18:00:09",
                "status": 1,
                "aisno": "5",
                "shipname": "北极2号",
                "radiocallsign": "pjyo",
                "speed": 19,
                "heading": 279.7,
                "channel": 347.2
            }
        ],
        "totalPages": 2,
        "totalElements": 5,
        "last": false,
        "size": 3,
        "number": 0,
        "first": true,
        "sort": [
            {
                "direction": "DESC",
                "property": "updated",
                "ignoreCase": false,
                "nullHandling": "NATIVE",
                "ascending": false
            }
        ],
        "numberOfElements": 3
    }
}

    AIS分页查询输出

    4. 雷达

    4.1 查询雷达信息记录

    URL：

    http://127.0.0.1:8096/radar/

    Request Type：

    get

    Example：

    输入
    GET /ais/ HTTP/1.1
Host: 127.0.0.1:8096
Cache-Control: no-cache
Postman-Token: 5f2fd9d3-c9d0-b1fe-97aa-8f43177542a2
    雷达查询输入
    输出
    {
    "flag": 0,
    "data": [
        {
            "id": 1,
            "latitude": 128.123,
            "longitude": 33.001,
            "updated": "2016-07-24 18:00:09",
            "status": 0,
            "radarno": "No.99_5",
            "radarposition": "psvnaexvc",
            "direction": "257.3300",
            "distance": "1.4998213081",
            "speed": 6,
            "heading": 278.5
        }
    ]
}
    雷达查询输出

    4.2.批量插入雷达信息记录

    URL：

    http://127.0.0.1:8096/radar/create/

    Request Type：

    post

    Example：

    输入
    POST /ais/create/ HTTP/1.1
Host: 127.0.0.1:8096
Content-Type: application/json
Cache-Control: no-cache
Postman-Token: 4084ec6a-0ee2-e32a-f4ef-6417f94589c1

 [
        {
            "latitude": 128.123, //纬度  DECIMAL(20,16)
            "longitude": 33.001, //经度 DECIMAL(20,16)
            "updated": "2016-07-24 18:00:09", //更新时间 DATETIME
            "status": 0, //不需要关注，可选
            "radarno": "No.99_5", //雷达目标编号 VARCHAR(50)
            "radarposition": "psvnaexvc", //雷达位置 VARCHAR(100)
            "direction": "257.3300", //方位 DECIMAL(8,4)
            "distance": "1.4998213081", //距离 DECIMAL(20,10)
            "speed": 6, //航速 DECIMAL(8,4)
            "heading": 278.5 //航向  DECIMAL(8,4)
        }
]
    雷达批量插入输入
    输出
    {
    "flag": 0,
    "data": [
        {
            "id": 2,
            "latitude": 128.123,
            "longitude": 33.001,
            "updated": "2016-07-24 18:00:09",
            "status": 0, 
            "radarno": "No.99_5",
            "radarposition": "psvnaexvc",
            "direction": "257.3300",
            "distance": "1.4998213081",
            "speed": 6,
            "heading": 278.5
        }
    ]
}
    雷达批量插入输出

    4.3. 分页查询雷达信息记录

    URL：

    http://127.0.0.1:8096/radar/page?pn=1&ps=3

    Request Type：

    get

    Example：

    输入
    .GET /ais/ HTTP/1.1
Host: 127.0.0.1:8096
Cache-Control: no-cache
Postman-Token: 5f2fd9d3-c9d0-b1fe-97aa-8f43177542a2
    雷达分页查询输入
    输出
    {
    "flag": 0,
    "data": {
        "content": [
            {
                "id": 4,
                "latitude": 128.123,
                "longitude": 33.001,
                "updated": "2016-07-24 18:00:09",
                "status": 1,
                "radarno": "No.99_5",
                "radarposition": "psvnaexvc",
                "direction": "257.3300",
                "distance": "1.4998213081",
                "speed": 4446,
                "heading": 278.5
            }
        ],
        "totalPages": 1,
        "totalElements": 1,
        "last": true,
        "size": 3,
        "number": 0,
        "first": true,
        "sort": [
            {
                "direction": "DESC",
                "property": "updated",
                "ignoreCase": false,
                "nullHandling": "NATIVE",
                "ascending": false
            }
        ],
        "numberOfElements": 1
    }
}
    雷达分页查询输出

    5. 雷达站

    5.1 查询雷达站信息记录

    URL：

    http://127.0.0.1:8096/radarstation/listall

    Request Type：

    get

    Example：

    输入
    
![Uploading Paste_Image_094020.png . . .]
GET /ais/ HTTP/1.1
Host: 127.0.0.1:8096
Cache-Control: no-cache
Postman-Token: 5f2fd9d3-c9d0-b1fe-97aa-8f43177542a2
    雷达站查询输入
    输出
    {
    "flag": 0,
    "data": [
        {
            "id": 1,
            "latitude": 20.418083,
            "longitude": 109.91086,
            "updated": "2016-08-09 10:03:28",
            "status": 1,
            "radarstationno": "001",
            "name": "湛江流沙雷达站",
            "camerano": "1",
            "radius": 100,
            "remark": "湛江流沙雷达站"
        },
        {
            "id": 2,
            "latitude": 22.238566,
            "longitude": 113.5779,
            "updated": "2016-08-09 10:03:28",
            "status": 1,
            "radarstationno": "002",
            "name": "珠海雷达站",
            "camerano": "1",
            "radius": 110,
            "remark": "珠海雷达站"
        },
        {
            "id": 3,
            "latitude": 22.5969,
            "longitude": 114.337783,
            "updated": "2016-08-09 10:03:28",
            "status": 0,
            "radarstationno": "003",
            "name": "深圳背仔角雷达站",
            "camerano": "1",
            "radius": 110,
            "remark": "深圳背仔角雷达站"
        },
        {
            "id": 4,
            "latitude": 22.611716,
            "longitude": 114.40225,
            "updated": "2016-08-09 10:03:28",
            "status": 1,
            "radarstationno": "004",
            "name": "深圳土洋雷达站",
            "camerano": "1",
            "radius": 110,
            "remark": "深圳土洋雷达站"
        },
        {
            "id": 5,
            "latitude": 22.50075,
            "longitude": 114.47915,
            "updated": "2016-08-09 10:03:28",
            "status": 1,
            "radarstationno": "005",
            "name": "深圳羊筹角雷达站",
            "camerano": "1",
            "radius": 110,
            "remark": "深圳羊筹角雷达站"
        },
        {
            "id": 6,
            "latitude": 23.336116,
            "longitude": 116.7451,
            "updated": "2016-08-09 12:03:28",
            "status": 1,
            "radarstationno": "006",
            "name": "汕头妈屿岛雷达站",
            "camerano": "1",
            "radius": 100,
            "remark": "汕头妈屿岛雷达站"
        },
        {
            "id": 7,
            "latitude": 23.45703,
            "longitude": 116.97708,
            "updated": "2016-08-09 10:03:28",
            "status": 1,
            "radarstationno": "007",
            "name": "汕头南澳岛雷达站",
            "camerano": "1",
            "radius": 120,
            "remark": "汕头南澳岛雷达站"
        }
    ]
}

    ![雷达查询输出]](https://img.haomeiwen.com/i2578430/cd9076df1f219173.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240))

    4.2.批量插入雷达站信息记录

    URL：

    http://127.0.0.1:8096/radarstation/create/

    Request Type：

    post

    Example：

    输入
    POST /ais/create/ HTTP/1.1
Host: 127.0.0.1:8096
Content-Type: application/json
Cache-Control: no-cache
Postman-Token: 4084ec6a-0ee2-e32a-f4ef-6417f94589c1

 [
        {
            "latitude": 23.45703,   //纬度  DECIMAL(20,16)
            "longitude": 116.97708, //经度 DECIMAL(20,16)
            "updated": "2016-08-09 10:03:28", //更新时间 DATETIME
            "status": 1, //不需要关注，可选 INT
            "radarstationno": "007", //雷达站编号 VARCHAR(50)
            "name": "汕头南澳岛雷达站",//雷站达名称 VARCHAR(50)
            "camerano": "1", //摄像头编号 VARCHAR(20) 
            "radius": 120, // 半径 DECIMAL(8,4)
            "remark": "汕头南澳岛雷达站" //描述 VARCHAR(100)
        }
]
    雷达站批量插入输入
    输出
    {
    "flag": 0,
    "data": [
        {
            "id": 8,
            "latitude": 23.45703,
            "longitude": 116.97708,
            "updated": "2016-08-09 10:03:28",
            "status": 1,
            "radarstationno": "007",
            "name": "汕头南澳岛雷达站2",
            "camerano": "1",
            "radius": 120,
            "remark": "汕头南澳岛雷达站2"
        }
    ]
}
    雷达站批量插入输出

    6. MYSQl脚本

    CREATE SCHEMA `coast` DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;

#海警
DROP TABLE IF EXISTS `coast`.`t_haijing`;
CREATE TABLE `coast`.`t_haijing` (
  `id` INT NOT NULL auto_increment,
  `shipNo` VARCHAR(50) NOT NULL,
  `CDMA` VARCHAR(20) NULL,
  `INMC` VARCHAR(50) NULL,
  `latitude` DECIMAL(20,16) NULL,
  `longitude` DECIMAL(20,16) NULL,
  `speed` DECIMAL(8,4) NULL,
  `heading` DECIMAL(8,4) NULL,
  `updated` DATETIME NOT NULL,
  `status` INT NOT NULL,
  PRIMARY KEY (`id`)
  )
ENGINE = InnoDB DEFAULT CHARACTER SET = gbk;
#ALTER TABLE `t_haijing` DROP INDEX index_haijing;
ALTER TABLE `t_haijing` ADD INDEX index_haijing (`updated`);
ALTER TABLE `t_haijing` ADD INDEX index_no (`shipNo`);

#融合
DROP TABLE IF EXISTS `coast`.`t_ronghe`;
CREATE TABLE `coast`.`t_ronghe` (
  `id` INT NOT NULL auto_increment,
  `rongheNo` VARCHAR(50) NOT NULL,
  `latitude` DECIMAL(20,16) NULL,
  `longitude` DECIMAL(20,16) NULL,
  `updated` DATETIME NOT NULL,
  `status` INT NOT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = gbk;
#ALTER TABLE `t_ronghe` DROP INDEX index_ronghe;
ALTER TABLE `t_ronghe` ADD INDEX index_ronghe ( `updated`);
ALTER TABLE `t_ronghe` ADD INDEX index_no ( `rongheNo`);

#AIS
DROP TABLE IF EXISTS `coast`.`t_ais`;
CREATE TABLE `coast`.`t_ais` (
  `id` INT NOT NULL auto_increment,
  `aisNo` VARCHAR(50) NOT NULL,
  `shipName` VARCHAR(50) NULL,
  `radioCallSign` VARCHAR(50) NULL,
  `latitude` DECIMAL(20,16) NULL,
  `longitude` DECIMAL(20,16) NULL,
  `speed` DECIMAL(8,4) NULL,
  `heading` DECIMAL(8,4) NULL,
  `channel` DECIMAL(8,4) NULL,
  `updated` DATETIME NOT NULL,
  `status` INT NOT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = gbk;
#ALTER TABLE `t_ais` DROP INDEX index_ais;
ALTER TABLE `t_ais` ADD INDEX index_ais ( `updated`);
ALTER TABLE `t_ais` ADD INDEX index_no ( `aisNo`);

#雷达
DROP TABLE IF EXISTS `coast`.`t_radar`;
CREATE TABLE `coast`.`t_radar` (
  `id` INT NOT NULL auto_increment,
  `radarNo` VARCHAR(50) NOT NULL,
  `radarPosition` VARCHAR(100) NULL,
  `direction` DECIMAL(8,4) NULL,
  `distance` DECIMAL(20,10) NULL,
  `latitude` DECIMAL(20,16) NULL,
  `longitude` DECIMAL(20,16) NULL,
  `speed` DECIMAL(8,4) NULL,
  `heading` DECIMAL(8,4) NULL,
  `updated` DATETIME NOT NULL,
  `status` INT NOT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = gbk;
#ALTER TABLE `t_radar` DROP INDEX index_radar;
ALTER TABLE `t_radar` ADD INDEX index_radar (`updated`);
ALTER TABLE `t_radar` ADD INDEX index_no ( `radarNo`);

#雷达站
DROP TABLE IF EXISTS `coast`.`t_radar_station`;
CREATE TABLE `coast`.`t_radar_station` (
  `id` INT NOT NULL auto_increment,
  `radarstationNo` VARCHAR(20) NOT NULL,
  `name` VARCHAR(50) NOT NULL,
  `latitude` DECIMAL(20,16) NULL,
  `longitude` DECIMAL(20,16) NULL,
  `radius` DECIMAL(8,4) NULL,
  `remark` VARCHAR(100) NULL,
  `updated` DATETIME NOT NULL,
  `status` INT NOT NULL,
  `cameraNo` VARCHAR(20) NOT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = gbk;
ALTER TABLE `t_radar_station` ADD INDEX index_radar_station (`updated`);
ALTER TABLE `t_radar_station` ADD INDEX index_no ( `radarstationNo`);
#ALTER TABLE `t_radar_station` DROP INDEX index_no;

#支队信息
DROP TABLE IF EXISTS `coast`.`t_team_region`;
CREATE TABLE `coast`.`t_team_region` (
  `id` INT NOT NULL auto_increment,
  `objId` INT NOT NULL,
  `order` INT NOT NULL,
  `latitude` DECIMAL(20,16) NULL,
  `longitude` DECIMAL(20,16) NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = gbk;

#图层控制管理对象关系
DROP TABLE IF EXISTS `coast`.`t_opt_relation`;
CREATE TABLE `coast`.`t_opt_relation` (
  `id` INT NOT NULL auto_increment,
  `name` VARCHAR(50) NOT NULL,
  `parentId` INT NULL,
  `tableName` VARCHAR(200) NULL,
  `objId` INT NULL,
  `isLeaf` INT NULL,
  `desc` VARCHAR(500) NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = gbk;

    相关文章

      网友评论

          本文标题：API FOR REST

          本文链接：https://www.haomeiwen.com/subject/tqsnjttx.html

          延伸阅读

          深度阅读

          • 您也可以注册成为美文阅读网的作者，发表您的原创作品、分享您的心情！

          栏目导航

          热点阅读

          关于我们|服务条款|联系我们|API FOR REST|投稿指南|网站地图|RSS订阅|排版工具|手机版

          提供经典美文摘抄,优美散文欣赏,现代诗歌精选,短篇小说,心情随笔,表白情书范文,故事会在线阅读欣赏

          Copyright © 2014-2023 Haomeiwen.com All Rights Reserved. 好美文阅读网 版权所有

          备案信息：桂公网安备 45052102000051号 · 桂ICP备13007215号-3

          本站所收录作品、热点评论等信息部分来源互联网，目的只是为了系统归纳学习和传递资讯

          所有作品版权归原创作者所有，与本站立场无关，如不慎侵犯了你的权益，请联系我们告知，我们将做删除处理！