--
-- Host: localhost    Database: one_log
-- ------------------------------------------------------


--
-- Table structure for table `log_antrian`
--

CREATE TABLE `log_antrian` (
  `Log_AntrianID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_AntrianCode` varchar(50) NOT NULL,
  `Log_AntrianJson` text NOT NULL,
  `Log_AntrianUserID` int(11) NOT NULL,
  `Log_AntrianDate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`Log_AntrianID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `log_antrian`
--


--
-- Table structure for table `log_clinic`
--

CREATE TABLE `log_clinic` (
  `Log_ClinicID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_ClinicDate` datetime NOT NULL DEFAULT current_timestamp(),
  `Log_ClinicCode` varchar(50) NOT NULL DEFAULT '',
  `Log_ClinicJson` text DEFAULT NULL,
  `Log_ClinicUserID` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`Log_ClinicID`),
  KEY `Log_ClinicDate` (`Log_ClinicDate`),
  KEY `Log_ClinicCode` (`Log_ClinicCode`),
  KEY `Log_ClinicUserID` (`Log_ClinicUserID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `log_clinic`
--


--
-- Table structure for table `log_courierspk`
--

CREATE TABLE `log_courierspk` (
  `Log_CourierSpkID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_CourierSpkDate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `Log_CourierSpkJSON` text NOT NULL,
  `Log_CourierSpkUserID` int(11) NOT NULL,
  PRIMARY KEY (`Log_CourierSpkID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `log_courierspk`
--


--
-- Table structure for table `log_doctor`
--

CREATE TABLE `log_doctor` (
  `Log_DoctorID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_DoctorDate` datetime NOT NULL DEFAULT current_timestamp(),
  `Log_DoctorCode` varchar(25) NOT NULL DEFAULT '',
  `Log_DoctorJson` varchar(2000) DEFAULT NULL,
  `Log_DoctorUserID` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`Log_DoctorID`),
  KEY `Log_DoctorDate` (`Log_DoctorDate`),
  KEY `Log_DoctorCode` (`Log_DoctorCode`),
  KEY `Log_DoctorUserID` (`Log_DoctorUserID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_doctor`
--


--
-- Table structure for table `log_fo`
--

CREATE TABLE `log_fo` (
  `Log_FoID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_FoDate` datetime NOT NULL DEFAULT current_timestamp(),
  `Log_FoCode` varchar(100) NOT NULL DEFAULT '',
  `Log_FoJson` text DEFAULT NULL,
  `Log_FoUserID` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`Log_FoID`),
  KEY `Log_FoDate` (`Log_FoDate`),
  KEY `Log_FoCode` (`Log_FoCode`),
  KEY `Log_FoUserID` (`Log_FoUserID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `log_fo`
--

INSERT INTO `log_fo` VALUES (1,'2024-02-01 10:13:10','FO.ORDER.ADD','{\"order_id\": 5, \"order_number\": \"05000001GB\", \"patient_id\": 50158, \"patient_name\": \"Tn SIR GOBANG \", \"doctor_pj_id\": 0, \"doctor_pj_name\": \"\", \"doctor_sender_id\": 17095, \"doctor_sender_name\": \"-\", \"company_id\": 1222, \"mou\": 1036, \"diagnose\": \"\", \"delivery\": \"[{\\\"address_id\\\":\\\"37\\\",\\\"delivery_id\\\":\\\"10\\\",\\\"delivery_type_id\\\":\\\"2\\\",\\\"senderdoctorid\\\":\\\"9871\\\",\\\"senderaddressid\\\":\\\"17095\\\",\\\"note\\\":\\\"Jl. Karunrung No.9\\\",\\\"kelurahan\\\":\\\"64403\\\"}]\"}',5),(2,'2024-02-01 10:13:10','FO.VERIFICATION.CONFIRM','{\"orderid\":5,\"values\":[{\"Fo_VerificationsValueID\":\"1\",\"Fo_VerificationsValueT_OrderHeaderID\":\"5\",\"Fo_VerificationsValueFo_VerificationsLabelID\":\"1\",\"Fo_VerificationsValueCheck\":\"Y\",\"Fo_VerificationsValueNote\":\"\",\"Fo_VerificationsValueUserID\":\"1531\",\"Fo_VerificationsValueIsActive\":\"Y\",\"Fo_VerificationsValueCreated\":\"2024-02-01 10:13:10\",\"Fo_VerificationsValueLastUpdated\":\"0000-00-00 00:00:00\"},{\"Fo_VerificationsValueID\":\"2\",\"Fo_VerificationsValueT_OrderHeaderID\":\"5\",\"Fo_VerificationsValueFo_VerificationsLabelID\":\"2\",\"Fo_VerificationsValueCheck\":\"Y\",\"Fo_VerificationsValueNote\":\"\",\"Fo_VerificationsValueUserID\":\"1531\",\"Fo_VerificationsValueIsActive\":\"Y\",\"Fo_VerificationsValueCreated\":\"2024-02-01 10:13:10\",\"Fo_VerificationsValueLastUpdated\":\"0000-00-00 00:00:00\"},{\"Fo_VerificationsValueID\":\"3\",\"Fo_VerificationsValueT_OrderHeaderID\":\"5\",\"Fo_VerificationsValueFo_VerificationsLabelID\":\"3\",\"Fo_VerificationsValueCheck\":\"Y\",\"Fo_VerificationsValueNote\":\"\",\"Fo_VerificationsValueUserID\":\"1531\",\"Fo_VerificationsValueIsActive\":\"Y\",\"Fo_VerificationsValueCreated\":\"2024-02-01 10:13:10\",\"Fo_VerificationsValueLastUpdated\":\"0000-00-00 00:00:00\"},{\"Fo_VerificationsValueID\":\"4\",\"Fo_VerificationsValueT_OrderHeaderID\":\"5\",\"Fo_VerificationsValueFo_VerificationsLabelID\":\"4\",\"Fo_VerificationsValueCheck\":\"Y\",\"Fo_VerificationsValueNote\":\"\",\"Fo_VerificationsValueUserID\":\"1531\",\"Fo_VerificationsValueIsActive\":\"Y\",\"Fo_VerificationsValueCreated\":\"2024-02-01 10:13:10\",\"Fo_VerificationsValueLastUpdated\":\"0000-00-00 00:00:00\"},{\"Fo_VerificationsValueID\":\"5\",\"Fo_VerificationsValueT_OrderHeaderID\":\"5\",\"Fo_VerificationsValueFo_VerificationsLabelID\":\"5\",\"Fo_VerificationsValueCheck\":\"Y\",\"Fo_VerificationsValueNote\":\"\",\"Fo_VerificationsValueUserID\":\"1531\",\"Fo_VerificationsValueIsActive\":\"Y\",\"Fo_VerificationsValueCreated\":\"2024-02-01 10:13:10\",\"Fo_VerificationsValueLastUpdated\":\"0000-00-00 00:00:00\"},{\"Fo_VerificationsValueID\":\"6\",\"Fo_VerificationsValueT_OrderHeaderID\":\"5\",\"Fo_VerificationsValueFo_VerificationsLabelID\":\"6\",\"Fo_VerificationsValueCheck\":\"Y\",\"Fo_VerificationsValueNote\":\"\",\"Fo_VerificationsValueUserID\":\"1531\",\"Fo_VerificationsValueIsActive\":\"Y\",\"Fo_VerificationsValueCreated\":\"2024-02-01 10:13:10\",\"Fo_VerificationsValueLastUpdated\":\"0000-00-00 00:00:00\"}],\"note\":\"\"}',1531),(3,'2024-02-01 11:48:53','FO.ORDER.ADD','{\"order_id\": 6, \"order_number\": \"05000002GB\", \"patient_id\": 50159, \"patient_name\": \"Nn FAJRIAH RASMAQ\", \"doctor_pj_id\": 0, \"doctor_pj_name\": \"\", \"doctor_sender_id\": 17095, \"doctor_sender_name\": \"-\", \"company_id\": 1222, \"mou\": 1036, \"diagnose\": \"\", \"delivery\": \"[{\\\"address_id\\\":\\\"37\\\",\\\"delivery_id\\\":\\\"10\\\",\\\"delivery_type_id\\\":\\\"2\\\",\\\"senderdoctorid\\\":\\\"9871\\\",\\\"senderaddressid\\\":\\\"17095\\\",\\\"note\\\":\\\"Jl. Karunrung No.9\\\",\\\"kelurahan\\\":\\\"64403\\\"}]\"}',6),(4,'2024-02-01 11:48:53','FO.VERIFICATION.CONFIRM','{\"orderid\":6,\"values\":[{\"Fo_VerificationsValueID\":\"8\",\"Fo_VerificationsValueT_OrderHeaderID\":\"6\",\"Fo_VerificationsValueFo_VerificationsLabelID\":\"1\",\"Fo_VerificationsValueCheck\":\"Y\",\"Fo_VerificationsValueNote\":\"\",\"Fo_VerificationsValueUserID\":\"1531\",\"Fo_VerificationsValueIsActive\":\"Y\",\"Fo_VerificationsValueCreated\":\"2024-02-01 11:48:53\",\"Fo_VerificationsValueLastUpdated\":\"0000-00-00 00:00:00\"},{\"Fo_VerificationsValueID\":\"9\",\"Fo_VerificationsValueT_OrderHeaderID\":\"6\",\"Fo_VerificationsValueFo_VerificationsLabelID\":\"2\",\"Fo_VerificationsValueCheck\":\"Y\",\"Fo_VerificationsValueNote\":\"\",\"Fo_VerificationsValueUserID\":\"1531\",\"Fo_VerificationsValueIsActive\":\"Y\",\"Fo_VerificationsValueCreated\":\"2024-02-01 11:48:53\",\"Fo_VerificationsValueLastUpdated\":\"0000-00-00 00:00:00\"},{\"Fo_VerificationsValueID\":\"10\",\"Fo_VerificationsValueT_OrderHeaderID\":\"6\",\"Fo_VerificationsValueFo_VerificationsLabelID\":\"3\",\"Fo_VerificationsValueCheck\":\"Y\",\"Fo_VerificationsValueNote\":\"\",\"Fo_VerificationsValueUserID\":\"1531\",\"Fo_VerificationsValueIsActive\":\"Y\",\"Fo_VerificationsValueCreated\":\"2024-02-01 11:48:53\",\"Fo_VerificationsValueLastUpdated\":\"0000-00-00 00:00:00\"},{\"Fo_VerificationsValueID\":\"11\",\"Fo_VerificationsValueT_OrderHeaderID\":\"6\",\"Fo_VerificationsValueFo_VerificationsLabelID\":\"4\",\"Fo_VerificationsValueCheck\":\"Y\",\"Fo_VerificationsValueNote\":\"\",\"Fo_VerificationsValueUserID\":\"1531\",\"Fo_VerificationsValueIsActive\":\"Y\",\"Fo_VerificationsValueCreated\":\"2024-02-01 11:48:53\",\"Fo_VerificationsValueLastUpdated\":\"0000-00-00 00:00:00\"},{\"Fo_VerificationsValueID\":\"12\",\"Fo_VerificationsValueT_OrderHeaderID\":\"6\",\"Fo_VerificationsValueFo_VerificationsLabelID\":\"5\",\"Fo_VerificationsValueCheck\":\"Y\",\"Fo_VerificationsValueNote\":\"\",\"Fo_VerificationsValueUserID\":\"1531\",\"Fo_VerificationsValueIsActive\":\"Y\",\"Fo_VerificationsValueCreated\":\"2024-02-01 11:48:53\",\"Fo_VerificationsValueLastUpdated\":\"0000-00-00 00:00:00\"},{\"Fo_VerificationsValueID\":\"13\",\"Fo_VerificationsValueT_OrderHeaderID\":\"6\",\"Fo_VerificationsValueFo_VerificationsLabelID\":\"6\",\"Fo_VerificationsValueCheck\":\"Y\",\"Fo_VerificationsValueNote\":\"\",\"Fo_VerificationsValueUserID\":\"1531\",\"Fo_VerificationsValueIsActive\":\"Y\",\"Fo_VerificationsValueCreated\":\"2024-02-01 11:48:53\",\"Fo_VerificationsValueLastUpdated\":\"0000-00-00 00:00:00\"}],\"note\":\"\"}',1531);

--
-- Table structure for table `log_fostatus`
--

CREATE TABLE `log_fostatus` (
  `Log_FoStatusID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_FoStatusT_OrderHeaderID` int(11) DEFAULT NULL,
  `Log_FoStatusM_StatusID` int(11) DEFAULT NULL,
  `Log_FoStatusUserID` int(11) DEFAULT NULL,
  `Log_FoStatusDate` datetime DEFAULT NULL,
  `Log_FoStatusCreated` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`Log_FoStatusID`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_fostatus`
--

INSERT INTO `log_fostatus` VALUES (9,5,1,1531,'2024-02-01 10:13:10','2024-02-01 10:13:10'),(10,5,2,1531,'2024-02-01 10:13:10','2024-02-01 10:13:10'),(11,5,3,1531,'2024-02-01 10:13:10','2024-02-01 10:13:10'),(12,6,1,1531,'2024-02-01 11:48:53','2024-02-01 11:48:53'),(13,6,2,1531,'2024-02-01 11:48:53','2024-02-01 11:48:53'),(14,6,3,1531,'2024-02-01 11:48:53','2024-02-01 11:48:53');

--
-- Table structure for table `log_login`
--

CREATE TABLE `log_login` (
  `Log_LoginID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_LoginDateTime` datetime NOT NULL,
  `Log_LoginIP` varchar(30) NOT NULL,
  `Log_LoginType` varchar(6) NOT NULL COMMENT 'LOGIN / LOGOUT',
  `Log_LoginStatus` varchar(10) NOT NULL COMMENT 'SUCCESS / FAILED',
  `Log_LoginLogin` varchar(50) NOT NULL COMMENT 'Username',
  `Log_LoginIsActive` char(1) NOT NULL DEFAULT 'Y',
  `Log_LoginLastUpdated` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`Log_LoginID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `log_login`
--

INSERT INTO `log_login` VALUES (1,'2024-02-01 09:28:18','149.108.59.200','LOGIN','FAILED','admin','Y','2024-02-01 09:28:18'),(2,'2024-02-01 09:28:23','149.108.59.200','LOGIN','SUCCESS','adminsas','Y','2024-02-01 09:28:23'),(3,'2024-02-01 09:35:47','149.108.59.200','LOGIN','SUCCESS','adminsas','Y','2024-02-01 09:35:47'),(4,'2024-02-01 11:36:32','149.108.59.200','LOGOUT','SUCCESS','adminsas','Y','2024-02-01 11:36:32'),(5,'2024-02-01 11:48:02','149.108.59.200','LOGIN','SUCCESS','adminsas','Y','2024-02-01 11:48:02');

--
-- Table structure for table `log_management_courier`
--

CREATE TABLE `log_management_courier` (
  `Log_ManagementCourierID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_ManagementCourierDateTime` datetime NOT NULL,
  `Log_ManagementCourierJSON` text NOT NULL,
  `Log_ManagementCourierUserIID` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`Log_ManagementCourierID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_management_courier`
--


--
-- Table structure for table `log_other_cytologi`
--

CREATE TABLE `log_other_cytologi` (
  `Log_OtherCytologiID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_OtherCytologiDatetime` timestamp NULL DEFAULT NULL,
  `Log_OtherCytologiJSON` text DEFAULT NULL,
  `Log_OtherCytologiUserID` int(11) DEFAULT NULL,
  PRIMARY KEY (`Log_OtherCytologiID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_other_cytologi`
--


--
-- Table structure for table `log_other_cytologidetails`
--

CREATE TABLE `log_other_cytologidetails` (
  `Log_OtherCytologiDetailsID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_OtherCytologiDetailsDateTime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `Log_OtherCytologiDetailsJSON` text DEFAULT NULL,
  `Log_OtherCytologiDetailsUserID` int(11) DEFAULT NULL,
  PRIMARY KEY (`Log_OtherCytologiDetailsID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_other_cytologidetails`
--


--
-- Table structure for table `log_other_fna`
--

CREATE TABLE `log_other_fna` (
  `Log_OtherFNAID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_OtherFNADatetime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `Log_OtherFNAJSON` text NOT NULL,
  `Log_OtherFNAUserID` int(11) DEFAULT NULL,
  PRIMARY KEY (`Log_OtherFNAID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_other_fna`
--


--
-- Table structure for table `log_other_fnadetails`
--

CREATE TABLE `log_other_fnadetails` (
  `Log_OtherFNADetailsID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_OtherFNADetailsDateTime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `Log_OtherFNADetailsJSON` text DEFAULT NULL,
  `Log_OtherFNADetailsUserID` int(11) DEFAULT NULL,
  PRIMARY KEY (`Log_OtherFNADetailsID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_other_fnadetails`
--


--
-- Table structure for table `log_other_lcprep`
--

CREATE TABLE `log_other_lcprep` (
  `Log_OtherLcprepID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_OtherLcprepDateTime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `Log_OtherLcprepJSON` text DEFAULT NULL,
  `Log_OtherLcprepUserID` int(11) DEFAULT NULL,
  PRIMARY KEY (`Log_OtherLcprepID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_other_lcprep`
--


--
-- Table structure for table `log_other_lcprepadekuasi`
--

CREATE TABLE `log_other_lcprepadekuasi` (
  `Log_OtherLcprepAdekuasiID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_OtherLcprepAdekuasiDateTime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `Log_OtherLcprepAdekuasiJSON` text NOT NULL,
  `Log_OtherLcprepAdekuasiUserID` int(11) DEFAULT NULL,
  PRIMARY KEY (`Log_OtherLcprepAdekuasiID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_other_lcprepadekuasi`
--


--
-- Table structure for table `log_other_lcprepdetails`
--

CREATE TABLE `log_other_lcprepdetails` (
  `Log_OtherLcprepDetailsID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_OtherLcprepDetailsDateTime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `Log_OtherLcprepDetailsJSON` text DEFAULT NULL,
  `Log_OtherLcprepDetailsUserID` int(11) DEFAULT NULL,
  PRIMARY KEY (`Log_OtherLcprepDetailsID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_other_lcprepdetails`
--


--
-- Table structure for table `log_other_lcprepinterpretasi`
--

CREATE TABLE `log_other_lcprepinterpretasi` (
  `Log_OtherLcprepInterpretasiID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_OtherLcprepInterpretasiDateTime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `Log_OtherLcprepInterpretasiJSON` text DEFAULT NULL,
  `Log_OtherLcprepInterpretasiUserID` int(11) DEFAULT NULL,
  PRIMARY KEY (`Log_OtherLcprepInterpretasiID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_other_lcprepinterpretasi`
--


--
-- Table structure for table `log_other_lcprepkategoriumum`
--

CREATE TABLE `log_other_lcprepkategoriumum` (
  `Log_OtherLcprepKategoriUmumID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_OtherLcprepKategoriUmumDateTime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `Log_OtherLcprepKategoriUmumJSON` text DEFAULT NULL,
  `Log_OtherLcprepKategoriUmumUserID` int(11) DEFAULT NULL,
  PRIMARY KEY (`Log_OtherLcprepKategoriUmumID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_other_lcprepkategoriumum`
--


--
-- Table structure for table `log_other_papsmear`
--

CREATE TABLE `log_other_papsmear` (
  `Log_OtherPapsmearID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_OtherPapsmearDateTime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `Log_OtherPapsmearJSON` text DEFAULT NULL,
  `Log_OtherPapsmearUserID` int(11) DEFAULT NULL,
  PRIMARY KEY (`Log_OtherPapsmearID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_other_papsmear`
--


--
-- Table structure for table `log_other_papsmearbahan`
--

CREATE TABLE `log_other_papsmearbahan` (
  `Log_OtherPapSmearBahanID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_OtherPapSmearBahanDateTime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `Log_OtherPapSmearBahanJSON` text DEFAULT NULL,
  `Log_OtherPapSmearBahanUserID` int(11) DEFAULT NULL,
  PRIMARY KEY (`Log_OtherPapSmearBahanID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_other_papsmearbahan`
--


--
-- Table structure for table `log_other_papsmearcategory`
--

CREATE TABLE `log_other_papsmearcategory` (
  `Log_OtherPapSmearCategoryID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_OtherPapSmearCategoryDateTime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `Log_OtherPapSmearCategoryJSON` text DEFAULT NULL,
  `Log_OtherPapSmearCategoryUserID` int(11) DEFAULT NULL,
  PRIMARY KEY (`Log_OtherPapSmearCategoryID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_other_papsmearcategory`
--


--
-- Table structure for table `log_other_papsmearcheck`
--

CREATE TABLE `log_other_papsmearcheck` (
  `Log_OtherPapSmearCheckID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_OtherPapSmearCheckDateTime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `Log_OtherPapSmearCheckJSON` text DEFAULT NULL,
  `Log_OtherPapSmearCheckUserID` int(11) DEFAULT NULL,
  PRIMARY KEY (`Log_OtherPapSmearCheckID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_other_papsmearcheck`
--


--
-- Table structure for table `log_other_papsmeardetails`
--

CREATE TABLE `log_other_papsmeardetails` (
  `Log_OtherPapSmearDetailsID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_OtherPapSmearDetailsDateTime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `Log_OtherPapSmearDetailsJSON` text DEFAULT NULL,
  `Log_OtherPapSmearDetailsUserID` int(11) DEFAULT NULL,
  PRIMARY KEY (`Log_OtherPapSmearDetailsID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_other_papsmeardetails`
--


--
-- Table structure for table `log_other_papsmearmaturasi`
--

CREATE TABLE `log_other_papsmearmaturasi` (
  `Log_OtherPapsmearMaturasiID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_OtherPapsmearMaturasiDateTime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `Log_OtherPapsmearMaturasiJSON` text DEFAULT NULL,
  `Log_OtherPapsmearMaturasiUserID` int(11) DEFAULT NULL,
  PRIMARY KEY (`Log_OtherPapsmearMaturasiID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_other_papsmearmaturasi`
--


--
-- Table structure for table `log_patient`
--

CREATE TABLE `log_patient` (
  `Log_PatientID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_PatientDate` datetime NOT NULL DEFAULT current_timestamp(),
  `Log_PatientCode` varchar(25) NOT NULL DEFAULT '',
  `Log_PatientJson` varchar(2000) DEFAULT NULL,
  `Log_PatientJsonBefore` varchar(2000) DEFAULT NULL,
  `Log_PatientUserID` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`Log_PatientID`),
  KEY `Log_PatientDate` (`Log_PatientDate`),
  KEY `Log_PatientCode` (`Log_PatientCode`),
  KEY `Log_PatientUserID` (`Log_PatientUserID`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `log_patient`
--

INSERT INTO `log_patient` VALUES (1,'2024-02-01 09:58:07','PATIENT.ADD','{\"M_PatientID\": 50154, \"M_PatientNoReg\": \"VBE0000647\", \"M_PatientPrefix\": null, \"M_PatientName\": \"SIR GOBANG \", \"M_PatientM_TitleID\": 2, \"M_PatientSuffix\": null, \"M_PatientM_SexID\": 1, \"M_PatientInitialVisit\": 0, \"M_PatientLastVisit\": null, \"M_PatientM_ReligionID\": 0, \"M_PatientPOB\": \"\", \"M_PatientDOB\": \"1932-06-22\", \"M_PatientHP\": \"087731453789\", \"M_PatientPhone\": \"\", \"M_PatientEmail\": \"\", \"M_PatientM_IdTypeID\": 1, \"M_PatientIDNumber\": \"1121112206880041\", \"M_PatientNote\": \"\", \"M_PatientPhoto\": null, \"M_PatientPhotoThumb\": null, \"M_PatientM_CompanyStaffPositionID\": null, \"M_PatientPhotoCounter\": 0, \"M_PatientCreated\": \"2024-02-01 09:58:07\", \"M_PatientLastUpdated\": \"2024-02-01 09:58:07\", \"M_PatientUserID\": 1531, \"M_PatientIsActive\": \"Y\", \"M_PatientOldID\": \"\", \"M_PatientNIK\": null, \"M_PatientJabatan\": null, \"M_PatientKedudukan\": null, \"M_PatientPJ\": null, \"M_PatientLocation\": null, \"M_PatientJob\": null, \"M_PatientUserID\": 1531}',NULL,1531),(2,'2024-02-01 09:58:07','PATIENT.ADDR_ADD','{\"M_PatientAddressID\": 50159, \"M_PatientAddressM_PatientID\": 50154, \"M_PatientName\": \"SIR GOBANG \", \"M_PatientAddressNote\": \"Utama\", \"M_PatientAddressDescription\": \"RT 04\", \"M_PatientAddressLocation\": null, \"M_PatientAddressM_KelurahanID\": 4215, \"M_PatientAddressOldCityID\": null, \"M_PatientAddressPostCodeID\": null, \"M_PatientAddressFax\": null, \"M_PatientAddressEmail\": null, \"M_PatientAddressPhone\": null, \"M_PatientAddressCreated\": null, \"M_PatientAddressLastUpdated\": null, \"M_PatientAddressIsActive\": \"Y\", \"M_PatientAddressLat\": 0.00000000, \"M_PatientAddressLng\": 0.00000000, \"M_PatientAddressOldAddressName\": null, \"M_PatientAddressOldAddressLocation\": null, \"M_PatientAddressUserID\": 3}',NULL,3),(4,'2024-02-01 10:00:35','PATIENT.ADD','{\"M_PatientID\": 50155, \"M_PatientNoReg\": \"VBE0000648\", \"M_PatientPrefix\": null, \"M_PatientName\": \"SIR GOBANG \", \"M_PatientM_TitleID\": 2, \"M_PatientSuffix\": null, \"M_PatientM_SexID\": 1, \"M_PatientInitialVisit\": 0, \"M_PatientLastVisit\": null, \"M_PatientM_ReligionID\": 0, \"M_PatientPOB\": \"\", \"M_PatientDOB\": \"1932-06-22\", \"M_PatientHP\": \"087731453789\", \"M_PatientPhone\": \"\", \"M_PatientEmail\": \"\", \"M_PatientM_IdTypeID\": 1, \"M_PatientIDNumber\": \"1121112206880041\", \"M_PatientNote\": \"\", \"M_PatientPhoto\": null, \"M_PatientPhotoThumb\": null, \"M_PatientM_CompanyStaffPositionID\": null, \"M_PatientPhotoCounter\": 0, \"M_PatientCreated\": \"2024-02-01 10:00:35\", \"M_PatientLastUpdated\": \"2024-02-01 10:00:35\", \"M_PatientUserID\": 1531, \"M_PatientIsActive\": \"Y\", \"M_PatientOldID\": \"\", \"M_PatientNIK\": null, \"M_PatientJabatan\": null, \"M_PatientKedudukan\": null, \"M_PatientPJ\": null, \"M_PatientLocation\": null, \"M_PatientJob\": null, \"M_PatientUserID\": 1531}',NULL,1531),(5,'2024-02-01 10:00:35','PATIENT.ADDR_ADD','{\"M_PatientAddressID\": 50160, \"M_PatientAddressM_PatientID\": 50155, \"M_PatientName\": \"SIR GOBANG \", \"M_PatientAddressNote\": \"Utama\", \"M_PatientAddressDescription\": \"RT 04\", \"M_PatientAddressLocation\": null, \"M_PatientAddressM_KelurahanID\": 4215, \"M_PatientAddressOldCityID\": null, \"M_PatientAddressPostCodeID\": null, \"M_PatientAddressFax\": null, \"M_PatientAddressEmail\": null, \"M_PatientAddressPhone\": null, \"M_PatientAddressCreated\": null, \"M_PatientAddressLastUpdated\": null, \"M_PatientAddressIsActive\": \"Y\", \"M_PatientAddressLat\": 0.00000000, \"M_PatientAddressLng\": 0.00000000, \"M_PatientAddressOldAddressName\": null, \"M_PatientAddressOldAddressLocation\": null, \"M_PatientAddressUserID\": 3}',NULL,3),(7,'2024-02-01 10:04:04','PATIENT.ADD','{\"M_PatientID\": 50156, \"M_PatientNoReg\": \"VBE0000649\", \"M_PatientPrefix\": null, \"M_PatientName\": \"SIR GOBANG \", \"M_PatientM_TitleID\": 2, \"M_PatientSuffix\": null, \"M_PatientM_SexID\": 1, \"M_PatientInitialVisit\": 0, \"M_PatientLastVisit\": null, \"M_PatientM_ReligionID\": 0, \"M_PatientPOB\": \"\", \"M_PatientDOB\": \"1932-06-22\", \"M_PatientHP\": \"087731453789\", \"M_PatientPhone\": \"\", \"M_PatientEmail\": \"\", \"M_PatientM_IdTypeID\": 1, \"M_PatientIDNumber\": \"1121112206880041\", \"M_PatientNote\": \"\", \"M_PatientPhoto\": null, \"M_PatientPhotoThumb\": null, \"M_PatientM_CompanyStaffPositionID\": null, \"M_PatientPhotoCounter\": 0, \"M_PatientCreated\": \"2024-02-01 10:04:04\", \"M_PatientLastUpdated\": \"2024-02-01 10:04:04\", \"M_PatientUserID\": 1531, \"M_PatientIsActive\": \"Y\", \"M_PatientOldID\": \"\", \"M_PatientNIK\": null, \"M_PatientJabatan\": null, \"M_PatientKedudukan\": null, \"M_PatientPJ\": null, \"M_PatientLocation\": null, \"M_PatientJob\": null, \"M_PatientUserID\": 1531}',NULL,1531),(8,'2024-02-01 10:04:04','PATIENT.ADDR_ADD','{\"M_PatientAddressID\": 50161, \"M_PatientAddressM_PatientID\": 50156, \"M_PatientName\": \"SIR GOBANG \", \"M_PatientAddressNote\": \"Utama\", \"M_PatientAddressDescription\": \"RT 04\", \"M_PatientAddressLocation\": null, \"M_PatientAddressM_KelurahanID\": 4215, \"M_PatientAddressOldCityID\": null, \"M_PatientAddressPostCodeID\": null, \"M_PatientAddressFax\": null, \"M_PatientAddressEmail\": null, \"M_PatientAddressPhone\": null, \"M_PatientAddressCreated\": null, \"M_PatientAddressLastUpdated\": null, \"M_PatientAddressIsActive\": \"Y\", \"M_PatientAddressLat\": 0.00000000, \"M_PatientAddressLng\": 0.00000000, \"M_PatientAddressOldAddressName\": null, \"M_PatientAddressOldAddressLocation\": null, \"M_PatientAddressUserID\": 3}',NULL,3),(10,'2024-02-01 10:04:45','PATIENT.ADD','{\"M_PatientID\": 50157, \"M_PatientNoReg\": \"VBE0000650\", \"M_PatientPrefix\": null, \"M_PatientName\": \"SIR GOBANG \", \"M_PatientM_TitleID\": 2, \"M_PatientSuffix\": null, \"M_PatientM_SexID\": 1, \"M_PatientInitialVisit\": 0, \"M_PatientLastVisit\": null, \"M_PatientM_ReligionID\": 0, \"M_PatientPOB\": \"\", \"M_PatientDOB\": \"1932-06-22\", \"M_PatientHP\": \"087731453789\", \"M_PatientPhone\": \"\", \"M_PatientEmail\": \"\", \"M_PatientM_IdTypeID\": 1, \"M_PatientIDNumber\": \"1121112206880041\", \"M_PatientNote\": \"\", \"M_PatientPhoto\": null, \"M_PatientPhotoThumb\": null, \"M_PatientM_CompanyStaffPositionID\": null, \"M_PatientPhotoCounter\": 0, \"M_PatientCreated\": \"2024-02-01 10:04:45\", \"M_PatientLastUpdated\": \"2024-02-01 10:04:45\", \"M_PatientUserID\": 1531, \"M_PatientIsActive\": \"Y\", \"M_PatientOldID\": \"\", \"M_PatientNIK\": null, \"M_PatientJabatan\": null, \"M_PatientKedudukan\": null, \"M_PatientPJ\": null, \"M_PatientLocation\": null, \"M_PatientJob\": null, \"M_PatientUserID\": 1531}',NULL,1531),(11,'2024-02-01 10:04:45','PATIENT.ADDR_ADD','{\"M_PatientAddressID\": 50162, \"M_PatientAddressM_PatientID\": 50157, \"M_PatientName\": \"SIR GOBANG \", \"M_PatientAddressNote\": \"Utama\", \"M_PatientAddressDescription\": \"RT 04\", \"M_PatientAddressLocation\": null, \"M_PatientAddressM_KelurahanID\": 4215, \"M_PatientAddressOldCityID\": null, \"M_PatientAddressPostCodeID\": null, \"M_PatientAddressFax\": null, \"M_PatientAddressEmail\": null, \"M_PatientAddressPhone\": null, \"M_PatientAddressCreated\": null, \"M_PatientAddressLastUpdated\": null, \"M_PatientAddressIsActive\": \"Y\", \"M_PatientAddressLat\": 0.00000000, \"M_PatientAddressLng\": 0.00000000, \"M_PatientAddressOldAddressName\": null, \"M_PatientAddressOldAddressLocation\": null, \"M_PatientAddressUserID\": 3}',NULL,3),(13,'2024-02-01 10:13:10','PATIENT.ADD','{\"M_PatientID\": 50158, \"M_PatientNoReg\": \"VBE0000651\", \"M_PatientPrefix\": null, \"M_PatientName\": \"SIR GOBANG \", \"M_PatientM_TitleID\": 2, \"M_PatientSuffix\": null, \"M_PatientM_SexID\": 1, \"M_PatientInitialVisit\": 0, \"M_PatientLastVisit\": null, \"M_PatientM_ReligionID\": 0, \"M_PatientPOB\": \"\", \"M_PatientDOB\": \"1932-06-22\", \"M_PatientHP\": \"087731453789\", \"M_PatientPhone\": \"\", \"M_PatientEmail\": \"\", \"M_PatientM_IdTypeID\": 1, \"M_PatientIDNumber\": \"1121112206880041\", \"M_PatientNote\": \"\", \"M_PatientPhoto\": null, \"M_PatientPhotoThumb\": null, \"M_PatientM_CompanyStaffPositionID\": null, \"M_PatientPhotoCounter\": 0, \"M_PatientCreated\": \"2024-02-01 10:13:10\", \"M_PatientLastUpdated\": \"2024-02-01 10:13:10\", \"M_PatientUserID\": 1531, \"M_PatientIsActive\": \"Y\", \"M_PatientOldID\": \"\", \"M_PatientNIK\": null, \"M_PatientJabatan\": null, \"M_PatientKedudukan\": null, \"M_PatientPJ\": null, \"M_PatientLocation\": null, \"M_PatientJob\": null, \"M_PatientUserID\": 1531}',NULL,1531),(14,'2024-02-01 10:13:10','PATIENT.ADDR_ADD','{\"M_PatientAddressID\": 50163, \"M_PatientAddressM_PatientID\": 50158, \"M_PatientName\": \"SIR GOBANG \", \"M_PatientAddressNote\": \"Utama\", \"M_PatientAddressDescription\": \"RT 04\", \"M_PatientAddressLocation\": null, \"M_PatientAddressM_KelurahanID\": 4215, \"M_PatientAddressOldCityID\": null, \"M_PatientAddressPostCodeID\": null, \"M_PatientAddressFax\": null, \"M_PatientAddressEmail\": null, \"M_PatientAddressPhone\": null, \"M_PatientAddressCreated\": null, \"M_PatientAddressLastUpdated\": null, \"M_PatientAddressIsActive\": \"Y\", \"M_PatientAddressLat\": 0.00000000, \"M_PatientAddressLng\": 0.00000000, \"M_PatientAddressOldAddressName\": null, \"M_PatientAddressOldAddressLocation\": null, \"M_PatientAddressUserID\": 3}',NULL,3),(15,'2024-02-01 10:13:10','PATIENT.EDIT','{\"M_PatientID\": 50158, \"M_PatientNoReg\": \"VBE0000651\", \"M_PatientPrefix\": null, \"M_PatientName\": \"SIR GOBANG \", \"M_PatientM_TitleID\": 2, \"M_PatientSuffix\": null, \"M_PatientM_SexID\": 1, \"M_PatientInitialVisit\": 0, \"M_PatientLastVisit\": null, \"M_PatientM_ReligionID\": 0, \"M_PatientPOB\": \"\", \"M_PatientDOB\": \"1932-06-22\", \"M_PatientHP\": \"087731453789\", \"M_PatientPhone\": \"\", \"M_PatientEmail\": \"\", \"M_PatientM_IdTypeID\": 1, \"M_PatientIDNumber\": \"1121112206880041\", \"M_PatientNote\": \"\", \"M_PatientPhoto\": null, \"M_PatientPhotoThumb\": null, \"M_PatientM_CompanyStaffPositionID\": null, \"M_PatientPhotoCounter\": 0, \"M_PatientCreated\": \"2024-02-01 10:13:10\", \"M_PatientLastUpdated\": \"2024-02-01 10:13:10\", \"M_PatientUserID\": 1531, \"M_PatientIsActive\": \"Y\", \"M_PatientOldID\": \"\", \"M_PatientNIK\": null, \"M_PatientJabatan\": null, \"M_PatientKedudukan\": null, \"M_PatientPJ\": null, \"M_PatientLocation\": null, \"M_PatientJob\": null, \"M_PatientUserID\": 1531}','{\"M_PatientID\": 50158, \"M_PatientNoReg\": \"VBE0000651\", \"M_PatientPrefix\": null, \"M_PatientName\": \"SIR GOBANG \", \"M_PatientM_TitleID\": 2, \"M_PatientSuffix\": null, \"M_PatientM_SexID\": 1, \"M_PatientInitialVisit\": 0, \"M_PatientLastVisit\": null, \"M_PatientM_ReligionID\": 0, \"M_PatientPOB\": \"\", \"M_PatientDOB\": \"1932-06-22\", \"M_PatientHP\": \"087731453789\", \"M_PatientPhone\": \"\", \"M_PatientEmail\": \"\", \"M_PatientM_IdTypeID\": 1, \"M_PatientIDNumber\": \"1121112206880041\", \"M_PatientNote\": \"\", \"M_PatientPhoto\": null, \"M_PatientPhotoThumb\": null, \"M_PatientM_CompanyStaffPositionID\": null, \"M_PatientPhotoCounter\": 0, \"M_PatientCreated\": \"2024-02-01 10:13:10\", \"M_PatientLastUpdated\": \"2024-02-01 10:13:10\", \"M_PatientUserID\": 1531, \"M_PatientIsActive\": \"Y\", \"M_PatientOldID\": \"\", \"M_PatientNIK\": null, \"M_PatientJabatan\": null, \"M_PatientKedudukan\": null, \"M_PatientPJ\": null, \"M_PatientLocation\": null, \"M_PatientJob\": null, \"M_PatientUserID\": 1531}',1531),(16,'2024-02-01 11:48:53','PATIENT.ADD','{\"M_PatientID\": 50159, \"M_PatientNoReg\": \"VBE0000652\", \"M_PatientPrefix\": null, \"M_PatientName\": \"FAJRIAH RASMAQ\", \"M_PatientM_TitleID\": 5, \"M_PatientSuffix\": null, \"M_PatientM_SexID\": 2, \"M_PatientInitialVisit\": 0, \"M_PatientLastVisit\": null, \"M_PatientM_ReligionID\": 1, \"M_PatientPOB\": \"SIDODADI\", \"M_PatientDOB\": \"1992-04-29\", \"M_PatientHP\": \"085810396052\", \"M_PatientPhone\": \"\", \"M_PatientEmail\": \"Fajriahrasmaq@gmail.com\", \"M_PatientM_IdTypeID\": 1, \"M_PatientIDNumber\": \"7604116904920004\", \"M_PatientNote\": \"\", \"M_PatientPhoto\": null, \"M_PatientPhotoThumb\": null, \"M_PatientM_CompanyStaffPositionID\": null, \"M_PatientPhotoCounter\": 0, \"M_PatientCreated\": \"2024-02-01 11:48:53\", \"M_PatientLastUpdated\": \"2024-02-01 11:48:53\", \"M_PatientUserID\": 1531, \"M_PatientIsActive\": \"Y\", \"M_PatientOldID\": \"\", \"M_PatientNIK\": null, \"M_PatientJabatan\": null, \"M_PatientKedudukan\": null, \"M_PatientPJ\": null, \"M_PatientLocation\": null, \"M_PatientJob\": null, \"M_PatientUserID\": 1531}',NULL,1531),(17,'2024-02-01 11:48:53','PATIENT.ADDR_ADD','{\"M_PatientAddressID\": 50164, \"M_PatientAddressM_PatientID\": 50159, \"M_PatientName\": \"FAJRIAH RASMAQ\", \"M_PatientAddressNote\": \"Rumah\", \"M_PatientAddressDescription\": \"JL YOMPO DG NABA KOMPLEKS MALINO\", \"M_PatientAddressLocation\": null, \"M_PatientAddressM_KelurahanID\": 63527, \"M_PatientAddressOldCityID\": null, \"M_PatientAddressPostCodeID\": \"\", \"M_PatientAddressFax\": \"\", \"M_PatientAddressEmail\": \"\", \"M_PatientAddressPhone\": \"+6285256689646\", \"M_PatientAddressCreated\": null, \"M_PatientAddressLastUpdated\": null, \"M_PatientAddressIsActive\": \"Y\", \"M_PatientAddressLat\": 0.00000000, \"M_PatientAddressLng\": 0.00000000, \"M_PatientAddressOldAddressName\": null, \"M_PatientAddressOldAddressLocation\": null, \"M_PatientAddressUserID\": 3}',NULL,3),(18,'2024-02-01 11:48:53','PATIENT.EDIT','{\"M_PatientID\": 50159, \"M_PatientNoReg\": \"VBE0000652\", \"M_PatientPrefix\": null, \"M_PatientName\": \"FAJRIAH RASMAQ\", \"M_PatientM_TitleID\": 5, \"M_PatientSuffix\": null, \"M_PatientM_SexID\": 2, \"M_PatientInitialVisit\": 0, \"M_PatientLastVisit\": null, \"M_PatientM_ReligionID\": 1, \"M_PatientPOB\": \"SIDODADI\", \"M_PatientDOB\": \"1992-04-29\", \"M_PatientHP\": \"085810396052\", \"M_PatientPhone\": \"\", \"M_PatientEmail\": \"Fajriahrasmaq@gmail.com\", \"M_PatientM_IdTypeID\": 1, \"M_PatientIDNumber\": \"7604116904920004\", \"M_PatientNote\": \"\", \"M_PatientPhoto\": null, \"M_PatientPhotoThumb\": null, \"M_PatientM_CompanyStaffPositionID\": null, \"M_PatientPhotoCounter\": 0, \"M_PatientCreated\": \"2024-02-01 11:48:53\", \"M_PatientLastUpdated\": \"2024-02-01 11:48:53\", \"M_PatientUserID\": 1531, \"M_PatientIsActive\": \"Y\", \"M_PatientOldID\": \"\", \"M_PatientNIK\": null, \"M_PatientJabatan\": null, \"M_PatientKedudukan\": null, \"M_PatientPJ\": null, \"M_PatientLocation\": null, \"M_PatientJob\": null, \"M_PatientUserID\": 1531}','{\"M_PatientID\": 50159, \"M_PatientNoReg\": \"VBE0000652\", \"M_PatientPrefix\": null, \"M_PatientName\": \"FAJRIAH RASMAQ\", \"M_PatientM_TitleID\": 5, \"M_PatientSuffix\": null, \"M_PatientM_SexID\": 2, \"M_PatientInitialVisit\": 0, \"M_PatientLastVisit\": null, \"M_PatientM_ReligionID\": 1, \"M_PatientPOB\": \"SIDODADI\", \"M_PatientDOB\": \"1992-04-29\", \"M_PatientHP\": \"085810396052\", \"M_PatientPhone\": \"\", \"M_PatientEmail\": \"Fajriahrasmaq@gmail.com\", \"M_PatientM_IdTypeID\": 1, \"M_PatientIDNumber\": \"7604116904920004\", \"M_PatientNote\": \"\", \"M_PatientPhoto\": null, \"M_PatientPhotoThumb\": null, \"M_PatientM_CompanyStaffPositionID\": null, \"M_PatientPhotoCounter\": 0, \"M_PatientCreated\": \"2024-02-01 11:48:53\", \"M_PatientLastUpdated\": \"2024-02-01 11:48:53\", \"M_PatientUserID\": 1531, \"M_PatientIsActive\": \"Y\", \"M_PatientOldID\": \"\", \"M_PatientNIK\": null, \"M_PatientJabatan\": null, \"M_PatientKedudukan\": null, \"M_PatientPJ\": null, \"M_PatientLocation\": null, \"M_PatientJob\": null, \"M_PatientUserID\": 1531}',1531);

--
-- Table structure for table `log_payment`
--

CREATE TABLE `log_payment` (
  `Log_PaymentID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_PaymentDate` datetime NOT NULL DEFAULT current_timestamp(),
  `Log_PaymentCode` varchar(100) NOT NULL DEFAULT '',
  `Log_PaymentOrderID` int(11) NOT NULL DEFAULT 0,
  `Log_PaymentJson` text DEFAULT NULL,
  `Log_PaymentUserID` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`Log_PaymentID`),
  KEY `Log_PaymentCode` (`Log_PaymentCode`),
  KEY `Log_PaymentUserID` (`Log_PaymentUserID`),
  KEY `Log_PaymentOrderID` (`Log_PaymentOrderID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `log_payment`
--


--
-- Table structure for table `log_photo`
--

CREATE TABLE `log_photo` (
  `Log_PhotoID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_PhotoDate` datetime NOT NULL DEFAULT current_timestamp(),
  `Log_PhotoCode` varchar(50) DEFAULT NULL,
  `Log_PhotoM_PatientID` int(11) NOT NULL DEFAULT 0,
  `Log_PhotoUrl` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`Log_PhotoID`),
  KEY `Log_PhotoDate` (`Log_PhotoDate`),
  KEY `Log_PhotoCode` (`Log_PhotoCode`),
  KEY `Log_PhotoM_PatientID` (`Log_PhotoM_PatientID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `log_photo`
--


--
-- Table structure for table `log_portserver`
--

CREATE TABLE `log_portserver` (
  `logPortServerID` int(11) NOT NULL AUTO_INCREMENT,
  `logDate` datetime DEFAULT current_timestamp(),
  `logInstrumentID` int(11) DEFAULT NULL,
  `logMessage` varchar(300) DEFAULT NULL,
  `logData` text DEFAULT NULL,
  PRIMARY KEY (`logPortServerID`),
  KEY `logInstrumentID` (`logInstrumentID`),
  KEY `logDate` (`logDate`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_portserver`
--


--
-- Table structure for table `log_preorder_home_service`
--

CREATE TABLE `log_preorder_home_service` (
  `Log_PreorderHomeServiceID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_PreorderHomeServiceCode` varchar(25) NOT NULL,
  `Log_PreorderHomeServiceJson` text NOT NULL,
  `Log_PreorderHomeServiceUserID` int(11) NOT NULL DEFAULT 0,
  `Log_PreorderHomeServiceDate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`Log_PreorderHomeServiceID`),
  KEY `Log_PreorderHomeServiceCode` (`Log_PreorderHomeServiceCode`),
  KEY `Log_PreorderHomeServiceUserID` (`Log_PreorderHomeServiceUserID`),
  KEY `Log_PreorderHomeServiceDate` (`Log_PreorderHomeServiceDate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `log_preorder_home_service`
--


--
-- Table structure for table `log_printlab`
--

CREATE TABLE `log_printlab` (
  `Log_PrintLabID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_PrintLabT_OrderHeaderID` int(11) NOT NULL,
  `Log_PrintLabDatetime` datetime NOT NULL,
  `Log_PrintLabJson` text NOT NULL,
  `Log_PrintLabUserID` int(11) NOT NULL,
  `Log_PrintLabCode` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`Log_PrintLabID`),
  KEY `Log_PrintLabT_OrderHeaderID` (`Log_PrintLabT_OrderHeaderID`),
  KEY `Log_PrintLabCode` (`Log_PrintLabCode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_printlab`
--


--
-- Table structure for table `log_process`
--

CREATE TABLE `log_process` (
  `Log_ProcessID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_ProcessDate` datetime NOT NULL DEFAULT current_timestamp(),
  `Log_ProcessCode` varchar(50) DEFAULT NULL,
  `Log_ProcessOrderID` int(11) NOT NULL DEFAULT 0,
  `Log_ProcessOrderNumber` varchar(25) DEFAULT NULL,
  `Log_ProcessJson` text DEFAULT NULL,
  `Log_ProcessUserID` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`Log_ProcessID`),
  KEY `Log_ProcessDate` (`Log_ProcessDate`),
  KEY `Log_ProcessOrderID` (`Log_ProcessOrderID`),
  KEY `Log_ProcessUserID` (`Log_ProcessUserID`),
  KEY `Log_ProcessOrderNumber` (`Log_ProcessOrderNumber`),
  KEY `Log_ProcessCode` (`Log_ProcessCode`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `log_process`
--

INSERT INTO `log_process` VALUES (1,'2024-02-01 10:14:03','PROCESS.Result.Entry',5,'05000001GB','[{\"id\":\"9\",\"result\":\"35\",\"note\":null,\"test_id\":\"894\",\"test_name\":\"SGOT\",\"resultInstrumentID\":0,\"order_id\":\"5\"},{\"id\":\"10\",\"result\":\"40\",\"note\":null,\"test_id\":\"895\",\"test_name\":\"SGPT\",\"resultInstrumentID\":0,\"order_id\":\"5\"}]',1531),(2,'2024-02-01 10:14:16','PROCESS.Result.Verification',5,'05000001GB','null',1531),(3,'2024-02-01 10:14:17','PROCESS.Result.Verification',5,'05000001GB','null',1531),(4,'2024-02-01 10:14:29','PROCESS.Result.Validation',5,'05000001GB','null',1531),(5,'2024-02-01 10:14:30','PROCESS.Result.Validation',5,'05000001GB','null',1531),(6,'2024-02-01 11:49:38','PROCESS.Result.Entry',6,'05000002GB','[{\"id\":\"11\",\"result\":\"32\",\"note\":null,\"test_id\":\"894\",\"test_name\":\"SGOT\",\"resultInstrumentID\":0,\"order_id\":\"6\"},{\"id\":\"12\",\"result\":\"30\",\"note\":null,\"test_id\":\"895\",\"test_name\":\"SGPT\",\"resultInstrumentID\":0,\"order_id\":\"6\"}]',1531),(7,'2024-02-01 11:49:49','PROCESS.Result.Verification',6,'05000002GB','null',1531),(8,'2024-02-01 11:49:50','PROCESS.Result.Verification',6,'05000002GB','null',1531),(9,'2024-02-01 11:50:01','PROCESS.Result.Validation',6,'05000002GB','null',1531),(10,'2024-02-01 11:50:02','PROCESS.Result.Validation',6,'05000002GB','null',1531);

--
-- Table structure for table `log_px`
--

CREATE TABLE `log_px` (
  `Log_PxID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_PxDate` datetime NOT NULL DEFAULT current_timestamp(),
  `Log_PxCode` varchar(100) NOT NULL DEFAULT '',
  `Log_PxOrderID` int(11) NOT NULL DEFAULT 0,
  `Log_PxJson` text DEFAULT NULL,
  `Log_PxUserID` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`Log_PxID`),
  KEY `Log_PxDate` (`Log_PxDate`),
  KEY `Log_PxCode` (`Log_PxCode`),
  KEY `Log_PxUserID` (`Log_PxUserID`),
  KEY `Log_PxOrderID` (`Log_PxOrderID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `log_px`
--

INSERT INTO `log_px` VALUES (1,'2024-02-01 10:13:10','PX.FO.NEW',5,'{\"company_id\":1222, \"mou_id\":1036, \"data\":[{\"t_id\":\"894\",\"t_cito\":\"N\",\"t_price\":\"80000\",\"t_disc\":\"0\",\"t_discrp\":\"0\",\"t_req\":\"Y\",\"t_reqnote\":\"\",\"t_ispacket\":\"N\",\"t_packettype\":\"PX\",\"t_packetid\":\"0\"},{\"t_id\":\"895\",\"t_cito\":\"N\",\"t_price\":\"80000\",\"t_disc\":\"0\",\"t_discrp\":\"0\",\"t_req\":\"Y\",\"t_reqnote\":\"\",\"t_ispacket\":\"N\",\"t_packettype\":\"PX\",\"t_packetid\":\"0\"}], \"o_promise\":[\"2024-02-01 15:13:10\"]}',1531),(2,'2024-02-01 11:48:53','PX.FO.NEW',6,'{\"company_id\":1222, \"mou_id\":1036, \"data\":[{\"t_id\":\"894\",\"t_cito\":\"N\",\"t_price\":\"80000\",\"t_disc\":\"0\",\"t_discrp\":\"0\",\"t_req\":\"Y\",\"t_reqnote\":\"\",\"t_ispacket\":\"N\",\"t_packettype\":\"PX\",\"t_packetid\":\"0\"},{\"t_id\":\"895\",\"t_cito\":\"N\",\"t_price\":\"80000\",\"t_disc\":\"0\",\"t_discrp\":\"0\",\"t_req\":\"Y\",\"t_reqnote\":\"\",\"t_ispacket\":\"N\",\"t_packettype\":\"PX\",\"t_packetid\":\"0\"}], \"o_promise\":[\"2024-02-01 15:48:53\"]}',1531);

--
-- Table structure for table `log_receivereference`
--

CREATE TABLE `log_receivereference` (
  `Log_ReceiveReferenceID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_ReceiveReferenceCode` varchar(100) NOT NULL,
  `Log_ReceiveReferenceJson` text NOT NULL,
  `Log_ReceiveReferenceUserID` int(11) NOT NULL,
  `Log_ReceiveReferenceDate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`Log_ReceiveReferenceID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `log_receivereference`
--


--
-- Table structure for table `log_ref_deliveryorder`
--

CREATE TABLE `log_ref_deliveryorder` (
  `Log_RefDeliveryorderID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_RefDeliveryorderDate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `Log_RefDeliveryorderCode` varchar(50) NOT NULL,
  `Log_RefDeliveryorderJson` text NOT NULL,
  `Log_RefDeliveryorderUserID` int(11) NOT NULL,
  PRIMARY KEY (`Log_RefDeliveryorderID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_ref_deliveryorder`
--


--
-- Table structure for table `log_result_couriercominghome`
--

CREATE TABLE `log_result_couriercominghome` (
  `Log_Result_CourierComingHomeID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_Result_CourierComingHomeDateTime` datetime NOT NULL,
  `Log_Result_CourierComingHomeJSON` text NOT NULL,
  `Log_Result_CourierComingHomeUserID` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`Log_Result_CourierComingHomeID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_result_couriercominghome`
--


--
-- Table structure for table `log_result_couriercominghome_detail`
--

CREATE TABLE `log_result_couriercominghome_detail` (
  `Log_Result_CourierComingHomeDetailID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_Result_CourierComingHomeDetailDateTime` datetime NOT NULL,
  `Log_Result_CourierComingHomeDetailJSON` text NOT NULL,
  `Log_Result_CourierComingHomeDetailUserID` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`Log_Result_CourierComingHomeDetailID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_result_couriercominghome_detail`
--


--
-- Table structure for table `log_result_courierspk_detail`
--

CREATE TABLE `log_result_courierspk_detail` (
  `Log_Result_CourierSpkDetailID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_Result_CourierSpkDetailDateTime` datetime NOT NULL,
  `Log_Result_CourierSpkDetailJSON` text NOT NULL,
  `Log_Result_CourierSpkDetailUserID` int(11) NOT NULL,
  PRIMARY KEY (`Log_Result_CourierSpkDetailID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_result_courierspk_detail`
--


--
-- Table structure for table `log_result_front_office`
--

CREATE TABLE `log_result_front_office` (
  `Log_ResultFrontOfficeID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_ResultFrontOfficeDateTime` datetime NOT NULL,
  `Log_ResultFrontOfficeJson` text NOT NULL,
  `Log_ResultFrontOfficeUserID` int(11) NOT NULL,
  PRIMARY KEY (`Log_ResultFrontOfficeID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_result_front_office`
--


--
-- Table structure for table `log_result_verifications_value`
--

CREATE TABLE `log_result_verifications_value` (
  `Log_ResultVerificationsValueID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_ResultVerificationsValueDatetime` datetime NOT NULL,
  `Log_ResultVerificationsValueJson` text NOT NULL,
  `Log_ResultVerificationsValueUserID` int(11) NOT NULL,
  PRIMARY KEY (`Log_ResultVerificationsValueID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_result_verifications_value`
--


--
-- Table structure for table `log_resultauthorization`
--

CREATE TABLE `log_resultauthorization` (
  `Log_ResultAuthorizationID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_ResultAuthorizationDate` datetime NOT NULL,
  `Log_ResultAuthorizationCode` varchar(15) NOT NULL DEFAULT 'CREATED',
  `Log_ResultAuthorizationJSON` text NOT NULL,
  `Log_ResultAuthorizationUserID` int(11) NOT NULL,
  PRIMARY KEY (`Log_ResultAuthorizationID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `log_resultauthorization`
--


--
-- Table structure for table `log_resultemail`
--

CREATE TABLE `log_resultemail` (
  `Log_ResultEmailID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_ResultEmailDate` datetime NOT NULL,
  `Log_ResultEmailCode` varchar(15) NOT NULL DEFAULT 'SENDING' COMMENT 'SENDING, FAILED, DONE',
  `Log_ResultEmailJSON` text NOT NULL,
  `Log_ResultEmailUserID` int(11) NOT NULL,
  PRIMARY KEY (`Log_ResultEmailID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `log_resultemail`
--


--
-- Table structure for table `log_resultentry`
--

CREATE TABLE `log_resultentry` (
  `Log_ResultEntryID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_ResultEntryDate` datetime DEFAULT current_timestamp(),
  `Log_ResultEntryUserID` int(11) DEFAULT NULL,
  `Log_ResultEntryCode` varchar(30) DEFAULT NULL,
  `Log_ResultEntryJson` text DEFAULT NULL,
  PRIMARY KEY (`Log_ResultEntryID`),
  KEY `Log_ResultEntryDate` (`Log_ResultEntryDate`),
  KEY `Log_ResultEntryUserID` (`Log_ResultEntryUserID`),
  KEY `Log_ResultEntryCode` (`Log_ResultEntryCode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_resultentry`
--


--
-- Table structure for table `log_resultentry_so`
--

CREATE TABLE `log_resultentry_so` (
  `Log_ResultEntrySoID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_ResultEntrySoDate` datetime NOT NULL,
  `Log_ResultEntrySoJSON` text NOT NULL,
  `Log_ResultEntrySoUserID` int(11) NOT NULL,
  PRIMARY KEY (`Log_ResultEntrySoID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `log_resultentry_so`
--


--
-- Table structure for table `log_resultsendcourier`
--

CREATE TABLE `log_resultsendcourier` (
  `Log_ResultSendCourierID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_ResultSendCourierDateTime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `Log_ResultSendCourierJson` text NOT NULL,
  `Log_ResultSendCourierUserID` int(11) NOT NULL,
  PRIMARY KEY (`Log_ResultSendCourierID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_resultsendcourier`
--


--
-- Table structure for table `log_resultsendemail`
--

CREATE TABLE `log_resultsendemail` (
  `Log_ResultSendEmailID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_ResultSendEmailDatetime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `Log_ResultSendEmailJson` text NOT NULL,
  `Log_ResultSendEmailUserID` int(11) NOT NULL,
  PRIMARY KEY (`Log_ResultSendEmailID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_resultsendemail`
--


--
-- Table structure for table `log_resultwa`
--

CREATE TABLE `log_resultwa` (
  `Log_ResultWaID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_ResultWaDate` datetime NOT NULL,
  `Log_ResultWaCode` varchar(15) NOT NULL DEFAULT 'SENDING' COMMENT 'SENDING, FAILED, DONE',
  `Log_ResultWaJSON` text NOT NULL,
  `Log_ResultWaUserID` int(11) NOT NULL,
  PRIMARY KEY (`Log_ResultWaID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `log_resultwa`
--


--
-- Table structure for table `log_sample`
--

CREATE TABLE `log_sample` (
  `Log_SampleID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_SampleDate` datetime NOT NULL DEFAULT current_timestamp(),
  `Log_SampleOrderID` int(11) NOT NULL DEFAULT 0,
  `Log_SampleSampleID` int(11) NOT NULL DEFAULT 0,
  `Log_SampleBarcode` varchar(25) NOT NULL DEFAULT '',
  `Log_SampleCode` varchar(50) NOT NULL DEFAULT '',
  `Log_SampleJson` text DEFAULT NULL,
  `Log_SampleUserID` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`Log_SampleID`),
  KEY `Log_SampleDate` (`Log_SampleDate`),
  KEY `Log_SampleOrderID` (`Log_SampleOrderID`),
  KEY `Log_SampleSampleID` (`Log_SampleSampleID`),
  KEY `Log_SampleBarcodeID` (`Log_SampleBarcode`),
  KEY `Log_SampleCode` (`Log_SampleCode`),
  KEY `Log_SampleUserID` (`Log_SampleUserID`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `log_sample`
--

INSERT INTO `log_sample` VALUES (1,'2024-02-01 10:13:10',5,36,'05000001GBSP1','SAMPLING.Sampling.Unsampled','{\"patient_id\": \"50158\"}',0),(2,'2024-02-01 10:13:10',5,36,'05000001GBSP1','SAMPLING.Sampling.Sampled','{\"patient_id\": 50158, \"patient_name\": \"Tn SIR GOBANG \", \"order_number\": \"05000001GB\", \"sample_name\": \"Serum Merah\"}',1531),(3,'2024-02-01 10:13:42',5,36,'05000001GBSP1','SAMPLING.Sampling.Unsampled','{\"patient_id\": 50158, \"patient_name\": \"Tn SIR GOBANG \", \"order_number\": \"05000001GB\", \"sample_name\": \"Serum Merah\"}',1531),(4,'2024-02-01 11:48:53',6,36,'05000002GBSP1','SAMPLING.Sampling.Unsampled','{\"patient_id\": \"50159\"}',0),(5,'2024-02-01 11:48:53',6,36,'05000002GBSP1','SAMPLING.Sampling.Sampled','{\"patient_id\": 50159, \"patient_name\": \"Nn FAJRIAH RASMAQ\", \"order_number\": \"05000002GB\", \"sample_name\": \"Serum Merah\"}',1531),(6,'2024-02-01 11:49:21',6,36,'05000002GBSP1','SAMPLING.Sampling.Unsampled','{\"patient_id\": 50159, \"patient_name\": \"Nn FAJRIAH RASMAQ\", \"order_number\": \"05000002GB\", \"sample_name\": \"Serum Merah\"}',1531);

--
-- Table structure for table `log_sample_order`
--

CREATE TABLE `log_sample_order` (
  `Log_sampleOrderID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_sampleOrderDate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `Log_sampleOrderJson` text NOT NULL,
  `Log_sampleOrderUserID` int(11) DEFAULT NULL,
  PRIMARY KEY (`Log_sampleOrderID`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_sample_order`
--

INSERT INTO `log_sample_order` VALUES (1,'2024-02-01 10:13:10','{\"id\": 1, \"barcode_id\": 1, \"station_id\": 1, \"barcode_number\": \"05000001GBSP1\", \"sampling_status\": \"N\", \"sampling_date\": null, \"sampling_time\": null, \"sampling_user\": null, \"receive_status\": \"N\", \"receive_date\": null, \"receive_time\": null, \"receive_user\": null, \"verification_status\": \"N\", \"verification_date\": null, \"verification_time\": null, \"verification_user\": 0, \"send_handling_status\": \"N\", \"send_handling_date\": null, \"send_handling_time\": null, \"send_handling_user\": 0, \"receive_handling_status\": \"N\", \"receive_handling_date\": null, \"receive_handling_time\": null, \"receive_handling_user\": 0, \"process_ready_time\": null, \"processing_status\": \"N\", \"processing_date\": null, \"processing_time\": null, \"processing_user\": 0, \"created\": \"2024-02-01 10:13:10\", \"worklist_receive\": \"N\", \"worklist_receive_user\": 0, \"worklist_receive_datetime\": null}',NULL),(2,'2024-02-01 10:13:10','{\"id\": 1, \"barcode_id\": 1, \"station_id\": 1, \"barcode_number\": \"05000001GBSP1\", \"sampling_status\": \"Y\", \"sampling_date\": \"2024-02-01\", \"sampling_time\": \"10:13:10\", \"sampling_user\": 1531, \"receive_status\": \"Y\", \"receive_date\": \"2024-02-01\", \"receive_time\": \"10:13:10\", \"receive_user\": 1531, \"verification_status\": \"Y\", \"verification_date\": \"2024-02-01\", \"verification_time\": \"10:13:10\", \"verification_user\": 1531, \"send_handling_status\": \"Y\", \"send_handling_date\": \"2024-02-01\", \"send_handling_time\": \"10:13:10\", \"send_handling_user\": 1531, \"receive_handling_status\": \"Y\", \"receive_handling_date\": \"2024-02-01\", \"receive_handling_time\": \"10:13:10\", \"receive_handling_user\": 1531, \"process_ready_time\": \"2024-02-01 10:13:10\", \"processing_status\": \"Y\", \"processing_date\": \"2024-02-01\", \"processing_time\": \"10:13:10\", \"processing_user\": 1531, \"created\": \"2024-02-01 10:13:10\", \"worklist_receive\": \"N\", \"worklist_receive_user\": 0, \"worklist_receive_datetime\": null}',1531),(3,'2024-02-01 10:13:42','{\"id\": 1, \"barcode_id\": 1, \"station_id\": 1, \"barcode_number\": \"05000001GBSP1\", \"sampling_status\": \"Y\", \"sampling_date\": \"2024-02-01\", \"sampling_time\": \"10:13:10\", \"sampling_user\": 1531, \"receive_status\": \"Y\", \"receive_date\": \"2024-02-01\", \"receive_time\": \"10:13:10\", \"receive_user\": 1531, \"verification_status\": \"Y\", \"verification_date\": \"2024-02-01\", \"verification_time\": \"10:13:10\", \"verification_user\": 1531, \"send_handling_status\": \"Y\", \"send_handling_date\": \"2024-02-01\", \"send_handling_time\": \"10:13:10\", \"send_handling_user\": 1531, \"receive_handling_status\": \"Y\", \"receive_handling_date\": \"2024-02-01\", \"receive_handling_time\": \"10:13:10\", \"receive_handling_user\": 1531, \"process_ready_time\": \"2024-02-01 10:13:10\", \"processing_status\": \"Y\", \"processing_date\": \"2024-02-01\", \"processing_time\": \"10:13:10\", \"processing_user\": 1531, \"created\": \"2024-02-01 10:13:10\", \"worklist_receive\": \"Y\", \"worklist_receive_user\": 1531, \"worklist_receive_datetime\": \"2024-02-01 10:13:42\"}',1531),(4,'2024-02-01 10:13:42','{\"id\": 1, \"barcode_id\": 1, \"station_id\": 1, \"barcode_number\": \"05000001GBSP1\", \"sampling_status\": \"Y\", \"sampling_date\": \"2024-02-01\", \"sampling_time\": \"10:13:10\", \"sampling_user\": 1531, \"receive_status\": \"Y\", \"receive_date\": \"2024-02-01\", \"receive_time\": \"10:13:10\", \"receive_user\": 1531, \"verification_status\": \"Y\", \"verification_date\": \"2024-02-01\", \"verification_time\": \"10:13:10\", \"verification_user\": 1531, \"send_handling_status\": \"Y\", \"send_handling_date\": \"2024-02-01\", \"send_handling_time\": \"10:13:10\", \"send_handling_user\": 1531, \"receive_handling_status\": \"Y\", \"receive_handling_date\": \"2024-02-01\", \"receive_handling_time\": \"10:13:10\", \"receive_handling_user\": 1531, \"process_ready_time\": \"2024-02-01 10:13:10\", \"processing_status\": \"Y\", \"processing_date\": \"2024-02-01\", \"processing_time\": \"10:13:10\", \"processing_user\": 1531, \"created\": \"2024-02-01 10:13:10\", \"worklist_receive\": \"Y\", \"worklist_receive_user\": 1531, \"worklist_receive_datetime\": \"2024-02-01 10:13:42\"}',1531),(5,'2024-02-01 11:48:53','{\"id\": 2, \"barcode_id\": 2, \"station_id\": 1, \"barcode_number\": \"05000002GBSP1\", \"sampling_status\": \"N\", \"sampling_date\": null, \"sampling_time\": null, \"sampling_user\": null, \"receive_status\": \"N\", \"receive_date\": null, \"receive_time\": null, \"receive_user\": null, \"verification_status\": \"N\", \"verification_date\": null, \"verification_time\": null, \"verification_user\": 0, \"send_handling_status\": \"N\", \"send_handling_date\": null, \"send_handling_time\": null, \"send_handling_user\": 0, \"receive_handling_status\": \"N\", \"receive_handling_date\": null, \"receive_handling_time\": null, \"receive_handling_user\": 0, \"process_ready_time\": null, \"processing_status\": \"N\", \"processing_date\": null, \"processing_time\": null, \"processing_user\": 0, \"created\": \"2024-02-01 11:48:53\", \"worklist_receive\": \"N\", \"worklist_receive_user\": 0, \"worklist_receive_datetime\": null}',NULL),(6,'2024-02-01 11:48:53','{\"id\": 2, \"barcode_id\": 2, \"station_id\": 1, \"barcode_number\": \"05000002GBSP1\", \"sampling_status\": \"Y\", \"sampling_date\": \"2024-02-01\", \"sampling_time\": \"11:48:53\", \"sampling_user\": 1531, \"receive_status\": \"Y\", \"receive_date\": \"2024-02-01\", \"receive_time\": \"11:48:53\", \"receive_user\": 1531, \"verification_status\": \"Y\", \"verification_date\": \"2024-02-01\", \"verification_time\": \"11:48:53\", \"verification_user\": 1531, \"send_handling_status\": \"Y\", \"send_handling_date\": \"2024-02-01\", \"send_handling_time\": \"11:48:53\", \"send_handling_user\": 1531, \"receive_handling_status\": \"Y\", \"receive_handling_date\": \"2024-02-01\", \"receive_handling_time\": \"11:48:53\", \"receive_handling_user\": 1531, \"process_ready_time\": \"2024-02-01 11:48:53\", \"processing_status\": \"Y\", \"processing_date\": \"2024-02-01\", \"processing_time\": \"11:48:53\", \"processing_user\": 1531, \"created\": \"2024-02-01 11:48:53\", \"worklist_receive\": \"N\", \"worklist_receive_user\": 0, \"worklist_receive_datetime\": null}',1531),(7,'2024-02-01 11:49:21','{\"id\": 2, \"barcode_id\": 2, \"station_id\": 1, \"barcode_number\": \"05000002GBSP1\", \"sampling_status\": \"Y\", \"sampling_date\": \"2024-02-01\", \"sampling_time\": \"11:48:53\", \"sampling_user\": 1531, \"receive_status\": \"Y\", \"receive_date\": \"2024-02-01\", \"receive_time\": \"11:48:53\", \"receive_user\": 1531, \"verification_status\": \"Y\", \"verification_date\": \"2024-02-01\", \"verification_time\": \"11:48:53\", \"verification_user\": 1531, \"send_handling_status\": \"Y\", \"send_handling_date\": \"2024-02-01\", \"send_handling_time\": \"11:48:53\", \"send_handling_user\": 1531, \"receive_handling_status\": \"Y\", \"receive_handling_date\": \"2024-02-01\", \"receive_handling_time\": \"11:48:53\", \"receive_handling_user\": 1531, \"process_ready_time\": \"2024-02-01 11:48:53\", \"processing_status\": \"Y\", \"processing_date\": \"2024-02-01\", \"processing_time\": \"11:48:53\", \"processing_user\": 1531, \"created\": \"2024-02-01 11:48:53\", \"worklist_receive\": \"Y\", \"worklist_receive_user\": 1531, \"worklist_receive_datetime\": \"2024-02-01 11:49:21\"}',1531),(8,'2024-02-01 11:49:21','{\"id\": 2, \"barcode_id\": 2, \"station_id\": 1, \"barcode_number\": \"05000002GBSP1\", \"sampling_status\": \"Y\", \"sampling_date\": \"2024-02-01\", \"sampling_time\": \"11:48:53\", \"sampling_user\": 1531, \"receive_status\": \"Y\", \"receive_date\": \"2024-02-01\", \"receive_time\": \"11:48:53\", \"receive_user\": 1531, \"verification_status\": \"Y\", \"verification_date\": \"2024-02-01\", \"verification_time\": \"11:48:53\", \"verification_user\": 1531, \"send_handling_status\": \"Y\", \"send_handling_date\": \"2024-02-01\", \"send_handling_time\": \"11:48:53\", \"send_handling_user\": 1531, \"receive_handling_status\": \"Y\", \"receive_handling_date\": \"2024-02-01\", \"receive_handling_time\": \"11:48:53\", \"receive_handling_user\": 1531, \"process_ready_time\": \"2024-02-01 11:48:53\", \"processing_status\": \"Y\", \"processing_date\": \"2024-02-01\", \"processing_time\": \"11:48:53\", \"processing_user\": 1531, \"created\": \"2024-02-01 11:48:53\", \"worklist_receive\": \"Y\", \"worklist_receive_user\": 1531, \"worklist_receive_datetime\": \"2024-02-01 11:49:21\"}',1531);

--
-- Table structure for table `log_sample_req`
--

CREATE TABLE `log_sample_req` (
  `Log_SampleReqID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_SampleReqDate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `Log_SampleReqJson` text NOT NULL,
  `Log_SampleReqUserID` int(11) NOT NULL,
  PRIMARY KEY (`Log_SampleReqID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_sample_req`
--


--
-- Table structure for table `log_samplestorage`
--

CREATE TABLE `log_samplestorage` (
  `Log_SampleStorageID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_SampleStorageDate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `Log_SampleStorageCode` varchar(25) NOT NULL COMMENT 'CREATED.SAVE, CREATED.OUT, CREATED.DESTROY, CANCEL.DESTROY, CREATED.EMPTY,  CANCEL.EMPTY',
  `Log_SampleStorageJSON` text NOT NULL,
  `Log_SampleStorageUserID` int(11) NOT NULL,
  PRIMARY KEY (`Log_SampleStorageID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `log_samplestorage`
--


--
-- Table structure for table `log_sampling_queue`
--

CREATE TABLE `log_sampling_queue` (
  `Log_SamplingQueueID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_SamplingQueueDate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `Log_SamplingQueueCode` varchar(50) DEFAULT NULL,
  `Log_SamplingQueueOrderID` int(11) NOT NULL DEFAULT 0,
  `Log_SamplingQueueStationID` int(11) NOT NULL DEFAULT 0,
  `Log_SamplingQueueJSON` text DEFAULT NULL,
  `Log_SamplingQueueUserID` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`Log_SamplingQueueID`),
  KEY `Log_SamplingQueueDate` (`Log_SamplingQueueDate`),
  KEY `Log_SamplingQueueCode` (`Log_SamplingQueueCode`),
  KEY `Log_SamplingQueueOrderID` (`Log_SamplingQueueOrderID`),
  KEY `Log_SamplingQueueStationID` (`Log_SamplingQueueStationID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `log_sampling_queue`
--

INSERT INTO `log_sampling_queue` VALUES (1,'2024-02-01 10:13:10','QUE.Sampling.Done',5,1,'{\"order_id\": 5, \"station_id\": 1, \"status_id\": \"5\"}',0),(2,'2024-02-01 11:48:53','QUE.Sampling.Done',6,1,'{\"order_id\": 6, \"station_id\": 1, \"status_id\": \"5\"}',0);

--
-- Table structure for table `log_sampling_queue_so`
--

CREATE TABLE `log_sampling_queue_so` (
  `Log_SampleQueueSOID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_SampleQueueSODate` date NOT NULL,
  `Log_SampleQueueSOJSON` text NOT NULL,
  `Log_SampleQueueSOUserID` int(11) NOT NULL,
  PRIMARY KEY (`Log_SampleQueueSOID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `log_sampling_queue_so`
--


--
-- Table structure for table `log_sampling_so_form`
--

CREATE TABLE `log_sampling_so_form` (
  `Log_SamplingSoFormID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_SamplingSoFormDate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `Log_SamplingSoFormJSON` text NOT NULL,
  `Log_SamplingSoFormUserID` int(11) NOT NULL,
  PRIMARY KEY (`Log_SamplingSoFormID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_sampling_so_form`
--


--
-- Table structure for table `log_so_resultentry_fisik_umum`
--

CREATE TABLE `log_so_resultentry_fisik_umum` (
  `LogSo_ResultEntryFisikUmumID` int(11) NOT NULL AUTO_INCREMENT,
  `LogSo_ResultEntryFisikUmumSo_ResultEntryID` int(11) NOT NULL,
  `LogSo_ResultEntryFisikUmumM_LangID` int(11) NOT NULL,
  `LogSo_ResultEntryFisikUmumType` varchar(35) NOT NULL,
  `LogSo_ResultEntryFisikUmumDetails` text NOT NULL,
  `LogSo_ResultEntryFisikUmumIsActive` char(1) NOT NULL,
  `LogSo_ResultEntryFisikUmumUserID` int(11) NOT NULL,
  `LogSo_ResultEntryFisikUmumCreated` datetime NOT NULL,
  `So_ResultEntryFisikUmumLastUpdated` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`LogSo_ResultEntryFisikUmumID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_so_resultentry_fisik_umum`
--


--
-- Table structure for table `log_supplies_barcode`
--

CREATE TABLE `log_supplies_barcode` (
  `Log_SuppliesBarcodeID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_SuppliesBarcodeDate` datetime NOT NULL DEFAULT current_timestamp(),
  `Log_SuppliesBarcodeCode` varchar(100) NOT NULL DEFAULT '',
  `Log_SuppliesBarcodeJson` varchar(2000) DEFAULT NULL,
  `Log_SuppliesBarcodeUserID` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`Log_SuppliesBarcodeID`),
  KEY `Log_SuppliesBarcodeDate` (`Log_SuppliesBarcodeDate`),
  KEY `Log_SuppliesBarcodeCode` (`Log_SuppliesBarcodeCode`),
  KEY `Log_SuppliesBarcodeUserID` (`Log_SuppliesBarcodeUserID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `log_supplies_barcode`
--


--
-- Table structure for table `log_walkletter`
--

CREATE TABLE `log_walkletter` (
  `Log_WalkLetterID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_WalkLetterCode` varchar(7) NOT NULL COMMENT 'SAMPLE, RESULT',
  `Log_WalkLetterDate` datetime NOT NULL,
  `Log_WalkLetterJSON` text NOT NULL,
  `Log_WalkLetterUserID` int(11) NOT NULL,
  PRIMARY KEY (`Log_WalkLetterID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `log_walkletter`
--


--
-- Table structure for table `log_worklist`
--

CREATE TABLE `log_worklist` (
  `Log_WorklistID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_WorklistDate` datetime DEFAULT current_timestamp(),
  `Log_WorklistUserID` int(11) DEFAULT NULL,
  `Log_WorklistCode` varchar(30) DEFAULT NULL,
  `Log_WorklistJson` text DEFAULT NULL,
  PRIMARY KEY (`Log_WorklistID`),
  KEY `Log_WorklistUserID` (`Log_WorklistUserID`),
  KEY `Log_WorklistCode` (`Log_WorklistCode`),
  KEY `Log_WorklistDate` (`Log_WorklistDate`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log_worklist`
--

INSERT INTO `log_worklist` VALUES (1,'2024-02-01 10:13:42',1531,'RECEIVE','{\"T_OrderHeaderID\":\"5\",\"T_SampleTypeID\":null}'),(2,'2024-02-01 10:13:42',1531,'RECEIVE','{\"T_OrderHeaderID\":\"5\",\"T_SampleTypeID\":null}'),(3,'2024-02-01 10:13:45',1531,'PRE.ANALYTIC','{\"T_TestID\":\"4633\",\"T_WorklistID\":\"31\",\"Requirement\":[]}'),(4,'2024-02-01 10:13:47',1531,'PRE.ANALYTIC','{\"T_TestID\":\"4634\",\"T_WorklistID\":\"31\",\"Requirement\":[]}'),(5,'2024-02-01 11:49:21',1531,'RECEIVE','{\"T_OrderHeaderID\":\"6\",\"T_SampleTypeID\":null}'),(6,'2024-02-01 11:49:21',1531,'RECEIVE','{\"T_OrderHeaderID\":\"6\",\"T_SampleTypeID\":null}');

--
-- Table structure for table `result_courierspk_detail_step_by_step`
--

CREATE TABLE `result_courierspk_detail_step_by_step` (
  `Result_CourierDetailStepByStepID` int(11) NOT NULL AUTO_INCREMENT,
  `Result_CourierDetailStepByStepResult_CourierSPKDetailID` int(11) NOT NULL DEFAULT 0,
  `Result_CourierDetailStepByStepUserID` int(11) NOT NULL,
  `Result_CourierDetailStepByStepLastUpdated` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`Result_CourierDetailStepByStepID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `result_courierspk_detail_step_by_step`
--


--
-- Table structure for table `result_handoveremail_log`
--

CREATE TABLE `result_handoveremail_log` (
  `Result_HandOverEmailLogID` int(11) NOT NULL AUTO_INCREMENT,
  `Result_HandOverEmailLogDateTime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `Result_HandOverEmailLogJSON` text NOT NULL,
  `Result_HandOverEmailLogUserID` int(11) NOT NULL,
  PRIMARY KEY (`Result_HandOverEmailLogID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `result_handoveremail_log`
--


--
-- Table structure for table `result_handoverpatient_log`
--

CREATE TABLE `result_handoverpatient_log` (
  `Result_HandOverPatientLogID` int(11) NOT NULL AUTO_INCREMENT,
  `Result_HandOverPatientLogDateTime` datetime NOT NULL,
  `Result_HandOverPatientLogJSON` text NOT NULL,
  `Result_HandOverPatientLogUserID` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`Result_HandOverPatientLogID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `result_handoverpatient_log`
--


--
-- Table structure for table `result_processtooffice_log`
--

CREATE TABLE `result_processtooffice_log` (
  `Result_ProcessToOfficeLogID` int(11) NOT NULL AUTO_INCREMENT,
  `Result_ProcessToOfficeLogDateTime` datetime NOT NULL,
  `Result_ProcessToOfficeLogJSON` text NOT NULL,
  `Result_ProcessToOfficeLogUserID` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`Result_ProcessToOfficeLogID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `result_processtooffice_log`
--


--
-- Table structure for table `time_line`
--

CREATE TABLE `time_line` (
  `TimeLineID` int(11) NOT NULL AUTO_INCREMENT,
  `TimeLineT_OrderHeaderID` int(11) DEFAULT NULL,
  `TimeLineCode` varchar(100) DEFAULT NULL,
  `TimeLineName` varchar(300) DEFAULT NULL,
  `TimeLineDate` datetime DEFAULT NULL,
  `TimeLineUserID` int(11) DEFAULT NULL,
  `TimeLineNote` varchar(300) DEFAULT NULL,
  PRIMARY KEY (`TimeLineID`),
  KEY `TimeLineT_OrderHeaderID` (`TimeLineT_OrderHeaderID`),
  KEY `TimeLineDate` (`TimeLineDate`),
  KEY `TimeLineUserID` (`TimeLineUserID`),
  KEY `TimeLineCode` (`TimeLineCode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `time_line`
--


--
-- Table structure for table `ui_notification`
--

CREATE TABLE `ui_notification` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(100) DEFAULT NULL,
  `data` varchar(300) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ui_notification`
--


--
-- Dumping routines for database 'one_log'
--
/*!50003 DROP PROCEDURE IF EXISTS `log_me` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `log_me`(IN `dtype` varchar(25), IN `dcode` varchar(100), IN `djson` varchar(2000), IN `duserid` int)
BEGIN

IF dtype = "PATIENT" THEN
  INSERT INTO log_patient(Log_PatientCode, Log_PatientJson, Log_PatientUserID)
  SELECT dcode, djson, duserid;

ELSEIF dtype = "DOCTOR" THEN
  INSERT INTO log_doctor(Log_DoctorCode, Log_DoctorJson, Log_DoctorUserID)
  SELECT dcode, djson, duserid;

ELSEIF dtype = "PX" THEN
  INSERT INTO log_px(Log_PxCode, Log_PxJson, Log_PxUserID)
  SELECT dcode, djson, duserid;

ELSEIF dtype = "FO" THEN
  INSERT INTO log_fo(Log_FoCode, Log_FoJson, Log_FoUserID)
  SELECT dcode, djson, duserid;

END IF;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `log_sample` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `log_sample`(IN `orderid` int, IN `sampleid` int, IN `barcode` varchar(25), IN `code` varchar(50), IN `userid` int, IN `json` text)
BEGIN

INSERT INTO log_sample(
Log_SampleOrderID,
Log_SampleSampleID,
Log_SampleBarcode,
Log_SampleCode,
Log_SampleJson,
Log_SampleUserID)
select orderid, sampleid, barcode, code, json, userid;

END ;;
DELIMITER ;


