- 博客(0)
- 资源 (1)
- 收藏
- 关注
身份证号对应归属地sql文件
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',
2018-03-22
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人