/*
Navicat MySQL Data Transfer
Source Server : local_hliedu
Source Server Version : 80014
Source Host : localhost:3306
Source Database : opsoft
Target Server Type : MYSQL
Target Server Version : 80014
File Encoding : 65001
Date: 2019-02-12 12:06:58
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for bs_street
-- ----------------------------
DROP TABLE IF EXISTS `bs_street`;
CREATE TABLE `bs_street` (
`STREET_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增列',
`STREET_CODE` varchar(40) NOT NULL COMMENT '街道代码',
`AREA_CODE` varchar(40) DEFAULT NULL COMMENT '父级区代码',
`STREET_NAME` varchar(50) NOT NULL COMMENT '街道名称',
`SHORT_NAME` varchar(30) NOT NULL COMMENT '简称',
`LNG` varchar(20) DEFAULT NULL COMMENT '经度',
`LAT` varchar(20) DEFAULT NULL COMMENT '纬度',
`SORT` int(6) DEFAULT NULL COMMENT '排序',
`GMT_CREATE` datetime DEFAULT NULL COMMENT '创建时间',
`GMT_MODIFIED` datetime DEFAULT NULL COMMENT '修改时间',
`MEMO` varchar(250) DEFAULT NULL COMMENT '备注',
`DATA_STATE` int(11) DEFAULT NULL COMMENT '状态',
`TENANT_CODE` varchar(32) DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (`STREET_ID`),
KEY `Index_1` (`STREET_CODE`,`TENANT_CODE`)
) ENGINE=InnoDB AUTO_INCREMENT=65536 DEFAULT CHARSET=utf8 COMMENT='街道设置';
-- ----------------------------
-- Records of bs_street
-- ----------------------------
INSERT INTO `bs_street` VALUES ('1', '110101001', '110101', '东华门街道', '东华门街道', '116.409607', '39.917973', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000');
INSERT INTO `bs_street` VALUES ('2', '110101002', '110101', '景山街道', '景山街道', '116.410049', '39.92688', '12', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000');
INSERT INTO `bs_street` VALUES ('3', '110101003', '110101', '交道口街道', '交道口街道', '116.405479', '39.9366', '11', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000');
INSERT INTO `bs_street` VALUES ('4', '110101004', '110101', '安定门街道', '安定门街道', '116.403862', '39.944294', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000');
INSERT INTO `bs_street` VALUES ('5', '110101005', '110101', '北新桥街道', '北新桥街道', '116.424095', '39.942024', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000');
INSERT INTO `bs_street` VALUES ('6', '110101006', '110101', '东四街道', '东四街道', '116.423729', '39.93026', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000');
INSERT INTO `bs_street` VALUES ('7', '110101007', '110101', '朝阳门街道', '朝阳门街道', '116.428055', '39.9188', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000');
INSERT INTO `bs_street` VALUES ('8', '110101008', '110101', '建国门街道', '建国门街道', '116.426224', '39.910351', '10', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000');
INSERT INTO `bs_street` VALUES ('9', '110101009', '110101', '东直门街道', '东直门街道', '116.440498', '39.934071', '8', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000');
INSERT INTO `bs_street` VALUES ('10', '110101010', '110101', '和平里街道', '和平里街道', '116.42347', '39.954552', '9', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000');
INSERT INTO `bs_street` VALUES ('11', '110101011', '110101', '前门街道', '前门街道', '116.40834', '39.898033', '14', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000');
INSERT INTO `bs_street` VALUES ('12', '110101012', '110101', '崇文门外街道', '崇文门外街道', '116.412598', '39.89743', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000');
INSERT INTO `bs_street` VALUES ('13', '110101013', '110101', '东花市街道', '东花市街道', '116.429489', '39.899067', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000');
INSERT INTO `bs_street` VALUES ('14', '110101014', '110101', '龙潭街道', '龙潭街道', '116.436722', '39.887169', '13', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000');
INSERT INTO `bs_street` VALUES ('15', '110101015', '110101', '体育馆路街道', '体育馆路街道', '116.418755', '39.917545', '16', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000');
INSERT INTO `bs_street` VALUES ('16', '110101016', '110101', '天坛街道', '天坛街道', '116.40004', '39.889736', '15', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000');
INSERT INTO `bs_street` VALUES ('17', '110101017', '110101', '永定门外街道', '永定门外街道', '116.401382', '39.866001', '17', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000');
INSERT INTO `bs_street` VALUES ('18', '110102001', '110102', '西长安街街道', '西长安街街道', '116.366791', '39.91531', '13', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000');
INSERT INTO `bs_street` VALUES ('19', '110102003', '110102', '新街口街道', '新街口街道', '116.370972', '39.943054', '12', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000');
INSERT INTO `bs_street` VALUES ('20', '110102007', '110102', '月坛街道', '月坛街道', '116.344398', '39.915092', '14', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000');
INSERT INTO `bs_street` VALUES ('21', '110102009', '110102', '展览路街道', '展览路街道', '116.366791', '39.91531', '15', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000');
INSERT INTO `bs_street` VALUES ('22', '110102010', '110102', '德胜街道', '德胜街道', '116.366791', '39.91531', '4', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000');
INSERT INTO `bs_street` VALUES ('23', '110102011', '110102', '金融街街道', '金融街街道', '116.366791', '39.91531', '7', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000');
INSERT INTO `bs_street` VALUES ('24', '110102012', '110102', '什刹海街道', '什刹海街道', '116.366791', '39.91531', '9', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000');
INSERT INTO `bs_street` VALUES ('25', '110102013', '110102', '大栅栏街道', '大栅栏街道', '116.39399', '39.893547', '3', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000');
INSERT INTO `bs_street` VALUES ('26', '110102014', '110102', '天桥街道', '天桥街道', '116.386925', '39.884876', '11', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000');
INSERT INTO `bs_street` VALUES ('27', '110102015', '110102', '椿树街道', '椿树街道', '116.375763', '39.899055', '2', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000');
INSERT INTO `bs_street` VALUES ('28', '110102016', '110102', '陶然亭街道', '陶然亭街道', '116.380646', '39.883484', '10', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000');
INSERT INTO `bs_street` VALUES ('29', '110102017', '110102', '广安门内街道', '广安门内街道', '116.362999', '39.889526', '5', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000');
INSERT INTO `bs_street` VALUES ('30', '110102018', '110102', '牛街街道', '牛街街道', '116.366791', '39.91531', '8', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000');
INSERT INTO `bs_street` VALUES ('31', '110102019', '110102', '白纸坊街道', '白纸坊街道', '116.363579', '39.877087', '1', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000');
INSERT INTO `bs_street` VALUES ('32', '110102020', '110102', '广安门外街道', '广安门外街道', '116.340057', '39.890453', '6', '2019-02-28 17:16:58', '2019-02-28 17:17:05', '', '1', '00000000');
INSERT INTO `bs_street` VALUES ('33', '110105001', '110105', '建外街道', '建外街道', '116.486412', '39.92149', '18'