证件类型及编码含义

 

DESCRIPTION   VALUE        INTVALUE  
身份证        IDCARD       100001
军人证       ARMYMANCARD   100002
护照         PASSPORT      100003
户口本     PERMANENTRESIDENT   100004
外国人永久居留证    FOREIGN   100005
武警证     POLICECARD        100006
公章   CACHET   100007
工商营业执照   BusinessLicense  100008
法人代码证  CorporationID   100009
学生证   STUDENTCARD   100010
士兵证   SOLDIERCARD   100011
港澳居民来往内地通行证   GAJMLW    100016
台湾居民来往大陆通行证   TWJMLW    100017
其他证件类型 QTZJLX   100018

CREATE TABLE `certificate_type` (
  `id` int(11) NOT NULL auto_increment COMMENT '编号',
  `value` varchar(50) collate utf8_unicode_ci default NULL,
  `description` varchar(50) collate utf8_unicode_ci default NULL,
  `intvalue` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

 

 

 

 

INSERT INTO `certificate_type` (`id`, `value`, `description`, `intvalue`) VALUES (1, 'IDCARD', '身份证', 100001);
INSERT INTO `certificate_type` (`id`, `value`, `description`, `intvalue`) VALUES (2, 'ARMYMANCARD', '军人证 ', 100002);
INSERT INTO `certificate_type` (`id`, `value`, `description`, `intvalue`) VALUES (3, 'PASSPORT', '护照', 100003);
INSERT INTO `certificate_type` (`id`, `value`, `description`, `intvalue`) VALUES (4, 'PERMANENTRESIDENT', '户口本', 100004);
INSERT INTO `certificate_type` (`id`, `value`, `description`, `intvalue`) VALUES (5, 'FOREIGN', '外国人永久居留证', 100005);
INSERT INTO `certificate_type` (`id`, `value`, `description`, `intvalue`) VALUES (6, 'POLICECARD', '武警证', 100006);
INSERT INTO `certificate_type` (`id`, `value`, `description`, `intvalue`) VALUES (7, 'CACHET', '公章', 100007);
INSERT INTO `certificate_type` (`id`, `value`, `description`, `intvalue`) VALUES (8, 'BusinessLicense', '工商营业执照', 100008);
INSERT INTO `certificate_type` (`id`, `value`, `description`, `intvalue`) VALUES (9, ' CorporationID', '法人代码证', 100009);
INSERT INTO `certificate_type` (`id`, `value`, `description`, `intvalue`) VALUES (10, 'STUDENTCARD', '学生证 ', 100010);
INSERT INTO `certificate_type` (`id`, `value`, `description`, `intvalue`) VALUES (11, 'SOLDIERCARD', '士兵证', 100011);
INSERT INTO `certificate_type` (`id`, `value`, `description`, `intvalue`) VALUES (12, 'GAJMLW', '港澳居民来往内地通行证', 100016);
INSERT INTO `certificate_type` (`id`, `value`, `description`, `intvalue`) VALUES (13, 'TWJMLW', '台湾居民来往大陆通行证', 100017);
INSERT INTO `certificate_type` (`id`, `value`, `description`, `intvalue`) VALUES (14, 'QTZJLX', '其他证件类型', 100018);

 

转载于:https://www.cnblogs.com/liuhongfeng/p/4981472.html