-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `vyawaharehosp_new`
--

DELIMITER $$
--
-- Procedures
--
CREATE DEFINER=`gssnagpu`@`localhost` PROCEDURE `getIpdPatients` ()   BEGIN 
	SELECT MrdNo,PatientName,IpdNo FROM tbl_dischargecards;
END$$

CREATE DEFINER=`gssnagpu`@`localhost` PROCEDURE `getPatients` ()   BEGIN 
	SELECT 'id','MrdNo','PatientName','Gender','ConsultantName','Age','Fees','Address','City' FROM tbl_patients ORDER BY id DESC LIMIT 1000;
END$$

CREATE DEFINER=`gssnagpu`@`localhost` PROCEDURE `getPatients2` ()   BEGIN 
	SELECT MrdNo,PatientName,ConsultantName,Phone,Address,City FROM tbl_patients;
END$$

DELIMITER ;

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2026_07_07_210000_add_ot_scheduled_approval_workflow', 1),
(2, '2026_07_10_120000_create_tbl_visit_documents', 2);

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

--
-- Table structure for table `tbl_appointments`
--

CREATE TABLE `tbl_appointments` (
  `id` int NOT NULL,
  `MrdNo` int DEFAULT NULL,
  `PatientName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Phone` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Address` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ReferFor` text COLLATE utf8mb4_general_ci,
  `Consultant` text COLLATE utf8mb4_general_ci,
  `AppDate` date DEFAULT NULL,
  `AppTime` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_autoref_master`
--

CREATE TABLE `tbl_autoref_master` (
  `id` bigint UNSIGNED NOT NULL,
  `Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Status` tinyint UNSIGNED NOT NULL DEFAULT '1',
  `CreatedBy` bigint UNSIGNED DEFAULT NULL,
  `ModifiedBy` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_autoref_master`
--

INSERT INTO `tbl_autoref_master` (`id`, `Name`, `Status`, `CreatedBy`, `ModifiedBy`) VALUES
(1, 'A1', 1, 34, NULL),
(2, 'A2', 1, 34, NULL);

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

--
-- Table structure for table `tbl_beds`
--

CREATE TABLE `tbl_beds` (
  `id` int NOT NULL,
  `ConsultantId` int DEFAULT '0',
  `Name` varchar(255) DEFAULT NULL,
  `Status` tinyint(1) DEFAULT '1',
  `Occupy` tinyint(1) DEFAULT '0',
  `CreatedBy` int DEFAULT '0',
  `CreatedDate` date DEFAULT NULL,
  `ModifiedBy` int DEFAULT '0',
  `ModifiedDate` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `tbl_bills`
--

CREATE TABLE `tbl_bills` (
  `id` int NOT NULL,
  `SrNo` int DEFAULT '0',
  `BillNo` varchar(255) DEFAULT NULL,
  `MrdNo` varchar(255) DEFAULT NULL,
  `IpdNo` varchar(255) DEFAULT NULL,
  `PatientName` varchar(255) DEFAULT NULL,
  `AgeGender` varchar(100) DEFAULT NULL,
  `BillDate` date DEFAULT NULL,
  `AdmissionDate` date DEFAULT NULL,
  `OperationDate` date DEFAULT NULL,
  `DischargeDate` date DEFAULT NULL,
  `Consultant` varchar(255) DEFAULT NULL,
  `Diagnosis` text,
  `OtherDetails` text,
  `SurgeryDone` text,
  `InsuranceComp` varchar(255) DEFAULT NULL,
  `TpaCompany` varchar(255) DEFAULT NULL,
  `PolicyNo` varchar(100) DEFAULT NULL,
  `ClainNo` varchar(255) DEFAULT NULL,
  `PackageName` varchar(255) DEFAULT NULL,
  `PackageAmt` float DEFAULT NULL,
  `BalanceAmt` float(14,2) DEFAULT NULL,
  `SubTotal` float(14,2) DEFAULT NULL,
  `Discount` float(14,2) DEFAULT NULL,
  `GrossAmt` float(14,2) DEFAULT NULL,
  `PaidAmt` float(14,2) DEFAULT NULL,
  `BalAmt` float(14,2) DEFAULT NULL,
  `PayMode` varchar(100) DEFAULT NULL,
  `Remarks` text,
  `Narration` text,
  `Status` tinyint(1) DEFAULT '1',
  `CreatedBy` int DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT '0',
  `updated_at` datetime DEFAULT NULL,
  `DiscountStatus` varchar(100) DEFAULT '0',
  `BillType` varchar(255) DEFAULT NULL,
  `SurgeryName` varchar(255) DEFAULT NULL,
  `FinYr` varchar(100) DEFAULT NULL,
  `OtId` int DEFAULT NULL,
  `DscId` int DEFAULT NULL,
  `Roll` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_bills`
--

INSERT INTO `tbl_bills` (`id`, `SrNo`, `BillNo`, `MrdNo`, `IpdNo`, `PatientName`, `AgeGender`, `BillDate`, `AdmissionDate`, `OperationDate`, `DischargeDate`, `Consultant`, `Diagnosis`, `OtherDetails`, `SurgeryDone`, `InsuranceComp`, `TpaCompany`, `PolicyNo`, `ClainNo`, `PackageName`, `PackageAmt`, `BalanceAmt`, `SubTotal`, `Discount`, `GrossAmt`, `PaidAmt`, `BalAmt`, `PayMode`, `Remarks`, `Narration`, `Status`, `CreatedBy`, `created_at`, `ModifiedBy`, `updated_at`, `DiscountStatus`, `BillType`, `SurgeryName`, `FinYr`, `OtId`, `DscId`, `Roll`) VALUES
(1, 1, '1', '1', NULL, 'Mr. Rajat Padmakar Dhanwalkar', '32/Male', '2026-07-08', '2026-07-08', '2026-07-08', '2026-07-08', NULL, NULL, NULL, NULL, 'Company 1', 'TPA', '12345', '134567', NULL, 1000, NULL, NULL, 0.00, NULL, 0.00, NULL, NULL, NULL, NULL, 1, 19, '2026-07-08 23:30:52', 0, '2026-07-08 23:30:52', '0', 'General', NULL, NULL, 14436, 4, 1);

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

--
-- Table structure for table `tbl_bill_charges`
--

CREATE TABLE `tbl_bill_charges` (
  `id` int NOT NULL,
  `BillNo` varchar(255) DEFAULT NULL,
  `MrdNo` int DEFAULT '0',
  `IpdNo` int DEFAULT '0',
  `PackageName` varchar(255) DEFAULT NULL,
  `PackageAmt` float(14,2) DEFAULT NULL,
  `BalanceAmt` float(14,2) DEFAULT NULL,
  `Name` varchar(255) DEFAULT NULL,
  `Days` int DEFAULT '0',
  `Rate` float(14,2) DEFAULT NULL,
  `Amount` float(14,2) DEFAULT NULL,
  `Status` tinyint(1) DEFAULT '1',
  `CreatedBy` int DEFAULT '0',
  `created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_bill_charges`
--

INSERT INTO `tbl_bill_charges` (`id`, `BillNo`, `MrdNo`, `IpdNo`, `PackageName`, `PackageAmt`, `BalanceAmt`, `Name`, `Days`, `Rate`, `Amount`, `Status`, `CreatedBy`, `created_at`) VALUES
(1, '1', 1, NULL, NULL, 1000.00, NULL, 'charges 1', 1, 1000.00, 1000.00, 1, 19, NULL);

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

--
-- Table structure for table `tbl_bill_charges_temp`
--

CREATE TABLE `tbl_bill_charges_temp` (
  `id` int NOT NULL,
  `BillNo` varchar(255) DEFAULT NULL,
  `MrdNo` int DEFAULT '0',
  `IpdNo` int DEFAULT '0',
  `PackageName` varchar(255) DEFAULT NULL,
  `PackageAmt` float(14,2) DEFAULT NULL,
  `BalanceAmt` float(14,2) DEFAULT NULL,
  `Name` varchar(255) DEFAULT NULL,
  `Days` int DEFAULT '0',
  `Rate` float(14,2) DEFAULT NULL,
  `Amount` float(14,2) DEFAULT NULL,
  `Status` tinyint(1) DEFAULT '1',
  `CreatedBy` int DEFAULT '0',
  `created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `tbl_brochures`
--

CREATE TABLE `tbl_brochures` (
  `id` int NOT NULL,
  `Name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `File` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Url` text COLLATE utf8mb4_general_ci,
  `Status` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_brochures`
--

INSERT INTO `tbl_brochures` (`id`, `Name`, `File`, `Url`, `Status`) VALUES
(1, 'KANCHBINDU', 'KANCHBINDU.pdf', 'https://smswaapi.in/inc/core/File_manager/KANCHBINDU.pdf', 1),
(2, 'COMPUTER_SYNDROME', 'COMPUTER_SYNDROME.pdf', 'https://digimarks.co.in/pdf/COMPUTER%20SYNDROME%20.pdf', 1),
(3, 'AMD', 'AMD.pdf', 'https://smswaapi.in/assets/uploads/905d0ddb400f26f63f6cec36af95b367/d21ccf36125b2714bbb29ff2243dcdb3.pdf', 0),
(4, 'LASIK', 'LASIK.pdf', 'https://smswaapi.in/assets/uploads/905d0ddb400f26f63f6cec36af95b367/036bbd805ac1c9256f665b54da801e30.pdf', 0),
(5, 'DRUSHTIDOSH & CHASHMA', 'DRUSHTIDOSH & CHASHMA.pdf', 'https://smswaapi.in/inc/core/File_manager/DRUSHTIDOSH.pdf', 1),
(6, 'MEMOBITES', 'MEMOBITES.pdf', 'https://smswaapi.in/inc/core/File_manager/MEMOBITES.pdf', 1),
(7, 'MOTIBINDU', 'MOTIBINDU.pdf', 'https://smswaapi.in/inc/core/File_manager/MOTIBINDU.pdf', 1),
(8, 'ANKHOKI_ALARGY', 'ANKHOKI_ALARGY.pdf', 'https://digimarks.co.in/pdf/ANKHOKI%20ALARGY.pdf', 1),
(9, 'MIGRANE', 'MIGRANE.pdf', 'https://smswaapi.in/inc/core/File_manager/MIGRANE.pdf', 1);

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

--
-- Table structure for table `tbl_charges`
--

CREATE TABLE `tbl_charges` (
  `id` int NOT NULL,
  `PackageName` varchar(255) DEFAULT NULL,
  `PackageAmt` float(14,2) DEFAULT NULL,
  `BalanceAmt` float(14,2) DEFAULT NULL,
  `Name` varchar(255) DEFAULT NULL,
  `Days` int DEFAULT '0',
  `Rate` float(14,2) DEFAULT NULL,
  `Amount` float(14,2) DEFAULT NULL,
  `Status` tinyint(1) DEFAULT '1',
  `CreatedBy` int DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT '0',
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `tbl_codepresc`
--

CREATE TABLE `tbl_codepresc` (
  `id` int NOT NULL,
  `Code` varchar(255) DEFAULT NULL,
  `Marathi` text,
  `Hindi` text,
  `English` text,
  `Type` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_codepresc`
--

INSERT INTO `tbl_codepresc` (`id`, `Code`, `Marathi`, `Hindi`, `English`, `Type`) VALUES
(1, 'RE', 'f@t ]javyaa DaoL`yaat                                                                                                                                                                                                                                                                                       ', 'isaf- daihnaI AaMKmao                                                                                                                                                                                                                                                                                       ', 'ONLY RIGHT EYE                                                                                                                                                                                                                                                                                              ', 'EYE                                                                                                 '),
(2, 'T.D.S.                                            ', 'raoja idvasaatUna 3 vaoLa                                                                                                                                                                                                                                                                                   ', 'raoja idna maoM 3 baar                                                                                                                                                                                                                                                                                      ', 'DAILY 3 TIMES IN A DAY                                                                                                                                                                                                                                                                                      ', 'TIME                                                                                                '),
(3, '1 HRLY.                                           ', 'raoja 1 tasaanaMtr                                                                                                                                                                                                                                                                                          ', 'raoja 1 GaMTo ko baad                                                                                                                                                                                                                                                                                       ', 'DAILY 1-1 HOUR AFTER                                                                                                                                                                                                                                                                                        ', 'TIME                                                                                                '),
(4, '4 HRLY.                                           ', 'raoja 4 tasaanaMtr                                                                                                                                                                                                                                                                                          ', 'raoja 4 GaMTo ko baad                                                                                                                                                                                                                                                                                       ', 'DAILY 4-4 HOURS AFTER                                                                                                                                                                                                                                                                                       ', 'TIME                                                                                                '),
(5, 'TAB                                               ', 'gaaoLI                                                                                                                                                                                                                                                                                                      ', 'gaaolaI                                                                                                                                                                                                                                                                                                     ', 'TAB.                                                                                                                                                                                                                                                                                                        ', 'CAT                                                                                                 '),
(6, 'LOTION                                            ', 'laaoSana                                                                                                                                                                                                                                                                                                    ', 'laaoSana                                                                                                                                                                                                                                                                                                    ', 'LOTION                                                                                                                                                                                                                                                                                                      ', 'CAT                                                                                                 '),
(7, 'X 2 DAYS', '×  2 idvasa                                                                                                                                                                                                                                                                                                 ', '?  2 idna                                                                                                                                                                                                                                                                                                   ', 'X  2 DAYS                                                                                                                                                                                                                                                                                                   ', 'DAY                                                                                                 '),
(8, 'X 5 DAYS', '×  5 idvasa                                                                                                                                                                                                                                                                                                 ', '×  5 idna                                                                                                                                                                                                                                                                                                   ', 'X  5 DAYS                                                                                                                                                                                                                                                                                                   ', 'DAY                                                                                                 '),
(9, 'X 10 DAYS', '×  10 idvasa                                                                                                                                                                                                                                                                                                ', '×  10 idna                                                                                                                                                                                                                                                                                                  ', 'X  10 DAYS                                                                                                                                                                                                                                                                                                  ', 'DAY                                                                                                 '),
(10, 'X 30 DAYS', '×  30 idvasa                                                                                                                                                                                                                                                                                                ', '×  30 idna                                                                                                                                                                                                                                                                                                  ', 'X  30 DAYS                                                                                                                                                                                                                                                                                                  ', 'DAY                                                                                                 '),
(11, 'X 2 MONTHS', '×  2 maihnao                                                                                                                                                                                                                                                                                                ', '×  2 maihnao                                                                                                                                                                                                                                                                                                ', 'X  2 MONTHS                                                                                                                                                                                                                                                                                                 ', 'DAY                                                                                                 '),
(12, 'X 5 MONTHS', '×  5 maihnao                                                                                                                                                                                                                                                                                                ', '×  5 maihnao                                                                                                                                                                                                                                                                                                ', 'X  5 MONTHS                                                                                                                                                                                                                                                                                                 ', 'DAY                                                                                                 '),
(13, 'MONDAY                                            ', 'saaomavaar                                                                                                                                                                                                                                                                                                  ', 'saaomavaar                                                                                                                                                                                                                                                                                                  ', 'MONDAY                                                                                                                                                                                                                                                                                                      ', 'DNAME                                                                                               '),
(14, 'THURSDAY                                          ', 'gau$vaar                                                                                                                                                                                                                                                                                                    ', 'gau$vaar                                                                                                                                                                                                                                                                                                    ', 'THURSDAY                                                                                                                                                                                                                                                                                                    ', 'DNAME                                                                                               '),
(15, 'SUNDAY                                            ', 'rivavaar                                                                                                                                                                                                                                                                                                    ', 'Sainavaar                                                                                                                                                                                                                                                                                                   ', 'SUNDAY                                                                                                                                                                                                                                                                                                      ', 'DNAME                                                                                               '),
(16, 'BE', 'daonhI DaoL`yaat                                                                                                                                                                                                                                                                                            ', 'daonaao AaMKaoMmao                                                                                                                                                                                                                                                                                          ', 'FOR BOTH EYES                                                                                                                                                                                                                                                                                               ', 'EYE                                                                                                 '),
(17, 'AfterMeal                                         ', 'jaovaNaa naMtr                                                                                                                                                                                                                                                                                              ', 'Kanao ko baad                                                                                                                                                                                                                                                                                               ', 'AfterMeal                                                                                                                                                                                                                                                                                                   ', '                                                                                                    '),
(18, '1.5TSP                                            ', '                                                                                                                                                                                                                                                                                                            ', '                                                                                                                                                                                                                                                                                                            ', '                                                                                                                                                                                                                                                                                                            ', '                                                                                                    '),
(19, 'EmptyStomach                                      ', '}paSI paoTI                                                                                                                                                                                                                                                                                                 ', 'KalaI poT                                                                                                                                                                                                                                                                                                   ', 'EmptyStomach                                                                                                                                                                                                                                                                                                ', '                                                                                                    '),
(20, 'AfterHeadache                                     ', 'Daoko du#alyaasa                                                                                                                                                                                                                                                                                            ', 'sardd haonoa pr                                                                                                                                                                                                                                                                                             ', 'AfterHeadache                                                                                                                                                                                                                                                                                               ', '                                                                                                    '),
(21, '1.5TSP                                            ', '1.5 camacaa                                                                                                                                                                                                                                                                                                 ', '1.5 camacaa                                                                                                                                                                                                                                                                                                 ', '1.5 SPOON                                                                                                                                                                                                                                                                                                   ', 'DOS                                                                                                 '),
(22, 'ToEyeLidsCorner                                   ', 'DaoLyaacyaa papNaIcyaa kDo laa                                                                                                                                                                                                                                                                              ', 'DaoLyaacyaa papNaIcyaa kDo laa                                                                                                                                                                                                                                                                              ', 'ToEyeLidsCorner                                                                                                                                                                                                                                                                                             ', '                                                                                                    '),
(23, 'Cold                                              ', ' barfanI PaapNyaanaa SIknI                                                                                                                                                                                                                                                                                  ', 'barf ko paNaI sao saoknaa                                                                                                                                                                                                                                                                                   ', 'COLD WATER MASSAGE                                                                                                                                                                                                                                                                                          ', '                                                                                                    '),
(24, 'OnceaWeek                                         ', 'AazvaDyaatUna ekda                                                                                                                                                                                                                                                                                          ', 'hfto mao ek baar                                                                                                                                                                                                                                                                                            ', 'OnceaWeek                                                                                                                                                                                                                                                                                                   ', '                                                                                                    '),
(25, '0.5 ML                                            ', '0.5 ima.ila                                                                                                                                                                                                                                                                                                 ', '0.5 ima.ila                                                                                                                                                                                                                                                                                                 ', '0.5 ML                                                                                                                                                                                                                                                                                                      ', 'DOS                                                                                                 '),
(26, 'AtNight                                           ', 'raHaI                                                                                                                                                                                                                                                                                                       ', 'ratkao                                                                                                                                                                                                                                                                                                      ', 'AtNight                                                                                                                                                                                                                                                                                                     ', '                                                                                                    '),
(27, '01-Feb', 'AQaI                                                                                                                                                                                                                                                                                                        ', 'AaQaI                                                                                                                                                                                                                                                                                                       ', '1/2                                                                                                                                                                                                                                                                                                         ', 'DOS                                                                                                 '),
(28, 'AfterBreakfast                                    ', 'naastyaa naMtr                                                                                                                                                                                                                                                                                              ', 'naasto ko baad                                                                                                                                                                                                                                                                                              ', 'AfterBreakfast                                                                                                                                                                                                                                                                                              ', '                                                                                                    '),
(29, '0.5 ML                                            ', '0.5 ima.ila                                                                                                                                                                                                                                                                                                 ', '0.5 ima.ila                                                                                                                                                                                                                                                                                                 ', '0.5 ML                                                                                                                                                                                                                                                                                                      ', 'DOS                                                                                                 '),
(30, 'F.I.D.                                            ', 'raoja idvasaatUna 5 vaoLa                                                                                                                                                                                                                                                                                   ', 'raoja idna maoM 5 baar                                                                                                                                                                                                                                                                                      ', '5 Times a Day                                                                                                                                                                                                                                                                                               ', 'TIME                                                                                                '),
(31, '1 ML                                              ', '1 ima.ila                                                                                                                                                                                                                                                                                                   ', '1 ima.ila                                                                                                                                                                                                                                                                                                   ', '1 ML                                                                                                                                                                                                                                                                                                        ', 'DOS                                                                                                 '),
(32, '10 MG                                             ', '10 ,ima.g`aama                                                                                                                                                                                                                                                                                              ', '10 ,ima.g`aama                                                                                                                                                                                                                                                                                              ', '10 MG                                                                                                                                                                                                                                                                                                       ', 'DOS                                                                                                 '),
(33, '1.5 ML                                            ', '1.5 ima.ila                                                                                                                                                                                                                                                                                                 ', '1.5 ima.ila                                                                                                                                                                                                                                                                                                 ', '1.5 ML                                                                                                                                                                                                                                                                                                      ', 'DOS                                                                                                 '),
(34, 'Stem                                              ', 'ivksa caa vaafara naakatuna dyaavaa                                                                                                                                                                                                                                                                         ', '                                                                                                                                                                                                                                                                                                            ', '                                                                                                                                                                                                                                                                                                            ', '                                                                                                    '),
(35, '2 ML                                              ', '2 ima.ila                                                                                                                                                                                                                                                                                                   ', '2 ima.ila                                                                                                                                                                                                                                                                                                   ', '2 ML                                                                                                                                                                                                                                                                                                        ', 'DOS                                                                                                 '),
(36, '20 MG                                             ', '20 ,ima.g`aama                                                                                                                                                                                                                                                                                              ', '20 ,ima.g`aama                                                                                                                                                                                                                                                                                              ', '20 MG                                                                                                                                                                                                                                                                                                       ', 'DOS                                                                                                 '),
(37, '2.5 ML                                            ', '2.5 ima.ila                                                                                                                                                                                                                                                                                                 ', '2.5 ima.ila                                                                                                                                                                                                                                                                                                 ', '2.5 ML                                                                                                                                                                                                                                                                                                      ', 'DOS                                                                                                 '),
(38, 'TO CONTINUE                                       ', 'sau$ zovaNao                                                                                                                                                                                                                                                                                                ', 'SaU$ rKnaa                                                                                                                                                                                                                                                                                                  ', '                                                                                                                                                                                                                                                                           CONTINUE                         ', '                                                                                                    '),
(39, '30 MG                                             ', '30 ,ima.g`aama                                                                                                                                                                                                                                                                                              ', '30 ,ima.g`aama                                                                                                                                                                                                                                                                                              ', '30 MG                                                                                                                                                                                                                                                                                                       ', 'DOS                                                                                                 '),
(40, 'X.I.D.                                            ', 'raoja idvasaatUna 6 vaoLa                                                                                                                                                                                                                                                                                   ', 'raoja idna maoM 6 baar                                                                                                                                                                                                                                                                                      ', '6 TIMES A DAY                                                                                                                                                                                                                                                                                               ', 'TIME                                                                                                '),
(41, '40 MG                                             ', '40 ,ima.g`aama                                                                                                                                                                                                                                                                                              ', '40 ,ima.g`aama                                                                                                                                                                                                                                                                                              ', '40 MG                                                                                                                                                                                                                                                                                                       ', 'DOS                                                                                                 '),
(42, 'SYRUP                                             ', 'isarp                                                                                                                                                                                                                                                                                                       ', 'ipnao kI dvaa                                                                                                                                                                                                                                                                                               ', 'SYRUP                                                                                                                                                                                                                                                                                                       ', 'CAT                                                                                                 '),
(43, '50 MG                                             ', '50 ,ima.g`aama                                                                                                                                                                                                                                                                                              ', '50 ,ima.g`aama                                                                                                                                                                                                                                                                                              ', '50 MG                                                                                                                                                                                                                                                                                                       ', 'DOS                                                                                                 '),
(44, 'X  1 DAY                                          ', '×  1 idvasa                                                                                                                                                                                                                                                                                                 ', '×  1 idna                                                                                                                                                                                                                                                                                                   ', 'X  1 DAY                                                                                                                                                                                                                                                                                                    ', 'DAY                                                                                                 '),
(45, '60 MG                                             ', '60 ,ima.g`aama                                                                                                                                                                                                                                                                                              ', '60 ,ima.g`aama                                                                                                                                                                                                                                                                                              ', '60 MG                                                                                                                                                                                                                                                                                                       ', 'DOS                                                                                                 '),
(46, 'X 3 DAYS', '×  3 idvasa                                                                                                                                                                                                                                                                                                 ', '×  3 idna                                                                                                                                                                                                                                                                                                   ', 'X 3 DAYS                                                                                                                                                                                                                                                                                                    ', 'DAY                                                                                                 ');
INSERT INTO `tbl_codepresc` (`id`, `Code`, `Marathi`, `Hindi`, `English`, `Type`) VALUES
(47, 'X 4 DAYS', '×  4 idvasa                                                                                                                                                                                                                                                                                                 ', '×  4 idna                                                                                                                                                                                                                                                                                                   ', 'X  4 DAYS                                                                                                                                                                                                                                                                                                   ', 'DAY                                                                                                 '),
(48, 'X 6 DAYS', '×  6 idvasa                                                                                                                                                                                                                                                                                                 ', '×  6 idna                                                                                                                                                                                                                                                                                                   ', 'X  6 DAYS                                                                                                                                                                                                                                                                                                   ', 'DAY                                                                                                 '),
(49, 'X 7 DAYS', '×  7 idvasa', '×  7 idna                                                                                                                                                                                                                                                                                                   ', 'X  7 DAYS                                                                                                                                                                                                                                                                                                   ', 'DAY                                                                                                 '),
(50, 'X 15 DAYS', '×  15 idvasa                                                                                                                                                                                                                                                                                                ', '×  15 idna                                                                                                                                                                                                                                                                                                  ', 'X  15 DAYS                                                                                                                                                                                                                                                                                                  ', 'DAY                                                                                                 '),
(51, 'X 20 DAYS', '×  20 idvasa                                                                                                                                                                                                                                                                                                ', '×  20 idna                                                                                                                                                                                                                                                                                                  ', 'X  20 DAYS                                                                                                                                                                                                                                                                                                  ', 'DAY                                                                                                 '),
(52, 'X 45 DAYS', '×  45 idvasa                                                                                                                                                                                                                                                                                                ', '×  45 idna                                                                                                                                                                                                                                                                                                  ', 'X  45 DAYS                                                                                                                                                                                                                                                                                                  ', 'DAY                                                                                                 '),
(53, 'X 1 MONTH', '×  1 maihnaa                                                                                                                                                                                                                                                                                                ', '×  1 maihnaa                                                                                                                                                                                                                                                                                                ', 'X  1 MONTH                                                                                                                                                                                                                                                                                                  ', 'DAY                                                                                                 '),
(54, 'X 3 MONTHS', '×  3 maihnao                                                                                                                                                                                                                                                                                                ', '×  3 maihnao                                                                                                                                                                                                                                                                                                ', 'X  3 MONTHS                                                                                                                                                                                                                                                                                                 ', 'DAY                                                                                                 '),
(55, 'X 4 MONTHS', ' x  4 maihnao                                                                                                                                                                                                                                                                                               ', '?  4 maihnao                                                                                                                                                                                                                                                                                                ', 'X  4 MONTHS                                                                                                                                                                                                                                                                                                 ', 'DAY                                                                                                 '),
(56, 'X 6 MONTHS', '×  6 maihnao                                                                                                                                                                                                                                                                                                ', '×  6 maihnao                                                                                                                                                                                                                                                                                                ', 'X  6 MONTHS                                                                                                                                                                                                                                                                                                 ', 'DAY                                                                                                 '),
(57, 'X  1 YEAR                                         ', '×  1 vaYa-                                                                                                                                                                                                                                                                                                  ', '×  1 saala                                                                                                                                                                                                                                                                                                  ', 'X  1 YEAR                                                                                                                                                                                                                                                                                                   ', 'DAY                                                                                                 '),
(58, 'TUESDAY                                           ', 'maMgaLvaar                                                                                                                                                                                                                                                                                                  ', 'maMgaLvaar                                                                                                                                                                                                                                                                                                  ', 'TUESDAY                                                                                                                                                                                                                                                                                                     ', 'DNAME                                                                                               '),
(59, 'WEDNESDAY                                         ', 'bauQavaar                                                                                                                                                                                                                                                                                                   ', 'bauQavaar                                                                                                                                                                                                                                                                                                   ', 'WEDNESDAY                                                                                                                                                                                                                                                                                                   ', 'DNAME                                                                                               '),
(60, 'FRIDAY                                            ', 'Sau?vaar                                                                                                                                                                                                                                                                                                    ', 'Sau?vaar                                                                                                                                                                                                                                                                                                    ', 'FRIDAY                                                                                                                                                                                                                                                                                                      ', 'DNAME                                                                                               '),
(61, 'SATURDAY                                          ', 'Sainavaar                                                                                                                                                                                                                                                                                                   ', 'Sainavaar                                                                                                                                                                                                                                                                                                   ', 'SATURDAY                                                                                                                                                                                                                                                                                                    ', 'DNAME                                                                                               '),
(62, '43160', '1?3                                                                                                                                                                                                                                                                                                         ', '1?3                                                                                                                                                                                                                                                                                                         ', '01-Mar                                                                                                                                                                                                                                                                                                      ', 'DOS                                                                                                 '),
(63, '43191', '1?4                                                                                                                                                                                                                                                                                                         ', '1?4                                                                                                                                                                                                                                                                                                         ', '01-Apr                                                                                                                                                                                                                                                                                                      ', 'DOS                                                                                                 '),
(64, 'O.D.                                              ', 'raoja idvasaatUna 1 vaoLa                                                                                                                                                                                                                                                                                   ', 'raoja idna maoM 1 baar                                                                                                                                                                                                                                                                                      ', 'DAILY 1 TIME  IN A DAY                                                                                                                                                                                                                                                                                      ', 'TIME                                                                                                '),
(65, 'B.D.', 'raoja idvasaatUna 2 vaoLa                                                                                                                                                                                                                                                                                   ', 'raoja idna maoM 2 baar                                                                                                                                                                                                                                                                                      ', 'DAILY 2 TIMES  IN A DAY                                                                                                                                                                                                                                                                                     ', 'TIME                                                                                                '),
(66, 'Q.I.D.                                            ', 'raoja idvasaatUna 4 vaoLa                                                                                                                                                                                                                                                                                   ', 'raoja idna maoM 4 baar                                                                                                                                                                                                                                                                                      ', 'DAILY 4 TIMES IN A DAY                                                                                                                                                                                                                                                                                      ', 'TIME                                                                                                '),
(67, 'H.S.                                              ', 'raoja JaaopNyaapUvaI- 1 tasa Agaaodr                                                                                                                                                                                                                                                                        ', 'raoja saaonao ko 1 GaToM phlao                                                                                                                                                                                                                                                                              ', 'DAILY 1 HOUR BEFORE SLEEP                                                                                                                                                                                                                                                                                   ', 'TIME                                                                                                '),
(68, '1', '1                                                                                                                                                                                                                                                                                                           ', '1                                                                                                                                                                                                                                                                                                           ', '1                                                                                                                                                                                                                                                                                                           ', 'DOS                                                                                                 '),
(69, '2', '2                                                                                                                                                                                                                                                                                                           ', '2                                                                                                                                                                                                                                                                                                           ', '2                                                                                                                                                                                                                                                                                                           ', 'DOS                                                                                                 '),
(70, 'NEXT VISIT                                        ', 'for tpasaNaI                                                                                                                                                                                                                                                                                                ', 'AgalaI jaa^Mca                                                                                                                                                                                                                                                                                              ', 'NEXT VISIT                                                                                                                                                                                                                                                                                                  ', 'DT                                                                                                  '),
(71, 'LE', 'f@t Davyaa DaoL`yaat                                                                                                                                                                                                                                                                                        ', 'isaf- baayaI AaMKmao                                                                                                                                                                                                                                                                                        ', 'ONLY LEFT EYE                                                                                                                                                                                                                                                                                               ', 'EYE                                                                                                 '),
(72, '2 HRLY.                                           ', 'raoja 2 tasaanaMtr                                                                                                                                                                                                                                                                                          ', 'raoja 2 GaMTo ko baad                                                                                                                                                                                                                                                                                       ', 'DAILY 2-2 HOURS AFTER                                                                                                                                                                                                                                                                                       ', 'TIME                                                                                                '),
(73, '3 HRLY.                                           ', 'raoja 3 tasaanaMtr                                                                                                                                                                                                                                                                                          ', 'raoja 3 GaMTo ko baad                                                                                                                                                                                                                                                                                       ', 'DAILY 3-3 HOURS AFTER                                                                                                                                                                                                                                                                                       ', 'TIME                                                                                                '),
(74, '? HRLY.                                           ', 'raoja AQyaa- tasaanaMtr                                                                                                                                                                                                                                                                                     ', 'raoja AaQao GaMTo ko baad                                                                                                                                                                                                                                                                                   ', 'DAILY ? - ?  HOUR AFTER                                                                                                                                                                                                                                                                                     ', 'TIME                                                                                                '),
(75, 'CAP', 'k^PsaUla                                                                                                                                                                                                                                                                                                    ', 'k^PsaUla                                                                                                                                                                                                                                                                                                    ', 'CAPSULE                                                                                                                                                                                                                                                                                                     ', 'CAT                                                                                                 '),
(76, 'SOS', 'garja Baasalyaasa                                                                                                                                                                                                                                                                                           ', 'ja$rt pDn?pr                                                                                                                                                                                                                                                                                                ', 'If Needed                                                                                                                                                                                                                                                                                                   ', 'TIME                                                                                                '),
(77, 'Hot                                               ', 'kaomaT PaaNyaacyaa kpDyaanI PaapNyaanaa SIknI                                                                                                                                                                                                                                                               ', 'gauNa gauNao PaaNaI sao saoknaa                                                                                                                                                                                                                                                                             ', 'MASSAGE WITH LUKE WARM WATER                                                                                                                                                                                                                                                                                ', '                                                                                                    '),
(78, 'DROP', 'qaoMba', 'D/a^p                                                                                                                                                                                                                                                                                                       ', 'DROP                                                                                                                                                                                                                                                                                                        ', 'CAT                                                                                                 '),
(79, 'OINT                                              ', 'malama                                                                                                                                                                                                                                                                                                      ', 'malama                                                                                                                                                                                                                                                                                                      ', 'OINTMENT                                                                                                                                                                                                                                                                                                    ', 'CAT                                                                                                 '),
(80, '100 MG                                            ', '100 ,ima.g`aama                                                                                                                                                                                                                                                                                             ', '100 ,ima.g`aama                                                                                                                                                                                                                                                                                             ', '100 MG                                                                                                                                                                                                                                                                                                      ', 'DOS                                                                                                 '),
(81, '150 MG                                            ', '150 ,ima.g`aama                                                                                                                                                                                                                                                                                             ', '150 ,ima.g`aama                                                                                                                                                                                                                                                                                             ', '150 MG                                                                                                                                                                                                                                                                                                      ', 'DOS                                                                                                 '),
(82, '250 MG                                            ', '250 ,ima.g`aama                                                                                                                                                                                                                                                                                             ', '250 ,ima.g`aama                                                                                                                                                                                                                                                                                             ', '250 MG                                                                                                                                                                                                                                                                                                      ', 'DOS                                                                                                 '),
(83, '500 MG                                            ', '500 ,ima.g`aama                                                                                                                                                                                                                                                                                             ', '500 ,ima.g`aama                                                                                                                                                                                                                                                                                             ', '500 MG                                                                                                                                                                                                                                                                                                      ', 'DOS                                                                                                 '),
(84, 'AT NIGHT.                                         ', 'ra~aI                                                                                                                                                                                                                                                                                                       ', 'rat kao                                                                                                                                                                                                                                                                                                     ', 'AT NIGHT                                                                                                                                                                                                                                                                                                    ', 'TIME                                                                                                '),
(85, '1TSP                                              ', '1 camacaa                                                                                                                                                                                                                                                                                                   ', '1 cammaca                                                                                                                                                                                                                                                                                                   ', '1 SPOON                                                                                                                                                                                                                                                                                                     ', 'DOS                                                                                                 '),
(86, '1/2TSP                                            ', 'AQaa- camacaa                                                                                                                                                                                                                                                                                               ', 'AaQaa cammaca                                                                                                                                                                                                                                                                                               ', '1/2 SPOON                                                                                                                                                                                                                                                                                                   ', 'DOS                                                                                                 '),
(87, '2TSP                                              ', '2 camacao                                                                                                                                                                                                                                                                                                   ', '2 cammaca                                                                                                                                                                                                                                                                                                   ', '2 SPOON                                                                                                                                                                                                                                                                                                     ', 'DOS                                                                                                 '),
(88, '2.5ML                                             ', '2.5 ima.ila                                                                                                                                                                                                                                                                                                 ', '2.5 ima.ila                                                                                                                                                                                                                                                                                                 ', '2.5 ML                                                                                                                                                                                                                                                                                                      ', 'DOS                                                                                                 '),
(89, '5ML                                               ', '5 ima.ila                                                                                                                                                                                                                                                                                                   ', '5 ima.ila                                                                                                                                                                                                                                                                                                   ', '5 ML                                                                                                                                                                                                                                                                                                        ', 'DOS                                                                                                 '),
(90, '3 ML                                              ', '3 ima.ila                                                                                                                                                                                                                                                                                                   ', '3 ima.ila                                                                                                                                                                                                                                                                                                   ', '3 ML                                                                                                                                                                                                                                                                                                        ', 'DOS                                                                                                 '),
(91, '3.5 ML                                            ', '3.5 ima.ila                                                                                                                                                                                                                                                                                                 ', '3.5 ima.ila                                                                                                                                                                                                                                                                                                 ', '3.5 ML                                                                                                                                                                                                                                                                                                      ', 'DOS                                                                                                 '),
(92, '4 ML                                              ', '4 ima.ila                                                                                                                                                                                                                                                                                                   ', '4 ima.ila                                                                                                                                                                                                                                                                                                   ', '4 ML                                                                                                                                                                                                                                                                                                        ', 'DOS                                                                                                 '),
(93, '4.5 ML                                            ', '4.5 ima.ila                                                                                                                                                                                                                                                                                                 ', '4.5 ima.ila                                                                                                                                                                                                                                                                                                 ', '4.5 ML                                                                                                                                                                                                                                                                                                      ', 'DOS                                                                                                 ');
INSERT INTO `tbl_codepresc` (`id`, `Code`, `Marathi`, `Hindi`, `English`, `Type`) VALUES
(94, '5 ML                                              ', '5 ima.ila                                                                                                                                                                                                                                                                                                   ', '5 ima.ila                                                                                                                                                                                                                                                                                                   ', '5 ML                                                                                                                                                                                                                                                                                                        ', 'DOS                                                                                                 '),
(95, '5.5 ML                                            ', '5.5 ima.ila                                                                                                                                                                                                                                                                                                 ', '5.5 ima.ila                                                                                                                                                                                                                                                                                                 ', '5.5 ML                                                                                                                                                                                                                                                                                                      ', 'DOS                                                                                                 '),
(96, '6 ML                                              ', '6 ima.ila                                                                                                                                                                                                                                                                                                   ', '6 ima.ila                                                                                                                                                                                                                                                                                                   ', '6 ML                                                                                                                                                                                                                                                                                                        ', 'DOS                                                                                                 '),
(97, '6.5 ML                                            ', '6.5 ima.ila                                                                                                                                                                                                                                                                                                 ', '6.5 ima.ila                                                                                                                                                                                                                                                                                                 ', '6.5 ML                                                                                                                                                                                                                                                                                                      ', 'DOS                                                                                                 '),
(98, '7 ML                                              ', '7 ima.ila                                                                                                                                                                                                                                                                                                   ', '7 ima.ila                                                                                                                                                                                                                                                                                                   ', '7 ML                                                                                                                                                                                                                                                                                                        ', 'DOS                                                                                                 '),
(99, '7.5 ML                                            ', '7.5 ima.ila                                                                                                                                                                                                                                                                                                 ', '7.5 ima.ila                                                                                                                                                                                                                                                                                                 ', '7.5 ML                                                                                                                                                                                                                                                                                                      ', 'DOS                                                                                                 '),
(100, '8 ML                                              ', '8 ima.ila                                                                                                                                                                                                                                                                                                   ', '8 ima.ila                                                                                                                                                                                                                                                                                                   ', '8 ML                                                                                                                                                                                                                                                                                                        ', 'DOS                                                                                                 '),
(101, '8.5 ML                                            ', '8.5 ima.ila                                                                                                                                                                                                                                                                                                 ', '8.5 ima.ila                                                                                                                                                                                                                                                                                                 ', '8.5 ML                                                                                                                                                                                                                                                                                                      ', 'DOS                                                                                                 '),
(102, '9 ML                                              ', '9 ima.ila                                                                                                                                                                                                                                                                                                   ', '9 ima.ila                                                                                                                                                                                                                                                                                                   ', '9 ML                                                                                                                                                                                                                                                                                                        ', 'DOS                                                                                                 '),
(103, '9.5 ML                                            ', '9.5 ima.ila                                                                                                                                                                                                                                                                                                 ', '9.5 ima.ila                                                                                                                                                                                                                                                                                                 ', '9.5 ML                                                                                                                                                                                                                                                                                                      ', 'DOS                                                                                                 '),
(104, '10 ML                                             ', '10 ima.ila                                                                                                                                                                                                                                                                                                  ', '10 ima.ila                                                                                                                                                                                                                                                                                                  ', '10 ML                                                                                                                                                                                                                                                                                                       ', 'DOS                                                                                                 '),
(105, '8 TAP', '8 vaoLa', '8 baar', '8 TIME IN A DAY', NULL),
(106, '6 TAP', '6 vaoLa', '6 baar', '6 TIME IN A DAY', NULL),
(107, '4 TAP', '4 vaoLa', '4 baar', '4 TIME IN A DAY', NULL),
(108, '3 TAP', '3 vaoLa', '3 baar', '3 TIME IN A DAY', NULL),
(109, '2 TAP', '2 vaoLa', '2 baar', '2 TIME IN A DAY', NULL),
(110, '1 TAP', '1 vaoLa', '1 baar', '1 TIME IN A DAY', NULL),
(111, 'X  5 DAYS', '×  5 idvasa                                                                                                                                                                                                                                                                                                 ', '×  5 idna                                                                                                                                                                                                                                                                                                   ', 'X  5 DAYS                                                                                                                                                                                                                                                                                                   ', 'DAY                                                                                                 '),
(112, 'X  10 DAYS', '×  10 idvasa                                                                                                                                                                                                                                                                                                ', '×  10 idna                                                                                                                                                                                                                                                                                                  ', 'X  10 DAYS                                                                                                                                                                                                                                                                                                  ', 'DAY                                                                                                 '),
(113, 'TILL NEXT VISIT ', 'PauZcyaa ivaisaT Paya-Mt', 'AgalaI jaa^Mca                                                                                                                                                                                                                                                                                              ', 'TILL NEXT VISIT ', 'DT                                                                                                  '),
(114, 'ToContinue', 'puZcyaa tpasaNaI pya---t sauÉ zovaNao', NULL, NULL, NULL);

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

--
-- Table structure for table `tbl_comp_days`
--

CREATE TABLE `tbl_comp_days` (
  `id` int NOT NULL,
  `Name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `tbl_comp_days`
--

INSERT INTO `tbl_comp_days` (`id`, `Name`) VALUES
(1, 'Since 3 Days'),
(2, 'Since 7 Days'),
(3, 'Since 15 Days'),
(4, 'Since 21 Days'),
(5, 'Since 1 Month'),
(6, 'Since 3 Month'),
(7, 'Since 6 Month'),
(8, 'Since 9 Month'),
(9, 'Since 1 Year'),
(10, 'Since 3 Year'),
(11, 'Since 7 Year'),
(12, 'Since 10 Year');

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

--
-- Table structure for table `tbl_consultants`
--

CREATE TABLE `tbl_consultants` (
  `id` bigint NOT NULL,
  `MrdNo` varchar(100) DEFAULT NULL,
  `VisitNo` int DEFAULT '0',
  `VisitDate` date DEFAULT NULL,
  `PatientName` varchar(255) DEFAULT NULL,
  `ChkReNormal` varchar(10) DEFAULT '0',
  `ChkLeNormal` varchar(10) DEFAULT '0',
  `ReOcMov` varchar(255) DEFAULT NULL,
  `LeOcMov` varchar(255) DEFAULT NULL,
  `BeOcMov` varchar(255) DEFAULT NULL,
  `OrbitalRe` varchar(255) DEFAULT NULL,
  `OrbitalLe` varchar(255) DEFAULT NULL,
  `ReLids` varchar(255) DEFAULT NULL,
  `LeLids` varchar(255) DEFAULT NULL,
  `ReConj` varchar(255) DEFAULT NULL,
  `LeConj` varchar(255) DEFAULT NULL,
  `ReCornea` varchar(255) DEFAULT NULL,
  `LeCornea` varchar(255) DEFAULT NULL,
  `ReCorneaRemark` varchar(255) DEFAULT NULL,
  `LeCorneaRemark` varchar(255) DEFAULT NULL,
  `ReAntChamber` varchar(255) DEFAULT NULL,
  `LeAntChamber` varchar(255) DEFAULT NULL,
  `ReIris` varchar(255) DEFAULT NULL,
  `LeIris` varchar(255) DEFAULT NULL,
  `RePupil` varchar(255) DEFAULT NULL,
  `LePupil` varchar(255) DEFAULT NULL,
  `ReIop` varchar(255) DEFAULT NULL,
  `LeIop` varchar(255) DEFAULT NULL,
  `ReLens` varchar(255) DEFAULT NULL,
  `LeLens` varchar(255) DEFAULT NULL,
  `ReLens2` varchar(255) DEFAULT NULL,
  `LeLens2` varchar(255) DEFAULT NULL,
  `ReNlp` varchar(255) DEFAULT NULL,
  `LeNlp` varchar(255) DEFAULT NULL,
  `ChkReHazy` varchar(255) DEFAULT '0',
  `ChkLeHazy` varchar(255) DEFAULT '0',
  `ReMedia` text,
  `LeMedia` text,
  `ReOptDisc` text,
  `LeOptDisc` text,
  `ReMacBV` text,
  `LeMacBV` text,
  `ReBv` varchar(255) DEFAULT NULL,
  `LeBv` varchar(255) DEFAULT NULL,
  `ReMidPerPh` text,
  `LeMidPerPh` text,
  `InvStName` text,
  `InvStBy` varchar(255) DEFAULT NULL,
  `Amount` varchar(100) DEFAULT NULL,
  `CounCellingBy` varchar(255) DEFAULT NULL,
  `Diagnosis` text,
  `Treatment` varchar(255) DEFAULT NULL,
  `Advice` text,
  `Remark` text,
  `ChkDilate` varchar(255) DEFAULT NULL,
  `ChkCatProfile` varchar(255) DEFAULT NULL,
  `ChkLasikProfile` varchar(255) DEFAULT NULL,
  `CreatedBy` int DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT '0',
  `updated_at` datetime DEFAULT NULL,
  `CouncRemark` text,
  `Checked` varchar(10) DEFAULT '0',
  `ReviewDay` int DEFAULT '0',
  `Review` varchar(255) DEFAULT NULL,
  `AppointDate` date DEFAULT NULL,
  `AlRe` varchar(100) DEFAULT NULL,
  `AlLe` varchar(100) DEFAULT NULL,
  `WtwRe` varchar(100) DEFAULT NULL,
  `WtwLe` varchar(100) DEFAULT NULL,
  `PachyRe` varchar(100) DEFAULT NULL,
  `PachyLe` varchar(100) DEFAULT NULL,
  `IOL1` varchar(100) DEFAULT NULL,
  `IOL2` varchar(100) DEFAULT NULL,
  `IOL3` varchar(100) DEFAULT NULL,
  `IOL4` varchar(100) DEFAULT NULL,
  `IOL5` varchar(100) DEFAULT NULL,
  `IOL6` varchar(100) DEFAULT NULL,
  `VisionRe` varchar(100) DEFAULT NULL,
  `VisionLe` varchar(100) DEFAULT NULL,
  `NearRe` varchar(100) DEFAULT NULL,
  `NearLe` varchar(100) DEFAULT NULL,
  `BP` varchar(100) DEFAULT NULL,
  `NctRe` varchar(100) DEFAULT NULL,
  `NctLe` varchar(100) DEFAULT NULL,
  `FundusRemark` text,
  `ReferTo` varchar(100) DEFAULT NULL,
  `ContinueTT` varchar(100) DEFAULT NULL,
  `PrintGls` varchar(100) DEFAULT NULL,
  `DiagnosisRemark` text,
  `PrintReLe` varchar(10) DEFAULT '0',
  `PageBreak` varchar(10) DEFAULT '0',
  `FundusDraw` varchar(10) DEFAULT '0',
  `ConsDialated` varchar(100) DEFAULT NULL,
  `ConsDiaEye` varchar(100) DEFAULT NULL,
  `CostCoated` varchar(100) DEFAULT NULL,
  `DfFe` varchar(10) DEFAULT '0',
  `ClinicName` varchar(255) DEFAULT NULL,
  `SpecDocName` varchar(255) DEFAULT NULL,
  `AppTime` varchar(100) DEFAULT NULL,
  `CmbPlanOfMang` varchar(255) DEFAULT NULL,
  `CmbRemark` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_consultants`
--

INSERT INTO `tbl_consultants` (`id`, `MrdNo`, `VisitNo`, `VisitDate`, `PatientName`, `ChkReNormal`, `ChkLeNormal`, `ReOcMov`, `LeOcMov`, `BeOcMov`, `OrbitalRe`, `OrbitalLe`, `ReLids`, `LeLids`, `ReConj`, `LeConj`, `ReCornea`, `LeCornea`, `ReCorneaRemark`, `LeCorneaRemark`, `ReAntChamber`, `LeAntChamber`, `ReIris`, `LeIris`, `RePupil`, `LePupil`, `ReIop`, `LeIop`, `ReLens`, `LeLens`, `ReLens2`, `LeLens2`, `ReNlp`, `LeNlp`, `ChkReHazy`, `ChkLeHazy`, `ReMedia`, `LeMedia`, `ReOptDisc`, `LeOptDisc`, `ReMacBV`, `LeMacBV`, `ReBv`, `LeBv`, `ReMidPerPh`, `LeMidPerPh`, `InvStName`, `InvStBy`, `Amount`, `CounCellingBy`, `Diagnosis`, `Treatment`, `Advice`, `Remark`, `ChkDilate`, `ChkCatProfile`, `ChkLasikProfile`, `CreatedBy`, `created_at`, `ModifiedBy`, `updated_at`, `CouncRemark`, `Checked`, `ReviewDay`, `Review`, `AppointDate`, `AlRe`, `AlLe`, `WtwRe`, `WtwLe`, `PachyRe`, `PachyLe`, `IOL1`, `IOL2`, `IOL3`, `IOL4`, `IOL5`, `IOL6`, `VisionRe`, `VisionLe`, `NearRe`, `NearLe`, `BP`, `NctRe`, `NctLe`, `FundusRemark`, `ReferTo`, `ContinueTT`, `PrintGls`, `DiagnosisRemark`, `PrintReLe`, `PageBreak`, `FundusDraw`, `ConsDialated`, `ConsDiaEye`, `CostCoated`, `DfFe`, `ClinicName`, `SpecDocName`, `AppTime`, `CmbPlanOfMang`, `CmbRemark`) VALUES
(1, '1', 1, '2026-07-07', 'Mr. Rajat Padmakar Dhanwalkar', '1', '1', 'Normal', 'Normal', NULL, NULL, NULL, 'Flat', 'Flat', 'Normal', 'Normal', 'Bright and Clear', 'Bright and Clear', NULL, NULL, 'Normal Depth', 'Normal Depth', 'Colour and Pattern Normal', 'Colour and Pattern Normal', 'NSRL', 'NSRL', NULL, NULL, 'Transparent', 'Transparent', NULL, NULL, 'No Regurgitation', 'No Regurgitation', NULL, NULL, 'Clear', 'Clear', 'Normal', 'Normal', 'Foveal reflex Healthy', 'Foveal reflex Healthy', 'Blood Vessels are normal', 'Blood Vessels are normal', 'Normal', 'Normal', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 34, '2026-07-07 22:20:37', 34, '2026-07-07 22:33:52', NULL, '1', 0, 'days', '2026-07-07', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL),
(2, '2', 1, '2026-07-07', 'Mr. Yogendra  Naringe', '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 19, '2026-07-07 22:25:21', 19, '2026-07-07 22:25:26', NULL, '0', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', '0', '0', 'BE', NULL, '0', NULL, NULL, NULL, NULL, NULL),
(3, '1', 2, '2026-07-08', 'Mr. Rajat Padmakar Dhanwalkar', '1', '1', 'Normal', 'Normal', NULL, NULL, NULL, 'Flat', 'Flat', 'Normal', 'Normal', 'Bright and Clear', 'Bright and Clear', NULL, NULL, 'Normal Depth', 'Normal Depth', 'Colour and Pattern Normal', 'Colour and Pattern Normal', 'NSRL', 'NSRL', NULL, NULL, 'Transparent', 'Transparent', NULL, NULL, 'No Regurgitation', 'No Regurgitation', NULL, NULL, 'Clear', 'Clear', 'Normal', 'Normal', 'Foveal reflex Healthy', 'Foveal reflex Healthy', 'Blood Vessels are normal', 'Blood Vessels are normal', 'Normal', 'Normal', '.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 19, '2026-07-08 10:42:15', 19, '2026-07-08 20:29:23', NULL, NULL, 0, 'days', '2026-07-08', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL),
(4, '2', 2, '2026-07-08', 'Mr. Yogendra  Naringe', '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 19, '2026-07-08 20:28:15', 19, '2026-07-08 20:28:15', NULL, '0', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', '0', NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL),
(5, '1', 3, '2026-07-10', 'Mr. Rajat Padmakar Dhanwalkar', '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 19, '2026-07-10 22:48:19', 19, '2026-07-10 22:48:19', NULL, '0', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', '0', NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `tbl_consultant_treatments`
--

CREATE TABLE `tbl_consultant_treatments` (
  `id` int NOT NULL,
  `PostId` int DEFAULT '0',
  `MrdNo` bigint DEFAULT '0',
  `VisitNo` int DEFAULT '0',
  `VisitDate` date DEFAULT '0000-00-00',
  `Treatment` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TreatType1` text COLLATE utf8mb4_general_ci,
  `TreatName1` text COLLATE utf8mb4_general_ci,
  `TreatDose1` text COLLATE utf8mb4_general_ci,
  `TreatFreq1` text COLLATE utf8mb4_general_ci,
  `TreatDur1` text COLLATE utf8mb4_general_ci,
  `TreatEye1` text COLLATE utf8mb4_general_ci,
  `TreatType2` text COLLATE utf8mb4_general_ci,
  `TreatName2` text COLLATE utf8mb4_general_ci,
  `TreatDose2` text COLLATE utf8mb4_general_ci,
  `TreatFreq2` text COLLATE utf8mb4_general_ci,
  `TreatDur2` text COLLATE utf8mb4_general_ci,
  `TreatEye2` text COLLATE utf8mb4_general_ci,
  `TreatType3` text COLLATE utf8mb4_general_ci,
  `TreatName3` text COLLATE utf8mb4_general_ci,
  `TreatDose3` text COLLATE utf8mb4_general_ci,
  `TreatFreq3` text COLLATE utf8mb4_general_ci,
  `TreatDur3` text COLLATE utf8mb4_general_ci,
  `TreatEye3` text COLLATE utf8mb4_general_ci,
  `TreatType4` text COLLATE utf8mb4_general_ci,
  `TreatName4` text COLLATE utf8mb4_general_ci,
  `TreatDose4` text COLLATE utf8mb4_general_ci,
  `TreatFreq4` text COLLATE utf8mb4_general_ci,
  `TreatDur4` text COLLATE utf8mb4_general_ci,
  `TreatEye4` text COLLATE utf8mb4_general_ci,
  `TreatType5` text COLLATE utf8mb4_general_ci,
  `TreatName5` text COLLATE utf8mb4_general_ci,
  `TreatDose5` text COLLATE utf8mb4_general_ci,
  `TreatFreq5` text COLLATE utf8mb4_general_ci,
  `TreatDur5` text COLLATE utf8mb4_general_ci,
  `TreatEye5` text COLLATE utf8mb4_general_ci,
  `TreatType6` text COLLATE utf8mb4_general_ci,
  `TreatName6` text COLLATE utf8mb4_general_ci,
  `TreatDose6` text COLLATE utf8mb4_general_ci,
  `TreatFreq6` text COLLATE utf8mb4_general_ci,
  `TreatDur6` text COLLATE utf8mb4_general_ci,
  `TreatEye6` text COLLATE utf8mb4_general_ci,
  `TreatType7` text COLLATE utf8mb4_general_ci,
  `TreatName7` text COLLATE utf8mb4_general_ci,
  `TreatDose7` text COLLATE utf8mb4_general_ci,
  `TreatFreq7` text COLLATE utf8mb4_general_ci,
  `TreatDur7` text COLLATE utf8mb4_general_ci,
  `TreatEye7` text COLLATE utf8mb4_general_ci,
  `TreatType8` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TreatName8` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TreatDose8` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TreatFreq8` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TreatDur8` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TreatEye8` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TreatChk9` text COLLATE utf8mb4_general_ci,
  `TreatType9` text COLLATE utf8mb4_general_ci,
  `TreatName9` text COLLATE utf8mb4_general_ci,
  `TreatDose9` text COLLATE utf8mb4_general_ci,
  `TreatFreq9` text COLLATE utf8mb4_general_ci,
  `TreatDur9` text COLLATE utf8mb4_general_ci,
  `TreatEye9` text COLLATE utf8mb4_general_ci,
  `TreatChk10` text COLLATE utf8mb4_general_ci,
  `TreatType10` text COLLATE utf8mb4_general_ci,
  `TreatName10` text COLLATE utf8mb4_general_ci,
  `TreatDose10` text COLLATE utf8mb4_general_ci,
  `TreatFreq10` text COLLATE utf8mb4_general_ci,
  `TreatDur10` text COLLATE utf8mb4_general_ci,
  `TreatEye10` text COLLATE utf8mb4_general_ci,
  `TreatChk11` text COLLATE utf8mb4_general_ci,
  `TreatType11` text COLLATE utf8mb4_general_ci,
  `TreatName11` text COLLATE utf8mb4_general_ci,
  `TreatDose11` text COLLATE utf8mb4_general_ci,
  `TreatFreq11` text COLLATE utf8mb4_general_ci,
  `TreatDur11` text COLLATE utf8mb4_general_ci,
  `TreatEye11` text COLLATE utf8mb4_general_ci,
  `TreatChk12` text COLLATE utf8mb4_general_ci,
  `TreatType12` text COLLATE utf8mb4_general_ci,
  `TreatName12` text COLLATE utf8mb4_general_ci,
  `TreatDose12` text COLLATE utf8mb4_general_ci,
  `TreatFreq12` text COLLATE utf8mb4_general_ci,
  `TreatDur12` text COLLATE utf8mb4_general_ci,
  `TreatEye12` text COLLATE utf8mb4_general_ci,
  `TreatChk13` text COLLATE utf8mb4_general_ci,
  `TreatType13` text COLLATE utf8mb4_general_ci,
  `TreatName13` text COLLATE utf8mb4_general_ci,
  `TreatDose13` text COLLATE utf8mb4_general_ci,
  `TreatFreq13` text COLLATE utf8mb4_general_ci,
  `TreatDur13` text COLLATE utf8mb4_general_ci,
  `TreatEye13` text COLLATE utf8mb4_general_ci,
  `TreatChk1` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '0',
  `TreatChk2` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '0',
  `TreatChk3` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '0',
  `TreatChk4` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '0',
  `TreatChk5` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '0',
  `TreatChk6` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '0',
  `TreatChk7` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '0',
  `TreatChk8` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_consultant_treatments`
--

INSERT INTO `tbl_consultant_treatments` (`id`, `PostId`, `MrdNo`, `VisitNo`, `VisitDate`, `Treatment`, `TreatType1`, `TreatName1`, `TreatDose1`, `TreatFreq1`, `TreatDur1`, `TreatEye1`, `TreatType2`, `TreatName2`, `TreatDose2`, `TreatFreq2`, `TreatDur2`, `TreatEye2`, `TreatType3`, `TreatName3`, `TreatDose3`, `TreatFreq3`, `TreatDur3`, `TreatEye3`, `TreatType4`, `TreatName4`, `TreatDose4`, `TreatFreq4`, `TreatDur4`, `TreatEye4`, `TreatType5`, `TreatName5`, `TreatDose5`, `TreatFreq5`, `TreatDur5`, `TreatEye5`, `TreatType6`, `TreatName6`, `TreatDose6`, `TreatFreq6`, `TreatDur6`, `TreatEye6`, `TreatType7`, `TreatName7`, `TreatDose7`, `TreatFreq7`, `TreatDur7`, `TreatEye7`, `TreatType8`, `TreatName8`, `TreatDose8`, `TreatFreq8`, `TreatDur8`, `TreatEye8`, `TreatChk9`, `TreatType9`, `TreatName9`, `TreatDose9`, `TreatFreq9`, `TreatDur9`, `TreatEye9`, `TreatChk10`, `TreatType10`, `TreatName10`, `TreatDose10`, `TreatFreq10`, `TreatDur10`, `TreatEye10`, `TreatChk11`, `TreatType11`, `TreatName11`, `TreatDose11`, `TreatFreq11`, `TreatDur11`, `TreatEye11`, `TreatChk12`, `TreatType12`, `TreatName12`, `TreatDose12`, `TreatFreq12`, `TreatDur12`, `TreatEye12`, `TreatChk13`, `TreatType13`, `TreatName13`, `TreatDose13`, `TreatFreq13`, `TreatDur13`, `TreatEye13`, `TreatChk1`, `TreatChk2`, `TreatChk3`, `TreatChk4`, `TreatChk5`, `TreatChk6`, `TreatChk7`, `TreatChk8`) VALUES
(1, 0, 1, 1, '2026-07-07', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2, 0, 2, 1, '2026-07-07', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', '0', '0', '0', '0', '0', '0'),
(3, 0, 1, 2, '2026-07-08', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4, 0, 2, 2, '2026-07-08', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', '0', '0', '0', '0', '0', '0'),
(5, 0, 1, 3, '2026-07-10', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', '0', '0', '0', '0', '0', '0');

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

--
-- Table structure for table `tbl_consultation_charges`
--

CREATE TABLE `tbl_consultation_charges` (
  `id` bigint NOT NULL,
  `PatientId` varchar(255) DEFAULT NULL,
  `MrdNo` varchar(255) DEFAULT NULL,
  `PatientName` varchar(255) DEFAULT NULL,
  `ConsultantId` int DEFAULT '0',
  `Consultant` varchar(255) DEFAULT NULL,
  `Procedures` varchar(255) DEFAULT NULL,
  `Amount` float(14,2) DEFAULT NULL,
  `PayMode` varchar(255) DEFAULT NULL,
  `ChequeNo` varchar(255) DEFAULT NULL,
  `Narration` text,
  `Status` tinyint(1) DEFAULT '1',
  `CreatedBy` int DEFAULT '0',
  `CreatedDate` date DEFAULT NULL,
  `ModifiedBy` int DEFAULT '0',
  `ModifiedDate` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `tbl_counsellings`
--

CREATE TABLE `tbl_counsellings` (
  `id` int NOT NULL,
  `MrdNo` text,
  `PatientName` text,
  `Age` text,
  `Gender` text,
  `Phone` text,
  `Address` text,
  `City` text,
  `AdmissionDate` text,
  `CounsellingDate` text,
  `SurgeryDate` text,
  `Site` text,
  `Diagnosis` text,
  `SurgeryName` text,
  `SurgenName` text,
  `Anaesthetist` text,
  `SurgeryPkg` text,
  `LaGa` text,
  `CounsellingBy` text,
  `Iol` text,
  `Diopter` text,
  `Notes` text,
  `IpdNo` text,
  `Confirm` text,
  `Charges` text,
  `ScrutinyBy` text,
  `IOLPower` text,
  `SAC` text,
  `Fitness` text,
  `Fundus` text,
  `Remark` text,
  `Status` text,
  `CreatedBy` text,
  `CreatedDate` text,
  `ModifiedBy` text,
  `ModifiedDate` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `tbl_decriptions`
--

CREATE TABLE `tbl_decriptions` (
  `id` int NOT NULL,
  `Description` text,
  `GlassRate` decimal(12,2) DEFAULT NULL,
  `Type` varchar(100) DEFAULT NULL,
  `CreatedBy` int DEFAULT '0',
  `CreatedDate` date DEFAULT NULL,
  `ModifiedBy` int DEFAULT '0',
  `ModifiedDate` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_decriptions`
--

INSERT INTO `tbl_decriptions` (`id`, `Description`, `GlassRate`, `Type`, `CreatedBy`, `CreatedDate`, `ModifiedBy`, `ModifiedDate`) VALUES
(1, 'OU ? Phlyctenular Conjunctivitis ??', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(2, 'OS Congenital Dacryocystitis', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(3, 'OU Glaucoma', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(4, 'Traumatic', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(5, 'OU Myopia', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(6, 'OU Hypermetropia with Presbyopia', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(7, 'OU Hypermetropia', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(8, 'OU Conjunctivitis', NULL, 'Diagnosis', 19, '0000-00-00', 19, '0000-00-00'),
(9, 'OD Subtarsal FB', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(10, 'OU Keratoconus Suspect', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(11, 'OU Ametropia with Presbyopia', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(13, 'Allergic Conjunctivitis', NULL, 'Diagnosis', 19, '0000-00-00', 19, '0000-00-00'),
(14, 'OS Acute Phacomorphic Glaucoma', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(15, 'OU Ametropia', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(16, 'OU Presbyopia', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(17, 'Headache ? Cause', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(18, 'OU Compound Myopic Astigmatism ', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(19, 'Recurrent', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(20, 'OD Chronic Dacryocystitis', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(21, 'OD Anisometropic Amblyopia', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(22, 'OU High Myopia', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(23, 'OU Chronic Dacryocystitis', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(24, 'OU Squamous Blepharitis', NULL, 'Diagnosis', 19, '0000-00-00', 19, '0000-00-00'),
(25, 'Meibomian Gland Dysfunction', NULL, 'Diagnosis', 19, '0000-00-00', 19, '0000-00-00'),
(26, 'Computer Vision Syndrome', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(27, 'OU Chronic Congestion', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(28, 'OU Episcleritis', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(29, 'OD Absolute Glaucoma', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(30, 'OS Vernal Keratoconjunctivitis', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(31, 'OU Compound Hypermetropic Astigmatism With Presbyopia', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(32, 'OU Myopic Astigmatism with Presbyopia', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(33, 'OS 6th neve palsy', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(34, 'OU Simple Myopic Astigmatism', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(35, 'OU Simple Myopic Astigmatism with Presbyopia', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(36, 'Toxic Keratitis Sec to Calatropis Flower ( Sodom Apple )', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(37, 'OS Homonymous Hemianopia', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(39, 'OU Compound Hypermetropic Astigmatism', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(40, 'OU Compound Myopic Astigmatism with Presbyopia', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(41, 'Sub Conjunctival Hemorrhage', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(42, 'OU Simple Hypermetropic Astigmatism with Presbyopia', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(43, 'OU Conjunctivochalasis', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(44, 'Hemifacial Spasm ? Cause', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(45, 'OU Mixed Astigmatism', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(46, 'OU Emmetropia', NULL, 'Diagnosis', 19, '0000-00-00', 19, '0000-00-00'),
(47, 'Sub Conjunctival Hg', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(48, 'Asymmetrical Cupping ? Physiological', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(49, 'OU Myopia with Presbyopia', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(50, 'Herpes Zoster Ophthalmicus', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(51, 'OU Congenital Dcaryocystitis', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(52, 'OD CL Induced Keratopathy', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(53, 'OD Chalazion with Cellulitis', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(54, 'Headache ?  Vascular', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(55, 'Congenital Dacryocystitis', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(56, 'Evaporative Dry Eye', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(57, 'Fasiculations', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(58, '( Family History Of Glaucoma )', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(60, 'Moderate Senile Ptosis', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(61, 'Post Subcapsular Cataract', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(62, 'Xanthelesma', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(63, 'Congenital NLD Obstruction', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(64, 'Adenoviral Numular Keratitis ( Post Conjunctivitis )', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(65, 'Oil Droplet Keratopathy', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(66, 'OU High Hypermetropia', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(67, 'Frequent Blinking', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(68, 'Aqueous Deficient Dry Eye / Non-Sjogrens Syndrome', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(69, 'OU Meridonial Amblyopia', NULL, 'Diagnosis', 19, '0000-00-00', 19, '0000-00-00'),
(70, 'Glaucoma Suspect', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(71, 'Nystagmus', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(72, 'Decentered IOL', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(73, 'Episcleritis', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(74, 'Lattices', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(75, 'Pthisis Bulbi', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(76, 'Ocular Hypertension', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(77, 'OU Chronic Redness ?? Cause', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(78, 'Traumatic Conjunctival Laceration', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(79, 'OU High Myopia With Astigmatism', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(80, 'Thyroid Disorder', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(81, 'Convergence Insufficiency', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(82, 'Amaurosis Fugax', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(83, 'OU Adenoviral Keratitis', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(84, 'Absolute Glaucoma', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(85, 'Allergy to TROPICACYL PLUS', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(86, 'OU Post Polar Cataract', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(87, 'OD Chronic Angle Closure Glaucoma', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(88, 'OD Amaurosis Fugax ? Cause', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(89, 'OU Retinal Detachment', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(90, 'OU  Post Embryotoxon', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(91, 'Blepharospasm', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(93, 'Symphathetic Ophthalmia', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(94, 'Traumatic Mydriasis', NULL, 'Diagnosis', 19, '0000-00-00', 19, '0000-00-00'),
(95, 'OS Double Headed Pterygium', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(96, 'Mucocoele', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(97, 'Facial Paresis', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(98, 'OU Essential Blepharospasm', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(99, 'OD Traumatic Subluxated  Cataract', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(100, 'Atrophic Bulbi', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(101, 'OD Adherent Leucoma', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(102, 'K/c of Downs syndrome', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(103, 'OS Conjunctival Mole', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(104, 'OU Mucus Fishing Syndrome', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(105, 'Left Homonymous Hemianopia', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(106, 'OU Ocular Mysthenia', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(107, 'OU Developmental Cataract', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(108, 'Essential Blepharospasm', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(109, 'OS Adherent Leucoma', NULL, 'Diagnosis', 19, '0000-00-00', 0, '0000-00-00'),
(110, 'DOV', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(111, 'Redness, Pain, Watering', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(112, 'Pain', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(113, 'Redness', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(114, 'F.B Sensation', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(116, 'Itching', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(118, 'Eye Pain', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(119, 'Headache', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(120, 'Glasses Prescribed', NULL, 'Treatment', 19, '0000-00-00', 0, '0000-00-00'),
(121, 'Refractive Lens Prescribed', NULL, 'Treatment', 19, '0000-00-00', 0, '0000-00-00'),
(122, 'Refractive Surgery', NULL, 'Treatment', 19, '0000-00-00', 0, '0000-00-00'),
(123, 'Lasix', NULL, 'Treatment', 19, '0000-00-00', 0, '0000-00-00'),
(124, 'Trabeculectomy', NULL, 'Treatment', 19, '0000-00-00', 0, '0000-00-00'),
(125, 'Phaco with IOL', NULL, 'Treatment', 19, '0000-00-00', 0, '0000-00-00'),
(126, 'Ectropin Correction /E', NULL, 'Treatment', 19, '0000-00-00', 0, '0000-00-00'),
(127, 'Endonasal DCR', NULL, 'Treatment', 19, '0000-00-00', 0, '0000-00-00'),
(128, 'Entropin Correction', NULL, 'Treatment', 19, '0000-00-00', 0, '0000-00-00'),
(129, 'Squint Surgery', NULL, 'Treatment', 19, '0000-00-00', 0, '0000-00-00'),
(130, 'Pterygium Excision with Conjuctival Grafting', NULL, 'Treatment', 19, '0000-00-00', 0, '0000-00-00'),
(131, 'Clear', NULL, 'Media', 19, '0000-00-00', 0, '0000-00-00'),
(132, 'Normal', NULL, 'OptDisc', 19, '0000-00-00', 0, '0000-00-00'),
(133, 'Normal', NULL, 'Fret', 19, '0000-00-00', 0, '0000-00-00'),
(134, 'Healthy', NULL, 'MacBV', 19, '0000-00-00', 0, '0000-00-00'),
(135, 'Normal', NULL, 'MidPerPh', 19, '0000-00-00', 0, '0000-00-00'),
(136, 'Foveal Reflex Healthy', NULL, 'MacBV', 19, '0000-00-00', 0, '0000-00-00'),
(137, 'Hazy', NULL, 'Media', 19, '0000-00-00', 19, '0000-00-00'),
(138, 'Floaters', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(139, 'Watering', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(140, 'PVD', NULL, 'Media', 19, '0000-00-00', 0, '0000-00-00'),
(141, 'Multiple drusen on macula', NULL, 'MacBV', 19, '0000-00-00', 0, '0000-00-00'),
(142, 'ERM', NULL, 'MacBV', 19, '0000-00-00', 0, '0000-00-00'),
(143, 'RE Cataract Surgery Done At  Vyawahare  Netralaya', NULL, 'OcularHistory', 19, '0000-00-00', 19, '0000-00-00'),
(144, 'Harsha Shejao', NULL, 'SPC', 19, '0000-00-00', 0, '0000-00-00'),
(145, 'IC Extraction With Iris Claw IOL Implantation Under GVP', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(146, 'PHACO WITH IOL  Physician fitness for Cataract surgery under LA  Blood Sugar F/PM', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(148, 'Discharge', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(149, 'Temporal pallor', NULL, 'OptDisc', 19, '0000-00-00', 0, '0000-00-00'),
(150, 'Ref to Neurologist', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(151, 'Opinion of Neurologist', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(152, 'LE Cataract Surgery Done at Vyawahare Netralaya', NULL, 'OcularHistory', 19, '0000-00-00', 0, '0000-00-00'),
(153, 'Macular scarring', NULL, 'MacBV', 19, '0000-00-00', 0, '0000-00-00'),
(154, 'Refractive surgery', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(155, 'Sudden Loss Of Vision', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(156, 'OU Refractive lens Exchange', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(157, 'C/D Ratio', NULL, 'OptDisc', 19, '0000-00-00', 0, '0000-00-00'),
(158, 'Burning Sensation', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(159, 'No evidence of DR', NULL, 'MidPerPh', 19, '0000-00-00', 0, '0000-00-00'),
(160, 'Myopic Maculopathy', NULL, 'MacBV', 19, '0000-00-00', 0, '0000-00-00'),
(161, 'Myopic Degeneration', NULL, 'MidPerPh', 19, '0000-00-00', 0, '0000-00-00'),
(162, 'h/of Trauma by wooden stick', NULL, 'OcularHistory', 19, '0000-00-00', 0, '0000-00-00'),
(163, 'Lacrimal Massage', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(164, 'Opinion of VR Surgeon', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(165, 'Asteroid Hyalosis', NULL, 'Media', 19, '0000-00-00', 0, '0000-00-00'),
(166, 'Ref. Back To Dr. Gajbe Sir For Refraction After 7 Days', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(167, 'Periphery No Treatable Lesion Seen', NULL, 'MidPerPh', 19, '0000-00-00', 0, '0000-00-00'),
(168, 'LE Pterygium Surgery done at Vyawahare Netralaya', NULL, 'OcularHistory', 19, '0000-00-00', 0, '0000-00-00'),
(169, 'RE Pterygium Surgery done  at Vyawahare Netralaya', NULL, 'OcularHistory', 19, '0000-00-00', 0, '0000-00-00'),
(170, 'Heaviness', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(171, 'Total Optic Atrophy', NULL, 'OptDisc', 19, '0000-00-00', 0, '0000-00-00'),
(172, 'Details not seen', NULL, 'MacBV', 19, '0000-00-00', 0, '0000-00-00'),
(173, 'Details not seen', NULL, 'OptDisc', 19, '0000-00-00', 0, '0000-00-00'),
(174, 'Details not seen', NULL, 'Media', 19, '0000-00-00', 0, '0000-00-00'),
(175, 'Details not seen', NULL, 'MidPerPh', 19, '0000-00-00', 0, '0000-00-00'),
(176, 'No treatable lesion seen in perifery', NULL, 'MidPerPh', 19, '0000-00-00', 0, '0000-00-00'),
(177, 'Myopic', NULL, 'OptDisc', 19, '0000-00-00', 0, '0000-00-00'),
(178, 'Squint Surgery', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(179, 'Foveal Reflex Dull', NULL, 'MacBV', 19, '0000-00-00', 0, '0000-00-00'),
(180, 'Macular Hole', NULL, 'MacBV', 19, '0000-00-00', 0, '0000-00-00'),
(181, 'RE Operated  For  Cataract on, Came  For Followup ', NULL, 'OcularHistory', 19, '0000-00-00', 0, '0000-00-00'),
(182, 'Review after 1 year', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(183, 'Macular edema / Multiple hgs along ST arcade', NULL, 'MacBV', 19, '0000-00-00', 0, '0000-00-00'),
(184, 'Hg/exudates along IT arcade', NULL, 'MidPerPh', 19, '0000-00-00', 0, '0000-00-00'),
(185, 'Protective Goggles', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(186, 'LE Operated  For  Cataract on, Came  For Followup ', NULL, 'OcularHistory', 19, '0000-00-00', 0, '0000-00-00'),
(187, 'Preferably Toric IOL', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(188, 'No e/of Diabetic Retinopathy', NULL, 'MidPerPh', 19, '0000-00-00', 19, '0000-00-00'),
(190, 'OU Ant Capsular Phimosis release done on', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(191, 'RE Operated  For  Pterygium  on, Came  For Followup ', NULL, 'OcularHistory', 19, '0000-00-00', 0, '0000-00-00'),
(192, 'Physician Checkup to rule out other Vasoocclusive disorders', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(193, 'SOS Early Cataract Surgery for refractive purpose', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(194, 'MULTIPLE MA/SUP. HG/EXUDATES +', NULL, 'MidPerPh', 19, '0000-00-00', 0, '0000-00-00'),
(195, 'Total Glaucomatous Optic Atrophy', NULL, 'OptDisc', 19, '0000-00-00', 0, '0000-00-00'),
(196, 'OD IOL Explantation with SF / Iris Claw IOL', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(197, 'To Keep HB1AC Below 6.5 Strict Control Of Blood Sugar', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(198, 'Pupil - Nondilating', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(199, 'Scleral Contact Lens', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(200, 'LE Operated  For  Pterygium  on, Came  For Followup ', NULL, 'OcularHistory', 19, '0000-00-00', 0, '0000-00-00'),
(201, 'Swelling', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(202, 'LE Cataract Surgery Done Elsewhere 2015', NULL, 'OcularHistory', 19, '0000-00-00', 0, '0000-00-00'),
(203, 'Irritation', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(204, 'Refer to Physician to rule out other Vaso-occlusive disorder', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(205, 'C/D ratio 0.8 , Cupping +, Rim thinning', NULL, 'OptDisc', 19, '0000-00-00', 0, '0000-00-00'),
(206, 'Endonasal DCR BE', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(207, 'Preoperative Blood Profile/ Physician fitness for Endonasal Surgery under LA / ENT Evaluation', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(208, 'Review for dilated examination', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(209, 'Arterial attenuation', NULL, 'MidPerPh', 19, '0000-00-00', 0, '0000-00-00'),
(210, 'Physician checkup for systemic risk factor control :BP,DM,Lipid Profile .Serum Homocystine,ESR,Cardiovascular evaluation', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(211, 'LE Operated  For  Cataract on, Came  For Followup', NULL, 'OcularHistory', 19, '0000-00-00', 0, '0000-00-00'),
(212, 'Refer to Neurologist  for headache', NULL, 'Advice', 19, '0000-00-00', 19, '0000-00-00'),
(213, 'RPE atrophy / Multiple drusen', NULL, 'MacBV', 19, '0000-00-00', 0, '0000-00-00'),
(214, 'Came for follow up', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(215, 'Entry of Foreign body', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(216, 'h/of PK surgery done on', NULL, 'OcularHistory', 19, '0000-00-00', 0, '0000-00-00'),
(217, 'Flashes Of Light', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(218, 'Bony corpuscular pigment / Art Attenuation', NULL, 'Media', 19, '0000-00-00', 0, '0000-00-00'),
(219, 'To continue old glasses', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(220, 'H/of - Road Accident', NULL, 'OcularHistory', 19, '0000-00-00', 0, '0000-00-00'),
(221, 'Pterygium Excision With Conjunctival Graft   Physician fitness for Pterygium surgery under LA  Blood Sugar F/PM', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(222, 'LASIK Iterested', NULL, 'SPC', 19, '0000-00-00', 0, '0000-00-00'),
(223, 'Few m/a+/ Hgs  on post pole', NULL, 'MidPerPh', 19, '0000-00-00', 0, '0000-00-00'),
(224, 'Referred to Physician for Strict control of Blood Sugar / To keep HB1Ac below 6.5 / Control of other associated risk factor like BP,Lipid Profile', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(225, 'Oculoplasty', NULL, 'SPC', 19, '0000-00-00', 0, '0000-00-00'),
(226, 'Few microanurysm and exudates', NULL, 'MidPerPh', 19, '0000-00-00', 0, '0000-00-00'),
(227, 'Retina Clinic', NULL, 'SPC', 19, '0000-00-00', 0, '0000-00-00'),
(228, 'Cataract Counselling', NULL, 'SPC', 19, '0000-00-00', 0, '0000-00-00'),
(231, 'MIS', NULL, 'SPC', 19, '0000-00-00', 0, '0000-00-00'),
(232, 'Phaco with IOL with Pterygium Excision with Graft', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(233, 'Peripapillary Crescent', NULL, 'OptDisc', 19, '0000-00-00', 0, '0000-00-00'),
(234, 'Low Visual Aid Clinic', NULL, 'SPC', 19, '0000-00-00', 0, '0000-00-00'),
(235, 'LE cataract sx done', NULL, 'OcularHistory', 19, '0000-00-00', 0, '0000-00-00'),
(236, 'Ref to Physician to rule out systemic causes of Periorbital Edema', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(237, 'CBC/ESR/HIV/VDRL/RA FACTOR/ Montoux Test / B Scan / Elisa for Toxo Ig G IgM / TB Gold Interferon / X Yay Chest / Sr ACE', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(238, 'Watering and  Redness while riding the vehicle', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(239, 'Intravitreal Bevacizumab Under GVP', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(240, 'Pigments on post pole with unhealthy perifery', NULL, 'MidPerPh', 19, '0000-00-00', 0, '0000-00-00'),
(241, 'Seen through undilated pupil', NULL, 'Media', 19, '0000-00-00', 0, '0000-00-00'),
(242, 'Peripappilary crescent', NULL, 'Media', 19, '0000-00-00', 0, '0000-00-00'),
(243, 'FR Dull / Circinate Retinopathy/ CSME', NULL, 'MacBV', 19, '0000-00-00', 0, '0000-00-00'),
(244, 'Low Visual Aid Clinic - Dr. Kalra', NULL, 'SPC', 19, '0000-00-00', 0, '0000-00-00'),
(245, 'Multiple hard exudates /Edema', NULL, 'MacBV', 19, '0000-00-00', 0, '0000-00-00'),
(246, 'Macular edema', NULL, 'MacBV', 19, '0000-00-00', 0, '0000-00-00'),
(247, 'Inj AntiVeg F Under GVP /Possibility of repeated injection explained to patient', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(249, 'Broken glasses , came for eye checkup', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(250, 'DOV with old glasses', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(251, 'Low Vision AID', NULL, 'Advice', 19, '0000-00-00', 19, '0000-00-00'),
(252, 'Importance of putting eye drop regularly and Regular follow up explained to patient', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(253, 'Rheumatological Consultation with SOS Immunosuppression', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(254, 'Ref to Psychiatrist / Physician for Insomnia', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(255, 'Review in Paediatric Ophthalmology / Squint Clinic on Monday  at 4.00 pm', NULL, 'Advice', 19, '0000-00-00', 19, '0000-00-00'),
(256, 'Referred back to Dr Sonone for further treatment ( Fundus -WNL)', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(257, 'No view of Fundus', NULL, 'Media', 19, '0000-00-00', 0, '0000-00-00'),
(258, 'No Cupping', NULL, 'OptDisc', 19, '0000-00-00', 0, '0000-00-00'),
(259, 'Mylinated Nerve Fiber', NULL, 'OptDisc', 19, '0000-00-00', 0, '0000-00-00'),
(260, 'Multiple m/a,hard exudate on macula', NULL, 'MacBV', 19, '0000-00-00', 0, '0000-00-00'),
(261, 'Dr Rutika Khadase', NULL, 'SPC', 19, '0000-00-00', 0, '0000-00-00'),
(264, 'Signs and Symptoms of RD explained to patient / Watch for Flashes and floaters', NULL, 'Advice', 19, '0000-00-00', 19, '0000-00-00'),
(265, 'OS Epithelial Cyst Punctured', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(266, 'Photic Burn', NULL, 'MacBV', 19, '0000-00-00', 0, '0000-00-00'),
(268, 'Few m/a+ on post pole', NULL, 'MidPerPh', 19, '0000-00-00', 0, '0000-00-00'),
(269, 'Review For', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(270, 'Perimetry Test', NULL, 'SPC', 19, '0000-00-00', 0, '0000-00-00'),
(271, 'Opinion of Rheumatologist Dr Parikshit Sagdeo', NULL, 'Advice', 19, '0000-00-00', 19, '0000-00-00'),
(272, 'Refer to Physician / Neurologist for Vertigo', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(273, 'Suture removed', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(274, 'Came for Cataract Evaluation', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(275, 'AUTOLOGUS SERUM 40% EYE DROP', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(276, 'Review for Retina Clinic for VR Consultation at 2.30 pm on Tuesday / Friday', NULL, 'Advice', 19, '0000-00-00', 19, '0000-00-00'),
(277, 'Optic Disc Pale', NULL, 'OptDisc', 19, '0000-00-00', 0, '0000-00-00'),
(278, 'Cycloplegic Refraction', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(279, 'Came For Pediatric Clinic', NULL, 'Complaint', 19, '0000-00-00', 19, '0000-00-00'),
(280, 'Missplace Glasses', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(281, 'OU Refractive Surgery', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(283, 'Register for Keratoplasty', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(284, 'Drooping Eye Lid', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(285, 'RE SPH CYL AXIS', NULL, 'OcularHistory', 19, '0000-00-00', 0, '0000-00-00'),
(286, 'SOS Early Cataract Surgery to deepen AC and  for refractive purpose', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(287, 'Refer to ENT Specialist for headache ? Sinusitis', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(288, 'BE Cataract Surgery Done Elsewhere', NULL, 'OcularHistory', 19, '0000-00-00', 0, '0000-00-00'),
(289, 'Squinting Of Eyes', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(290, 'H/of - Missplace glasses', NULL, 'OcularHistory', 19, '0000-00-00', 0, '0000-00-00'),
(291, 'Bandage Contact Lens', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(292, 'Few microanurysm , hgs and exudates +', NULL, 'MidPerPh', 19, '0000-00-00', 0, '0000-00-00'),
(293, 'Photophobia', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(294, 'Phonophobia', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(295, 'Headache Half Side', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(296, 'Headache while Reading', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(297, 'Severe Headache Twice in a month', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(298, 'Headache twice or thrice in a month', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(299, 'Eye Pain While Travelling', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(300, 'Watering While Rideing', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(301, 'Toric Contact Lens', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(302, 'Review tomorrow', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(303, 'OU Removal Of Meibomian Concretion done', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(304, '? Pale ?? Physiological', NULL, 'OptDisc', 19, '0000-00-00', 0, '0000-00-00'),
(305, 'seen faintly appears normal', NULL, 'OptDisc', 19, '0000-00-00', 0, '0000-00-00'),
(306, 'OD Refixation OF IOL', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(307, 'Multiple Soft drusen', NULL, 'MacBV', 19, '0000-00-00', 0, '0000-00-00'),
(308, 'Meibography / Warm Compress with Mask and expression of glands', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(309, 'OS Cyclocryo', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(310, 'Multiple cotton wool spots , sup hg , exudates , ma on post pole', NULL, 'MidPerPh', 19, '0000-00-00', 0, '0000-00-00'),
(311, 'edema on macula  away from faz', NULL, 'MacBV', 19, '0000-00-00', 0, '0000-00-00'),
(312, 'Came For Peadiatric Clinic', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(313, 'Warm Compress and Lid Massage', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(315, 'Warm Compress with Lid Massage with Micro-ovenable Evolve eye mask', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(316, 'Difficulty while driving at Night', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(317, 'Flickers In the Eye', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(318, 'Review after 1 month', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(319, 'Convergence Exercises', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(320, 'Phaco with IOL / Preferably Toric IOL', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(321, 'Preferably EDOF IOL', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(322, 'Inj PST Tricort given on', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(323, 'Vitrectomy with MP + FGE+EL+SOI Under GVP Under LA', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(324, 'C/D Ratio 0.3 , NRR - Healthy', NULL, 'OptDisc', 19, '0000-00-00', 0, '0000-00-00'),
(325, 'Adv- Blood Sugar ,Lipid Profile .Serum Homocystine,ESR  Physician checkup for systemic risk factor control :BP,,Cardiovascular evaluation,DM  ', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(326, 'Preferably M/F IOL', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(327, 'Accomodation Exercises', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(328, 'Small Tissue Growth', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(329, 'H/of - Injury by Iron Part in LE', NULL, 'OcularHistory', 19, '0000-00-00', 0, '0000-00-00'),
(330, 'Pulsative Headache twice or thrice in a month', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(331, 'H/of - Entry of Lime burn', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(332, 'Expression done 3 nd sitting', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(333, 'H/of - Exposure to insectiside spray LE', NULL, 'OcularHistory', 19, '0000-00-00', 0, '0000-00-00'),
(334, 'Physician Evaluation for embolic source / Carotd Doppler / 2D Echo  Blood Sugar / Lipid Profile / Serum Homocystine', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(335, 'Consider for Bynocs Vision treatment', NULL, 'Advice', 19, '0000-00-00', 19, '0000-00-00'),
(336, 'Blurring of Vision transient for 30 min', NULL, 'OcularHistory', 19, '0000-00-00', 0, '0000-00-00'),
(337, 'Opinion of Oculoplastic Surgeon', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(338, 'Lateral Tarsal Strip with Medial Punctoplasty Under Guarded Prognosis', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(339, 'Lattice degeration', NULL, 'MidPerPh', 19, '0000-00-00', 0, '0000-00-00'),
(340, 'Warm Compress with Lid massage twice a week', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(341, 'VR Evaluation after surgery   ', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(342, 'Prominent choroidal vasculature', NULL, 'MidPerPh', 19, '0000-00-00', 0, '0000-00-00'),
(343, 'Conjunctival Tear repair', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(344, 'Watering and  Redness while riding the vehicle', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(345, 'Glasses with Blue Blocking and Antireflective coating lenses', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(346, 'Dilated examination on the day of Surgery', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(347, 'Few scattered hgs', NULL, 'MidPerPh', 19, '0000-00-00', 0, '0000-00-00'),
(348, 'OS Prosthetic eye shell ( COP )', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(349, 'OS Corneal FB with rust removal by Diamond burr done', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(350, 'Preferably Multifocal IOL', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(351, 'Blindness and White reflex', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(352, '(No Evidence Of Papilloedema)', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(353, 'Referred back to Dr Kurhade for further treatment (No Evidence Of Papilloedema)', NULL, 'Advice', 19, '0000-00-00', 0, '0000-00-00'),
(354, 'Came for regular eye checkup', NULL, 'Complaint', 19, '0000-00-00', 0, '0000-00-00'),
(358, '- Please use ARC coated, blue blocking lenses.', NULL, 'Remarks', 19, '0000-00-00', 19, '0000-00-00'),
(360, 'Cataract Profile - 2 K', NULL, 'InvSt', 19, '0000-00-00', 19, '0000-00-00'),
(361, 'OU Compound Myopic Astigmatism with Presbyopia', NULL, 'Diagnosis', 19, '0000-00-00', 19, '0000-00-00'),
(362, 'OU Compound Hypermetropic Astigmatism With Presbyopia', NULL, 'Diagnosis', 19, '0000-00-00', 19, '0000-00-00'),
(365, '- Mount Lenses as per IPD', NULL, 'Remarks', 19, '0000-00-00', 19, '0000-00-00'),
(366, 'Patient will need Retinal Surgery after 1 month under GVP', NULL, 'AdviceRemark', 19, '0000-00-00', 19, '0000-00-00'),
(367, 'Ref to VR Specialist for Opinion', NULL, 'ReferTo', 19, '0000-00-00', 19, '0000-00-00'),
(369, 'Automated Perimetry Test', NULL, 'InvSt', 19, '0000-00-00', 19, '0000-00-00'),
(370, 'A-Scan/B-Scan Charges', NULL, 'InvSt', 19, '0000-00-00', 19, '0000-00-00'),
(371, 'Fundus Photrography Charges ', NULL, 'InvSt', 19, '0000-00-00', 19, '0000-00-00'),
(372, 'Syringing -', NULL, 'InvSt', 19, '0000-00-00', 19, '0000-00-00'),
(373, 'B-Scan - 1k', NULL, 'InvSt', 19, '0000-00-00', 19, '0000-00-00'),
(374, 'Glaucoma Profile - 3k', NULL, 'InvSt', 19, '0000-00-00', 19, '0000-00-00'),
(375, 'Topography - 1k', NULL, 'InvSt', 19, '0000-00-00', 19, '0000-00-00'),
(376, 'Cunsultation Charges', NULL, 'InvSt', 19, '0000-00-00', 19, '0000-00-00'),
(378, 'LE YAG Capsulotomy Laser - 1.5k', NULL, 'InvSt', 19, '0000-00-00', 19, '0000-00-00'),
(379, 'Meibography And Expression - 1k', NULL, 'InvSt', 19, '0000-00-00', 19, '0000-00-00'),
(380, 'BE Yag Capsulotomy Laser Charges - 3k', NULL, 'InvSt', 19, '0000-00-00', 19, '0000-00-00'),
(381, 'OCT Line Scan - 1k', NULL, 'InvSt', 19, '0000-00-00', 19, '0000-00-00'),
(382, 'Convergence Normal / Insufficiency -', NULL, 'InvSt', 19, '0000-00-00', 19, '0000-00-00'),
(383, 'Axial Length', NULL, 'InvSt', 19, '0000-00-00', 19, '0000-00-00'),
(384, 'I Trace 1k', NULL, 'InvSt', 19, '0000-00-00', 19, '0000-00-00'),
(387, 'I-Trace Schirmer Meibography', NULL, 'InvSt', 19, '0000-00-00', 19, '0000-00-00'),
(389, 'Scaler Contact Lens Charges ', NULL, 'InvSt', 19, '0000-00-00', 19, '0000-00-00'),
(390, 'LE Phaco Surgery Charges ', NULL, 'InvSt', 19, '0000-00-00', 19, '0000-00-00'),
(393, 'Schirmer Test - 200', NULL, 'InvSt', 19, '0000-00-00', 19, '0000-00-00'),
(396, 'OU High Hypermetropia', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(397, 'OU High Myopia', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(398, 'OU Simple Myopic Astigmatism with Presbyopia', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(399, 'OU Simple Hypermetropic Astigmatism with Presbyopia', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(400, 'OU Immature Senile Cataract', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(402, 'Consider for Refractive Surgery', NULL, 'Advice', 19, NULL, 19, NULL),
(405, 'Dr. Sameer Ambadekar', NULL, 'Surgeon', 19, NULL, 19, NULL),
(406, 'Mr. Ajay Sherekar', NULL, 'Assistant', 19, NULL, 19, NULL),
(409, 'Dr. Ravi Khetan', NULL, 'Anaesthetist', 19, NULL, 19, NULL),
(411, 'RE Phaco Surgery with Toric Foldable IOL with CCI under Topical Anesthesia done by Dr. Pravin Vyawahare.', NULL, 'sugestedsurgery', 19, NULL, 19, NULL),
(412, 'Frequent Blinking', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(413, 'Referred back to Dr Kurhade for further treatment (No Evidence Of Papilloedema)', NULL, 'ReferTo', 19, NULL, 19, NULL),
(415, 'Yes - Bluerhex', NULL, 'Capstaining', 19, NULL, 19, NULL),
(416, '- Please make Bifocal glasses.', NULL, 'Remarks', 19, NULL, 19, NULL),
(417, '- Please make Progressive glasses.', NULL, 'Remarks', 19, NULL, 19, NULL),
(418, '- Make separate glasses for near & distance.', NULL, 'Remarks', 19, NULL, 19, NULL),
(419, 'Referred to ENT Specialist for Pain around Maxillary area', NULL, 'ReferTo', 19, NULL, 19, NULL),
(420, 'Refer to Neurologist / Physician for headache', NULL, 'ReferTo', 19, NULL, 19, NULL),
(421, 'Dr Sameer Ambadekar', NULL, 'AppConsultant', 19, NULL, 19, NULL),
(422, 'Squint Clinic', NULL, 'ReferFor', 19, NULL, 19, NULL),
(423, 'OU Presbyopia', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(424, 'OU Hypermetropia', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(425, '- Please make Bifocal / Progressive glasses as per patients choice.', NULL, 'Remarks', 19, NULL, 19, NULL),
(426, 'OU Hypermetropia with Presbyopia', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(427, 'Refer to Physician / Neurologist for Headache', NULL, 'Advice', 19, NULL, 19, NULL),
(428, 'Choroidal Coloboma', NULL, 'MidPerPh', 19, NULL, 19, NULL),
(429, 'Tessellated', NULL, 'MidPerPh', 19, NULL, 19, NULL),
(430, 'Refer to Physician / Neurologist for Headache', NULL, 'AdviceRemark', 19, NULL, 19, NULL),
(431, 'Consider for Refractive Surgery', NULL, 'AdviceRemark', 19, NULL, 19, NULL),
(432, 'Referred back to Dr Kurhade for further treatment   ( No evidence of Pappilloedema )', NULL, 'AdviceRemark', 19, NULL, 19, NULL),
(433, 'Opinion of Oculoplastic Surgeon', NULL, 'AdviceRemark', 19, NULL, 19, NULL),
(434, 'LE Phaco Surgery with  ERV (Extended Range of Vision) Foldable IOL with CCI under Topical Anesthesia done by Dr. Pravin Vyawahare.', NULL, 'sugestedsurgery', 19, NULL, 19, NULL),
(435, 'LE Phaco Surgery with Multifocal Foldable IOL with CCI Under Topical Anesthesia Done By Dr.Neeta  Vyawahare.', NULL, 'sugestedsurgery', 19, NULL, 19, NULL),
(436, '- Continue Same Glasses', NULL, 'Remarks', 19, NULL, 19, NULL),
(437, 'OU Compound Myopic Astigmatism', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(438, 'Cycloplegic refraction', NULL, 'InvSt', 19, NULL, 19, NULL),
(439, 'OU Blepharitis', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(440, 'Cellophane Maculopathy', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(441, 'Refer to Pediatrician  for Headache', NULL, 'Advice', 19, NULL, 19, NULL),
(443, '- Glasses given for Screen use / Please make glasses with Blue blocking and Antiglare coating lenses', NULL, 'Remarks', 19, NULL, 19, NULL),
(445, 'Referred to ENT Specialist for Pain in frontal region to rule out Frontal Sinusitis', NULL, 'AdviceRemark', 19, NULL, 19, NULL),
(446, 'Dr. Rutika Khadase', NULL, 'AppConsultant', 19, NULL, 19, NULL),
(447, '+0.25 Glasses given / Advice to wear during computer Use', NULL, 'AdviceRemark', 19, NULL, 19, NULL),
(448, 'Refer to Physician / Neurologist for Headache', NULL, 'ReferTo', 19, NULL, 19, NULL),
(449, 'Evaluation by Oculoplasty Surgeon', NULL, 'Advice', 19, NULL, 19, NULL),
(450, 'RE C3R Surgery done Under Topical Anesthesia Done By Dr. Pravin Vyawahare.', NULL, 'sugestedsurgery', 19, NULL, 19, NULL),
(451, 'LE Corneal Tattoing Under GVP under Local  Anesthesia done By Dr. Pravin Vyawahare', NULL, 'sugestedsurgery', 19, NULL, 19, NULL),
(452, 'LE Cyclocryo Surgery Under Local Anesthesia Done By Dr Pravin Vyawahare.', NULL, 'sugestedsurgery', 19, NULL, 19, NULL),
(453, 'BE PRK Surgery Under Topical Anesthesia Done at Laser Vision Center By Dr. Pravin Vyawahare.', NULL, 'sugestedsurgery', 19, NULL, 19, NULL),
(454, 'LE Evisceration Surgery Under Local Anesthesia Done By Dr. Pravin Vyawahare.', NULL, 'sugestedsurgery', 19, NULL, 19, NULL),
(455, 'RE PK Surgery Under  GVP under Local Anesthesia Done  By Dr Pravin Vyawahare.', NULL, 'sugestedsurgery', 19, NULL, 19, NULL),
(456, 'RE Phaco with Foldable IOL with Pterygium Exsicion with Conjunctival Transplantation with CCI Under Local  Anesthesia done by Dr. Pravin Vyawahare.', NULL, 'sugestedsurgery', 19, NULL, 19, NULL),
(457, 'RE LR RECESSION 9MM+ MR RESECTION 6.5 MM UNDER LA FDT NEGATIVE', NULL, 'OperationNotes', 19, NULL, 19, NULL),
(458, 'OU Myopia', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(459, 'LE Endonasal DCR Done Under Local Anesthesia.', NULL, 'sugestedsurgery', 19, NULL, 19, NULL),
(460, 'Abnormal Mass', NULL, 'Complaint', 19, NULL, 19, NULL),
(461, 'DOV For Distance', NULL, 'Complaint', 19, NULL, 19, NULL),
(462, 'DOV For Near', NULL, 'Complaint', 19, NULL, 19, NULL),
(463, 'Myopia Profile - 1.5 k', NULL, 'InvSt', 19, NULL, 19, NULL),
(464, 'OU High Myopia With Astigmatism', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(465, 'LE Phaco with Foldable IOL with Trabaculoctomy with inj Mytomycin c with CCI Under Local Anesthesia under GVP Done By Dr. Pravin Vyawahare.', NULL, 'sugestedsurgery', 19, NULL, 19, NULL),
(467, 'RE Probing Under Guarded Prognosis Under General Anesthesia done By Dr. Pravin Vyawahare.', NULL, 'sugestedsurgery', 19, NULL, 19, NULL),
(468, 'RE Pterygium Excision with Conjunctival Transplantation with CCI Under Local Anestheasia Done By Dr. Pravin Vyawahare.', NULL, 'sugestedsurgery', 19, NULL, 19, NULL),
(469, 'RE Secondary Iris Claw IOL Under GVP with CCI Under Local Anesthesia Done By Dr. Pravin Vyawahare.', NULL, 'sugestedsurgery', 19, NULL, 19, NULL),
(470, 'RE Phaco Surgery with Foldable IOL with CCI Under Topical Anesthesia Done By Dr. Pravin Vyawahare.', NULL, 'sugestedsurgery', 19, NULL, 19, NULL),
(471, 'RE C3R Surgery Under Topical Anesthesia Done By Dr. Pravin Vyawahare.', NULL, 'sugestedsurgery', 19, NULL, 19, NULL),
(472, 'Rahul Sachan', NULL, 'Assistant', 19, NULL, 19, NULL),
(473, 'Double Vision', NULL, 'Complaint', 19, NULL, 19, NULL),
(474, '- Needs Cycloplagic Refraction', NULL, 'Remarks', 19, NULL, 19, NULL),
(475, 'Dryness', NULL, 'Complaint', 19, NULL, 19, NULL),
(476, 'DR. APRAJITA SHINDE', NULL, 'AppConsultant', 19, NULL, 19, NULL),
(478, 'Corneal Scraping', NULL, 'InvSt', 19, NULL, 19, NULL),
(479, 'Adv.- Ref to Physician for Cantrol Blood sugar', NULL, 'otremark', 19, NULL, 19, NULL),
(480, 'Refer to Neurologist for ? Mysthenia Gravis ( Ice test positive )', NULL, 'Advice', 19, NULL, 19, NULL),
(482, 'OD Neuralgia ? Trigeminal', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(483, 'LE Intravitrial AntivegF Under GVP Given by Dr. Neeta Vyawahare.', NULL, 'sugestedsurgery', 19, NULL, 19, NULL),
(484, 'Refractive Profile - 2k', NULL, 'InvSt', 19, NULL, 19, NULL),
(485, 'Choroidal coloboma', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(488, 'Cataract Surgery by Phaco with IOL to deepen AC & revert angle closure and Pupilary block', NULL, 'OperationNotes', 19, NULL, 19, NULL),
(489, 'O  Sub Conjunctival Hemorrhage', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(490, 'Multiple hgs around superotemoral arcade and on macula superiorly', NULL, 'BV', 19, NULL, 19, NULL),
(491, 'Multiple hgs around inferotemoral arcade and on macula inferiorly', NULL, 'BV', 19, NULL, 19, NULL),
(492, 'Black eye', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(493, 'Refer to Psychiatrist', NULL, 'AdviceRemark', 19, NULL, 19, NULL),
(494, 'Dr. Swapnil Sharma', NULL, 'Surgeon', 19, NULL, 19, NULL),
(495, 'Colour Insufficiency', NULL, 'InvSt', 19, NULL, 19, NULL),
(496, 'Patient fir for discharge', NULL, 'SlitLamp', 19, NULL, 19, NULL),
(497, 'Refer to Physician / Neurologist for headache, (No Evidence Of Papilloedema)', NULL, 'Advice', 19, NULL, 19, NULL),
(498, 'RE Trabaculoctomy with inj Mytomycin c  under GVP under Local Anesthesia Done By Dr. Pravin Vyawahare.', NULL, 'sugestedsurgery', 19, NULL, 19, NULL),
(500, 'LE Phaco Surgery with Foldable IOL With CCI   Under Topical Anesthesia Done By Dr. Neeta Vyawahare.', NULL, 'sugestedsurgery', 19, NULL, 19, NULL),
(502, 'Dr. Aprajita Shinde', NULL, 'Surgeon', 19, NULL, 19, NULL),
(503, 'To protect eyes from Sun and Use UV Blocking Glasses', NULL, 'AdviceRemark', 19, NULL, 19, NULL),
(504, 'RE Phaco Surgery with Foldable IOL with CCI Under Topical Anesthesia Done By Dr. Pravin  Vyawahare.', NULL, 'sugestedsurgery', 19, NULL, 19, NULL),
(505, 'OU Pseudophakia', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(507, 'RE Phaco Surgery with Foldable IOL With Intravitrial AntivegF Under GVP under Topical Anesthesia With CCI  done By Dr. Pravin  Vyawahare.', NULL, 'sugestedsurgery', 19, NULL, 19, NULL),
(508, 'Gonio- Oppositional Closure , only SL seen , Opens up after indentation ,no synechiae ,pigmentation seen', NULL, 'InvSt', 19, NULL, 19, NULL),
(509, 'C/D Ratio 0.9', NULL, 'OptDisc', 19, NULL, 19, NULL),
(511, 'Opinion of Dr Tayade for genetic counselling about RP', NULL, 'AdviceRemark', 19, NULL, 19, NULL),
(512, 'Downs Syndrome', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(514, '- Please make glasses only for distance as per patients choice.', NULL, 'Remarks', 19, NULL, 19, NULL),
(515, 'LE Intravitrial AntivegF Under GVP Given by Dr. Pravin Vyawahare.', NULL, 'sugestedsurgery', 19, NULL, 19, NULL),
(516, 'LE Cataract Surgery by phaco with IOL to deepen AC & to revert angle closue and pupillary block.', NULL, 'sugestedsurgery', 19, NULL, 19, NULL),
(517, 'RE Phaco with Foldable IOL Under Local (R.B Block) Anesthesia Done By Dr. Pravin Vyawahare.', NULL, 'sugestedsurgery', 19, NULL, 19, NULL),
(518, 'OD Acute Glaucoma Sec to Angle Closure With Cataract', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(519, 'Squint Evaluation', NULL, 'Advice', 19, NULL, 19, NULL),
(520, 'Review in Paediatric Ophthalmology / Squint Clinic on Thursday at 2.30  pm', NULL, 'Advice', 19, NULL, 19, NULL),
(521, 'OD Evisceration with Implant followed by COP', NULL, 'Advice', 19, NULL, 19, NULL),
(522, 'RE Phakic Toric IOL with CCI Under Topical Anesthesia Done By Dr. Pravin Vyawahare.', NULL, 'sugestedsurgery', 19, NULL, 19, NULL),
(523, 'Early Cataract', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(524, 'Nasal Pterygium', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(525, 'H/of - Exposure to Calatropis Flower', NULL, 'OcularHistory', 19, NULL, 19, NULL),
(529, 'Eyecryal l Active Toric      Rahul', NULL, 'Project', 19, NULL, 19, NULL),
(530, 'Dr.  Ashok  Naredi', NULL, 'Anaesthetist', 19, NULL, 19, NULL),
(532, 'Consider IRPL Therapy for Meibomian Gland Dysfunction', NULL, 'Advice', 19, NULL, 19, NULL),
(533, 'Intermitted Exotropia', NULL, 'Advice', 19, NULL, 19, NULL),
(534, 'Please process for the cashless', NULL, 'ReferTo', 19, NULL, 19, NULL),
(535, 'Intermittent Exotropia', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(536, 'OS Cyst over Lacrimal gland ? Dacrops', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(538, 'vitreous cells', NULL, 'Media', 19, NULL, 19, NULL),
(539, 'inferior RD', NULL, 'MidPerPh', 19, NULL, 19, NULL),
(540, 'Micropthlamia', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(541, 'dystrophy', NULL, 'MacBV', 19, NULL, 19, NULL),
(543, 'Foveal reflex dull few hgs + ma++', NULL, 'MacBV', 19, NULL, 19, NULL),
(544, 'Refer to Rheumatologist', NULL, 'ReferTo', 19, NULL, 19, NULL),
(545, 'glasses', NULL, 'AdviceRemark', 19, NULL, 19, NULL),
(546, 'CBC, BLOOD SUGAR AND LIPID PROFILE, SERUM HOMOCYSTEINE', NULL, 'AdviceRemark', 19, NULL, 19, NULL),
(547, 'OS Pthisis Bulbi', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(548, 'Vision Prognosis Explained to the patient', NULL, 'Advice', 19, NULL, 19, NULL),
(549, 'Neuroimaging', NULL, 'InvSt', 19, NULL, 19, NULL),
(550, 'OD Inflammed Pinguecula', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(551, 'Syringing - 200', NULL, 'InvSt', 19, NULL, 19, NULL),
(553, 'Sphincter tear', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(554, 'Review for dilated examination', NULL, 'Advice', 19, NULL, 19, NULL),
(555, 'Arterial attenuation', NULL, 'BV', 19, NULL, 19, NULL),
(556, 'Sumit Sachan', NULL, 'Assistant', 19, NULL, 19, NULL),
(559, 'Endonasal DCLE R Sx Done on , Vyawahare Netralaya', NULL, 'OcularHistory', 19, NULL, 19, NULL),
(560, 'LE I/D Chalazion Local Anesthesia done By Dr. Pravin Vyawahare.', NULL, 'sugestedsurgery', 19, NULL, 19, NULL),
(561, 'OU Phakic IOL OS 1st under GVP', NULL, 'Advice', 19, NULL, 19, NULL),
(562, 'Pachymetry', NULL, 'InvSt', 19, NULL, 19, NULL),
(563, 'OS Eviscerated Eye', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(564, 'Compound Hypermetropic Astigmatism', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(565, 'Mature Cataract', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(566, 'K /C OF DM / HT', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(567, 'Recurrent Nasal Pterygium', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(568, 'OS Recurrent Nodular Scleritis', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(570, 'OD Acute  Dacryocystitis', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(571, 'OD  Post Op Uveitis', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(572, 'Schirmer then Meibography  1k', NULL, 'InvSt', 19, NULL, 19, NULL),
(573, 'Review for Squint Clinic on Monday / Thursday at 2.00 pm', NULL, 'Advice', 19, NULL, 19, NULL),
(574, 'Consider for Refractive Surgery ( Phakic Toric IOL )', NULL, 'Advice', 19, NULL, 19, NULL),
(575, 'OU Allergic Lid oedema with conjunctivitis', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(576, 'OD Acute Anterior Uveitis with Hypopyon', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(577, 'Gonio - Angle Open', NULL, 'InvSt', 19, NULL, 19, NULL),
(578, 'OD Congenital Dacryocystitis', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(580, 'few microanurysm seen on post pole', NULL, 'BV', 19, NULL, 19, NULL),
(581, 'few microanurysm / hard exudates seen on post pole', NULL, 'BV', 19, NULL, 19, NULL),
(582, 'Multiple microanurysm / hard exudates / soft exudates seen on post pole ++', NULL, 'BV', 19, NULL, 19, NULL),
(583, 'Gonio - Total angle closure with 360 degrees synecheia', NULL, 'InvSt', 19, NULL, 19, NULL),
(584, 'OU Post Subcapsular Cataract', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(585, 'OU Myopic Astigmatism with Presbyopia', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(586, 'OU  Optic Disc Pallor', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(587, 'OS Traumatic Cataract with Iridodialysis', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(588, 'LE Pterygium Surgery done Elsewhere', NULL, 'OcularHistory', 19, NULL, 19, NULL),
(589, 'Congenital Moderate Ptosis', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(590, 'SEVERE HEADACHE', NULL, 'Complaint', 19, NULL, 19, NULL),
(591, 'Review for dilated examination', NULL, 'AdviceRemark', 19, NULL, 19, NULL),
(592, 'Mild NPDR', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(593, '- Glasses given for only near use', NULL, 'Remarks', 19, NULL, 19, NULL),
(594, 'Dry Eye Profile - 1 k', NULL, 'InvSt', 19, NULL, 19, NULL),
(595, 'Lattice Degeneration', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(596, 'Fuck\'s Endothelial dystrophy', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(597, 'Barrage laser Done', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(598, 'O YAG Capsulotomy done on', NULL, 'Advice', 19, NULL, 19, NULL),
(599, 'O  Corneal FB', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(600, 'OD Scleritis', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(601, '? Duane\'s retraction syndrome', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(602, 'Review For Dilated Examination', NULL, 'AdviceRemark', 19, NULL, 19, NULL),
(603, 'OS  ST  Tributary vein Occlusion', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(604, 'OU Involution Entropion', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(605, 'Review for evaluation for pupil', NULL, 'Advice', 19, NULL, 19, NULL),
(606, 'Hypertropia', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(607, 'S/p RD Surgery with Barrage laser', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(609, 'Adv- Blood Sugar F/PP ,Lipid Profile .Serum Homocystine,ESR  Physician checkup for systemic risk factor control : DM ,BP,,Cardiovascular evaluation', NULL, 'Advice', 19, NULL, 19, NULL),
(610, 'OS Axial Proptosis', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(612, 'OU Compound Hypermetropic Astigmatism', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(613, 'OS Corneal Ulcer ? Fungal', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(614, 'Meibography - 1k', NULL, 'InvSt', 19, NULL, 19, NULL),
(615, 'OU Simple Hypermetropic Astigmatism', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(616, 'K/c of DM / HT', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(617, 'OS Stromal Keratitis', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(618, 'OCT in Glaucoma mode / OCT Pachy - 1.5k', NULL, 'InvSt', 19, NULL, 19, NULL),
(619, 'Lid Echymosis', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(620, 'Restrict mobile use ,More outdoor activity', NULL, 'Advice', 19, NULL, 19, NULL),
(621, 'OD Recurrent Chalazion', NULL, 'Diagnosis', 19, NULL, 19, NULL);
INSERT INTO `tbl_decriptions` (`id`, `Description`, `GlassRate`, `Type`, `CreatedBy`, `CreatedDate`, `ModifiedBy`, `ModifiedDate`) VALUES
(622, 'Optic Disc pallor', NULL, 'OptDisc', 19, NULL, 19, NULL),
(623, 'Fields / OCT Line Scan - 2k', NULL, 'InvSt', 19, NULL, 19, NULL),
(624, 'SOS Probing under short GA', NULL, 'Advice', 19, NULL, 19, NULL),
(625, 'OCT in Glaucoma Mode  . line scan  , Pachy - 1.5 k', NULL, 'InvSt', 19, NULL, 19, NULL),
(626, 'Few hgs and few ma seen on post pole', NULL, 'BV', 19, NULL, 19, NULL),
(628, 'Asteroid Hyalosis', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(629, 'Herpes Zoster Ophthalmicus', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(630, 'Dr. Sapna Agrawal', NULL, 'Anaesthetist', 19, NULL, 19, NULL),
(631, 'BE Lasik surgery under Topical Anesthesia done at Vision laser center by Dr. Pravin Vyawahare.', NULL, 'sugestedsurgery', 19, NULL, 19, NULL),
(632, 'Referred back to Dr Kurhade for further treatment  ( No Evidence Of Papilloedema / No Ophthalmic cause for Headache)', NULL, 'Advice', 19, NULL, 19, NULL),
(633, 'OS Phtisis Bulbi', NULL, 'Advice', 19, NULL, 19, NULL),
(634, 'OS Phtisis Bulbi', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(635, 'SYRUP COMBIFLAM 5 ML', NULL, 'Advice', 19, NULL, 19, NULL),
(636, 'OD Esotropia with Amblyopia', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(637, 'Fundus Photography', NULL, 'InvSt', 19, NULL, 19, NULL),
(638, '- Separate Glass for near use', NULL, 'Remarks', 19, NULL, 19, NULL),
(639, 'Blinking of eyes', NULL, 'Complaint', 19, NULL, 19, NULL),
(640, 'Dilated Examination on the day of surgery', NULL, 'AdviceRemark', 19, NULL, 19, NULL),
(641, '+0.25 D Glasses give for reading to reduce eye strain , May not use for distance', NULL, 'Remarks', 19, NULL, 19, NULL),
(643, 'Multiple hgs on post pole +', NULL, 'BV', 19, NULL, 19, NULL),
(644, 'Inj Botox for Hemifacial spasm', NULL, 'Advice', 19, NULL, 19, NULL),
(645, 'LE Blepharospasm with Hemifacial spasm', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(646, 'Discomfort', NULL, 'Complaint', 19, NULL, 19, NULL),
(647, 'OS Mydriatic Pupil ? cause', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(648, 'OU Photic Keratitis sec to Welding Arc Light exposure', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(650, 'OCT in Glaucoma mode , Progression Analysis - 1k', NULL, 'InvSt', 19, NULL, 19, NULL),
(651, 'CBC/ESR/RA FACTOR/ Montoux Test / ANA /HLA B 27', NULL, 'Advice', 19, NULL, 19, NULL),
(652, 'Puffy eyes', NULL, 'Complaint', 19, NULL, 19, NULL),
(653, 'OU Atypical coloboma with Microcornea', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(654, 'OS Allergic Lid Oedema with Conj chemosis', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(655, 'Vertigo ? Cause', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(656, 'Refer to Physician / Neurologist for Vertigo & Headache', NULL, 'Advice', 19, NULL, 19, NULL),
(657, 'Full EDOF / M-EDF-2/ 14-05-24', NULL, 'Project', 19, NULL, 19, NULL),
(658, 'Deviation of eye', NULL, 'Complaint', 19, NULL, 19, NULL),
(659, 'Swelling upper eye lid', NULL, 'Complaint', 19, NULL, 19, NULL),
(660, 'Swelling lower eye lid', NULL, 'Complaint', 19, NULL, 19, NULL),
(661, 'Dr. Rutika Lokhande', NULL, 'Surgeon', 19, NULL, 19, NULL),
(662, 'Vitreous Floaters', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(663, 'Consider for scleral lens', NULL, 'Advice', 19, NULL, 19, NULL),
(664, 'First session of  IRPL Therapy done on', NULL, 'Advice', 19, NULL, 19, NULL),
(665, 'Second session of  IRPL Therapy done on', NULL, 'Advice', 19, NULL, 19, NULL),
(666, 'Third session of  IRPL Therapy done on', NULL, 'Advice', 19, NULL, 19, NULL),
(667, 'Fourth session of  IRPL Therapy done on', NULL, 'Advice', 19, NULL, 19, NULL),
(668, 'OS Corneal epithelial erosion', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(670, 'OU Posterior Polar Cataract', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(671, 'Headache / Vertigo ? Cause', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(672, 'High Myopia With Astigmatism', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(673, 'High Hypermetropia With Astigmatism', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(674, 'O  Chalazion', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(675, 'OU YAG PI Under GVP done on', NULL, 'Advice', 19, NULL, 19, NULL),
(677, 'EYECRYL TORIC   06-24', NULL, 'Project', 19, NULL, 19, NULL),
(678, 'Eye strain', NULL, 'Complaint', 19, NULL, 19, NULL),
(679, 'Dr. Anup Chandak.', NULL, 'Surgeon', 19, NULL, 19, NULL),
(680, '- Needs protective glasses', NULL, 'Remarks', 19, NULL, 19, NULL),
(681, 'MD-TRC Toric Monofocal29/06/2024', NULL, 'Project', 19, NULL, 19, NULL),
(682, 'Schirmer 1 - RE 3 mm / LE -3 mm /  Schirmer 2 - RE 2 mm / LE -2 mm', NULL, 'InvSt', 19, NULL, 19, NULL),
(683, 'BE Operated  For  Lasik  on, Came for followup', NULL, 'OcularHistory', 19, NULL, 19, NULL),
(684, 'came for retina clinic', NULL, 'Complaint', 19, NULL, 19, NULL),
(685, 'MM-DIFF MULTIFOCAL', NULL, 'Project', 19, NULL, 19, NULL),
(686, '+0.25 number given to reduce eyestrain on computer.', NULL, 'Advice', 19, NULL, 19, NULL),
(687, 'Stickiness of lids', NULL, 'Complaint', 19, NULL, 19, NULL),
(688, 'Scotoma', NULL, 'Complaint', 19, NULL, 19, NULL),
(689, 'Advance Cataract', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(690, 'Patient can be considered for Myopic Glasses', NULL, 'Advice', 19, NULL, 19, NULL),
(691, 'OU Vernal Keratoconjunctivitis', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(692, 'OU Allergic Rhino conjunctivitis', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(693, 'Cr. Scrape/ Dark Goggle/Blood Sugar R 1k', NULL, 'InvSt', 19, NULL, 19, NULL),
(694, 'BE PRK Surgery Done At Vn', NULL, 'OcularHistory', 19, NULL, 19, NULL),
(695, 'O RD Surgery Done At', NULL, 'OcularHistory', 19, NULL, 19, NULL),
(696, 'OU Sup Limbic Conjunctivitis', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(697, 'Fields - 1.5k', NULL, 'InvSt', 19, NULL, 19, NULL),
(698, 'P.V', NULL, 'Surgeon', 19, NULL, 19, NULL),
(699, 'N.V.', NULL, 'Surgeon', 19, NULL, 19, NULL),
(700, 'Dr.  Swanand Lunge (Physician)', NULL, 'Anaesthetist', 19, NULL, 19, NULL),
(701, 'Glasses prescribed', NULL, 'Advice', 19, NULL, 19, NULL),
(702, 'Fatigue', NULL, 'Complaint', 19, NULL, 19, NULL),
(703, 'Light sensitivity', NULL, 'Complaint', 19, NULL, 19, NULL),
(704, 'RE Phaco Surgery with Multifocal Foldable IOL with CCI Under Topical Anesthesia Done By Dr. Pravin  Vyawahare.', NULL, 'sugestedsurgery', 19, NULL, 19, NULL),
(705, 'Tortuous blood vessels', NULL, 'BV', 19, NULL, 19, NULL),
(706, '- Please Make Photochromic Glasses as per Patients choice.', NULL, 'Remarks', 19, NULL, 19, NULL),
(708, 'Refer to Neurologist  for pain around right eye', NULL, 'Advice', 19, NULL, 19, NULL),
(709, 'Arus Senilis', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(710, 'OS Microsporodial Keratoconjunctivitis', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(711, 'Steriport total', NULL, 'Irrigatingsol', 19, NULL, 19, NULL),
(712, 'Colored halos seen around light at night', NULL, 'Complaint', 19, NULL, 19, NULL),
(713, 'Review early  in case of any complains or emergency', NULL, 'Advice', 19, NULL, 19, NULL),
(714, 'LE Phaco Surgery with  Toric ERV (Extended Range of Vision) Foldable IOL with CCI under Topical Anesthesia done by Dr. Pravin Vyawahare.', NULL, 'sugestedsurgery', 19, NULL, 19, NULL),
(715, 'Patient has history of headache 2 times in a month ,half sided , triggers after traveling and fasting for 2/3 hours', NULL, 'Complaint', 19, NULL, 19, NULL),
(716, 'OCT Line Scan - Free', NULL, 'InvSt', 19, NULL, 19, NULL),
(717, 'OCT Line Scan , EMM5 - 1k', NULL, 'InvSt', 19, NULL, 19, NULL),
(718, 'IP-600 monofocal 14/12/24', NULL, 'Project', 19, NULL, 19, NULL),
(719, 'TBUT  / Interferometry / Schirmer / Meibography', NULL, 'InvSt', 19, NULL, 19, NULL),
(720, 'Dr. Harish Shriramwar', NULL, 'Anaesthetist', 19, NULL, 19, NULL),
(721, 'Topography / OCT Pachy - 2k', NULL, 'InvSt', 19, NULL, 19, NULL),
(722, 'right eye surgery', NULL, 'InvSt', 19, NULL, 19, NULL),
(723, 'crvo', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(724, 'Vomiting sensation', NULL, 'Complaint', 19, NULL, 19, NULL),
(725, 'Refer to Physician / Neurologist for Headache ( No Evidence Of Papilledema / No Ophthalmic cause for Headache)', NULL, 'Advice', 19, NULL, 19, NULL),
(726, 'conjunctivical cyst', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(727, 'dry eyes', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(728, 'Transient swelling after itching', NULL, 'Complaint', 19, NULL, 19, NULL),
(729, 'refer to neurophysicisn for headache', NULL, 'AdviceRemark', 19, NULL, 19, NULL),
(730, 'myopia', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(731, 'foreign body', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(732, 'psuedophakia', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(733, 'traumatic hyphaema left eye', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(734, 'chemical injury', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(735, 'To Use Eylys Mask and give demo', NULL, 'Advice', 19, NULL, 19, NULL),
(737, 'Fundus Photography / OCT Line Scan - 1.5k', NULL, 'InvSt', 19, NULL, 19, NULL),
(738, 'Frequent Blinking ? Transient Tic Disorder ( Habitual Tics)', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(739, 'RE Intra Vitrial Antivegf Inj Done At VN', NULL, 'OcularHistory', 19, NULL, 19, NULL),
(740, 'corneal opacity right', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(741, 'Axial Length measurement 1k', NULL, 'InvSt', 19, NULL, 19, NULL),
(742, 'iridocyclitis right eye', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(743, 'Continue Same Glasses', NULL, 'Advice', 19, NULL, 19, NULL),
(744, 'Full EDOF TORIC M /20-05-2025', NULL, 'Project', 19, NULL, 19, NULL),
(745, 'myopic astigmatism', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(746, 'Gonio - No Angle Structure Seen', NULL, 'InvSt', 19, NULL, 19, NULL),
(747, 'Dr. Anup Wasankar', NULL, 'Anaesthetist', 19, NULL, 19, NULL),
(748, 'OS Corneal FB removed , rust ring removed with Algar Brush on', NULL, 'Advice', 19, NULL, 19, NULL),
(749, 'DeStrain therapy by BYNOCS', NULL, 'Advice', 19, NULL, 19, NULL),
(750, 'Vertigo', NULL, 'Complaint', 19, NULL, 19, NULL),
(751, '- Consider for High Index glasses', NULL, 'Remarks', 19, NULL, 19, NULL),
(752, 'Hallucinations', NULL, NULL, 19, NULL, 19, NULL),
(753, 'Patient old glasses has worn out ,wanted to make new', NULL, 'Complaint', 19, NULL, 19, NULL),
(754, 'Dr. Nilesh Badukale', NULL, 'Anaesthetist', 19, NULL, 19, NULL),
(755, 'Progressive Axial Myopia', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(756, 'Please counsel for Cataract Surgery', NULL, 'ReferTo', 19, NULL, 19, NULL),
(757, 'PCO Project Natural HD 31-10-2025', NULL, 'Project', 19, NULL, 19, NULL),
(758, 'Twitching Of Eye Lid', NULL, 'Complaint', 19, NULL, 19, NULL),
(759, 'Please Explain Bifocal Glasses', NULL, 'ReferTo', 19, NULL, 19, NULL),
(760, 'Please Explain Allergy', NULL, 'ReferTo', 19, NULL, 19, NULL),
(761, 'Please Explain Progressive Glasses', NULL, 'ReferTo', 19, NULL, 19, NULL),
(762, 'Please Explain Myopia Progression & Instruction', NULL, 'ReferTo', 19, NULL, 19, NULL),
(763, '- As per patients choice please make Glasses only for distance and remove glasses for near work', NULL, 'Remarks', 19, NULL, 19, NULL),
(764, 'methotrexate', NULL, 'Diagnosis', 19, NULL, 19, NULL),
(765, 'Dr. Tejal Gawande', NULL, 'Anaesthetist', 19, NULL, 19, NULL),
(766, 'Foveal Reflex Dull Few Drusens+  Tessalated', NULL, 'MacBV', 19, NULL, 19, NULL),
(767, 'Dry Eyes', NULL, 'Complaint', 19, NULL, 19, NULL),
(768, 'Difficulty in Night Vision', NULL, 'OcularHistory', 19, NULL, 19, NULL),
(769, 'O Trab Surgery Done At', NULL, 'OcularHistory', 19, NULL, 19, NULL),
(770, 'Patient may perceive folater after surgery because of PVD  Explained to patient', NULL, 'AdviceRemark', 19, NULL, 19, NULL),
(771, 'H/O C3R Surgery Done At', NULL, 'OcularHistory', 19, NULL, 19, NULL),
(772, 'Sticky Eyes', NULL, 'Complaint', 19, NULL, 19, NULL),
(773, 'H/O  Thyroid disorder since 5-6 years back', NULL, 'OcularHistory', 19, NULL, 19, NULL),
(774, 'Type of Discharge: Discharge to Home/ DAMA/LAMA/ Death/ Transferred to other Hospital', NULL, 'SlitLamp', 19, NULL, 19, NULL),
(775, 'DR Sanjay Mahatpure', NULL, 'Anaesthetist', 19, NULL, 19, NULL),
(776, 'sdsds', NULL, 'special_instrcuton', 34, '2026-05-12', 0, NULL),
(777, 'ggg', 100.00, 'GlassName', 35, '2026-06-22', 35, '2026-06-22'),
(778, 'test', NULL, 'OptoSendRemark', 34, '2026-06-29', 0, NULL);

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

--
-- Table structure for table `tbl_dischargecards`
--

CREATE TABLE `tbl_dischargecards` (
  `id` bigint NOT NULL,
  `IpdNo` int NOT NULL,
  `MrdNo` varchar(100) DEFAULT NULL,
  `PatientName` varchar(255) DEFAULT NULL,
  `AgeGender` varchar(100) DEFAULT NULL,
  `Mobile` varchar(100) DEFAULT NULL,
  `Address` text,
  `AdmissionDate` date DEFAULT NULL,
  `AdmissionTime` varchar(100) DEFAULT NULL,
  `OperationDate` date DEFAULT NULL,
  `OperationTime` varchar(100) DEFAULT NULL,
  `DischargeDate` date DEFAULT NULL,
  `DischargeTime` varchar(100) DEFAULT NULL,
  `FollowUpDate1` date DEFAULT NULL,
  `Diagnosis` text,
  `OtNotes` varchar(255) DEFAULT NULL,
  `OptEye` varchar(255) DEFAULT NULL,
  `SurgeryPerformed` varchar(255) DEFAULT NULL,
  `CondDischarge` varchar(255) DEFAULT NULL,
  `cmbbsrandom` varchar(255) DEFAULT NULL,
  `txtbsfasting` varchar(255) DEFAULT NULL,
  `cmbusrandom` varchar(255) DEFAULT NULL,
  `txtusfasting` varchar(255) DEFAULT NULL,
  `cmbhbsag` varchar(255) DEFAULT NULL,
  `txtbp` varchar(255) DEFAULT NULL,
  `cmbbspostmeal` varchar(255) DEFAULT NULL,
  `txtbspostmeal` varchar(255) DEFAULT NULL,
  `cmbuspostmeal` varchar(255) DEFAULT NULL,
  `txtuspostmeal` varchar(255) DEFAULT NULL,
  `cmbecg` varchar(255) DEFAULT NULL,
  `cmbhiv` varchar(255) DEFAULT NULL,
  `txtfitnessby` varchar(255) DEFAULT NULL,
  `txtother` varchar(255) DEFAULT NULL,
  `IolPower` varchar(255) DEFAULT NULL,
  `CylToric` varchar(255) DEFAULT NULL,
  `Axis` varchar(255) DEFAULT NULL,
  `Multifocal` varchar(255) DEFAULT NULL,
  `Constant` varchar(255) DEFAULT NULL,
  `IopRe` varchar(255) DEFAULT NULL,
  `IopLe` varchar(255) DEFAULT NULL,
  `Status` tinyint(1) DEFAULT '1',
  `CreatedBy` int DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT '0',
  `updated_at` datetime DEFAULT NULL,
  `txtremark` text,
  `OperationNotes` text,
  `SlitLamp` text,
  `IolPowerRe` varchar(100) DEFAULT NULL,
  `IolPowerLe` varchar(100) DEFAULT NULL,
  `StickerPrint` int DEFAULT '0',
  `CreatedTime` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbl_dischargecards`
--

INSERT INTO `tbl_dischargecards` (`id`, `IpdNo`, `MrdNo`, `PatientName`, `AgeGender`, `Mobile`, `Address`, `AdmissionDate`, `AdmissionTime`, `OperationDate`, `OperationTime`, `DischargeDate`, `DischargeTime`, `FollowUpDate1`, `Diagnosis`, `OtNotes`, `OptEye`, `SurgeryPerformed`, `CondDischarge`, `cmbbsrandom`, `txtbsfasting`, `cmbusrandom`, `txtusfasting`, `cmbhbsag`, `txtbp`, `cmbbspostmeal`, `txtbspostmeal`, `cmbuspostmeal`, `txtuspostmeal`, `cmbecg`, `cmbhiv`, `txtfitnessby`, `txtother`, `IolPower`, `CylToric`, `Axis`, `Multifocal`, `Constant`, `IopRe`, `IopLe`, `Status`, `CreatedBy`, `created_at`, `ModifiedBy`, `updated_at`, `txtremark`, `OperationNotes`, `SlitLamp`, `IolPowerRe`, `IolPowerLe`, `StickerPrint`, `CreatedTime`) VALUES
(1, 1, '1', 'Mr. Rajat Padmakar Dhanwalkar', '32/Male', '9595454907', 'Ayodhaynagar, Nagpur', '2026-07-08', NULL, '2026-07-08', NULL, '2026-07-08', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 19, '2026-07-08 20:38:09', 19, '2026-07-08 20:38:09', NULL, NULL, NULL, NULL, NULL, 0, NULL),
(2, 2, '1', 'Mr. Rajat Padmakar Dhanwalkar', '32/Male', '9595454907', 'Ayodhaynagar, Nagpur', '2026-07-08', NULL, '2026-07-08', NULL, '2026-07-08', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 19, '2026-07-08 20:43:04', 19, '2026-07-08 20:43:04', NULL, NULL, NULL, NULL, NULL, 0, NULL),
(3, 1, '4', 'MR. AJAY SHEREKAR', '27/Male', NULL, 'Ashok Colony', '2020-05-30', NULL, '2020-05-30', NULL, '2020-05-30', NULL, '2020-05-30', 'BE CATARACT', NULL, NULL, NULL, NULL, NULL, '111 MG/DL', NULL, NULL, NULL, '120/80', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'RE-12 LE-12', NULL, 1, 19, '2026-07-08 23:22:05', 19, '2026-07-08 23:22:05', NULL, 'RE PHACHO WITH FOLDABLE IOL', NULL, NULL, NULL, 0, NULL),
(4, 14436, '1', 'Mr. Rajat Padmakar Dhanwalkar', '32/Male', '9595454907', 'Ayodhaynagar, Nagpur', '2026-07-08', NULL, '2026-07-08', NULL, '2026-07-08', NULL, '2026-07-08', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 19, '2026-07-08 23:25:33', 19, '2026-07-08 23:25:33', NULL, NULL, NULL, NULL, NULL, 0, NULL);

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

--
-- Table structure for table `tbl_dischargecards_other`
--

CREATE TABLE `tbl_dischargecards_other` (
  `id` bigint NOT NULL,
  `IpdNo` int NOT NULL,
  `MrdNo` varchar(100) DEFAULT NULL,
  `PatientName` varchar(255) DEFAULT NULL,
  `AgeGender` varchar(100) DEFAULT NULL,
  `Mobile` varchar(100) DEFAULT NULL,
  `Address` text,
  `AdmissionDate` date DEFAULT NULL,
  `AdmissionTime` varchar(100) DEFAULT NULL,
  `OperationDate` date DEFAULT NULL,
  `OperationTime` varchar(100) DEFAULT NULL,
  `DischargeDate` date DEFAULT NULL,
  `DischargeTime` varchar(100) DEFAULT NULL,
  `FollowUpDate1` date DEFAULT NULL,
  `Diagnosis` text,
  `OtNotes` varchar(255) DEFAULT NULL,
  `OptEye` varchar(255) DEFAULT NULL,
  `SurgeryPerformed` varchar(255) DEFAULT NULL,
  `CondDischarge` varchar(255) DEFAULT NULL,
  `cmbbsrandom` varchar(255) DEFAULT NULL,
  `txtbsfasting` varchar(255) DEFAULT NULL,
  `cmbusrandom` varchar(255) DEFAULT NULL,
  `txtusfasting` varchar(255) DEFAULT NULL,
  `cmbhbsag` varchar(255) DEFAULT NULL,
  `txtbp` varchar(255) DEFAULT NULL,
  `cmbbspostmeal` varchar(255) DEFAULT NULL,
  `txtbspostmeal` varchar(255) DEFAULT NULL,
  `cmbuspostmeal` varchar(255) DEFAULT NULL,
  `txtuspostmeal` varchar(255) DEFAULT NULL,
  `cmbecg` varchar(255) DEFAULT NULL,
  `cmbhiv` varchar(255) DEFAULT NULL,
  `txtfitnessby` varchar(255) DEFAULT NULL,
  `txtother` varchar(255) DEFAULT NULL,
  `IolPower` varchar(255) DEFAULT NULL,
  `CylToric` varchar(255) DEFAULT NULL,
  `Axis` varchar(255) DEFAULT NULL,
  `Multifocal` varchar(255) DEFAULT NULL,
  `Constant` varchar(255) DEFAULT NULL,
  `IopRe` varchar(255) DEFAULT NULL,
  `IopLe` varchar(255) DEFAULT NULL,
  `Status` tinyint(1) DEFAULT '1',
  `CreatedBy` int DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `ModifiedBy` int DEFAULT '0',
  `updated_at` datetime DEFAULT NULL,
  `txtremark` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `tbl_discharge_treatments`
--

CREATE TABLE `tbl_discharge_treatments` (
  `id` int NOT NULL,
  `PostId` int DEFAULT NULL,
  `Eye` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `MrdNo` bigint DEFAULT NULL,
  `VisitNo` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `VisitDate` date DEFAULT NULL,
  `Treatment` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TreatType1` text COLLATE utf8mb4_general_ci,
  `TreatName1` text COLLATE utf8mb4_general_ci,
  `TreatDose1` text COLLATE utf8mb4_general_ci,
  `TreatFreq1` text COLLATE utf8mb4_general_ci,
  `TreatDur1` text COLLATE utf8mb4_general_ci,
  `TreatEye1` text COLLATE utf8mb4_general_ci,
  `TreatType2` text COLLATE utf8mb4_general_ci,
  `TreatName2` text COLLATE utf8mb4_general_ci,
  `TreatDose2` text COLLATE utf8mb4_general_ci,
  `TreatFreq2` text COLLATE utf8mb4_general_ci,
  `TreatDur2` text COLLATE utf8mb4_general_ci,
  `TreatEye2` text COLLATE utf8mb4_general_ci,
  `TreatType3` text COLLATE utf8mb4_general_ci,
  `TreatName3` text COLLATE utf8mb4_general_ci,
  `TreatDose3` text COLLATE utf8mb4_general_ci,
  `TreatFreq3` text COLLATE utf8mb4_general_ci,
  `TreatDur3` text COLLATE utf8mb4_general_ci,
  `TreatEye3` text COLLATE utf8mb4_general_ci,
  `TreatType4` text COLLATE utf8mb4_general_ci,
  `TreatName4` text COLLATE utf8mb4_general_ci,
  `TreatDose4` text COLLATE utf8mb4_general_ci,
  `TreatFreq4` text COLLATE utf8mb4_general_ci,
  `TreatDur4` text COLLATE utf8mb4_general_ci,
  `TreatEye4` text COLLATE utf8mb4_general_ci,
  `TreatType5` text COLLATE utf8mb4_general_ci,
  `TreatName5` text COLLATE utf8mb4_general_ci,
  `TreatDose5` text COLLATE utf8mb4_general_ci,
  `TreatFreq5` text COLLATE utf8mb4_general_ci,
  `TreatDur5` text COLLATE utf8mb4_general_ci,
  `TreatEye5` text COLLATE utf8mb4_general_ci,
  `TreatType6` text COLLATE utf8mb4_general_ci,
  `TreatName6` text COLLATE utf8mb4_general_ci,
  `TreatDose6` text COLLATE utf8mb4_general_ci,
  `TreatFreq6` text COLLATE utf8mb4_general_ci,
  `TreatDur6` text COLLATE utf8mb4_general_ci,
  `TreatEye6` text COLLATE utf8mb4_general_ci,
  `TreatType7` text COLLATE utf8mb4_general_ci,
  `TreatName7` text COLLATE utf8mb4_general_ci,
  `TreatDose7` text COLLATE utf8mb4_general_ci,
  `TreatFreq7` text COLLATE utf8mb4_general_ci,
  `TreatDur7` text COLLATE utf8mb4_general_ci,
  `TreatEye7` text COLLATE utf8mb4_general_ci,
  `TreatType8` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TreatName8` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TreatDose8` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TreatFreq8` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TreatDur8` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TreatEye8` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TreatChk9` text COLLATE utf8mb4_general_ci,
  `TreatType9` text COLLATE utf8mb4_general_ci,
  `TreatName9` text COLLATE utf8mb4_general_ci,
  `TreatDose9` text COLLATE utf8mb4_general_ci,
  `TreatFreq9` text COLLATE utf8mb4_general_ci,
  `TreatDur9` text COLLATE utf8mb4_general_ci,
  `TreatEye9` text COLLATE utf8mb4_general_ci,
  `TreatChk10` text COLLATE utf8mb4_general_ci,
  `TreatType10` text COLLATE utf8mb4_general_ci,
  `TreatName10` text COLLATE utf8mb4_general_ci,
  `TreatDose10` text COLLATE utf8mb4_general_ci,
  `TreatFreq10` text COLLATE utf8mb4_general_ci,
  `TreatDur10` text COLLATE utf8mb4_general_ci,
  `TreatEye10` text COLLATE utf8mb4_general_ci,
  `TreatChk11` text COLLATE utf8mb4_general_ci,
  `TreatType11` text COLLATE utf8mb4_general_ci,
  `TreatName11` text COLLATE utf8mb4_general_ci,
  `TreatDose11` text COLLATE utf8mb4_general_ci,
  `TreatFreq11` text COLLATE utf8mb4_general_ci,
  `TreatDur11` text COLLATE utf8mb4_general_ci,
  `TreatEye11` text COLLATE utf8mb4_general_ci,
  `TreatChk12` text COLLATE utf8mb4_general_ci,
  `TreatType12` text COLLATE utf8mb4_general_ci,
  `TreatName12` text COLLATE utf8mb4_general_ci,
  `TreatDose12` text COLLATE utf8mb4_general_ci,
  `TreatFreq12` text COLLATE utf8mb4_general_ci,
  `TreatDur12` text COLLATE utf8mb4_general_ci,
  `TreatEye12` text COLLATE utf8mb4_general_ci,
  `TreatChk13` text COLLATE utf8mb4_general_ci,
  `TreatType13` text COLLATE utf8mb4_general_ci,
  `TreatName13` text COLLATE utf8mb4_general_ci,
  `TreatDose13` text COLLATE utf8mb4_general_ci,
  `TreatFreq13` text COLLATE utf8mb4_general_ci,
  `TreatDur13` text COLLATE utf8mb4_general_ci,
  `TreatEye13` text COLLATE utf8mb4_general_ci,
  `TreatChk1` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '0',
  `TreatChk2` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '0',
  `TreatChk3` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '0',
  `TreatChk4` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '0',
  `TreatChk5` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '0',
  `TreatChk6` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '0',
  `TreatChk7` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '0',
  `TreatChk8` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '0',
  `TreatDate1` date DEFAULT NULL,
  `TreatDate2` date DEFAULT NULL,
  `TreatDate3` date DEFAULT NULL,
  `TreatDate4` date DEFAULT NULL,
  `TreatDate5` date DEFAULT NULL,
  `TreatDate6` date DEFAULT NULL,
  `TreatDate7` date DEFAULT NULL,
  `TreatDate8` date DEFAULT NULL,
  `TreatDate9` date DEFAULT NULL,
  `TreatDate10` date DEFAULT NULL,
  `TreatDate11` date DEFAULT NULL,
  `TreatDate12` date DEFAULT NULL,
  `TreatDate13` date DEFAULT NULL,
  `Tapchk1` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Tapchk2` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Tapchk3` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Tapchk4` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Tapchk5` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Tapchk6` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Tapchk7` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Tapchk8` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Tapchk9` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Tapchk10` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Tapchk11` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Tapchk12` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Tapchk13` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_discharge_treatments`
--

INSERT INTO `tbl_discharge_treatments` (`id`, `PostId`, `Eye`, `MrdNo`, `VisitNo`, `VisitDate`, `Treatment`, `TreatType1`, `TreatName1`, `TreatDose1`, `TreatFreq1`, `TreatDur1`, `TreatEye1`, `TreatType2`, `TreatName2`, `TreatDose2`, `TreatFreq2`, `TreatDur2`, `TreatEye2`, `TreatType3`, `TreatName3`, `TreatDose3`, `TreatFreq3`, `TreatDur3`, `TreatEye3`, `TreatType4`, `TreatName4`, `TreatDose4`, `TreatFreq4`, `TreatDur4`, `TreatEye4`, `TreatType5`, `TreatName5`, `TreatDose5`, `TreatFreq5`, `TreatDur5`, `TreatEye5`, `TreatType6`, `TreatName6`, `TreatDose6`, `TreatFreq6`, `TreatDur6`, `TreatEye6`, `TreatType7`, `TreatName7`, `TreatDose7`, `TreatFreq7`, `TreatDur7`, `TreatEye7`, `TreatType8`, `TreatName8`, `TreatDose8`, `TreatFreq8`, `TreatDur8`, `TreatEye8`, `TreatChk9`, `TreatType9`, `TreatName9`, `TreatDose9`, `TreatFreq9`, `TreatDur9`, `TreatEye9`, `TreatChk10`, `TreatType10`, `TreatName10`, `TreatDose10`, `TreatFreq10`, `TreatDur10`, `TreatEye10`, `TreatChk11`, `TreatType11`, `TreatName11`, `TreatDose11`, `TreatFreq11`, `TreatDur11`, `TreatEye11`, `TreatChk12`, `TreatType12`, `TreatName12`, `TreatDose12`, `TreatFreq12`, `TreatDur12`, `TreatEye12`, `TreatChk13`, `TreatType13`, `TreatName13`, `TreatDose13`, `TreatFreq13`, `TreatDur13`, `TreatEye13`, `TreatChk1`, `TreatChk2`, `TreatChk3`, `TreatChk4`, `TreatChk5`, `TreatChk6`, `TreatChk7`, `TreatChk8`, `TreatDate1`, `TreatDate2`, `TreatDate3`, `TreatDate4`, `TreatDate5`, `TreatDate6`, `TreatDate7`, `TreatDate8`, `TreatDate9`, `TreatDate10`, `TreatDate11`, `TreatDate12`, `TreatDate13`, `Tapchk1`, `Tapchk2`, `Tapchk3`, `Tapchk4`, `Tapchk5`, `Tapchk6`, `Tapchk7`, `Tapchk8`, `Tapchk9`, `Tapchk10`, `Tapchk11`, `Tapchk12`, `Tapchk13`) VALUES
(1, 1, NULL, 1, NULL, NULL, 'DC Cat Paid', 'TAB', 'TAB ZOXAN 500', '1', 'B.D.', 'X 3 DAYS', NULL, 'TAB', 'TAB NAPRA-D', '1', 'SOS', 'X 2 DAYS', NULL, 'DROP', 'MOXIROOT EYE DROP', '1', '2 HRLY.', 'X 2 DAYS', NULL, 'DROP', NULL, '1', 'T.D.S.', 'X 7 DAYS', NULL, 'DROP', 'IDYLON EYE DROP', '1', '2 HRLY.', 'X 2 DAYS', NULL, 'DROP', NULL, '1', 'T.D.S.', 'X 7 DAYS', NULL, 'DROP', NULL, '1', 'B.D.', 'X 7 DAYS', NULL, 'DROP', NULL, '1', 'O.D.', 'X 7 DAYS', NULL, '1', 'DROP', 'AMFINAC OD EYE DROP', '1', 'O.D.', 'X 45 DAYS', NULL, '1', 'GENERAL', 'STERILE WIPES (14)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', '1', '1', '1', '1', '1', '1', '2026-07-11', '2026-07-10', '2026-07-10', '2026-07-15', '2026-07-10', '2026-07-15', '2026-07-15', '2026-07-15', '2026-08-22', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2, 2, NULL, 1, NULL, NULL, 'DC Cat Paid', 'TAB', 'TAB ZOXAN 500', '1', 'B.D.', 'X 3 DAYS', NULL, 'TAB', 'TAB NAPRA-D', '1', 'SOS', 'X 2 DAYS', NULL, 'DROP', 'MOXIROOT EYE DROP', '1', '2 HRLY.', 'X 2 DAYS', NULL, 'DROP', NULL, '1', 'T.D.S.', 'X 7 DAYS', NULL, 'DROP', 'IDYLON EYE DROP', '1', '2 HRLY.', 'X 2 DAYS', NULL, 'DROP', NULL, '1', 'T.D.S.', 'X 7 DAYS', NULL, 'DROP', NULL, '1', 'B.D.', 'X 7 DAYS', NULL, 'DROP', NULL, '1', 'O.D.', 'X 7 DAYS', NULL, '1', 'DROP', 'AMFINAC OD EYE DROP', '1', 'O.D.', 'X 45 DAYS', NULL, '1', 'GENERAL', 'STERILE WIPES (14)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', '1', '1', '1', '1', '1', '1', '2026-07-11', '2026-07-10', '2026-07-10', '2026-07-15', '2026-07-10', '2026-07-15', '2026-07-15', '2026-07-15', '2026-08-22', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3, 3, NULL, 4, NULL, NULL, 'DC Cat Paid', 'TAB', 'TAB ZOXAN 500', '1', 'B.D.', 'X 3 DAYS', NULL, 'TAB', 'TAB NAPRA-D', '1', 'SOS', 'X 2 DAYS', NULL, 'DROP', 'MOXIROOT EYE DROP', '1', '2 HRLY.', 'X 2 DAYS', 'BE', 'DROP', NULL, '1', 'T.D.S.', 'X 7 DAYS', 'BE', 'DROP', 'IDYLON EYE DROP', '1', '2 HRLY.', 'X 2 DAYS', 'BE', 'DROP', NULL, '1', 'T.D.S.', 'X 7 DAYS', 'BE', 'DROP', NULL, '1', 'B.D.', 'X 7 DAYS', 'BE', 'DROP', NULL, '1', 'O.D.', 'X 7 DAYS', 'BE', '1', 'DROP', 'AMFINAC OD EYE DROP', '1', 'O.D.', 'X 45 DAYS', 'BE', '1', 'GENERAL', 'STERILE WIPES (14)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', '1', '1', '1', '1', '1', '1', '2026-07-11', '2026-07-10', '2026-07-10', '2026-07-15', '2026-07-10', '2026-07-15', '2026-07-15', '2026-07-15', '2026-08-22', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4, 4, NULL, 1, NULL, NULL, 'DC Cat Paid', 'TAB', 'TAB ZOXAN 500', '1', 'B.D.', 'X 3 DAYS', NULL, 'TAB', 'TAB NAPRA-D', '1', 'SOS', 'X 2 DAYS', NULL, 'DROP', 'MOXIROOT EYE DROP', '1', '2 HRLY.', 'X 2 DAYS', 'RE', 'DROP', NULL, '1', 'T.D.S.', 'X 7 DAYS', 'RE', 'DROP', 'IDYLON EYE DROP', '1', '2 HRLY.', 'X 2 DAYS', 'RE', 'DROP', NULL, '1', 'T.D.S.', 'X 7 DAYS', 'RE', 'DROP', NULL, '1', 'B.D.', 'X 7 DAYS', 'RE', 'DROP', NULL, '1', 'O.D.', 'X 7 DAYS', 'RE', '1', 'DROP', 'AMFINAC OD EYE DROP', '1', 'O.D.', 'X 45 DAYS', 'RE', '1', 'GENERAL', 'STERILE WIPES (14)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', '1', '1', '1', '1', '1', '1', '2026-07-11', '2026-07-10', '2026-07-10', '2026-07-15', '2026-07-10', '2026-07-15', '2026-07-15', '2026-07-15', '2026-08-22', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `tbl_discharge_treatments_other`
--

CREATE TABLE `tbl_discharge_treatments_other` (
  `id` int NOT NULL,
  `PostId` int DEFAULT '0',
  `Eye` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `MrdNo` bigint DEFAULT '0',
  `VisitNo` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `VisitDate` date DEFAULT NULL,
  `Treatment` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TreatType1` text COLLATE utf8mb4_general_ci,
  `TreatName1` text COLLATE utf8mb4_general_ci,
  `TreatDose1` text COLLATE utf8mb4_general_ci,
  `TreatFreq1` text COLLATE utf8mb4_general_ci,
  `TreatDur1` text COLLATE utf8mb4_general_ci,
  `TreatEye1` text COLLATE utf8mb4_general_ci,
  `TreatType2` text COLLATE utf8mb4_general_ci,
  `TreatName2` text COLLATE utf8mb4_general_ci,
  `TreatDose2` text COLLATE utf8mb4_general_ci,
  `TreatFreq2` text COLLATE utf8mb4_general_ci,
  `TreatDur2` text COLLATE utf8mb4_general_ci,
  `TreatEye2` text COLLATE utf8mb4_general_ci,
  `TreatType3` text COLLATE utf8mb4_general_ci,
  `TreatName3` text COLLATE utf8mb4_general_ci,
  `TreatDose3` text COLLATE utf8mb4_general_ci,
  `TreatFreq3` text COLLATE utf8mb4_general_ci,
  `TreatDur3` text COLLATE utf8mb4_general_ci,
  `TreatEye3` text COLLATE utf8mb4_general_ci,
  `TreatType4` text COLLATE utf8mb4_general_ci,
  `TreatName4` text COLLATE utf8mb4_general_ci,
  `TreatDose4` text COLLATE utf8mb4_general_ci,
  `TreatFreq4` text COLLATE utf8mb4_general_ci,
  `TreatDur4` text COLLATE utf8mb4_general_ci,
  `TreatEye4` text COLLATE utf8mb4_general_ci,
  `TreatType5` text COLLATE utf8mb4_general_ci,
  `TreatName5` text COLLATE utf8mb4_general_ci,
  `TreatDose5` text COLLATE utf8mb4_general_ci,
  `TreatFreq5` text COLLATE utf8mb4_general_ci,
  `TreatDur5` text COLLATE utf8mb4_general_ci,
  `TreatEye5` text COLLATE utf8mb4_general_ci,
  `TreatType6` text COLLATE utf8mb4_general_ci,
  `TreatName6` text COLLATE utf8mb4_general_ci,
  `TreatDose6` text COLLATE utf8mb4_general_ci,
  `TreatFreq6` text COLLATE utf8mb4_general_ci,
  `TreatDur6` text COLLATE utf8mb4_general_ci,
  `TreatEye6` text COLLATE utf8mb4_general_ci,
  `TreatType7` text COLLATE utf8mb4_general_ci,
  `TreatName7` text COLLATE utf8mb4_general_ci,
  `TreatDose7` text COLLATE utf8mb4_general_ci,
  `TreatFreq7` text COLLATE utf8mb4_general_ci,
  `TreatDur7` text COLLATE utf8mb4_general_ci,
  `TreatEye7` text COLLATE utf8mb4_general_ci,
  `TreatType8` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TreatName8` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TreatDose8` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TreatFreq8` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TreatDur8` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TreatEye8` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TreatChk9` text COLLATE utf8mb4_general_ci,
  `TreatType9` text COLLATE utf8mb4_general_ci,
  `TreatName9` text COLLATE utf8mb4_general_ci,
  `TreatDose9` text COLLATE utf8mb4_general_ci,
  `TreatFreq9` text COLLATE utf8mb4_general_ci,
  `TreatDur9` text COLLATE utf8mb4_general_ci,
  `TreatEye9` text COLLATE utf8mb4_general_ci,
  `TreatChk10` text COLLATE utf8mb4_general_ci,
  `TreatType10` text COLLATE utf8mb4_general_ci,
  `TreatName10` text COLLATE utf8mb4_general_ci,
  `TreatDose10` text COLLATE utf8mb4_general_ci,
  `TreatFreq10` text COLLATE utf8mb4_general_ci,
  `TreatDur10` text COLLATE utf8mb4_general_ci,
  `TreatEye10` text COLLATE utf8mb4_general_ci,
  `TreatChk11` text COLLATE utf8mb4_general_ci,
  `TreatType11` text COLLATE utf8mb4_general_ci,
  `TreatName11` text COLLATE utf8mb4_general_ci,
  `TreatDose11` text COLLATE utf8mb4_general_ci,
  `TreatFreq11` text COLLATE utf8mb4_general_ci,
  `TreatDur11` text COLLATE utf8mb4_general_ci,
  `TreatEye11` text COLLATE utf8mb4_general_ci,
  `TreatChk12` text COLLATE utf8mb4_general_ci,
  `TreatType12` text COLLATE utf8mb4_general_ci,
  `TreatName12` text COLLATE utf8mb4_general_ci,
  `TreatDose12` text COLLATE utf8mb4_general_ci,
  `TreatFreq12` text COLLATE utf8mb4_general_ci,
  `TreatDur12` text COLLATE utf8mb4_general_ci,
  `TreatEye12` text COLLATE utf8mb4_general_ci,
  `TreatChk13` text COLLATE utf8mb4_general_ci,
  `TreatType13` text COLLATE utf8mb4_general_ci,
  `TreatName13` text COLLATE utf8mb4_general_ci,
  `TreatDose13` text COLLATE utf8mb4_general_ci,
  `TreatFreq13` text COLLATE utf8mb4_general_ci,
  `TreatDur13` text COLLATE utf8mb4_general_ci,
  `TreatEye13` text COLLATE utf8mb4_general_ci,
  `TreatChk1` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '0',
  `TreatChk2` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '0',
  `TreatChk3` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '0',
  `TreatChk4` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '0',
  `TreatChk5` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '0',
  `TreatChk6` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '0',
  `TreatChk7` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '0',
  `TreatChk8` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_drugs`
--

CREATE TABLE `tbl_drugs` (
  `id` int NOT NULL,
  `Type` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Name` text COLLATE utf8mb4_general_ci,
  `Dose` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Freq` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_drugs`
--

INSERT INTO `tbl_drugs` (`id`, `Type`, `Name`, `Dose`, `Freq`) VALUES
(1, 'DROP      ', 'PRED FORT EYE DROP', '', 'null'),
(2, 'DROP      ', 'TREHALUB EYE DROP', '', 'null'),
(3, 'GENERAL   ', 'CT SAME GLASSES', '', 'null'),
(4, 'DROP      ', 'ATROSULPH EYE DROP', '', 'null'),
(5, 'DROP      ', 'COMBIPAT EYE DROP', '', 'null'),
(6, 'OINT      ', 'SOFTDROP-PM EYE OINTMENT', '', 'null'),
(7, 'DROP      ', 'LUBREX EYE DROP', '', 'null'),
(8, 'DROP      ', 'GENTEAL EYE DROP', '', 'null'),
(9, 'DROP      ', 'FML EYE DROP', '', 'null'),
(10, 'DROP      ', 'FRESHVE EYE DROP', '', 'null'),
(11, 'DROP      ', 'LACRYL FORTE EYE DROP', '', 'null'),
(12, 'DROP      ', 'TOPVISC EYE DROP', '', 'null'),
(13, 'DROP      ', 'TIMOL-P  EYE DROP', '', 'null'),
(14, 'DROP      ', 'FLOSOFT EYE DROP', '', 'null'),
(15, 'DROP      ', 'HOMIDE EYE DROP', '', 'null'),
(16, 'CAP       ', 'CAP OSMEGA', '', 'null'),
(17, 'OINT', 'OCUPOL -DX EYE OINTMENT', '1', 'H.S.'),
(18, 'OINT.     ', 'HYPERSOL-6 EYE OINTMENT', '', 'null'),
(19, 'DROP      ', 'DORZOX-T EYE DROP', '', 'null'),
(20, 'DROP      ', 'REFRESH TEARS EYE DROP', '', 'null'),
(21, NULL, 'IBUGESIC PLUS', NULL, NULL),
(22, NULL, 'ACILOC 300', NULL, NULL),
(23, 'TAB       ', 'TAB ACILOC 150', '', 'null'),
(24, 'CAP       ', 'CAP OMEZ D', '', 'null'),
(25, 'TAB       ', 'TAB ACTAMID', '', 'null'),
(26, 'TAB       ', 'TAB SMIZOLE D', '', 'null'),
(27, 'GENERAL   ', 'Microvenable Mask', '', 'null'),
(28, 'GENERAL   ', 'ID SCRUBB WITH HYPOCLIN LID CLEANSER', '', 'null'),
(29, 'CAP       ', 'CAP. DOXY 100 MG', '', 'null'),
(30, NULL, 'ACIVIR EYE OINTMENT', NULL, NULL),
(31, 'CAP       ', 'CAP. I-SITE', '', 'null'),
(32, 'CAP       ', 'CAP. IOPAR-SR', '', 'null'),
(33, 'DROP      ', 'NO DRY LIQUIGEL EYE DROP', '', 'null'),
(34, 'OINT.     ', 'LACRIGEL EYE OINT.', '', 'null'),
(35, 'DROP      ', 'HYPERSOL-5 EYE DROP', '', 'null'),
(36, 'TAB       ', 'TAB ZOXON 500', '', 'null'),
(37, 'TAB       ', 'TAB IBUGESIC PLUS', '', 'null'),
(38, 'DROP      ', 'MOXICIP EYE DROP', '', 'null'),
(39, 'DROP      ', 'L PRED EYE DROP', '', 'null'),
(40, 'DROP      ', 'CHLOROCOL PLUS EYE DROP', '', 'null'),
(41, 'TAB       ', 'TAB CIPLOX  500', '', 'null'),
(42, 'TAB       ', 'TAB ACILOC 150', '', 'null'),
(43, 'DROP      ', 'IRIVISC EYE DROP', '', 'null'),
(44, 'DROP      ', 'ACULAR- LS EYE DROP', '', 'null'),
(45, 'DROP      ', 'IOTIM  0.5 % EYE DROP', '', 'null'),
(46, 'GENERAL   ', 'CT. MEDICINES AS PER ADVICE', '', 'null'),
(47, 'TAB       ', 'TAB COMBIFLAM', '', 'null'),
(48, 'GENERAL   ', 'ADV. PACHYMETRY', '', 'null'),
(49, 'TAB       ', 'TAB MONTEMAC-L', '', 'null'),
(50, 'TAB       ', 'TAB VITAMIN C 500 MG CHEWABLE', '', 'null'),
(51, 'DROP      ', 'JUST TEARS EYE DROP', '', 'null'),
(52, 'DROP      ', 'VELDROP EYE DROP', '', 'null'),
(53, 'DROP      ', 'NO DRY EYE DROP', '', 'null'),
(54, 'DROP      ', 'BRIMOLOL EYE DROP', '', 'null'),
(55, 'DROP      ', 'OPTIVE EYE DROP', '', 'null'),
(56, 'DROP      ', 'FLOGEL EYE DROP', '', 'null'),
(57, 'DROP      ', 'ADD TEARS EYE DROP', '', 'null'),
(58, 'DROP      ', 'LOTEL EYE DROP', '', 'null'),
(59, 'DROP      ', 'FLEXITEARS EYE DROP', '', 'null'),
(60, 'DROP      ', 'FML EYE DROP', '', 'null'),
(61, 'TAB       ', 'TAB SMICARE P', '', 'null'),
(62, 'DROP      ', 'TIMOLET OD EYE DROP', '', 'null'),
(63, 'DROP      ', 'SYSTANE EYE DROP', '', 'null'),
(64, 'DROP      ', 'VIGAMOX EYE DROP', '', 'null'),
(65, 'DROP      ', 'KERALUBE EYE DROP', '', 'null'),
(66, 'DROP      ', 'ECOTEARS EYE DROP', '', 'null'),
(67, 'GENERAL   ', 'Lid Cleaning and Lid Hygine', '', 'null'),
(68, 'DROP      ', 'DUEWET EYE DROP', '', 'null'),
(69, 'DROP      ', 'NAVENAC EYE DROP', '', 'null'),
(70, 'TAB       ', 'TAB FLUNARIN 10 mg', '', 'null'),
(71, 'DROP      ', 'ZYMAR EYE DROP', '', 'null'),
(72, 'TAB.      ', 'I-AL', '', 'null'),
(73, 'TAB.      ', 'SN-15', '', 'null'),
(74, 'TAB.      ', 'ALTIVA-180', '', 'null'),
(75, 'DROP      ', 'ATROPINE EYE DROP', '', 'null'),
(76, NULL, 'LIMCEE-500', '1', 'O.D.'),
(77, 'DROP      ', 'EYEBREX EYE DROP', '', 'null'),
(78, 'DROP      ', 'ULTRAGEL EYE DROP', '', 'null'),
(79, 'DROP      ', 'APDROPS LP EYE DROP', '', 'null'),
(80, 'DROP      ', 'LACRIMOS EYE DROP', '', 'null'),
(81, 'GENERAL   ', 'to continue till next visit', '', 'null'),
(303, 'DROP', 'DEXOREN-SP EYE DROP', '1', 'B.D.'),
(83, 'DROP      ', 'AQUATOP EYE DROP', '', 'null'),
(84, 'TAB.      ', 'COMBIFLAM TAB.', '', 'null'),
(85, 'DROP      ', 'MILFLODEX EYE DROP', '', 'null'),
(86, 'DROP      ', 'OSMOTEARS EYE DROP', '', 'null'),
(87, 'TAB.      ', 'TAB DIAMOX', '', 'null'),
(88, 'CAP       ', 'CAP NOVORET NEO', '', 'null'),
(89, 'DROP      ', 'OTEARS EYE DROP', '', 'null'),
(90, 'DROP      ', '4 QUIN-LOT EYE DROP', '', 'null'),
(91, 'DROP      ', 'MILFLOX DM EYE DROP', '', 'null'),
(92, 'OINT.     ', 'LACRIGEL EYE OINTMENT', '', 'null'),
(93, 'DROP      ', 'ALBRIM-T EYE DROP', '', 'null'),
(94, 'TAB.      ', 'TAB DOXY -100', '', 'null'),
(95, 'TAB.      ', 'TAB CEFADUR-500', '', 'null'),
(96, 'ADV       ', 'ct same', '', 'null'),
(97, 'ADV       ', 'le  iol', '', 'null'),
(98, 'ADV       ', 'RETINA', '', 'null'),
(99, 'ADV       ', 'PTERYGIUM', '', 'null'),
(100, 'ADV       ', 'RE IOL', '', 'null'),
(101, 'TAB       ', 'TAB ALPRAX 0.25 mg', '', 'null'),
(102, 'DROP      ', 'MOXIGRAM LX EYE DROP', '', 'null'),
(103, 'DROP      ', 'ZYAQUA EYE DROP', '', 'null'),
(104, 'OINT      ', 'CHLOROCHOL H EYE OINTMENT', '', 'null'),
(105, 'DROP      ', 'VELDROP GEL EYE DROP', '', 'null'),
(106, 'CAP       ', 'CAP OMEGA RED', '', 'null'),
(107, 'DROP      ', 'AQUATOP-G EYE DROP', '', 'null'),
(108, 'DROP      ', 'HYDROEYES  0.05 % EYE DROP', '', 'null'),
(109, 'TAB       ', 'MONTAID L', '', 'null'),
(110, 'TAB       ', 'TAB TRYPTOMER 10 mg at bed time', '', 'null'),
(111, 'TAB       ', 'TAB NAPRA-D', '', 'null'),
(112, 'TAB       ', 'TAB INDERAL 10 mg', '', 'null'),
(113, 'DROP      ', 'TRAVOSUN EYE DROP', '', 'null'),
(114, 'DROP      ', 'TRAVOSUN T EYE DROP', '', 'null'),
(115, 'DROP      ', 'ABSORB EYE DROP', '', 'null'),
(116, 'DROP      ', 'ECOTEARS GEL EYE DROP', '', 'null'),
(117, 'DROP      ', 'HYDROEYES HS 0.1 % EYE DROP', '', 'null'),
(118, 'DROP      ', 'PEGTEARS EYE DROP', '', 'null'),
(119, 'DROP      ', 'MOXVE - LP EYE DROP', '', 'null'),
(120, 'DROP      ', 'IRIMIST EYE DROP', '', 'null'),
(121, 'DROP      ', 'MOFLOREN-D EYE DROP', '', 'null'),
(122, 'DROP      ', 'GATILOX-DM EYE DROP', '', 'null'),
(123, 'DROP      ', 'OSMODROPS EYE DROP', '', 'null'),
(124, 'DROP      ', 'GATIQUIN-P EYE DROP', '', 'null'),
(125, 'DROP      ', 'GATIQUIN HS EYE DROP', '', 'null'),
(126, 'DROP      ', 'HY5 EYE DROP', '', 'null'),
(127, 'DROP      ', 'RELUB EYE DROP', '', 'null'),
(128, 'DROP      ', 'RELUB DS EYE DROP', '', 'null'),
(129, 'DROP      ', 'BIDIN LS TM EYE DROP', '', 'null'),
(130, 'DROP      ', 'TOVAXO EYE DROP', '', 'null'),
(131, 'DROP      ', 'I DEW EYE DROP', '', 'null'),
(132, 'DROP      ', 'BRIMOTAS-T EYE DROP', '', 'null'),
(133, 'DROP      ', 'LOTEFLAM EYE DROP', '', 'null'),
(134, 'DROP      ', 'IMMUDROP DS SINGULES EYE DOP', '', 'null'),
(135, 'TAB       ', 'TAB Omez 20', '', 'null'),
(136, 'DROP      ', 'REFRESH EZEE UNIMS', '', 'null'),
(137, 'DROP      ', 'BIFLACE EYE DROP', '', 'null'),
(138, 'DROP      ', 'Brinzotim', '', 'null'),
(139, 'DROP      ', 'LACRYL ULTRA EYE DROP', '', 'null'),
(140, 'DROP      ', 'ATRODEX-C EYE DROP', '', 'null'),
(141, 'DROP      ', 'CYCTOCORT EYE DROP', '', 'null'),
(142, 'DROP      ', 'AMPLINAK EYE DROP', '', 'null'),
(143, 'DROP      ', 'JUST TEARS LIQUIGEL EYE DROP', '', 'null'),
(144, 'DROP      ', 'CATAPRED EYE DROP', '', 'null'),
(145, 'INJ       ', 'INJ RIBOCROSS 0.1% Riboflavin solution', '', 'null'),
(146, 'DROP      ', 'MFLOTAS EYE DROP', '', 'null'),
(147, 'DROP      ', 'SOFTVISC EYE DROP', '', 'null'),
(148, 'TAB       ', 'SMICARE P', '', 'null'),
(149, 'DROP      ', 'COMPU-DROPS EYE DROP', '', 'null'),
(150, 'DROP      ', 'I KUL PLUS  EYE DROP', '', 'null'),
(151, 'OINT      ', 'ZAHA EYE OINTMENT', '', 'null'),
(152, 'OINT      ', 'AZITHRAL EYE OINTMENT', '', 'null'),
(153, 'GENERAL   ', 'Warm Compress with Lid massage biweekly', '', 'null'),
(154, 'TAB       ', 'TAB ZAID', '', 'null'),
(155, 'TAB       ', 'SYRUP ZAID', '', 'null'),
(156, 'TAB       ', 'TAB SOLOPOSE BETA', '', 'null'),
(157, 'DROP      ', 'OPSION HA ( 5 Ml ) EYE DROP', '', 'null'),
(158, 'TAB       ', 'TAB OMNACORTIL 40 mg', '', 'null'),
(159, 'DROP      ', 'MOISOL EYE DROP', '', 'null'),
(160, 'DROP      ', 'POLYNASE EYE DROP', '', 'null'),
(161, 'DROP      ', 'REFRESH LIQUIGEL EYE DROP', '', 'null'),
(162, 'SYRUP     ', 'ORAL GLYCERINE 50 ML TID to be added in Sprite', '', 'null'),
(163, 'GENERAL   ', 'ZYAQUA CLEANSER', '', 'null'),
(164, 'DROP      ', 'OCUMOIST MAX EYE DROP', '', 'null'),
(165, 'DROP      ', 'AQUALUBE EYE DROP', '', 'null'),
(166, 'DROP      ', 'APDROPS-DM EYE DROP', '', 'null'),
(167, 'DROP      ', 'APDROPS-PD EYE DROP', '', 'null'),
(168, 'DROP      ', 'POLYCHLOR EYE DROP', '', 'null'),
(169, 'DROP      ', 'LOTEPRED EYE DROP', '', 'null'),
(170, 'DROP      ', 'BRINOLAR EYE DROP', '', 'null'),
(171, 'DROP      ', 'BLINK-I EYE DROP', '', 'null'),
(172, 'DROP      ', 'ZYLOPRED EYE DROP', '', 'null'),
(173, 'DROP      ', 'UV LUBE UNIMS', '', 'null'),
(174, 'DROP      ', 'EXTRALUBE EYE DROP', '', 'null'),
(175, 'DROP      ', 'EXTRAGAT EYE DROP', '', 'null'),
(176, 'DROP      ', 'PSEUDO-TEARS EYE DROP', '', 'null'),
(177, 'DROP      ', 'NO-DRY FUSION EYE DROP', '', 'null'),
(178, 'DROP      ', 'ZYWET EYE DROP', '', 'null'),
(179, 'JELLY     ', 'CAROKID JELLY', '', 'null'),
(180, 'GENERAL   ', 'CAROKID JELLY', '', 'null'),
(181, 'DROP      ', 'A-WAYLABLE EYE DROP', '', 'null'),
(182, 'DROP      ', 'TRAVISGHT EYE DROP', '', 'null'),
(183, 'OINT      ', 'AQUALUBE PM EYE GEL', '', 'null'),
(184, 'CAP       ', 'Continue Treatment as adviced', '', 'null'),
(185, 'DROP      ', 'EYEMIST FORTE EYE DROP', '', 'null'),
(186, 'DROP      ', 'EYEMIST EYE GEL', '', 'null'),
(187, 'SYRUP     ', 'SYRUP KESOL', '', 'null'),
(188, 'DROP      ', 'FLAREX EYE DROP', '', 'null'),
(189, 'DROP      ', 'ERPETOL EYEDROP', '', 'null'),
(190, 'DROP      ', 'EYEMIST EYE DROP', '', 'null'),
(191, 'DROP      ', 'ONTEARS UNIMS EYE DROP', '', 'null'),
(192, 'DROP      ', 'BEPOS EYE DROP', '', 'null'),
(193, 'DROP      ', 'AQUASURGE EYE DROP', '', 'null'),
(194, 'DROP      ', 'NO DRY FUSION EYE DROP', '', 'null'),
(195, 'DROP      ', 'SMARTTEARS EYE DROP', '', 'null'),
(196, 'DROP      ', 'FLOMON EYE DROP', '', 'null'),
(197, 'DROP      ', 'GENTEAL GEL EYE DROP', '', 'null'),
(198, 'DROP      ', 'ZAHA DX EYE DROP', '', 'null'),
(199, 'DROP      ', 'ACUPAT EYE DROP', '', 'null'),
(200, 'OINT      ', 'GENTEAL EYE GEL', '', 'null'),
(201, 'DROP      ', 'MAXMOIST EYE DROP', '', 'null'),
(202, 'DROP      ', 'SYSTANE - ULTRA EYE DROP', '', 'null'),
(203, 'DROP      ', 'AQUASURGE - MAX EYE DROP', '', 'null'),
(204, 'DROP      ', 'EYEMAC EYE DROP', '', 'null'),
(205, 'DROP      ', 'OLOPAT EYE DROP', '', 'null'),
(206, 'DROP      ', 'MOFLOREN EYE DROP', '', 'null'),
(207, 'DROP      ', 'ALFABET-PF EYE DROP', '', 'null'),
(208, 'DROP      ', 'OPTICOOL EYE DROP', '', 'null'),
(209, 'DROP      ', 'IRIVISC LIQUIGEL EYE DROP', '', 'null'),
(210, 'DROP      ', 'MILFLOX EYE DROP', '', 'null'),
(211, 'OINT      ', 'ENTRAK EYE OINTMENT', '', 'null'),
(212, 'GENERAL   ', '25 OXY ORAL SPRAY', '', 'null'),
(213, 'DROP      ', 'NEPALACT EYE DROP', '', 'null'),
(214, 'DROP', 'AMFINAC OD EYE DROP', '1', 'O.D.'),
(215, 'DROP      ', 'IDYLON EYE DROP', '', 'null'),
(216, 'DROP      ', 'OCUPOL EYEDROP', '', 'null'),
(217, 'DROP      ', 'DEUWET EYE DROP', '', 'null'),
(218, 'GENERAL   ', 'To put eye drops regularly', '', 'null'),
(219, 'DROP      ', 'CARMILOSE EYE DROP', '', 'null'),
(220, 'DROP      ', 'CARMILOSE-GEL EYE DROP', '', 'null'),
(221, 'DROP      ', 'KETOFLAM-LS EYE DROP', '', 'null'),
(222, 'DROP      ', 'MOXIROOT EYE DROP', '', 'null'),
(223, 'TAB', 'TAB VITEXTRA PLUS', '1', 'O.D.'),
(224, 'DROP      ', 'FMELON EYE DROP', '', 'null'),
(225, 'DROP      ', 'LUPITROS-TZ EYE DROP  9 PM', '', 'null'),
(226, 'DROP      ', 'CYCLOMUNE 0.05% EYE DROP', '', 'null'),
(227, 'DROP      ', 'LUPITROS TZ EYE DROP  9 PM', '', 'null'),
(228, 'OINT      ', 'DEXOREN-SP EYE OINTMENT', '', 'null'),
(229, 'DROP      ', 'PIXELUB MULTI EYE DROP', '', 'null'),
(230, 'CAP       ', 'CAP DOXT-SL    100 mg - Before Meal', '', 'null'),
(231, 'DROP      ', 'COMBIGAN EYE DROP', '', 'null'),
(344, 'TAB', 'TAB 2 B12', '1', 'O.D.'),
(233, 'OINT      ', 'ZYMAR EYE OINTMENT', '', 'null'),
(234, 'TAB       ', 'TAB AIMCEE 500 MG', '', 'null'),
(304, 'DROP', 'BRINZOTIM EYE DROP', '1', 'B.D.'),
(236, 'DROP      ', 'MYTICOM EYE DROP', '', 'null'),
(237, 'DROP      ', 'I-BORIC EYE DROP', '', 'null'),
(238, 'DROP      ', 'RIPATEC EYE DROP', '', 'null'),
(239, 'DROP      ', 'MY ATRO EYE DROP', '', 'null'),
(240, 'DROP      ', 'TRAVOPURE EYE DROP', '', 'null'),
(241, 'OINT      ', 'MOXICIP EYE OINTMENT', '', 'null'),
(242, 'DROP      ', 'AB PRESS  EYE DROP', '', 'null'),
(243, NULL, 'Review after 7 days for refraction', NULL, NULL),
(244, 'TAB       ', 'TAB BIOZOBID PLUS', '', 'null'),
(245, 'GENERAL   ', 'Review after 3 month', '', 'null'),
(247, 'GENERAL   ', 'LID SCRUBB WITH ZYAQUA LID CLEANSER', '', 'null'),
(248, 'GENERAL   ', 'Ct Treatment given as per schedule on Discharge Card', '', 'null'),
(249, 'TAB       ', 'TAB IDYCURE AC', '', 'null'),
(250, 'DROP      ', 'SOHA LIQUIGEL EYE DROP ( Trehalose plus Sodium Hyaluronate)', '', 'null'),
(251, 'DROP      ', 'CAREPROST LS EYE DROP', '', 'null'),
(252, 'CAP       ', 'CAP RABILYC DSR', '', 'null'),
(253, 'DROP      ', 'TEAR NATURALE FORTE EYE DROP', '', 'null'),
(254, 'GENERAL   ', 'Protective Goggles', '', 'null'),
(255, 'DROP      ', 'NAPHAROOT  EYE DROP', '', 'null'),
(256, 'DROP      ', 'HYAQUA MINI EYE DROP', '', 'null'),
(257, 'GENERAL   ', 'Convergence Exercises / Accomodation Exercises', '', 'null'),
(258, 'TAB       ', 'TAB ACIVIR 400', '', 'null'),
(259, 'DROP      ', 'OPICA DOU EYE DROP', '', 'null'),
(260, 'DROP      ', 'MOXICISE EYE DROP', '', 'null'),
(261, 'DROP      ', 'CROMAL FORTE EYE', '', 'null'),
(262, 'GENERAL   ', 'Amsler Grid', '', 'null'),
(263, 'DROP      ', 'OKT EYE DROP - To start if itching recurs', '', 'null'),
(264, 'CAP       ', 'CAP DOX TS            before meal', '', 'null'),
(265, 'DROP      ', 'HYAQUA EYE DROP', '', 'null'),
(266, 'DROP      ', 'MOXIROOT D EYE DROP', '', 'null'),
(267, 'DROP      ', 'MOXIROOT-D EYE DROP', '', 'null'),
(268, 'DROP      ', 'PRESSOTIM  EYE DROP', '', 'null'),
(269, 'DROP      ', 'SYSTANE HYDRATION EYE DROP', '', 'null'),
(270, 'DROP      ', 'LYCKATEARS EYE DROP', '', 'null'),
(271, 'TAB       ', 'TAB UPRISE D3 60000 IU Once a week for 6 weeks', '', 'null'),
(272, NULL, 'ILLEVRO /NEPASTAR OD EYE DROP', NULL, NULL),
(273, 'DROP      ', 'MOXIROOT-LP EYE DROP', '', 'null'),
(274, 'GENERAL   ', 'Dark Goggles', '', 'null'),
(275, 'GENERAL   ', 'Stopped Travatan b/of ? Allergy', '', 'null'),
(276, 'DROP      ', 'LYCKATEARS GEL EYE DROP', '', 'null'),
(277, 'TAB       ', 'TAB LIMCEE 500 MG', '', 'null'),
(278, 'GENERAL   ', 'Green Shield', '', 'null'),
(279, 'DROP      ', 'AZARGA EYE DROP', '', 'null'),
(280, 'DROP      ', 'APIDINE EYE DROP -To Apply Locally', '', 'null'),
(301, 'OINT', 'PANTHAGEL EYE GEL', NULL, NULL),
(282, 'SYRUP     ', 'SYRUP PURPVIT', '', 'null'),
(283, 'TAB       ', 'TAB PURPVIT', '', 'null'),
(284, 'DROP', 'BETOACT EYE DROP -To instill if itching recurs', '1', 'B.D.'),
(285, 'DROP', 'ARM TEARS EYE DROP', '1', 'T.D.S.'),
(286, NULL, 'MELALUMIN UNDER EYE SERUM', '1', 'H.S.'),
(287, NULL, 'Warm compress', NULL, NULL),
(288, 'Steam', 'to continue if needed', NULL, NULL),
(289, 'TAB', 'TAB MONTEMAC-L', '1', 'O.D.'),
(290, NULL, 'Warm Compress with Lid massage daily', NULL, NULL),
(291, 'CAP', 'CAP DIAMOX ER 500 mg', '1', 'O.D.'),
(292, 'Cold', 'Cold compress', NULL, NULL),
(302, NULL, 'Review for dilated fundus examn', NULL, NULL),
(300, 'DROP', 'C-PENT EYE DROP', NULL, NULL),
(295, 'DROP', 'MOSI-D EYE DROP', '1', 'T.D.S.'),
(296, 'DROP', 'FLEXITEARS-HA EYE DROP', '1', 'T.D.S.'),
(297, 'DROP', 'SYSTANE COMPLETE  EYE DROP', '1', 'T.D.S.'),
(298, 'CAP', 'CAP IOPAR SR', NULL, NULL),
(299, 'DROP', 'VIGADEXA EYE DROP', NULL, NULL),
(305, 'SYRUP', 'DEXOREN-S EYE DROP', '1', 'B.D.'),
(306, 'DROP', 'AMFINAC  EYE DROP', '1', 'T.D.S.'),
(307, 'TAB', 'TAB IBUGESIC JUNIOR', '1', 'B.D.'),
(308, 'GENERAL', 'Continue Treatment as adviced on discharge card', NULL, NULL),
(309, 'TAB', 'TAB RAYBON -D3 / TAB UPRISE D3 60000 IU Once a week for 8 weeks', NULL, NULL),
(310, 'DROP', 'ALPHAGAN Z EYE DROP', '1', 'T.D.S.'),
(311, 'DROP', 'CYCLISIS 0.05% EYE DROP', '1', 'B.D.'),
(312, 'DROP', 'CYCLISIS-PF EYE DROP', '1', 'B.D.'),
(313, 'TAB', 'TAB CHYMORAL FORTE', '1', 'O.D.'),
(314, 'DROP', 'PRESSOTRAV  EYE DROP', '1', 'H.S.'),
(315, 'SYRUP', 'SYRUP COMBIFLAM 5 ML', '1', 'T.D.S.'),
(316, 'GENERAL', 'EYECIRQUE-PRO UNDER EYE GEL SERUM', '1', 'B.D.'),
(317, 'OINT', 'LOTEL EYE OINTMENT', '1', 'H.S.'),
(319, 'TAB', 'TAB CLAMP KID FORTE', '1', 'B.D.'),
(320, 'DROP', 'ZOLINE PLUS EYE DROP', '1', 'T.D.S.'),
(321, 'DROP', 'LOIMFLA EYE DROP', '1', '3 TAP'),
(322, 'DROP', 'FMELON - T EYE DROP', '1', '3 TAP'),
(323, 'DROP', 'BACTOLIP-D EYE DROP', '1', 'T.D.S.'),
(324, 'DROP', 'HYCORNI EYE DROP', '1', 'T.D.S.'),
(325, 'TAB', 'TAB MONTELIC-L', '1', 'B.D.'),
(326, 'Hot', 'Warm Compress with Lid massage biweekly with hot water mask', NULL, NULL),
(327, 'DROP', 'HYCLO 0.05% EYE DROP', '1', 'T.D.S.'),
(328, NULL, 'Continue treatment of Dr.', NULL, NULL),
(329, NULL, 'Lacrimal Massage', NULL, NULL),
(330, 'OINT', 'IFLOMAX EYE GEL', '1', 'B.D.'),
(331, 'GENERAL', 'MYOVIT-GUMMIES', '1', 'O.D.'),
(332, 'DROP', 'CEQUA 0.09% UNIMS 9SINGLE USE VIAL)', '1', 'B.D.'),
(333, 'DROP', 'AUTOLOGUS SERUM 20% EYE DROP', '1', 'Q.I.D.'),
(334, 'DROP', 'LUMIGAN 0.01 % EYE DROP', NULL, NULL),
(335, 'DROP', 'BACTOLIP EYE DROP', '1', 'T.D.S.'),
(336, 'OINT', 'TACROLIMUS  EYE OINTMENT', '1', 'B.D.'),
(337, 'OINT', 'LACRYL GENTLE EYE GEL', '1', 'H.S.'),
(338, 'DROP', 'OPHTHOLUBE EYE DROP', '1', 'T.D.S.'),
(339, NULL, 'WARM MASSAGE WITH EYLYS MASK', NULL, NULL),
(340, 'SYRUP', 'Liftanta eyedrop', '1', 'B.D.'),
(341, 'DROP', 'OLOPAT  EYE DROP -To instill if itching recurs', '1', 'B.D.'),
(342, NULL, 'ENPAT 0.7 % EYE DROP -To instill if itching recurs', NULL, NULL),
(343, NULL, 'AMFINAC CS EYE DROP', NULL, NULL),
(345, 'DROP', 'MAXIM D EYE DROP', '1', NULL),
(346, 'DROP', 'NEPAFLAM OD EYE DROP', '1', 'O.D.'),
(347, NULL, 'DORZOX EYE DROP', NULL, NULL),
(348, NULL, 'CYCLOTEARS D 0.05% EYE DROP', NULL, NULL),
(349, 'DROP', 'TRIOPTIC EYE DROP', '1', 'O.D.'),
(350, 'DROP', 'HYCORNI-O EYE DROP', NULL, NULL),
(351, 'DROP', 'OCUPOL EYE DROP', NULL, NULL),
(352, NULL, 'Warm Compress with Lid massage daily with Eylys Mask', NULL, NULL),
(353, NULL, 'OCUPOL DX EYE DROP', NULL, NULL);

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

--
-- Table structure for table `tbl_duration`
--

CREATE TABLE `tbl_duration` (
  `id` int NOT NULL,
  `Duration` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `DurVal` int DEFAULT NULL,
  `DurPeriod` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_duration`
--

INSERT INTO `tbl_duration` (`id`, `Duration`, `DurVal`, `DurPeriod`) VALUES
(1, 'X 1 DAY', 1, 'days'),
(2, 'X 2 DAYS', 2, 'days'),
(3, 'X 3 DAYS', 3, 'days'),
(4, 'X 4 DAYS', 4, 'days'),
(5, 'X 5 DAYS', 5, 'days'),
(6, 'X 6 DAYS', 6, 'days'),
(7, 'X 7 DAYS', 7, 'days'),
(8, 'X 10 DAYS', 10, 'days'),
(9, 'X 15 DAYS', 15, 'days'),
(10, 'X 20 DAYS', 20, 'days'),
(11, 'X 30 DAYS', 30, 'days'),
(12, 'X 45 DAYS', 45, 'days'),
(13, 'X 1 MONTHS', 1, 'month'),
(14, 'X 2 MONTHS', 2, 'month'),
(15, 'X 3 MONTHS', 3, 'month'),
(16, 'X 4 MONTHS', 4, 'month'),
(17, 'X 5 MONTHS', 5, 'month'),
(18, 'X 6 MONTHS', 6, 'month'),
(19, 'X 1 YEAR', 1, 'year'),
(20, 'ToContinue', 0, 'days'),
(21, '5 Days', 5, 'days'),
(22, 'X 4 MONTHS', 4, 'month'),
(23, '10 DAYS', 10, 'days'),
(24, 'X  5 DAYS', 5, 'days'),
(25, 'X  10 DAYS', 10, 'days'),
(26, 'X  3 DAYS', 3, 'days'),
(27, 'X  2 MONTHS', 2, 'month'),
(28, '7 Days', 7, 'days'),
(29, '6 DAYS', 6, 'days'),
(30, '1 DAY', 1, 'days'),
(31, 'X  1 MONTH', 1, 'month'),
(32, 'X  15 DAYS', 15, 'days'),
(33, 'X  1 DAY', 1, 'days'),
(34, 'X  30 DAYS', 30, 'days'),
(35, 'X  6 MONTHS', 6, 'month'),
(36, 'X  7 DAYS', 7, 'days'),
(37, 'X  3 MONTHS', 3, 'month'),
(38, 'X  2 DAYS', 2, 'days'),
(39, 'X  20 DAYS', 20, 'days'),
(40, '15 DAYS', 15, 'days'),
(41, 'AT 9 PM', 0, 'days'),
(42, 'X  1 YEAR', 1, 'year'),
(43, '1 Month', 1, 'month'),
(44, 'X  6 DAYS', 6, 'days'),
(45, 'X  8 MONTHS', 8, 'month'),
(46, 'X  45 DAYS', 45, 'days'),
(47, '21 Days', 21, 'days'),
(48, 'X  8 DAYS', 8, 'days'),
(49, 'X  5 MONTHS', 5, 'month'),
(50, '3 Days', 3, 'days'),
(51, 'Life Time ', 0, 'days'),
(52, 'X 6 MONTHS', 6, 'month'),
(53, 'TILL NEXT VISIT ', 0, 'days'),
(54, '3 Months', 3, 'month'),
(55, 'X  4 DAYS', 4, 'days'),
(56, 'lifelong', 0, 'days'),
(57, 'X  2 MONTH', 2, 'month'),
(58, 'X 15 DAYS', 15, 'days'),
(59, '6 Months', 6, 'month'),
(60, '2 Months', 2, 'month'),
(61, '1 Year', 1, 'year'),
(62, '2 Years', 2, 'year'),
(63, 'AT Night', 0, 'days'),
(64, '6 Month', 6, 'month'),
(65, '2 DAYS', 2, 'days'),
(66, 'X  07 DAYS', 7, 'days'),
(67, 'at 4\\/5\\/6 pm', 0, 'days'),
(68, 'lifelong ', 0, 'days'),
(69, 'X  13 DAYS', 13, 'days'),
(70, 'X  12 DAYS', 12, 'days'),
(71, 'X  18 DAYS', 18, 'days'),
(72, 'for life ', 0, 'days'),
(73, 'lifetime ', 0, 'days'),
(74, 'X  21 DAYS', 21, 'days'),
(75, 'X  25 DAYS', 25, 'days'),
(76, 'TILL NEXT VISIT', 0, 'days'),
(77, 'SOS', 0, 'days'),
(78, '30 DAY', 30, 'days'),
(79, 'X  4 MONTHS', 4, 'month'),
(80, '6 weeks', 42, 'days'),
(81, 'X  6 WEEKS', 42, 'days'),
(82, 'CTNV', 0, 'days'),
(83, 'X 10 DAYS', 10, 'days'),
(84, 'X 5 DAYS', 5, 'days');

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

--
-- Table structure for table `tbl_fixed_date`
--

CREATE TABLE `tbl_fixed_date` (
  `id` int NOT NULL,
  `FixedDate` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_insurance_company_master`
--

CREATE TABLE `tbl_insurance_company_master` (
  `id` bigint UNSIGNED NOT NULL,
  `Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Status` tinyint UNSIGNED NOT NULL DEFAULT '1',
  `CreatedBy` bigint UNSIGNED DEFAULT NULL,
  `ModifiedBy` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_insurance_company_master`
--

INSERT INTO `tbl_insurance_company_master` (`id`, `Name`, `Status`, `CreatedBy`, `ModifiedBy`) VALUES
(1, 'Company 1', 1, 34, NULL);

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

--
-- Table structure for table `tbl_ipd`
--

CREATE TABLE `tbl_ipd` (
  `id` bigint NOT NULL,
  `IpdNo` int DEFAULT NULL,
  `PatientId` int DEFAULT '0',
  `MrdNo` int DEFAULT '0',
  `ConsultantId` int DEFAULT '0',
  `BedNo` int DEFAULT '0',
  `HodName` varchar(255) DEFAULT NULL,
  `TrainerName` varchar(255) DEFAULT NULL,
  `PatientName` varchar(255) DEFAULT NULL,
  `Age` varchar(100) DEFAULT NULL,
  `Gender` varchar(255) DEFAULT NULL,
  `Address` text,
  `Occupation` varchar(255) DEFAULT NULL,
  `RelativeName` varchar(255) DEFAULT NULL,
  `ReferenceName` varchar(255) DEFAULT NULL,
  `CurrentDieseas` text,
  `ConfirmDieseas` text,
  `EntryDate` date DEFAULT NULL,
  `EntryTime` varchar(255) DEFAULT NULL,
  `DischargeDate` date DEFAULT NULL,
  `DischargeTime` varchar(255) DEFAULT NULL,
  `Cast` varchar(255) DEFAULT NULL,
  `AnnualIncome` varchar(255) DEFAULT NULL,
  `Result` varchar(100) DEFAULT NULL,
  `Status` tinyint(1) DEFAULT '1',
  `CreatedBy` int DEFAULT '0',
  `CreatedDate` date DEFAULT NULL,
  `ModifiedBy` int DEFAULT '0',
  `ModifiedDate` date DEFAULT NULL,
  `Treatment` varchar(255) DEFAULT NULL,
  `TreatChk1` tinyint(1) DEFAULT NULL,
  `TreatType1` text,
  `TreatName1` text,
  `TreatDose1` text,
  `TreatFreq1` text,
  `TreatDur1` text,
  `TreatEye1` text,
  `TreatChk2` text,
  `TreatType2` text,
  `TreatName2` text,
  `TreatDose2` text,
  `TreatFreq2` text,
  `TreatDur2` text,
  `TreatEye2` text,
  `TreatChk3` text,
  `TreatType3` text,
  `TreatName3` text,
  `TreatDose3` text,
  `TreatFreq3` text,
  `TreatDur3` text,
  `TreatEye3` text,
  `TreatChk4` text,
  `TreatType4` text,
  `TreatName4` text,
  `TreatDose4` text,
  `TreatFreq4` text,
  `TreatDur4` text,
  `TreatEye4` text,
  `TreatChk5` text,
  `TreatType5` text,
  `TreatName5` text,
  `TreatDose5` text,
  `TreatFreq5` text,
  `TreatDur5` text,
  `TreatEye5` text,
  `TreatChk6` text,
  `TreatType6` text,
  `TreatName6` text,
  `TreatDose6` text,
  `TreatFreq6` text,
  `TreatDur6` text,
  `TreatEye6` text,
  `TreatChk7` text,
  `TreatType7` text,
  `TreatName7` text,
  `TreatDose7` text,
  `TreatFreq7` text,
  `TreatDur7` text,
  `TreatEye7` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `tbl_ipd_madam_receipts`
--

CREATE TABLE `tbl_ipd_madam_receipts` (
  `id` bigint NOT NULL,
  `SrNo` int NOT NULL,
  `FinYr` varchar(20) NOT NULL DEFAULT '24-24',
  `ReceiptNo` varchar(100) DEFAULT NULL,
  `MrdNo` varchar(255) DEFAULT NULL,
  `IpdNo` varchar(255) DEFAULT NULL,
  `PatientName` varchar(255) DEFAULT NULL,
  `Amount` float(14,2) DEFAULT NULL,
  `PayMode` varchar(255) DEFAULT NULL,
  `ChequeNo` varchar(255) DEFAULT NULL,
  `Narration` text,
  `AdmissionDate` date DEFAULT NULL,
  `AdmissionTime` varchar(100) DEFAULT NULL,
  `DepositDate` date DEFAULT NULL,
  `DepositTime` varchar(100) DEFAULT NULL,
  `Status` tinyint(1) DEFAULT '1',
  `CreatedBy` int DEFAULT '0',
  `CreatedDate` date DEFAULT NULL,
  `ModifiedBy` int DEFAULT '0',
  `ModifiedDate` date DEFAULT NULL,
  `Procedures` text,
  `ChqDate` date DEFAULT NULL,
  `ChqDep` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `tbl_ipd_receipts`
--

CREATE TABLE `tbl_ipd_receipts` (
  `id` bigint NOT NULL,
  `SrNo` int NOT NULL,
  `FinYr` varchar(20) NOT NULL DEFAULT '23-24',
  `ReceiptNo` varchar(255) DEFAULT NULL,
  `MrdNo` varchar(255) DEFAULT NULL,
  `IpdNo` varchar(255) DEFAULT NULL,
  `PatientName` varchar(255) DEFAULT NULL,
  `Amount` float(14,2) DEFAULT NULL,
  `PayMode` varchar(255) DEFAULT NULL,
  `ChequeNo` varchar(255) DEFAULT NULL,
  `Narration` text,
  `AdmissionDate` date DEFAULT NULL,
  `AdmissionTime` varchar(100) DEFAULT NULL,
  `DepositDate` date DEFAULT NULL,
  `DepositTime` varchar(100) DEFAULT NULL,
  `Status` tinyint(1) DEFAULT '1',
  `CreatedBy` int DEFAULT '0',
  `CreatedDate` date DEFAULT NULL,
  `ModifiedBy` int DEFAULT '0',
  `ModifiedDate` date DEFAULT NULL,
  `Procedures` text,
  `ChqDate` date DEFAULT NULL,
  `ChqDep` date DEFAULT NULL,
  `BankName` varchar(255) DEFAULT NULL,
  `BranchName` varchar(255) DEFAULT NULL,
  `AccountNo` varchar(255) DEFAULT NULL,
  `AccountHolder` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `tbl_item_ledger`
--

CREATE TABLE `tbl_item_ledger` (
  `id` bigint NOT NULL,
  `PostId` int DEFAULT '0',
  `BillNo` varchar(255) DEFAULT NULL,
  `MrdNo` int DEFAULT '0',
  `FrameType` int DEFAULT '0',
  `FrameName` varchar(255) DEFAULT NULL,
  `Power` varchar(100) DEFAULT NULL,
  `Qty` int DEFAULT '0',
  `Rate` float(14,2) DEFAULT NULL,
  `GlassName` varchar(255) DEFAULT NULL,
  `GlassRate` varchar(255) DEFAULT NULL,
  `TotalAmount` float(14,2) DEFAULT NULL,
  `CrDr` varchar(100) DEFAULT NULL,
  `Narration` text,
  `Type` varchar(100) DEFAULT NULL,
  `Status` tinyint(1) DEFAULT '1',
  `CreatedBy` varchar(100) DEFAULT NULL,
  `CreatedDate` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `tbl_item_masters`
--

CREATE TABLE `tbl_item_masters` (
  `id` int NOT NULL,
  `srno` int DEFAULT '0',
  `Code` varchar(100) DEFAULT NULL,
  `ItemType` int DEFAULT '0',
  `Name` varchar(255) DEFAULT NULL,
  `Details` text,
  `Qty` int DEFAULT '0',
  `Rate` float(14,2) DEFAULT NULL,
  `AddMinus` varchar(10) DEFAULT '+',
  `Status` tinyint(1) DEFAULT '1',
  `CreatedBy` int DEFAULT '0',
  `CreatedDate` date DEFAULT NULL,
  `ModifiedBy` int DEFAULT '0',
  `ModifiedDate` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `tbl_item_type`
--

