/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES tis620 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
DROP TABLE IF EXISTS `person_vaccine`;
CREATE TABLE `person_vaccine` (
  `person_vaccine_id` int(11) NOT NULL,
  `vaccine_name` varchar(150) NOT NULL,
  `vaccine_code` varchar(20) DEFAULT NULL,
  `vaccine_group` varchar(20) DEFAULT NULL,
  `export_vaccine_code` varchar(10) DEFAULT NULL,
  `hos_guid` varchar(38) DEFAULT NULL,
  `combine_vaccine` char(1) DEFAULT NULL,
  `icode` varchar(7) DEFAULT NULL,
  `update_moph_registry` char(1) DEFAULT NULL,
  `require_plan` char(1) DEFAULT NULL,
  `vaccine_route_id` int(11) DEFAULT NULL,
  `report_name` varchar(200) DEFAULT NULL,
  `active_status` char(1) DEFAULT NULL,
  `vaccine_manufacturer` varchar(25) DEFAULT NULL,
  `dx_icd10` varchar(10) DEFAULT NULL,
  `auto_treatment_plan` char(1) DEFAULT NULL,
  `treatment_plan_type_id` int(11) DEFAULT NULL,
  `use_moph_lot` char(1) DEFAULT NULL,
  `show_serial_lookup` char(1) DEFAULT NULL,
  `def_dose_qty` double(15,2) DEFAULT NULL,
  `def_dose_unit` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`person_vaccine_id`),
  UNIQUE KEY `ix_vaccine_name` (`vaccine_name`),
  KEY `ix_export_vaccine_code` (`export_vaccine_code`),
  KEY `ix_hos_guid` (`hos_guid`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;

LOCK TABLES `person_vaccine` WRITE;
/*!40000 ALTER TABLE `person_vaccine` DISABLE KEYS */;
INSERT INTO `person_vaccine` VALUES
  (1, 'TT ทีที (รหัส101)', 'TT1/dT1', 'dT', '101', '98e1f2ba-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z235', NULL, NULL, NULL, NULL, NULL, NULL),
  (2, '(เลิกใช้งาน)_บาดทะยักเข็มที่ 2', 'TT2/dT2', 'dT', '102', '98e1f51c-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'N', '', 'Z235', NULL, NULL, NULL, NULL, NULL, NULL),
  (3, '(เลิกใช้งาน)_บาดทะยักเข็มที่ 3', 'TT3/dT3', 'dT', '103', '98e1f62a-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'N', '', 'Z235', NULL, NULL, NULL, NULL, NULL, NULL),
  (4, '(เลิกใช้งาน)_บาดทะยักเข็มที่ 4', 'TT4/dT4', 'dT', '104', '98e1f724-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'N', '', 'Z235', NULL, NULL, NULL, NULL, NULL, NULL),
  (5, 'BCG ต่ำกว่า 1 ปี', 'BCG', 'BCG', '010', '98e1f8c8-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z232', NULL, NULL, NULL, NULL, NULL, NULL),
  (6, 'HBV1 ตับอักเสบบี 1 แรกเกิด', 'HBV1', 'HBV', '041', '98e1f9d6-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z246', NULL, NULL, NULL, NULL, NULL, NULL),
  (7, 'HBV2 ตับเอักเสบบี 2 (2เดือน)', 'HBV2', 'HBV', '042', '98e1fabc-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z246', NULL, NULL, NULL, NULL, NULL, NULL),
  (8, 'HBV3 ตับเอักเสบบี 3 (6เดือน)', 'HBV3', 'HBV', '043', '98e1fba2-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z246', NULL, NULL, NULL, NULL, NULL, NULL),
  (9, 'DTP1 ดีทีพี1 (2 เดือน)', 'DTP1', 'DTP', '031', '98e1fc7e-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z271', NULL, NULL, NULL, NULL, NULL, NULL),
  (10, 'DTP2 ดีทีพี2 (4 เดือน)', 'DTP2', 'DTP', '032', '98e1fd64-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z271', NULL, NULL, NULL, NULL, NULL, NULL),
  (11, 'DTP3 ดีทีพี3 (6 เดือน)', 'DTP3', 'DTP', '033', '98e1fe36-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z271', NULL, NULL, NULL, NULL, NULL, NULL),
  (12, 'OPV1 โอพีวี 1 (2เดือน)', 'OPV1', 'OPV', '081', '98e1ff1c-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z240\r\n', NULL, NULL, NULL, NULL, NULL, NULL),
  (13, 'OPV2 โอพีวี 2 (4เดือน)', 'OPV2', 'OPV', '082', '98e1fff8-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z240\r\n', NULL, NULL, NULL, NULL, NULL, NULL),
  (14, 'OPV3 โอพีวี 3 (6เดือน)', 'OPV3', 'OPV', '083', '98e200d4-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z240\r\n', NULL, NULL, NULL, NULL, NULL, NULL),
  (15, 'MMR1 (9 เดือน)', 'MMR', 'MMR', '061', '98e201a6-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z274', NULL, NULL, NULL, NULL, NULL, NULL),
  (16, '(ยกเลิก)_วัคซีน Measle', 'MEAS', 'MEAS', '061', '98e2028c-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'N', '', 'Z274', NULL, NULL, NULL, NULL, NULL, NULL),
  (17, 'DTP4 ดีทีพี กระตุ้น 1 (18เดือน)', 'DTP4', 'DTP', '034', '98e2035e-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z271', NULL, NULL, NULL, NULL, NULL, NULL),
  (18, 'OPV4 กระตุ้น 1 (18เดือน)', 'OPV4', 'OPV', '084', '98e2043a-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z240\r\n', NULL, NULL, NULL, NULL, NULL, NULL),
  (19, 'JE1 ไข้สมองอักเสบเจอี 1 (18เดือน)', 'JE1', 'JE', '051', '98e20516-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z241\r\n', NULL, NULL, NULL, NULL, NULL, NULL),
  (20, 'JE2 ไข้สมองอักเสบเจอี 2 (19เดือน)', 'JE2', 'JE', '052', '98e205f2-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z241\r\n', NULL, NULL, NULL, NULL, NULL, NULL),
  (21, 'JE3 ไข้สมองอักเสบเจอี 3 (30เดือน)', 'JE3', 'JE', '053', '98e206ce-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z241\r\n', NULL, NULL, NULL, NULL, NULL, NULL),
  (22, 'DTP5 ดีทีพี กระตุ้น 2 (48เดือน)', 'DTP5', 'DTP', '035', '98e20ade-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z240\r\n', NULL, NULL, NULL, NULL, NULL, NULL),
  (23, 'OPV5 กระตุ้น 2 (48เดือน)', 'OPV5', 'OPV', '085', '98e20bd8-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z240\r\n', NULL, NULL, NULL, NULL, NULL, NULL),
  (24, 'dTs1 นักเรียนครั้งที่ 1( ป.1)', 'dTs1', 'dT', '021', '98e20cbe-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z235', NULL, NULL, NULL, NULL, NULL, NULL),
  (25, 'dTs2 นักเรียนครั้งที่ 2( ป.1)', 'dTs2', 'dT', '022', '98e20d9a-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z235', NULL, NULL, NULL, NULL, NULL, NULL),
  (26, 'OPVs1 โอพีวีเอส 1 (ป.1)', 'OPVs1', 'OPV', '086', '98e20e76-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z240\r\n', NULL, NULL, NULL, NULL, NULL, NULL),
  (27, '(เลิกใช้งาน)_บาดทะยักเข็มที่ 5', 'TT5/dT5', 'dT', '105', '98e20f5c-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'N', '', 'Z235', NULL, NULL, NULL, NULL, NULL, NULL),
  (28, 'MMRs หัด คางทูม หัดเยอรมัน เอส (ป.1)', 'MMRs', 'MMR', '072', '98e21038-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'N', '', 'Z274', NULL, NULL, NULL, NULL, NULL, NULL),
  (29, 'OPVs2 โอพีวีเอส 2 (ป.1)', 'OPVs2', 'OPV', '087', '98e2111e-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z240\r\n', NULL, NULL, NULL, NULL, NULL, NULL),
  (30, 'OPVs3 โอพีวีเอส 3 (ป.2)', 'OPVs3', 'OPV', '088', '98e211fa-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z240\r\n', NULL, NULL, NULL, NULL, NULL, NULL),
  (31, 'OPVC โอพีวีซี (ช่วงรณรงค์)', 'OPVC', 'OPV', '089', '98e2139e-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z240\r\n', NULL, NULL, NULL, NULL, NULL, NULL),
  (32, 'dTs3 นักเรียนครั้งที่ 3( ป.2)', 'dTs3', 'dT', '023', '98e21542-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z235', NULL, NULL, NULL, NULL, NULL, NULL),
  (33, 'dTs4 นักเรียนครั้งที่ 4( ป.6)', 'dTs4', 'dT', '024', '98e2165a-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z235', NULL, NULL, NULL, NULL, NULL, NULL),
  (34, '(ยกเลิก)_วัคซีนบาดทะยัก หญิงครรภ์ เข็ม 1', 'dTANC 1', 'dT', '201', '98e21740-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'N', '', NULL, NULL, NULL, NULL, '', NULL, NULL),
  (35, '(ยกเลิก)_วัคซีนบาดทะยัก หญิงครรภ์ เข็ม 2', 'dTANC 2', 'dT', '202', '98e21826-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'N', '', NULL, NULL, NULL, NULL, '', NULL, NULL),
  (36, '(ยกเลิก)_วัคซีนบาดทะยัก หญิงครรภ์ เข็ม 3', 'dTANC 3', 'dT', '203', '98e21902-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'N', '', NULL, NULL, NULL, NULL, '', NULL, NULL),
  (37, '(ยกเลิก)_วัคซีนบาดทะยัก หญิงครรภ์ เข็ม 4', 'dTANC 4', 'dT', '204', '98e219de-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'N', '', NULL, NULL, NULL, NULL, '', NULL, NULL),
  (38, '(ยกเลิก)_วัคซีนบาดทะยัก หญิงครรภ์ เข็ม 5', 'dTANC 5', 'dT', '205', '98e21aba-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'N', '', NULL, NULL, NULL, NULL, '', NULL, NULL),
  (39, 'Rabies Vaccine 1 (พิษสุนัขบ้า 1)', 'Rabies Vaccine 1', 'Rabies Vaccine', '111', '98e21ba0-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z242\r\n', NULL, NULL, NULL, NULL, NULL, NULL),
  (40, 'Rabies Vaccine 2 (พิษสุนัขบ้า 2)', 'Rabies Vaccine 2', 'Rabies Vaccine', '112', '98e21c90-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z242\r\n', NULL, NULL, NULL, NULL, NULL, NULL),
  (41, 'Rabies Vaccine 3 (พิษสุนัขบ้า 3)', 'Rabies Vaccine 3', 'Rabies Vaccine', '113', '98e21d6c-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z242\r\n', NULL, NULL, NULL, NULL, NULL, NULL),
  (42, 'Rabies Vaccine 4 (พิษสุนัขบ้า 4)', 'Rabies Vaccine 4', 'Rabies Vaccine', '114', '98e21e7a-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z242\r\n', NULL, NULL, NULL, NULL, NULL, NULL),
  (43, 'Rabies Vaccine 5 (พิษสุนัขบ้า 5)', 'Rabies Vaccine 5', 'Rabies Vaccine', '115', '98e225c8-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z242\r\n', NULL, NULL, NULL, NULL, NULL, NULL),
  (44, 'influenza รหัส 815 (ไข้หวัดใหญ่)', 'Flu', 'Flu', '815', '98e227bc-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z251', NULL, NULL, NULL, '', NULL, NULL),
  (45, '(ยกเลิก)_DTPHB1 (2 เดือน)', 'DTPHB1', 'DTPHB', '091', '98e22974-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'N', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  (46, '(ยกเลิก)_DTPHB2 (4 เดือน)', 'DTPHB2', 'DTPHB', '092', '98e22a82-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'N', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  (47, '(ยกเลิก)_DTPHB3 (6 เดือน)', 'DTPHB3', 'DTPHB', '093', '98e22b68-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'N', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
  (48, 'BCGs (ป.1)', 'BCGs', 'BCG', '011', '98e22c4e-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z232', NULL, NULL, NULL, NULL, NULL, NULL),
  (49, 'MMR2 หัด คามทูม หัดเยอรมัน (1ปี 6เดือน)', 'MMR/MR', 'MMR/MR', '073', '98e22d34-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z274', NULL, NULL, NULL, NULL, NULL, NULL),
  (50, 'JEเชื้อเป็น เข็ม1 (1ปี)', 'LAJE1', 'JE', 'J11', '98e22e38-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z241\r\n', NULL, NULL, NULL, NULL, NULL, NULL),
  (51, 'JEเชื้อเป็น เข็ม2 (2ปีครึ่ง)', 'LAJE2', 'JE', 'J12', '98e22ff0-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z241\r\n', NULL, NULL, NULL, NULL, NULL, NULL),
  (52, 'dT คอตีบบาดทะยัก(20-50 ปี)', 'dTC1', 'dT', '901', '98e231d0-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z235', NULL, NULL, NULL, NULL, NULL, NULL),
  (53, 'MRs หัด หัดเยอรมัน เอส (ป.1)', 'MRs', 'MMR', '075', '98e232fc-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z244', NULL, NULL, NULL, NULL, NULL, NULL),
  (54, 'MRC หัด หัดเยอรมัน ซี (รณรงค์)', 'MRC', 'MRC', '074', '98e233d8-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z244', NULL, NULL, NULL, NULL, NULL, NULL),
  (55, 'MMRC หัด คางทูม หัดเยอรมัน ซี\r\n (รณรงค์)', 'MMRC', 'MMRC', '076', '98e234b4-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z274', NULL, NULL, NULL, NULL, NULL, NULL),
  (56, '(ยกเลิก)_IPV-P โปลิโอชนิดฉีด(4เดือน)', 'IPV-P', 'IPV-P', '401', '98e23590-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z240\r\n', NULL, NULL, NULL, '', NULL, NULL),
  (57, 'HPVs1 (นร.หญิง ป.5)', 'HPVs1', 'HPVs', '310', '98e2366c-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, 1, NULL, 'Y', '', 'Z258\r\n', NULL, NULL, NULL, '', NULL, NULL),
  (58, 'HPVs2 (ห่างเข็มแรกอย่างน้อย 6 เดือน)', 'HPVs2', 'HPVs', '320', '98e2373e-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, 1, NULL, 'Y', '', 'Z258\r\n', NULL, NULL, NULL, '', NULL, NULL),
  (59, 'HPVs+(หญิง 15 ปีขึ้นไป)', 'HPVs+', 'HPVs', '311', '98e23810-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, 1, NULL, 'Y', '', 'Z258\r\n', NULL, NULL, NULL, '', NULL, NULL),
  (60, 'RV2-1 โรต้า (อายุ 2ด.-ไม่เกิด15สัปดาห์)', 'RV2-1', 'RV', 'R11', '98e238ec-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z258\r\n', NULL, NULL, NULL, NULL, NULL, NULL),
  (61, 'RV2-2 โรต้า (อายุ 4ด.-ไม่เกิด32สัปดาห์)', 'RV2-2', 'RV', 'R12', '98e239be-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z258\r\n', NULL, NULL, NULL, NULL, NULL, NULL),
  (62, 'RV3-1 โรต้า (อายุ 2ด.-ไม่เกิด15สัปดาห์)', 'RV3-1', 'RV', 'R21', '98e23bb2-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z258\r\n', NULL, NULL, NULL, NULL, NULL, NULL),
  (63, 'RV3-2 โรต้า (อายุ 4ด.)', 'RV3-2', 'RV', 'R22', '98e23d38-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z258\r\n', NULL, NULL, NULL, NULL, NULL, NULL),
  (64, 'RV3-3 โรต้า (อายุ 6ด.-ไม่เกิด32สัปดาห์)', 'RV3-3', 'RV', 'R23', '98e2433c-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z258\r\n', NULL, NULL, NULL, NULL, NULL, NULL),
  (65, 'HBVs1 ตับอักเสบบี เอส1 (ป.1)', 'HBVs1', 'HBV', '044', '98e24508-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z246\r\n', NULL, NULL, NULL, NULL, NULL, NULL),
  (66, 'HBVs2 ตับอักเสบบี เอส2 (ป.1)', 'HBVs2', 'HBV', '045', '98e24724-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z246\r\n', NULL, NULL, NULL, NULL, NULL, NULL),
  (67, 'HBVs3 ตับอักเสบบี เอส3 (ป.2)', 'HBVs3', 'HBV', '046', '98e24b66-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z246\r\n', NULL, NULL, NULL, NULL, NULL, NULL),
  (68, 'LAJEs1 เจอีเชื้อเป็น เอส1 (ป.1)', 'LAJEs1', 'JE', '054', '98e24d3c-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z241\r\n', NULL, NULL, NULL, NULL, NULL, NULL),
  (69, 'LAJEs2 เจอีเชื้อเป็น เอส2 (ป.2)', 'LAJEs2', 'JE', '055', '98e24ed6-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z241\r\n', NULL, NULL, NULL, NULL, NULL, NULL),
  (70, 'IPVs ไอพีวีเอส (ป.1)', 'IPVs', 'IPV-P', '402', '98e25066-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z240', NULL, NULL, NULL, '', NULL, NULL),
  (71, 'dT ดีที (อายุ 7 ปีขึ้นไป)', 'dT', 'dT', '106', '98e25200-b1af-11e8-945f-00505693bd9b', NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z235', NULL, NULL, NULL, NULL, NULL, NULL),
  (72, 'DTP-HB+HIP 1 (2เดือน)', 'DTPHBHib1', 'DTPHBHib', 'D21', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z271', NULL, NULL, NULL, NULL, NULL, NULL),
  (73, 'DTP-HB+HIP 2 (4เดือน)', 'DTPHBHib2', 'DTPHBHib', 'D22', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z271', NULL, NULL, NULL, NULL, NULL, NULL),
  (74, 'DTP-HB+HIP 3 (6เดือน)', 'DTPHBHib3', 'DTPHBHib', 'D23', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z271', NULL, NULL, NULL, NULL, NULL, NULL),
  (75, 'MRss (น.ศ.แพทย์/สาธารณสุข) รหัส 077', 'MRss', 'MRss', '077', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z244', NULL, NULL, NULL, NULL, NULL, NULL),
  (76, 'HBV (ผู้ใหญ่) รหัส 047', 'HBV', 'HBV', '047', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z246', NULL, NULL, NULL, NULL, NULL, NULL),
  (77, 'ap (วัคซีนไอกรน ผู้ใหญ่) รหัส P41', 'ap', 'ap', 'P41', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z271', NULL, NULL, NULL, NULL, NULL, NULL),
  (78, 'influenza (อื่นๆเช่น วัคซีนที่ฉีดจากเอกชล/จ่ายเอง) รหัส 818', 'Flu', 'Flu', '818', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z251', NULL, NULL, NULL, NULL, NULL, NULL),
  (79, 'influenza (ผู้ประกันตน อายุ 50 ปีขึ้นไป) รหัส 817', 'Flu', 'Flu', '817', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z251', NULL, NULL, NULL, '', NULL, NULL),
  (80, 'Coronavirus AstraZenaca', 'CA1', 'Coronavirus', 'C19', NULL, NULL, '1500724', NULL, 'N', 1, 'XE-FORM-Covid-TAG-A5', 'Y', 'AstraZeneca', 'U119', 'N', NULL, 'Y', NULL, NULL, NULL),
  (81, 'Coronavirus Sinovac', 'CS1', 'Coronavirus', 'C19', NULL, NULL, '1500725', NULL, 'N', 1, 'XE-FORM-Covid-TAG-A5', 'Y', 'Sinovac Life Sciences', 'U119', 'N', NULL, 'Y', NULL, NULL, NULL),
  (82, 'Coronavirus Pfizer', 'CP1', 'Coronavirus', 'C19', NULL, NULL, '1500726', NULL, 'N', 1, 'XE-FORM-Covid-TAG-A5', 'Y', 'Pfizer, BioNTech', 'U119', 'N', NULL, 'Y', NULL, NULL, NULL),
  (83, 'Covid19_Moderna', 'CM1', 'Coronavirus', 'C19', NULL, NULL, '1500730', NULL, 'N', 1, 'XE-FORM-Covid-TAG-A5', 'Y', 'Moderna', 'U119', 'N', NULL, 'Y', NULL, NULL, NULL),
  (84, 'Coronavirus Sinopharm', 'CI1', 'Coronavirus', 'C19', NULL, NULL, NULL, NULL, 'N', 1, 'XE-FORM-Covid-TAG-A5', 'Y', 'Sinopharm', 'U119', 'N', NULL, 'Y', NULL, NULL, NULL);
INSERT INTO `person_vaccine` VALUES
  (85, 'Covid19_Covovax', 'CC1', 'Coronavirus', 'C19', NULL, NULL, NULL, NULL, 'N', 1, 'XE-FORM-Covid-TAG-A5', 'Y', 'Covovax', 'U119', 'N', NULL, 'Y', NULL, NULL, NULL),
  (86, 'IPV1 (2 เดือน)', 'IPV1', 'IPV-P', 'I11', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z240', NULL, NULL, NULL, NULL, NULL, NULL),
  (87, 'IPV2 (4 เดือน)', 'IPV2', 'IPV-P', 'I12', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z240', NULL, NULL, NULL, NULL, NULL, NULL),
  (88, 'IPV3 (6 เดือน)', 'IPV3', 'IPV-P', 'I13', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z240', NULL, NULL, NULL, NULL, NULL, NULL),
  (89, 'IPV4 (18 เดือน)', 'IPV4', 'IPV-P', 'I14', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z240', NULL, NULL, NULL, NULL, NULL, NULL),
  (90, 'IPV5 (4 ปี)', 'IPV5', 'IPV-P', 'I15', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z240', NULL, NULL, NULL, NULL, NULL, NULL),
  (93, 'Covid19_Evusheld', 'LB1', 'Coronavirus', 'C19', NULL, NULL, NULL, NULL, NULL, 1, 'XE-FORM-Appointment-COVID19', 'Y', 'AstraZeneca', 'U119', NULL, NULL, 'Y', NULL, 1, NULL),
  (94, 'HPVC21 (Cecolin2) เข็ม1', 'HPVC21', 'HPVC', 'HPVC21', NULL, 'N', NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z258', NULL, NULL, NULL, NULL, NULL, NULL),
  (95, 'HPVC22 (Cecolin2) เข็ม2', 'HPVC22', 'HPVC', 'HPVC22', NULL, 'N', NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z258', NULL, NULL, NULL, NULL, NULL, NULL),
  (96, 'HPVC23 (Cecolin2) เข็ม3', 'HPVC23', 'HPVC', 'HPVC23', NULL, 'N', NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z258', NULL, NULL, NULL, NULL, NULL, NULL),
  (97, 'HPVV21 (CERVARIX2) เข็ม1', 'HPVV21', 'HPVV', 'HPVV21', NULL, 'N', NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z258', NULL, NULL, NULL, NULL, NULL, NULL),
  (98, 'HPVV22 (CERVARIX2) เข็ม2', 'HPVV22', 'HPVV', 'HPVV22', NULL, 'N', NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z258', NULL, NULL, NULL, NULL, NULL, NULL),
  (99, 'HPVV23 (CERVARIX2) เข็ม3', 'HPVV23', 'HPVV', 'HPVV23', NULL, 'N', NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z258', NULL, NULL, NULL, NULL, NULL, NULL),
  (100, 'HPVG41 (GARDASIL4) เข็ม1', 'HPVG41', 'HPVG', 'HPVG41', NULL, 'N', NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z258', NULL, NULL, NULL, NULL, NULL, NULL),
  (101, 'HPVG42 (GARDASIL4) เข็ม2', 'HPVG42', 'HPVG', 'HPVG42', NULL, 'N', NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z258', NULL, NULL, NULL, NULL, NULL, NULL),
  (102, 'HPVG43 (GARDASIL4) เข็ม3', 'HPVG43', 'HPVG', 'HPVG43', NULL, 'N', NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z258', NULL, NULL, NULL, NULL, NULL, NULL),
  (103, 'HPVG91 (GARDASIL9) เข็ม1', 'HPVG91', 'HPVG', 'HPVG91', NULL, 'N', NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z258', NULL, NULL, NULL, NULL, NULL, NULL),
  (104, 'HPVG92 (GARDASIL9) เข็ม2', 'HPVG92', 'HPVG', 'HPVG92', NULL, 'N', NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z258', NULL, NULL, NULL, NULL, NULL, NULL),
  (105, 'HPVG93 (GARDASIL9) เข็ม3', 'HPVG93', 'HPVG', 'HPVG93', NULL, 'N', NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z258', NULL, NULL, NULL, NULL, NULL, NULL),
  (106, 'Rabies ID1 วัคซีนพิษสุนัขบ้า ในหนัง 1', 'Rabies ID1', 'Rabies ID', '116', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z242', NULL, NULL, NULL, NULL, NULL, NULL),
  (107, 'Rabies ID2 วัคซีนพิษสุนัขบ้า ในหนัง 2', 'Rabies ID2', 'Rabies ID', '117', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z242', NULL, NULL, NULL, NULL, NULL, NULL),
  (108, 'Rabies ID3 วัคซีนพิษสุนัขบ้า ในหนัง 3', 'Rabies ID3', 'Rabies ID', '118', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z242', NULL, NULL, NULL, NULL, NULL, NULL),
  (109, 'Rabies ID4 วัคซีนพิษสุนัขบ้า ในหนัง 4', 'Rabies ID4', 'Rabies ID', '119', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z242', NULL, NULL, NULL, NULL, NULL, NULL),
  (110, 'Rabies Booter06 วัคซีนพิษสุนัขบ้า กระตุ้นใน 6 ด.', 'Rabies Booter06', 'Rabies Booter', 'B06', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z242', NULL, NULL, NULL, NULL, NULL, NULL),
  (111, 'Rabies Booter61 \r\nวัคซีนพิษสุนัขบ้า กระตุ้นใน 6 ด. ครั้งที่ 1', 'Rabies Booter61', 'Rabies Booter', 'B61', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z242', NULL, NULL, NULL, NULL, NULL, NULL),
  (112, 'Rabies Booter62 วัคซีนพิษสุนัขบ้า กระตุ้นใน 6 ด. ครั้งที่ 2', 'Rabies Booter62', 'Rabies Booter', 'B62', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z242', NULL, NULL, NULL, NULL, NULL, NULL),
  (113, 'Rabies Booter64 วัคซีนพิษสุนัขบ้า กระตุ้นใน 6 ด. 4 จุด', 'Rabies Booter64', 'Rabies Booter', 'B64', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z242', NULL, NULL, NULL, NULL, NULL, NULL),
  (114, 'Rabies PREP1 วัคซีนพิษสุนัขบ้า ล่วงหน้า 1', 'Rabies PREP1', 'Rabies PREP', 'PE1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z242', NULL, NULL, NULL, NULL, NULL, NULL),
  (115, 'Rabies PREP2 วัคซีนพิษสุนัขบ้า ล่วงหน้า 2', 'Rabies PREP2', 'Rabies PREP', 'PE2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z242', NULL, NULL, NULL, NULL, NULL, NULL),
  (116, 'Rabies PREP3 วัคซีนพิษสุนัขบ้า ล่วงหน้า 3', 'Rabies PREP3', 'Rabies PREP', 'PE3', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', '', 'Z242', NULL, NULL, NULL, NULL, NULL, NULL);
/*!40000 ALTER TABLE `person_vaccine` ENABLE KEYS */;
UNLOCK TABLES;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
