【文件属性】:
文件名称:身份证号对应归属地sql文件
文件大小:522KB
文件格式:SQL
更新时间:2021-04-11 11:09:28
身份证 省市区
DROP TABLE IF EXISTS `bclp_identity_card`;
CREATE TABLE `bclp_identity_card` (
`id` int(22) NOT NULL AUTO_INCREMENT,
`number` varchar(50) DEFAULT NULL COMMENT '身份证前6位',
`address` varchar(50) DEFAULT NULL COMMENT '归属地',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP,
`create_id` varchar(50) DEFAULT NULL,
`update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
`update_id` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3554 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of bclp_identity_card
-- ----------------------------
INSERT INTO `bclp_identity_card` VALUES ('2', '110000', '北京市', '2018-03-21 11:05:54', 'sys', '2018-03-21 11:15:19', null);
INSERT INTO `bclp_identity_card` VALUES ('3', '110100', '北京市市辖区', '2018-03-21 11:05:54', 'sys', '2018-03-21 11:15:19', null);
INSERT INTO `bclp_identity_card` VALUES ('4', '110101', '北京市东城区', '2018-03-21 11:05:54', 'sys', '2018-03-21 11:15:19', null);
INSERT INTO `bclp_identity_card` VALUES ('5', '110102', '北京市西城区', '2018-03-21 11:05:54', 'sys', '2018-03-21 11:15:19', null);
INSERT INTO `bclp_identity_card` VALUES ('6', '110103', '北京市崇文区', '2018-03-21 11:05:54', 'sys', '2018-03-21 11:15:19', null);
INSERT INTO `bclp_identity_card` VALUES ('7', '110104', '北京市宣武区', '2018-03-21 11:05:55',