-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Dec 15, 2025 at 01:52 AM
-- Server version: 10.4.27-MariaDB
-- PHP Version: 8.2.0

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `escent_pricelist`
--

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

--
-- Table structure for table `pathology`
--

CREATE TABLE `pathology` (
  `Slno` int(10) UNSIGNED NOT NULL,
  `Investigation` varchar(255) NOT NULL,
  `Walkinprice` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `pathology`
--

INSERT INTO `pathology` (`Slno`, `Investigation`, `Walkinprice`) VALUES
(1, '24 Hrs Protein Albumin Ratio', 630),
(2, '24 Hrs Urine Creatinine Clearance Test', 480),
(3, '24 Hrs Urinary Protein', 350),
(4, '24 Hrs Urinary Uric Acid', 230),
(5, '24 hrs URINE CYTOLOGY', 180),
(6, '24hrs CAPD Fluid CREATININE', 180),
(7, '24hrs CAPD Fluid UREA', 180),
(8, '24hrs URINARY ALBUMIN', 640),
(9, '24hrs URINARY CALCIUM', 290),
(10, '24hrs URINARY CHLORIDE', 180),
(11, '24hrs URINARY CREATININE', 180),
(12, '24hrs URINARY PHOSPHOROUS', 250),
(13, '24hrs URINARY POTASSIUM', 180),
(14, '24hrs URINARY SODIUM', 180),
(15, '24hrs URINARY UREA', 180),
(16, '24hrs URINARY URIC ACID', 230),
(17, '24hrs URINE AFB', 200),
(18, '24hrs Urine Protein Creatinine Ratio', 550),
(19, '24hrs URINE R/E', 200),
(20, '24hrs URINE SPECIFIC GRAVITY', 220),
(21, '24hrs URINE VOLUME', 100),
(22, 'A:G (ALBUMIN:GLOBULIN) RATIO', 280),
(23, 'ABSOLUTE EOSINOPHIL COUNT', 150),
(24, 'ABSOLUTE GRANULOCYTE COUNT', 150),
(25, 'ABSOLUTE LYMPHOCYTE COUNT', 150),
(26, 'ABSOLUTE NEUTROPHIL COUNT', 150),
(27, 'ADENOSINE DEAMINASE (ADA) - BLOOD', 930),
(28, 'Adenosine Deaminase (ADA)-CSF', 930),
(29, 'Adenosine Deaminase (ADA)-FLUID', 930),
(30, 'ALBUMIN, Fluid', 190),
(31, 'ALBUMIN, Serum', 190),
(32, 'ALBUMIN/CREATININE RATIO, 24hrs URINE', 750),
(33, 'ALFA FETO PROTEIN (AFP)', 1250),
(34, 'ALKALINE PHOSPHATASE (ALP)', 160),
(35, 'AMH PANEL', 3900),
(36, 'AMH PLUS', 4650),
(37, 'AMYLASE', 600),
(38, 'Amylase Fluid', 600),
(39, 'ANTI CCP (ANTI CYCLIC CIRULLINATED PEPTIDE)', 1950),
(40, 'ANTI ds DNA', 950),
(41, 'ANTI HbeAg', 900),
(42, 'ANTI HBs Titre', 1000),
(43, 'Anti- HbsAg', 900),
(44, 'ANTI MULLERIAN HORMONE (AMH)', 2000),
(45, 'ANTI NUCLEAR ANTIBODY (ANA)', 950),
(46, 'ANTI PHOSPHOLIPID ANTIBODY, IgG', 1500),
(47, 'ANTI PHOSPHOLIPID ANTIBODY, IgM', 1500),
(48, 'ANTI STREPTOLYSIN O (ASO) - Quantitative', 650),
(49, 'ANTI STREPTOLYSIN O (ASO) - Semi-Quantitative', 650),
(50, 'Anti Thyroglobulin', 1500),
(51, 'ANTI TPO (THYROID PEROXIDASE) ANTIBODY', 1500),
(52, 'Apla IgG IgM', 2500),
(53, 'Ascitic Fluid for AFB', 200),
(54, 'Ascitic Fluid RE', 650),
(55, 'AUTOLOGOUS SKIN SERUM TEST(ASST)', 280),
(56, 'Bence Jones Protein, Urine', 100),
(57, 'BETA - HCG', 950),
(58, 'BICARBONATE', 900),
(59, 'Bile Pigment/Salts - URINE TEST', 160),
(60, 'Bilirubin ( Total & Conjugate)', 220),
(61, 'BIOPSY - SECOND OPINION', 800),
(62, 'BIOPSY (LARGE)', 1650),
(63, 'BIOPSY (MEDIUM)', 990),
(64, 'BIOPSY (SMALL)', 900),
(65, 'BIOPSY CANCER/COMPLEX SPECIMEN', 3750),
(66, 'BLAST CELLS', 100),
(67, 'BLEEDING TIME', 100),
(68, 'Blood Culture & Sensitivity', 980),
(69, 'Blood Glucose Fasting', 120),
(70, 'Blood Glucose PP', 120),
(71, 'Blood Glucose Random', 120),
(72, 'BLOOD GROUP (ABO & Rh Typing)', 150),
(73, 'Blood in Urine', 100),
(74, 'BLOOD PICTURE - PERIPHERAL SMEAR EXAMINATION (P/S)', 130),
(75, 'Blood Urea Nitrogen (BUN)', 150),
(76, 'Body Fluid RE', 650),
(77, 'Bone Marrow Aspiration Cytology', 800),
(78, 'BONE MARROW IRON STAIN', 570),
(79, 'BREAST CANCER PANEL - 1 (ERPR)', 2400),
(80, 'BREAST DISCHARGE CYTOLOGY', 200),
(81, 'BT CT', 180),
(82, 'C3 Compliment', 750),
(83, 'C4- Complement', 750),
(84, 'CA - 125', 1500),
(85, 'CA 19.9', 1500),
(86, 'Calcium', 290),
(87, 'Calcium Ionised', 900),
(88, 'Calcium Profile Test', 820),
(89, 'Carcinoembryonic Antigen(CEA)', 950),
(90, 'Cardiac Enzymes Profile', 1700),
(91, 'CELL BLOCK CYTOLOGY', 600),
(92, 'Cerebrospinal Fluid, Analysis', 650),
(93, 'Cervical Smear (Liquid Based Cytology)', 800),
(94, 'Chloride', 180),
(95, 'Chloride - CSF', 180),
(96, 'Chloride (URINE SPOT TEST)', 180),
(97, 'Clot Retraction Time', 70),
(98, 'CLOTTING TIME', 100),
(99, 'CMV IgG', 430),
(100, 'CMV IgG & IgM', 800),
(101, 'CMV IgM', 430),
(102, 'COAGULATION PROFILE', 900),
(103, 'Cold Agglutination', 100),
(104, 'COMPLETE BLOOD COUNT', 550),
(105, 'Complete Blood Count (CBC)', 550),
(106, 'COOMB S TEST DIRECT', 370),
(107, 'COOMB S TEST INDIRECT', 400),
(108, 'Cortisol - Evening', 800),
(109, 'Cortisol - Morning', 800),
(110, 'Cortisol Random', 800),
(111, 'Covid - 19 RT PCR (SARS-CoV-2)', 1000),
(112, 'COVID-19 (SARS-CoV-2)', 1600),
(113, 'Creatine Kinase (CK)', 350),
(114, 'Creatine Kinase MB (CK-MB)', 480),
(115, 'Creatinine', 180),
(116, 'Creatinine (URINE SPOT TEST)', 150),
(117, 'CREATININE, FLUID', 180),
(118, 'CRP (C-REACTIVE PROTEIN) Quantitative', 580),
(119, 'CRP (C-REACTIVE PROTEIN) Semi Quantitative', 500),
(120, 'CSF for AFB', 200),
(121, 'CSF SUGAR', 100),
(122, 'Culture & Sensitivity', 880),
(123, 'Cytological Examination', 200),
(124, 'CYTOLOGY CONSULTATION-SECOND OPINION', 550),
(125, 'Cytology Scrapping', 350),
(126, 'D- Dimer', 1100),
(127, 'Dengue DUO', 1200),
(128, 'Dengue PCR', 2700),
(129, 'Differential leucocyte Count (DLC)', 150),
(130, 'DRAIN FLUID TRIGLYCERIDE LEVEL', 300),
(131, 'ECG', 300),
(132, 'Electrolytes', 520),
(133, 'ENA Screen', 4000),
(134, 'ERYTHROCYTE SEDIMENTATION RATE (ESR)', 100),
(135, 'Estradiol - Oestradiol (E2)', 800),
(136, 'Faecal Reducing Substance', 100),
(137, 'Fecal Calprotectin', 2200),
(138, 'Ferritin', 750),
(139, 'Fibrinogen', 1500),
(140, 'FLUID AFB', 200),
(141, 'Fluid Analysis', 650),
(142, 'FNAC', 850),
(143, 'FNAC (ULTRASOUND GUIDE)', 1950),
(144, 'Free - T3', 400),
(145, 'Free - T4', 400),
(146, 'FSH (FOLLICLE STIMULATING HORMONE)', 680),
(147, 'FUNGAL Culture & Sensitivity', 900),
(148, 'Fungal Study', 200),
(149, 'Fungal Study Stool', 200),
(150, 'GAMMA GLUTAMYL TRANSFERASE (GGT)', 160),
(151, 'Genexpert', 2500),
(152, 'GeneXpert MTB WITH RIFAMPICIN RESISTANCE, QUALITATIVE', 2850),
(153, 'GLOBULIN', 150),
(154, 'Glucose Challenge Test (GCT) 50gm', 120),
(155, 'Glucose Challenge Test (GCT) 75gm', 120),
(156, 'Glucose Tolerance Test (GTT) 100 gm', 400),
(157, 'Glucose Tolerance Test (GTT) 75 gm (3 samples)', 400),
(158, 'Glucose Tolerance Test (OGTT)', 250),
(159, 'Glomerual Filtration Rate', 250),
(160, 'Gram Stain', 200),
(161, 'H. PYLORI', 930),
(162, 'H. Pylori Ag Stool', 950),
(163, 'Haematocrit', 100),
(164, 'Haemoglobin (Hb)', 100),
(165, 'Hair Clipping', 200),
(166, 'Hair Clipping For KOH Mount', 200),
(167, 'HbA1c', 780),
(168, 'HbeAg', 300),
(169, 'HBsAg', 450),
(170, 'HBsAg (CMIA)', 500),
(171, 'HCV Antibody (Hepatitis C Virus)', 530),
(172, 'HCV (CMIA)', 580),
(173, 'HCV RNA Viral Load', 7700),
(174, 'HDL Cholesterol', 250),
(175, 'Hepatitis A Virus (HAV), IgM', 800),
(176, 'Hepatitis A Virus (HAV), Total', 800),
(177, 'Hepatitis B Viral Load', 7500),
(178, 'Hepatitis E Virus (HEV), IgG', 1300),
(179, 'Hepatitis E Virus (HEV), IgM', 1300),
(180, 'HIV Antibody (4th Generation +Ag)', 480),
(181, 'HIV Antibody Tri-Dot', 480),
(182, 'HIV (CMIA)', 530),
(183, 'HIV Viral Load (QT)', 4000),
(184, 'HLA-b27 by PCR', 2800),
(185, 'HPV PCR', 2800),
(186, 'HSV 1&2 - IgG', 500),
(187, 'HSV 1&2, IgM', 500),
(188, 'HSV 1,2 (IgG & IgM) ANTIBODY', 980),
(189, 'IHC - CD20', 1500),
(190, 'IHC - CD3', 1500),
(191, 'IHC Individual Marker, C-erb B2/HER-2-NEU', 1500),
(192, 'IHC Individual Marker, ER (Estrogen Receptor)', 1500),
(193, 'IHC Individual Marker, Ki 67', 1500),
(194, 'IHC Individual Marker, PR (Progesterone Receptor)', 1500),
(195, 'IMMATURE TO TOTAL NEUTROPHIL RATIO', 130),
(196, 'IMMUNOHISTOCHEMISTRY - HMB 45', 1500),
(197, 'Immunohistochemistry Any 5 Marker( EMA, CD99, CD34, S- 100)', 5200),
(198, 'IMMUNOHISTOCHEMISTRY CD34', 1500),
(199, 'IMMUNOHISTOCHEMISTRY CD45', 1500),
(200, 'IMMUNOHISTOCHEMISTRY CYTOKERATIN (CK)', 1500),
(201, 'Immunohistochemistry for CD117', 1500),
(202, 'INDIA INK PREPARATION', 100),
(203, 'INORGANIC PHOSPHORUS', 250),
(204, 'Insulin Fasting', 600),
(205, 'Insulin PP', 600),
(206, 'Intact Parathyroid Hormone(iPTH)', 1950),
(207, 'INTERLEUKIN - 6', 3500),
(208, 'Iron Profile', 950),
(209, 'Iron Profile with TSAT', 980),
(210, 'IRON, SERUM', 280),
(211, 'IRON/TIBC/UIBC', 400),
(212, 'KIDNEY FUNCTION TEST', 890),
(213, 'KIDNEY PANEL', 1600),
(214, 'LDH, Fluid', 390),
(215, 'LDH, Serum', 390),
(216, 'LDL Cholesterol', 350),
(217, 'LE CELL PHENOMENON', 180),
(218, 'LH (Leutinizing Hormone)', 680),
(219, 'Lipase', 600),
(220, 'LIPID PROFILE', 980),
(221, 'LIVER FUNCTION TEST (LFT)', 950),
(222, 'Magnesium', 400),
(223, 'Malarial Parasite (OMT)', 380),
(224, 'Malarial Parasite (QBC)', 230),
(225, 'Malarial Parasite (SMEAR)', 100),
(226, 'Malignant Cell', 200),
(227, 'MANTOUX TEST', 100),
(228, 'MCH', 100),
(229, 'MCHC', 100),
(230, 'MCV', 100),
(231, 'MIXING STUDY FOR COAGULATION INHIBITORS', 860),
(232, 'MTB - RIF', 2850),
(233, 'MTB PCR', 2500),
(234, 'Nail Clipping For KOH Mount', 200),
(235, 'Nasal Discharge Eosinophil', 200),
(236, 'Oral Scrapping R/E', 650),
(237, 'P.T. RATIO', 200),
(238, 'Pap Smear', 250),
(239, 'PCOD ( Polycystic Ovarian Diesease ) PANEL', 2950),
(240, 'PCOD Panel (Extended)', 5500),
(241, 'PCOD Panel (Mini)', 2950),
(242, 'PCOD Panel (Maxi)', 4050),
(243, 'Pericardial Fluid', 650),
(244, 'Peritoneal Fluid', 650),
(245, 'pH Pleural Fluid', 50),
(246, 'PIVKA II', 3000),
(247, 'PLATELET COUNT', 100),
(248, 'Platelet rich plasma (PRP)', 2000),
(249, 'Pleural Fluid RE', 650),
(250, 'Plueral Fluid for AFB', 200),
(251, 'Potassium', 180),
(252, 'Potassium (URINE SPOT TEST)', 170),
(253, 'Pregnancy test, Urine', 110),
(254, 'Procalcitonin', 1800),
(255, 'Progesterone', 750),
(256, 'Prolactin', 750),
(257, 'Prostate Specific Antigen (Free) PSA', 980),
(258, 'Prostate SpecificC Antigen (Total) PSA', 980),
(259, 'Protein (URINE SPOT TEST)', 320),
(260, 'Protein Creatinine Ratio, Random Urine', 580),
(261, 'PROTEIN TOTAL, 24 Hours Urine', 320),
(262, 'Protein Total, Fluid', 230),
(263, 'PROTEIN Total, Serum', 230),
(264, 'PROTHROMBIN TIME & INR', 480),
(265, 'PTTK/APTT', 480),
(266, 'Pus for AFB', 200),
(267, 'RAPID ANTIGEN TEST (RAT) FOR SARS-CoV-2', 500),
(268, 'RAPID UREASE TEST OF H-PYLORI (RUT)', 500),
(269, 'RBC COUNT', 100),
(270, 'RDW', 100),
(271, 'RETICULOCYTE COUNT', 200),
(272, 'RHEUMATOID FACTOR - QUANTITATIVE', 630),
(273, 'RHEUMATOID FACTOR - SEMI QUANTITATIVE', 530),
(274, 'RUBELLA IgG', 450),
(275, 'RUBELLA IgG & IgM', 800),
(276, 'RUBELLA IgM', 450),
(277, 'SALMONELLA TYPHI-Dot Enterocheck', 470),
(278, 'SARS-CoV-2 IgG Antibody', 1500),
(279, 'SARS-CoV-2 IgM Antibody', 1500),
(280, 'Scrapping (Leg Skin Lesion)', 200),
(281, 'Scrub Typhus', 500),
(282, 'Semen Analysis', 650),
(283, 'SEMEN FOR AFB', 200),
(284, 'SEPSIS SCREEN PROFILE', 1180),
(285, 'Serum Ascites Albumin Gradient (SAAG)', 400),
(286, 'Serum IGE', 880),
(287, 'Serum Lactate Dehydrogenase', 390),
(288, 'Serum Pleural Albumin Gradient', 400),
(289, 'SGOT/AST (ASPARTATE AMINO-TRANSFERASE)', 190),
(290, 'SGPT/ALT (ALANINE AMINO-TRANSFERASE)', 190),
(291, 'Sickling Test', 300),
(292, 'Skin Scrapping For KOH Mount', 200),
(293, 'Slide preparation (histo) Block -01', 150),
(294, 'Slide preparation (Histo) Block 02-04', 200),
(295, 'Slide preparation (Histo)- block -08-09', 400),
(296, 'Slide preparation (histo) block>10', 500),
(297, 'Slide prepation (Histo)-Block 05-07', 300),
(298, 'Smear for Malignant Cells', 180),
(299, 'Sodium', 200),
(300, 'Sodium (URINE SPOT TEST)', 200),
(301, 'SPECIAL HEALTH PACKAGE', 499),
(302, 'SPECIAL STAIN PAS', 450),
(303, 'Spinocan GB Needle', 120),
(304, 'SPUTUM CYTOLOGY', 200),
(305, 'SPUTUM FOR AFB EARLY MORNING', 200),
(306, 'SPUTUM FOR AFB SPOT', 200),
(307, 'SPUTUM FOR AFB STAIN', 200),
(308, 'SPUTUM FOR FUNGAL STAIN', 200),
(309, 'SPUTUM FOR GRAM STAIN', 200),
(310, 'SPUTUM FOR PARAGONIMUS EGG', 150),
(311, 'SPUTUM R/E', 650),
(312, 'STAIN, GIEMSA', 450),
(313, 'Stool For AFB', 200),
(314, 'STOOL FOR CRYPTOSPORIDIUM', 100),
(315, 'Stool for Hanging Drop', 100),
(316, 'Stool for Occult Blood', 150),
(317, 'Stool for Occult Blood 1st Day', 150),
(318, 'Stool for Occult Blood 2nd Day', 150),
(319, 'Stool for Occult Blood 3rd Day', 150),
(320, 'Stool For Paragonimus Egg', 150),
(321, 'Stool OVA And CYST', 100),
(322, 'Stool Routine Examination', 200),
(323, 'Synovial Fluid R/E', 650),
(324, 'T3 ( Total )', 250),
(325, 'T4 ( Total )', 250),
(326, 'TB - QUANTIFERON', 2950),
(327, 'Testosterone', 800),
(328, 'TFT', 700),
(329, 'Throat Swab R/E', 650),
(330, 'THYROID FUNCTION TEST', 700),
(331, 'Thyroid Stimulating Hormone(TSH)', 300),
(332, 'TORCH PROFILE', 2800),
(333, 'TOTAL Cholesterol', 250),
(334, 'Total Granulocyte Count', 100),
(335, 'Total Iron- Binding capacity', 120),
(336, 'TOTAL LEUKOCYTE COUNT (TLC)', 100),
(337, 'Total Protein, CSF', 320),
(338, 'Toxoplasma Antibody IgG, IgM', 800),
(339, 'Toxoplasma IgG', 430),
(340, 'Toxoplasma IgM', 430),
(341, 'Triglycerides', 250),
(342, 'Troponin - I', 800),
(343, 'Troponin - T', 800),
(344, 'Typhidot Test', 490),
(345, 'Urea', 180),
(346, 'Urea Creatinine Ratio', 380),
(347, 'UREA, FLUID', 180),
(348, 'Uric Acid', 230),
(349, 'Urinary Amylase', 500),
(350, 'Urinary Calcium, Random', 290),
(351, 'Urinary Haemoglobin', 100),
(352, 'Urinary Lipase', 500),
(353, 'Urinary Magnesium Random', 400),
(354, 'Urinary Phosphorous Random', 250),
(355, 'Urinary Protein Random', 350),
(356, 'Urinary Uric Acid Random', 230),
(357, 'Urine AFB', 200),
(358, 'Urine AFB - 2nd Day', 200),
(359, 'Urine AFB - 3rd Day', 200),
(360, 'Urine Albumin (Qualitative)', 100),
(361, 'Urine Albumin Creatinine Ratio (ACR)', 750),
(362, 'Urine Albumin Creatinine Ratio (ACR) 24Hrs', 750),
(363, 'Urine Bilirubin', 80),
(364, 'Urine Creatinine Clearance Test', 370),
(365, 'URINE CYTOLOGY', 200),
(366, 'Urine Drug Screening', 800),
(367, 'Urine for Eosinophil', 100),
(368, 'URINE FOR REDUCING SUGAR', 120),
(369, 'URINE FOR TB PCR', 2500),
(370, 'Urine Fungal Body', 200),
(371, 'Urine Ketone Bodies', 100),
(372, 'Urine Microalbumin', 640),
(373, 'Urine Microscopy', 60),
(374, 'URINE PIGMENT', 90),
(375, 'Urine Protein Creatinine Ratio', 580),
(376, 'Urine Routine Examination', 190),
(377, 'URINE SALT', 90),
(378, 'Urine SP-Gravity', 100),
(379, 'Urine Sugar', 100),
(380, 'Urine Sugar (Fasting & PP)', 100),
(381, 'Urine Urobilinogen', 100),
(382, 'Vaginal Swab R/E', 650),
(383, 'VDRL/RPR', 200),
(384, 'Vitamin B12', 1300),
(385, 'Vitamin D 25-HYDROXY', 1850),
(386, 'VLDL', 280),
(387, 'WIDAL', 300),
(388, 'Wound Swab for AFB', 200),
(389, 'Wound swab For Gram Stain', 200),
(390, 'Stool Cryptosporidium - BABINA', 100),
(391, 'CMV PCR, Tissue (Metropolis) ', 4620),
(392, 'Anti TR Ab ( TSH Receptor Antibody) - UNIPATH', 2000),
(393, 'Typhoid IgM', 490),
(394, 'Mumps IgG - UNIPATH', 1000),
(395, 'Measles Rubeola IgG', 900),
(396, 'Rubella IgG - UNIPATH', 600),
(397, 'C1 Esterase Inhibitor Level - UNIPATH', 2500);

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

--
-- Table structure for table `radiology`
--

CREATE TABLE `radiology` (
  `Slno` int(11) NOT NULL,
  `Investigation` varchar(255) NOT NULL,
  `Walkinprice` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `radiology`
--

INSERT INTO `radiology` (`Slno`, `Investigation`, `Walkinprice`) VALUES
(1, 'CT Arm', 3700),
(2, 'CT Foot', 3950),
(3, 'CT Temporal Bone', 3150),
(4, 'CT - HIP JOINT', 3900),
(5, 'CT - KUB', 6050),
(6, 'CT - LEG', 2750),
(7, 'CT - NECK', 3980),
(8, 'CT - PELVIS', 3900),
(9, 'CT - PNS', 4000),
(10, 'CT - SHOULDER', 3900),
(11, 'CT - THORAX', 3880),
(12, 'CT - TM JOINT', 3900),
(13, 'CT - WRIST JOINT', 3900),
(14, 'CT Abdominal Angiography', 8430),
(15, 'CT Ankle Joint', 3700),
(16, 'CT Aortagram with carotid angiogram', 8650),
(17, 'CT Base of Skull', 2650),
(18, 'CT Base of Skull with Brain', 2850),
(19, 'CT Bony Pelvis', 3150),
(20, 'CT Brain ( Involving Special Investigation)', 2650),
(21, 'CT Brain with Orbit', 3900),
(22, 'CT Brain with PNS', 3950),
(23, 'CT Brain with Posterior Fossa', 2450),
(24, 'CT Brain with Temporal Bone', 3900),
(25, 'CT Brain, Contrast', 2230),
(26, 'CT Brain, Plain', 1950),
(27, 'CT Carotid Angio', 6180),
(28, 'CT Cerebral Angiography', 6180),
(29, 'CT Cervical with base of Skull', 3650),
(30, 'CT Cervico - Thoracic Spine', 4450),
(31, 'CT Chest with 3D', 4450),
(32, 'CT Colonography', 4350),
(33, 'CT Coronary Angiography', 10650),
(34, 'CT Dorsal/Thoracic Spine', 3950),
(35, 'CT Dual/Bi Phase', 6450),
(36, 'CT ELBOW JOINT', 3900),
(37, 'CT Enterography', 5730),
(38, 'CT Face', 3050),
(39, 'CT Face with PNS', 3900),
(40, 'CT FOREARM', 3900),
(41, 'CT Humerus', 3150),
(42, 'CT Internal Auditory Canal', 3050),
(43, 'CT KNEE JOINT', 3900),
(44, 'CT KUB Plain', 3750),
(45, 'CT KUB Urogram', 6730),
(46, 'CT Larynx', 3900),
(47, 'CT Lower Abdomen', 3430),
(48, 'CT Lumbar Spine', 3450),
(49, 'CT Lumbosacral', 3350),
(50, 'CT Mandible', 3050),
(51, 'CT MASTOID AIR CELL', 3050),
(52, 'CT Myelo', 3050),
(53, 'CT Nasopharynx', 3900),
(54, 'CT Nasopharynx with Neck', 3900),
(55, 'CT Oral Cavity', 2950),
(56, 'CT Orbits', 3650),
(57, 'CT Palate', 3150),
(58, 'CT Patella', 2650),
(59, 'CT Peripheral Angiography', 8430),
(60, 'CT PNS (Ax, Sag & Cor)', 4000),
(61, 'CT PNS (Coronal)', 2050),
(62, 'CT PNS with Nasopharynx', 4450),
(63, 'CT Posterior Fossa', 2050),
(64, 'CT Pulmonary Angiography', 6730),
(65, 'CT Renal Angiography', 6730),
(66, 'CT Sella', 2650),
(67, 'CT THIGH', 3150),
(68, 'CT Thoracic Angiography', 6730),
(69, 'CT THORACO-LUMBAR SPINE', 4950),
(70, 'CT Tibia', 2050),
(71, 'CT Tri Phase', 7030),
(72, 'CT Tri-Phase with Whole Abdomen', 8230),
(73, 'CT Upper Abdomen', 3230),
(74, 'CT Urography', 5850),
(75, 'CT VIRTUAL ENDOSCOPY', 4650),
(76, 'CT WHOLE ABDOMEN', 6080),
(77, 'CT WHOLE ABDOMEN WITH UROGRAM', 6950),
(78, 'HRCT THORAX', 5000),
(79, 'HRCT THORAX (SCREENING)', 1500);

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

--
-- Table structure for table `ultrasound`
--

CREATE TABLE `ultrasound` (
  `Slno` int(11) NOT NULL,
  `Investigation` varchar(255) NOT NULL,
  `Walkinprice` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ultrasound`
--

INSERT INTO `ultrasound` (`Slno`, `Investigation`, `Walkinprice`) VALUES
(1, 'ABDOMINAL DOPPLER - USG', 2800),
(2, 'ANKLE JOINT - USG', 1200),
(3, 'APPENDIX AREA - USG', 400),
(4, 'AV DOPPLER STUDY BOTH LEGS', 6000),
(5, 'AXILLA - USG', 600),
(6, 'Axilla for one site (USG)', 350),
(7, 'Bilateral Cervical Region - USG', 900),
(8, 'BILATERAL LIMB DOPPLER - USG ( Both side)', 6500),
(9, 'BILATERAL SCROTUM COLOUR DOPPLER - USG', 950),
(10, 'Bilateral Upper Limb - USG', 1800),
(11, 'BREAST - USG', 1000),
(12, 'Breast One Site - USG', 600),
(13, 'Buttock', 900),
(14, 'CALF - USG', 900),
(15, 'CAROTID DOPPLER - USG', 3500),
(16, 'Cervical Region One Site - USG', 500),
(17, 'CHEST (ONE SITE) - USG', 400),
(18, 'CHEST - USG', 700),
(19, 'CONGENITAL ANOMALY', 2900),
(20, 'Cranium - USG', 1100),
(21, 'FAST/E FAST - USG', 1100),
(22, 'FCS usg', 490),
(23, 'FETAL DOPPLER - USG', 1900),
(24, 'FETAL DOPPLER TWINS - USG', 3100),
(25, 'FETAL REDUCTION - USG', 3100),
(26, 'FOREARM - USG', 900),
(27, 'FWB ( NUCHAL TRANSLUCENCY ) - USG', 950),
(28, 'FWB ( NUCHAL TRANSLUCENCY ) SCREENING - USG', 650),
(29, 'FWB ( Screening) - USG', 550),
(30, 'FWB (Anomaly Scan) - USG', 2900),
(31, 'FWB (TWINS) - USG', 1300),
(32, 'FWB - USG', 830),
(33, 'FWB Anomaly Scan (Twins) - USG', 4500),
(34, 'FWB POST ANOMALY SCAN - USG', 800),
(35, 'FWB Twins ( Screening ) - USG', 900),
(36, 'FWB WITH BIOPHYSICAL PROFILE', 900),
(37, 'FWB(NUCHAL TRANSLUCENCY) TWINS - USG', 1600),
(38, 'FWB(NUCHAL TRANSLUCENCY) TWINS SCREENING - USG', 1200),
(39, 'FWB NT + NB', 1100),
(40, 'G.B. Area USG', 400),
(41, 'INGUINAL REGION (BOTH SITE) - USG', 950),
(42, 'INGUINAL REGION (ONE SITE ) - USG', 550),
(43, 'Inguinoscrotal Region ( Both Site ) usg', 1600),
(44, 'Inguinoscrotal Region (One Site) - USG', 850),
(45, 'Kidney Area (One Site) - USG', 400),
(46, 'KUB (Screening) - USG', 550),
(47, 'KUB USG', 700),
(48, 'LEVEL - I USG', 1100),
(49, 'LIVER AREA - USG', 400),
(50, 'Lower Abdomen (Screening) - USG', 550),
(51, 'Lower Abdomen - USG', 700),
(52, 'NECK - USG', 1500),
(53, 'NECK (ONE SITE) - USG', 700),
(54, 'NECK (SCREENING) - USG', 900),
(55, 'PAROTID GLAND (BOTH SITE)', 900),
(56, 'Parotid Gland (one Site) - USG', 500),
(57, 'PELVIS (SCREENING) - USG', 550),
(58, 'PELVIS - USG', 700),
(59, 'PERINEUM - USG', 700),
(60, 'PERIUMBILICAL AREA - USG', 400),
(61, 'PORTAL DOPPLER - USG', 1700),
(62, 'PROSTATE - USG', 580),
(63, 'RENAL DOPPLER - USG', 2800),
(64, 'SCAPULA - USG', 900),
(65, 'SCROTUM (BOTH SITE) - USG', 1000),
(66, 'SCROTUM (ONE SITE) - USG', 650),
(67, 'Scrotum doppler', 1200),
(68, 'SHOULDER - USG', 1200),
(69, 'SINGLE LIMB DOPPLER - USG', 3500),
(70, 'SIS (SALINE INFUSION SONOGRAPHY ) - USG', 1300),
(71, 'SMALL AREA - USG', 1100),
(72, 'SOFT TISSUE - USG', 900),
(73, 'Stone Detection - USG', 699),
(74, 'SUB - MENTAL AREA - USG', 900),
(75, 'Sub Clavicular Area - USG', 900),
(76, 'SUPRA CLAVICULAR REGION (ONE SITE)', 500),
(77, 'SUPRA CLAVICULAR REGION - USG', 900),
(78, 'Thigh (one site) - USG', 500),
(79, 'THIGH - USG', 900),
(80, 'THORAX (SCREENING) - USG', 450),
(81, 'THORAX - USG', 650),
(82, 'THYROID - USG', 1000),
(83, 'Trans Vaginal Sonography (screening) - USG', 550),
(84, 'Trans Vaginal Sonography - USG', 700),
(85, 'TVS + NT', 850),
(86, 'TVS NT + NB', 1100),
(87, 'TVS - DOPPLER', 1000),
(88, 'TVS With FCS - USG', 850),
(89, 'Unilateral limb doppler', 2000),
(90, 'Upper Abdomen (Screening) - USG', 550),
(91, 'UPPER ABDOMEN - USG', 700),
(92, 'Upper Limb (Single) - USG', 900),
(93, 'USG Guided', 950),
(94, 'USG Marking for Tapping', 400),
(95, 'WHOLE ABDOMEN ( SCREENING ) - USG', 650),
(96, 'WHOLE ABDOMEN - USG', 1150),
(97, 'WRIST - USG', 1200);

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `username` varchar(50) NOT NULL,
  `password` varchar(255) NOT NULL,
  `role` varchar(20) NOT NULL DEFAULT 'user',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `username`, `password`, `role`, `created_at`) VALUES
(2, 'admin', '$2y$10$HMJS07t1FLqZX.kcLiMswemh7pq8DyvEKrBQy0LTx7lgClmEe14UO', 'admin', '2025-11-19 02:55:10');

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

--
-- Table structure for table `xray`
--

CREATE TABLE `xray` (
  `Slno` int(11) NOT NULL,
  `Investigation` varchar(255) NOT NULL,
  `Walkinprice` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `xray`
--

INSERT INTO `xray` (`Slno`, `Investigation`, `Walkinprice`) VALUES
(1, 'Abdomen AP/LAT - X - Ray', 480),
(2, 'Abdomen ERECT AP X - Ray', 380),
(3, 'Abdomen Supine AP - X - Ray', 380),
(4, 'Ankle Joint AP / LAT X - Ray', 480),
(5, 'Ankle Lat View X - Ray', 380),
(6, 'Ankle Mortice View - X Ray', 380),
(7, 'Ankles AP / LAT(Both) X - Ray', 480),
(8, 'Apicogram X - Ray', 380),
(9, 'ARM AP X-RAY', 380),
(10, 'Arm AP / LAT X - Ray', 480),
(11, 'Barium Enema - Fasting X - Ray', 1800),
(12, 'Barium Swallow Oesophagus X - Ray', 1800),
(13, 'Bariun Follow Through - Fasting X - Ray', 2500),
(14, 'Base Of Skull X - Ray', 380),
(15, 'BIG TOE X - Ray', 350),
(16, 'Both Femur Ap/lat X - Ray', 750),
(17, 'Both Foot AP/LAT X - Ray', 650),
(18, 'Both Knee AP/LAT X - Ray', 650),
(19, 'BOTH Shoulder AP / LAT', 650),
(20, 'Both T.M. Joint X - Ray', 450),
(21, 'Both Wrist AP/LAT X - Ray', 500),
(22, 'Calcaneum X - Ray', 380),
(23, 'Calcaneum Axial View X - Ray', 380),
(24, 'Cervical Flexion & Extension X - Ray', 480),
(25, 'Cervical Spine AP/LAT X - Ray', 480),
(26, 'Cervical Spine Both Oblique X - Ray', 480),
(27, 'Cervical Spine LAT View X - Ray', 380),
(28, 'Cervico Thorasic AP X - RAY', 380),
(29, 'Cervico Thorasic AP/LAT X - RAY', 570),
(30, 'Chest AP X - Ray', 380),
(31, 'Chest AP & LAT X - Ray', 570),
(32, 'Chest LAT View X - Ray', 380),
(33, 'Chest PA & LAT. View X - Ray', 570),
(34, 'Chest PA View X - Ray', 380),
(35, 'Chest Small X - Ray', 350),
(36, 'Clavicle X - Ray', 380),
(37, 'Clavicle AP/Oblique X - Ray', 450),
(38, 'Cocyx -AP / LAT X - Ray', 480),
(39, 'Dorsal Spine AP/LAT X - RAY', 480),
(40, 'Dorso - Lumbar Spine - Lat View X - Ray', 380),
(41, 'Dorso Lumbar Spine AP/LAT X - Ray', 480),
(42, 'Elbow X - Ray', 380),
(43, 'Elbow AP/LAT X - Ray', 480),
(44, 'Face Bone Ap/lat X - RAY', 480),
(45, 'Feet AP/LAT X - Ray', 480),
(46, 'Femur AP X - Ray', 380),
(47, 'Femur AP/LAT X - Ray', 480),
(48, 'Finger AP/LAT X - RAY', 450),
(49, 'Fistulogram X - Ray', 1650),
(50, 'Foot X - Ray', 380),
(51, 'Foot (Both) X - Ray', 450),
(52, 'Foot AP/LAT X - Ray', 450),
(53, 'FOOT AP/OBLIQUE X - RAY', 450),
(54, 'Forearm X - Ray', 380),
(55, 'Forearm AP X - Ray', 350),
(56, 'Forearm AP/LAT X - Ray', 450),
(57, 'Forearms (Both) X - Ray', 450),
(58, 'Hand X - Ray', 380),
(59, 'Hand AP/LAT X - Ray', 450),
(60, 'Heel X - Ray', 380),
(61, 'Heel Lat/axial X - Ray', 450),
(62, 'Heels (Both) X - Ray', 450),
(63, 'Hip AP/LAT X - Ray', 480),
(64, 'Hip Join AP X - Ray', 380),
(65, 'Hip LAT X - Ray', 380),
(66, 'Humerus AP/LAT X - Ray', 450),
(67, 'Hystero - S - Gram (HSG) X - Ray', 2200),
(68, 'IVP X - Ray', 1850),
(69, 'Knee (Both) AP X - Ray', 380),
(70, 'Knee (Skyline View) - X Ray', 380),
(71, 'Knee AP/LAT X - RAY', 450),
(72, 'Knee Joint X - Ray', 380),
(73, 'KUB X - Ray', 380),
(74, 'L.S. Spine AP X - Ray', 380),
(75, 'L.S. Spine AP/LAT X - Ray', 480),
(76, 'L.S. Spine Both Oblique View X - Ray', 480),
(77, 'L.S. Spine Flexion & Extension X - Ray', 480),
(78, 'L.S. Spine Lateral View X - Ray', 380),
(79, 'Leg X - Ray', 380),
(80, 'Leg AP/LAT X - Ray', 480),
(81, 'Mammography', 1600),
(82, 'Mammography, Bilateral Breast', 1950),
(83, 'Mandible X - Ray', 380),
(84, 'Mandible AP/LAT X - Ray', 480),
(85, 'Mandible Both LAT/Oblique X - Ray', 480),
(86, 'Mandible LAT Oblique X - Ray', 450),
(87, 'Mastoid (Laws View) X - Ray', 380),
(88, 'Mastoid Towns View X - Ray', 380),
(89, 'Maxilla Ap View X - Ray', 380),
(90, 'Micturiting Cystourethrogram X - Ray', 1600),
(91, 'Nasal Bone X - Ray', 380),
(92, 'Nasal Bone (Both Lateral) X - Ray', 480),
(93, 'Nasopharynx LAT X - Ray', 380),
(94, 'Orbits AP / LAT View X - Ray', 450),
(95, 'P.N.S Lat. X - Ray', 380),
(96, 'P.N.S OM VIEW - X - RAY', 380),
(97, 'Patella X - Ray', 380),
(98, 'Patella Skyline View X - Ray', 380),
(99, 'Pelvis X - Ray', 380),
(100, 'Pelvis AP / LAT X - Ray', 480),
(101, 'Pelvis Both S.I. Joint X - Ray', 450),
(102, 'PNS X - Ray', 380),
(103, 'Retrograde Urethrogram X - Ray', 1650),
(104, 'S.I. Joint X - Ray', 380),
(105, 'S.I. Joint Both Oblique X - Ray', 570),
(106, 'SACRO ILLAC JOINT AP/Lat X - Ray', 480),
(107, 'Scapula X - Ray', 380),
(108, 'Scapula AP/LAT X - Ray', 480),
(109, 'Sciatic X - Ray', 380),
(110, 'Shoulder X - Ray', 380),
(111, 'Shoulder AP/LAT X - Ray', 480),
(112, 'Sialogram X - Ray', 1600),
(113, 'Skull (LAT) X - Ray', 380),
(114, 'Skull AP / LAT X - Ray', 380),
(115, 'Soft Tissue Neck X - Ray', 380),
(116, 'Soft Tissue Neck AP X - Ray', 380),
(117, 'Soft Tissue Neck AP / Lateral X - Ray', 480),
(118, 'Sternum AP / Lat X - Ray', 480),
(119, 'Sternum Lat X - Ray', 380),
(120, 'Styloid Process X - Ray', 380),
(121, 'T - Tube Cholangiogram X - Ray', 1600),
(122, 'T.M. Joint X - Ray', 380),
(123, 'T.M. Joint Open Mouth & Closed X - Ray', 480),
(124, 'Thigh X - Ray', 480),
(125, 'Thigh (Both) X - Ray', 570),
(126, 'Thigh AP/LAT X - Ray', 480),
(127, 'Thoracis Spine Lateral View X - Ray', 380),
(128, 'Thoraco Lumbar Spine X - Ray', 480),
(129, 'Thoraco Lumber Spine AP View X - Ray', 380),
(130, 'Thumb AP/LAT X - RAY', 380),
(131, 'Urethrocystogram X - Ray', 1600),
(132, 'Wrist Joints AP / LAT X - Ray', 480),
(133, 'Wrists (BOTH) X - Ray', 480),
(134, 'Wrists Joint X - Ray', 380);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `pathology`
--
ALTER TABLE `pathology`
  ADD PRIMARY KEY (`Slno`);

--
-- Indexes for table `radiology`
--
ALTER TABLE `radiology`
  ADD PRIMARY KEY (`Slno`);

--
-- Indexes for table `ultrasound`
--
ALTER TABLE `ultrasound`
  ADD PRIMARY KEY (`Slno`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`);

--
-- Indexes for table `xray`
--
ALTER TABLE `xray`
  ADD PRIMARY KEY (`Slno`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `pathology`
--
ALTER TABLE `pathology`
  MODIFY `Slno` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=398;

--
-- AUTO_INCREMENT for table `radiology`
--
ALTER TABLE `radiology`
  MODIFY `Slno` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=80;

--
-- AUTO_INCREMENT for table `ultrasound`
--
ALTER TABLE `ultrasound`
  MODIFY `Slno` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=98;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `xray`
--
ALTER TABLE `xray`
  MODIFY `Slno` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=135;
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 */;