-- phpMyAdmin SQL Dump
-- version 4.2.7.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Aug 24, 2020 at 02:23 PM
-- Server version: 5.5.39
-- PHP Version: 5.4.31

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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 utf8 */;

--
-- Database: `usbong_kms`
--

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

--
-- Table structure for table `image`
--

CREATE TABLE IF NOT EXISTS `image` (
`image_id` int(11) NOT NULL,
  `transaction_id` int(11) NOT NULL,
  `image_filename` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `inventory`
--

CREATE TABLE IF NOT EXISTS `inventory` (
`inventory_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `quantity_in_stock` int(11) NOT NULL DEFAULT '0',
  `expiration_date` date NOT NULL,
  `added_datetime_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=450 ;

--
-- Dumping data for table `inventory`
--

INSERT INTO `inventory` (`inventory_id`, `item_id`, `quantity_in_stock`, `expiration_date`, `added_datetime_stamp`) VALUES
(1, 1, 884, '2021-09-01', '2020-04-05 16:34:13'),
(2, 2, 716, '2021-03-01', '2020-04-05 16:34:13'),
(3, 3, 404, '2020-12-01', '2020-04-05 16:34:13'),
(4, 4, 0, '0000-00-00', '2020-04-05 16:34:13'),
(5, 5, 0, '0000-00-00', '2020-04-05 16:34:13'),
(6, 6, 3200, '2022-10-01', '2020-04-05 16:34:13'),
(7, 7, 0, '0000-00-00', '2020-04-05 16:34:13'),
(8, 8, 0, '0000-00-00', '2020-04-05 16:34:13'),
(9, 9, 48, '2021-06-01', '2020-04-05 16:34:13'),
(10, 10, 12, '2021-04-01', '2020-04-05 16:34:13'),
(11, 11, 0, '0000-00-00', '2020-04-05 16:34:13'),
(12, 12, 3842, '2021-05-01', '2020-04-05 16:34:13'),
(13, 13, 308, '2020-11-01', '2020-04-05 16:34:13'),
(14, 14, 149, '2021-07-01', '2020-04-05 16:34:13'),
(15, 15, 152, '2021-03-01', '2020-04-05 16:34:13'),
(16, 15, 365, '2021-04-01', '2020-04-05 16:34:13'),
(17, 15, 100, '2021-10-01', '2020-04-05 16:34:13'),
(18, 16, 0, '0000-00-00', '2020-04-05 16:34:13'),
(19, 17, 108, '2022-09-01', '2020-04-05 16:34:13'),
(20, 18, 139, '2022-01-01', '2020-04-05 16:34:13'),
(21, 19, 0, '0000-00-00', '2020-04-05 16:34:13'),
(22, 20, 200, '2020-12-01', '2020-04-05 16:34:14'),
(23, 21, 393, '2021-07-01', '2020-04-05 16:34:14'),
(24, 22, 415, '2022-06-01', '2020-04-05 16:34:14'),
(25, 23, 0, '0000-00-00', '2020-04-05 16:34:14'),
(26, 24, 130, '2022-01-01', '2020-04-05 16:34:14'),
(27, 25, 70, '2020-05-01', '2020-04-05 16:34:14'),
(28, 26, 26, '2021-09-01', '2020-04-05 16:34:14'),
(29, 27, 213, '2022-08-01', '2020-04-05 16:34:14'),
(30, 28, 176, '2021-04-01', '2020-04-05 16:34:14'),
(31, 29, 264, '2022-02-01', '2020-04-05 16:34:14'),
(32, 30, 73, '2021-02-01', '2020-04-05 16:34:14'),
(33, 30, 100, '2021-08-01', '2020-04-05 16:34:14'),
(34, 31, 36, '2022-07-01', '2020-04-05 16:34:14'),
(35, 32, 0, '0000-00-00', '2020-04-05 16:34:14'),
(36, 33, 140, '2020-05-01', '2020-04-05 16:34:14'),
(37, 34, 100, '2020-05-01', '2020-04-05 16:34:14'),
(38, 35, 48, '2020-06-01', '2020-04-05 16:34:14'),
(39, 36, 25, '2021-04-01', '2020-04-05 16:34:14'),
(40, 37, 0, '0000-00-00', '2020-04-05 16:34:14'),
(41, 38, 25, '2022-04-01', '2020-04-05 16:34:14'),
(42, 39, 893, '2022-03-01', '2020-04-05 16:34:14'),
(43, 40, 511, '2022-04-01', '2020-04-05 16:34:14'),
(44, 41, 7252, '2020-10-01', '2020-04-05 16:34:15'),
(45, 42, 230, '2022-02-01', '2020-04-05 16:34:15'),
(46, 43, 0, '0000-00-00', '2020-04-05 16:34:15'),
(47, 44, 0, '0000-00-00', '2020-04-05 16:34:15'),
(48, 45, 0, '0000-00-00', '2020-04-05 16:34:15'),
(49, 46, 106, '2021-10-01', '2020-04-05 16:34:15'),
(50, 46, 450, '2022-02-01', '2020-04-05 16:34:15'),
(51, 47, 104, '2021-01-01', '2020-04-05 16:34:15'),
(52, 48, 371, '2022-01-01', '2020-04-05 16:34:15'),
(53, 48, 263, '2022-05-01', '2020-04-05 16:34:15'),
(54, 49, 0, '0000-00-00', '2020-04-05 16:34:15'),
(55, 50, 1, '2024-03-01', '2020-04-05 16:34:15'),
(56, 51, 236, '2022-04-01', '2020-04-05 16:34:15'),
(57, 52, 100, '2021-02-01', '2020-04-05 16:34:15'),
(58, 53, 581, '2021-03-01', '2020-04-05 16:34:15'),
(59, 54, 240, '2020-10-01', '2020-04-05 16:34:15'),
(60, 55, 247, '2022-09-01', '2020-04-05 16:34:15'),
(61, 56, 217, '2022-08-01', '2020-04-05 16:34:15'),
(62, 57, 0, '0000-00-00', '2020-04-05 16:34:15'),
(63, 58, 34, '2021-05-01', '2020-04-05 16:34:15'),
(64, 59, 213, '2021-11-01', '2020-04-05 16:34:15'),
(65, 60, 0, '0000-00-00', '2020-04-05 16:34:15'),
(66, 61, 1846, '2020-11-01', '2020-04-05 16:34:15'),
(67, 62, 404, '2021-02-01', '2020-04-05 16:34:16'),
(68, 63, 31, '2020-07-01', '2020-04-05 16:34:16'),
(69, 64, 0, '0000-00-00', '2020-04-05 16:34:16'),
(70, 65, 61, '2021-12-01', '2020-04-05 16:34:16'),
(71, 66, 5, '2020-09-01', '2020-04-05 16:34:16'),
(72, 66, 100, '2020-12-01', '2020-04-05 16:34:16'),
(73, 66, 100, '2021-06-01', '2020-04-05 16:34:16'),
(74, 67, 15, '2020-12-01', '2020-04-05 16:34:16'),
(75, 67, 100, '2021-10-01', '2020-04-05 16:34:16'),
(76, 68, 244, '2022-03-01', '2020-04-05 16:34:16'),
(77, 69, 362, '2021-09-01', '2020-04-05 16:34:16'),
(78, 70, 246, '2021-04-01', '2020-04-05 16:34:16'),
(79, 71, 0, '0000-00-00', '2020-04-05 16:34:16'),
(80, 72, 90, '2020-11-01', '2020-04-05 16:34:16'),
(81, 73, 5, '2021-09-01', '2020-04-05 16:34:16'),
(82, 73, 20, '2021-10-01', '2020-04-05 16:34:16'),
(83, 74, 110, '2020-10-01', '2020-04-05 16:34:16'),
(84, 74, 75, '2021-05-01', '2020-04-05 16:34:16'),
(85, 75, 0, '0000-00-00', '2020-04-05 16:34:16'),
(86, 76, 33, '2020-05-01', '2020-04-05 16:34:16'),
(87, 76, 100, '2021-11-01', '2020-04-05 16:34:16'),
(88, 77, 111, '2021-09-01', '2020-04-05 16:34:17'),
(89, 78, 402, '2021-08-01', '2020-04-05 16:34:17'),
(90, 79, 88, '2020-08-01', '2020-04-05 16:34:17'),
(91, 80, 737, '2022-12-01', '2020-04-05 16:34:17'),
(92, 81, 0, '0000-00-00', '2020-04-05 16:34:17'),
(93, 82, 261, '2021-04-01', '2020-04-05 16:34:17'),
(94, 83, 103, '2020-06-01', '2020-04-05 16:34:17'),
(95, 84, 346, '2022-01-01', '2020-04-05 16:34:17'),
(96, 84, 1125, '2022-10-01', '2020-04-05 16:34:17'),
(97, 85, 209, '2021-08-01', '2020-04-05 16:34:17'),
(98, 85, 200, '2021-10-01', '2020-04-05 16:34:17'),
(99, 86, 117, '2022-03-01', '2020-04-05 16:34:17'),
(100, 87, 600, '2022-07-01', '2020-04-05 16:34:17'),
(101, 88, 400, '2022-08-01', '2020-04-05 16:34:17'),
(102, 89, 60, '2021-10-01', '2020-04-05 16:34:17'),
(103, 90, 0, '0000-00-00', '2020-04-05 16:34:17'),
(104, 91, 212, '2021-07-01', '2020-04-05 16:34:17'),
(105, 92, 201, '2021-07-01', '2020-04-05 16:34:17'),
(106, 93, 0, '0000-00-00', '2020-04-05 16:34:17'),
(107, 94, 0, '0000-00-00', '2020-04-05 16:34:17'),
(108, 95, 206, '2022-11-01', '2020-04-05 16:34:17'),
(109, 96, 858, '2021-05-01', '2020-04-05 16:34:17'),
(110, 97, 440, '2021-11-01', '2020-04-05 16:34:17'),
(111, 98, 1, '2022-05-01', '2020-04-05 16:34:17'),
(112, 99, -1, '0000-00-00', '2020-04-05 16:34:17'),
(113, 100, -1, '0000-00-00', '2020-04-05 16:34:17'),
(114, 101, 5, '2022-03-01', '2020-04-05 16:34:17'),
(115, 102, 5, '2022-08-01', '2020-04-05 16:34:18'),
(116, 21, 100, '2021-07-01', '2020-05-15 05:10:26'),
(117, 98, 10, '2024-05-01', '2020-05-27 07:40:05'),
(118, 3, 10, '2024-05-01', '2020-05-30 09:54:33'),
(119, 413, 10, '0000-00-00', '2020-06-15 05:57:44'),
(120, 102, -1, '0000-00-00', '2020-06-16 23:13:38'),
(121, 103, -1, '0000-00-00', '2020-06-16 23:19:04'),
(122, 104, -1, '0000-00-00', '2020-06-16 23:19:04'),
(123, 105, -1, '0000-00-00', '2020-06-16 23:19:04'),
(124, 106, -1, '0000-00-00', '2020-06-16 23:19:04'),
(125, 107, -1, '0000-00-00', '2020-06-16 23:19:04'),
(126, 108, -1, '0000-00-00', '2020-06-16 23:19:04'),
(127, 109, -1, '0000-00-00', '2020-06-16 23:19:04'),
(128, 110, -1, '0000-00-00', '2020-06-16 23:19:04'),
(129, 111, -1, '0000-00-00', '2020-06-16 23:19:04'),
(130, 112, -1, '0000-00-00', '2020-06-16 23:19:05'),
(131, 113, -1, '0000-00-00', '2020-06-16 23:19:05'),
(132, 114, -1, '0000-00-00', '2020-06-16 23:19:05'),
(133, 115, -1, '0000-00-00', '2020-06-16 23:19:05'),
(134, 116, -1, '0000-00-00', '2020-06-16 23:19:05'),
(135, 117, -1, '0000-00-00', '2020-06-16 23:19:05'),
(136, 118, -1, '0000-00-00', '2020-06-16 23:19:05'),
(137, 119, -1, '0000-00-00', '2020-06-16 23:19:05'),
(138, 120, -1, '0000-00-00', '2020-06-16 23:19:05'),
(139, 121, -1, '0000-00-00', '2020-06-16 23:19:05'),
(140, 122, -1, '0000-00-00', '2020-06-16 23:19:05'),
(141, 123, -1, '0000-00-00', '2020-06-16 23:19:05'),
(142, 124, -1, '0000-00-00', '2020-06-16 23:19:05'),
(143, 125, -1, '0000-00-00', '2020-06-16 23:19:05'),
(144, 126, -1, '0000-00-00', '2020-06-16 23:19:05'),
(145, 127, -1, '0000-00-00', '2020-06-16 23:19:05'),
(146, 128, -1, '0000-00-00', '2020-06-16 23:19:05'),
(147, 129, -1, '0000-00-00', '2020-06-16 23:19:05'),
(148, 130, -1, '0000-00-00', '2020-06-16 23:19:05'),
(149, 131, -1, '0000-00-00', '2020-06-16 23:19:05'),
(150, 132, -1, '0000-00-00', '2020-06-16 23:19:05'),
(151, 133, -1, '0000-00-00', '2020-06-16 23:19:05'),
(152, 134, -1, '0000-00-00', '2020-06-16 23:19:05'),
(153, 135, -1, '0000-00-00', '2020-06-16 23:19:05'),
(154, 136, -1, '0000-00-00', '2020-06-16 23:19:05'),
(155, 137, -1, '0000-00-00', '2020-06-16 23:19:05'),
(156, 138, -1, '0000-00-00', '2020-06-16 23:19:05'),
(157, 139, -1, '0000-00-00', '2020-06-16 23:19:05'),
(158, 140, -1, '0000-00-00', '2020-06-16 23:19:05'),
(159, 141, -1, '0000-00-00', '2020-06-16 23:19:06'),
(160, 142, -1, '0000-00-00', '2020-06-16 23:19:06'),
(161, 143, -1, '0000-00-00', '2020-06-16 23:19:06'),
(162, 144, -1, '0000-00-00', '2020-06-16 23:19:06'),
(163, 145, -1, '0000-00-00', '2020-06-16 23:19:06'),
(164, 146, -1, '0000-00-00', '2020-06-16 23:19:06'),
(165, 147, -1, '0000-00-00', '2020-06-16 23:19:06'),
(166, 148, -1, '0000-00-00', '2020-06-16 23:19:06'),
(167, 149, -1, '0000-00-00', '2020-06-16 23:19:06'),
(168, 150, -1, '0000-00-00', '2020-06-16 23:19:06'),
(169, 151, -1, '0000-00-00', '2020-06-16 23:19:06'),
(170, 152, -1, '0000-00-00', '2020-06-16 23:19:06'),
(171, 153, -1, '0000-00-00', '2020-06-16 23:19:06'),
(172, 154, -1, '0000-00-00', '2020-06-16 23:19:06'),
(173, 155, -1, '0000-00-00', '2020-06-16 23:19:06'),
(174, 156, -1, '0000-00-00', '2020-06-16 23:19:06'),
(175, 157, -1, '0000-00-00', '2020-06-16 23:19:06'),
(176, 158, -1, '0000-00-00', '2020-06-16 23:19:06'),
(177, 159, -1, '0000-00-00', '2020-06-16 23:19:06'),
(178, 160, -1, '0000-00-00', '2020-06-16 23:19:06'),
(179, 161, -1, '0000-00-00', '2020-06-16 23:19:06'),
(180, 162, -1, '0000-00-00', '2020-06-16 23:19:06'),
(181, 163, -1, '0000-00-00', '2020-06-16 23:19:06'),
(182, 164, -1, '0000-00-00', '2020-06-16 23:19:06'),
(183, 165, -1, '0000-00-00', '2020-06-16 23:19:06'),
(184, 166, -1, '0000-00-00', '2020-06-16 23:19:06'),
(185, 167, -1, '0000-00-00', '2020-06-16 23:19:06'),
(186, 168, -1, '0000-00-00', '2020-06-16 23:19:06'),
(187, 169, -1, '0000-00-00', '2020-06-16 23:19:07'),
(188, 170, -1, '0000-00-00', '2020-06-16 23:19:07'),
(189, 171, -1, '0000-00-00', '2020-06-16 23:19:07'),
(190, 172, -1, '0000-00-00', '2020-06-16 23:19:07'),
(191, 173, -1, '0000-00-00', '2020-06-16 23:19:07'),
(192, 174, -1, '0000-00-00', '2020-06-16 23:19:07'),
(193, 175, -1, '0000-00-00', '2020-06-16 23:19:07'),
(194, 176, -1, '0000-00-00', '2020-06-16 23:19:07'),
(195, 177, -1, '0000-00-00', '2020-06-16 23:19:07'),
(196, 178, -1, '0000-00-00', '2020-06-16 23:19:07'),
(197, 179, -1, '0000-00-00', '2020-06-16 23:19:07'),
(198, 180, -1, '0000-00-00', '2020-06-16 23:19:07'),
(199, 181, -1, '0000-00-00', '2020-06-16 23:19:07'),
(200, 182, -1, '0000-00-00', '2020-06-16 23:19:07'),
(201, 183, -1, '0000-00-00', '2020-06-16 23:19:07'),
(202, 184, -1, '0000-00-00', '2020-06-16 23:19:07'),
(203, 185, -1, '0000-00-00', '2020-06-16 23:19:07'),
(204, 186, -1, '0000-00-00', '2020-06-16 23:19:07'),
(205, 187, -1, '0000-00-00', '2020-06-16 23:19:07'),
(206, 188, -1, '0000-00-00', '2020-06-16 23:19:07'),
(207, 189, -1, '0000-00-00', '2020-06-16 23:19:07'),
(208, 190, -1, '0000-00-00', '2020-06-16 23:19:07'),
(209, 191, -1, '0000-00-00', '2020-06-16 23:19:07'),
(210, 192, -1, '0000-00-00', '2020-06-16 23:19:07'),
(211, 193, -1, '0000-00-00', '2020-06-16 23:19:07'),
(212, 194, -1, '0000-00-00', '2020-06-16 23:19:07'),
(213, 195, -1, '0000-00-00', '2020-06-16 23:19:07'),
(214, 196, -1, '0000-00-00', '2020-06-16 23:19:07'),
(215, 197, -1, '0000-00-00', '2020-06-16 23:19:07'),
(216, 198, -1, '0000-00-00', '2020-06-16 23:19:08'),
(217, 199, -1, '0000-00-00', '2020-06-16 23:19:08'),
(218, 200, -1, '0000-00-00', '2020-06-16 23:19:08'),
(219, 201, -1, '0000-00-00', '2020-06-16 23:19:08'),
(220, 202, -1, '0000-00-00', '2020-06-16 23:19:08'),
(221, 203, -1, '0000-00-00', '2020-06-16 23:19:08'),
(222, 204, -1, '0000-00-00', '2020-06-16 23:19:08'),
(223, 205, -1, '0000-00-00', '2020-06-16 23:19:08'),
(224, 206, -1, '0000-00-00', '2020-06-16 23:19:08'),
(225, 207, -1, '0000-00-00', '2020-06-16 23:19:08'),
(226, 208, -1, '0000-00-00', '2020-06-16 23:19:08'),
(227, 209, -1, '0000-00-00', '2020-06-16 23:19:08'),
(228, 210, -1, '0000-00-00', '2020-06-16 23:19:08'),
(229, 211, -1, '0000-00-00', '2020-06-16 23:19:08'),
(230, 212, -1, '0000-00-00', '2020-06-16 23:19:08'),
(231, 213, -1, '0000-00-00', '2020-06-16 23:19:08'),
(232, 214, -1, '0000-00-00', '2020-06-16 23:19:08'),
(233, 215, -1, '0000-00-00', '2020-06-16 23:19:08'),
(234, 216, -1, '0000-00-00', '2020-06-16 23:19:08'),
(235, 217, -1, '0000-00-00', '2020-06-16 23:19:08'),
(236, 218, -1, '0000-00-00', '2020-06-16 23:19:08'),
(237, 219, -1, '0000-00-00', '2020-06-16 23:19:08'),
(238, 220, -1, '0000-00-00', '2020-06-16 23:19:08'),
(239, 221, -1, '0000-00-00', '2020-06-16 23:19:08'),
(240, 222, -1, '0000-00-00', '2020-06-16 23:19:08'),
(241, 223, -1, '0000-00-00', '2020-06-16 23:19:08'),
(242, 224, -1, '0000-00-00', '2020-06-16 23:19:08'),
(243, 225, -1, '0000-00-00', '2020-06-16 23:19:08'),
(244, 226, -1, '0000-00-00', '2020-06-16 23:19:09'),
(245, 227, -1, '0000-00-00', '2020-06-16 23:19:09'),
(246, 228, -1, '0000-00-00', '2020-06-16 23:19:09'),
(247, 229, -1, '0000-00-00', '2020-06-16 23:19:09'),
(248, 230, -1, '0000-00-00', '2020-06-16 23:19:09'),
(249, 231, -1, '0000-00-00', '2020-06-16 23:19:09'),
(250, 232, -1, '0000-00-00', '2020-06-16 23:19:09'),
(251, 233, -1, '0000-00-00', '2020-06-16 23:19:09'),
(252, 234, -1, '0000-00-00', '2020-06-16 23:19:09'),
(253, 235, -1, '0000-00-00', '2020-06-16 23:19:09'),
(254, 236, -1, '0000-00-00', '2020-06-16 23:19:09'),
(255, 237, -1, '0000-00-00', '2020-06-16 23:19:09'),
(256, 238, -1, '0000-00-00', '2020-06-16 23:19:09'),
(257, 239, -1, '0000-00-00', '2020-06-16 23:19:09'),
(258, 240, -1, '0000-00-00', '2020-06-16 23:19:09'),
(259, 241, -1, '0000-00-00', '2020-06-16 23:19:09'),
(260, 242, -1, '0000-00-00', '2020-06-16 23:19:09'),
(261, 243, -1, '0000-00-00', '2020-06-16 23:19:09'),
(262, 244, -1, '0000-00-00', '2020-06-16 23:19:09'),
(263, 245, -1, '0000-00-00', '2020-06-16 23:19:09'),
(264, 246, -1, '0000-00-00', '2020-06-16 23:19:09'),
(265, 247, -1, '0000-00-00', '2020-06-16 23:19:09'),
(266, 248, -1, '0000-00-00', '2020-06-16 23:19:09'),
(267, 249, -1, '0000-00-00', '2020-06-16 23:19:09'),
(268, 250, -1, '0000-00-00', '2020-06-16 23:19:09'),
(269, 251, -1, '0000-00-00', '2020-06-16 23:19:09'),
(270, 252, -1, '0000-00-00', '2020-06-16 23:19:09'),
(271, 253, -1, '0000-00-00', '2020-06-16 23:19:09'),
(272, 254, -1, '0000-00-00', '2020-06-16 23:19:09'),
(273, 255, -1, '0000-00-00', '2020-06-16 23:19:10'),
(274, 256, -1, '0000-00-00', '2020-06-16 23:19:10'),
(275, 257, -1, '0000-00-00', '2020-06-16 23:19:10'),
(276, 258, -1, '0000-00-00', '2020-06-16 23:19:10'),
(277, 259, -1, '0000-00-00', '2020-06-16 23:19:10'),
(278, 260, -1, '0000-00-00', '2020-06-16 23:19:10'),
(279, 261, -1, '0000-00-00', '2020-06-16 23:19:10'),
(280, 262, -1, '0000-00-00', '2020-06-16 23:19:10'),
(281, 263, -1, '0000-00-00', '2020-06-16 23:19:10'),
(282, 264, -1, '0000-00-00', '2020-06-16 23:19:10'),
(283, 265, -1, '0000-00-00', '2020-06-16 23:19:10'),
(284, 266, -1, '0000-00-00', '2020-06-16 23:19:10'),
(285, 267, -1, '0000-00-00', '2020-06-16 23:19:10'),
(286, 268, -1, '0000-00-00', '2020-06-16 23:19:10'),
(287, 269, -1, '0000-00-00', '2020-06-16 23:19:10'),
(288, 270, -1, '0000-00-00', '2020-06-16 23:19:10'),
(289, 271, -1, '0000-00-00', '2020-06-16 23:19:10'),
(290, 272, -1, '0000-00-00', '2020-06-16 23:19:10'),
(291, 273, -1, '0000-00-00', '2020-06-16 23:19:10'),
(292, 274, -1, '0000-00-00', '2020-06-16 23:19:10'),
(293, 275, -1, '0000-00-00', '2020-06-16 23:19:10'),
(294, 276, -1, '0000-00-00', '2020-06-16 23:19:10'),
(295, 277, -1, '0000-00-00', '2020-06-16 23:19:10'),
(296, 278, -1, '0000-00-00', '2020-06-16 23:19:10'),
(297, 279, -1, '0000-00-00', '2020-06-16 23:19:10'),
(298, 280, -1, '0000-00-00', '2020-06-16 23:19:10'),
(299, 281, -1, '0000-00-00', '2020-06-16 23:19:10'),
(300, 282, -1, '0000-00-00', '2020-06-16 23:19:10'),
(301, 283, -1, '0000-00-00', '2020-06-16 23:19:10'),
(302, 284, -1, '0000-00-00', '2020-06-16 23:19:10'),
(303, 285, -1, '0000-00-00', '2020-06-16 23:19:11'),
(304, 286, -1, '0000-00-00', '2020-06-16 23:19:11'),
(305, 287, -1, '0000-00-00', '2020-06-16 23:19:11'),
(306, 288, -1, '0000-00-00', '2020-06-16 23:19:11'),
(307, 289, -1, '0000-00-00', '2020-06-16 23:19:11'),
(308, 290, -1, '0000-00-00', '2020-06-16 23:19:11'),
(309, 291, -1, '0000-00-00', '2020-06-16 23:19:11'),
(310, 292, -1, '0000-00-00', '2020-06-16 23:19:11'),
(311, 293, -1, '0000-00-00', '2020-06-16 23:19:11'),
(312, 294, -1, '0000-00-00', '2020-06-16 23:19:11'),
(313, 295, -1, '0000-00-00', '2020-06-16 23:19:11'),
(314, 296, -1, '0000-00-00', '2020-06-16 23:19:11'),
(315, 297, -1, '0000-00-00', '2020-06-16 23:19:11'),
(316, 298, -1, '0000-00-00', '2020-06-16 23:19:11'),
(317, 299, -1, '0000-00-00', '2020-06-16 23:19:11'),
(318, 300, -1, '0000-00-00', '2020-06-16 23:19:11'),
(319, 301, -1, '0000-00-00', '2020-06-16 23:19:11'),
(320, 302, -1, '0000-00-00', '2020-06-16 23:19:11'),
(321, 303, -1, '0000-00-00', '2020-06-16 23:19:11'),
(322, 304, -1, '0000-00-00', '2020-06-16 23:19:11'),
(323, 305, -1, '0000-00-00', '2020-06-16 23:19:11'),
(324, 306, -1, '0000-00-00', '2020-06-16 23:19:11'),
(325, 307, -1, '0000-00-00', '2020-06-16 23:19:11'),
(326, 308, -1, '0000-00-00', '2020-06-16 23:19:11'),
(327, 309, -1, '0000-00-00', '2020-06-16 23:19:11'),
(328, 310, -1, '0000-00-00', '2020-06-16 23:19:11'),
(329, 311, -1, '0000-00-00', '2020-06-16 23:19:11'),
(330, 312, -1, '0000-00-00', '2020-06-16 23:19:11'),
(331, 313, -1, '0000-00-00', '2020-06-16 23:19:11'),
(332, 314, -1, '0000-00-00', '2020-06-16 23:19:11'),
(333, 315, -1, '0000-00-00', '2020-06-16 23:19:11'),
(334, 316, -1, '0000-00-00', '2020-06-16 23:19:11'),
(335, 317, -1, '0000-00-00', '2020-06-16 23:19:11'),
(336, 318, -1, '0000-00-00', '2020-06-16 23:19:11'),
(337, 319, -1, '0000-00-00', '2020-06-16 23:19:12'),
(338, 320, -1, '0000-00-00', '2020-06-16 23:19:12'),
(339, 321, -1, '0000-00-00', '2020-06-16 23:19:12'),
(340, 322, -1, '0000-00-00', '2020-06-16 23:19:12'),
(341, 323, -1, '0000-00-00', '2020-06-16 23:19:12'),
(342, 324, -1, '0000-00-00', '2020-06-16 23:19:12'),
(343, 325, -1, '0000-00-00', '2020-06-16 23:19:12'),
(344, 326, -1, '0000-00-00', '2020-06-16 23:19:12'),
(345, 327, -1, '0000-00-00', '2020-06-16 23:19:12'),
(346, 328, -1, '0000-00-00', '2020-06-16 23:19:12'),
(347, 329, -1, '0000-00-00', '2020-06-16 23:19:12'),
(348, 330, -1, '0000-00-00', '2020-06-16 23:19:12'),
(349, 331, -1, '0000-00-00', '2020-06-16 23:19:12'),
(350, 332, -1, '0000-00-00', '2020-06-16 23:19:12'),
(351, 333, -1, '0000-00-00', '2020-06-16 23:19:12'),
(352, 334, -1, '0000-00-00', '2020-06-16 23:19:12'),
(353, 335, -1, '0000-00-00', '2020-06-16 23:19:12'),
(354, 336, -1, '0000-00-00', '2020-06-16 23:19:12'),
(355, 337, -1, '0000-00-00', '2020-06-16 23:19:12'),
(356, 338, -1, '0000-00-00', '2020-06-16 23:19:12'),
(357, 339, -1, '0000-00-00', '2020-06-16 23:19:12'),
(358, 340, -1, '0000-00-00', '2020-06-16 23:19:12'),
(359, 341, -1, '0000-00-00', '2020-06-16 23:19:12'),
(360, 342, -1, '0000-00-00', '2020-06-16 23:19:12'),
(361, 343, -1, '0000-00-00', '2020-06-16 23:19:12'),
(362, 344, -1, '0000-00-00', '2020-06-16 23:19:12'),
(363, 345, -1, '0000-00-00', '2020-06-16 23:19:12'),
(364, 346, -1, '0000-00-00', '2020-06-16 23:19:12'),
(365, 347, -1, '0000-00-00', '2020-06-16 23:19:12'),
(366, 348, -1, '0000-00-00', '2020-06-16 23:19:12'),
(367, 349, -1, '0000-00-00', '2020-06-16 23:19:12'),
(368, 350, -1, '0000-00-00', '2020-06-16 23:19:13'),
(369, 351, -1, '0000-00-00', '2020-06-16 23:19:13'),
(370, 352, -1, '0000-00-00', '2020-06-16 23:19:13'),
(371, 353, -1, '0000-00-00', '2020-06-16 23:19:13'),
(372, 354, -1, '0000-00-00', '2020-06-16 23:19:13'),
(373, 355, -1, '0000-00-00', '2020-06-16 23:19:13'),
(374, 356, -1, '0000-00-00', '2020-06-16 23:19:13'),
(375, 357, -1, '0000-00-00', '2020-06-16 23:19:13'),
(376, 358, -1, '0000-00-00', '2020-06-16 23:19:13'),
(377, 359, -1, '0000-00-00', '2020-06-16 23:19:13'),
(378, 360, -1, '0000-00-00', '2020-06-16 23:19:13'),
(379, 361, -1, '0000-00-00', '2020-06-16 23:19:13'),
(380, 362, -1, '0000-00-00', '2020-06-16 23:19:13'),
(381, 363, -1, '0000-00-00', '2020-06-16 23:19:13'),
(382, 364, -1, '0000-00-00', '2020-06-16 23:19:13'),
(383, 365, -1, '0000-00-00', '2020-06-16 23:19:13'),
(384, 366, -1, '0000-00-00', '2020-06-16 23:19:13'),
(385, 367, -1, '0000-00-00', '2020-06-16 23:19:13'),
(386, 368, -1, '0000-00-00', '2020-06-16 23:19:13'),
(387, 369, -1, '0000-00-00', '2020-06-16 23:19:13'),
(388, 370, -1, '0000-00-00', '2020-06-16 23:19:13'),
(389, 371, -1, '0000-00-00', '2020-06-16 23:19:13'),
(390, 372, -1, '0000-00-00', '2020-06-16 23:19:13'),
(391, 373, -1, '0000-00-00', '2020-06-16 23:19:13'),
(392, 374, -1, '0000-00-00', '2020-06-16 23:19:13'),
(393, 375, -1, '0000-00-00', '2020-06-16 23:19:13'),
(394, 376, -1, '0000-00-00', '2020-06-16 23:19:13'),
(395, 377, -1, '0000-00-00', '2020-06-16 23:19:13'),
(396, 378, -1, '0000-00-00', '2020-06-16 23:19:13'),
(397, 379, -1, '0000-00-00', '2020-06-16 23:19:13'),
(398, 380, -1, '0000-00-00', '2020-06-16 23:19:13'),
(399, 381, -1, '0000-00-00', '2020-06-16 23:19:13'),
(400, 382, -1, '0000-00-00', '2020-06-16 23:19:13'),
(401, 383, -1, '0000-00-00', '2020-06-16 23:19:13'),
(402, 384, -1, '0000-00-00', '2020-06-16 23:19:13'),
(403, 385, -1, '0000-00-00', '2020-06-16 23:19:14'),
(404, 386, -1, '0000-00-00', '2020-06-16 23:19:14'),
(405, 387, -1, '0000-00-00', '2020-06-16 23:19:14'),
(406, 388, -1, '0000-00-00', '2020-06-16 23:19:14'),
(407, 389, -1, '0000-00-00', '2020-06-16 23:19:14'),
(408, 390, -1, '0000-00-00', '2020-06-16 23:19:14'),
(409, 391, -1, '0000-00-00', '2020-06-16 23:19:14'),
(410, 392, -1, '0000-00-00', '2020-06-16 23:19:14'),
(411, 393, -1, '0000-00-00', '2020-06-16 23:19:14'),
(412, 394, -1, '0000-00-00', '2020-06-16 23:19:14'),
(413, 395, -1, '0000-00-00', '2020-06-16 23:19:14'),
(414, 396, -1, '0000-00-00', '2020-06-16 23:19:14'),
(415, 397, -1, '0000-00-00', '2020-06-16 23:19:14'),
(416, 398, -1, '0000-00-00', '2020-06-16 23:19:14'),
(417, 399, -1, '0000-00-00', '2020-06-16 23:19:14'),
(418, 400, -1, '0000-00-00', '2020-06-16 23:19:14'),
(419, 401, -1, '0000-00-00', '2020-06-16 23:19:14'),
(420, 402, -1, '0000-00-00', '2020-06-16 23:19:14'),
(421, 403, -1, '0000-00-00', '2020-06-16 23:19:14'),
(422, 404, -1, '0000-00-00', '2020-06-16 23:19:14'),
(423, 405, -1, '0000-00-00', '2020-06-16 23:19:14'),
(424, 406, -1, '0000-00-00', '2020-06-16 23:19:14'),
(425, 407, -1, '0000-00-00', '2020-06-16 23:19:15'),
(426, 408, -1, '0000-00-00', '2020-06-16 23:19:15'),
(427, 409, -1, '0000-00-00', '2020-06-16 23:19:15'),
(428, 410, -1, '0000-00-00', '2020-06-16 23:19:15'),
(429, 411, -1, '0000-00-00', '2020-06-16 23:19:16'),
(430, 412, -1, '0000-00-00', '2020-06-16 23:19:16'),
(431, 413, -1, '0000-00-00', '2020-06-16 23:19:16'),
(432, 414, -1, '0000-00-00', '2020-06-16 23:19:16'),
(433, 415, -1, '0000-00-00', '2020-06-16 23:19:16'),
(434, 416, -1, '0000-00-00', '2020-06-16 23:19:16'),
(435, 417, -1, '0000-00-00', '2020-06-16 23:19:16'),
(436, 418, -1, '0000-00-00', '2020-06-16 23:19:16'),
(437, 419, -1, '0000-00-00', '2020-06-16 23:19:16'),
(438, 420, -1, '0000-00-00', '2020-06-16 23:19:16'),
(439, 421, -1, '0000-00-00', '2020-06-16 23:19:16'),
(440, 422, -1, '0000-00-00', '2020-06-16 23:19:16'),
(441, 423, -1, '0000-00-00', '2020-06-16 23:19:16'),
(442, 424, -1, '0000-00-00', '2020-06-16 23:19:16'),
(443, 425, -1, '0000-00-00', '2020-06-16 23:19:16'),
(444, 426, -1, '0000-00-00', '2020-06-16 23:19:16'),
(445, 427, -1, '0000-00-00', '2020-06-16 23:19:16'),
(446, 428, -1, '0000-00-00', '2020-06-16 23:19:16'),
(447, 36, 10, '2021-04-01', '2020-06-24 11:15:14'),
(448, 36, 100, '2022-08-01', '2020-08-11 09:43:21'),
(449, 439, -1, '0000-00-00', '2020-08-24 12:14:08');

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

--
-- Table structure for table `item`
--

CREATE TABLE IF NOT EXISTS `item` (
`item_id` int(11) NOT NULL,
  `item_name` text NOT NULL,
  `item_price` decimal(10,2) NOT NULL,
  `item_type_id` tinyint(4) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=440 ;

--
-- Dumping data for table `item`
--

INSERT INTO `item` (`item_id`, `item_name`, `item_price`, `item_type_id`) VALUES
(0, 'NONE', '0.00', 1),
(1, 'ACECLOFENAC (DICLOTOL) 100mg \r\n', '16.50', 1),
(2, 'ACECLOFENAC (DOLOWIN SR) 200mg\r\n', '20.00', 1),
(3, 'ACECLOFENAC + PARACETAMOL (DOLOWIN) PLUS 100mg', '16.00', 1),
(4, 'ADVIL IMPORTED 200mg\r\n', '6.00', 1),
(5, 'ADVIL 200mg\r\n', '8.50', 1),
(6, 'AGMASET 445mg\r\n', '35.00', 1),
(7, 'AGMASET 445mg; PER BOTTLE\r\n', '1300.00', 1),
(8, 'AGMASET 445mg; SET OF 3\r\n', '100.00', 1),
(9, 'ALENDRONETE SODIUM (ALDREN) 70mg', '150.00', 1),
(10, 'ALENDRONETE SODIUM (ALENDRA) 70mg', '300.00', 1),
(11, 'ALENDRONETE SODIUM (REVENTA) 70mg', '158.00', 1),
(12, 'ALFA - CALCINOL\r\n', '16.00', 1),
(13, 'ALLOPURINOL 100mg\r\n', '1.60', 1),
(14, 'AMLODIPINE (DIADIPINE) 10mg\r\n', '3.25', 1),
(15, 'AMLODIPINE (LODIPEX) 5mg\r\n', '2.75', 1),
(16, 'AMOXICILLIN 250mg\r\n', '2.50', 1),
(17, 'AMOXICILLIN 500mg\r\n', '4.00', 1),
(18, 'SULODEXIDE (ANGIOFLUX) 250mg\r\n', '38.80', 1),
(19, 'ATENOLOL (ZENOBLOC) 100mg\r\n', '6.00', 1),
(20, 'ATENOLOL (ZENOBLOC) 50mg\r\n', '4.50', 1),
(21, 'CALCIUMADE\r\n', '9.00', 1),
(22, 'CARISOPRODOL/ PARACETAMOL (LAGAFLEX) 300/250', '24.00', 1),
(23, 'CATAPRES 75mg\r\n', '34.00', 1),
(24, 'CEFALEXIN (EXEL) CAP 500mg\r\n', '7.00', 1),
(25, 'CEFIXIME (QUIX) 200mg\r\n', '25.00', 1),
(26, 'CEFUROXIME AXETIL (EROXIME-500) 500mg\r\n', '46.00', 1),
(27, 'CELCOXX 200mg\r\n', '30.00', 1),
(28, 'CELCOXX 400mg\r\n', '46.00', 1),
(29, 'CIPROFLOXACIN (CYFROX) 500mg\r\n', '7.00', 1),
(30, 'CLINDAMYCIN CAP (CLINDAGOLD) 300mg\r\n', '8.00', 1),
(31, 'CLOPIDOGREL 75mg\r\n', '9.00', 1),
(32, 'CLOXACILLIN 500mg\r\n', '5.00', 1),
(33, 'COLCHICINE (GOUTNIL) TAB 500mg\r\n', '5.00', 1),
(34, 'COLCHICINE (RHEA) TAB 500mg\r\n', '3.00', 1),
(35, 'COTRIMOXAZOLE FORTE\r\n', '5.00', 1),
(36, 'DEHYDROSOL POWDER FOR ORAL SOLUTION (ORS-75 REPLACEMENT)\r\n', '15.00', 1),
(37, 'DIAMICRON 80mg\r\n', '32.50', 1),
(38, 'DICLOFENAC SODIUM (DICLORAN GEL) GEL 20g\r\n', '250.00', 1),
(39, 'DICLOFENAC SODIUM (CURAFEN) 100mg', '10.00', 1),
(40, 'DICLOFENAC SODIUM (TRIFOCID) 50mg', '5.00', 1),
(41, 'DICLOFENAC NA (SUBSYDE CR) 100mg\r\n', '13.50', 1),
(42, 'DILTIAZEM 30mg\r\n', '5.00', 1),
(43, 'DILTIAZEM 60mg\r\n', '10.00', 1),
(44, 'DOLCET 37.5/325mg\r\n', '38.00', 1),
(45, 'ETORICOXIB (ARCOXIA) 120mg\r\n', '80.00', 1),
(46, 'ETORICOXIB (ETOXI-60) 120mg\r\n', '56.00', 1),
(47, 'ETORICOXIB (ETOXI-60) 60mg\r\n', '32.40', 1),
(48, 'ETORICOXIB (TORICO) 90mg\r\n', '26.00', 1),
(49, 'ETORICOXIB (XIBRA) 60mg\r\n', '18.00', 1),
(50, 'FASTUM GEL 30g\r\n', '430.00', 1),
(51, 'OFLOXACIN (FLOXA-200) 200mg\r\n', '10.00', 1),
(52, 'OFLOXACIN (FLOXA) 400mg\r\n', '13.00', 1),
(53, 'FURIC 40mg\r\n', '17.50', 1),
(54, 'FURIC 80mg\r\n', '24.25', 1),
(55, 'GABAPENTIN (GABIX) 100mg\r\n', '30.00', 1),
(56, 'GABAPENTIN (GABIX) 300mg\r\n', '33.00', 1),
(57, 'GABARON (GABA.) 300mg\r\n', '25.00', 1),
(58, 'GLICLAZIDE (ZEBET-8) 80mg\r\n', '5.80', 1),
(59, 'IBUPROFEN TAB 200mg\r\n', '1.20', 1),
(60, 'IBUPROFEN TAB 400mg\r\n', '1.60', 1),
(61, 'ISOFLAV-CR CAP\r\n', '30.00', 1),
(62, 'KETTESSE TAB 25mg\r\n', '33.00', 1),
(63, 'LORATADINE (LORAOX) 10mg\r\n', '7.00', 1),
(64, 'LORNOXICAN (ZORNICA-4)\r\n', '16.50', 1),
(65, 'LOSARTAN POTASSIUM (AMGEL) 50mg\r\n', '11.25', 1),
(66, 'LOSARTAN POTASSIUM (LOZAK) 100mg', '19.25', 1),
(67, 'MEFENAMIC 250mg\r\n', '1.50', 1),
(68, 'MEFENAMIC 500mg\r\n', '2.00', 1),
(69, 'MELOXICAM (MELOFAR) 15mg\r\n', '12.00', 1),
(70, 'METFORMIN (ADIAC) TAB 500mg\r\n', '1.70', 1),
(71, 'METOPROLOL (PROLOL) TAB 100mg\r\n', '4.20', 1),
(72, 'METOPROLOL (PROLOL) TAB 50mg\r\n', '2.60', 1),
(73, 'MUPIROCIN OINTMENT (MUPIDERM) 5g', '175.00', 1),
(74, 'NAPROXEN (NAPLEX) 500mg', '7.00', 1),
(75, 'NAPROXEN 550mg\r\n', '7.00', 1),
(76, 'OMEPRAZOLE (OMEBLOC-20) 20mg\r\n', '7.00', 1),
(77, 'OMEPRAZOLE (RANZOLE) 40mg\r\n', '10.00', 1),
(78, 'PARA + ORPHANADRINECITRATE (PARADRINFORTE) 50/650mg', '19.00', 1),
(79, 'PARA + ORPHENADRINECITRATE (PROPARFORTE) 650/35mg', '19.00', 1),
(80, 'PARA + TRAMADOL HCL (CETRADOL) 325/37.5', '10.00', 1),
(81, 'PARA + TRAMADOL HCL (DOLOGESIC) 325/37.5', '15.00', 1),
(82, 'PARA + TRAMADOL HCL (TAKOL-CR) 100mg', '60.00', 1),
(83, 'PARA + TRAMADOL HCL (TRAP) 325/37.5\r\n', '15.00', 1),
(84, 'PIASCLEDINE 200/100mg\r\n', '50.00', 1),
(85, 'PREDNISONE TAB 5mg\r\n', '1.30', 1),
(86, 'PREGABALIN (GABICA) CAP 75mg\r\n', '33.00', 1),
(87, 'RANICLAV (CO-AMOXX) 625mg\r\n', '25.00', 1),
(88, 'PREGMAX M-75 (PREGABALIN + METHYLCOBALAMIN)', '30.75', 1),
(89, 'ROSUVASTATIN 10mg\r\n', '10.00', 1),
(90, 'SODIUM ASCORBATE (SOVIT-CEE) 500mg', '5.50', 1),
(91, 'TRAMADOL (SAPHTRAM) 50mg', '5.00', 1),
(92, 'TREVOCA TAB\r\n', '25.00', 1),
(93, 'VIARTRIL-S CAP 500mg\r\n', '20.00', 1),
(94, 'VIARTRIL-S POWDER SACHET\r\n', '60.00', 1),
(95, 'VIGEL CREAM 15g\r\n', '160.00', 1),
(96, 'ACECLOFENAC + PARACETAMOL (ZERODOL-P) 100/500mg\r\n', '23.00', 1),
(97, 'IBUPROFEN + PARACETAMOL (RESTOLAX FORTE 10/325mg)', '5.70', 1),
(98, 'DICLOFENAC SODIUM GEL (DICLOGEN) 20G', '185.00', 1),
(99, '* GLUCOSAMINE 1500mg', '15.00', 1),
(100, '* CALCIUM 600mg + VITAMIN D\r\n', '6.00', 1),
(102, 'Knee Immobilizer Blue', '2000.00', 2),
(103, 'Non-adhesive Dressing', '50.00', 2),
(104, 'Wrist Splint Kiddie Right -Medium', '500.00', 2),
(105, 'Elastic Knee -Extra Large [DUPLICATE]', '400.00', 2),
(106, 'Lumbar Support (NB-504) -Extra Small', '1800.00', 2),
(107, 'Thumb Splint IMING', '1000.00', 2),
(108, 'Lumbar Support -XL [DUPLICATE]', '1800.00', 2),
(109, 'Thumb Stabilizer', '1200.00', 2),
(110, 'Profoot Triad Orthotic (MEN)', '1200.00', 2),
(111, 'Wrist Prime Right -XL', '500.00', 2),
(112, 'Lumbar Support -L [DUPLICATE]', '1800.00', 2),
(113, 'Theraband Silver (Foil)', '390.00', 2),
(114, 'Aluminum Crutches -Large', '1500.00', 2),
(115, 'Lumbar (WB-577) -S/XS', '2100.00', 2),
(116, 'Elastic Knee -Medium [DUPLICATE]', '400.00', 2),
(117, 'Tennis Elbow Support -Large', '450.00', 2),
(118, 'Elastic Knee -Large ]DUPLICATE]', '400.00', 2),
(119, 'Hinged Knee Brace -Large', '1650.00', 2),
(120, 'Thumb Splint -Large', '300.00', 2),
(121, 'Thumb Stabilizer (OH-304)', '1200.00', 2),
(122, 'Clavicle Support OH-136 -Medium', '700.00', 2),
(123, 'Knee Support -Extra Extra Large', '400.00', 2),
(124, 'Elastic Ankle -Extra Large', '400.00', 2),
(125, 'Elastic Calf -Large', '375.00', 2),
(126, 'Sling and Swathe Original -Large', '380.00', 2),
(127, 'Knee Support -Extra Extra Large [DUPLICATE]', '400.00', 2),
(128, 'Hinged Knee Brace -Extra Large', '1650.00', 2),
(129, 'Knee Support -Extra Large', '400.00', 2),
(130, 'Elastic Ankle -Medium', '400.00', 2),
(131, 'Energizer 9V', '135.00', 2),
(132, 'Transfer Belt', '1600.00', 2),
(133, 'Longbone Collar Blue -Medium', '650.00', 2),
(134, 'Ligament Knee Support (NS-706) -Medium', '1500.00', 2),
(135, 'Lumbar Support -M [DUPLICATE]', '1800.00', 2),
(136, 'Profoot Triad Orthotic (WOMEN)', '1200.00', 2),
(137, 'Splint Green -Large', '200.00', 2),
(138, 'Lumbar Support (WB-577) -Large/Extra Large', '2100.00', 2),
(139, 'Wrist Splint Kiddie Right -Large', '500.00', 2),
(140, 'Knee Support -Large', '400.00', 2),
(141, 'Ankle Foot Orthosis (OH-908) Left -Medium', '300.00', 2),
(142, 'Elastic Knee (ES-701) -Extra Large', '400.00', 2),
(143, 'Transfer Belt (00-173)', '1600.00', 2),
(144, 'Alina Stockings Thigh High 20-30mmHg -Large', '1600.00', 2),
(145, 'Longbone Wrist Splint Left -Small', '500.00', 2),
(146, 'Elastic Knee Support (ES-701) -Extra Extra Large', '400.00', 2),
(147, 'Prime Wrist Splint Right -Medium', '500.00', 2),
(148, 'Wrist Brace -Small', '500.00', 2),
(149, 'Knee Immobilizer Eco (Green) -Small', '1500.00', 2),
(150, 'Body Splint [DUPLICATE]', '150.00', 2),
(151, 'Encore Wrist Forearm Splint Right -Large', '600.00', 2),
(152, 'Wrist Splint IM Right -Medium', '500.00', 2),
(153, 'Abdominal Binder', '300.00', 2),
(154, 'Energizer AAA', '130.00', 2),
(155, 'Block Box (set)', '1900.00', 2),
(156, 'Rib Belt (EB-502) -Small', '800.00', 2),
(157, 'Elastic Knee (ES-701) -Medium', '400.00', 2),
(158, 'Knight Tylor Brace -Medium', '8500.00', 2),
(159, 'Ice Cupp 6inch', '100.00', 2),
(160, 'Energizer Battery 9V', '135.00', 2),
(161, 'Hinged Knee Brace (NS-704) -Small', '1650.00', 2),
(162, 'Prime ThomasCollarBlue Eco -Large', '500.00', 2),
(163, 'Neoprene Ankle Support Lycra (NS-903)', '600.00', 2),
(164, 'Hinged Knee Brace (NS-704) -Large', '1650.00', 2),
(165, 'Elastic Ankle -Large', '400.00', 2),
(166, 'Wrist Splint Kiddie Left -Medium', '500.00', 2),
(167, 'Arm Sling Kiddie -Medium', '200.00', 2),
(168, 'Alina Stockings Knee High 20-30mmHg Medium', '1600.00', 2),
(169, 'Clavicle Brace OH-102 -Medium', '1750.00', 2),
(170, 'Hinged Knee Brace (NS-704) -Medium', '1650.00', 2),
(171, 'Knee Support Immobilizer Blue -Extra Large', '2000.00', 2),
(172, 'Theratube Red', '330.00', 2),
(173, 'Lumbar Support (NB-504) -Medium', '1800.00', 2),
(174, 'Hot Moist Pack 00-092 Cervical', '930.00', 2),
(175, 'Thumb Splint -Small', '300.00', 2),
(176, 'Knee Immobilizer Blue -Large', '2000.00', 2),
(177, 'Body Splint', '250.00', 2),
(178, 'Hot Water Bag 500ML', '100.00', 2),
(179, 'Restorator', '1900.00', 2),
(180, 'Prime Sling Loop', '180.00', 2),
(181, 'Cane with Chair', '1000.00', 2),
(182, 'Thumb Splint Stabilizer', '1000.00', 2),
(183, 'Stockinette 36" (1 yard)', '180.00', 2),
(184, 'Wrist Splint Kiddie Left -Large', '500.00', 2),
(185, 'Ankle Brace WH-901 -Large', '850.00', 2),
(186, 'Longbone Wrist Splint Right -Small', '500.00', 2),
(187, 'MTI Hot /Cold Gel Pack', '300.00', 2),
(188, 'Longbone Wrist Splint Right -Medium', '500.00', 2),
(189, 'Skin Traction -Large', '1300.00', 2),
(190, 'Lumbar Support (WB-577) -Small/Medium', '2100.00', 2),
(191, 'Wrist Splint', '500.00', 2),
(192, 'Theraband Black (Foil)', '350.00', 2),
(193, 'Prime Wrist Splint Left -Small', '500.00', 2),
(194, 'Lumbar (EB-512) -Extra Extra Extra Large (Triple Extra Large)', '2000.00', 2),
(195, 'Knee Immobilizer 18" -Medium', '2000.00', 2),
(197, 'Rubber Tip for Quad Cane', '40.00', 2),
(198, 'Skin Traction -Small', '1300.00', 2),
(199, 'Knee Immobilizer 18" -Small', '2000.00', 2),
(200, 'Thumb Splint [DUPLICATE]', '300.00', 2),
(201, 'Elastic Knee (ES-701) -Large', '400.00', 2),
(202, 'Heel Cup -Small', '500.00', 2),
(203, 'Knee Immobilizer Blue -Medium', '2000.00', 2),
(204, 'Theraband Red (Foil)', '225.00', 2),
(205, 'Clavicle Support OH-136 -Large', '700.00', 2),
(206, 'Wooden Crutch set L ', '750.00', 2),
(207, 'Clavicular Padded Splint -Small / Child', '500.00', 2),
(208, 'Clavicular Padded Splint -Medium', '500.00', 2),
(209, 'NSS', '100.00', 1),
(210, 'Knee Immobilizer Eco (Green) -Large', '1500.00', 2),
(211, 'Hot Water Bag 2000ML -Big', '175.00', 2),
(212, 'Tri Star Ankle Support', '1200.00', 2),
(213, 'Rubber Tip Aluminum Crutch Black', '40.00', 2),
(214, 'Skin Traction -Small', '1300.00', 2),
(215, 'Finger Splint', '250.00', 2),
(216, 'Eveready Battery AAA set of 2', '59.25', 2),
(217, 'Prime Cast 3" [DUPLICATE]', '325.00', 2),
(218, 'Lumbar Eco -Extra Extra Large', '1300.00', 2),
(219, 'Prime Splint 5"', '500.00', 2),
(220, 'Thumb Splint (One Size Only)', '300.00', 2),
(221, 'Heel Cup -Large', '500.00', 2),
(222, 'Elastic Calf ES-801 -Medium', '400.00', 2),
(223, 'DM Shoe (Not Pair) Size 10', '350.00', 2),
(224, 'Elastic Band 2"', '40.00', 2),
(225, 'Xylocane', '150.00', 2),
(226, 'Silicon Heel Cup -Medium', '500.00', 2),
(227, 'Roll Gauze 3"', '50.00', 2),
(228, 'Lidocane', '200.00', 2),
(229, 'Arm Sling Checkered -Small', '200.00', 2),
(230, 'Lumbar (WB-577) -S/M', '2100.00', 2),
(231, 'Wrist Splint Right -Extra Large', '500.00', 2),
(232, 'Lumbar Starleaf -Extra Large', '1300.00', 2),
(233, 'Skin Traction', '1300.00', 2),
(234, 'Prime Splint 4"', '600.00', 2),
(235, 'Rib Belt (EB-502) -Extra large', '800.00', 2),
(236, 'Rubber Tip Quad Cane', '40.00', 2),
(237, 'Prime Fiberglass Splint 4"', '400.00', 2),
(238, 'Lumbar Eco -Medium', '1300.00', 2),
(239, 'Prime ThomasCollarBlue Eco -Large ', '500.00', 2),
(240, 'DM Shoe (Not Pair) Size 8', '350.00', 2),
(241, 'Lumbar Eco -Extra Large', '1300.00', 2),
(242, 'Aluminum Splint', '150.00', 2),
(243, 'Forearm Splint', '800.00', 2),
(244, 'Dr. Care Finger Splint', '250.00', 2),
(245, 'Umbrella Cane -Small', '350.00', 2),
(246, 'Knee Immobilizer 21" -Medium', '1500.00', 2),
(247, 'Knee Patella (NS-703) -Medium', '750.00', 2),
(248, 'Wrist Splint Kiddie Right -Small', '500.00', 2),
(249, 'Standard Wheelchair Spoke Wheels Black Upholstery', '4600.00', 2),
(250, 'Knee Support -Medium', '400.00', 2),
(251, 'Skin Traction Large', '1300.00', 2),
(252, 'Energizer Battery AA set of 2', '130.00', 2),
(253, 'Hinged Knee Brace -Large [DUPLICATE]', '1650.00', 2),
(254, 'Energizer AA', '130.00', 2),
(255, 'Adduction Pillow', '1500.00', 2),
(256, 'Silicone Heel Cup -Large', '500.00', 2),
(257, 'Sling and Swathe Original -Small', '380.00', 2),
(258, 'Face Mask 50''s (SURGITECH)', '50.00', 2),
(259, 'Wooden Crutch L', '750.00', 2),
(260, 'Wrist Splint Right -Extra Large', '500.00', 2),
(261, 'Longbone Collar Blue -Large', '650.00', 2),
(262, 'Commode Chair', '2700.00', 2),
(263, 'Ankle Stirrup Air One Size', '1700.00', 2),
(264, 'Knee Immobilizer Black Eco 21" -Small', '1500.00', 2),
(265, 'Hot Water Bag 1000ML', '150.00', 2),
(266, 'Knee Immobilizer Blue 18" -Medium', '2000.00', 2),
(267, 'Knee Immobilizer Blue 21" -Large', '2000.00', 2),
(268, 'Knee Immobilizer Eco (Green) -Medium', '1500.00', 2),
(269, 'Hinged Knee Brace -Medium', '1650.00', 2),
(270, 'Adjustable Shoulder Support (NS-102) -Large', '850.00', 2),
(271, 'Elastic Ankle Medium', '400.00', 2),
(272, 'Lumbar Starleaf -Large', '1300.00', 2),
(273, 'Clavicle Brace OH-102 -Large', '1750.00', 2),
(274, 'Neoprene Knee Support NS-701 -Large', '600.00', 2),
(275, 'Thumb Splint Blue -Small', '750.00', 2),
(276, 'Ice Cupp 8inch', '150.00', 2),
(277, 'Thumb Splint Blue -Small [DUPLICATE]', '300.00', 2),
(278, 'Knee Patella (NS-703) -Large', '750.00', 2),
(279, 'Hinged Knee Brace (NS-704) -Extra Large', '1650.00', 2),
(280, 'Micropore (1/2)"', '20.00', 2),
(281, 'Skin Traction Medium', '1300.00', 2),
(282, 'Dr. S Ortho Hinged Knee Brace -Medium', '1500.00', 2),
(283, 'Heel Cup -Medium', '500.00', 2),
(284, 'Elastic Calf ES-801 -Large', '400.00', 2),
(285, 'Wooden Crutch set M', '750.00', 2),
(286, 'Elastic Knee Support (ES-701) -Extra Large', '400.00', 2),
(287, 'Lumbar Support (NB-504) -Extra Extra Large', '1800.00', 2),
(288, 'Lumbar Support (NB-504) -Extra Large', '1800.00', 2),
(289, 'Knee Immobilizer Black Eco 21" -Medium', '1500.00', 2),
(290, 'Medical Compression Stockings Thigh High 20-30mmHg -Extra Large', '1600.00', 2),
(291, 'Wooden Crutch set L', '750.00', 2),
(292, 'Clavicle Splint -Small Infant', '500.00', 2),
(293, 'Wrist Splint Left -Small', '500.00', 2),
(294, 'MTI Digital Arm BP Economy', '1900.00', 2),
(295, 'Umbrella Cane Large', '400.00', 2),
(296, 'Allen and Irving Aneroid BP with Stethoscope', '1400.00', 2),
(297, 'Aluminum Crutches Medium', '1500.00', 2),
(298, 'Wrist Splint Right -Medium', '500.00', 2),
(299, 'DM Shoe (Not Pair) Size 5', '350.00', 2),
(300, 'Silicon Heel Cup -Large', '500.00', 2),
(301, 'Roll Gauze 4"', '40.00', 2),
(302, 'Fiberglass Prime Cast 4" Blue', '375.00', 2),
(303, 'Wrist Splint Right -Small', '500.00', 2),
(304, 'Clavicle Brace OH-102 -Extra Large', '1750.00', 2),
(305, 'Non-stick', '50.00', 2),
(306, 'Micropore 1"', '20.00', 2),
(307, 'Prime Walker', '2200.00', 2),
(308, 'Longbone Wrist Splint Left -Medium', '500.00', 2),
(309, 'Longbone Wrist Splint Right -Large', '500.00', 2),
(310, 'DM Shoe (Not Pair) Size 11', '350.00', 2),
(311, 'Lumbar Support (NB-504) -Medium', '1800.00', 2),
(312, 'Stockinette for closed reduction', '350.00', 2),
(313, 'Local Aluminum Walker', '1600.00', 2),
(314, 'Rib Belt (EB-502) -Large', '800.00', 2),
(315, 'DM Shoe (Not Pair) Size 6', '350.00', 2),
(316, 'DM Shoe (Not Pair) Size 7', '350.00', 2),
(317, 'Single Cane', '500.00', 2),
(318, 'Neoprene Knee Support Lycra (NS-707)', '800.00', 2),
(319, 'Prime ThomasCollarBlue -Large', '500.00', 2),
(320, 'Hinged Knee Brace -Small', '1650.00', 2),
(321, 'Medical Compression Stockings Thigh High 20-30mmHg Small', '1600.00', 2),
(322, 'Clavicle Splint -Medium', '500.00', 2),
(323, 'Hot Moist Pack 00-093 Spinal 10"x18"', '930.00', 2),
(324, 'Elastic Knee Support (ES-701) -Small', '400.00', 2),
(325, 'Knee Immobilizer Eco (Green) -Large', '1500.00', 2),
(326, 'Prime Wrist Splint Left -Medium', '500.00', 2),
(327, 'Rubber Tip Crutches', '30.00', 2),
(328, 'Plaster of Paris 2"', '100.00', 2),
(329, 'Prime Wrist Splint Right -Large', '500.00', 2),
(330, 'Neoprene Knee Support NS-701 -Medium', '600.00', 2),
(331, 'Elastic Knee Support (ES-701) -Large', '400.00', 2),
(332, 'Lumbar (WB-577) -L/XL', '2100.00', 2),
(333, 'Prime Fiberglass Splint 3"', '600.00', 2),
(334, 'Fiberglass Prime Cast 5" Blue', '425.00', 2),
(335, 'Elastic Ankle Support (ES-901) -Large', '400.00', 2),
(336, 'Stockinette 5"', '75.00', 2),
(337, 'Roll Gauze 5"', '75.00', 2),
(338, 'Arm Sling Kiddie -Extra Large', '200.00', 2),
(339, 'Eveready Battery AA Set of 2', '39.00', 2),
(340, 'Prime ThomasCollarBlue -Small', '500.00', 2),
(341, 'Splint Orange', '200.00', 2),
(342, 'Prime Wrist Splint Left -Small', '500.00', 2),
(343, 'Wooden Crutch', '750.00', 2),
(344, 'Wrist Splint Left -Medium', '500.00', 2),
(345, 'Knee Immobilizer Black Eco 21" -Large', '1500.00', 2),
(346, 'Wadding Sheet 3"x4 Polyester', '60.00', 2),
(347, 'Wrist Splint Kiddie Left -Small', '500.00', 2),
(348, 'Plaster of Paris 4"', '350.00', 2),
(349, 'Medical Compression Stockings Thigh High 20-30mmHg Large', '1600.00', 2),
(350, 'Arm Sling Blue -Small', '250.00', 2),
(351, 'Fiberglass Prime Cast 3" Blue', '325.00', 2),
(352, 'Stockinette 3"', '180.00', 2),
(353, 'Prime ThomasCollarBlue -Medium', '500.00', 2),
(354, 'Elastic Ankle Support (ES-901) -Extra Large', '400.00', 2),
(355, 'Sling and Swathe Original -Medium', '380.00', 2),
(356, 'DM Shoe (Not Pair) Size 9', '350.00', 2),
(357, 'Neoprene Knee Support NS-701 -Extra Large', '600.00', 2),
(358, 'Elastic Knee Support (ES-701) -Medium', '400.00', 2),
(359, 'Prime Wrist Splint Left -Large', '500.00', 2),
(360, 'Prime Wrist Splint Right -Small', '500.00', 2),
(361, 'Medical Compression Stockings Thigh High 20-30mmHg Medium', '1600.00', 2),
(362, 'Fiberglass Prime Cast 2" Blue', '235.00', 2),
(363, 'Arm Sling Blue -Medium', '250.00', 2),
(364, 'Lumbar Support (NB-504) -Large', '1800.00', 2),
(365, 'Clavicle Splint -Large', '500.00', 2),
(366, 'Ankle Lycra (NS-903)', '700.00', 2),
(367, 'Arm Sling Kiddie -Small', '200.00', 2),
(368, 'Lumbar Starleaf -Extra Extra Large', '1300.00', 2),
(369, 'Fiberglass Splint 2"', '350.00', 2),
(370, 'Gauze', '25.00', 2),
(371, 'Stockinette 2"', '30.00', 2),
(372, 'Elastic Band 3"', '50.00', 2),
(373, 'Wheelchair', '4600.00', 2),
(374, 'Commode Chair US', '3000.00', 2),
(375, 'Starleaf Thumb Splint', '800.00', 2),
(376, 'Fiberglass Splint 4"', '600.00', 2),
(377, 'Elastic Band 4"', '60.00', 2),
(378, 'Fiberglass Splint 5"', '800.00', 2),
(379, 'Elastic Band 6"', '100.00', 2),
(380, 'Wadding Sheet 5"x4 Polyester', '60.00', 2),
(381, 'Elastic Ankle Support (ES-901) -Medium', '400.00', 2),
(382, 'Elastic Ankle Support (ES-901) -Small', '400.00', 2),
(383, 'Stockinette 4"', '180.00', 2),
(384, 'Knee Immobilizer 21" -Large', '1500.00', 2),
(385, 'Fiberglass Prime Cast 4" Blue [DUPLICATE]', '375.00', 2),
(386, 'Wadding Sheet 4"x4 Polyester', '60.00', 2),
(387, 'Squeeze Ball', '40.00', 2),
(388, 'Umbrella Cane Big', '450.00', 2),
(389, 'Quad Cane', '750.00', 2),
(390, 'Medical Compression Stocking Dr. S Ortho Large', '1400.00', 2),
(391, 'Arm Sling Kiddie -Large', '200.00', 2),
(392, 'Plaster of Paris 6"', '350.00', 2),
(393, 'Wadding Sheet 2"x4 Polyester', '50.00', 2),
(394, 'Arm Sling Blue -Large', '250.00', 2),
(395, 'Aircast Black', '8500.00', 2),
(396, 'Prime Aircast Grey', '7500.00', 2),
(397, 'Splint Violet', '200.00', 2),
(398, 'Roll Gauze 2"', '20.00', 2),
(399, 'Medical Compression Stockings LYCRA JINNI', '1600.00', 2),
(400, 'THORACOLUMBAR SACRAL ORTHOSIS (TLSO)', '9700.00', 2),
(401, 'Arm Sling Blue -Extra Large', '250.00', 2),
(402, 'Clavicle Support OH-136 -Small', '700.00', 2),
(403, 'Clavicle Support OH-136 -Extra Large', '700.00', 2),
(404, 'Dr. Care Clavicle Support', '1200.00', 2),
(405, 'Aluminum Cane', '500.00', 2),
(406, 'Wrist Brace -Medium', '500.00', 2),
(407, 'DM Shoe (Not Pair) Ladies Size 2', '350.00', 2),
(408, 'Local Aluminum Walker with Wheels', '1600.00', 2),
(409, 'Eveready Battery 9V', '60.00', 2),
(410, 'Rib Belt (EB-502) -Medium', '800.00', 2),
(411, 'NAPROXEN (SONAP) 500mg', '7.00', 1),
(412, 'NAPROXEN (PROXEN) 500mg', '7.00', 1),
(413, 'Theraband Gold (Foil)\r\n', '525.00', 2),
(414, 'OMEPRAZOLE (MEPRACID) 20mg', '7.00', 1),
(415, 'RAFONEX (CO-AMOXX) 625mg', '25.00', 1),
(416, 'Wrist Splint Right -Large', '500.00', 2),
(417, 'Lumbar Starleaf -Medium', '1300.00', 2),
(418, 'Wrist Splint Black Right -One Size Only', '500.00', 2),
(419, 'Wrist Splint Black Left -One Size Only', '500.00', 2),
(420, '* GLUCOSAMINE 500mg', '12.00', 1),
(421, 'KENDALL TELFA NON-ADHERENT DRESSING 3inx8in (7.5cm x 20cm)', '50.00', 2),
(422, 'CIPROFLOXACIN (CYFROX) 500mg', '7.00', 1),
(423, 'LOSARTAN POTASSIUM (VONWELT) 100mg', '19.25', 1),
(424, 'LOSARTAN POTASSIUM (NATRAZOL) 100mg', '19.25', 1),
(425, 'METHYL-PREDNISOLONE ACETATE (DEPO-MEDROL) 40mg/mL', '500.00', 1),
(426, 'Encore Wrist Forearm Splint Left -Extra Large', '600.00', 2),
(427, 'DONJOY TRU-PUL KNEE RIGHT -MEDIUM', '2000.00', 2),
(428, 'Energizing Posture Support -Medium', '325.00', 2),
(429, 'AMLODIPINE (NORVATROL-5) 5mg', '2.75', 1),
(430, 'COLCHICINE (GENERIC/VONWELT) TAB 500mg', '3.00', 1),
(431, 'DICLOFENAC SODIUM GEL (ARNIL) 20G', '150.00', 1),
(432, 'ETORICOXIB (XIBRA-120) 120mg', '56.00', 1),
(433, 'GLICLAZIDE (GLYCINORM-80) 80mg', '5.80', 1),
(434, 'LOSARTAN POTASSIUM (ANGEL-50) 50mg', '11.25', 1),
(435, 'MEFENAMIC (MEGYXAN) 500mg', '2.00', 1),
(436, 'MELOXICAM (TERACAM) 15mg', '12.00', 1),
(437, 'OMEPRAZOLE (INHIBITA) 40mg', '10.00', 1),
(438, 'NAPROXEN (SONAP) 500mg UPDATED	\r\n', '10.00', 1),
(439, 'MINORSET', '500.00', 2);

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

--
-- Table structure for table `item_type`
--

CREATE TABLE IF NOT EXISTS `item_type` (
`item_type_id` tinyint(4) NOT NULL,
  `item_type_name` text NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `item_type`
--

INSERT INTO `item_type` (`item_type_id`, `item_type_name`) VALUES
(1, 'Medicine'),
(2, 'Non-medicine');

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

--
-- Table structure for table `medical_doctor`
--

CREATE TABLE IF NOT EXISTS `medical_doctor` (
`medical_doctor_id` int(11) NOT NULL,
  `medical_doctor_name` text NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `medical_doctor`
--

INSERT INTO `medical_doctor` (`medical_doctor_id`, `medical_doctor_name`) VALUES
(0, 'ANY'),
(1, 'SYSON, PEDRO'),
(2, 'SYSON, PETER'),
(3, 'SUMMARY'),
(4, 'REJUSO, CHASTITY AMOR'),
(5, 'DELA PAZ, RODIL'),
(6, 'LASAM, HONESTO'),
(7, 'BALCE, GRACIA CIELO');

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

--
-- Table structure for table `patient`
--

CREATE TABLE IF NOT EXISTS `patient` (
`patient_id` int(11) NOT NULL,
  `patient_name` varchar(60) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=20 ;

--
-- Dumping data for table `patient`
--

INSERT INTO `patient` (`patient_id`, `patient_name`) VALUES
(-1, 'CANCELLED'),
(0, 'NONE'),
(1, 'BERGSTEIN, AKI'),
(2, 'JOCSON, MICHELLE'),
(3, 'SALMONE, LYN'),
(4, 'ANG, MARI'),
(5, 'DELA PAZ, MIGUEL'),
(6, 'DELA PAZ, JUDY'),
(7, 'DOMINGO, JAN'),
(8, 'GARCIA, MARIA'),
(9, 'ONES, ALAN'),
(10, 'SORIANO, LILIA'),
(11, 'DE GUZMAN, MELISSA'),
(12, 'SANTOS, MARIE'),
(13, 'TAN, ED'),
(14, 'CARPIO, VERNA'),
(15, 'BAC, NILA'),
(16, 'ROCES, ARTURO'),
(17, 'ALBERTO, FELINA'),
(18, 'TANEDO, MIGUEL'),
(19, 'SALOME, JOCELYN');

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

--
-- Table structure for table `receipt`
--

CREATE TABLE IF NOT EXISTS `receipt` (
`receipt_id` int(11) NOT NULL,
  `receipt_type_id` int(11) NOT NULL,
  `transaction_id` int(11) NOT NULL,
  `receipt_number` int(11) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `receipt`
--

INSERT INTO `receipt` (`receipt_id`, `receipt_type_id`, `transaction_id`, `receipt_number`) VALUES
(1, 1, 4, 1234),
(2, 2, 4, 4444),
(3, 2, 3, 4444);

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

--
-- Table structure for table `receipt_type`
--

CREATE TABLE IF NOT EXISTS `receipt_type` (
`receipt_type_id` int(11) NOT NULL,
  `receipt_type_name` text NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `receipt_type`
--

INSERT INTO `receipt_type` (`receipt_type_id`, `receipt_type_name`) VALUES
(1, 'MARIKINA ORTHOPEDIC SPECIALTY CLINIC'),
(2, 'P.A.S. ORTHOPEDIC AND MEDICAL SUPPLIES'),
(3, 'MEDICAL DOCTOR NAME');

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

--
-- Table structure for table `report`
--

CREATE TABLE IF NOT EXISTS `report` (
`report_id` int(11) NOT NULL,
  `report_type_id` tinyint(4) NOT NULL DEFAULT '2',
  `report_filename` text CHARACTER SET utf8mb4 NOT NULL,
  `report_description` text CHARACTER SET utf8mb4 NOT NULL,
  `added_datetime_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `report_type`
--

CREATE TABLE IF NOT EXISTS `report_type` (
`report_type_id` tinyint(4) NOT NULL,
  `report_type_name` varchar(30) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `report_type`
--

INSERT INTO `report_type` (`report_type_id`, `report_type_name`) VALUES
(1, 'Lessons-learned Report'),
(2, 'OT and PT Treatment'),
(3, 'Incident Report'),
(4, 'Reports from All Locations'),
(5, 'Report Image'),
(6, 'Consultation'),
(7, 'Purchase Medicine'),
(8, 'Information Desk Queue');

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

--
-- Table structure for table `therapist`
--

CREATE TABLE IF NOT EXISTS `therapist` (
`therapist_id` int(11) NOT NULL,
  `therapist_name` text CHARACTER SET utf8mb4 NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `therapist`
--

INSERT INTO `therapist` (`therapist_id`, `therapist_name`) VALUES
(0, 'NONE'),
(1, 'DEL MAR, KRIS'),
(2, 'PASCO, NOEL'),
(3, 'CORTEZ, GREG'),
(4, 'VILLEGAS, JAN'),
(5, 'SANTI, ELLA'),
(6, 'ARTON, MARIE'),
(7, 'ALDEO, MICHAEL'),
(8, 'GARA, CARLOS'),
(9, 'SARMIENTO, ANGELIE'),
(10, 'ONG, CHRISTIAN'),
(11, 'FRANCISCO, REMI'),
(12, 'SIY, GWEN'),
(13, 'PO, STEVEN'),
(14, 'DEL CASTILLO, EMMANUEL'),
(15, 'HERNANDEZ, ERNING'),
(16, 'CHUA, MARY');

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

--
-- Table structure for table `transaction`
--

CREATE TABLE IF NOT EXISTS `transaction` (
`transaction_id` int(11) NOT NULL,
  `patient_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL DEFAULT '0',
  `transaction_date` text NOT NULL,
  `transaction_quantity` int(11) NOT NULL,
  `fee` decimal(11,2) NOT NULL,
  `fee_quantity` int(11) NOT NULL DEFAULT '0',
  `x_ray_fee` decimal(11,2) NOT NULL,
  `lab_fee` decimal(11,2) NOT NULL,
  `notes` text NOT NULL,
  `med_fee` decimal(11,2) NOT NULL,
  `pas_fee` decimal(11,2) NOT NULL,
  `transaction_type_id` int(11) NOT NULL DEFAULT '1',
  `transaction_type_name` text NOT NULL,
  `treatment_id` int(11) NOT NULL DEFAULT '0',
  `treatment_type_name` text NOT NULL,
  `treatment_diagnosis` text NOT NULL,
  `transaction_old_new` tinyint(2) NOT NULL DEFAULT '0',
  `medical_doctor_id` int(11) NOT NULL,
  `report_id` int(11) NOT NULL,
  `ip_address_id` tinytext NOT NULL,
  `machine_address_id` tinytext NOT NULL,
  `added_datetime_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `transaction`
--

INSERT INTO `transaction` (`transaction_id`, `patient_id`, `item_id`, `transaction_date`, `transaction_quantity`, `fee`, `fee_quantity`, `x_ray_fee`, `lab_fee`, `notes`, `med_fee`, `pas_fee`, `transaction_type_id`, `transaction_type_name`, `treatment_id`, `treatment_type_name`, `treatment_diagnosis`, `transaction_old_new`, `medical_doctor_id`, `report_id`, `ip_address_id`, `machine_address_id`, `added_datetime_stamp`) VALUES
(1, 1, 0, '08/24/2020', 0, '3500.00', 0, '0.00', '0.00', 'MINORSET; PAID', '0.00', '0.00', 1, 'CASH', 0, '', '', 0, 1, 0, 'SERVER ADDRESS', '00-90-F5-60-88-BE', '2020-08-24 12:13:22'),
(3, 0, 439, '08/24/2020', 0, '560.00', 1, '0.00', '0.00', 'PAID', '0.00', '560.00', 1, 'CASH', 0, '', '', 0, 0, 0, 'SERVER ADDRESS', '00-90-F5-60-88-BE', '2020-08-24 12:14:32'),
(4, 1, 0, '08/24/2020', 3, '3500.00', 0, '0.00', '0.00', 'MINORSET; PAID', '0.00', '560.00', 1, 'CASH', 0, '', '', 0, 1, 0, 'SERVER ADDRESS', '00-90-F5-60-88-BE', '2020-08-24 12:14:36');

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

--
-- Table structure for table `transaction_type`
--

CREATE TABLE IF NOT EXISTS `transaction_type` (
`transaction_type_id` int(11) NOT NULL,
  `transaction_type_name` text NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=21 ;

--
-- Dumping data for table `transaction_type`
--

INSERT INTO `transaction_type` (`transaction_type_id`, `transaction_type_name`) VALUES
(1, 'CASH'),
(2, 'SC'),
(3, 'PWD'),
(4, 'HMO/ETIQA'),
(5, 'HMO/AVEGA'),
(6, 'HMO/BLUECROSS'),
(7, 'HMO/CAREHEALTHPLUS'),
(8, 'HMO/COCOLIFE'),
(9, 'HMO/EASTWEST'),
(10, 'HMO/GENERALIPHIL'),
(11, 'HMO/GETWELL'),
(12, 'HMO/HMI'),
(13, 'HMO/INTELLICARE'),
(14, 'HMO/LACSON-LACSON'),
(15, 'HMO/MAXICARE'),
(16, 'HMO/MEDASIA'),
(17, 'HMO/MEDICARD'),
(18, 'HMO/MEDOCARE'),
(19, 'HMO/PHILCARE'),
(20, 'HMO/VALUCARE');

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

--
-- Table structure for table `treatment`
--

CREATE TABLE IF NOT EXISTS `treatment` (
`treatment_id` int(11) NOT NULL,
  `treatment_type_id` int(11) NOT NULL,
  `treatment_datetime_stamp` datetime NOT NULL,
  `treatment_diagnosis` text CHARACTER SET utf8mb4 NOT NULL,
  `treatment_temperature` decimal(10,2) NOT NULL,
  `treatment_bp` text CHARACTER SET utf8mb4 NOT NULL,
  `therapist_id` int(11) NOT NULL,
  `added_datetime_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `treatment_type`
--

CREATE TABLE IF NOT EXISTS `treatment_type` (
`treatment_type_id` int(11) NOT NULL,
  `treatment_type_name` text CHARACTER SET utf8mb4 NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `treatment_type`
--

INSERT INTO `treatment_type` (`treatment_type_id`, `treatment_type_name`) VALUES
(1, 'CONSULT'),
(2, 'PT REHAB');

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

--
-- Table structure for table `x_ray_body_location`
--

CREATE TABLE IF NOT EXISTS `x_ray_body_location` (
`x_ray_body_location_id` int(11) NOT NULL,
  `x_ray_body_location_name` text NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ;

--
-- Dumping data for table `x_ray_body_location`
--

INSERT INTO `x_ray_body_location` (`x_ray_body_location_id`, `x_ray_body_location_name`) VALUES
(1, 'Chest (pedia)'),
(2, 'Chest (adult)'),
(3, 'Shoulder'),
(4, 'Wrist'),
(5, 'Hand'),
(6, 'Elbow'),
(7, 'Forearm'),
(8, 'Humerus'),
(9, 'Foot'),
(10, 'Ankle'),
(11, 'Ankle/Foot'),
(12, 'Both Os calsis'),
(13, 'Leg (adult)'),
(14, 'Leg (pedia)'),
(15, 'knee'),
(16, 'Knee / Patella'),
(17, 'Femur (adult)'),
(18, 'Femur (pedia)'),
(19, 'Skull'),
(20, 'Cervical'),
(21, 'T-cage'),
(22, 'Pelvis'),
(23, 'Pelvis / Hip Joints'),
(24, 'Thoraco-lumbar'),
(25, 'Lumbo-sacral'),
(26, 'Lumbo-sacral to lower thoracic'),
(27, 'Coccyx'),
(28, 'Both Lower<br/>Extremities (pedia)');

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

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

CREATE TABLE IF NOT EXISTS `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 AUTO_INCREMENT=81 ;

--
-- 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, 11, 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, 1100, '0000-00-00 00:00:00'),
(25, 20, 12, 900, '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, 1, 500, '0000-00-00 00:00:00'),
(41, 1, 6, 600, '2020-08-23 03:56:11'),
(42, 2, 14, 400, '2020-08-23 03:57:08'),
(43, 3, 2, 400, '2020-08-23 03:57:08'),
(44, 3, 6, 800, '2020-08-23 03:57:08'),
(45, 4, 6, 400, '2020-08-23 03:57:08'),
(46, 5, 10, 400, '2020-08-23 03:57:08'),
(47, 5, 8, 600, '2020-08-23 03:57:08'),
(48, 6, 6, 400, '2020-08-23 03:57:08'),
(49, 7, 6, 600, '2020-08-23 03:57:08'),
(50, 8, 2, 400, '2020-08-23 03:57:08'),
(51, 8, 6, 600, '2020-08-23 03:57:08'),
(52, 9, 10, 400, '2020-08-23 03:57:08'),
(53, 10, 6, 400, '2020-08-23 03:57:08'),
(54, 11, 8, 600, '2020-08-23 03:57:08'),
(55, 12, 13, 400, '2020-08-23 03:57:08'),
(56, 13, 6, 650, '2020-08-23 03:57:08'),
(57, 14, 6, 600, '2020-08-23 03:57:09'),
(58, 15, 6, 600, '2020-08-23 03:57:09'),
(59, 16, 9, 750, '2020-08-23 03:57:09'),
(60, 17, 6, 650, '2020-08-23 03:57:09'),
(61, 18, 6, 600, '2020-08-23 03:57:09'),
(62, 19, 6, 800, '2020-08-23 03:57:09'),
(63, 20, 6, 800, '2020-08-23 03:57:09'),
(64, 20, 7, 1400, '2020-08-23 03:57:09'),
(65, 20, 12, 1050, '2020-08-23 03:57:09'),
(66, 20, 13, 400, '2020-08-23 03:57:09'),
(67, 21, 2, 500, '2020-08-23 03:57:09'),
(68, 22, 2, 500, '2020-08-23 03:57:09'),
(69, 23, 5, 1000, '2020-08-23 03:57:09'),
(70, 24, 3, 500, '2020-08-23 03:57:09'),
(71, 24, 6, 1000, '2020-08-23 03:57:09'),
(72, 24, 4, 1800, '2020-08-23 03:57:09'),
(73, 24, 15, 450, '2020-08-23 03:57:09'),
(74, 25, 6, 900, '2020-08-23 03:57:09'),
(75, 25, 11, 1000, '2020-08-23 03:57:09'),
(76, 25, 13, 450, '2020-08-23 03:57:09'),
(77, 26, 6, 1000, '2020-08-23 03:57:09'),
(78, 27, 6, 900, '2020-08-23 03:57:09'),
(79, 27, 13, 450, '2020-08-23 03:57:09'),
(80, 28, 1, 500, '2020-08-23 03:57:09');

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

--
-- Table structure for table `x_ray_type`
--

CREATE TABLE IF NOT EXISTS `x_ray_type` (
`x_ray_type_id` int(11) NOT NULL,
  `x_ray_type_name` text NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

--
-- Dumping data for table `x_ray_type`
--

INSERT INTO `x_ray_type` (`x_ray_type_id`, `x_ray_type_name`) VALUES
(1, '(Pedia) AP'),
(2, 'AP only'),
(3, 'AP-upright'),
(4, 'AP, R/L Bending'),
(5, 'AP/Frog leg'),
(6, 'AP/Lateral'),
(7, 'AP/Lateral, R/L Oblique'),
(8, 'AP/Lateral/Oblique ( 3:1 )'),
(9, 'AP/Lateral/Skyline (3:1)'),
(10, 'AP/Oblique'),
(11, 'Hips AP, L-S Lateral'),
(12, 'Lateral, R/L Oblique'),
(13, 'Lateral only'),
(14, 'PA'),
(15, 'Scoliosis Series');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `image`
--
ALTER TABLE `image`
 ADD PRIMARY KEY (`image_id`), ADD KEY `transaction_id` (`transaction_id`);

--
-- Indexes for table `inventory`
--
ALTER TABLE `inventory`
 ADD PRIMARY KEY (`inventory_id`);

--
-- Indexes for table `item`
--
ALTER TABLE `item`
 ADD PRIMARY KEY (`item_id`), ADD KEY `item_type_id` (`item_type_id`);

--
-- Indexes for table `item_type`
--
ALTER TABLE `item_type`
 ADD PRIMARY KEY (`item_type_id`);

--
-- Indexes for table `medical_doctor`
--
ALTER TABLE `medical_doctor`
 ADD PRIMARY KEY (`medical_doctor_id`);

--
-- Indexes for table `patient`
--
ALTER TABLE `patient`
 ADD PRIMARY KEY (`patient_id`);

--
-- Indexes for table `receipt`
--
ALTER TABLE `receipt`
 ADD PRIMARY KEY (`receipt_id`), ADD KEY `receipt_type_id` (`receipt_type_id`), ADD KEY `transaction_id` (`transaction_id`);

--
-- Indexes for table `receipt_type`
--
ALTER TABLE `receipt_type`
 ADD PRIMARY KEY (`receipt_type_id`);

--
-- Indexes for table `report`
--
ALTER TABLE `report`
 ADD PRIMARY KEY (`report_id`), ADD KEY `payslip_type_id` (`report_type_id`);

--
-- Indexes for table `report_type`
--
ALTER TABLE `report_type`
 ADD PRIMARY KEY (`report_type_id`);

--
-- Indexes for table `therapist`
--
ALTER TABLE `therapist`
 ADD PRIMARY KEY (`therapist_id`);

--
-- Indexes for table `transaction`
--
ALTER TABLE `transaction`
 ADD PRIMARY KEY (`transaction_id`), ADD KEY `medical_doctor_id` (`medical_doctor_id`), ADD KEY `report_id` (`report_id`), ADD KEY `patient_id` (`patient_id`), ADD KEY `item_id` (`item_id`);

--
-- Indexes for table `transaction_type`
--
ALTER TABLE `transaction_type`
 ADD PRIMARY KEY (`transaction_type_id`);

--
-- Indexes for table `treatment`
--
ALTER TABLE `treatment`
 ADD PRIMARY KEY (`treatment_id`);

--
-- Indexes for table `treatment_type`
--
ALTER TABLE `treatment_type`
 ADD PRIMARY KEY (`treatment_type_id`), ADD UNIQUE KEY `treatment_type_id` (`treatment_type_id`);

--
-- Indexes for table `x_ray_body_location`
--
ALTER TABLE `x_ray_body_location`
 ADD PRIMARY KEY (`x_ray_body_location_id`);

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

--
-- Indexes for table `x_ray_type`
--
ALTER TABLE `x_ray_type`
 ADD PRIMARY KEY (`x_ray_type_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `image`
--
ALTER TABLE `image`
MODIFY `image_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `inventory`
--
ALTER TABLE `inventory`
MODIFY `inventory_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=450;
--
-- AUTO_INCREMENT for table `item`
--
ALTER TABLE `item`
MODIFY `item_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=440;
--
-- AUTO_INCREMENT for table `item_type`
--
ALTER TABLE `item_type`
MODIFY `item_type_id` tinyint(4) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `medical_doctor`
--
ALTER TABLE `medical_doctor`
MODIFY `medical_doctor_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `patient`
--
ALTER TABLE `patient`
MODIFY `patient_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=20;
--
-- AUTO_INCREMENT for table `receipt`
--
ALTER TABLE `receipt`
MODIFY `receipt_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `receipt_type`
--
ALTER TABLE `receipt_type`
MODIFY `receipt_type_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `report`
--
ALTER TABLE `report`
MODIFY `report_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `report_type`
--
ALTER TABLE `report_type`
MODIFY `report_type_id` tinyint(4) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `therapist`
--
ALTER TABLE `therapist`
MODIFY `therapist_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `transaction`
--
ALTER TABLE `transaction`
MODIFY `transaction_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `transaction_type`
--
ALTER TABLE `transaction_type`
MODIFY `transaction_type_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=21;
--
-- AUTO_INCREMENT for table `treatment`
--
ALTER TABLE `treatment`
MODIFY `treatment_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `treatment_type`
--
ALTER TABLE `treatment_type`
MODIFY `treatment_type_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `x_ray_body_location`
--
ALTER TABLE `x_ray_body_location`
MODIFY `x_ray_body_location_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=29;
--
-- 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=81;
--
-- AUTO_INCREMENT for table `x_ray_type`
--
ALTER TABLE `x_ray_type`
MODIFY `x_ray_type_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=16;
--
-- Constraints for dumped tables
--

--
-- Constraints for table `image`
--
ALTER TABLE `image`
ADD CONSTRAINT `image_ibfk_1` FOREIGN KEY (`transaction_id`) REFERENCES `transaction` (`transaction_id`);

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