首页 > 学术百科

证件类型及编码含义

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

本文发布于:2024-09-20 14:19:38，感谢您对本站的认可！

本文链接：https://www.17tex.com/xueshu/818162.html

上一篇：万能身份证号(UniversalIDnumber)

下一篇：查看证照——精选推荐

标签：来往居民证件类型编码含义内地

留言与评论（共有 0 条评论）