-- Table structure for table `edi_drug_vn`
--

CREATE TABLE `edi_drug_vn` (
  `VENDOR_TRADE_CODE` varchar(10) NOT NULL,
  `INVS_TRADE_CODE` varchar(18) NOT NULL,
  `VENDOR_CODE` varchar(10) NOT NULL,
  `TMTID` varchar(18) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=tis620 COLLATE=tis620_thai_ci;

-- --------------------------------------------------------

--
-- Table structure for table `ed_group`
--

CREATE TABLE `ed_group` (
  `RECORD_NUMBER` int(11) NOT NULL,
  `CODE` char(8) NOT NULL,
  `NAME` char(60) DEFAULT NULL,
  `SUB_COMMIT_CODE` int(11) DEFAULT NULL,
  `FORECAST` double DEFAULT NULL,
  `hide` varchar(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ed_group`
--

INSERT INTO `ed_group` (`RECORD_NUMBER`, `CODE`, `NAME`, `SUB_COMMIT_CODE`, `FORECAST`, `hide`) VALUES
(329, '010101', 'ANTACIDS AND OTHER DRUGS FOR DYSPEPSIA', NULL, 2, NULL),
(360, '010201', 'ATISPASMODICS  AND OTHER  DRUGS ALTERING GUT MOTILITITY', NULL, 2, NULL),
(506, '010301', 'ULCER-HEALING DRUGS AD DRUGS USED IN VARICEAL  BLEEDING', NULL, 2, NULL),
(395, '010401', 'DRUGS USED IN ACUTE DIARRHEA', NULL, 10, NULL),
(416, '010501', 'DRUGS USED INI CHRONIC BOWEL DISORDER', NULL, 2, NULL),
(440, '010601', 'LAXATIVES', NULL, 2, NULL),
(445, '010701', 'LOCAL PREPARATIONS FOR ANAL RECTAL DISORDER', NULL, 2, NULL),
(384, '010801', 'DRUGS  AFFECTING INTESTINAL SECRETIONS', NULL, 2, NULL),
(515, '020101', 'POSITIVE INOTROPIC DRUG', NULL, 2, NULL),
(380, '020201', 'DIURETICS', NULL, 2, NULL),
(513, '020301', 'ANTIRRHYTHMIC DRUG', NULL, 2, NULL),
(362, '020401', 'BETA-BLOCKING AGENTS', NULL, 2, NULL),
(388, '020500', 'DRUGS AFFECTING THE RENIN-ANGIOTENSIN SYSTEM', NULL, 2, NULL),
(507, '020501', 'VASODILATOR ANTIHYPERTENSIVE DRUGS', NULL, 2, NULL),
(368, '020502', 'CENTRALLY ACTING ANTIHYPERTENSIVE DRUGS', NULL, 2, NULL),
(322, '020503', 'ALPHA-ADRENOCEPTOR BLOCKING DRUGS', NULL, 2, NULL),
(328, '020504', 'ANGIOTENSIN-COVERTING ENZYME INHIBITORS', NULL, 2, NULL),
(327, '020505', 'ANGIOTENSIN-2 RECEPTOR ANTAGONIST', NULL, 2, NULL),
(456, '020600', 'NITRATES,CALCIUM- CHANNEL BLOCKERS AND VASODILATORS', NULL, 2, NULL),
(455, '020601', 'NITRATES', NULL, 2, NULL),
(365, '020602', 'CALCIUM-CHANNEL BLOCKERS', NULL, 2, NULL),
(478, '020603', 'OTHER VASODILATORS', NULL, 2, NULL),
(494, '020700', 'SYMPATHOMIMETICS', NULL, 2, NULL),
(436, '020701', 'INOTROPIC SYMPATHOMIMETICS', NULL, 2, NULL),
(399, '020703', 'DRUGS USED IN CARDIOPULMONARY RESUSCUITATION', NULL, 2, NULL),
(337, '020801', 'ANTICOAGULANTS', NULL, 2, NULL),
(349, '020901', 'ANTIPLATELET DRUGS', NULL, 2, NULL),
(424, '021001', 'FIBRINOLYTIC DRUGS', NULL, 2, NULL),
(428, '021101', 'HAEMOSTATICS', NULL, 2, NULL),
(442, '021201', 'LIPID-REGULATING  DRUGS', NULL, 2, NULL),
(487, '030000', 'RESPIRATORY SYSTEM', NULL, 2, NULL),
(364, '030100', 'BRONCHODILATORS', NULL, 2, NULL),
(320, '030101', 'ADRENOCEPTOR AGONIST', NULL, 2, NULL),
(370, '030102', 'COMPOUD ANTIMUSCARINIC BRONCHODILATORS', NULL, 2, NULL),
(499, '030103', 'THEOPHYLLINE', NULL, 2, NULL),
(373, '030201', 'CORTICOSTERIODS', NULL, 2, NULL),
(441, '030301', 'LEUKOTRIENE RECEPTOR ANTAGONISTS', NULL, 2, NULL),
(343, '030401', 'ANTIHISTAMINES', NULL, 2, NULL),
(485, '030501', 'PULMONARY SURFACTANTS', NULL, 2, NULL),
(375, '030600', 'COUGH PREPARATIONS', NULL, 2, NULL),
(376, '030601', 'COUGH SUPPESSANTS', NULL, 2, NULL),
(421, '030602', 'EXPECTORANT AND DEMULCENT COUGH PREPARATIONS', NULL, 2, NULL),
(496, '030701', 'SYSTEMIC NASAL DECONGESTANTS', NULL, 2, NULL),
(477, '030801', 'OTHER RESPIRATORY PREPARATIONS', NULL, 2, NULL),
(366, '040000', 'CENTRAL NERVOUS SYSTEM', NULL, 2, NULL),
(431, '040101', 'HYPNOTICS AND ANXIOLYTICS', NULL, 2, NULL),
(409, '040200', 'DRUGS USED IN PSYCHOSES AND RELATED DISORDERS', NULL, 2, NULL),
(351, '040201', 'ANTIPSYCHOTIC DRUGS', NULL, 2, NULL),
(346, '040202', 'ANTIMANIC DRUGS', NULL, 2, NULL),
(338, '040301', 'ANTIDEPRESSANT DRUGS', NULL, 2, NULL),
(367, '040401', 'CENTRAL NERVOUS SYSTEM STIMULANTS', NULL, 2, NULL),
(405, '040500', 'DRUGS USED IN NUASEA AND VERTIGO', NULL, 2, NULL),
(406, '040501', 'DRUGS USED IN NUASEA AND VOMITING', NULL, 2, NULL),
(415, '040502', 'DRUGS USED IN VESTIBULAR DISORDER', NULL, 2, NULL),
(326, '040601', 'ANALGESICS AND ANTIPYRETICS', NULL, 2, NULL),
(325, '040700', 'ANALGESICS', NULL, 2, NULL),
(462, '040701', 'OPIOIDS ANALGESICS', NULL, 2, NULL),
(391, '040702', 'DRUGS FOR NEUROPATHIC PAIN', NULL, 2, NULL),
(348, '040703', 'ANTIMIGRAINE DRUGS', NULL, 2, NULL),
(340, '040800', 'ANTIEPILEPTICS', NULL, 2, NULL),
(413, '040801', 'DRUGS USED IN THE CONTROL OF EPILEPSY', NULL, 2, NULL),
(411, '040802', 'DRUGS USED IN STATUS EPILEPTICUS', NULL, 2, NULL),
(408, '040901', 'DRUGS USED IN PARKINSONISM AND RELATED DISORDER', NULL, 2, NULL),
(412, '041001', 'DRUGS USED IN SUBSTANCES DEPENDENCE', NULL, 2, NULL),
(469, '041101', 'OTHER DRUGS USED IN PSYCHOSES AND RELATED', NULL, 2, NULL),
(331, '050000', 'ANTI-INFECTIONS', NULL, 2, NULL),
(334, '050100', 'ANTIBACTERIALS', NULL, 2, NULL),
(480, '050101', 'PENICILLINS', NULL, 2, NULL),
(369, '050102', 'CEPHALOSPORINS,CEPHAMYCINS AND OTHER BETA-LACTAM', NULL, 2, NULL),
(498, '050103', 'TETRACYCLINES', NULL, 2, NULL),
(323, '050104', 'AMINOGLYCOSIDES', NULL, 2, NULL),
(446, '050105', 'MACROLIDES', NULL, 2, NULL),
(486, '050106', 'QUINOLONES', NULL, 2, NULL),
(492, '050107', 'SOME OTHER ANTIBACTERIALS', NULL, 2, NULL),
(493, '050108', 'SULFONAMIDES AND TRIMETHOPRIM', NULL, 2, NULL),
(355, '050109', 'ANTITUBERCULOUS DRUGS', NULL, 2, NULL),
(344, '050110', 'ANTILEPROTIC DRUGS', NULL, 2, NULL),
(342, '050201', 'ANTIFUNGALS DRUGS', NULL, 2, NULL),
(356, '050300', 'ANTIVIRALS DRUGS', NULL, 2, NULL),
(457, '050301', 'NON-ANTIRETROVIRALS', NULL, 2, NULL),
(352, '050302', 'ANTIRETROVIRALS', NULL, 2, NULL),
(350, '050400', 'ANTIPROTOZOAL DRUGS', NULL, 2, NULL),
(345, '050401', 'ANTIMALARIALS', NULL, 2, NULL),
(476, '050402', 'OTHER PROTOZOAL DRUGS', NULL, 2, NULL),
(330, '050501', 'ANTHELMINTICS', NULL, 2, NULL),
(353, '050601', 'ANTISEPTICS', NULL, 2, NULL),
(420, '060000', 'ENDOCRINE SYSTEM', NULL, 2, NULL),
(401, '060100', 'DRUGS USED IN DIABETES', NULL, 2, NULL),
(437, '060101', 'INSULINS', NULL, 2, NULL),
(463, '060102', 'ORAL DIABETIC DRUGS', NULL, 2, NULL),
(500, '060200', 'THYROID AND ANTIHYROID DRUGS', NULL, 2, NULL),
(501, '060201', 'THYROID HORMONES', NULL, 2, NULL),
(354, '060202', 'ANTITHYROID HORMONES', NULL, 2, NULL),
(495, '060301', 'SYSTEMIC CORTICOSTEROIDS', NULL, 2, NULL),
(430, '060400', 'HORMONES REPLACMENT PREPARATIONS', NULL, 2, NULL),
(423, '060401', 'FEMALE SEX HORMONES', NULL, 2, NULL),
(447, '060402', 'MALE SEX HORMONES AND ANTAGONISTS', NULL, 2, NULL),
(433, '060500', 'HYPOTHALAMIC AND PITUITARY HORMONES', NULL, 2, NULL),
(432, '060501', 'HYPOTHALAMIC AND ANTERIOR PITUITARY HORMONES', NULL, 2, NULL),
(481, '060502', 'POSTERIOR PITUITARY HORMONES ANTAGONIST', NULL, 2, NULL),
(385, '060601', 'DRUGS AFFECTING BONE METABOLISM', NULL, 2, NULL),
(470, '060700', 'OTHER ENDOCRINE DRUGS', NULL, 2, NULL),
(363, '060701', 'BROMOCRIPTINE AND OTHER DOPAMINERGIC DRUGS', NULL, 2, NULL),
(386, '060702', 'DRUGS AFFECTING GONADOTROPINS', NULL, 2, NULL),
(460, '070000', 'OBSTETRICS,GYNAECOLOGY AND URINARY-TRACT DISORDER', NULL, 2, NULL),
(407, '070100', 'DRUGS USED IN OBSTETRICS', NULL, 2, NULL),
(484, '070101', 'PROSTAGLADINS, PROSTAGLANDINS ANTAGONISTS AND OXYTOCINS', NULL, 2, NULL),
(454, '070102', 'MYOMETRIAL RELAXANTS', NULL, 2, NULL),
(505, '070201', 'TREATMENT OF VAGINAL AND VUVAL CONDITIONS', NULL, 2, NULL),
(371, '070301', 'CONTRACEPTIVES', NULL, 2, NULL),
(390, '070400', 'DRUGS FOR GNEITO-URINARY DISORDERS', NULL, 2, NULL),
(389, '070401', 'DRUGS FOR BENIGN PROSTATIV HYPERPLASIA', NULL, 2, NULL),
(394, '070402', 'DRUGS FOR URINARY FREQUENCY, ENURESIS AND INCONTINENCE', NULL, 2, NULL),
(396, '070403', 'DRUGS USED IN ALKALINISATION OF URINE', NULL, 2, NULL),
(471, '070501', 'OTHER GYNAECOLOGIC DRUGS', NULL, 2, NULL),
(448, '080000', 'MALIGNANT DISEASE AND IMMUNOSUPPRESSION', NULL, 2, NULL),
(378, '080100', 'CYTOTOXIC DRUGS', NULL, 2, NULL),
(321, '080101', 'ALKYLATING DRUGS', NULL, 2, NULL),
(377, '080102', 'CYTOTOXIC  ANTIBIOTICS', NULL, 2, NULL),
(347, '080103', 'ANTIMETABOLITES', NULL, 2, NULL),
(508, '080104', 'VINCA ALKALOIDS AND ETOPOSIDE', NULL, 2, NULL),
(466, '080105', 'OTHER ANTINEOPLASTIC DRUGS', NULL, 2, NULL),
(387, '080201', 'DRUGS AFFECTING THE IMMUNE', NULL, 2, NULL),
(489, '080300', 'SEX HORMONES AND HORMONE ANTAGONIST IN MALIGNANT DISEASE', NULL, 2, NULL),
(483, '080301', 'PROGESTOGENS,ANTI-ESTROGENS ,ENZ INHIBITOR', NULL, 2, NULL),
(427, '080302', 'GONADORELIN ANALOGUES', NULL, 2, NULL),
(459, '090000', 'NUTRITION AND BLOOD', NULL, 2, NULL),
(511, '090100', 'WHOLE BLOOD,BLOOD PRODUCTS,AND DRUGS USED UN SOME BLOOD DISO', NULL, 2, NULL),
(510, '090101', 'WHOLE BLOOD AND BLOOD PRODUCTS', NULL, 2, NULL),
(398, '090102', 'DRUGS USED IN BONE MARROW TRANSPLANTATION', NULL, 2, NULL),
(402, '090103', 'DRUGS USED IN HYPOPLASTOC,HAEMOLYTIC AND ANAEMIAS', NULL, 2, NULL),
(425, '090201', 'FLUIDS AND ELECTROLYTES', NULL, 2, NULL),
(509, '090301', 'VITAMINS', NULL, 2, NULL),
(439, '090401', 'INTRAVENOUS NUTRITION', NULL, 2, NULL),
(450, '090501', 'MINERALS', NULL, 2, NULL),
(473, '090601', 'OTHER NUTRITION AND BLOOD', NULL, 2, NULL),
(452, '100000', 'MUSCULOSKELETAL AND JOINT DISEASES', NULL, 2, NULL),
(410, '100100', 'DRUGS USED IN RHEUMATIC DISEASE AND GOUT', NULL, 2, NULL),
(458, '100101', 'NON-STEROIDAL ANTI-INFLAMATORY DRUGS', NULL, 2, NULL),
(379, '100102', 'DISEASE-MODIFYING ANTIRHEUMATIC DRUGS(DMARD)', NULL, 2, NULL),
(393, '100103', 'DRUGS FOR TREATMENT OF GOUT AND  HYPERURICEMIA', NULL, 5, NULL),
(472, '100200', 'OTHER MUSCULOSKELETAL PREPARATIONS', NULL, 2, NULL),
(417, '100201', 'DRUGS WHICH ENHANCE NEUROMUSCULAR TRANMISSION', NULL, 2, NULL),
(490, '100202', 'SKELETAL MUSCLE RELAXANTS', NULL, 2, NULL),
(516, '10111', 'Salicylic acid and ester', NULL, 2, NULL),
(517, '10112', 'Heteroaryl acetic acids', NULL, 2, NULL),
(518, '10113', 'Indolactic acid', NULL, 2, NULL),
(519, '10114', 'Arylpropionic acid', NULL, 2, NULL),
(520, '10115', 'Oxicams', NULL, 2, NULL),
(521, '10116', 'Anthranilic acid', NULL, 2, NULL),
(522, '10117', 'Selective COX-II inhibitor', NULL, 2, NULL),
(422, '110000', 'EYE', NULL, 2, NULL),
(357, '110100', 'ATI-INFECTIVE EYE PREPARATIONS', NULL, 2, NULL),
(358, '110101', 'ATIBACTERIALS AND EYE WASH SOLUTION', NULL, 2, NULL),
(335, '110102', 'ANTIBACTERIALS WITH CORTICOSTEROIDS', NULL, 2, NULL),
(359, '110103', 'ATIFUNGALS', NULL, 2, NULL),
(361, '110104', 'ATIVIRALS', NULL, 2, NULL),
(374, '110201', 'CORTICOSTEROIDS AND OTHER ANTI-INFLAMATORY PREPARATIONS', NULL, 2, NULL),
(453, '110301', 'MYDRIATICS AND CYCLOPLEGICS', NULL, 2, NULL),
(392, '110401', 'DRUGS FOR TREATMENT OF GLAUCOMA', NULL, 2, NULL),
(444, '110501', 'LOCAL ANAESTHETICS', NULL, 2, NULL),
(497, '110601', 'TEAR DEFICIENCY,OCULAR LIBRICANTS AND ASTRINGENTS', NULL, 2, NULL),
(461, '110701', 'OCULAR DIAGNOSTIC AND PERI-OPERATIVE PREPARATIONS', NULL, 2, NULL),
(474, '110801', 'OTHER OPHTHALMIC PREPARATIONS', NULL, 2, NULL),
(418, '120000', 'EAR,NOSE,AND OROPHARYNX', NULL, 2, NULL),
(381, '120101', 'DRUG ACTING ON THE EAR', NULL, 2, NULL),
(382, '120200', 'DRUG ACTING ON THE NOSE', NULL, 2, NULL),
(404, '120201', 'DRUGS USED IN NASAL ALLERGY', NULL, 2, NULL),
(504, '120202', 'TOPICAL NASAL DECONGESTANTS', NULL, 2, NULL),
(383, '120300', 'DRUG ACTING ON THE OROPHARYNX', NULL, 2, NULL),
(465, '120301', 'OROPHARYNGEAL ANTISEPTICS', NULL, 2, NULL),
(464, '120302', 'OROPHARYNGEAL ANTIFUNGAL DRUGS', NULL, 2, NULL),
(467, '120303', 'OTHER DENTAL PREPARATIONS', NULL, 2, NULL),
(491, '130000', 'SKIN', NULL, 2, NULL),
(332, '130100', 'ANTI-INFECTIVE SKIN PREPARATIONS', NULL, 2, NULL),
(333, '130101', 'ANTIBACTERIAL PREPARATIONS', NULL, 2, NULL),
(341, '130102', 'ANTIFUNGAL PREPARATIONS', NULL, 2, NULL),
(479, '130103', 'PARASITICIDAL PREPARATIONS', NULL, 2, NULL),
(419, '130201', 'EMOLLIENT AND BARRIER PREPARATIONS', NULL, 2, NULL),
(502, '130301', 'TOPICAL ANTIPRURITICS', NULL, 2, NULL),
(503, '130401', 'TOPICAL CORTICOSTEROIDS', NULL, 2, NULL),
(475, '130501', 'OTHER PERPARATIONS FOR PSORIASIS', NULL, 2, NULL),
(482, '130601', 'PREPARATIONS FOR WARTS AND CALLUSES', NULL, 2, NULL),
(468, '130701', 'OTHER DERMATOLOGIC DRUGS', NULL, 2, NULL),
(434, '140101', 'IMMUNILOGICAL PRODUCTS AND VACCINE', NULL, 2, NULL),
(324, '150000', 'ANAESTHESIAS', NULL, 2, NULL),
(426, '150100', 'GENERAL ANAESTHESIA', NULL, 2, NULL),
(438, '150101', 'INTRAVENOUS ANAESTHETICS', NULL, 2, NULL),
(435, '150102', 'INHALATIONAL ANAESTHETICS', NULL, 2, NULL),
(451, '150103', 'MUSCULAR RELAXANTS(NEUROMUSCULAR BLOCKING DRUGS)', NULL, 2, NULL),
(488, '150104', 'SEDATIVE AND ANALGESIC PERI-OPERATIVE DRUGS', NULL, 2, NULL),
(336, '150105', 'ANTICHOLIESTERASES AND ANTIMUSCARINIC DRUGS USED IN ANAESTHE', NULL, 2, NULL),
(443, '150201', 'LOCAL ANAESTHESIA', NULL, 2, NULL),
(339, '160101', 'ANTIDOTES', NULL, 2, NULL),
(372, '170000', 'CONTRAST MEDIAS AND RADIOPHARMACEUTICALS', NULL, 2, NULL),
(512, '170100', 'X-RAY CONTRAST MEDIAS, IODINATED', NULL, 2, NULL),
(414, '170101', 'DRUGS USED IN UROGRAPHY AND COMPUTED TOMOGRAPHY', NULL, 2, NULL),
(397, '170102', 'DRUGS USED IN ANGIOGRAPHY', NULL, 2, NULL),
(403, '170103', 'DRUGS USED IN MYELOGRAPHY', NULL, 2, NULL),
(400, '170104', 'DRUGS USED IN CARDIOVASCULAR CATHERIZATION', NULL, 2, NULL),
(523, '4811', 'Aromatic ring anticonvulsant', NULL, 2, NULL),
(524, '4812', 'Non-aromatic ring anticonvulsant', NULL, 2, NULL),
(527, '5111', 'Beta-lactam Penicillin', NULL, 2, NULL),
(528, '5121', 'First generation cephalosporin', NULL, 2, NULL),
(529, '5122', 'Second generation cephalosporin', NULL, 2, NULL),
(530, '5123', 'Third generation cephalosporin', NULL, 2, NULL),
(531, '5124', 'Fourth generation cephalosporin', NULL, 2, NULL),
(532, '5125', 'Carbapenem', NULL, 2, NULL),
(525, '5181', 'Sulfomamide antibiotc', NULL, 2, NULL),
(526, '5182', 'Sulfomamide non-antibiotc', NULL, 2, NULL),
(429, '600101', 'HERBAL MEDICINAL PRODUCTS', NULL, 2, NULL),
(514, '710101', 'เวชภัณฑ์และวัสดุการแพทย์', NULL, 2, NULL),
(449, '900101', 'MEDICAL FOOD', NULL, 2, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `exchange_info`
--

CREATE TABLE `exchange_info` (
  `exchange_code` varchar(2) NOT NULL,
  `exchange_des` varchar(100) DEFAULT NULL,
  `hide` varchar(1) DEFAULT 'N'
) ENGINE=InnoDB DEFAULT CHARSET=tis620 COLLATE=tis620_thai_ci;

--
-- Dumping data for table `exchange_info`
--

INSERT INTO `exchange_info` (`exchange_code`, `exchange_des`, `hide`) VALUES
('0', '', 'N'),
('1', 'แลกเปลี่ยนไม่ได้', 'N'),
('2', 'แลกเปลี่ยนได้หลังหมดอายุ', 'N'),
('3', 'แลกเปลี่ยนได้อายุ > 3 เดือน', 'N'),
('4', 'แลกเปลี่ยนได้อายุ > 6 เดือน', 'N'),
('5', 'แลกเปลี่ยนได้อายุ > 12 เดือน', 'N');

-- --------------------------------------------------------

--
-- Table structure for table `e_po`
--

CREATE TABLE `e_po` (
  `EMAIL_ACC` varchar(30) DEFAULT NULL,
  `EMAIL_PASS` varchar(32) DEFAULT NULL,
  `EMAIL_CC` varchar(60) DEFAULT NULL,
  `EMAIL_SUBJECT` varchar(100) DEFAULT NULL,
  `DEPT_ID` varchar(6) DEFAULT NULL,
  `EMAIL_MSG` varchar(255) DEFAULT NULL,
  `ID` int(11) NOT NULL,
  `GoogleToken` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `e_po`
--

INSERT INTO `e_po` (`EMAIL_ACC`, `EMAIL_PASS`, `EMAIL_CC`, `EMAIL_SUBJECT`, `DEPT_ID`, `EMAIL_MSG`, `ID`, `GoogleToken`) VALUES
('eprocure10667@gmail.com', 'UnhCUkheb14=', '', 'สั่งซื้อเวชภัณฑ์ยา กลุ่มงานเภสัชกรรม โรงพยบาลบุรีรัมย์', 'BUY01', '<P>เรียนบริษัทผู้จำหน่ายยา<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;โรงพยาบาลบุรีรัมย์มีความประสงค์สั่งซื้อเวชภัณฑ์ยา&nbsp; โดยมีรายละเอียดดังไฟล์ข้อมูลที่แนบมากับอีเมล์นี้<BR><BR>ขอแสดงความนับถือ<BR>กลุ่มงานเภสัชกรรม โรงพยาบาลบุรีรัมย์</P>', 1, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `focus_list`
--

CREATE TABLE `focus_list` (
  `LIST_CODE` int(11) DEFAULT NULL,
  `LIST_TYPE` smallint(6) DEFAULT NULL,
  `USER_ID` varchar(32) DEFAULT NULL,
  `DEPT_ID` varchar(6) DEFAULT NULL,
  `LIST_NAME` varchar(25) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `focus_list`
--

INSERT INTO `focus_list` (`LIST_CODE`, `LIST_TYPE`, `USER_ID`, `DEPT_ID`, `LIST_NAME`) VALUES
(1, 1, 'ratchata', 'PO01', 'ทดสอบ'),
(2, 2, 'ratchata', 'TEST01', 'ทดสอบ'),
(3, 1, 'invs', 'BAB01', 'บัญชีของฉัน 1'),
(4, 1, 'invs', 'BAB01', 'บัญชัของฉัน 2'),
(5, 1, 'invs', 'BAB01', 'ยาอนุมัติพิเศษ'),
(6, 2, 'invs', 'BAB01', 'ยาเม็ด บัญชี ช');

-- --------------------------------------------------------

--
-- Table structure for table `focus_list_c`
--

CREATE TABLE `focus_list_c` (
  `WORKING_CODE` varchar(18) NOT NULL,
  `LIST_CODE` int(11) DEFAULT NULL,
  `USER_ID` varchar(32) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `focus_list_c`
--

INSERT INTO `focus_list_c` (`WORKING_CODE`, `LIST_CODE`, `USER_ID`) VALUES
('6A003H', 1, 'ratchata'),
('244734', 2, 'ratchata'),
('246352', 3, 'invs'),
('693923', 3, 'invs'),
('802062', 3, 'invs'),
('1003', 3, 'invs'),
('672501', 3, 'invs'),
('3442', 4, 'invs'),
('3488', 4, 'invs'),
('229164', 5, 'invs'),
('229129', 5, 'invs'),
('226551', 6, 'invs'),
('872656', 6, 'invs'),
('810850', 6, 'invs'),
('HPC4000', 6, '4009'),
('HPC4000', 2, '4009'),
('0.02TA2', 2, '4009');

-- --------------------------------------------------------

--
-- Table structure for table `form`
--

CREATE TABLE `form` (
  `FORM_NAME` varchar(50) DEFAULT NULL,
  `FORM_CODE` varchar(6) DEFAULT NULL,
  `FORM_DATA` longblob DEFAULT NULL,
  `USER_ID` varchar(16) DEFAULT NULL,
  `FORM_SYS` varchar(6) DEFAULT NULL,
  `LAST_UPDATE` varchar(8) DEFAULT NULL,
  `LAST_UPLOAD` varchar(8) DEFAULT NULL,
  `COPIES` smallint(6) DEFAULT NULL,
  `MOD_SYS` varchar(10) DEFAULT NULL,
  `HIDE` varchar(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `form`
--

INSERT INTO `form` (`FORM_NAME`, `FORM_CODE`, `FORM_DATA`, `USER_ID`, `FORM_SYS`, `LAST_UPDATE`, `LAST_UPLOAD`, `COPIES`, `MOD_SYS`, `HIDE`) VALUES
('1 รายงานขอซื้อขอจ้าง', '01', 0x[encoded data, 289270 characters], 'invs', '11', '20180612', '20190626', NULL, 'MED', NULL);
INSERT INTO `form` (`FORM_NAME`, `FORM_CODE`, `FORM_DATA`, `USER_ID`, `FORM_SYS`, `LAST_UPDATE`, `LAST_UPLOAD`, `COPIES`, `MOD_SYS`, `HIDE`) VALUES
('2 รายงานผลการพิจารณา', '02', 0x[encoded data, 211934 characters], 'invs', '11', '20180612', '20190626', NULL, 'MED', NULL);
