证件类型及编码含义
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);