-- phpMyAdmin SQL Dump
-- version 4.9.0.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Apr 11, 2022 at 06:01 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');

--
-- 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=125;
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 */;
