/*
Navicat Premium Data Transfer
Source Server : localhost_3306
Source Server Type : MySQL
Source Server Version : 80019
Source Host : localhost:3306
Source Schema : ry-vue
Target Server Type : MySQL
Target Server Version : 80019
File Encoding : 65001
Date: 19/03/2020 15:24:47
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for t_area
-- ----------------------------
DROP TABLE IF EXISTS `t_area`;
CREATE TABLE `t_area` (
`id` bigint(0) NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`is_child` double NULL DEFAULT NULL,
`level` tinyint(0) NULL DEFAULT NULL,
`pid` bigint(0) NULL DEFAULT NULL,
`ancestors` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`sort` int(0) NULL DEFAULT NULL,
`longitude` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`latitude` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`type` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0',
`del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0',
`create_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`create_time` datetime(0) NULL DEFAULT NULL,
`update_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`update_time` datetime(0) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '地区信息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_area
-- ----------------------------
INSERT INTO `t_area` VALUES (1, '中国', 1, 1, 0, '0', 1, '104.114129', '37.550339', NULL, '0', '0', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (2, '北京市', 1, 2, 1, '0,1', 1, '116.39564503788', '39.92998577808', '城市', '0', '2', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (3, '天津市', 1, 2, 1, '0,1', 2, '117.21081309155', '39.14392990331', '城市', '0', '2', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (4, '河北省', 1, 2, 1, '0,1', 3, '115.66143362422', '38.613839749251', '省', '0', '2', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (5, '山西省', 1, 2, 1, '0,1', 4, '112.51549586384', '37.866565990509', '省', '0', '2', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (6, '内蒙古自治区', 1, 2, 1, '0,1', 5, '114.41586754817', '43.468238221949', '省', '0', '2', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (7, '辽宁省', 1, 2, 1, '0,1', 6, '122.75359155772', '41.621600105958', '省', '0', '2', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (8, '吉林省', 1, 2, 1, '0,1', 7, '126.26287593078', '43.678846185241', '省', '0', '2', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (9, '黑龙江省', 1, 2, 1, '0,1', 8, '128.04741371499', '47.356591643111', '省', '0', '2', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (10, '上海市', 1, 2, 1, '0,1', 9, '121.48789948569', '31.249161710015', '城市', '0', '2', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (11, '江苏省', 1, 2, 1, '0,1', 10, '119.36848893836', '33.013797169954', '省', '0', '2', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (12, '浙江省', 1, 2, 1, '0,1', 11, '119.95720242066', '29.159494120761', '省', '0', '2', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (13, '安徽省', 1, 2, 1, '0,1', 12, '117.21600520757', '31.859252417079', '省', '0', '2', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (14, '福建省', 1, 2, 1, '0,1', 13, '117.98494311991', '26.050118295661', '省', '0', '2', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (15, '江西省', 1, 2, 1, '0,1', 14, '115.6760823667', '27.757258443441', '省', '0', '2', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (16, '山东省', 1, 2, 1, '0,1', 15, '118.52766339288', '36.099289929728', '省', '0', '0', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (17, '河南省', 1, 2, 1, '0,1', 16, '113.48680405753', '34.157183767956', '省', '0', '2', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (18, '湖北省', 1, 2, 1, '0,1', 17, '112.41056219213', '31.20931625014', '省', '0', '2', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (19, '湖南省', 1, 2, 1, '0,1', 18, '111.72066354648', '27.695864052356', '省', '0', '2', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (20, '广东省', 1, 2, 1, '0,1', 19, '113.39481755876', '23.408003729025', '省', '0', '2', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (21, '广西壮族自治区', 1, 2, 1, '0,1', 20, '108.92427442706', '23.552254688119', '省', '0', '2', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (22, '海南省', 1, 2, 1, '0,1', 21, '109.73375548794', '19.180500801261', '省', '0', '2', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (23, '重庆市', 1, 2, 1, '0,1', 22, '106.53063501341', '29.544606108886', '城市', '0', '2', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (24, '四川省', 1, 2, 1, '0,1', 23, '102.8991597236', '30.367480937958', '省', '0', '2', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (25, '贵州省', 1, 2, 1, '0,1', 24, '106.7349961033', '26.902825927797', '省', '0', '2', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (26, '云南省', 1, 2, 1, '0,1', 25, '101.59295163701', '24.864212795483', '省', '0', '2', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (27, '西藏自治区', 1, 2, 1, '0,1', 26, '89.137981684031', '31.367315402715', '省', '0', '2', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (28, '陕西省', 1, 2, 1, '0,1', 27, '109.50378929073', '35.860026261323', '省', '0', '2', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (29, '甘肃省', 1, 2, 1, '0,1', 28, '102.45762459934', '38.103267343752', '省', '0', '2', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (30, '青海省', 1, 2, 1, '0,1', 29, '96.202543672261', '35.499761004275', '省', '0', '2', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (31, '宁夏回族自治区', 1, 2, 1, '0,1', 30, '106.15548126505', '37.321323112295', '省', '0', '2', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (32, '新疆维吾尔自治区', 1, 2, 1, '0,1', 31, '85.614899338339', '42.127000957642', '省', '0', '2', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (33, '新疆建设兵团', 1, 2, 1, '0,1', 32, '', '', '', '0', '2', NULL, '2015-03-27 16:31:40', NULL, NULL);
INSERT INTO `t_area` VALUES (34, '黑龙江垦区', 1, 2, 1, '0,1', 33, '', '', '', '0', '2', NULL, '2015-03-27 16:32:37', NULL, NULL);
INSERT INTO `t_area` VALUES (35, '广东农垦', 1, 2, 1, '0,1', 34, '', '', '', '0', '2', NULL, '2015-03-27 16:32:51', NULL, NULL);
INSERT INTO `t_area` VALUES (36, '朝阳区', 1, 3, 2, '0,1,2', 1, '116.52169489108', '39.958953166407', '区县', '0', '2', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (37, '海淀区', 1, 3, 2, '0,1,2', 2, '116.23967780102', '40.033162045078', '区县', '0', '2', NULL, '2014-09-22 14:32:17', NULL, NULL);
INSERT INTO `t_area` VALUES (38, '东城区', 1, 3, 2, '0,1,2', 3, '116.42188470126', '39.938574012986', '区�
