-- MySQL dump 10.13  Distrib 5.1.47, for redhat-linux-gnu (i386)
--
-- Host: localhost    Database: vaccine_covid
-- ------------------------------------------------------
-- Server version	5.1.47

/*!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 utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `Sheet2`
--

DROP TABLE IF EXISTS `Sheet2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Sheet2` (
  `arow_number` int(1) DEFAULT NULL,
  `person_type` varchar(41) DEFAULT NULL,
  `person_risk_type` varchar(43) DEFAULT NULL,
  `chw_code` int(2) DEFAULT NULL,
  `amp_code` int(2) DEFAULT NULL,
  `tmb_code` int(2) DEFAULT NULL,
  `addr_moo` int(1) DEFAULT NULL,
  `hospital_name` varchar(53) DEFAULT NULL,
  `hospital_code` int(5) DEFAULT NULL,
  `prefix` varchar(8) DEFAULT NULL,
  `first_name` varchar(10) DEFAULT NULL,
  `last_name` varchar(6) DEFAULT NULL,
  `gender_name` varchar(12) DEFAULT NULL,
  `birth_date` varchar(9) DEFAULT NULL,
  `cid` bigint(13) DEFAULT NULL,
  `mobile_phone` int(10) DEFAULT NULL,
  `need_vaccine` int(1) DEFAULT NULL,
  `person_type_id` int(1) DEFAULT NULL,
  `person_risk_type_id` int(3) DEFAULT NULL,
  `company` varchar(10) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Sheet2`
--

LOCK TABLES `Sheet2` WRITE;
/*!40000 ALTER TABLE `Sheet2` DISABLE KEYS */;
INSERT INTO `Sheet2` VALUES (1,'5-ประชาชนทั่วไป','501-ประชาชนทั่วไป',20,9,2,7,'โรงพยาบาลสัตหีบกม10',10825,'MR.','NOL','RATH','ชาย','19/2/2524',293943249,NULL,1,5,501,NULL),(2,'5-ประชาชนทั่วไป','501-ประชาชนทั่วไป',20,9,2,7,'โรงพยาบาลสัตหีบกม10',10825,'น.ส.','SAOKOEURNG','HENG','หญิง','30/4/2540',293944695,NULL,1,5,501,NULL),(3,'5-ประชาชนทั่วไป','501-ประชาชนทั่วไป',20,9,2,7,'โรงพยาบาลสัตหีบกม10',10825,'MRS.','KIMHOR','TAN','หญิง','4/6/2525',10051260972,950740189,1,5,501,NULL),(4,'5-ประชาชนทั่วไป','501-ประชาชนทั่วไป',20,9,2,7,'โรงพยาบาลสัตหีบกม10',10825,'MRS.','CHANDY','SOEUM','หญิง','3/7/2537',10051862735,947057226,1,5,501,NULL),(5,'5-ประชาชนทั่วไป','501-ประชาชนทั่วไป',20,9,2,7,'โรงพยาบาลสัตหีบกม10',10825,'MR.','NOL','LIENG','ชาย','10/4/2529',10481121927,632971051,1,5,501,NULL),(6,'5-ประชาชนทั่วไป','501-ประชาชนทั่วไป',20,9,2,7,'โรงพยาบาลสัตหีบกม10',10825,'MR.','VICHET','CHHORN','ชาย','12/5/2536',11011678900,617845233,1,5,501,NULL),(7,'5-ประชาชนทั่วไป','501-ประชาชนทั่วไป',20,9,2,7,'โรงพยาบาลสัตหีบกม10',10825,'MRS.','YOT','SAN','หญิง','17/8/2531',20011340088,628588516,1,5,501,NULL),(8,'5-ประชาชนทั่วไป','501-ประชาชนทั่วไป',20,9,2,7,'โรงพยาบาลสัตหีบกม10',10825,'MR.','SACHCHAK','YOEM','ชาย','11/4/2523',20041435061,920053063,1,5,501,NULL),(9,'5-ประชาชนทั่วไป','501-ประชาชนทั่วไป',20,9,2,7,'โรงพยาบาลสัตหีบกม10',10825,'MR.','DIN','DOEM','ชาย','9/3/2521',20041435273,628408175,1,5,501,NULL);
/*!40000 ALTER TABLE `Sheet2` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `list`
--

DROP TABLE IF EXISTS `list`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `list` (
  `date_import` date NOT NULL,
  `hospital_name` varchar(20) CHARACTER SET utf8 NOT NULL,
  `appointment_dose_type_id` varchar(1) CHARACTER SET utf8 NOT NULL,
  `cid` varchar(13) CHARACTER SET utf8 NOT NULL,
  `hospital_appointment_slot_id` varchar(8) CHARACTER SET utf8 NOT NULL,
  `slot_no` varchar(7) CHARACTER SET utf8 NOT NULL,
  `appointment_date` date NOT NULL,
  `appointment_time` time NOT NULL,
  `appointment_confirm_type_name` varchar(15) CHARACTER SET utf8 NOT NULL,
  `person_name` varchar(30) CHARACTER SET utf8 NOT NULL,
  `appointment_confirm_type_name_1` varchar(15) CHARACTER SET utf8 NOT NULL,
  `confirm_datetime` datetime NOT NULL,
  `person_age_year` int(2) NOT NULL,
  `mobile_phone` varchar(10) CHARACTER SET utf8 NOT NULL,
  `person_type_name` varchar(30) CHARACTER SET utf8 NOT NULL,
  `person_risk_type_name` varchar(30) CHARACTER SET utf8 NOT NULL,
  `vaccine_plan_1` int(2) NOT NULL,
  `vaccine_plan_2` int(2) NOT NULL,
  `consent` varchar(6) CHARACTER SET utf8 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `list`
--

LOCK TABLES `list` WRITE;
/*!40000 ALTER TABLE `list` DISABLE KEYS */;
/*!40000 ALTER TABLE `list` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'vaccine_covid'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2021-08-20  0:00:12