-- phpMyAdmin SQL Dump
-- version 4.9.0.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Mar 28, 2023 at 08:40 AM
-- Server version: 10.4.6-MariaDB
-- PHP Version: 7.3.9

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!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 utf8mb4 */;

--
-- Database: `usbong_kms`
--

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

--
-- Table structure for table `x_ray_service`
--

CREATE TABLE `x_ray_service` (
  `x_ray_service_id` int(11) NOT NULL,
  `x_ray_body_location_id` int(11) NOT NULL,
  `x_ray_type_id` int(11) NOT NULL,
  `x_ray_price` int(11) NOT NULL,
  `added_datetime_stamp` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `x_ray_service`
--

INSERT INTO `x_ray_service` (`x_ray_service_id`, `x_ray_body_location_id`, `x_ray_type_id`, `x_ray_price`, `added_datetime_stamp`) VALUES
(1, 1, 6, 600, '0000-00-00 00:00:00'),
(2, 2, 14, 400, '0000-00-00 00:00:00'),
(3, 3, 2, 350, '0000-00-00 00:00:00'),
(4, 3, 6, 600, '0000-00-00 00:00:00'),
(5, 4, 6, 400, '0000-00-00 00:00:00'),
(6, 5, 10, 400, '0000-00-00 00:00:00'),
(7, 5, 8, 550, '0000-00-00 00:00:00'),
(8, 6, 6, 400, '0000-00-00 00:00:00'),
(9, 7, 6, 500, '0000-00-00 00:00:00'),
(10, 8, 2, 350, '0000-00-00 00:00:00'),
(11, 8, 6, 500, '0000-00-00 00:00:00'),
(12, 9, 10, 400, '0000-00-00 00:00:00'),
(13, 10, 6, 400, '0000-00-00 00:00:00'),
(14, 9, 8, 550, '0000-00-00 00:00:00'),
(15, 12, 13, 400, '0000-00-00 00:00:00'),
(16, 13, 6, 650, '0000-00-00 00:00:00'),
(17, 14, 6, 500, '0000-00-00 00:00:00'),
(18, 15, 6, 600, '0000-00-00 00:00:00'),
(19, 16, 9, 750, '0000-00-00 00:00:00'),
(20, 17, 6, 650, '0000-00-00 00:00:00'),
(21, 18, 6, 500, '0000-00-00 00:00:00'),
(22, 19, 6, 700, '0000-00-00 00:00:00'),
(23, 20, 6, 700, '0000-00-00 00:00:00'),
(24, 20, 7, 1400, '0000-00-00 00:00:00'),
(25, 20, 12, 1050, '0000-00-00 00:00:00'),
(26, 20, 13, 350, '0000-00-00 00:00:00'),
(27, 21, 2, 500, '0000-00-00 00:00:00'),
(28, 22, 2, 500, '0000-00-00 00:00:00'),
(29, 23, 5, 900, '0000-00-00 00:00:00'),
(30, 24, 3, 500, '0000-00-00 00:00:00'),
(31, 24, 6, 900, '0000-00-00 00:00:00'),
(32, 24, 4, 1350, '0000-00-00 00:00:00'),
(33, 24, 15, 450, '0000-00-00 00:00:00'),
(34, 25, 6, 800, '0000-00-00 00:00:00'),
(35, 25, 11, 900, '0000-00-00 00:00:00'),
(36, 25, 13, 400, '0000-00-00 00:00:00'),
(37, 26, 6, 900, '0000-00-00 00:00:00'),
(38, 27, 6, 800, '0000-00-00 00:00:00'),
(39, 27, 13, 400, '0000-00-00 00:00:00'),
(40, 28, 2, 500, '0000-00-00 00:00:00'),
(41, 1, 6, 600, '2020-08-22 19:56:11'),
(42, 2, 14, 400, '2020-08-22 19:57:08'),
(43, 3, 2, 400, '2020-08-22 19:57:08'),
(44, 3, 6, 800, '2020-08-22 19:57:08'),
(45, 4, 6, 400, '2020-08-22 19:57:08'),
(46, 5, 10, 400, '2020-08-22 19:57:08'),
(47, 5, 8, 600, '2020-08-22 19:57:08'),
(48, 6, 6, 400, '2020-08-22 19:57:08'),
(49, 7, 6, 600, '2020-08-22 19:57:08'),
(50, 8, 2, 400, '2020-08-22 19:57:08'),
(51, 8, 6, 600, '2020-08-22 19:57:08'),
(52, 9, 10, 400, '2020-08-22 19:57:08'),
(53, 9, 8, 600, '2020-08-22 19:57:08'),
(54, 10, 6, 400, '2020-08-22 19:57:08'),
(55, 12, 13, 400, '2020-08-22 19:57:08'),
(56, 13, 6, 650, '2020-08-22 19:57:08'),
(57, 14, 6, 600, '2020-08-22 19:57:09'),
(58, 15, 6, 600, '2020-08-22 19:57:09'),
(59, 16, 9, 750, '2020-08-22 19:57:09'),
(60, 17, 6, 650, '2020-08-22 19:57:09'),
(61, 18, 6, 600, '2020-08-22 19:57:09'),
(62, 19, 6, 800, '2020-08-22 19:57:09'),
(63, 20, 6, 800, '2020-08-22 19:57:09'),
(64, 20, 7, 1400, '2020-08-22 19:57:09'),
(65, 20, 12, 1050, '2020-08-22 19:57:09'),
(66, 20, 13, 400, '2020-08-22 19:57:09'),
(67, 21, 2, 500, '2020-08-22 19:57:09'),
(68, 22, 2, 500, '2020-08-22 19:57:09'),
(69, 23, 5, 1000, '2020-08-22 19:57:09'),
(70, 24, 3, 500, '2020-08-22 19:57:09'),
(71, 24, 6, 1000, '2020-08-22 19:57:09'),
(72, 24, 4, 1800, '2020-08-22 19:57:09'),
(73, 24, 15, 450, '2020-08-22 19:57:09'),
(74, 25, 6, 900, '2020-08-22 19:57:09'),
(75, 25, 11, 1000, '2020-08-22 19:57:09'),
(76, 25, 13, 450, '2020-08-22 19:57:09'),
(77, 26, 6, 1000, '2020-08-22 19:57:09'),
(78, 27, 6, 900, '2020-08-22 19:57:09'),
(79, 27, 13, 450, '2020-08-22 19:57:09'),
(80, 28, 2, 500, '2020-08-22 19:57:09'),
(81, 29, 6, 600, '2020-09-10 04:28:01'),
(82, 1, 6, 600, '2020-09-10 09:00:30'),
(83, 2, 14, 400, '2020-09-10 09:00:30'),
(84, 3, 2, 400, '2020-09-10 09:00:30'),
(85, 3, 6, 800, '2020-09-10 09:00:30'),
(86, 4, 6, 400, '2020-09-10 09:00:30'),
(87, 5, 10, 400, '2020-09-10 09:00:30'),
(88, 5, 8, 600, '2020-09-10 09:00:30'),
(89, 6, 6, 400, '2020-09-10 09:00:30'),
(90, 7, 6, 600, '2020-09-10 09:00:30'),
(91, 8, 2, 400, '2020-09-10 09:00:30'),
(92, 8, 6, 600, '2020-09-10 09:00:30'),
(93, 9, 10, 400, '2020-09-10 09:00:30'),
(94, 9, 8, 600, '2020-09-10 09:00:30'),
(95, 10, 6, 400, '2020-09-10 09:00:31'),
(96, 12, 13, 400, '2020-09-10 09:00:31'),
(97, 13, 6, 650, '2020-09-10 09:00:31'),
(98, 14, 6, 600, '2020-09-10 09:00:31'),
(99, 15, 6, 600, '2020-09-10 09:00:31'),
(100, 29, 6, 600, '2020-09-10 09:00:31'),
(101, 16, 9, 900, '2020-09-10 09:00:31'),
(102, 17, 6, 650, '2020-09-10 09:00:31'),
(103, 18, 6, 600, '2020-09-10 09:00:31'),
(104, 19, 6, 800, '2020-09-10 09:00:31'),
(105, 20, 6, 800, '2020-09-10 09:00:31'),
(106, 20, 7, 1600, '2020-09-10 09:00:31'),
(107, 20, 12, 1200, '2020-09-10 09:00:31'),
(108, 20, 13, 400, '2020-09-10 09:00:31'),
(109, 21, 2, 500, '2020-09-10 09:00:31'),
(110, 22, 2, 500, '2020-09-10 09:00:31'),
(111, 23, 5, 1000, '2020-09-10 09:00:31'),
(112, 24, 3, 500, '2020-09-10 09:00:31'),
(113, 24, 6, 1000, '2020-09-10 09:00:31'),
(114, 24, 4, 1800, '2020-09-10 09:00:31'),
(115, 24, 15, 450, '2020-09-10 09:00:31'),
(116, 25, 6, 900, '2020-09-10 09:00:31'),
(117, 25, 11, 1000, '2020-09-10 09:00:31'),
(118, 25, 13, 450, '2020-09-10 09:00:31'),
(119, 26, 6, 1000, '2020-09-10 09:00:31'),
(120, 27, 6, 900, '2020-09-10 09:00:31'),
(121, 27, 13, 450, '2020-09-10 09:00:31'),
(122, 28, 2, 500, '2020-09-10 09:00:31'),
(125, 1, 6, 600, '2023-03-01 07:25:39'),
(126, 2, 14, 400, '2023-03-01 07:25:39'),
(127, 3, 2, 400, '2023-03-01 07:25:39'),
(128, 3, 6, 800, '2023-03-01 07:25:39'),
(129, 4, 6, 500, '2023-03-01 07:25:39'),
(130, 5, 10, 500, '2023-03-01 07:25:39'),
(131, 5, 8, 650, '2023-03-01 07:25:39'),
(132, 6, 6, 500, '2023-03-01 07:25:39'),
(133, 7, 6, 600, '2023-03-01 07:25:39'),
(134, 8, 2, 500, '2023-03-01 07:25:39'),
(135, 8, 6, 600, '2023-03-01 07:25:39'),
(136, 9, 10, 500, '2023-03-01 07:25:40'),
(137, 9, 8, 650, '2023-03-01 07:25:40'),
(138, 32, 6, 500, '2023-03-01 07:30:56'),
(139, 12, 13, 400, '2023-03-01 07:30:56'),
(140, 33, 13, 500, '2023-03-01 07:31:45'),
(141, 13, 6, 650, '2023-03-01 07:31:46'),
(142, 14, 6, 500, '2023-03-01 07:31:46'),
(143, 15, 6, 600, '2023-03-01 07:31:46'),
(144, 17, 6, 700, '2023-03-01 07:36:06'),
(145, 18, 6, 650, '2023-03-01 07:36:07'),
(146, 19, 6, 800, '2023-03-01 07:36:07'),
(147, 20, 6, 800, '2023-03-01 07:36:07'),
(148, 30, 6, 1200, '2023-03-01 07:36:07'),
(149, 21, 2, 600, '2023-03-01 07:36:07'),
(150, 22, 2, 600, '2023-03-01 07:36:07'),
(151, 23, 5, 1200, '2023-03-01 07:36:07'),
(152, 24, 3, 600, '2023-03-01 07:37:26'),
(153, 24, 6, 1200, '2023-03-01 07:37:26'),
(154, 24, 3, 600, '2023-03-01 07:38:47'),
(155, 24, 6, 1200, '2023-03-01 07:38:47'),
(156, 24, 17, 2200, '2023-03-01 07:38:47'),
(157, 25, 6, 1000, '2023-03-01 07:38:47'),
(158, 25, 11, 1200, '2023-03-01 07:38:47'),
(159, 27, 6, 900, '2023-03-01 07:38:47'),
(160, 27, 13, 500, '2023-03-01 07:38:48'),
(161, 31, 2, 600, '2023-03-01 07:42:51'),
(162, 1, 6, 600, '2023-03-01 07:45:01'),
(163, 2, 14, 400, '2023-03-01 07:45:01'),
(164, 3, 2, 400, '2023-03-01 07:45:01'),
(165, 3, 6, 800, '2023-03-01 07:45:01'),
(166, 4, 6, 500, '2023-03-01 07:45:01'),
(167, 5, 10, 500, '2023-03-01 07:45:02'),
(168, 5, 8, 650, '2023-03-01 07:45:02'),
(169, 6, 6, 500, '2023-03-01 07:45:02'),
(170, 7, 6, 600, '2023-03-01 07:45:02'),
(171, 8, 2, 500, '2023-03-01 07:45:02'),
(172, 8, 6, 600, '2023-03-01 07:45:02'),
(173, 9, 10, 500, '2023-03-01 07:45:02'),
(174, 9, 8, 650, '2023-03-01 07:45:02'),
(175, 32, 6, 500, '2023-03-01 07:45:02'),
(176, 12, 13, 400, '2023-03-01 07:45:02'),
(177, 1, 6, 600, '2023-03-01 07:45:38'),
(178, 2, 14, 400, '2023-03-01 07:45:38'),
(179, 3, 2, 400, '2023-03-01 07:45:38'),
(180, 3, 6, 800, '2023-03-01 07:45:38'),
(181, 4, 6, 500, '2023-03-01 07:45:38'),
(182, 5, 10, 500, '2023-03-01 07:45:38'),
(183, 5, 8, 650, '2023-03-01 07:45:38'),
(184, 6, 6, 500, '2023-03-01 07:45:38'),
(185, 7, 6, 600, '2023-03-01 07:45:39'),
(186, 8, 2, 500, '2023-03-01 07:45:39'),
(187, 8, 6, 600, '2023-03-01 07:45:39'),
(188, 9, 10, 500, '2023-03-01 07:45:39'),
(189, 9, 8, 650, '2023-03-01 07:45:39'),
(190, 32, 6, 500, '2023-03-01 07:45:39'),
(191, 12, 13, 400, '2023-03-01 07:45:39'),
(192, 33, 13, 500, '2023-03-01 07:45:39'),
(193, 13, 6, 650, '2023-03-01 07:45:39'),
(194, 14, 6, 500, '2023-03-01 07:45:39'),
(195, 15, 6, 600, '2023-03-01 07:45:39'),
(196, 16, 9, 900, '2023-03-01 07:50:53'),
(197, 1, 6, 600, '2023-03-01 07:51:01'),
(198, 2, 14, 400, '2023-03-01 07:51:01'),
(199, 3, 2, 400, '2023-03-01 07:51:01'),
(200, 3, 6, 800, '2023-03-01 07:51:01'),
(201, 4, 6, 500, '2023-03-01 07:51:02'),
(202, 5, 10, 500, '2023-03-01 07:51:02'),
(203, 5, 8, 650, '2023-03-01 07:51:02'),
(204, 6, 6, 500, '2023-03-01 07:51:02'),
(205, 7, 6, 600, '2023-03-01 07:51:02'),
(206, 8, 2, 500, '2023-03-01 07:51:02'),
(207, 8, 6, 600, '2023-03-01 07:51:02'),
(208, 9, 10, 500, '2023-03-01 07:51:02'),
(209, 9, 8, 650, '2023-03-01 07:51:02'),
(210, 32, 6, 500, '2023-03-01 07:51:02'),
(211, 12, 13, 400, '2023-03-01 07:51:02'),
(212, 33, 13, 500, '2023-03-01 07:51:02'),
(213, 13, 6, 650, '2023-03-01 07:51:02'),
(214, 14, 6, 500, '2023-03-01 07:51:02'),
(215, 15, 6, 600, '2023-03-01 07:51:02'),
(216, 16, 9, 900, '2023-03-01 07:51:02'),
(217, 17, 6, 700, '2023-03-01 07:51:02'),
(218, 18, 6, 650, '2023-03-01 07:51:02'),
(219, 19, 6, 800, '2023-03-01 07:51:03'),
(220, 20, 6, 800, '2023-03-01 07:51:03'),
(221, 30, 6, 1200, '2023-03-01 07:51:03'),
(222, 21, 2, 600, '2023-03-01 07:51:03'),
(223, 22, 2, 600, '2023-03-01 07:51:03'),
(224, 23, 5, 1200, '2023-03-01 07:51:03'),
(225, 1, 6, 600, '2023-03-01 07:51:46'),
(226, 2, 14, 400, '2023-03-01 07:51:46'),
(227, 3, 2, 400, '2023-03-01 07:51:46'),
(228, 3, 6, 800, '2023-03-01 07:51:46'),
(229, 4, 6, 500, '2023-03-01 07:51:46'),
(230, 5, 10, 500, '2023-03-01 07:51:46'),
(231, 5, 8, 650, '2023-03-01 07:51:46'),
(232, 6, 6, 500, '2023-03-01 07:51:46'),
(233, 7, 6, 600, '2023-03-01 07:51:46'),
(234, 8, 2, 500, '2023-03-01 07:51:46'),
(235, 8, 6, 600, '2023-03-01 07:51:46'),
(236, 9, 10, 500, '2023-03-01 07:51:46'),
(237, 9, 8, 650, '2023-03-01 07:51:46'),
(238, 32, 6, 500, '2023-03-01 07:51:46'),
(239, 12, 13, 400, '2023-03-01 07:51:46'),
(240, 33, 13, 500, '2023-03-01 07:51:46'),
(241, 13, 6, 650, '2023-03-01 07:51:46'),
(242, 14, 6, 500, '2023-03-01 07:51:46'),
(243, 15, 6, 600, '2023-03-01 07:51:46'),
(244, 16, 9, 900, '2023-03-01 07:51:46'),
(245, 17, 6, 700, '2023-03-01 07:51:46'),
(246, 18, 6, 650, '2023-03-01 07:51:46'),
(247, 19, 6, 800, '2023-03-01 07:51:47'),
(248, 20, 6, 800, '2023-03-01 07:51:47'),
(249, 30, 6, 1200, '2023-03-01 07:51:47'),
(250, 21, 2, 600, '2023-03-01 07:51:47'),
(251, 22, 2, 600, '2023-03-01 07:51:47'),
(252, 23, 5, 1200, '2023-03-01 07:51:47'),
(253, 23, 0, 1200, '2023-03-01 07:51:47'),
(254, 24, 3, 600, '2023-03-01 07:51:47'),
(255, 24, 6, 1200, '2023-03-01 07:51:47'),
(256, 24, 17, 2200, '2023-03-01 07:51:47'),
(257, 25, 6, 1000, '2023-03-01 07:51:47'),
(258, 25, 11, 1200, '2023-03-01 07:51:47'),
(259, 27, 6, 900, '2023-03-01 07:51:47'),
(260, 27, 13, 500, '2023-03-01 07:51:47'),
(261, 35, 1, 600, '2023-03-01 07:51:47'),
(262, 31, 2, 600, '2023-03-01 07:51:47'),
(263, 1, 6, 600, '2023-03-09 06:15:44'),
(264, 2, 14, 400, '2023-03-09 06:15:44'),
(265, 3, 2, 400, '2023-03-09 06:15:45'),
(266, 3, 6, 800, '2023-03-09 06:15:45'),
(267, 4, 6, 500, '2023-03-09 06:15:45'),
(268, 5, 10, 500, '2023-03-09 06:15:45'),
(269, 5, 8, 650, '2023-03-09 06:15:45'),
(270, 6, 6, 500, '2023-03-09 06:15:45'),
(271, 7, 6, 600, '2023-03-09 06:15:45'),
(272, 8, 2, 500, '2023-03-09 06:15:45'),
(273, 8, 6, 600, '2023-03-09 06:15:45'),
(274, 9, 10, 500, '2023-03-09 06:15:45'),
(275, 9, 8, 650, '2023-03-09 06:15:45'),
(276, 32, 6, 500, '2023-03-09 06:15:45'),
(277, 12, 13, 400, '2023-03-09 06:15:45'),
(278, 33, 13, 500, '2023-03-09 06:15:45'),
(279, 13, 6, 650, '2023-03-09 06:15:45'),
(280, 14, 6, 500, '2023-03-09 06:15:45'),
(281, 29, 6, 600, '2023-03-09 06:15:45'),
(282, 34, 9, 900, '2023-03-09 06:15:45'),
(283, 17, 6, 700, '2023-03-09 06:15:46'),
(284, 18, 6, 650, '2023-03-09 06:15:46'),
(285, 19, 6, 800, '2023-03-09 06:15:46'),
(286, 20, 6, 800, '2023-03-09 06:15:46'),
(287, 30, 6, 1200, '2023-03-09 06:15:46'),
(288, 21, 2, 600, '2023-03-09 06:15:46'),
(289, 22, 2, 600, '2023-03-09 06:15:46'),
(290, 23, 5, 1200, '2023-03-09 06:15:46'),
(291, 23, 0, 1200, '2023-03-09 06:15:46'),
(292, 24, 3, 600, '2023-03-09 06:15:46'),
(293, 24, 6, 1200, '2023-03-09 06:15:46'),
(294, 24, 17, 2200, '2023-03-09 06:15:46'),
(295, 25, 6, 1000, '2023-03-09 06:15:46'),
(296, 25, 11, 1200, '2023-03-09 06:15:46'),
(297, 27, 6, 900, '2023-03-09 06:15:46'),
(298, 27, 13, 500, '2023-03-09 06:15:46'),
(299, 35, 1, 600, '2023-03-09 06:15:46'),
(300, 31, 2, 600, '2023-03-09 06:15:46');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `x_ray_service`
--
ALTER TABLE `x_ray_service`
  ADD PRIMARY KEY (`x_ray_service_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `x_ray_service`
--
ALTER TABLE `x_ray_service`
  MODIFY `x_ray_service_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=301;
COMMIT;

/*!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 */;
