【全国行政区划对应表】administrative_division_code.sql

身份证各个字段对应的省市区等行政划分： CREATE TABLE `administrative_division_code` ( `sno` int(11) NOT NULL, `province_id` int(2) NOT NULL COMMENT '省级代码(前两位)', `city_id` int(4) NOT NULL COMMENT '地市级代码(前4位)', `district_id` int(6) NOT NULL COMMENT '县区级代码(前6位)', `province_name` varchar(50) NOT NULL COMMENT '省级全称', `province_name_ab` varchar(10) NOT NULL COMMENT '省级简称', `city_name` varchar(50) NOT NULL COMMENT '地市级名称', `district_name` varchar(50) DEFAULT NULL COMMENT '区县级名称', `remark` varchar(1000) DEFAULT NULL COMMENT '备注', `flag` int(1) NOT NULL DEFAULT '1' COMMENT '大陆区划', PRIMARY KEY (`sno`), KEY `idx_adc_province_id` (`province_id`) USING BTREE, KEY `idx_adc_city_id` (`city_id`) USING BTREE, KEY `idx_adc_district_id` (`district_id`) USING BTREE )