-- Table structure for table `dtvs`
--

CREATE TABLE IF NOT EXISTS `dtvs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `infertilitysheetid` int(11) unsigned DEFAULT NULL,
  `dtvsresult` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `dtvsplace`
--

CREATE TABLE IF NOT EXISTS `dtvsplace` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=5 ;

--
-- Dumping data for table `dtvsplace`
--

INSERT INTO `dtvsplace` (`id`, `title`, `del`) VALUES
(1, 'Dr Amr م.ملكي', NULL),
(2, 'dr amr م.ملكي', NULL),
(3, '', NULL),
(4, 'sherbini', NULL);

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

--
-- Table structure for table `dtvsresult`
--

CREATE TABLE IF NOT EXISTS `dtvsresult` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=17 ;

--
-- Dumping data for table `dtvsresult`
--

INSERT INTO `dtvsresult` (`id`, `title`, `del`) VALUES
(1, 'n', NULL),
(2, 'arcuate ut', NULL),
(3, 'subseptate ut', NULL),
(4, 'complete ut septum', NULL),
(5, 'complete ut & cx septum', NULL),
(6, 'bicornuate ut', NULL),
(7, '?n', NULL),
(8, 'mild', NULL),
(9, 'seems n', NULL),
(10, 'need re-eval after 2w', NULL),
(11, 'not done may be arcuate', NULL),
(12, 'photo', NULL),
(13, 't shaped ut', NULL),
(14, 'v.mild arcuate', NULL),
(15, 'v.v.v.v. mild arcuate', NULL),
(16, 'v.v ', NULL);

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

--
-- Table structure for table `education`
--

CREATE TABLE IF NOT EXISTS `education` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(150) NOT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT AUTO_INCREMENT=89 ;

--
-- Dumping data for table `education`
--

INSERT INTO `education` (`id`, `title`, `del`) VALUES
(1, 'بكالوريوس', NULL),
(2, 'أولي كليه طب', NULL),
(3, 'دبلوم', NULL),
(4, 'ليسانس حقوق', NULL),
(5, 'اعدادية', NULL),
(6, 'ثانوية عامة', NULL),
(7, 'معهد Ùنى صناعى', NULL),
(8, 'محو الامية', NULL),
(9, 'Ùنون تطبقية', NULL),
(10, 'ابتداية', NULL),
(11, 'كلية حقوق', NULL),
(12, 'كلية دراسات إسلامية', NULL),
(13, 'دبلوم ', NULL),
(14, 'دبلوم متوسط', NULL),
(15, 'ليسانس  شريعة سلاميه', NULL),
(16, 'بكالوريوس علوم', NULL),
(17, 'دبلوم تجاره', NULL),
(18, 'أمي', NULL),
(19, 'إعداديه', NULL),
(20, 'كليه تربية', NULL),
(21, 'بكالوريوس تربية', NULL),
(22, 'دبلوم بحري', NULL),
(23, 'بكالوريوس آداب جغراÙيا', NULL),
(24, 'معهد سياحة وÙنادق', NULL),
(25, 'ليسانس ألسن', NULL),
(26, 'بكالوريوس   تجارة', NULL),
(27, 'إبتدائيه', NULL),
(28, 'معهد خدمه إجتماعيه', NULL),
(29, 'بكالوريوس تجارة أنجليزى', NULL),
(30, 'ماجستير طب', NULL),
(31, 'بكالوريوس Ùنون تطبيقية', NULL),
(32, 'معهد Ùنى صحى', NULL),
(33, 'ليسانس تربية إنجليزى', NULL),
(34, 'بكالوريوس إعلام', NULL),
(35, 'معهد نظم ومعلومات', NULL),
(36, 'امى', NULL),
(37, 'كلية طب بيطري', NULL),
(38, 'ليسانس لغة عربية', NULL),
(39, 'ليسانس  أداب وتربية ', NULL),
(40, 'كلية اداب', NULL),
(41, 'بكالوريوس حاسب آلى', NULL),
(42, 'بكالوريوس خدمة إجتماعية', NULL),
(43, 'معهد تكييÙ وتبريد', NULL),
(44, 'دبلوم زراعة', NULL),
(45, 'دبلوم Ùنى', NULL),
(46, 'دبلوم صناعى', NULL),
(47, 'ليسانس علوم وتربية', NULL),
(48, 'معهد حاسب', NULL),
(49, 'معهد هندسة', NULL),
(50, 'إعدادية', NULL),
(51, 'معهد Ùنى تجارى', NULL),
(52, 'كلية تجارة', NULL),
(53, 'معهد تجارى', NULL),
(54, 'Ùن تحليل', NULL),
(55, 'Ùن تحليل', NULL),
(56, 'Ùن تحليل', NULL),
(57, 'Ùن تحليل', NULL),
(58, 'بكالوريوس تمريض', NULL),
(59, 'دبلوم تمريض', NULL),
(60, 'معهدخدمة إجتماعية', NULL),
(61, 'ليسانس آداب', NULL),
(62, 'بكالوريوس إدارة أعمال', NULL),
(63, 'معهد Ùني صحي', NULL),
(64, 'بكالوريوس تربية إنجليزى', NULL),
(65, 'بكالوريوس دراسات إسلامية', NULL),
(66, 'أول إعدادى', NULL),
(67, 'معلمات', NULL),
(68, 'معهد Ùني زراعي', NULL),
(69, 'طالبة كلية أداب', NULL),
(70, 'ليسانس تربية لغه عربية ', NULL),
(71, 'ليسانس تربية لغه عربية ', NULL),
(72, 'ليسانس تربية لغه عربية ', NULL),
(73, 'ليسانس تربية لغه عربية ', NULL),
(74, 'ليسانس تربية لغه عربية ', NULL),
(75, 'ليسانس تربية لغه عربية ', NULL),
(76, 'ليسانس تربية لغه عربية ', NULL),
(77, 'كلية تربية', NULL),
(78, 'بكالريوس تجارة', NULL),
(79, 'بكالريوس تربية', NULL),
(80, 'بكالريوس تربية إنجليزي', NULL),
(81, 'ثانوية أزهرية', NULL),
(82, 'معهد Ùني تجاري', NULL),
(83, 'بكالريوس نظم ومعلومات', NULL),
(84, 'ثالث اعدادى', NULL),
(85, 'تالتة إعدادى', NULL),
(86, 'بكالريوس تربية نوعية', NULL),
(87, 'بكالريوس حاسبات', NULL),
(88, 'أمية', NULL);

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

--
-- Table structure for table `endvisitreports`
--

CREATE TABLE IF NOT EXISTS `endvisitreports` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patientid` int(11) NOT NULL,
  `reason` text,
  `enddate` date DEFAULT NULL,
  `notes` text,
  `doctorid` int(11) NOT NULL,
  `status` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `eprep`
--

CREATE TABLE IF NOT EXISTS `eprep` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ivfsheetid` int(11) unsigned DEFAULT NULL,
  `epreplps` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eprepcd` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lmpfrozen` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eprepdate` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eprepttt` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eprepe` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eprepro` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `epreplo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eprepcancel` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `thawingdate` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `thawingstn` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `thawingen` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cdlps` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `epreplps`
--

CREATE TABLE IF NOT EXISTS `epreplps` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=11 ;

--
-- Dumping data for table `epreplps`
--

INSERT INTO `epreplps` (`id`, `title`, `del`) VALUES
(1, '12xcv', NULL),
(2, 'progest 1x3-prontogest 1x2 d11', NULL),
(3, 'd11(13-11-2020)', NULL),
(4, '2 ch d14 -duph 1x3 d16-pronto amp 1x2-', NULL),
(5, 'progest 2x2-pronto 400 1x2(12-8-2021)', NULL),
(6, '2 ch d13- pronto 400 1x2+ duph 1x3 d15', NULL),
(7, 'prog1x3-Prontog1x2 d11(22/9/021)', NULL),
(8, 'cyclo, progest d14', NULL),
(9, 'progest ,prontogest  D14', NULL),
(10, '', NULL);

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

--
-- Table structure for table `examination`
--

CREATE TABLE IF NOT EXISTS `examination` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `patientid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `doctorid` int(11) unsigned DEFAULT NULL,
  `sysdate` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `examinationdate` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `weight` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `height` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bmi` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `b_p` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pulse` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rgb` varchar(191) CHARACTER SET utf8mb4 DEFAULT NULL,
  `headandneck` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `chestandheart` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `abdomen` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pelvis` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `extremitis` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  `bp2` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `examinationabdomen`
--

CREATE TABLE IF NOT EXISTS `examinationabdomen` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `examinationchest`
--

CREATE TABLE IF NOT EXISTS `examinationchest` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `examinationextremitis`
--

CREATE TABLE IF NOT EXISTS `examinationextremitis` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `examinationhead`
--

CREATE TABLE IF NOT EXISTS `examinationhead` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `del` int(11) unsigned DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `examinationlocalse`
--

CREATE TABLE IF NOT EXISTS `examinationlocalse` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=5 ;

--
-- Dumping data for table `examinationlocalse`
--

INSERT INTO `examinationlocalse` (`id`, `title`, `del`) VALUES
(1, 'gynecomast', NULL),
(2, 'undescended testis', NULL),
(3, 'atrophied testis', NULL),
(4, 'Lt', NULL);

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

--
-- Table structure for table `examinationpelvis`
--

CREATE TABLE IF NOT EXISTS `examinationpelvis` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `excelinfo`
--

CREATE TABLE IF NOT EXISTS `excelinfo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `time` datetime DEFAULT NULL,
  `serial` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=2 ;

--
-- Dumping data for table `excelinfo`
--

INSERT INTO `excelinfo` (`id`, `time`, `serial`) VALUES
(1, '2020-07-21 03:29:34', 'd2dc0d4a176d32a97932cebd7e737b14adc7ba654265aa43b3e7887301651afe531e1066a5b2f49112f18207cc741b3043e7678b1160efbeb3f18e5e2c995267');

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

--
-- Table structure for table `excelinfopatients`
--

CREATE TABLE IF NOT EXISTS `excelinfopatients` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patientid` int(11) NOT NULL,
  `statusno` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `familyhistory`
--

CREATE TABLE IF NOT EXISTS `familyhistory` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=23 ;

--
-- Dumping data for table `familyhistory`
--

INSERT INTO `familyhistory` (`id`, `title`, `del`) VALUES
(1, 'DM', NULL),
(2, 'HTN', NULL),
(3, 'cardiac', NULL),
(4, 'hepatic', NULL),
(5, 'renal', NULL),
(6, 'hypothyroid', NULL),
(7, 'cancer', NULL),
(8, 'DM', 1),
(9, 'DM', 1),
(10, 'DM', 1),
(11, 'breast cancer', NULL),
(12, 'twins', NULL),
(13, 'cancer breast', NULL),
(14, 'brain cancer', NULL),
(15, 'B.A', NULL),
(16, 'rh arthritis', NULL),
(17, 'down s', NULL),
(18, 'HCV', NULL),
(19, '1st marriage +ve consanguinity', NULL),
(20, 'cancer nose (father)', NULL),
(21, 'stomach cancer(father)', NULL),
(22, 'thyrotoxicosis', NULL);

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

--
-- Table structure for table `folliculom`
--

CREATE TABLE IF NOT EXISTS `folliculom` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `infertilitysheetid` int(11) unsigned DEFAULT NULL,
  `lmp` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ttt` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cd` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ro` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `endo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pelvis` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `too` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `result` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `followup`
--

CREATE TABLE IF NOT EXISTS `followup` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patientid` int(11) NOT NULL,
  `history` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `lmp` date NOT NULL,
  `eed` date NOT NULL,
  `ivf` date NOT NULL,
  `g` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `p` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0' COMMENT '1 end , 0 not yet ',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `followupcard`
--

CREATE TABLE IF NOT EXISTS `followupcard` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `enterdate` date DEFAULT NULL,
  `exitdate` date DEFAULT NULL,
  `date` date DEFAULT NULL,
  `patientid` int(11) NOT NULL,
  `doctorid` int(11) NOT NULL,
  `diagnosis` text NOT NULL,
  `status` int(11) NOT NULL,
  `deleted` int(11) DEFAULT '0',
  `deptid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `followupcarddrugs`
--

CREATE TABLE IF NOT EXISTS `followupcarddrugs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cardid` int(11) NOT NULL,
  `drugid` int(11) NOT NULL,
  `drugtype` varchar(250) NOT NULL,
  `drugdos` varchar(250) NOT NULL,
  `recepittmpid` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `followupdiagnosis`
--

CREATE TABLE IF NOT EXISTS `followupdiagnosis` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `followid` int(11) NOT NULL,
  `date` date NOT NULL,
  `diagnosis` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `del` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `followupexam`
--

CREATE TABLE IF NOT EXISTS `followupexam` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `followid` int(11) NOT NULL,
  `date` date NOT NULL,
  `exam` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `del` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `followupinvest`
--

CREATE TABLE IF NOT EXISTS `followupinvest` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `followid` int(11) NOT NULL,
  `date` date NOT NULL,
  `invest` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `del` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `followupvisit`
--

CREATE TABLE IF NOT EXISTS `followupvisit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `followid` int(11) NOT NULL,
  `date` date NOT NULL,
  `wt` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bp` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ga` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `us` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `del` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `generalanasthesa`
--

CREATE TABLE IF NOT EXISTS `generalanasthesa` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `del` int(11) NOT NULL,
  `anasthesaid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=41 ;

--
-- Dumping data for table `generalanasthesa`
--

INSERT INTO `generalanasthesa` (`id`, `name`, `del`, `anasthesaid`) VALUES
(1, 'I.V', 0, 1),
(2, 'mask', 0, 1),
(3, 'spinal', 0, 2),
(4, 'epidural', 0, 2),
(5, 'local infiltration', 0, 2),
(6, 'paracervical block', 0, 2),
(7, 'wwww', 0, 4),
(8, 'wwww', 0, 3),
(9, 'uuu', 0, 5),
(10, 'aatt', 0, 16),
(11, 'ee', 0, 16),
(12, 'w', 1, 2),
(13, 'eeq', 1, 2),
(14, 'tt', 1, 2),
(15, 'qqm', 1, 21),
(16, 'rr', 1, 21),
(17, 'ww', 1, 21),
(18, 'aaa11', 0, 21),
(19, 'rrrr', 1, 21),
(20, '222', 0, 16),
(21, 'yyyy', 0, 29),
(22, 'yyyy', 1, 29),
(23, 'bb', 0, 30),
(24, 'ssss', 0, 31),
(25, 'zzz', 0, 33),
(26, 'dddd', 1, 35),
(27, 'hhhh', 0, 37),
(28, 'iiii', 0, 36),
(29, 'gfgfg', 0, 0),
(30, 'www', 0, 1),
(31, 'ttt1', 0, 1),
(32, 'ggg', 0, 1),
(33, 'hhh', 0, 1),
(34, 'uuuu', 0, 1),
(35, 'اا', 0, 39),
(36, 'ثثث', 0, 39),
(37, 'بب', 0, 39),
(38, 'ddd', 0, 39),
(39, 'aa', 0, 39),
(40, 'bb', 0, 39);

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

--
-- Table structure for table `generalbreast`
--

CREATE TABLE IF NOT EXISTS `generalbreast` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=16 ;

--
-- Dumping data for table `generalbreast`
--

INSERT INTO `generalbreast` (`id`, `title`, `del`) VALUES
(1, 'galactorrhea ', NULL),
(2, 'fibroadenosis', NULL),
(3, 'small size', NULL),
(4, 'rt', NULL),
(5, 'lt', NULL),
(6, 'bilat', NULL),
(7, 'n', NULL),
(8, 'mobile', NULL),
(9, 'fixed', NULL),
(10, 'lump', NULL),
(11, 'lt UQ', NULL),
(12, 'small', NULL),
(13, 'rt small', NULL),
(14, '? small lump in lt upper outer quadrant+ bloody disch from nipple', NULL),
(15, 'rt: n', NULL);

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

--
-- Table structure for table `generalhirsutism`
--

CREATE TABLE IF NOT EXISTS `generalhirsutism` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=5 ;

--
-- Dumping data for table `generalhirsutism`
--

INSERT INTO `generalhirsutism` (`id`, `title`, `del`) VALUES
(1, 'no', NULL),
(2, 'mild', NULL),
(3, 'mod', NULL),
(4, 'severe', NULL);

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

--
-- Table structure for table `generalthyroid`
--

CREATE TABLE IF NOT EXISTS `generalthyroid` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `generalthyroid`
--

INSERT INTO `generalthyroid` (`id`, `title`, `del`) VALUES
(1, 'goitre', NULL),
(2, 'n', NULL),
(3, 'total thyroidectomy', NULL);

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

--
-- Table structure for table `gtdetail`
--

CREATE TABLE IF NOT EXISTS `gtdetail` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `gtid` int(11) unsigned DEFAULT NULL,
  `posx` double DEFAULT NULL,
  `posy` double DEFAULT NULL,
  `width` int(11) unsigned DEFAULT NULL,
  `height` int(11) unsigned DEFAULT NULL,
  `imgno` int(11) unsigned DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  `comment` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `gtimage`
--

CREATE TABLE IF NOT EXISTS `gtimage` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `gdate` date DEFAULT NULL,
  `patientid` int(11) unsigned DEFAULT NULL,
  `doctorid` int(11) unsigned DEFAULT NULL,
  `gtid` int(11) unsigned DEFAULT NULL,
  `comment` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  `pic` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `programview` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `gyna`
--

CREATE TABLE IF NOT EXISTS `gyna` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `patientid` int(11) unsigned DEFAULT NULL,
  `gynadate` date DEFAULT NULL,
  `complaint` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `diagnosisid` text COLLATE utf8mb4_unicode_ci,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `conditions` int(11) unsigned DEFAULT NULL,
  `doctorid` int(11) unsigned DEFAULT NULL,
  `diagnosistxt` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `complaintid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `inf_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `inf_since_y` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `inf_since_m` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `inf_stay_y` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `inf_stay_m` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `inf_stay_hus` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `inf_abortion` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `inf_semen` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `inf_fsh` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `inf_lh` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `inf_tsh` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `inf_prl` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `inf_amh` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `inf_hsg` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `inf_note` text COLLATE utf8mb4_unicode_ci,
  `gynalmp` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `gynadrugs`
--

CREATE TABLE IF NOT EXISTS `gynadrugs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patientid` int(11) NOT NULL,
  `date` date NOT NULL,
  `drugid` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drugtype` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drugdos` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0',
  `doctorid` int(11) NOT NULL,
  `drugname` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `forhusband` int(11) unsigned DEFAULT NULL,
  `recepittmpid` int(11) DEFAULT '0',
  `recepitdrugid` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `gynainfertility`
--

CREATE TABLE IF NOT EXISTS `gynainfertility` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patientid` int(11) NOT NULL,
  `note` text COLLATE utf8mb4_unicode_ci,
  `date` date DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `since_y` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `since_m` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stay_y` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stay_m` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stay_hus` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `abortion` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `semen` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fsh` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lh` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tsh` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `prl` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amh` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hsg` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `gynainfertilityplan`
--

CREATE TABLE IF NOT EXISTS `gynainfertilityplan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patientid` int(11) NOT NULL,
  `plan` text COLLATE utf8mb4_unicode_ci,
  `itr` int(11) DEFAULT '0',
  `deleted` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `gynainfertilitytype`
--

CREATE TABLE IF NOT EXISTS `gynainfertilitytype` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text COLLATE utf8mb4_unicode_ci,
  `deleted` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `gynainvestigation`
--

CREATE TABLE IF NOT EXISTS `gynainvestigation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patientid` int(11) NOT NULL,
  `date` date NOT NULL,
  `investid` int(11) NOT NULL,
  `investresult` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0',
  `doctorid` int(11) NOT NULL,
  `forhusband` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `gynasheet`
--

CREATE TABLE IF NOT EXISTS `gynasheet` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patientid` int(11) unsigned DEFAULT NULL,
  `usvsdtv` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `importantnote` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `gynasheetdrugs`
--

CREATE TABLE IF NOT EXISTS `gynasheetdrugs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patientid` int(11) NOT NULL,
  `date` date NOT NULL,
  `drugid` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drugtype` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drugdos` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0',
  `doctorid` int(11) NOT NULL,
  `drugname` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `forhusband` int(11) unsigned DEFAULT NULL,
  `recepittmpid` int(11) DEFAULT '0',
  `recepitdrugid` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `gynasheetinvest`
--

CREATE TABLE IF NOT EXISTS `gynasheetinvest` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patientid` int(11) NOT NULL,
  `date` date NOT NULL,
  `investid` int(11) NOT NULL,
  `investresult` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0',
  `doctorid` int(11) NOT NULL,
  `forhusband` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `gynaus`
--

CREATE TABLE IF NOT EXISTS `gynaus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patientid` int(11) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `day` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `endo` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovrayll` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovraylw` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovraylv` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovraylno` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovraylsize` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovrayrl` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovrayrw` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovrayrv` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovrayrno` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovrayrsize` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uterusl` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uterusw` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uterusv` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cervixl` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cervixw` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cervixv` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `lfolliclesno` int(11) NOT NULL DEFAULT '0',
  `rfolliclesno` int(11) NOT NULL DEFAULT '0',
  `doctorid` int(11) NOT NULL,
  `deleted` int(11) DEFAULT '0',
  `mainantenatalid` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT COMMENT='ultrasound for gyna visits' AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `gynausficils`
--

CREATE TABLE IF NOT EXISTS `gynausficils` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gynausid` int(11) NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `length` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `width` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `volume` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` int(11) NOT NULL DEFAULT '0',
  `sysdate` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `help`
--

CREATE TABLE IF NOT EXISTS `help` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tempdelete` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `histopath`
--

CREATE TABLE IF NOT EXISTS `histopath` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=8 ;

--
-- Dumping data for table `histopath`
--

INSERT INTO `histopath` (`id`, `title`, `del`) VALUES
(1, 'simple EH without atypia', NULL),
(2, '', NULL),
(3, '', NULL),
(4, '', NULL),
(5, 'incomplete v.mole', NULL),
(6, 'disordered prolif endo -response of anovulation- fibroid ut??', NULL),
(7, 'ut:small submucous fibroid-focal adenomyosis-simple EH without atypia . cx: ch.non specific cervitis . tubes: n', NULL);

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

--
-- Table structure for table `hormon`
--

CREATE TABLE IF NOT EXISTS `hormon` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `sdate` date DEFAULT NULL,
  `patientid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  `lh` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `prl` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `etwo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amh` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `freet` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `totalt` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pfour` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tsh` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tthree` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dht` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bhcg` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `inhibinb` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `asd` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tfour` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dheas` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fsh` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `doctorid` int(11) unsigned DEFAULT NULL,
  `ca125` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cea` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `calgg` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ldh` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tfehprotein` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `hormonalprofile`
--

CREATE TABLE IF NOT EXISTS `hormonalprofile` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `infertilitysheetid` int(11) unsigned DEFAULT NULL,
  `datefsh` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `datelh` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `datett` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dateprl` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `datee2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dateinhibin` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dateother` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dateother1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `resultfsh` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `resultlh` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `resulttt` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `resultprl` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `resulte2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `resultinhibin` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `resultother` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `resultother1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `hormonalprofile2`
--

CREATE TABLE IF NOT EXISTS `hormonalprofile2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `infertilitysheetid` int(11) unsigned DEFAULT NULL,
  `dateother` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `datep4` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `datee2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `datelh` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `datefsh` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dateprl` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `datetsh` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dateamh` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `resultamh` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `resulttsh` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `resultprl` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `resultfsh` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `resultlh` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `resulte2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `resultp4` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `resultother` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `hospitalnames`
--

CREATE TABLE IF NOT EXISTS `hospitalnames` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `hsg`
--

CREATE TABLE IF NOT EXISTS `hsg` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `sdate` date DEFAULT NULL,
  `patientid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  `uterus` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ltube` text COLLATE utf8mb4_unicode_ci,
  `notes` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `smear` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rtube` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `doctorid` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `hsginfertility`
--

CREATE TABLE IF NOT EXISTS `hsginfertility` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `infertilitysheetid` int(11) unsigned DEFAULT NULL,
  `hsgut` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hsgplace` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hsgrt` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hsglt` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hsgpelvis` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `hsglt`
--

CREATE TABLE IF NOT EXISTS `hsglt` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=28 ;

--
-- Dumping data for table `hsglt`
--

INSERT INTO `hsglt` (`id`, `title`, `del`) VALUES
(1, 'n', NULL),
(2, 'block', NULL),
(3, 'hydrosalpnix', NULL),
(4, 'peritubal adhesions', NULL),
(5, 'proximal', NULL),
(6, 'distal', NULL),
(7, 'mild', NULL),
(8, 'mod', NULL),
(9, 'severe', NULL),
(10, '?', NULL),
(11, 'little immed spill', NULL),
(12, 'no immed spill', NULL),
(13, 'little delayed spill', NULL),
(14, 'no delayed spill', NULL),
(15, 'suspended to lat pelvic wall', NULL),
(16, '?? delayed spill', NULL),
(17, '?? proximal block', NULL),
(18, '?? pelvic adhesion', NULL),
(19, '???', NULL),
(20, '?? peritubal adhesions', NULL),
(21, '', NULL),
(22, 'mod/severe hydrosapinx(distal) with distal block ', NULL),
(23, 'proximal block ( just short segment of tube appeared)', NULL),
(24, '', NULL),
(25, 'patent', NULL),
(26, '?? suspended up to lat pelvic wall', NULL),
(27, '?? adhesions', NULL);

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

--
-- Table structure for table `hsgpelvis`
--

CREATE TABLE IF NOT EXISTS `hsgpelvis` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `hsgpelvis`
--

INSERT INTO `hsgpelvis` (`id`, `title`, `del`) VALUES
(1, '---', NULL),
(2, '?? pelvic adhesions', NULL);

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

--
-- Table structure for table `hsgplace`
--

CREATE TABLE IF NOT EXISTS `hsgplace` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=32 ;

--
-- Dumping data for table `hsgplace`
--

INSERT INTO `hsgplace` (`id`, `title`, `del`) VALUES
(1, 'مركز عابدين', NULL),
(2, 'مركز الحياه', NULL),
(3, 'مركز بدير', NULL),
(4, 'شربين', NULL),
(5, '  دمياط الجديده', NULL),
(6, 'مركز دمياط للاشعه', NULL),
(7, 'مركز النيل سكان', NULL),
(8, 'سمارت سكان بورسعيد', NULL),
(9, 'طلال عامر', NULL),
(10, 'مركز عابدين - د.عمرو', NULL),
(11, 'مركز بدير- ابو شحاته', NULL),
(12, 'م. عابدين -د.هبه', NULL),
(13, 'م. بدير-ابو شحاته', NULL),
(14, 'مركز حنا', NULL),
(15, 'م.دمياط للاشعه- السعيد حموده', NULL),
(16, 'م.عابدين -مطر', NULL),
(17, 'عصام الشويحي', NULL),
(18, 'م.دمياط-د حاÙظ', NULL),
(19, 'م.عابدين-جمال ورده', NULL),
(20, NULL, NULL),
(21, 'م.الحياه- د. عمرو', NULL),
(22, 'م. الايمان', NULL),
(23, 'بدير-الشربيني', NULL),
(24, 'الشروق د.علاء مجاهد', NULL),
(25, 'الحياة د.هبة', NULL),
(26, 'مركز العطاء', NULL),
(27, 'مركز مصر للاشعه', NULL),
(28, 'د.مصطÙي العوضي- اجا', NULL),
(29, 'م.الروضه سكان-د.هانم', NULL),
(30, 'د.مهدي المزاحي', NULL),
(31, 'مركز الايمان', NULL);

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

--
-- Table structure for table `hsgrt`
--

CREATE TABLE IF NOT EXISTS `hsgrt` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=28 ;

--
-- Dumping data for table `hsgrt`
--

INSERT INTO `hsgrt` (`id`, `title`, `del`) VALUES
(1, 'n', NULL),
(2, 'block', NULL),
(3, 'hydrosalpnix', NULL),
(4, 'peritubal adhesions', NULL),
(5, 'proximal', NULL),
(6, 'distal', NULL),
(7, 'mild', NULL),
(8, 'mod', NULL),
(9, 'severe', NULL),
(10, '?', NULL),
(11, 'little immed spill', NULL),
(12, 'no immed spill', NULL),
(13, 'little delayed spill', NULL),
(14, 'no delayed spill', NULL),
(15, 'suspended to lat pelvic wall', NULL),
(16, '', NULL),
(17, 'suspended to lat pel wall', NULL),
(18, '???', NULL),
(19, '?? inadequate dye', NULL),
(20, '?? pelvic adhesion', NULL),
(21, '?? peritubal adhesions', NULL),
(22, ' distal block', NULL),
(23, 'proximal block ( just short segment of tube appeared )', NULL),
(24, 'mod to severe', NULL),
(25, 'Mod/Severe Hydrosapinx(Distal) With Distal Block ', NULL),
(26, 'patent', NULL),
(27, 'adhesions', NULL);

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

--
-- Table structure for table `hsgut`
--

CREATE TABLE IF NOT EXISTS `hsgut` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=15 ;

--
-- Dumping data for table `hsgut`
--

INSERT INTO `hsgut` (`id`, `title`, `del`) VALUES
(1, 'n', NULL),
(2, 'filling defect', NULL),
(3, 'arcuate', NULL),
(4, 'subseptate / bicornuate', NULL),
(5, 't shaped', NULL),
(6, 'T Shaped arcuate', NULL),
(7, 'subseptate ut', NULL),
(8, 'seems to be normal', NULL),
(9, 'mild Arcuate', NULL),
(10, 'v.mild arcuate', NULL),
(11, '?', NULL),
(12, 'mild broad shallow arcuate ut', NULL),
(13, '--', NULL),
(14, 'irreg fundus', NULL);

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

--
-- Table structure for table `husbandjobs`
--

CREATE TABLE IF NOT EXISTS `husbandjobs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(55) NOT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT AUTO_INCREMENT=89 ;

--
-- Dumping data for table `husbandjobs`
--

INSERT INTO `husbandjobs` (`id`, `title`, `del`) VALUES
(1, 'محاسب', NULL),
(2, 'إسترجى', NULL),
(3, 'Ùلاح', NULL),
(4, 'حلوانى', NULL),
(5, 'تاجر أسماك', NULL),
(6, 'مدرس', NULL),
(7, 'مهندس', NULL),
(8, 'نجار', NULL),
(9, 'موظÙ Ùي شركة المياة', NULL),
(10, 'تاجر حديد وبويات', NULL),
(11, 'استرجى', NULL),
(12, 'اويمجى', NULL),
(13, 'عامل', NULL),
(14, 'تاجر موبليا', NULL),
(15, 'قهوى', NULL),
(16, 'أعمال حره', NULL),
(17, 'مدرس رياضيات', NULL),
(18, 'منجد', NULL),
(19, 'شيÙ', NULL),
(20, 'سباك', NULL),
(21, 'تاجر سيارات', NULL),
(22, 'سواق', NULL),
(23, 'تاجر أخشاب', NULL),
(24, 'مستورد أخشاب', NULL),
(25, 'أستورجي', NULL),
(26, 'صياد', NULL),
(27, 'دكتور عيون', NULL),
(28, 'موظÙ Ùي المينا', NULL),
(29, 'بنك Ùيصل', NULL),
(30, 'محامي', NULL),
(31, 'مندوب شركة أدوية', NULL),
(32, 'موظÙ Ùي مجلس المحلة ', NULL),
(33, 'كهربائى', NULL),
(34, 'تاجر ملابس', NULL),
(35, 'مدرس كمبيوتر', NULL),
(36, 'صيدلة', NULL),
(37, 'مدهباتى', NULL),
(38, 'صاحب محل ', NULL),
(39, 'محامى', NULL),
(40, 'موظÙ Ùي المحكمة', NULL),
(41, 'مدرس لغة عربية', NULL),
(42, 'مندوب مبيعات', NULL),
(43, 'ميكانيكى سيارات', NULL),
(44, 'موظÙ Ùي Ùندق', NULL),
(45, 'تشطيب ديكورات', NULL),
(46, 'مدرس  ثانوى بحرى', NULL),
(47, 'نقاش', NULL),
(48, 'مدير مدرسة التجارة', NULL),
(49, 'قشرجى', NULL),
(50, 'مدير صيانة Ùي شركة', NULL),
(51, 'مصصم اثات', NULL),
(52, 'استاذ دكتور', NULL),
(53, 'معمل المشترك', NULL),
(54, 'بياع', NULL),
(55, 'ممرض إسعاÙ', NULL),
(56, 'موظÙ Ùى معهد الاورام', NULL),
(57, 'مندوب مستلزمات طبية', NULL),
(58, 'عامل Ùي مسجد', NULL),
(59, 'تاجر أدوات كهربائية', NULL),
(60, 'صاحب سوبر ماركت', NULL),
(61, 'حارس أمني', NULL),
(62, 'مذيع تلÙزيزني', NULL),
(63, 'مدير مطعم', NULL),
(64, 'تاجر أكسسوار سيارات', NULL),
(65, 'محل موبيلات', NULL),
(66, 'دعاية واعلان', NULL),
(67, 'عامل Ùي المينا', NULL),
(68, 'عامل Ùي المينا', NULL),
(69, 'عامل Ùي المينا', NULL),
(70, 'Ùني تصنيع معادن', NULL),
(71, 'تاجر قطع غيارات سيارات', NULL),
(72, 'موظÙ Ùي بنك', NULL),
(73, 'جبس Ùرم', NULL),
(74, 'شركة برمجة', NULL),
(75, 'مÙتيش بضايع بحرى ', NULL),
(76, 'موظÙ Ùي شركة حاويات', NULL),
(77, 'تاجر عربيات', NULL),
(78, 'لايعمل', NULL),
(79, 'مبلط', NULL),
(80, 'مهندس زراعى', NULL),
(81, 'عامل  Ùي مصنع', NULL),
(82, 'عامل Ùي معرض', NULL),
(83, 'عامل Ùي معرض', NULL),
(84, 'مدرس Ùرنساوي', NULL),
(85, 'طبيب أسنان', 0),
(86, 'طبيب أسنان', 0),
(87, 'مصنع الغزل والنسيج', NULL),
(88, 'موظÙ أمن', NULL);

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

--
-- Table structure for table `husbandtypes`
--

CREATE TABLE IF NOT EXISTS `husbandtypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT AUTO_INCREMENT=4 ;

--
-- Dumping data for table `husbandtypes`
--

INSERT INTO `husbandtypes` (`id`, `title`, `del`) VALUES
(1, 'استاذ', NULL),
(2, 'الشيÙ', NULL),
(3, 'الدكتور', NULL);

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

--
-- Table structure for table `husbndiagnosis1`
--

CREATE TABLE IF NOT EXISTS `husbndiagnosis1` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=21 ;

--
-- Dumping data for table `husbndiagnosis1`
--

INSERT INTO `husbndiagnosis1` (`id`, `title`, `del`) VALUES
(1, 'Diagnosis1', 1),
(2, 'Diagnosis2', 1),
(3, 'Diagnosis3', 1),
(4, 'emo', 1),
(5, 'emoo', 1),
(6, 'ytyyr', 1),
(7, 'er', 1),
(8, 'cc', 1),
(9, 'tttttttttttttt', 1),
(10, 'f', 1),
(11, 'ff', 1),
(12, 'Hypo-Hypo', NULL),
(13, 'Hyper-Hypo', NULL),
(14, 'Normo-Hypo', NULL),
(15, 'OA', NULL),
(16, 'N', NULL),
(17, 'dm', 1),
(18, 'htn', 1),
(19, 'mn', 1),
(20, 'NOA', NULL);

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

--
-- Table structure for table `husbndiagnosis2`
--

CREATE TABLE IF NOT EXISTS `husbndiagnosis2` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=12 ;

--
-- Dumping data for table `husbndiagnosis2`
--

INSERT INTO `husbndiagnosis2` (`id`, `title`, `del`) VALUES
(1, 'Diagnosis21', 1),
(2, 'Diagnosis22', 1),
(3, 'k', 1),
(4, 'Oligo', NULL),
(5, 'Astheno', NULL),
(6, 'Terato', NULL),
(7, 'OAT', NULL),
(8, 'NOA', NULL),
(9, 'small testes', NULL),
(10, 'AZO', NULL),
(11, 'Aspermia', NULL);

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

--
-- Table structure for table `husbndiagnosis3`
--

CREATE TABLE IF NOT EXISTS `husbndiagnosis3` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=16 ;

--
-- Dumping data for table `husbndiagnosis3`
--

INSERT INTO `husbndiagnosis3` (`id`, `title`, `del`) VALUES
(1, 'mild', NULL),
(2, 'Diagnosis31', 1),
(3, 'hhhhhhhhhhhhhh', 1),
(4, 'severe', NULL),
(5, 'sertoli cell only', NULL),
(6, 'klinefilter', NULL),
(7, 'kallman', NULL),
(8, 'yq micro del', NULL),
(9, 'Mumps', NULL),
(10, 'TB', NULL),
(11, 'CBAVD', NULL),
(12, 'chemo', NULL),
(13, 'impotence', NULL),
(14, 'PME', NULL),
(15, 'RGE', NULL);

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

--
-- Table structure for table `hus_previous_marriage`
--

CREATE TABLE IF NOT EXISTS `hus_previous_marriage` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `period` varchar(255) DEFAULT NULL,
  `males` int(11) DEFAULT '0',
  `females` int(11) DEFAULT '0',
  `last_age` varchar(255) DEFAULT NULL,
  `deleted` int(11) DEFAULT '0',
  `patientid` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `hysteroscopy`
--

CREATE TABLE IF NOT EXISTS `hysteroscopy` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `sdate` date DEFAULT NULL,
  `patientid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  `cervix` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uterine` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rostium` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lostium` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `doctorid` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `hysteroscopyinfertility`
--

CREATE TABLE IF NOT EXISTS `hysteroscopyinfertility` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `infertilitysheetid` int(11) unsigned DEFAULT NULL,
  `copydil` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `copycx` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `copyintrod` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `copycavity` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `copyplace` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `copymcx` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `copyrostium` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `copylostium` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `copymcavity` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `copymrostium` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `copymlostium` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hysintervention` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `coast` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `icsi`
--

CREATE TABLE IF NOT EXISTS `icsi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `infertilitysheetid` int(11) unsigned DEFAULT NULL,
  `icsiprotocol` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icsiplace` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icsisemen` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icsiresult` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `refr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vd` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `et` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icsiss` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fert` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `opu` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `e2d2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `icsiplace`
--

CREATE TABLE IF NOT EXISTS `icsiplace` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=34 ;

--
-- Dumping data for table `icsiplace`
--

INSERT INTO `icsiplace` (`id`, `title`, `del`) VALUES
(1, 'م.الأهرام د.عمرو عديل', NULL),
(2, 'م.رويال د.عمرو عديل', NULL),
(3, 'د.محمد Ùضل', 1),
(4, 'د.محمد Ùضل', 1),
(5, 'د.محمد Ùضل', 1),
(6, 'د.محمد Ùضل', NULL),
(7, 'د.عزمي صالح اسكندريه', NULL),
(8, 'د. الشربيني', NULL),
(9, '', NULL),
(10, 'د. عبد الحميد مطاوع', NULL),
(11, 'د.محمود سامي', NULL),
(12, 'د.اشرÙ مطر-دار الامومه', NULL),
(13, 'دار الطب القاهره', NULL),
(14, 'المركز السامي', NULL),
(15, 'ابو الÙار', NULL),
(16, 'د.محمد مطاوع', NULL),
(17, ']', 1),
(18, ']', 1),
(19, 'د.حسن يوسÙ', NULL),
(20, '', NULL),
(21, 'م.كوينز-اشرÙ قرطام', NULL),
(22, 'د.ياسر الشهاوي-دار الامومه', NULL),
(23, 'د.محمد Ùرحات-م.ابوالغار', NULL),
(24, 'د.عامر شتا -م.الÙيروز', NULL),
(25, 'د.حسام زكي', NULL),
(26, NULL, NULL),
(27, 'd/amr adeel', NULL),
(28, 'د.عبد اللطيÙ سويلم-الحياه', NULL),
(29, 'د.علاء مجاهد', NULL),
(30, 'م.نور الحياة القاهرة', NULL),
(31, 'م. جنين القاهره', NULL),
(32, 'د.وائل البنا -حياه', NULL),
(33, '', NULL);

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

--
-- Table structure for table `icsiprotocol`
--

CREATE TABLE IF NOT EXISTS `icsiprotocol` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=6 ;

--
-- Dumping data for table `icsiprotocol`
--

INSERT INTO `icsiprotocol` (`id`, `title`, `del`) VALUES
(1, 'long ag', NULL),
(2, 'antag', NULL),
(3, 'short ag', NULL),
(4, 'fET', NULL),
(5, 'FET', NULL);

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

--
-- Table structure for table `icsiresult`
--

CREATE TABLE IF NOT EXISTS `icsiresult` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `icsiresult`
--

INSERT INTO `icsiresult` (`id`, `title`, `del`) VALUES
(1, '+ve', NULL),
(2, '-ve', NULL),
(3, '+ve then EPL', NULL);

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

--
-- Table structure for table `icsisemen`
--

CREATE TABLE IF NOT EXISTS `icsisemen` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=10 ;

--
-- Dumping data for table `icsisemen`
--

INSERT INTO `icsisemen` (`id`, `title`, `del`) VALUES
(1, 'sample', NULL),
(2, 'TESA', NULL),
(3, 'TESE', NULL),
(4, 'fresh sample', 1),
(5, 'fresh sample', 1),
(6, 'mic TESE', NULL),
(7, '-ve Mic TESE', NULL),
(8, '', NULL),
(9, '', NULL);

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

--
-- Table structure for table `icsiss`
--

CREATE TABLE IF NOT EXISTS `icsiss` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `icsiss`
--

INSERT INTO `icsiss` (`id`, `title`, `del`) VALUES
(1, '--', NULL),
(2, 'm', NULL),
(3, 'f', NULL);

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

--
-- Table structure for table `importbill`
--

CREATE TABLE IF NOT EXISTS `importbill` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoicenum` varchar(50) NOT NULL,
  `invoicedate` date NOT NULL,
  `suppliers` varchar(100) NOT NULL,
  `receiveuser` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `importdetails`
--

CREATE TABLE IF NOT EXISTS `importdetails` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bill_id` int(11) NOT NULL,
  `drug_id` int(11) NOT NULL,
  `amount` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `index_foreignkey_importdetails_importbill` (`bill_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `importtdetails`
--

CREATE TABLE IF NOT EXISTS `importtdetails` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `bill_id` int(11) unsigned DEFAULT NULL,
  `drug_id` int(11) unsigned DEFAULT NULL,
  `amount` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `infertility`
--

CREATE TABLE IF NOT EXISTS `infertility` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patientid` int(11) NOT NULL,
  `marriage` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `menstr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `operations` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sexualhistory` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `breast` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hirsuitism` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sexch` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `obesity` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `infertilitydiagnosis`
--

CREATE TABLE IF NOT EXISTS `infertilitydiagnosis` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `infertid` int(11) NOT NULL,
  `date` date NOT NULL,
  `diagnosiswife` text COLLATE utf8mb4_unicode_ci,
  `diagnosishusband` text COLLATE utf8mb4_unicode_ci,
  `del` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `infertilitydrugs`
--

CREATE TABLE IF NOT EXISTS `infertilitydrugs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patientid` int(11) NOT NULL,
  `date` date NOT NULL,
  `drugid` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drugtype` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drugdos` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0',
  `doctorid` int(11) NOT NULL,
  `drugname` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `forhusband` int(11) unsigned DEFAULT NULL,
  `recepittmpid` int(11) DEFAULT '0',
  `recepitdrugid` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `infertilitygyna`
--

CREATE TABLE IF NOT EXISTS `infertilitygyna` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `infertid` int(11) NOT NULL,
  `date` date NOT NULL,
  `vagina` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `exam` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sounding` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `adenxae` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `infertilityinvest`
--

CREATE TABLE IF NOT EXISTS `infertilityinvest` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `infertid` int(11) NOT NULL,
  `date` date NOT NULL,
  `semen` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `peg` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hsg` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pct` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `us` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `prolactin` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `thyr` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fsh` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lh` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `laparoscopy` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `infertilitylmp`
--

CREATE TABLE IF NOT EXISTS `infertilitylmp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `infertid` int(11) NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `infertilitynotes`
--

CREATE TABLE IF NOT EXISTS `infertilitynotes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `infertid` int(11) NOT NULL,
  `date` date NOT NULL,
  `note` text COLLATE utf8mb4_unicode_ci,
  `del` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `infertilitysheet`
--

CREATE TABLE IF NOT EXISTS `infertilitysheet` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patientid` int(11) unsigned DEFAULT NULL,
  `obstg` int(11) unsigned DEFAULT NULL,
  `obstp` int(11) unsigned DEFAULT NULL,
  `obstft` int(11) unsigned DEFAULT NULL,
  `obstpt` int(11) unsigned DEFAULT NULL,
  `obstepc` int(11) unsigned DEFAULT NULL,
  `obstliving` int(11) unsigned DEFAULT NULL,
  `sheettype` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sheetyear` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sheetmonth` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `husbndiagnosis1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `husbndiagnosis2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `husbndiagnosis3` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sheetttt` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `diagnosis` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tttda` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tttmetformin` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ttttype` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tttresponse` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sheettrials` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sheetdate` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sheetresult` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sheethusband` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sheetwife` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sheetother` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `generalbw` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `generalbmi` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `generalbreast` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `generalhirsutism` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `generalthyroid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `localvulva` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `localvagina` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `localcx` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `localother` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `localother1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `menstrualreg` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wmenstrualcd` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `menstrualamount` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `menstrualdysm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wmenstruallmp` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wsexual` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `medicalhistory` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `w2medical` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `surgicalhistory` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wsurgical` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `familyhistory` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wfamily` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `examinationgeneral` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `examinationlocalse` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `examinationlocalnote` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sheetlocation` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `historyduration` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `historyin` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `historyout` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `medicalhistorydm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `medicalhistorynote` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `surgicalhistorydm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `surgicalhistorynote` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `usvsdtv` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `importantnote` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `menstrualh` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `infertilitysheetdrugs`
--

CREATE TABLE IF NOT EXISTS `infertilitysheetdrugs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patientid` int(11) NOT NULL,
  `date` date NOT NULL,
  `drugid` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drugtype` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drugdos` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0',
  `doctorid` int(11) NOT NULL,
  `drugname` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `forhusband` int(11) unsigned DEFAULT NULL,
  `recepittmpid` int(11) DEFAULT '0',
  `recepitdrugid` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `infertilitysheetinvest`
--

CREATE TABLE IF NOT EXISTS `infertilitysheetinvest` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patientid` int(11) NOT NULL,
  `date` date NOT NULL,
  `investid` int(11) NOT NULL,
  `investresult` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0',
  `doctorid` int(11) NOT NULL,
  `forhusband` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `instruction`
--

CREATE TABLE IF NOT EXISTS `instruction` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patientid` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `tempdelete` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `investcats`
--

CREATE TABLE IF NOT EXISTS `investcats` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0',
  `displayorder` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT COMMENT='cats for invests appear in gyna and antenatal ' AUTO_INCREMENT=23 ;

--
-- Dumping data for table `investcats`
--

INSERT INTO `investcats` (`id`, `name`, `deleted`, `displayorder`) VALUES
(1, '3- Chemistry', 0, 2),
(2, '10- Urine & Stool', 0, 7),
(3, '1- Hematology', 0, 1),
(4, '7- virology', 0, 5),
(5, '4- Hormonal profile', 0, 3),
(6, '2- coagulation profile', 0, 8),
(7, '9- auto ab (Immunology)', 0, 4),
(8, '5- tumor markers', 0, 6),
(9, '12- Genetics', 0, 9),
(10, 'pre operative / ICSI', 0, 0),
(11, '11- semen - Male', 0, 10),
(12, 'Others', 0, 0),
(13, 'Old Favorite', 0, -1),
(14, 'Radiological', 0, 11),
(15, '', 1, 12),
(16, 'aNC (booking)', 0, 13),
(17, '', 1, 14),
(18, '', 1, 15),
(19, 'ANC (27 w)', 0, 16),
(20, '6- aneuploidy screening', 0, 17),
(21, '8- bacteriology', 0, 18),
(22, '13- pathology', 1, 19);

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

--
-- Table structure for table `investigations`
--

CREATE TABLE IF NOT EXISTS `investigations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ancsheetid` int(11) unsigned DEFAULT NULL,
  `invesdhb` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invesdplat` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invesdfbs` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invesdogtt` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invesdhbs` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invesdhcv` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invesdcua` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invesdferr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `investhb` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `investplat` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `investfbs` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `investhbs` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `investhcv` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `investcua` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `investferr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `invests`
--

CREATE TABLE IF NOT EXISTS `invests` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `investcatid` int(11) NOT NULL,
  `name` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `favorite` int(11) NOT NULL DEFAULT '0',
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT COMMENT=' invests appear in gyna and antenatal ' AUTO_INCREMENT=277 ;

--
-- Dumping data for table `invests`
--

INSERT INTO `invests` (`id`, `investcatid`, `name`, `favorite`, `deleted`) VALUES
(1, 3, 'ABO group', 0, 0),
(2, 3, 'Rh factor', 0, 0),
(3, 3, 'CBC', 0, 0),
(4, 3, 'Hb%', 0, 0),
(5, 3, 'RBCs indices', 0, 0),
(6, 3, 'platelets', 0, 0),
(7, 3, 'WBCs', 0, 0),
(8, 3, 'reticulocytic count', 0, 0),
(9, 3, 'indirect coombs', 0, 0),
(10, 3, 'Serum Ferritin', 0, 0),
(11, 1, 'LIVER f.t: SGPT', 0, 0),
(12, 1, 'SGOT', 0, 0),
(13, 1, 'Bilirubin (Total)', 0, 0),
(14, 1, 'Bilirubin (direct)', 0, 0),
(15, 1, 'Albumin', 0, 0),
(16, 1, 'alk ph', 0, 0),
(17, 1, 'bile acids', 0, 0),
(18, 1, 'kIDNEY f.t: Creatinine', 0, 0),
(19, 1, 'cr clearance', 0, 0),
(20, 1, 'urea', 0, 0),
(21, 1, 'uric acid ', 0, 0),
(22, 1, 'na', 0, 0),
(23, 1, 'k', 0, 0),
(24, 1, 'bicarb', 0, 0),
(25, 1, 'Ca', 0, 0),
(26, 1, 'Phosphorus', 0, 0),
(27, 1, ' LIPID PROFILE (cholesterol - TG)', 0, 0),
(28, 1, 'bL SUGAR PROFILE: FBS', 0, 0),
(29, 5, 'FSH', 0, 0),
(30, 5, 'LH', 0, 0),
(31, 5, 'E2', 0, 0),
(32, 5, 'Progesterone', 0, 0),
(33, 5, 'midluteal Prog', 0, 0),
(34, 5, 'AMH', 0, 0),
(35, 5, 'Free T3', 0, 0),
(36, 5, 'Free T4', 0, 0),
(37, 5, 'TSH', 0, 0),
(38, 5, 'PRL', 0, 0),
(39, 5, 'cortisol (am-pm)', 0, 0),
(40, 5, 'dexa supp test', 0, 0),
(41, 5, 't (total)', 0, 0),
(42, 5, 't (free)', 0, 0),
(43, 5, 'DHEA-S', 0, 0),
(44, 5, '17 OHP', 0, 0),
(45, 5, 'HCG (Qualitative)', 0, 0),
(46, 5, 'HCG (Quantitative)', 0, 0),
(47, 5, '', 0, 1),
(48, 5, '', 0, 1),
(49, 5, 'PTH', 0, 0),
(50, 5, 'Free Beta HCG', 0, 1),
(51, 5, 'PAPPA', 0, 1),
(52, 5, 'AFP', 0, 1),
(53, 5, 'HCG', 0, 1),
(54, 5, 'E3 ', 0, 1),
(55, 7, 'Lupus Anticoagulant', 0, 0),
(56, 7, 'Anticardiolipin  IgG', 0, 0),
(57, 7, 'Anticardiolipin  IgM', 0, 0),
(58, 7, 'Anti B2GP IgG ', 0, 0),
(59, 7, 'Anti B2GP IgM', 0, 0),
(60, 7, 'ANA', 0, 0),
(61, 7, 'Anti ds DNA', 0, 0),
(62, 7, 'RF', 0, 0),
(63, 7, 'anti CCP', 0, 0),
(64, 4, 'Toxoplasma IgM ', 0, 0),
(65, 4, 'Toxoplasma IgG', 0, 0),
(66, 4, 'Rubella IgM ', 0, 0),
(67, 4, 'Rubella IgG', 0, 0),
(68, 4, 'VZV (IgG)', 0, 0),
(69, 4, 'HSV IgM', 0, 0),
(70, 4, 'HSV IgG', 0, 0),
(71, 4, 'CMV IgM', 0, 0),
(72, 4, ' CMV IgG', 0, 0),
(73, 4, '', 0, 1),
(74, 4, 'HBs Ag', 0, 0),
(75, 4, 'HBs Ab', 0, 0),
(76, 4, 'hBc IgM', 0, 0),
(77, 4, 'HBc IgG', 0, 0),
(78, 4, 'HCV Ab', 0, 0),
(79, 8, 'CA 125', 0, 0),
(80, 8, 'CEA ', 0, 0),
(81, 8, 'CA 15-3', 0, 0),
(82, 8, 'CA19-9 ', 0, 0),
(83, 2, 'complete Urine analysis', 0, 0),
(84, 2, '    Urine c&S', 0, 0),
(85, 2, '24h Urinary PCR', 0, 0),
(86, 6, 'BT - CT', 0, 0),
(87, 6, 'APTT', 0, 0),
(88, 6, 'TT', 0, 0),
(89, 6, 'pT (INR)', 0, 0),
(90, 6, 'VWF:Ag - VWF:Ac (VWF:Rco)', 0, 0),
(91, 6, 'F VIII - F IX', 0, 0),
(92, 6, 'fibrinogen', 0, 0),
(93, 6, 'FDPs', 0, 0),
(94, 6, 'd.dimer', 0, 0),
(95, 9, 'CYTO:  karyotyping', 0, 0),
(96, 11, 'conventional Semen analysis', 0, 0),
(97, 6, 'Thrombophilia ( Ptn C&s - Anti tIII - FVL - PGM - homocysteinemia - MTHFR)', 0, 0),
(98, 5, '', 0, 1),
(99, 4, 'HIV Ab', 0, 0),
(100, 7, 'Anti D antibodies', 0, 0),
(127, 13, 'CBC', 0, 0),
(130, 0, 'nor', 0, 0),
(137, 0, 'vvv', 0, 0),
(138, 0, 'gg edit ', 0, 0),
(143, 0, 'new2', 0, 0),
(144, 0, 'new33', 0, 0),
(145, 5, 'new11', 0, 1),
(146, 5, 'new12', 0, 1),
(156, 0, '', 0, 0),
(166, 0, 'res3', 0, 0),
(168, 0, 'new5', 0, 0),
(169, 0, 'res6', 0, 0),
(170, 0, 'rrr', 0, 0),
(176, 12, 'ABO and Rh factor', 0, 1),
(177, 12, 'CBC', 0, 1),
(178, 12, 'urine analysis', 0, 1),
(179, 12, 'Fasting blood sugar', 0, 1),
(180, 12, '2hPP blood sugar', 0, 1),
(181, 12, 'Toxoplasma IgM', 0, 1),
(182, 13, 'ABO & Rh', 0, 0),
(183, 13, 'urine analysis', 0, 0),
(184, 13, 'Random blood sugar', 0, 0),
(185, 13, 'Rubella IgG', 0, 0),
(186, 13, 'Lupus anticoagulant', 0, 0),
(187, 13, 'anticariolipin IgG', 0, 0),
(190, 12, 'HSG', 0, 1),
(191, 1, 'RBS', 0, 0),
(192, 14, 'scrotal US', 0, 0),
(193, 3, 'CRP', 0, 0),
(194, 5, '', 0, 1),
(195, 5, '', 0, 1),
(196, 5, 'HCG Quantitative twice(every 24 hours) ', 1, 1),
(197, 5, 'HCG Quantitative Twice(Every 48 Hours) ', 1, 1),
(198, 3, 'ESR', 0, 0),
(199, 3, 'Anti Rh Antibodies', 0, 0),
(200, 14, 'breast mamography', 0, 0),
(201, 14, 'Breast US', 0, 0),
(202, 8, 'AFP', 0, 0),
(203, 8, 'LDH', 0, 0),
(204, 3, 'hb electrophoresis', 0, 0),
(205, 14, 'Abdominal & Pelvic Us', 0, 0),
(206, 14, 'Pelvic MRI With / without Fat Suppresion', 0, 0),
(207, 14, 'brain MRI sella tursica', 0, 0),
(208, 11, 'CASA Semen DNA fragmentation test', 0, 0),
(209, 14, '', 1, 1),
(210, 16, 'hb%', 0, 0),
(211, 1, 'OGTT (75gm - F - 1H - 2H)', 0, 0),
(212, 1, 'hb A1C', 0, 0),
(213, 1, 'FG/FI ratio', 0, 0),
(214, 20, 't1:  b-HCG', 0, 0),
(215, 20, 'PAPP-A', 0, 0),
(216, 20, 'T2:  B-HCG', 0, 0),
(217, 20, 'AFP', 0, 0),
(218, 20, 'UE3', 0, 0),
(219, 20, 'inhibin a', 0, 0),
(220, 20, '', 0, 1),
(221, 4, 'VDRL Syphilis', 0, 1),
(222, 4, '', 0, 1),
(223, 4, '', 0, 1),
(224, 4, '', 0, 1),
(225, 4, '', 0, 1),
(226, 4, '', 0, 1),
(227, 21, 'widal', 0, 0),
(228, 21, 'Brucella', 0, 0),
(229, 21, 'ASOT', 0, 0),
(230, 21, 'VDRL Syphilis', 0, 0),
(231, 21, 'RPR Syphilis', 0, 0),
(232, 21, 'vag discharge C/S', 0, 0),
(233, 7, 'anti thyroid ab (TSI)', 0, 0),
(234, 7, 'Anti Thyroid Ab (TPO)', 0, 0),
(235, 7, 'anti adrenal ab', 0, 0),
(236, 7, 'C3', 0, 0),
(237, 7, 'C4', 0, 0),
(238, 2, 'bact colony count', 0, 0),
(239, 2, 'Urinary cast', 0, 0),
(240, 2, 'Stool Analysis', 0, 0),
(241, 11, 'post ejac. urine analysis', 0, 0),
(242, 11, 'SDF', 0, 0),
(243, 9, 'amniocentesis', 0, 0),
(244, 9, 'CVS', 0, 0),
(245, 9, 'MOLECULAR:  FMR-1 gene premutation', 0, 0),
(246, 9, 'FVL mut', 0, 0),
(247, 9, 'Prothrombin gene mut', 0, 0),
(248, 9, 'AZF gene (yq ch microdel)', 0, 0),
(249, 9, 'SDF', 0, 0),
(250, 9, 'RT PCR', 0, 0),
(251, 16, 'platelets', 0, 0),
(252, 16, 'FBS', 0, 0),
(253, 16, 'CUA', 0, 0),
(254, 16, 'HBs ag', 0, 0),
(255, 16, 'HCV Ab', 0, 0),
(256, 19, 'CBC', 0, 0),
(257, 19, 'OGTT (75gm - F - 1H - 2H)', 0, 0),
(258, 19, 'CUA', 0, 0),
(259, 10, 'ABO Group', 0, 0),
(260, 10, 'Rh Factor', 0, 0),
(261, 10, 'Hb%', 0, 0),
(262, 10, 'RBCs Indices', 0, 0),
(263, 10, 'Platelets', 0, 0),
(264, 10, 'PT (INR)', 0, 0),
(265, 10, 'SGPT', 0, 0),
(266, 10, 'SGOT', 0, 0),
(267, 10, 'Bilirubin (Total)', 0, 0),
(268, 10, 'Bilirubin (Direct)', 0, 0),
(269, 10, 'Albumin', 0, 0),
(270, 10, 'Creatinine', 0, 0),
(271, 10, 'fBS', 0, 0),
(272, 10, 'HBs Ag', 0, 0),
(273, 10, 'HCV Ab', 0, 0),
(274, 10, 'HIV Ab', 0, 0),
(275, 10, '', 0, 0),
(276, 3, 'Hct', 0, 0);

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

--
-- Table structure for table `ivfsheet`
--

CREATE TABLE IF NOT EXISTS `ivfsheet` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patientid` int(11) unsigned DEFAULT NULL,
  `endpreg` int(11) unsigned DEFAULT NULL,
  `anevaluation` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `anevaluations` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `antype` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `anduration` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `anamh` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `annn` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `antypes` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `anprotocol` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `anttt` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `annotes` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lmpfresh` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `toocd` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `toodate` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `toodrug` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `opun` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `opumll` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `opuml` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `opugv` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `opuat` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `oopuu` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `opunote` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ssemen` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sseemen` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sseemmen` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sseemmeen` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fefn` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fefa` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fefb` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fefc` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sssnofte` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sssresult` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ssscd` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ettn` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ettg` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ettnote` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ettcancel` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `frrcd` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `frrst` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `frren` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ooutcometvsn` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ooutcomedeln` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ooutcomehsgn` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lmpfrozen` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ssnofte` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ssresult` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `etcd` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `etdate` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `etn` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `outcometvsd` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `etg` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `etnote` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `etcancel` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `refren` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `outcomehsgd` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `outcomehsgn` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `outcomedeld` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `outcomedeln` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `outcometvsn` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ettdate` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ooutcomehsgd` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ooutcometvsd` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ooutcomedeld` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `opudate` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `frozenor` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `historytoday` datetime DEFAULT NULL,
  `e2d2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pla2ce` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `importantnote` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `jncision`
--

CREATE TABLE IF NOT EXISTS `jncision` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `del` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=25 ;

--
-- Dumping data for table `jncision`
--

INSERT INTO `jncision` (`id`, `name`, `del`) VALUES
(1, 'midline', 0),
(2, 'transverse', 0),
(3, 'paramedian', 0),
(4, 'sss', 1),
(5, 'wwwaa', 1),
(6, 'aaaaaqq', 1),
(7, 'eeee', 1),
(8, 'www', 1),
(9, 'ee21', 1),
(10, 'rr1q111', 1),
(11, '444', 1),
(12, 'ww', 1),
(13, '444444', 1),
(14, 'ffff', 1),
(15, 'bbb', 1),
(16, 'لل', 1),
(17, 'ddd', 1),
(18, '6666', 0),
(19, 'aaaaa', 1),
(20, 'iiiii', 0),
(21, 'aaa', 0),
(22, 'cccc', 0),
(23, 'bbb', 0),
(24, 'Pfannistel', 0);

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

--
-- Table structure for table `laparlo`
--

CREATE TABLE IF NOT EXISTS `laparlo` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=19 ;

--
-- Dumping data for table `laparlo`
--

INSERT INTO `laparlo` (`id`, `title`, `del`) VALUES
(1, 'PCO', NULL),
(2, 'adhesion to lat pel wall', NULL),
(3, 'adhesion to post abd wall/colon', NULL),
(4, 'cyst (simple)', NULL),
(5, 'Cyst (hgic)', NULL),
(6, ' 2 Cyst (choclate)', NULL),
(7, 'Cyst (dermoid)', NULL),
(8, 'ov tortion', NULL),
(9, 'n', NULL),
(10, 'small endometrioma', NULL),
(11, 'no drilling', NULL),
(12, 'tubo-ovarian complex', NULL),
(13, '2', NULL),
(14, '1', NULL),
(15, '?small', NULL),
(16, '', NULL),
(17, '', NULL),
(18, 'no LOD', NULL);

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

--
-- Table structure for table `laparlt`
--

CREATE TABLE IF NOT EXISTS `laparlt` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=23 ;

--
-- Dumping data for table `laparlt`
--

INSERT INTO `laparlt` (`id`, `title`, `del`) VALUES
(1, '+ve MBT', NULL),
(2, '-ve MBT (block)', NULL),
(3, 'hydrosalpnix', NULL),
(4, 'adhesion to lat pel wall', NULL),
(5, 'absent', NULL),
(6, 'disconnected', NULL),
(7, 'mild', NULL),
(8, 'mod', NULL),
(9, 'severe', NULL),
(10, 'disturbed TOR', NULL),
(11, 'ectopic preg', NULL),
(12, 'prox. block', NULL),
(13, 'mod to severe', NULL),
(14, 'ى', 1),
(15, 'n', NULL),
(16, 'on forced injection', NULL),
(17, 'perisalpingitis', NULL),
(18, 'no need for disconn', NULL),
(19, 'severe hydrosalpinx', NULL),
(20, 'but unhealthy', NULL),
(21, '??', NULL),
(22, 'mild/mod hydrosalpinix', NULL);

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

--
-- Table structure for table `laparmlo`
--

CREATE TABLE IF NOT EXISTS `laparmlo` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=11 ;

--
-- Dumping data for table `laparmlo`
--

INSERT INTO `laparmlo` (`id`, `title`, `del`) VALUES
(1, 'LOD', NULL),
(2, 'adhesiolysis', NULL),
(3, 'PRP', NULL),
(4, ' aspiration', NULL),
(5, 'cystectomy', NULL),
(6, 'ovariotomy', NULL),
(7, 'untwist', NULL),
(8, '3 drill', NULL),
(9, 'rupture', NULL),
(10, '2 Drill', NULL);

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

--
-- Table structure for table `laparmlt`
--

CREATE TABLE IF NOT EXISTS `laparmlt` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=9 ;

--
-- Dumping data for table `laparmlt`
--

INSERT INTO `laparmlt` (`id`, `title`, `del`) VALUES
(1, '+Ve MBT With Forced Inj', NULL),
(2, 'Disconn', NULL),
(3, 'Salpingectomy', NULL),
(4, 'Adhesiolysis', NULL),
(5, '', 1),
(6, '', 1),
(7, 'disconnection', NULL),
(8, 'open&drainge', NULL);

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

--
-- Table structure for table `laparmpelvis`
--

CREATE TABLE IF NOT EXISTS `laparmpelvis` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=11 ;

--
-- Dumping data for table `laparmpelvis`
--

INSERT INTO `laparmpelvis` (`id`, `title`, `del`) VALUES
(1, 'adhesiolysis', NULL),
(2, ' wash&suction', NULL),
(3, 'fulgeration', NULL),
(4, 'cautery', NULL),
(5, '', NULL),
(6, '', NULL),
(7, '', NULL),
(8, 'cout.', 1),
(9, 'no cautery', NULL),
(10, 'PSN', NULL);

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

--
-- Table structure for table `laparmro`
--

CREATE TABLE IF NOT EXISTS `laparmro` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=13 ;

--
-- Dumping data for table `laparmro`
--

INSERT INTO `laparmro` (`id`, `title`, `del`) VALUES
(1, 'LOD', NULL),
(2, 'Adhesiolysis', NULL),
(3, 'PRP', NULL),
(4, ' aspiration', NULL),
(5, 'cystectomy', NULL),
(6, 'ovariotomy', NULL),
(7, 'untwist', NULL),
(8, '3 drill', NULL),
(9, '4 drill', NULL),
(10, '---', NULL),
(11, 'corpus luteum', NULL),
(12, 'bipolar', NULL);

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

--
-- Table structure for table `laparmrt`
--

CREATE TABLE IF NOT EXISTS `laparmrt` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=8 ;

--
-- Dumping data for table `laparmrt`
--

INSERT INTO `laparmrt` (`id`, `title`, `del`) VALUES
(1, '+ve MBT with forced inj', NULL),
(2, 'disconn', NULL),
(3, 'salpingectomy', NULL),
(4, 'adhesiolysis', NULL),
(5, 'bad dissection', NULL),
(6, 'no need for disconn', NULL),
(7, 'disconnection', NULL);

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

--
-- Table structure for table `laparmut`
--

CREATE TABLE IF NOT EXISTS `laparmut` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `laparmut`
--

INSERT INTO `laparmut` (`id`, `title`, `del`) VALUES
(1, 'myomectomy', NULL),
(2, 'puncture', NULL),
(3, 'removal', NULL);

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

--
-- Table structure for table `laparoscopy`
--

CREATE TABLE IF NOT EXISTS `laparoscopy` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `sdate` date DEFAULT NULL,
  `patientid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  `uterus` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `radnexa` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ladnexa` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pelvis` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `doctorid` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `laparoscopyinfertility`
--

CREATE TABLE IF NOT EXISTS `laparoscopyinfertility` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `infertilitysheetid` int(11) unsigned DEFAULT NULL,
  `laparplace` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `laparul` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `laparrt` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `laparlt` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `laparro` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `laparlo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `laparmut` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `laparpelvis` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `laparmrt` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `laparmlt` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `laparmro` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `laparmlo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `laparmpelvis` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lapintervention` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `coast` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `laparpelvis`
--

CREATE TABLE IF NOT EXISTS `laparpelvis` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=8 ;

--
-- Dumping data for table `laparpelvis`
--

INSERT INTO `laparpelvis` (`id`, `title`, `del`) VALUES
(1, 'omental adhesion to ant abd wall', NULL),
(2, 'frozen pelvis', NULL),
(3, 'hemoperitoneum', NULL),
(4, 'endometriotic spots in uterosacral', NULL),
(5, 'endometriotic spots', NULL),
(6, 'endometriosis', NULL),
(7, 'omental adhesions to lat pel wall at 2 points', NULL);

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

--
-- Table structure for table `laparplace`
--

CREATE TABLE IF NOT EXISTS `laparplace` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=16 ;

--
-- Dumping data for table `laparplace`
--

INSERT INTO `laparplace` (`id`, `title`, `del`) VALUES
(1, 'dddddddd', 1),
(2, 'qqw', 1),
(3, 'royal center- d amr', NULL),
(4, 'د جمال وردة - م العام', NULL),
(5, 'د.جمال ورده -الÙيروز', NULL),
(6, 'د.اشرÙ مطر', NULL),
(7, 'م.الجامعه المنصوره', NULL),
(8, 'د.مهدي المزاحي-دار الشÙا', NULL),
(9, 'د.عامر شتا-الÙيروز', NULL),
(10, 'حاÙظ التخصصي', NULL),
(11, 'م.الحياة د.علاء مجاهد', NULL),
(12, 'د.وائل البنا', NULL),
(13, 'م.الÙيروز-مهدي المزاحي', NULL),
(14, 'د.ياسر الشهاوي-دار الامومه', NULL),
(15, 'د.محمد حسني-رويال', NULL);

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

--
-- Table structure for table `laparro`
--

CREATE TABLE IF NOT EXISTS `laparro` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=16 ;

--
-- Dumping data for table `laparro`
--

INSERT INTO `laparro` (`id`, `title`, `del`) VALUES
(1, 'PCO', NULL),
(2, 'Adhesion to lat pel wall', NULL),
(3, 'adhesion to post abd wall/colon', NULL),
(4, 'cyst (simple)', NULL),
(5, 'cyst (hgic)', NULL),
(6, 'cyst (choclate)', NULL),
(7, 'cyst (dermoid)', NULL),
(8, 'ov tortion', NULL),
(9, 'n', NULL),
(10, 'large endometrioma', NULL),
(11, 'no drilling', NULL),
(12, 'tubo-ovarian complex', NULL),
(13, 'colon adhesion to tube,ov,ant abdominal wall', NULL),
(14, '?small', NULL),
(15, '', NULL);

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

--
-- Table structure for table `laparrt`
--

CREATE TABLE IF NOT EXISTS `laparrt` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=26 ;

--
-- Dumping data for table `laparrt`
--

INSERT INTO `laparrt` (`id`, `title`, `del`) VALUES
(1, '+Ve MBT', NULL),
(2, '-Ve MBT (Block)', NULL),
(3, 'distal block', 1),
(4, 'hydrosalpnix', NULL),
(5, 'adhesion to lat pel wall', NULL),
(6, 'absent', NULL),
(7, 'disconnected', NULL),
(8, 'mild', NULL),
(9, 'mod', NULL),
(10, 'severe', NULL),
(11, 'disturbed TOR', NULL),
(12, 'ectopic preg', NULL),
(13, 'prox. block', NULL),
(14, 'v.mild', NULL),
(15, 'on forced injection', NULL),
(16, '-ve MBT', NULL),
(17, 'perisalpingitis', NULL),
(18, '', NULL),
(19, 'no need for disconn', NULL),
(20, 'mod hydrosalpinx', NULL),
(21, '', NULL),
(22, '-ve dye ->+ve on forced inj', NULL),
(23, 'mild/mod hydrosalpinix', NULL),
(24, 'n', NULL),
(25, '', NULL);

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

--
-- Table structure for table `laparul`
--

CREATE TABLE IF NOT EXISTS `laparul` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=8 ;

--
-- Dumping data for table `laparul`
--

INSERT INTO `laparul` (`id`, `title`, `del`) VALUES
(1, 'nL', NULL),
(2, 'small subserous fibroids', NULL),
(3, 'small simple cyst in ant wall', NULL),
(4, '', NULL),
(5, 'normal', NULL),
(6, 'fixed RVF with adhesions to mesocolon', NULL),
(7, 'v.small subserous fibroid in post wall', NULL);

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

--
-- Table structure for table `lastvisit`
--

CREATE TABLE IF NOT EXISTS `lastvisit` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `patientid` int(11) unsigned DEFAULT NULL,
  `control` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `localcx`
--

CREATE TABLE IF NOT EXISTS `localcx` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=33 ;

--
-- Dumping data for table `localcx`
--

INSERT INTO `localcx` (`id`, `title`, `del`) VALUES
(1, 'erosion', NULL),
(2, 'endocx polyp', NULL),
(3, 'ectocx polyp', NULL),
(4, 'ectropion', NULL),
(5, '+ve VIA', NULL),
(6, '-Ve VIA', NULL),
(7, 'small', NULL),
(8, 'large', NULL),
(9, 'necrotic', NULL),
(10, ' cx cautery 1.5 y', NULL),
(11, 'monilia', NULL),
(12, '', NULL),
(13, '', NULL),
(14, '', NULL),
(15, 'cx polyo', 1),
(16, '', NULL),
(17, '', NULL),
(18, '', NULL),
(19, '', NULL),
(20, '', NULL),
(21, 'n', NULL),
(22, 'enlarged external genitalia', NULL),
(23, 'hypertrophy of both labia minora', NULL),
(24, 'not done', NULL),
(25, 'posterior cx', NULL),
(26, 'small fibroid in ant cx lip', NULL),
(27, '', NULL),
(28, 'large cx', NULL),
(29, 'open ext os', NULL),
(30, 'at 1 oclock', NULL),
(31, 'single', NULL),
(32, 'multiple', NULL);

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

--
-- Table structure for table `localvagina`
--

CREATE TABLE IF NOT EXISTS `localvagina` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=14 ;

--
-- Dumping data for table `localvagina`
--

INSERT INTO `localvagina` (`id`, `title`, `del`) VALUES
(1, 'itis (monilia)', NULL),
(2, 'Itis (TV)', NULL),
(3, 'Itis (BV)', NULL),
(4, '', 1),
(5, '', 1),
(6, 'n', NULL),
(7, 'ant prolapse', NULL),
(8, 'post prolapse', NULL),
(9, 'mild', NULL),
(10, 'severe', NULL),
(11, 'suspected RVFistula', NULL),
(12, 'cysto-rectocele', NULL),
(13, 'no ant fornix (band () ant vag wall & ant cx lip)', NULL);

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

--
-- Table structure for table `localvulva`
--

CREATE TABLE IF NOT EXISTS `localvulva` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=12 ;

--
-- Dumping data for table `localvulva`
--

INSERT INTO `localvulva` (`id`, `title`, `del`) VALUES
(1, 'itis', NULL),
(2, 'l.maj. bartholin', NULL),
(3, 'L.Min. hypertrophy', NULL),
(4, 'papil. accum.', NULL),
(5, '', 1),
(6, '', 1),
(7, '', 1),
(8, 'n', NULL),
(9, 'rt', NULL),
(10, 'lt', NULL),
(11, 'clitoral hypertrophy', NULL);

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

--
-- Table structure for table `mainantenental`
--

CREATE TABLE IF NOT EXISTS `mainantenental` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `patientid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `doctorid` int(11) unsigned DEFAULT NULL,
  `lmp` date DEFAULT NULL,
  `eed` date DEFAULT NULL,
  `notes` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `done` int(11) unsigned DEFAULT NULL,
  `ivf` date DEFAULT NULL,
  `g` int(11) unsigned DEFAULT NULL,
  `sysdate` date DEFAULT NULL,
  `hb` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `mainantenentaldrugs`
--

CREATE TABLE IF NOT EXISTS `mainantenentaldrugs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patientid` int(11) NOT NULL,
  `mainantenatalid` int(11) NOT NULL,
  `date` date NOT NULL,
  `drugid` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drugtype` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drugdos` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0',
  `doctorid` int(11) NOT NULL,
  `drugname` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `forhusband` int(11) unsigned DEFAULT NULL,
  `recepittmpid` int(11) DEFAULT '0',
  `recepitdrugid` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `mainantenentalinvest`
--

CREATE TABLE IF NOT EXISTS `mainantenentalinvest` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patientid` int(11) NOT NULL,
  `mainantenatalid` int(11) NOT NULL,
  `date` date NOT NULL,
  `investid` int(11) NOT NULL,
  `investresult` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0',
  `doctorid` int(11) NOT NULL,
  `forhusband` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `mainantenentalus`
--

CREATE TABLE IF NOT EXISTS `mainantenentalus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mainantenatalid` int(11) NOT NULL,
  `doctorid` int(11) NOT NULL,
  `patientid` int(11) NOT NULL,
  `date` date NOT NULL,
  `nga` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gs` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `crl` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fhr` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bpd` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fl` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `placenta` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ai` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fwt` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `maingyna`
--

CREATE TABLE IF NOT EXISTS `maingyna` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `patientid` int(11) unsigned DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `notes` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plan` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `medicalhistory`
--

CREATE TABLE IF NOT EXISTS `medicalhistory` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=82 ;

--
-- Dumping data for table `medicalhistory`
--

INSERT INTO `medicalhistory` (`id`, `title`, `del`) VALUES
(1, 'DM', NULL),
(2, 'HTN', NULL),
(3, 'hypothyroid', NULL),
(4, 'hyperthyroid', NULL),
(5, 'MS', NULL),
(6, 'Rh Arthritis', NULL),
(7, 'SLE', NULL),
(8, 'Renal stone', NULL),
(9, 'cervical lumbar disc', NULL),
(10, 'sciatica', NULL),
(11, 'tachcardia', NULL),
(12, 'DKA', NULL),
(13, 'recurrent ICU admission', NULL),
(14, 'anemic', NULL),
(15, 'icu admission (covid 19)', NULL),
(16, 'gastritis', NULL),
(17, 'V.V', NULL),
(18, '', NULL),
(19, ' lumbar  disc', NULL),
(20, 'hypercholesterolemia', NULL),
(21, '1ry inf 1.6 Y', NULL),
(22, 'favism', NULL),
(23, '??', NULL),
(24, '1ry inf 1.8y', NULL),
(25, 'COS # د.عمرو', NULL),
(26, 'vaginismus', NULL),
(27, 'sinusitis', NULL),
(28, 'b.a', NULL),
(29, '?? rt subserous fibroid with red degeneration', NULL),
(30, 'hospital  admision for 2 day م. العام', NULL),
(31, 'COS # DR/ AMR', NULL),
(32, '?? ant wall intramural fibroid 13x18mm', NULL),
(33, 'renal colic', NULL),
(34, 'cystitis', NULL),
(35, '1RY INF 14.6 Y', NULL),
(36, 'Repeated ICSI failure', NULL),
(37, '1ry inf 1y + endometriomas', NULL),
(38, '1 ', NULL),
(39, '1ry infertility', NULL),
(40, 'vertebral disc', NULL),
(41, ' allergy to fe injection', NULL),
(42, 'IDDM', NULL),
(43, 'endometriosis', NULL),
(44, 'a-', NULL),
(45, '+ve LAC', NULL),
(46, '+ve aCL Ab', NULL),
(47, 'calcular cholecystitis', NULL),
(48, 'mild hirsutism', NULL),
(49, '??? hypothyroid', NULL),
(50, 'hx of covid', NULL),
(51, 'T.B', NULL),
(52, 'tinea versicolor', NULL),
(53, 'lt breast cancer', NULL),
(54, 'IC HTN', NULL),
(55, '?? CVT', NULL),
(56, '', NULL),
(57, 'hx of PET, PTL', NULL),
(58, 'recieved 1st dose of covid vaccine', NULL),
(59, 'spontanous pregnancy ', NULL),
(60, 'Recurrent ePL', NULL),
(61, 'fe ingection (6)', NULL),
(62, '', NULL),
(63, '1ry inf 1.5y', NULL),
(64, 'PCO', NULL),
(65, '1ry inf 2.5', NULL),
(66, 'hPV', NULL),
(67, 'blood transfusion 3', NULL),
(68, '?? dVT', NULL),
(69, 'Hypotensive', NULL),
(70, '?? flumox allergy', NULL),
(71, 'hx of anemia', NULL),
(72, 'ureteric stone', NULL),
(73, '--', NULL),
(74, 'thrombocytopenia', NULL),
(75, 'diaphragmatic hernia', NULL),
(76, 'umblical hernia', NULL),
(77, '', NULL),
(78, 'GERD', NULL),
(79, '2.7y', NULL),
(80, 'mild v.V', NULL),
(81, 'hx of hospital admision 1y ago م.العام ? ov cyst', NULL);

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

--
-- Table structure for table `medicalhistorydm`
--

CREATE TABLE IF NOT EXISTS `medicalhistorydm` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=23 ;

--
-- Dumping data for table `medicalhistorydm`
--

INSERT INTO `medicalhistorydm` (`id`, `title`, `del`) VALUES
(1, 'DM', NULL),
(2, 'varicocele', NULL),
(3, 'STD', NULL),
(4, 'Smoking', NULL),
(5, 'addiction', NULL),
(6, 'HTN', NULL),
(7, 'bilat', NULL),
(8, 'rt', NULL),
(9, 'lt', NULL),
(10, 'BA', NULL),
(11, 'hematuria', NULL),
(12, 'hematospermia', NULL),
(13, 'Smoking(shisha)', NULL),
(14, 'b.A', NULL),
(15, 'anti psychotic ttt', NULL),
(16, 'ex smoking 1y ago', NULL),
(17, 'smoking(goza)', NULL),
(18, 'paraplegia', NULL),
(19, 'obese', NULL),
(20, 'ex smoker', NULL),
(21, 'lumar disc', NULL),
(22, 'ex addiction', NULL);

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

--
-- Table structure for table `menstrualamount`
--

CREATE TABLE IF NOT EXISTS `menstrualamount` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=8 ;

--
-- Dumping data for table `menstrualamount`
--

INSERT INTO `menstrualamount` (`id`, `title`, `del`) VALUES
(1, 'average ', NULL),
(2, 'excessive', NULL),
(3, 'little', NULL),
(4, 'Menarche at 12 ys old', 1),
(5, 'severe oligo', NULL),
(6, 'oligo', NULL),
(7, 'olid', 1);

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

--
-- Table structure for table `menstrualdysm`
--

CREATE TABLE IF NOT EXISTS `menstrualdysm` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=5 ;

--
-- Dumping data for table `menstrualdysm`
--

INSERT INTO `menstrualdysm` (`id`, `title`, `del`) VALUES
(1, 'No', NULL),
(2, 'spasmodic', NULL),
(3, 'congestive', NULL),
(4, 'cresc-decresc', NULL);

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

--
-- Table structure for table `menstrualreg`
--

CREATE TABLE IF NOT EXISTS `menstrualreg` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=10 ;

--
-- Dumping data for table `menstrualreg`
--

INSERT INTO `menstrualreg` (`id`, `title`, `del`) VALUES
(1, 'Reg', NULL),
(2, 'iRReg', NULL),
(3, 'oligo', NULL),
(4, 'severe oligo', NULL),
(5, 'lact amen', NULL),
(6, 'reg on coc', NULL),
(7, 'post menopause', NULL),
(8, 'post memopause 10y ago', NULL),
(9, 'amenorrhea(chemotherapy)', NULL);

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

--
-- Table structure for table `midlinejncision`
--

CREATE TABLE IF NOT EXISTS `midlinejncision` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `del` int(11) NOT NULL,
  `jncisionid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=23 ;

--
-- Dumping data for table `midlinejncision`
--

INSERT INTO `midlinejncision` (`id`, `name`, `del`, `jncisionid`) VALUES
(1, 'upper', 0, 1),
(2, 'lower', 0, 1),
(3, 'pfnnestiel', 0, 2),
(4, 'joel cohen', 0, 2),
(5, 'RT', 0, 3),
(6, '1-T', 0, 3),
(7, 'ccc', 0, 4),
(8, 'rr', 0, 9),
(9, 'ee11', 1, 10),
(10, 'aaa', 1, 10),
(11, 'aa', 1, 10),
(12, 'ee11', 0, 10),
(13, 'ww', 0, 10),
(14, '22', 0, 9),
(15, 'للل', 1, 1),
(16, '666666', 0, 18),
(17, 'sssss', 0, 19),
(18, 'ttttt', 1, 1),
(19, 'jjjjjjjj', 0, 1),
(20, 'aaa', 0, 1),
(21, 'bb', 0, 23),
(22, 'aa', 0, 23);

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

--
-- Table structure for table `mointoringsheet`
--

CREATE TABLE IF NOT EXISTS `mointoringsheet` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `doctorid` int(11) DEFAULT NULL,
  `patientid` int(11) DEFAULT NULL,
  `monitordate` date DEFAULT NULL,
  `lmp` date DEFAULT NULL,
  `attempno` int(11) DEFAULT '0',
  `procedure` int(11) DEFAULT NULL,
  `protocol` int(11) DEFAULT NULL,
  `ejac` int(11) DEFAULT NULL,
  `pesa` int(11) DEFAULT NULL,
  `tese` int(11) DEFAULT NULL,
  `sryo` int(11) DEFAULT NULL,
  `hmg` int(11) DEFAULT NULL,
  `agonist` int(11) DEFAULT NULL,
  `hcg` int(11) DEFAULT '0',
  `remarks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `place` varchar(255) DEFAULT NULL,
  `amp` varchar(255) DEFAULT NULL,
  `oocytestotal` varchar(255) DEFAULT NULL,
  `oocytesm1` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `oocytesm2` varchar(255) DEFAULT NULL,
  `oocytesgv` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `ettotal` varchar(255) DEFAULT NULL,
  `etg1` varchar(255) DEFAULT NULL,
  `cyroday` varchar(255) DEFAULT NULL,
  `cyrow` varchar(255) DEFAULT NULL,
  `p4` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `outcome` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT '0' COMMENT ' 0 open , 1 archived',
  `sysdate` date DEFAULT NULL,
  `deleted` int(11) DEFAULT '0',
  `notes` text CHARACTER SET utf8,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `mointoringsheetagonist`
--

CREATE TABLE IF NOT EXISTS `mointoringsheetagonist` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `mointoringsheetagonist`
--

INSERT INTO `mointoringsheetagonist` (`id`, `name`, `deleted`) VALUES
(1, '1', 0);

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

--
-- Table structure for table `mointoringsheetdrugs`
--

CREATE TABLE IF NOT EXISTS `mointoringsheetdrugs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patientid` int(11) NOT NULL,
  `date` date NOT NULL,
  `drugid` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drugtype` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drugdos` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0',
  `doctorid` int(11) NOT NULL,
  `drugname` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `forhusband` int(11) unsigned DEFAULT NULL,
  `recepittmpid` int(11) DEFAULT '0',
  `recepitdrugid` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `mointoringsheetejac`
--

CREATE TABLE IF NOT EXISTS `mointoringsheetejac` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `mointoringsheetejac`
--

INSERT INTO `mointoringsheetejac` (`id`, `name`, `deleted`) VALUES
(1, '1', 0);

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

--
-- Table structure for table `mointoringsheethcg`
--

CREATE TABLE IF NOT EXISTS `mointoringsheethcg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `mointoringsheethmg`
--

CREATE TABLE IF NOT EXISTS `mointoringsheethmg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `mointoringsheethmg`
--

INSERT INTO `mointoringsheethmg` (`id`, `name`, `deleted`) VALUES
(1, '1', 0);

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

--
-- Table structure for table `mointoringsheetinvestigation`
--

CREATE TABLE IF NOT EXISTS `mointoringsheetinvestigation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patientid` int(11) NOT NULL,
  `date` date NOT NULL,
  `investid` int(11) NOT NULL,
  `investresult` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0',
  `doctorid` int(11) NOT NULL,
  `forhusband` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `mointoringsheetpesa`
--

CREATE TABLE IF NOT EXISTS `mointoringsheetpesa` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `mointoringsheetpesa`
--

INSERT INTO `mointoringsheetpesa` (`id`, `name`, `deleted`) VALUES
(1, '1', 0);

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

--
-- Table structure for table `mointoringsheetprocedure`
--

CREATE TABLE IF NOT EXISTS `mointoringsheetprocedure` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `mointoringsheetprocedure`
--

INSERT INTO `mointoringsheetprocedure` (`id`, `name`, `deleted`) VALUES
(1, '1', 0);

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

--
-- Table structure for table `mointoringsheetprotocol`
--

CREATE TABLE IF NOT EXISTS `mointoringsheetprotocol` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `mointoringsheetprotocol`
--

INSERT INTO `mointoringsheetprotocol` (`id`, `name`, `deleted`) VALUES
(1, '1', 0);

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

--
-- Table structure for table `mointoringsheetsryo`
--

CREATE TABLE IF NOT EXISTS `mointoringsheetsryo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `mointoringsheetsryo`
--

INSERT INTO `mointoringsheetsryo` (`id`, `name`, `deleted`) VALUES
(1, '1', 0);

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

--
-- Table structure for table `mointoringsheettese`
--

CREATE TABLE IF NOT EXISTS `mointoringsheettese` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `mointoringsheettese`
--

INSERT INTO `mointoringsheettese` (`id`, `name`, `deleted`) VALUES
(1, '1', 0);

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

--
-- Table structure for table `mointoringsheetvisits`
--

CREATE TABLE IF NOT EXISTS `mointoringsheetvisits` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mointoringsheetid` int(11) DEFAULT NULL,
  `visitdate` date DEFAULT NULL,
  `cycleday` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hmg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `endo` text CHARACTER SET utf8mb4,
  `follicright` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `follicleft` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `e2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `sysdate` date DEFAULT NULL,
  `deleted` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `mrict`
--

CREATE TABLE IF NOT EXISTS `mrict` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `sdate` date DEFAULT NULL,
  `patientid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  `uterus` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `radnexa` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ladnexa` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pelvis` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `doctorid` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `newvisit`
--

CREATE TABLE IF NOT EXISTS `newvisit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `infertilitysheetid` int(11) unsigned DEFAULT NULL,
  `newvisitcycles` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lmp` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bw` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ut` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ov` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ttt` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `newvisitcycles`
--

CREATE TABLE IF NOT EXISTS `newvisitcycles` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=9 ;

--
-- Dumping data for table `newvisitcycles`
--

INSERT INTO `newvisitcycles` (`id`, `title`, `del`) VALUES
(1, 'Reg', NULL),
(2, 'IRReg', NULL),
(3, 'oligo', NULL),
(4, 'severe oligo', NULL),
(5, 'lact amen', NULL),
(6, 'dysme for 2 cyclesnorrhea', 1),
(7, 'reg on cOC', NULL),
(8, 'amen(chemo)', NULL);

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

--
-- Table structure for table `newvisitg`
--

CREATE TABLE IF NOT EXISTS `newvisitg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gynasheetid` int(11) unsigned DEFAULT NULL,
  `newvisitcycles` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `newvisitgdiag` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `newvisitgco` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lmp` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bw` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ut` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ov` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `noteg` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plan` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `usvsdtv` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `newvisitgco`
--

CREATE TABLE IF NOT EXISTS `newvisitgco` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=125 ;

--
-- Dumping data for table `newvisitgco`
--

INSERT INTO `newvisitgco` (`id`, `title`, `del`) VALUES
(1, '', 1),
(2, '', 1),
(3, '', 1),
(4, '', 1),
(5, 'Pain (LA)', NULL),
(6, 'Pain (Diffuse LA)', NULL),
(7, 'Pain (Suprapubic)', NULL),
(8, 'Pain (Epigastric)', NULL),
(9, 'Pain (Rt Iliac)', NULL),
(10, 'Pain (Lt Iliac)', NULL),
(11, 'Bleeding (HMB)', NULL),
(12, 'Bleeding (MenoMetro)', NULL),
(13, 'Bleeding (Midcycle Spotting)', NULL),
(14, 'Bleeding (Peri M)', NULL),
(15, 'Bleeding (PMB)', NULL),
(16, 'Bleeding On COC', NULL),
(17, 'bleeding on POP', NULL),
(18, 'bleeding on DMPA', NULL),
(19, 'bleeding on implant', NULL),
(20, 'bleeding on IUCD', NULL),
(21, 'bleeding on Mirena', NULL),
(22, 'discharge (whitish curdy)', NULL),
(23, 'discharge (yellowish/frothy/offensive)', NULL),
(24, 'Discharge (greyish/Offensive fishy)', NULL),
(25, 'swelling (abd)', NULL),
(26, 'Swelling (pelvi-Abd)', NULL),
(27, 'Swelling (vulval)', NULL),
(28, 'Swelling (vag)', NULL),
(29, '', 1),
(30, 'fggf', 1),
(31, 'UI (inv passage of urine with strain)', NULL),
(32, 'UI (urge with passage of urine)', NULL),
(33, 'UI (mixed)', NULL),
(34, 'dysuria/urgency/frequency of micturition', NULL),
(35, 'pruritus vulvae', NULL),
(36, 'fever', NULL),
(37, 'mens dist (precoc puberty)', NULL),
(38, 'Mens Dist (delayed Puberty)', NULL),
(39, 'Mens Dist (oligo)', NULL),
(40, 'Mens Dist (2ry amen)', NULL),
(41, 'Mens Dist (hirsutism)', NULL),
(42, 'PMM(mastalgia)', NULL),
(43, 'PMD', NULL),
(44, 'hot flushes', NULL),
(45, 'seeking cO', NULL),
(46, 'postpone menses', NULL),
(47, 'bilat breast pus discharge', NULL),
(48, 'vulval soreness', NULL),
(49, '1m ago', NULL),
(50, 'dysuria', NULL),
(51, 'bleeding', NULL),
(52, 'since 29-7-021', NULL),
(53, 'irregul', NULL),
(54, 'irregular menses', NULL),
(55, '', NULL),
(56, 'acne', NULL),
(57, 'cyclic rt shoulder pain', NULL),
(58, 'breast atrophy after weaning of 2nd baby', NULL),
(59, 'monilial discharge', NULL),
(60, 'mild hirsiutism', NULL),
(61, 'vaginal spotting ', NULL),
(62, 'spotting on diane', NULL),
(63, 'menorrhagia(increase duration)', NULL),
(64, 'severe spasmodic dysmenorrhea ', NULL),
(65, 'white vaginal discharge ', NULL),
(66, 'since 4ms', NULL),
(67, 'lower abdominal pain', NULL),
(68, 'since 4m ago', NULL),
(69, 'follow  up post abortion', NULL),
(70, 'mild vaginal spotting for 3 days', NULL),
(71, 'continous vaginal bleeding for 3 w', NULL),
(72, 'for 3m', 1),
(73, '', NULL),
(74, 'irregular vag bleeding on IUD', NULL),
(75, 'premenstrual (backpain-vomiting-fainting)', NULL),
(76, '5m ago', NULL),
(77, 'IMB', NULL),
(78, 'since 2m', NULL),
(79, 'burning sensation', NULL),
(80, 'intolerance to diane', NULL),
(81, 'coming for contraception(IUD)', NULL),
(82, 'burning at micturation+ vag disch', NULL),
(83, 'dysmenorrhea for 2 cycles', NULL),
(84, 'missed period since 2w after last tab of coc', NULL),
(85, 'accidentally discovered ov cyst', NULL),
(86, 'lt nipple bloody discharge since 1m', NULL),
(87, 'mild mastalgia', NULL),
(88, '2 Painful lumps in lt breast since 1m', NULL),
(89, 'vaginal, anal pain for 3y', NULL),
(90, 'cyclic mild anal bleeding with menses for 20y ', NULL),
(91, 'desire implanon removal', NULL),
(92, '(expire=3y use)', NULL),
(93, 'recurrent', NULL),
(94, '', NULL),
(95, 'coming for reassurance b4 marriage as she has only 1 ovary', 1),
(96, 'reassurance b4 marriage as she has only 1 ovary', NULL),
(97, 'nausea', NULL),
(98, 'offensive vag discharge', NULL),
(99, 'premenstrual rt mastalgia refer to back', NULL),
(100, 'post coital pain', NULL),
(101, 'last menses for 10d ', NULL),
(102, 'diarrhea', NULL),
(103, 'last period remain 25 d', NULL),
(104, 'hirsutism', NULL),
(105, 'white vaginal discharge with itching', NULL),
(106, '', NULL),
(107, 'acne in both thighs &shoulders', NULL),
(108, 'anemia', NULL),
(109, 'hMB last menses', NULL),
(110, 'accid discovered rt ov hgic cyst, fibroid', NULL),
(111, '6m ago', NULL),
(112, '3w', NULL),
(113, 'premenstrual nausea,headache,watery offensive discharge', NULL),
(114, 'vaginal mass', NULL),
(115, '10y', NULL),
(116, 'dyspareunia', NULL),
(117, 'since 1.5y', NULL),
(118, 'polymenorrhea', NULL),
(119, 'increase BW', NULL),
(120, 'mother afraid of PCO', NULL),
(121, 'pelvic pain', NULL),
(122, 'since 1w  ', NULL),
(123, 'failed trials of iUD removal (missed threads)', NULL),
(124, '4y ago', NULL);

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

--
-- Table structure for table `newvisitgdiag`
--

CREATE TABLE IF NOT EXISTS `newvisitgdiag` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=52 ;

--
-- Dumping data for table `newvisitgdiag`
--

INSERT INTO `newvisitgdiag` (`id`, `title`, `del`) VALUES
(1, '1ry amen (constitutional)', NULL),
(2, '1ry Amen (imperforate hymen)', NULL),
(3, '1ry Amen (T.V.Septum)', NULL),
(4, '1ry Amen (MA)', NULL),
(5, '1ry Amen (AIS)', NULL),
(6, '1ry Amen (turner)', NULL),
(7, '1ry Amen (pure GD)', NULL),
(8, '1ry Amen (mixed GD)', NULL),
(9, '1ry Amen (true herma)', NULL),
(10, '1ry Amen (5ARD)', NULL),
(11, '1ry Amen (CAH)', NULL),
(12, '2ry Amen (Hypothyroid)', NULL),
(13, '2ry Amen (Hyper PRL)', NULL),
(14, '2ry Amen (pit PRL oma)', NULL),
(15, 'PCOS', NULL),
(16, 'Hirsutism', NULL),
(17, 'EH', NULL),
(18, 'thick endom', NULL),
(19, 'hormonal imbalance', NULL),
(20, 'Precoc Puberty', NULL),
(21, 'perimenopausal bleeding', NULL),
(22, 'adenomyosis', NULL),
(23, 'cystocele(mod) + rectocele(severe)', NULL),
(24, '', NULL),
(25, '', NULL),
(26, '', NULL),
(27, '', NULL),
(28, '2x7 cm', NULL),
(29, 'jhjikv', 1),
(30, 'herpes simplex 2', NULL),
(31, '2ry amen (implanon)', NULL),
(32, 'fibroid ut', NULL),
(33, 'post abortive ut remnants', NULL),
(34, 'classic PCOS', NULL),
(35, 'endometriosis', NULL),
(36, 'normal menarche', NULL),
(37, 'hormonal imbalance (??PCO)', NULL),
(38, 'PMS', NULL),
(39, 'PCOD', NULL),
(40, 'suspected RVFistula', NULL),
(41, 'hgic ov cyst', NULL),
(42, 'cancer lt breast', NULL),
(43, 'displaced IUD (cx canal)', NULL),
(44, 'post P VM F.Up', NULL),
(45, 'vaginitis', NULL),
(46, 'ectocx fibroid', NULL),
(47, 'endocx polyp', NULL),
(48, 'multiple', NULL),
(49, 'post C VM F.Up', NULL),
(50, 'rt ureteric ?? stone', NULL),
(51, 'psychological dist', NULL);

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

--
-- Table structure for table `old_visits`
--

CREATE TABLE IF NOT EXISTS `old_visits` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patientid` int(11) NOT NULL,
  `visitdate` date NOT NULL,
  `detectionid` int(11) NOT NULL,
  `detectionvalue` decimal(10,0) DEFAULT '0',
  `visitorder` int(11) NOT NULL,
  `enterordered` int(11) NOT NULL,
  `view` tinyint(1) NOT NULL DEFAULT '0',
  `deleted` int(11) DEFAULT '0',
  `end` int(11) DEFAULT '0',
  `enddate` date DEFAULT NULL,
  `reason` text COLLATE utf8mb4_unicode_ci,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `enddoctorid` int(11) DEFAULT NULL,
  `mobileappvisit` int(11) unsigned DEFAULT NULL,
  `payedflag` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `operation`
--

CREATE TABLE IF NOT EXISTS `operation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=44 ;

--
-- Dumping data for table `operation`
--

INSERT INTO `operation` (`id`, `title`, `del`, `name`) VALUES
(1, 'pipple endom sampling', NULL, NULL),
(2, '', '1', NULL),
(3, 'dddddddd', '1', NULL),
(4, '', '1', NULL),
(5, '', '1', NULL),
(6, '', '1', NULL),
(7, '', '1', NULL),
(8, '', '1', NULL),
(9, 'fe infusion', NULL, NULL),
(10, 'Bartholin gl excision', NULL, NULL),
(11, 'bartholin marsubialization', NULL, NULL),
(12, 'abscess', NULL, NULL),
(13, 'D$C', NULL, NULL),
(14, '', '1', NULL),
(15, '', '1', NULL),
(16, 'cx cerclage', NULL, NULL),
(17, 'blood transfusion', NULL, NULL),
(18, 'TAH+BS  sss ', NULL, NULL),
(19, NULL, '0', 'fsfsfssfsfsss'),
(20, 'acac', '1', NULL),
(21, '', '1', NULL),
(22, '22', '1', NULL),
(23, '333', '1', NULL),
(24, '', '1', NULL),
(25, '2222', '1', NULL),
(26, 'dddd', '1', NULL),
(27, 'asdd', '1', NULL),
(28, 'sfsfsf', '1', NULL),
(29, 'acacaca', '1', NULL),
(30, 'sssssssss', '1', NULL),
(31, 'rrrr', '1', NULL),
(32, '111', '1', NULL),
(33, '12', '1', NULL),
(34, '6544', '1', NULL),
(35, '52525', '1', NULL),
(36, '', '1', NULL),
(37, 'xxxx', '1', NULL),
(38, '55555', '1', NULL),
(39, '159357', '1', NULL),
(40, 'wwwww', NULL, NULL),
(41, 'cccc', NULL, NULL),
(42, '123456899', NULL, NULL),
(43, '1555555555555555555555555555555555', NULL, NULL);

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

--
-- Table structure for table `operationids`
--

CREATE TABLE IF NOT EXISTS `operationids` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `doctorid` int(11) NOT NULL,
  `assistantid` int(11) NOT NULL,
  `operationid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `operations`
--

CREATE TABLE IF NOT EXISTS `operations` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `infertilitysheetid` int(11) unsigned DEFAULT NULL,
  `operation` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `place` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `histopath` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cost` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `operativedetails`
--

CREATE TABLE IF NOT EXISTS `operativedetails` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `operationid` int(11) NOT NULL,
  `date` date NOT NULL,
  `timestart` time NOT NULL,
  `timeend` time NOT NULL,
  `indication` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `anasthesaid` int(11) NOT NULL,
  `generalid` int(11) NOT NULL,
  `anasthetstsid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `assistantid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `complication` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `jncisionid` int(11) NOT NULL,
  `midlineid` int(11) NOT NULL,
  `peritonealwash` int(1) NOT NULL DEFAULT '0',
  `exdetails` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `opsteps` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `layers` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `drains` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `suture` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bloodtransfusion` int(1) NOT NULL DEFAULT '0',
  `complications` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `recommendation` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `patientid` int(11) NOT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  `anasthetsts2id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `assistant2id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `operativedetailsdrugs`
--

CREATE TABLE IF NOT EXISTS `operativedetailsdrugs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `operationid` int(11) NOT NULL,
  `drugid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drugtype` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drugdos` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `doctorid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drugname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0',
  `recepittmpid` int(11) DEFAULT '0',
  `recepitdrugid` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `op_wait_list`
--

CREATE TABLE IF NOT EXISTS `op_wait_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patientid` int(11) DEFAULT '0',
  `opdate` date DEFAULT NULL,
  `operation` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `place` int(11) DEFAULT NULL,
  `notes` text CHARACTER SET utf8mb4,
  `deleted` int(11) DEFAULT '0',
  `user_id` int(11) DEFAULT '0',
  `createdate` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `origin`
--

CREATE TABLE IF NOT EXISTS `origin` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=10 ;

--
-- Dumping data for table `origin`
--

INSERT INTO `origin` (`id`, `title`, `del`) VALUES
(1, 'kkkkkkkk', '1'),
(2, 'ii', '1'),
(3, 'ckkjfkjgkj', 'kkkk'),
(4, NULL, '1'),
(5, NULL, '1'),
(6, 'المركز الملكي', NULL),
(7, 'المنزل', '1'),
(8, 'م. الÙيروز', NULL),
(9, 'م. الصÙا', NULL);

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

--
-- Table structure for table `otherinvestigations`
--

CREATE TABLE IF NOT EXISTS `otherinvestigations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `deleted` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `otherinvestigationsrows`
--

CREATE TABLE IF NOT EXISTS `otherinvestigationsrows` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `patientid` int(11) DEFAULT NULL,
  `doctorid` int(11) DEFAULT NULL,
  `deleted` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `otherinvestigationsvalues`
--

CREATE TABLE IF NOT EXISTS `otherinvestigationsvalues` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `investrowid` int(11) DEFAULT NULL,
  `investid` int(11) NOT NULL,
  `value` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `ovst`
--

CREATE TABLE IF NOT EXISTS `ovst` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ivfsheetid` int(11) unsigned DEFAULT NULL,
  `ovstcdfh` int(11) unsigned DEFAULT NULL,
  `ovstdate` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovstag` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovsthmg` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovstfr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovstfrr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovstfrrr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovstfrrrr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovstdffrrrr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovstfffrrr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovstffrrrr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovstffffrr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovstfffffr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovstdffffff` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovstfrfffff` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovstffffff` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovstfrrffff` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovstdfrrffff` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovstdfrfffff` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovstdfffffr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovstdffffrr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovstdfffrrr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovstdfrrrr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovstdfrrr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovstdfrr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ovstdfr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eovst` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eeovst` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `noteovst` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `pathology` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `sdate` date DEFAULT NULL,
  `patientid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  `cytology` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `histopathology` text COLLATE utf8mb4_unicode_ci,
  `doctorid` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `patientfiles`
--

CREATE TABLE IF NOT EXISTS `patientfiles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patientid` int(11) NOT NULL,
  `file` varchar(240) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `patients`
--

CREATE TABLE IF NOT EXISTS `patients` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `wifename` text COLLATE utf8mb4_unicode_ci,
  `wiftypeid` int(11) DEFAULT NULL,
  `dateofbirth` date DEFAULT NULL,
  `wifebl` int(255) DEFAULT NULL,
  `wifeage` int(11) DEFAULT NULL,
  `wifeeducation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wifejob` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wifenationalid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mirragefrom` float DEFAULT '0',
  `mirragefromdate` date DEFAULT '0000-00-00',
  `boyson` int(11) DEFAULT NULL,
  `girlson` int(11) DEFAULT NULL,
  `statuesid` int(11) DEFAULT NULL,
  `husdandname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `husbandtypeid` int(11) DEFAULT NULL,
  `husbandage` int(11) DEFAULT NULL,
  `husbanddateofbirth` date DEFAULT NULL,
  `husbandbl` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `husbandjob` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `husbandeducation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `husbandnationalid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `importantnote` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `risk` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `risktype` int(11) DEFAULT NULL,
  `spacialnotes` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `statusno` int(11) DEFAULT NULL,
  `done` tinyint(1) DEFAULT '0',
  `pno` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ab` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ectopic` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vmodel` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted` int(11) DEFAULT '0',
  `entrydate` datetime DEFAULT NULL,
  `userid` int(11) DEFAULT NULL,
  `cs` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `patientid` int(11) unsigned DEFAULT NULL,
  `patient_password_hash` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `husband_notes` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `svd` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `report_note` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `doctorid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `husband_habbits` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `statusno` (`statusno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `patients_tmp`
--

CREATE TABLE IF NOT EXISTS `patients_tmp` (
  `pit_id` int(11) NOT NULL AUTO_INCREMENT,
  `pit_name` varchar(55) NOT NULL,
  PRIMARY KEY (`pit_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `patients_updates`
--

CREATE TABLE IF NOT EXISTS `patients_updates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `wifename` text COLLATE utf8mb4_unicode_ci,
  `wiftypeid` int(11) DEFAULT NULL,
  `dateofbirth` date DEFAULT NULL,
  `wifebl` int(255) DEFAULT NULL,
  `wifeage` int(11) DEFAULT NULL,
  `wifeeducation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wifejob` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wifenationalid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mirragefrom` float DEFAULT '0',
  `mirragefromdate` date DEFAULT '0000-00-00',
  `boyson` int(11) DEFAULT NULL,
  `girlson` int(11) DEFAULT NULL,
  `statuesid` int(11) DEFAULT NULL,
  `husdandname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `husbandtypeid` int(11) DEFAULT NULL,
  `husbandage` int(11) DEFAULT NULL,
  `husbanddateofbirth` date DEFAULT NULL,
  `husbandbl` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `husbandjob` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `husbandeducation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `husbandnationalid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `importantnote` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `risk` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `risktype` int(11) DEFAULT NULL,
  `spacialnotes` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `statusno` int(11) DEFAULT NULL,
  `done` tinyint(1) DEFAULT '0',
  `pno` int(11) NOT NULL DEFAULT '0',
  `ab` int(11) NOT NULL DEFAULT '0',
  `ectopic` int(11) NOT NULL DEFAULT '0',
  `vmodel` int(11) NOT NULL DEFAULT '0',
  `deleted` int(11) DEFAULT '0',
  `entrydate` datetime DEFAULT NULL,
  `userid` int(11) DEFAULT NULL,
  `cs` int(11) unsigned DEFAULT NULL,
  `patientid` int(11) unsigned DEFAULT NULL,
  `patient_password_hash` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `husband_notes` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `svd` int(11) unsigned DEFAULT NULL,
  `report_note` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `doctorid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `husband_habbits` text COLLATE utf8mb4_unicode_ci,
  `userid_edit` int(11) DEFAULT '0',
  `date_edit` datetime DEFAULT NULL,
  `patientid_edit` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `statusno` (`statusno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `phamount`
--

CREATE TABLE IF NOT EXISTS `phamount` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=183 ;

--
-- Dumping data for table `phamount`
--

INSERT INTO `phamount` (`id`, `name`, `del`) VALUES
(182, 'excessive', 0);

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

--
-- Table structure for table `pharmacystore`
--

CREATE TABLE IF NOT EXISTS `pharmacystore` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `drug_id` int(11) NOT NULL,
  `amountbefore` int(11) DEFAULT '0',
  `amountafter` int(11) DEFAULT '0',
  `amountvary` int(11) NOT NULL,
  `opdate` datetime NOT NULL,
  `optype` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `phcontraception`
--

CREATE TABLE IF NOT EXISTS `phcontraception` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `patientid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sysdate` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contype` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contduration` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contstopped` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contranote` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  `doctorid` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `phcontracttype`
--

CREATE TABLE IF NOT EXISTS `phcontracttype` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=62 ;

--
-- Dumping data for table `phcontracttype`
--

INSERT INTO `phcontracttype` (`id`, `name`, `del`) VALUES
(11, 'DMPA', 0),
(13, 'Implants', 0),
(16, 'POP', 0),
(17, 'Mirena', 0),
(51, 'IUD', 0),
(55, 'OC', 0),
(56, 'Condom', 0),
(57, 'tuba', 0),
(58, 'tubal ligation', 0),
(59, 'coc', 0),
(60, 'progesterone only', 0),
(61, 'mesocept', 0);

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

--
-- Table structure for table `phdysmenorrhoea`
--

CREATE TABLE IF NOT EXISTS `phdysmenorrhoea` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `phdysmenorrhoea`
--

INSERT INTO `phdysmenorrhoea` (`id`, `name`, `del`) VALUES
(1, 'dysmenorrhea', 0);

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

--
-- Table structure for table `phfamily`
--

CREATE TABLE IF NOT EXISTS `phfamily` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `patientid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `doctorid` int(11) unsigned DEFAULT NULL,
  `sysdate` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `family_disease` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `family_relative` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `familynote` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `phfamilydisease`
--

CREATE TABLE IF NOT EXISTS `phfamilydisease` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `phfamilyrelative`
--

CREATE TABLE IF NOT EXISTS `phfamilyrelative` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `phmenstrual`
--

CREATE TABLE IF NOT EXISTS `phmenstrual` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `patientid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sysdate` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `menarche` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `duration` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `length` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phregularity` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phamount` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phdysmenorrhoea` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phl_mp` date DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  `doctorid` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `phobstericterminate`
--

CREATE TABLE IF NOT EXISTS `phobstericterminate` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=26 ;

--
-- Dumping data for table `phobstericterminate`
--

INSERT INTO `phobstericterminate` (`id`, `name`, `del`) VALUES
(1, 'SVD', 0),
(2, 'CS', 0),
(3, 'Ectopic', 0),
(4, 'Abortion', 0),
(5, 'V.mole', 0),
(13, 'aaaa', 1),
(14, 'اااا', 1),
(15, '777', 1),
(16, '4444', 1),
(17, '2222', 1),
(18, 'اى حاجه', 1),
(19, 'eeeee', 1),
(20, 'ssss', 1),
(21, 'zzzz', 1),
(22, 'aa', 0),
(23, 'yygggggg', 0),
(24, 'hhhh', 0),
(25, 'P2', 0);

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

--
-- Table structure for table `phobstericterplace`
--

CREATE TABLE IF NOT EXISTS `phobstericterplace` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  `patientid` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `phobstetric`
--

CREATE TABLE IF NOT EXISTS `phobstetric` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `patientid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sysdate` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `obstrduration` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `obstermination` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `obsplace` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `obsdate` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `obsnote` text COLLATE utf8mb4_unicode_ci,
  `del` int(11) unsigned DEFAULT NULL,
  `doctorid` int(11) unsigned DEFAULT NULL,
  `outcomeid` int(191) DEFAULT NULL,
  `babytype` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `babygendernew` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT '0',
  `babyweight` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `babyname` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `babytype1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `babygendernew1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `babyweight1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `babyname1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `babytype2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `babygendernew2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `babyweight2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `babyname2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `phpastart`
--

CREATE TABLE IF NOT EXISTS `phpastart` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `patientid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sysdate` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `arttype` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `artcenter` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `artyear` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `artnote` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  `doctorid` int(11) unsigned DEFAULT NULL,
  `emdate` date DEFAULT NULL,
  `emembryos` int(11) unsigned DEFAULT NULL,
  `straw1` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `phpastartcenter`
--

CREATE TABLE IF NOT EXISTS `phpastartcenter` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `phpastarttype`
--

CREATE TABLE IF NOT EXISTS `phpastarttype` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=6 ;

--
-- Dumping data for table `phpastarttype`
--

INSERT INTO `phpastarttype` (`id`, `name`, `del`) VALUES
(1, 'IUI', 0),
(2, 'IVF', 0),
(3, 'ICSI', 0),
(4, 'cryo', 0),
(5, 'faild', 0);

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

--
-- Table structure for table `phpastgynecological`
--

CREATE TABLE IF NOT EXISTS `phpastgynecological` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `patientid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `doctorid` int(11) unsigned DEFAULT NULL,
  `sysdate` date DEFAULT NULL,
  `gynecologicaloperation` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gynecologicalyear` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gynecologicalsurgeon` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gynecologicalnote` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `phpastgynecologicaloperation`
--

CREATE TABLE IF NOT EXISTS `phpastgynecologicaloperation` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `phpasticsi`
--

CREATE TABLE IF NOT EXISTS `phpasticsi` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `opu` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `patientid` int(11) unsigned DEFAULT NULL,
  `partentid` int(11) unsigned DEFAULT NULL,
  `gi` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gii` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gv` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `et` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `etf` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `phpastmedical`
--

CREATE TABLE IF NOT EXISTS `phpastmedical` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `patientid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sysdate` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `medicaldisease` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `medicalnote` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  `doctorid` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `phpastmedicaldisease`
--

CREATE TABLE IF NOT EXISTS `phpastmedicaldisease` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `phpastsurgical`
--

CREATE TABLE IF NOT EXISTS `phpastsurgical` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `patientid` int(11) unsigned DEFAULT NULL,
  `doctorid` int(11) unsigned DEFAULT NULL,
  `sysdate` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `surgicaloperation` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phsurgicalyear` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phsurgicalsurgeon` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `surgicalnote` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `phpastsurgicaloperation`
--

CREATE TABLE IF NOT EXISTS `phpastsurgicaloperation` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `phregularity`
--

CREATE TABLE IF NOT EXISTS `phregularity` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=12 ;

--
-- Dumping data for table `phregularity`
--

INSERT INTO `phregularity` (`id`, `name`, `del`) VALUES
(7, 'regular', 0),
(8, 'irrigular', 0),
(9, 'menpause', 0),
(10, 'premenpause', 0),
(11, 'iry amenorrhea', 0);

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

--
-- Table structure for table `place`
--

CREATE TABLE IF NOT EXISTS `place` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=6 ;

--
-- Dumping data for table `place`
--

INSERT INTO `place` (`id`, `title`, `del`) VALUES
(1, 'qqqq', NULL),
(2, 'aaa', NULL),
(3, 'bbbb', NULL),
(5, 'ccc', NULL);

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

--
-- Table structure for table `place2`
--

CREATE TABLE IF NOT EXISTS `place2` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=13 ;

--
-- Dumping data for table `place2`
--

INSERT INTO `place2` (`id`, `title`, `del`) VALUES
(1, 'mccmvmnv', '1'),
(2, 'kjkjkjjj', '1'),
(3, 'kkllklklklklip', '1'),
(4, NULL, '1'),
(5, NULL, '1'),
(6, 'المركز الملكي', '1'),
(7, 'قسم أول', NULL),
(8, 'الروضه', NULL),
(9, 'fayrouz', '1'),
(10, 'الضهره-Ùارسكور', NULL),
(11, 'التكامل', NULL),
(12, 'البراشيه-Ùارسكور', NULL);

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

--
-- Table structure for table `placenta`
--

CREATE TABLE IF NOT EXISTS `placenta` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=21 ;

--
-- Dumping data for table `placenta`
--

INSERT INTO `placenta` (`id`, `title`, `del`) VALUES
(1, 'شىÙ', 1),
(2, 'ant', NULL),
(3, 'post high ', NULL),
(4, 'post high rt lat', NULL),
(5, 'ant high', NULL),
(6, 'fundal ant to lt', NULL),
(7, 'fundalm', 1),
(8, 'fundal', NULL),
(9, 'Ant fundal ', NULL),
(10, 'post placenta', NULL),
(11, 'ant low lying', NULL),
(12, 'pl pr compl cent to rt', NULL),
(13, 'post', NULL),
(14, NULL, NULL),
(15, NULL, NULL),
(16, 'post low to lt', NULL),
(17, NULL, NULL),
(18, NULL, NULL),
(19, '1st->ant / 2nd-> post', NULL),
(20, 'ant low to lt', NULL);

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

--
-- Table structure for table `presenthistoryanswers`
--

CREATE TABLE IF NOT EXISTS `presenthistoryanswers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `presenthistorycatid` int(11) NOT NULL,
  `name` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `favorite` int(11) NOT NULL DEFAULT '0',
  `deleted` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT COMMENT=' invests appear in gyna and antenatal ' AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `presenthistoryquestions`
--

CREATE TABLE IF NOT EXISTS `presenthistoryquestions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted` int(11) NOT NULL DEFAULT '0',
  `displayorder` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT COMMENT='cats for invests appear in gyna and antenatal ' AUTO_INCREMENT=2 ;

--
-- Dumping data for table `presenthistoryquestions`
--

INSERT INTO `presenthistoryquestions` (`id`, `name`, `deleted`, `displayorder`) VALUES
(1, '111', 0, 1);

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

--
-- Table structure for table `previous_marriage`
--

CREATE TABLE IF NOT EXISTS `previous_marriage` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `period` varchar(255) DEFAULT NULL,
  `males` int(11) DEFAULT '0',
  `females` int(11) DEFAULT '0',
  `last_age` varchar(255) DEFAULT NULL,
  `deleted` int(11) DEFAULT '0',
  `patientid` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `programesetting`
--

CREATE TABLE IF NOT EXISTS `programesetting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `centername` varchar(255) DEFAULT NULL,
  `doctorname` varchar(255) DEFAULT NULL,
  `spacial` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `color` float DEFAULT NULL,
  `above` float DEFAULT NULL,
  `buttom` float DEFAULT NULL,
  `pleft` float DEFAULT NULL,
  `pright` float DEFAULT NULL,
  `center` float DEFAULT NULL,
  `gynalink` varchar(225) DEFAULT NULL,
  `antenatal` varchar(225) DEFAULT NULL,
  `fontsizeen` int(6) DEFAULT NULL,
  `fontsizear` int(6) DEFAULT NULL,
  `alignttt` char(2) DEFAULT '0',
  `ultrasound` char(1) DEFAULT '0',
  `patientnoaut` char(1) DEFAULT '0',
  `addshours` int(11) DEFAULT '0',
  `ishide` int(11) DEFAULT '0',
  `simpleview` int(11) DEFAULT '0',
  `displaydoctorname` int(11) DEFAULT '0',
  `entryorder` int(11) DEFAULT '0',
  `investshow` int(11) NOT NULL,
  `prescriptioncashing` int(11) DEFAULT '0',
  `diagnosshow` int(11) NOT NULL,
  `visitsform` int(11) DEFAULT '0',
  `background` varchar(255) NOT NULL,
  `backupdest` text,
  `backupdriver` varchar(191) DEFAULT NULL,
  `hideid` tinyint(1) unsigned DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `password` varchar(191) DEFAULT NULL,
  `erpdb` varchar(191) DEFAULT NULL,
  `erpdbsave` int(11) unsigned DEFAULT NULL,
  `balance` tinyint(1) unsigned DEFAULT NULL,
  `head` tinyint(1) unsigned DEFAULT NULL,
  `chest` tinyint(1) unsigned DEFAULT NULL,
  `abdomen` tinyint(1) unsigned DEFAULT NULL,
  `pelvis` tinyint(1) unsigned DEFAULT NULL,
  `extremitis` tinyint(1) unsigned DEFAULT NULL,
  `btype` tinyint(1) unsigned DEFAULT NULL,
  `hbtype` tinyint(1) unsigned DEFAULT NULL,
  `risk` tinyint(1) unsigned DEFAULT NULL,
  `notes` tinyint(1) unsigned DEFAULT NULL,
  `menstrual` tinyint(1) unsigned DEFAULT NULL,
  `contraception` tinyint(1) unsigned DEFAULT NULL,
  `obstetric` tinyint(1) unsigned DEFAULT NULL,
  `past` tinyint(1) unsigned DEFAULT NULL,
  `family` tinyint(1) unsigned DEFAULT NULL,
  `medical` tinyint(1) unsigned DEFAULT NULL,
  `surgical` tinyint(1) unsigned DEFAULT NULL,
  `gynecological` tinyint(1) unsigned DEFAULT NULL,
  `art` tinyint(1) unsigned DEFAULT NULL,
  `entrydetails` tinyint(1) unsigned DEFAULT NULL,
  `gynalmp` tinyint(1) unsigned DEFAULT NULL,
  `infertility` int(11) DEFAULT '0',
  `namefontsize` varchar(191) DEFAULT NULL,
  `programview` tinyint(1) unsigned DEFAULT NULL,
  `patient_doctor` int(11) NOT NULL DEFAULT '0' COMMENT '0 yes , 1 no ',
  `previous_marriage` int(11) DEFAULT '0',
  `phppath` varchar(255) DEFAULT NULL,
  `art_internal` tinyint(4) DEFAULT NULL,
  `art_external` tinyint(4) DEFAULT NULL,
  `visit_period` int(11) DEFAULT '0',
  `print_diag` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=2 ;

--
-- Dumping data for table `programesetting`
--

INSERT INTO `programesetting` (`id`, `centername`, `doctorname`, `spacial`, `address`, `phone`, `logo`, `color`, `above`, `buttom`, `pleft`, `pright`, `center`, `gynalink`, `antenatal`, `fontsizeen`, `fontsizear`, `alignttt`, `ultrasound`, `patientnoaut`, `addshours`, `ishide`, `simpleview`, `displaydoctorname`, `entryorder`, `investshow`, `prescriptioncashing`, `diagnosshow`, `visitsform`, `background`, `backupdest`, `backupdriver`, `hideid`, `email`, `password`, `erpdb`, `erpdbsave`, `balance`, `head`, `chest`, `abdomen`, `pelvis`, `extremitis`, `btype`, `hbtype`, `risk`, `notes`, `menstrual`, `contraception`, `obstetric`, `past`, `family`, `medical`, `surgical`, `gynecological`, `art`, `entrydetails`, `gynalmp`, `infertility`, `namefontsize`, `programview`, `patient_doctor`, `previous_marriage`, `phppath`, `art_internal`, `art_external`, `visit_period`, `print_diag`) VALUES
(1, '', '', '', '', '', '429e9f43800a60bec13d37452e5a0287.jpg', NULL, 5.6, 1.5, NULL, NULL, NULL, NULL, NULL, 24, 24, '-1', '1', '0', 5, 1, 0, NULL, 0, 0, 1, 0, 0, '3dc7359216f58b9f75ea75c50d240a80.jpg', NULL, 'D:\\wamp\\bin\\mysql\\mysql5.6.17', 0, '', '', 'obgy_app', 1, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NULL, NULL, NULL, '', 1, 1, 1, '', 1, 1, 1, NULL);

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

--
-- Table structure for table `receiptdrugs`
--

CREATE TABLE IF NOT EXISTS `receiptdrugs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `receipt_id` int(11) NOT NULL,
  `drugs_id` int(11) NOT NULL,
  `amount` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `recepittmp`
--

CREATE TABLE IF NOT EXISTS `recepittmp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `doctor_id` int(11) NOT NULL,
  `patient_id` int(11) NOT NULL,
  `rect_date` date NOT NULL,
  `drugstablename` varchar(250) DEFAULT NULL,
  `status` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `records`
--

CREATE TABLE IF NOT EXISTS `records` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patientid` int(11) NOT NULL,
  `date` date NOT NULL,
  `diagnosis` text COLLATE utf8mb4_unicode_ci,
  `ttt` text COLLATE utf8mb4_unicode_ci,
  `del` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `registeration`
--

CREATE TABLE IF NOT EXISTS `registeration` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ancsheetid` int(11) unsigned DEFAULT NULL,
  `place2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `origin` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `awifep` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `coast` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `semen`
--

CREATE TABLE IF NOT EXISTS `semen` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `sdate` date DEFAULT NULL,
  `patientid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  `count` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `motilitya` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `motilityab` text COLLATE utf8mb4_unicode_ci,
  `normal` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `puscell` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `normaltype` int(191) DEFAULT NULL,
  `oligo` int(191) DEFAULT NULL,
  `astheno` int(191) DEFAULT NULL,
  `tetrato` int(191) DEFAULT NULL,
  `doctorid` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `semen2`
--

CREATE TABLE IF NOT EXISTS `semen2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `infertilitysheetid` int(11) unsigned DEFAULT NULL,
  `semen2placesemenfr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `semen2resultscrotal` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `semen2resulttrue` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `semen2placetese` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `semen2resultyqmicro` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `semen2resultsdf` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `semen2resultkaryo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `detescrotal` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `detetrue` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `detekaryo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deteyqmicro` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `detesdf` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `detesemenfr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `detetese` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deteother` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `placescrotal` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `placetrue` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `placeyqmicro` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `placekaryo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `placesdf` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `placeother` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `resultother` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `resulttese` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `resultsemenfraf` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `resultsemenfrm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `resultsemenfrc` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `semen2placesemenfr`
--

CREATE TABLE IF NOT EXISTS `semen2placesemenfr` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=6 ;

--
-- Dumping data for table `semen2placesemenfr`
--

INSERT INTO `semen2placesemenfr` (`id`, `title`, `del`) VALUES
(1, 'مركز رويال', NULL),
(2, 'مركز الأهرام', NULL),
(3, 'مركز جنه ', NULL),
(4, 'الÙيروز', NULL),
(5, 'م.الخصوبه', NULL);

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

--
-- Table structure for table `semen2placetese`
--

CREATE TABLE IF NOT EXISTS `semen2placetese` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `semen2placetese`
--

INSERT INTO `semen2placetese` (`id`, `title`, `del`) VALUES
(1, 'TESE', 1),
(2, 'مركز رويال', NULL);

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

--
-- Table structure for table `semen2resultkaryo`
--

CREATE TABLE IF NOT EXISTS `semen2resultkaryo` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `semen2resultkaryo`
--

INSERT INTO `semen2resultkaryo` (`id`, `title`, `del`) VALUES
(1, 'n', NULL),
(2, 'klinefilter', NULL),
(3, NULL, NULL);

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

--
-- Table structure for table `semen2resultscrotal`
--

CREATE TABLE IF NOT EXISTS `semen2resultscrotal` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=36 ;

--
-- Dumping data for table `semen2resultscrotal`
--

INSERT INTO `semen2resultscrotal` (`id`, `title`, `del`) VALUES
(1, 'varicocele', NULL),
(2, 'atrophic testis', NULL),
(3, 'n', NULL),
(4, 'rt', NULL),
(5, 'lt', NULL),
(6, 'bilat', NULL),
(7, 'grade 2', NULL),
(8, 'score 7', NULL),
(9, 'small sized both testicle rt vol (8.2) lt (7.4)', NULL),
(10, 'grade 1', NULL),
(11, 'absent lt testis', NULL),
(12, 'atrophic rt testis', NULL),
(13, 'lt varicocele ', NULL),
(14, 'grade 3', NULL),
(15, 'rt varicocele', NULL),
(16, 'mod', NULL),
(17, 'no varicocele', NULL),
(18, 'recurrent', NULL),
(19, 'mild', NULL),
(20, 'bil mod hydrocele', NULL),
(21, 'rt testicle 5.4x2.3cm', NULL),
(22, 'lt testicle5.2x2.1cm', NULL),
(23, 'lt III', NULL),
(24, 'Rt II', NULL),
(25, 'atrophic lt testis', NULL),
(26, 'n size rt testis', NULL),
(27, 'grade 4', NULL),
(28, 'lt varicocele grade II , bilat enlarged LNs', NULL),
(29, 'small', NULL),
(30, 'testis', NULL),
(31, '', NULL),
(32, '', NULL),
(33, 'lt epididymal spermatocele 2.3x1.8cm + small rt epididymal head spermatocele 2.5x2.5mm', NULL),
(34, 'small sized retractile lt testis 7cm3', NULL),
(35, 'normal sized testes', NULL);

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

--
-- Table structure for table `semen2resultsdf`
--

CREATE TABLE IF NOT EXISTS `semen2resultsdf` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `semen2resultsdf`
--

INSERT INTO `semen2resultsdf` (`id`, `title`, `del`) VALUES
(1, 'n', NULL),
(2, 'DFI > 30%', NULL);

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

--
-- Table structure for table `semen2resulttrue`
--

CREATE TABLE IF NOT EXISTS `semen2resulttrue` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `semen2resulttrue`
--

INSERT INTO `semen2resulttrue` (`id`, `title`, `del`) VALUES
(1, 'n', NULL),
(2, 'OA', NULL);

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

--
-- Table structure for table `semen2resultyqmicro`
--

CREATE TABLE IF NOT EXISTS `semen2resultyqmicro` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=5 ;

--
-- Dumping data for table `semen2resultyqmicro`
--

INSERT INTO `semen2resultyqmicro` (`id`, `title`, `del`) VALUES
(1, 'n', NULL),
(2, 'AZF a/b', NULL),
(3, 'AZF c', NULL),
(4, 'no deletion', NULL);

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

--
-- Table structure for table `semeninfertility`
--

CREATE TABLE IF NOT EXISTS `semeninfertility` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `infertilitysheetid` int(11) unsigned DEFAULT NULL,
  `semenplace` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sementype` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nc` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `prm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `af` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vit` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vol` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tzi` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sdi` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `semenplace`
--

CREATE TABLE IF NOT EXISTS `semenplace` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=91 ;

--
-- Dumping data for table `semenplace`
--

INSERT INTO `semenplace` (`id`, `title`, `del`) VALUES
(1, 'eeeeeeeeeeee', 1),
(2, 'as', 1),
(3, 'sddseerr', 1),
(4, 'qwqwwe', 1),
(5, 'wwwwww', 1),
(6, 'uiui', 1),
(7, 'dfdfdfdf', 1),
(8, 'qqqqqq', 1),
(9, NULL, 1),
(10, NULL, 1),
(11, 'sssdddddddddddddddddddddddd', 1),
(12, 'ccc', 1),
(13, NULL, 1),
(14, 'jjfjf', 1),
(15, 'ddfrrer', 1),
(16, 'gggggggg', 1),
(17, 'hhhhhhhhhhhh', 1),
(18, 'kkkkkkkkkkk', 1),
(19, 'ffffffffffff', 1),
(20, 'ew', 1),
(21, 'معمل القدس', NULL),
(22, 'معمل القاضي', NULL),
(23, 'معمل البرج', NULL),
(24, 'معمل المختبر', NULL),
(25, 'معمل الشربيني', NULL),
(26, 'معمل سونه', NULL),
(27, 'معمل ميترا', NULL),
(28, 'معمل الامل الاسكندريه', NULL),
(29, 'معمل شÙاء', NULL),
(30, 'معمل الÙيروز', NULL),
(31, 'معمل ايجبت لاب', NULL),
(32, '', NULL),
(33, 'معمل الحكمه', NULL),
(34, 'معمل صلاح عارÙ', NULL),
(35, 'مركز الاهرام للخصوبه', NULL),
(36, 'مركز رويال للخصوبة', NULL),
(37, 'معمل سيتي', NULL),
(38, 'معمل ترست', NULL),
(39, 'معمل سيجما', NULL),
(40, 'الكويت', NULL),
(41, 'معمل السلام', NULL),
(42, 'معمل جنه', NULL),
(43, 'معمل الكويتي الالماني', NULL),
(44, 'معمل البهائى بورسعيد', NULL),
(45, 'معمل دار الÙؤاد-بورسعيد', NULL),
(46, 'كÙر الغاب', NULL),
(47, 'ابراهيم عبد القادر', NULL),
(48, 'معمل ريال لاب- كÙر سعد', NULL),
(49, 'معمل اوميجا', NULL),
(50, 'معمل المدينه', NULL),
(51, 'معمل جنين', NULL),
(52, 'معمل  محمد الÙراش', NULL),
(53, 'معمل ابراهيم عبد القادر', NULL),
(54, 'م.مصر طنطا', NULL),
(55, 'م.الاهواني المهندسين', NULL),
(56, 'م. المستقبل', NULL),
(57, 'رضا سلطان', NULL),
(58, 'حاÙظ جويلي', NULL),
(59, 'م.عاشور-كÙر الشيخ', NULL),
(60, 'م.شريÙ الغنام', NULL),
(61, 'م.درس لاب', NULL),
(62, 'م.الملكي', NULL),
(63, 'م.احمد سعد كÙر سعد', NULL),
(64, 'م.أبشر', NULL),
(65, 'م.الاطباء -الحامول', NULL),
(66, 'م.تكنو لاب', NULL),
(67, 'م.النيل', NULL),
(68, 'م.بدران', NULL),
(69, 'م. عادل عبد القادر', NULL),
(70, 'م. شÙاء', NULL),
(71, 'م.الÙا', NULL),
(72, 'م.الدرس', NULL),
(73, 'م.الاهرام', NULL),
(74, 'معمل  الأمل', NULL),
(75, 'م.رعاية الزرقا', NULL),
(76, 'م.ايجيبت لاب', NULL),
(77, 'معمل استرا', NULL),
(78, 'معمل طيبه', NULL),
(79, 'معمل محمد صحصاح', NULL),
(80, 'م.أدم القاهره', NULL),
(81, 'م.حياه', NULL),
(82, 'م. جنه', NULL),
(83, 'م. احمد الشويحي', NULL),
(84, 'م.مشرÙه', NULL),
(85, 'معمل المستقبل', NULL),
(86, 'م.ابراهيم عبد القادر', NULL),
(87, 'معمل أسترا', NULL),
(88, 'lv', NULL),
(89, 'معمل انجاب', NULL),
(90, 'معمل الخصوبه', NULL);

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

--
-- Table structure for table `sementype`
--

CREATE TABLE IF NOT EXISTS `sementype` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=13 ;

--
-- Dumping data for table `sementype`
--

INSERT INTO `sementype` (`id`, `title`, `del`) VALUES
(1, 'mmmm', 1),
(2, 'dfddfffffffffffffffff', 1),
(3, 'eerere', 1),
(4, 'qwqwqwerer', 1),
(5, 'qwqwewe', 1),
(6, NULL, 1),
(7, 'conventional', NULL),
(8, 'CASA', NULL),
(9, 'hhhhhhhhhhhh', 1),
(10, 'dfffffffffffff', 1),
(11, 'gggggggggggg', 1),
(12, NULL, 1);

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

--
-- Table structure for table `sheethusband`
--

CREATE TABLE IF NOT EXISTS `sheethusband` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=30 ;

--
-- Dumping data for table `sheethusband`
--

INSERT INTO `sheethusband` (`id`, `title`, `del`) VALUES
(1, 'hormonal profile', NULL),
(2, 'semen', NULL),
(3, 'cASA', NULL),
(4, 'semen freezing', NULL),
(5, 'e yeast - trental sr -oxa lozenges', NULL),
(6, 'trental-selenium -fa', NULL),
(7, '---', NULL),
(8, 'complete ttt 3m --> repeat semen --> if same : think about ICSI', NULL),
(9, 'if no preg this cycle', NULL),
(10, 'Gona 150 - epiff 5000 /w  3m then semen', NULL),
(11, 'wt dec', NULL),
(12, ' trental sr-selenium aCE- Folic acid', NULL),
(13, 'mic TESE with ICSI', NULL),
(14, 'oxifree - FA', NULL),
(15, 'postpone semen', NULL),
(16, 'next cycle', NULL),
(17, '', NULL),
(18, 'epif 500/w- f75/w- trental- selenium- fa-->3m then mic tESE if +ve-->ICSI', NULL),
(19, 'FSH- T.T- AZF gene-Karyotyping', NULL),
(20, 'HSG(Tubal patency, exclude hydrosalpinix)- aMH, TSH', 1),
(21, 'no semen at all (no seminal fluid)- hormonal profile', NULL),
(22, '(on ptn request)', NULL),
(23, 'pRL,CASA', NULL),
(24, 'karyotyping', NULL),
(25, 'epifassi 5000/w - selenium aCE 1x2 to complete 3m of ttt then trial semen freezing', NULL),
(26, 'CASA + semen freeze when arrive', NULL),
(27, 'refer to andrology', NULL),
(28, 'genetic (karyo-AZF gene)', NULL),
(29, 'scrotal US', NULL);

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

--
-- Table structure for table `sheetlocation`
--

CREATE TABLE IF NOT EXISTS `sheetlocation` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=10 ;

--
-- Dumping data for table `sheetlocation`
--

INSERT INTO `sheetlocation` (`id`, `title`, `del`) VALUES
(1, 'السعودية', NULL),
(2, 'قطر', NULL),
(3, NULL, 1),
(4, 'انجلترا', NULL),
(5, 'اليونان', NULL),
(6, 'kuwait', NULL),
(7, 'cairo', NULL),
(8, 'الامارات', NULL),
(9, 'sharm el sheikh', NULL);

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

--
-- Table structure for table `sheetwife`
--

CREATE TABLE IF NOT EXISTS `sheetwife` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=116 ;

--
-- Dumping data for table `sheetwife`
--

INSERT INTO `sheetwife` (`id`, `title`, `del`) VALUES
(1, 'decrease wt 14 kg if no preg semen +HSG before COS', NULL),
(2, '', NULL),
(3, 'TSH-PRL-AMH', NULL),
(4, 'hysteroscope correction of subseptate', NULL),
(5, 'excision of cervical polyp', NULL),
(6, 'hysteroscope then ICSI', NULL),
(7, 'withdr (steronate 1x2x5) then COS (letrozol synthon 1x2x5)', NULL),
(8, 'for 2m --> if no preg --> HSG', NULL),
(9, 'PRL Then next cycle COS(HMG)-postpone endoscopy - FA', NULL),
(10, 'dec wt', NULL),
(11, 'staticap - gluco 1000', NULL),
(12, 'myomectomy ', NULL),
(13, 'tubal disconnection', NULL),
(14, 'AMH', NULL),
(15, 'then ICSI', NULL),
(16, '9', NULL),
(17, 'PRL - TSH', NULL),
(18, 'Prepare for FET', NULL),
(19, 'HMG 3-6M', NULL),
(20, 'CASA', NULL),
(21, 'HSG Then HMG', NULL),
(22, '15 kg', NULL),
(23, 'FA', NULL),
(24, 'COS concentrating on lt tube vs FET', NULL),
(25, '', NULL),
(26, 'Dostilact ', NULL),
(27, 'TOO this cycle epif 2 D15 - progest d17 1x2x15', NULL),
(28, 'if no preg', NULL),
(29, 'ICSI', NULL),
(30, 'lap to rule out hydrosalpnix', NULL),
(31, 'hyst (arcuate - polypi)', NULL),
(32, 'hysteroscopic correction of subseptate ut +dec wt 20kg +HMG--->if no preg -->HSG...(in preg -->juspirin-clexane)', NULL),
(33, 'lt breast US for br lump', NULL),
(34, 'f.up ov cyst postmenst', NULL),
(35, 'after m travel', NULL),
(36, 'COC (gynocept) 1m', NULL),
(37, '3', NULL),
(38, 'complete folliculometry  d13', NULL),
(39, ' postpone HSG when wife travel to husband- after 3 m start HMG', NULL),
(40, ' gluco 1000', NULL),
(41, '- FET In  ابو الÙار او المركز السامي After 1 M Coc Norocarmina -TSH, Prl, Solupred 20 1/2', NULL),
(42, 'Fa-Amrizole N- Lutone 3 If Menses Delayed For 10 Days Then COS', NULL),
(43, 'Plan : Lap Or HSG Then HMG', NULL),
(44, 'hSG-->if hydrosalpinix-->lap discon+ICSI', NULL),
(45, '10', NULL),
(46, 'HCG --> if -ve --> lap (rule out hydrosalpnix) ', NULL),
(47, 'ttt of cx erosion', NULL),
(48, 'next cycle HMG 2-3m if no preg --> HSG', NULL),
(49, 'AMH+ multivit+ anti infec+steronate nor d18 then antag ICSI', NULL),
(50, '+- diag hysteroscope', NULL),
(51, 'then COS With next cycle for 1-3 m', NULL),
(52, 'HSG+removal of ant cx lip fibroid', NULL),
(53, '(withdrwal + supp of cyst)', NULL),
(54, '(check lt tubal patency)', NULL),
(55, 'anti oxidants (selenium - oxifree)', NULL),
(56, 'TSH', NULL),
(57, 'Control D.M-thyroid-dec wt-gluco 1000 then ICSI (antagonist)', NULL),
(58, 'hMG 2m --> if no preg --> ICSI', NULL),
(59, 'eltroxin 50/d', NULL),
(60, 'martaviva 1 (after hyst)', NULL),
(61, 'lap (?? endometriosis)', NULL),
(62, 'ttt vaginitis', NULL),
(63, 'Female: TSH,PRL The COS +IUI This Month For 3 Trials', 1),
(64, '', NULL),
(65, 'TSH,PRL The COS +IUI This Month For 3 Trials', 1),
(66, 'TSH,PRL The COS +IUI This Month For 3 Trials - Male Refuse Postpone COS Next Cycle', NULL),
(67, 'nercefaxone 1gm-doxymycin 2 -albothyl supp- dec wt', NULL),
(68, '', NULL),
(69, 'HSG(Tubal Patency, Exclude Hydrosalpinix)- AMH, TSH', NULL),
(70, 'office hyst to correct suggestive arcuate then ICSI(antag)', NULL),
(71, 'ptn prefer HMG for 3m as atrial but afraid of OHSS', NULL),
(72, 'DA 1', NULL),
(73, 'DA 2', NULL),
(74, 'when confirm sex select--> IUD removal then ICSI+ sex select', NULL),
(75, 'office hyst', NULL),
(76, 'repeat HSG to rule out tubal block+ dec wt 20kg', NULL),
(77, '+ tESE', NULL),
(78, '2', NULL),
(79, 'HSG', NULL),
(80, '', NULL),
(81, 'when male arrive after 2m HMG', NULL),
(82, 'as ptn just miscarried 2 m ago so B-HCG ', NULL),
(83, 'then?? MTX then cotraception for 3m then spontanous pregnancy', NULL),
(84, 'then laporscope vs ICSI', NULL),
(85, 'diagonstic laproscope then COS', NULL),
(86, 'tSH+ triggering of ovulation(2 epif d16,progest d18 1x2x15) if no preg-->semen+AMH', NULL),
(87, 'office hysteroscope then ICSI', NULL),
(88, 'HSG  to rule out  hydrosalpinx in other f.t +wt reduction (20kg) +AMH-TSH then decide', NULL),
(89, 'orly', NULL),
(90, 'tSH-AMH repeat 4D after 2w then ICSI + micr TESE+ pre hysteroscope', NULL),
(91, 'TOO Epif or choriomon+progest d16 1x2x15 ', NULL),
(92, 'if no preg + bad semen--->ICSI +- pre tubal disconn - if no preg + good semen ---> lap adhesions , hydrosalpinix', NULL),
(93, 'then ICSI+sex selection', NULL),
(94, 'lap (LOD - Adhesiolysis)', NULL),
(95, 'HbA1C', NULL),
(96, '8-9', NULL),
(97, 'iCSI (after m travel)', NULL),
(98, 'HSG(rule out lt hydrosal)', NULL),
(99, 'f.Up endom from d11 (? need for PRP)', NULL),
(100, 'off. hyst', NULL),
(101, 'then FET', NULL),
(102, 'Ptn Complete 6m F.Up After Evacuation Of Incomplete V.Mole -  Next Cycle: COS', NULL),
(103, 'if all n--> try 1m HMG--> if no preg--> lap (endometriosis)', NULL),
(104, 'then?? clomid+ counsel about fertile period', NULL),
(105, '', NULL),
(106, 'finantially dec', NULL),
(107, '3.5', NULL),
(108, 'COS(CCLLetrozole) 3m', NULL),
(109, 'hSG then ? laparoscope - cause of misc (arcuate+-/v.mole/hydrosalpinix)', NULL),
(110, '5kg only', NULL),
(111, 'hMG 1-3m if no preg-->lap8(adhesiolysis-LOD)', NULL),
(112, 'ICSI (male did not prefer lap diag,ttt for adhesiolysis)+ pre hyst', NULL),
(113, '', NULL),
(114, 'conserve 3m-->tecnovula', NULL),
(115, 'staticap', NULL);

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

--
-- Table structure for table `sis`
--

CREATE TABLE IF NOT EXISTS `sis` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `infertilitysheetid` int(11) unsigned DEFAULT NULL,
  `sisresult` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sonar`
--

CREATE TABLE IF NOT EXISTS `sonar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patientid` int(11) NOT NULL,
  `sonardate` date NOT NULL,
  `imagename` varchar(255) DEFAULT NULL,
  `notes` varchar(255) NOT NULL,
  `vediourl` longtext,
  `tempdelete` char(1) NOT NULL DEFAULT '0',
  `type` int(11) NOT NULL,
  `originalname` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sseemen`
--

CREATE TABLE IF NOT EXISTS `sseemen` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `sseemen`
--

INSERT INTO `sseemen` (`id`, `title`, `del`) VALUES
(1, 'fresh', NULL),
(2, 'frozen', NULL);

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

--
-- Table structure for table `sseemmeen`
--

CREATE TABLE IF NOT EXISTS `sseemmeen` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `sseemmeen`
--

INSERT INTO `sseemmeen` (`id`, `title`, `del`) VALUES
(1, 'Freezing', NULL),
(2, 'no freezing', NULL);

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

--
-- Table structure for table `sseemmen`
--

CREATE TABLE IF NOT EXISTS `sseemmen` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `sseemmen`
--

INSERT INTO `sseemmen` (`id`, `title`, `del`) VALUES
(1, 'sample', NULL);

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

--
-- Table structure for table `ssemen`
--

CREATE TABLE IF NOT EXISTS `ssemen` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `ssemen`
--

INSERT INTO `ssemen` (`id`, `title`, `del`) VALUES
(1, 'good', NULL),
(2, 'bad', NULL);

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

--
-- Table structure for table `surgicalhistory`
--

CREATE TABLE IF NOT EXISTS `surgicalhistory` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=55 ;

--
-- Dumping data for table `surgicalhistory`
--

INSERT INTO `surgicalhistory` (`id`, `title`, `del`) VALUES
(1, 'appendicectomy', NULL),
(2, 'myomectomy', NULL),
(3, 'ov cystectomy', NULL),
(4, 'lap bil tubal disconn', NULL),
(5, 'EP - conservative', NULL),
(6, 'EP - MTX', NULL),
(7, 'EP - Laparoscopy - otomy', NULL),
(8, 'EP - Laparoscopy - ectomy', NULL),
(9, 'EP - Laparotomy - Otomy', NULL),
(10, 'EP - Laparotomy - ectomy', NULL),
(11, '', 1),
(12, '', 1),
(13, '', 1),
(14, '', 1),
(15, '', 1),
(16, '', 1),
(17, '', 1),
(18, 'cS', NULL),
(19, 'total thyroidectomy', NULL),
(20, 'hysterectomy', NULL),
(21, 'Cholecystectomy lap', NULL),
(22, 'cholecystectomy ', NULL),
(23, 'anal fissure', NULL),
(24, 'lt oophrectomy - laparotomy', NULL),
(25, 'cardiac operation', NULL),
(26, 'ov cyst aspiration', NULL),
(27, 'ear operation', NULL),
(28, 'rt ov cystectomy', NULL),
(29, 'tonsillectomy', NULL),
(30, '?? vaginal cystectomy ', NULL),
(31, 'bil ovarian cystectomy', NULL),
(32, '+ IUD removal', NULL),
(33, '(open)', NULL),
(34, 'vulval cyst ', NULL),
(35, 'vulval abscess', NULL),
(36, 'rt salpingectomy (eP)', NULL),
(37, 'rt', NULL),
(38, 'lt', NULL),
(39, 'bil breast lumpectomy', NULL),
(40, 'upper GIT endoscope', NULL),
(41, 'hystroscope', NULL),
(42, 'Laproscopic ov. drilling', NULL),
(43, '', NULL),
(44, '', NULL),
(45, '', NULL),
(46, 'open heart', NULL),
(47, 'obstructed rt kidney-> post silicon insertion', NULL),
(48, 'lap rt salpingectomy', NULL),
(49, 'cx cautery', NULL),
(50, 'lumbar disc operation', NULL),
(51, 'excision lt breast abcess', NULL),
(52, 'lt hgic cyst', NULL),
(53, 'nasal septum deviation', NULL),
(54, 'cystoscope', NULL);

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

--
-- Table structure for table `surgicalhistorydm`
--

CREATE TABLE IF NOT EXISTS `surgicalhistorydm` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=14 ;

--
-- Dumping data for table `surgicalhistorydm`
--

INSERT INTO `surgicalhistorydm` (`id`, `title`, `del`) VALUES
(1, 'herniorrhaphy', NULL),
(2, 'varicocelectomy', NULL),
(3, 'cystoscope ', NULL),
(4, 'orchiectomy', NULL),
(5, 'unilat', NULL),
(6, 'lt', NULL),
(7, 'rt', NULL),
(8, 'splenectomy', NULL),
(9, 'lt breast lumpectomy', NULL),
(10, 'appendicectomy', NULL),
(11, 'knee,hand operation', NULL),
(12, 'piles, anal fissure', NULL),
(13, 'hard palate tumor excision', NULL);

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

--
-- Table structure for table `table2`
--

CREATE TABLE IF NOT EXISTS `table2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name2` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `table3`
--

CREATE TABLE IF NOT EXISTS `table3` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `tablename`
--

CREATE TABLE IF NOT EXISTS `tablename` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `testtbl1`
--

CREATE TABLE IF NOT EXISTS `testtbl1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name2` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `testtbl2`
--

CREATE TABLE IF NOT EXISTS `testtbl2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(55) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `totalbalance`
--

CREATE TABLE IF NOT EXISTS `totalbalance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patientid` int(11) DEFAULT NULL,
  `balance` int(11) DEFAULT NULL,
  `deleted` int(11) DEFAULT '0',
  `userid` int(11) DEFAULT NULL,
  `adddate` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `totalbalancepaids`
--

CREATE TABLE IF NOT EXISTS `totalbalancepaids` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patientid` int(11) DEFAULT NULL,
  `paid` float DEFAULT NULL,
  `userid` int(11) DEFAULT NULL,
  `paydate` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `tttda`
--

CREATE TABLE IF NOT EXISTS `tttda` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `tttda`
--

INSERT INTO `tttda` (`id`, `title`, `del`) VALUES
(1, 'yes', NULL),
(2, '--', NULL);

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

--
-- Table structure for table `tttmetformin`
--

CREATE TABLE IF NOT EXISTS `tttmetformin` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=5 ;

--
-- Dumping data for table `tttmetformin`
--

INSERT INTO `tttmetformin` (`id`, `title`, `del`) VALUES
(1, 'yes', NULL),
(2, '--', NULL),
(3, 'gluco 500', NULL),
(4, 'cidophage', NULL);

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

--
-- Table structure for table `tttresponse`
--

CREATE TABLE IF NOT EXISTS `tttresponse` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=5 ;

--
-- Dumping data for table `tttresponse`
--

INSERT INTO `tttresponse` (`id`, `title`, `del`) VALUES
(1, 'good', NULL),
(2, 'bad', NULL),
(3, NULL, NULL),
(4, NULL, NULL);

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

--
-- Table structure for table `ttttype`
--

CREATE TABLE IF NOT EXISTS `ttttype` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=14 ;

--
-- Dumping data for table `ttttype`
--

INSERT INTO `ttttype` (`id`, `title`, `del`) VALUES
(1, 'CC', NULL),
(2, 'nolvadex', NULL),
(3, 'letrozole', NULL),
(4, 'HMG', NULL),
(5, 'tecnovula', NULL),
(6, 'femara', NULL),
(7, '5-2021', NULL),
(8, '7-2020', NULL),
(9, 'last 1y ago', NULL),
(10, 'last 7 y', NULL),
(11, 'no folliculometry', NULL),
(12, 'last 3m ago', NULL),
(13, '', NULL);

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

--
-- Table structure for table `tvs`
--

CREATE TABLE IF NOT EXISTS `tvs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `infertilitysheetid` int(11) unsigned DEFAULT NULL,
  `tvsut` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tvsro` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tvslo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tvscx` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tvspelvis` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dtvsplace` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `tvscx`
--

CREATE TABLE IF NOT EXISTS `tvscx` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=13 ;

--
-- Dumping data for table `tvscx`
--

INSERT INTO `tvscx` (`id`, `title`, `del`) VALUES
(1, 'n', NULL),
(2, 'nabothian foll', NULL),
(3, 'fibroid', NULL),
(4, 'small ant cx lip fibroid', NULL),
(5, 'Cx Preg (GS Eccentric In Post Cx Lip)', NULL),
(6, '', NULL),
(7, '', NULL),
(8, '', NULL),
(9, 'small erosion', NULL),
(10, 'large cx', NULL),
(11, 'open ext os', NULL),
(12, 'Multiple Nabothian Follicle Like Stimulated Ovary', NULL);

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

--
-- Table structure for table `tvslo`
--

CREATE TABLE IF NOT EXISTS `tvslo` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=42 ;

--
-- Dumping data for table `tvslo`
--

INSERT INTO `tvslo` (`id`, `title`, `del`) VALUES
(1, 'N', NULL),
(2, 'PCO', NULL),
(3, 'Classic PCO', NULL),
(4, 'classic large PCO', NULL),
(5, 'cyst (simple)', NULL),
(6, 'cyst (hgic)', NULL),
(7, 'cyst (choclate)', NULL),
(8, 'cyst (dermoid)', NULL),
(9, 'TOC', NULL),
(10, 'typical', NULL),
(11, 'atypical', NULL),
(12, 'hydrosalpnix', NULL),
(13, 'TO encysted adhesions', NULL),
(14, 'fair', NULL),
(15, 'follicle 20mm (D16)', NULL),
(16, 'follicle 19mm', NULL),
(17, 'follicle 11mm', NULL),
(18, 'prolapsed in DOP', NULL),
(19, '3x3.3 Cm', NULL),
(20, 'cyst (multilocular)', NULL),
(21, '1.5 cm', NULL),
(22, '2cm', NULL),
(23, 'surgically removed', NULL),
(24, '1.2x2 - 2x2.5 - 2.5 Cm', NULL),
(25, '2 chocolate cysts (1x1.8cm) (2x5cm)', NULL),
(26, 'simple cyst 2.5x3cm', NULL),
(27, 'early', NULL),
(28, '4x2.5cm', NULL),
(29, '2 follic 11,13', NULL),
(30, 'gF 18mm', NULL),
(31, 'mild PCO', NULL),
(32, 'mid sized', NULL),
(33, 'small', NULL),
(34, '? PCO+ GF 21mm', NULL),
(35, ' It:endometrioma 2x3.5cm', NULL),
(36, 'small Early Endometrioma 1.5 Cm', NULL),
(37, 'c.L', NULL),
(38, '4x5cm', NULL),
(39, '', NULL),
(40, 'small in DOP', NULL),
(41, '4cm', NULL);

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

--
-- Table structure for table `tvspelvis`
--

CREATE TABLE IF NOT EXISTS `tvspelvis` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=9 ;

--
-- Dumping data for table `tvspelvis`
--

INSERT INTO `tvspelvis` (`id`, `title`, `del`) VALUES
(1, '--', NULL),
(2, 'free fluid', NULL),
(3, 'mild', NULL),
(4, 'mod', NULL),
(5, 'severe', NULL),
(6, '?? endometriosis', NULL),
(7, 'encysted adhesions mostly vs lt hydrosalpinx 4x7.7 cm', NULL),
(8, 'chronic PID', NULL);

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

--
-- Table structure for table `tvsro`
--

CREATE TABLE IF NOT EXISTS `tvsro` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=44 ;

--
-- Dumping data for table `tvsro`
--

INSERT INTO `tvsro` (`id`, `title`, `del`) VALUES
(1, 'n', NULL),
(2, 'PCO', NULL),
(3, 'Classic PCO', NULL),
(4, 'classic large PCO', NULL),
(5, 'cyst (simple)', NULL),
(6, 'Cyst (hgic)', NULL),
(7, 'Cyst (choclate)', NULL),
(8, 'Cyst (dermoid)', NULL),
(9, 'TOC', NULL),
(10, 'typical', NULL),
(11, 'atypical', NULL),
(12, 'hydrosalpnix', NULL),
(13, 'tO encysted adhesions', NULL),
(14, '', 1),
(15, '', 1),
(16, '', 1),
(17, 'multicystic', NULL),
(18, 'fair', NULL),
(19, '1.2x2 - 2x2.5 - 2.5 cm', NULL),
(20, '2.8x3.6 cm', NULL),
(21, 'surgically removed', NULL),
(22, 'gF 16mm', NULL),
(23, '4.5x6.5cm', NULL),
(24, '4x5cm', NULL),
(25, 'prolapsed in DOP', NULL),
(26, 'mild PCO', NULL),
(27, 'd15 gF 19.5mm', 1),
(28, 'not seen', NULL),
(29, '', NULL),
(30, 'd 11', NULL),
(31, 'mid sized', NULL),
(32, 'hgic cyst 2cm', NULL),
(33, ' 2 Endometriomas (1.5x4cm + 1.2x1.5cm) Prolapsed In DOP ?? Adhesions To Ut', NULL),
(34, 'gf 15mm', NULL),
(35, 'PCO+ Severe Hydrosalpinx 8x3cm', NULL),
(36, 'large Endometrioma 3x4.5 Prolapsed In Dop', NULL),
(37, '3.9x5 cm', NULL),
(38, '1.3cm', NULL),
(39, 'simple cyst 2x3cm', NULL),
(40, 'early', NULL),
(41, '2.5cm', NULL),
(42, 'small collapsed cyst 2x2.5 may be prev cycle', NULL),
(43, 'small in DOP', NULL);

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

--
-- Table structure for table `tvsut`
--

CREATE TABLE IF NOT EXISTS `tvsut` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=63 ;

--
-- Dumping data for table `tvsut`
--

INSERT INTO `tvsut` (`id`, `title`, `del`) VALUES
(1, 'AVF', NULL),
(2, 'RVF I', NULL),
(3, 'RVF II', NULL),
(4, 'RVF III', NULL),
(5, 'Adenomyosis', NULL),
(6, 'Fibroid', NULL),
(7, 'Generalized', NULL),
(8, 'Localized', NULL),
(9, 'S.Muc (0-2)', NULL),
(10, 'I.Mural (3-5)', NULL),
(11, 'S.Seros (6-7)', NULL),
(12, 'Class 0', NULL),
(13, 'Class 1', NULL),
(14, 'Class 2', NULL),
(15, 'Class 3', NULL),
(16, 'Class 4', NULL),
(17, 'Class 5', NULL),
(18, 'Class 6', NULL),
(19, 'Class 7', NULL),
(20, 'ant', NULL),
(21, 'post', NULL),
(22, 'fundal', NULL),
(23, 'high corp', NULL),
(24, 'low corp', NULL),
(25, 'Mid Corp', NULL),
(26, '5 cm', NULL),
(27, 'Intramural', NULL),
(28, 'mild Arcuate Ut', NULL),
(29, 'Thin Endom', NULL),
(30, 'thick endom', NULL),
(31, 'trilam endom', NULL),
(32, 'Niche', NULL),
(33, 'rt lat 3x2.8 cm high corp class 4 near endom 2m ', NULL),
(34, 'ant wall', NULL),
(35, '2.5x3 cm', NULL),
(36, 'bulky', NULL),
(37, 'Arcuate Ut', NULL),
(38, 'Subseptate Ut', NULL),
(39, 'Subseptate Vs Arcuate Ut', NULL),
(40, '200cc', NULL),
(41, 'GS like structure 5w', NULL),
(42, '12mm', NULL),
(43, 'mirena in situ', NULL),
(44, ' no arcuate', NULL),
(45, 'to lt', NULL),
(46, 'to rt', NULL),
(47, 'acute', NULL),
(48, 'iUD in situ', NULL),
(49, 'Endo 13.5mm', NULL),
(50, 'cystic endom', NULL),
(51, 'normal', NULL),
(52, 'RVF II/III', NULL),
(53, '10mm', NULL),
(54, '8mm', NULL),
(55, 'Intracavitory Fibroid( 5x 6.5cm),Bulky 270cc', NULL),
(56, 'RVF I/II', NULL),
(57, 'Anteverted Retroflexed', NULL),
(58, '125cc', NULL),
(59, '185cc', NULL),
(60, 'fibroids', NULL),
(61, '1.5x3cm', NULL),
(62, '240cc', NULL);

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

--
-- Table structure for table `type`
--

CREATE TABLE IF NOT EXISTS `type` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=25 ;

--
-- Dumping data for table `type`
--

INSERT INTO `type` (`id`, `title`, `del`) VALUES
(1, 'Type1', '1'),
(2, 'Type2', '1'),
(3, 'qwqe', '1'),
(4, 'nnnnnnnnnnnnnnnn', '1'),
(5, 'oo', '1'),
(6, 'gggggggggg', '1'),
(7, 'fffffffffff', '1'),
(8, 'dddddddd', '1'),
(9, '1ry', '1'),
(10, 'qw', '1'),
(11, '1ry', '1'),
(12, '1ry', '1'),
(13, '2ry', '1'),
(14, ' male sex selection', '1'),
(15, 'dkldkdfkd', 'kkkk'),
(16, NULL, '1'),
(17, 'NVD', '1'),
(18, 'sex selection', '1'),
(19, '1ry', '1'),
(20, '2ry', '1'),
(21, 'nVD', NULL),
(22, 'cS', NULL),
(23, '2ry + male sex selec', '1'),
(24, '', '1');

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

--
-- Table structure for table `typeinf`
--

CREATE TABLE IF NOT EXISTS `typeinf` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=7 ;

--
-- Dumping data for table `typeinf`
--

INSERT INTO `typeinf` (`id`, `title`, `del`) VALUES
(3, '1ry', NULL),
(4, '2ry', NULL),
(5, 'sex selection', NULL),
(6, '1ry (M2)', NULL);

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

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

CREATE TABLE IF NOT EXISTS `ultrasound` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `patientid` int(11) unsigned DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  `done` int(11) unsigned DEFAULT NULL,
  `edate` date DEFAULT NULL,
  `stype` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `based` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tcondition` int(11) unsigned DEFAULT NULL,
  `babyno` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sid` int(11) unsigned DEFAULT NULL,
  `indication` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gage` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `physician` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `otherbased` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `limit` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `ultrasounddetail`
--

CREATE TABLE IF NOT EXISTS `ultrasounddetail` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `del` int(11) unsigned DEFAULT NULL,
  `ultrasoundid` int(11) unsigned DEFAULT NULL,
  `relationc` int(11) unsigned DEFAULT NULL,
  `appearance` int(11) unsigned DEFAULT NULL,
  `fluid` int(11) unsigned DEFAULT NULL,
  `movement` int(11) unsigned DEFAULT NULL,
  `shape` int(11) unsigned DEFAULT NULL,
  `cavum` int(11) unsigned DEFAULT NULL,
  `falx` int(11) unsigned DEFAULT NULL,
  `thalami` int(11) unsigned DEFAULT NULL,
  `ventricle` int(11) unsigned DEFAULT NULL,
  `cerebellum` int(11) unsigned DEFAULT NULL,
  `magna` int(11) unsigned DEFAULT NULL,
  `u_lip` int(11) unsigned DEFAULT NULL,
  `profile` int(11) unsigned DEFAULT NULL,
  `orbits` int(11) unsigned DEFAULT NULL,
  `nose` int(11) unsigned DEFAULT NULL,
  `nostrils` int(11) unsigned DEFAULT NULL,
  `neck` int(11) unsigned DEFAULT NULL,
  `thoraxshape` int(11) unsigned DEFAULT NULL,
  `mass` int(11) unsigned DEFAULT NULL,
  `heart` int(11) unsigned DEFAULT NULL,
  `heartactivity` int(11) unsigned DEFAULT NULL,
  `hsize` int(11) unsigned DEFAULT NULL,
  `haxix` int(11) unsigned DEFAULT NULL,
  `chamberview` int(11) unsigned DEFAULT NULL,
  `loutflow` int(11) unsigned DEFAULT NULL,
  `routflow` int(11) unsigned DEFAULT NULL,
  `stomach` int(11) unsigned DEFAULT NULL,
  `bowel` int(11) unsigned DEFAULT NULL,
  `kidney` int(11) unsigned DEFAULT NULL,
  `bladder` int(11) unsigned DEFAULT NULL,
  `cordinsertion` int(11) unsigned DEFAULT NULL,
  `cordvessels` int(11) unsigned DEFAULT NULL,
  `spine` int(11) unsigned DEFAULT NULL,
  `rarm` int(11) unsigned DEFAULT NULL,
  `rleg` int(11) unsigned DEFAULT NULL,
  `larm` int(11) unsigned DEFAULT NULL,
  `lleg` int(11) unsigned DEFAULT NULL,
  `gender` double DEFAULT NULL,
  `gendern` int(11) unsigned DEFAULT NULL,
  `conclusion` int(11) unsigned DEFAULT NULL,
  `plans` int(11) unsigned DEFAULT NULL,
  `position` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `diameterm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `diameterp` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `headcm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `headcp` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `abdominalm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `abdominalp` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lengthm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lengthp` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `otherm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `otherp` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `othernormal` text COLLATE utf8mb4_unicode_ci,
  `finding` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `weeks` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `referred` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `oplans` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cover` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `abconclusion` tinyint(1) unsigned DEFAULT NULL,
  `pconclusion` tinyint(1) unsigned DEFAULT NULL,
  `inconclusion` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `ultrasoundgyna`
--

CREATE TABLE IF NOT EXISTS `ultrasoundgyna` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `patientid` int(11) unsigned DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  `done` int(11) unsigned DEFAULT NULL,
  `edate` date DEFAULT NULL,
  `etype` int(11) unsigned DEFAULT NULL,
  `sid` int(11) unsigned DEFAULT NULL,
  `tcondition` int(11) unsigned DEFAULT NULL,
  `position` int(11) unsigned DEFAULT NULL,
  `tz` int(11) unsigned DEFAULT NULL,
  `myo` int(11) unsigned DEFAULT NULL,
  `myowall` int(11) unsigned DEFAULT NULL,
  `douglas` int(11) unsigned DEFAULT NULL,
  `rtsize` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `conclusion` int(11) unsigned DEFAULT NULL,
  `physician` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `indication` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `measurments` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `thickness` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `flesion` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rtshape` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rtfolicles` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ltfolicles` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ltshape` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ltsize` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pmass` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lymph` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rtarteries` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ltarteries` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `score` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subspace` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `anymass` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `normalcon` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `limit` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `describ` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `abnormalcon` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `ultrasoundobst`
--

CREATE TABLE IF NOT EXISTS `ultrasoundobst` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `patientid` int(11) unsigned DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  `done` int(11) unsigned DEFAULT NULL,
  `edate` date DEFAULT NULL,
  `stype` int(11) unsigned DEFAULT NULL,
  `sid` int(11) unsigned DEFAULT NULL,
  `tcondition` int(11) unsigned DEFAULT NULL,
  `babyno` double DEFAULT NULL,
  `physician` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `limit` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `indication` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `ultrasoundobstdetail`
--

CREATE TABLE IF NOT EXISTS `ultrasoundobstdetail` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `del` int(11) unsigned DEFAULT NULL,
  `ultrasoundobstid` int(11) unsigned DEFAULT NULL,
  `appearance` int(11) unsigned DEFAULT NULL,
  `shape` int(11) unsigned DEFAULT NULL,
  `cranial` int(11) unsigned DEFAULT NULL,
  `falx` int(11) unsigned DEFAULT NULL,
  `choroid` int(11) unsigned DEFAULT NULL,
  `profile` int(11) unsigned DEFAULT NULL,
  `orbits` int(11) unsigned DEFAULT NULL,
  `neck` int(11) unsigned DEFAULT NULL,
  `pulm` int(11) unsigned DEFAULT NULL,
  `diaphragm` int(11) unsigned DEFAULT NULL,
  `heart` int(11) unsigned DEFAULT NULL,
  `heartactivity` int(11) unsigned DEFAULT NULL,
  `hsize` int(11) unsigned DEFAULT NULL,
  `haxix` int(11) unsigned DEFAULT NULL,
  `chamberview` int(11) unsigned DEFAULT NULL,
  `stomach` int(11) unsigned DEFAULT NULL,
  `bowel` int(11) unsigned DEFAULT NULL,
  `kidney` int(11) unsigned DEFAULT NULL,
  `bladder` int(11) unsigned DEFAULT NULL,
  `cordinsertion` int(11) unsigned DEFAULT NULL,
  `cordvessels` int(11) unsigned DEFAULT NULL,
  `spine` int(11) unsigned DEFAULT NULL,
  `rarm` int(11) unsigned DEFAULT NULL,
  `rleg` int(11) unsigned DEFAULT NULL,
  `larm` int(11) unsigned DEFAULT NULL,
  `lleg` int(11) unsigned DEFAULT NULL,
  `gender` double DEFAULT NULL,
  `gendern` int(11) unsigned DEFAULT NULL,
  `conclusion` int(11) unsigned DEFAULT NULL,
  `plans` int(11) unsigned DEFAULT NULL,
  `anomaly` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `crownm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `crownmc` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nuchalm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nuchalc` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `diameterm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `diameterc` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `headcm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `headcc` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `abdominalm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `abdominalc` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `flengthm` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `flengthc` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `finding` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gaestimatew` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gaestimated` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `othernormal` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `oplans` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `weeks` double DEFAULT NULL,
  `referred` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pconclusion` tinyint(1) unsigned DEFAULT NULL,
  `inconclusion` tinyint(1) unsigned DEFAULT NULL,
  `abconclusion` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `usaf`
--

CREATE TABLE IF NOT EXISTS `usaf` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=8 ;

--
-- Dumping data for table `usaf`
--

INSERT INTO `usaf` (`id`, `title`, `del`) VALUES
(1, 'تالعا', 1),
(2, 'n', NULL),
(3, 'Oligo', NULL),
(4, 'Mild high', NULL),
(5, '2nd polyhydr', NULL),
(6, 'increase', NULL),
(7, 'mild polyhydramnios', NULL);

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

--
-- Table structure for table `usn`
--

CREATE TABLE IF NOT EXISTS `usn` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=5 ;

--
-- Dumping data for table `usn`
--

INSERT INTO `usn` (`id`, `title`, `del`) VALUES
(1, 'single', NULL),
(2, 'DCT', NULL),
(3, 'MCT', NULL),
(4, 'DCT-1viable', NULL);

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

--
-- Table structure for table `usplace`
--

CREATE TABLE IF NOT EXISTS `usplace` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=27 ;

--
-- Dumping data for table `usplace`
--

INSERT INTO `usplace` (`id`, `title`, `del`) VALUES
(1, 'Ant ', NULL),
(2, 'ant low', NULL),
(3, 'Post High', NULL),
(4, 'Post high Rt Lat', NULL),
(5, '', NULL),
(6, NULL, NULL),
(7, '', NULL),
(8, 'fundal ant to lt', NULL),
(9, 'Post high to the rt + multiple pl lacunae', NULL),
(10, NULL, NULL),
(11, 'post ', NULL),
(12, NULL, NULL),
(13, '1st ant - 2nd post high', NULL),
(14, 'ant fundal ', NULL),
(15, NULL, NULL),
(16, 'ant low complete centralis', NULL),
(17, 'post low to lt', NULL),
(18, 'pl pr comp centralis to rt ', NULL),
(19, 'post fundal', NULL),
(20, NULL, NULL),
(21, NULL, NULL),
(22, 'ant high', NULL),
(23, 'ant high', NULL),
(24, 'ant to lt ', NULL),
(25, 'ant low to lt', NULL),
(26, 'ant low to lt not PP', NULL);

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

--
-- Table structure for table `ustv`
--

CREATE TABLE IF NOT EXISTS `ustv` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `sdate` date DEFAULT NULL,
  `patientid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  `uterus` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `radnexa` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ladnexa` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pelvis` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `doctorid` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `visits`
--

CREATE TABLE IF NOT EXISTS `visits` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patientid` int(11) NOT NULL,
  `visitdate` date NOT NULL,
  `visittime` time DEFAULT NULL,
  `detectionid` int(11) NOT NULL,
  `totaldetectionvalue` decimal(10,0) DEFAULT '0',
  `discount` decimal(10,0) DEFAULT '0',
  `detectionvalue_cash` decimal(10,0) DEFAULT '0',
  `detectionvalue_visa` decimal(10,0) DEFAULT '0',
  `restdetectionvalue` decimal(10,0) DEFAULT '0',
  `visitorder` int(11) NOT NULL,
  `enterordered` int(11) NOT NULL,
  `view` tinyint(1) NOT NULL DEFAULT '0',
  `deleted` int(11) DEFAULT '0',
  `end` int(11) DEFAULT '0',
  `enddate` date DEFAULT NULL,
  `reason` text COLLATE utf8mb4_unicode_ci,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `enddoctorid` int(11) DEFAULT NULL,
  `mobileappvisit` int(11) unsigned DEFAULT NULL,
  `payedflag` int(11) unsigned DEFAULT NULL,
  `visit_period` int(11) DEFAULT '0',
  `user_id` int(11) DEFAULT '0',
  `urgent` int(11) DEFAULT '0',
  `createdate` datetime DEFAULT NULL,
  `visitid` int(11) DEFAULT '0',
  `patient_edit` int(11) DEFAULT '0',
  `approx_time` time DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `visit_periods`
--

CREATE TABLE IF NOT EXISTS `visit_periods` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `timing` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `max_no` int(11) DEFAULT '0',
  `deleted` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `visit_periods`
--

INSERT INTO `visit_periods` (`id`, `name`, `timing`, `max_no`, `deleted`) VALUES
(1, 'الÙترة الأولى', 'من 1:00 إلى 2:00', 8, 0),
(2, 'الÙترة الثانية', 'من 2:00 إلى 3:00', 8, 0),
(3, 'الÙترة الثالثة', 'من 3:00 إلى 4:00', 8, 0),
(4, 'الÙترة الرابعة', 'من 4:00 إلى 5:00', 8, 0),
(5, 'الÙترة الخامسة', 'من 5:00 إلى 6:00', 8, 0);

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

--
-- Table structure for table `wifeepc`
--

CREATE TABLE IF NOT EXISTS `wifeepc` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `infertilitysheetid` int(11) unsigned DEFAULT NULL,
  `wifeepcttt` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wifeepcobst` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wifeepctype` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wifeepcw` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `histopath` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wifeepcp` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wifeepcepc` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `coast` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wifeepcdate` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `wifeepcobst`
--

CREATE TABLE IF NOT EXISTS `wifeepcobst` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=34 ;

--
-- Dumping data for table `wifeepcobst`
--

INSERT INTO `wifeepcobst` (`id`, `title`, `del`) VALUES
(1, 'rtyrt', NULL),
(2, 'د.علي المصري', NULL),
(3, 'د.هاله هدايه- العام', NULL),
(4, 'د.معتز شبكه', NULL),
(5, 'د. الشربيني', NULL),
(6, 'د.حاÙظ جويلي', NULL),
(7, 'د.محمد عبدالله', NULL),
(8, 's.arabia', NULL),
(9, 'د.محمد شلبي', NULL),
(10, 'د.محمد شحم', NULL),
(11, 'د.صاÙيناز', NULL),
(12, 'السعوديه', NULL),
(13, 'د. اشرÙ مطر', NULL),
(14, 'د.تامر عيسي', NULL),
(15, 'م. التخصصي', NULL),
(16, 'د.عماد مريل- الصÙا', NULL),
(17, 'د.ابراهيم الدالي', NULL),
(18, 'د.ايمان الصردي', NULL),
(19, 'د.عامر شتا', NULL),
(20, 'd/amr -royal cen', NULL),
(21, 'د.عمرو عديل', NULL),
(22, 'د.اشرÙ رجب', NULL),
(23, NULL, NULL),
(24, 'د.محمد الشيطي', NULL),
(25, 'د.محمد الشحات -الزرقا', NULL),
(26, 'د.محمد سمير', NULL),
(27, 'د.عديل م.Ùيروز', NULL),
(28, 'د.عديل م.ملكي', NULL),
(29, 'د.نبيل زكي', NULL),
(30, 'د.محمد داود', NULL),
(31, 'د.صÙاء أبو النصر', NULL),
(32, 'د.محمد زايد-الازهر', NULL),
(33, 'د.عمرو-التخصصي', NULL);

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

--
-- Table structure for table `wifeepcttt`
--

CREATE TABLE IF NOT EXISTS `wifeepcttt` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=12 ;

--
-- Dumping data for table `wifeepcttt`
--

INSERT INTO `wifeepcttt` (`id`, `title`, `del`) VALUES
(1, 'conservative', NULL),
(2, 'medical (miso)', NULL),
(3, 'Medical (MTX)', NULL),
(4, 'D&C', NULL),
(5, 'laparoscopy otomy', NULL),
(6, 'Laparoscopy ectomy', NULL),
(7, 'Laparotomy Otomy', NULL),
(8, 'Laparotomy ectomy', NULL),
(9, NULL, 1),
(10, NULL, 1),
(11, 'medical+ d&c', NULL);

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

--
-- Table structure for table `wifeepctype`
--

CREATE TABLE IF NOT EXISTS `wifeepctype` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=8 ;

--
-- Dumping data for table `wifeepctype`
--

INSERT INTO `wifeepctype` (`id`, `title`, `del`) VALUES
(1, 'EPL', NULL),
(2, 'A T1', NULL),
(3, 'A T2', NULL),
(4, 'C VM', NULL),
(5, 'P VM', NULL),
(6, 'EP', NULL),
(7, NULL, 1);

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

--
-- Table structure for table `wifejobs`
--

CREATE TABLE IF NOT EXISTS `wifejobs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(55) NOT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT AUTO_INCREMENT=52 ;

--
-- Dumping data for table `wifejobs`
--

INSERT INTO `wifejobs` (`id`, `title`, `del`) VALUES
(1, 'ربة منزل', NULL),
(2, 'لاتعمل', NULL),
(3, 'موظÙة', NULL),
(4, 'دكتوره بطرية', NULL),
(5, 'مدرسة', NULL),
(6, 'طالبة', NULL),
(7, 'أخصاية اجتماعية ', NULL),
(8, 'موجه معامل', NULL),
(9, 'سكرتيرة دكتور اسنان', NULL),
(10, 'مساعدة طبيب أسنان', NULL),
(11, 'مدرسة لغة إنجليزية', NULL),
(12, 'مهندسة ديكور', NULL),
(13, 'Ùنى تخدير', NULL),
(14, 'شؤن طلاب ', NULL),
(15, 'دكتورة أطÙال', NULL),
(16, 'دكتورة بيطربية', NULL),
(17, 'صيدلنية', NULL),
(18, 'موظÙة Ùي معهد الاورام ', NULL),
(19, 'محكمة', NULL),
(20, 'موظÙة Ùي مستشÙى رأس البر ', NULL),
(21, 'مديرة مدرسة اللغات', NULL),
(22, 'موظÙة Ùي الوحدة المحلية', NULL),
(23, 'مدربة جيم', NULL),
(24, 'مركز رحمة', NULL),
(25, 'استاذ دكتور', NULL),
(26, 'استاذ دكتور نظم معلومات', 0),
(27, 'موظÙه Ùى مجلس المدينة', NULL),
(28, 'معمل المشترك', NULL),
(29, 'معمل المشترك', NULL),
(30, 'معمل المشترك', NULL),
(31, 'محامية', NULL),
(32, 'أخصائية تمريض', NULL),
(33, 'ممرضة Ùي معهد الاورام', NULL),
(34, 'Ùنية تمريض Ùي معهد الاورام', NULL),
(35, 'موظÙه Ùي صيدلية', NULL),
(36, 'Ùنيه تمريض', NULL),
(37, 'مدرسة لغة عربية', NULL),
(38, 'Ùي محل ملابس', NULL),
(39, 'مدرس مساعدجامعة دمياط ', NULL),
(40, 'سكرتيرة Ùي مكتب محاسب', NULL),
(41, 'مدرسة  موسيقى', NULL),
(42, 'محاسبة', NULL),
(43, 'محاسبه', NULL),
(44, 'مهندسة زراعية', NULL),
(45, 'اخصائى تحليل', NULL),
(46, 'مدير مالى Ùى السباحة ', NULL),
(47, 'معيدة Ùي كلية تربية نوعية', NULL),
(48, 'طبيب صيدلي', 0),
(49, 'محل بقالة', NULL),
(50, 'شركة الغزل والنسيج', NULL),
(51, 'شغل مصنع الغزال والنسيج', NULL);

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

--
-- Table structure for table `wifemodeofd`
--

CREATE TABLE IF NOT EXISTS `wifemodeofd` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `wifemodeofd`
--

INSERT INTO `wifemodeofd` (`id`, `title`, `del`) VALUES
(1, 'CS', NULL),
(2, 'sVD', NULL),
(3, 'nVD', NULL);

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

--
-- Table structure for table `wifeobst`
--

CREATE TABLE IF NOT EXISTS `wifeobst` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=69 ;

--
-- Dumping data for table `wifeobst`
--

INSERT INTO `wifeobst` (`id`, `title`, `del`) VALUES
(1, 'د أشرÙ رجب', NULL),
(2, 'د. سحر السحراوي', NULL),
(3, 'د.علي المصري', NULL),
(4, 'المركز الملكي', NULL),
(5, 'د.ابتسام الÙقي', NULL),
(6, 'د.حسام شحم', NULL),
(7, 'د.رامي ماهر-التخصصي', NULL),
(8, 'م. التخصصي', NULL),
(9, 'د. اسامه مهنا-التخصصي', NULL),
(10, 'د.صÙاء ابو النصر', NULL),
(11, 'د.اسامه ورده', NULL),
(12, 'د.جمال ورده', NULL),
(13, ' cNC د.عمرو عديل', NULL),
(14, 'م.التخصصي', NULL),
(15, 'انجلترا', NULL),
(16, 'د.علاء الارشل', NULL),
(17, 'د.اسماعيل الحÙناوي', NULL),
(18, 'د.معتز شبكه', NULL),
(19, 'د.عمرو عديل المركز الملكي', NULL),
(20, 'د.ايمان الصردي', NULL),
(21, 'د.محمد العراقي', NULL),
(22, 'د.سهير شلبي', NULL),
(23, 'د.السعيد حموده', NULL),
(24, 'السعوديه', NULL),
(25, 'د.سعد الصايغ', NULL),
(26, 'الكويت', NULL),
(27, 'د.محمد الضبع', NULL),
(28, 'د.محمد الضبع', 1),
(29, 'د.محمد الضبع', 1),
(30, 'د.محمد الضبع', 1),
(31, 'د.عمرو عديل-الÙيروز', NULL),
(32, ']', 1),
(33, 'د.يوسÙ جمال- م.Ùارسكور', NULL),
(34, 'د.شريÙ عبد العزيز م. Ùارسكور', NULL),
(35, 'د.شريÙ عبد العزيز م.Ùارسكور', 1),
(36, 'د.ايمن رجب', NULL),
(37, 'د.محمد مطاوع', NULL),
(38, 'د.عادل السعيد', NULL),
(39, 'م.الصÙا', NULL),
(40, 'د.شريÙ عبد العزيز-م.Ùارسكور', NULL),
(41, 'د.ابراهيم جمال', NULL),
(42, 'د.ابرا', 1),
(43, 'د.سيد عبد الرحمن الحامول', NULL),
(44, 'د.محمد شحم', NULL),
(45, 'د.محمود زقزوق-Ùارسكور', NULL),
(46, 'د.عمرو عديل- م. المصري', NULL),
(47, 'د.عمرو -م.الصÙا', NULL),
(48, 'د اشرÙ مطر', NULL),
(49, 'د.ساميه عيد', NULL),
(50, 'د.سلوي عنتر', NULL),
(51, 'م. العام', NULL),
(52, 'د.ايمان عبد الرؤوÙ', NULL),
(53, 'د.احمد عيسي', NULL),
(54, '', NULL),
(55, 'د.سحر السحراوي', NULL),
(56, '', NULL),
(57, 'د.رضا أجا', NULL),
(58, 'د.السعيد الشحات', NULL),
(59, 'د.عاصم الشوبكي', NULL),
(60, 'د.مأمون أبو حسن', NULL),
(61, 'د.هيسام جوهر', NULL),
(62, 'د.خالد أبو دنيا', NULL),
(63, 'د.محمد دسوقي', NULL),
(64, ' د.حمدي عبد المنعم', NULL),
(65, 'م. الأزهر', NULL),
(66, 'د.هاله هدايه', NULL),
(67, 'د.عمرو-التخصصي', NULL),
(68, 'د.أحمد العبد', NULL);

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

--
-- Table structure for table `wifep`
--

CREATE TABLE IF NOT EXISTS `wifep` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `infertilitysheetid` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wifemodeofd` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wifeobst` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wifesex` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wifepmethod` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wifetypeofd` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `duration` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `wifel` tinyint(1) unsigned DEFAULT NULL,
  `awifepmethod` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `wifepmethod`
--

CREATE TABLE IF NOT EXISTS `wifepmethod` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=15 ;

--
-- Dumping data for table `wifepmethod`
--

INSERT INTO `wifepmethod` (`id`, `title`, `del`) VALUES
(1, 'POP', NULL),
(2, 'COC', NULL),
(3, 'IUD', NULL),
(4, 'Mirena', NULL),
(5, 'Implant', NULL),
(6, 'DMPA', NULL),
(7, 'nuvaRing', NULL),
(8, 'Condom', NULL),
(9, 't. ligation', NULL),
(10, '', 1),
(11, '', 1),
(12, '', 1),
(13, '', 1),
(14, 'no', NULL);

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

--
-- Table structure for table `wifesex`
--

CREATE TABLE IF NOT EXISTS `wifesex` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `wifesex`
--

INSERT INTO `wifesex` (`id`, `title`, `del`) VALUES
(1, 'm', NULL),
(2, 'f', NULL);

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

--
-- Table structure for table `wifestatus`
--

CREATE TABLE IF NOT EXISTS `wifestatus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(55) NOT NULL,
  `del` int(11) unsigned DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT AUTO_INCREMENT=10 ;

--
-- Dumping data for table `wifestatus`
--

INSERT INTO `wifestatus` (`id`, `title`, `del`) VALUES
(1, 'انسة', 0),
(2, 'متزوجة', 0),
(3, 'مطلقة', 0),
(8, 'متزجه للمره الثانيه', 0),
(9, 'ارمله ', 0);

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

--
-- Table structure for table `wifetypeofd`
--

CREATE TABLE IF NOT EXISTS `wifetypeofd` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `del` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `wifetypeofd`
--

INSERT INTO `wifetypeofd` (`id`, `title`, `del`) VALUES
(1, 'FT', NULL),
(2, 'PT', NULL);

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

--
-- Table structure for table `wifetypes`
--

CREATE TABLE IF NOT EXISTS `wifetypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(55) NOT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT AUTO_INCREMENT=3 ;

--
-- Dumping data for table `wifetypes`
--

INSERT INTO `wifetypes` (`id`, `title`, `del`) VALUES
(1, 'مدام', NULL),
(2, 'آنسة', NULL);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `awcontrollprop`
--
ALTER TABLE `awcontrollprop`
  ADD CONSTRAINT `c_fk_awcontrollprop_awcontroll_id` FOREIGN KEY (`awcontroll_id`) REFERENCES `awcontroll` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;

--
-- Constraints for table `awrolecontrollprop`
--
ALTER TABLE `awrolecontrollprop`
  ADD CONSTRAINT `c_fk_awrolecontrollprop_controllprop_id` FOREIGN KEY (`controllprop_id`) REFERENCES `awcontrollprop` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
  ADD CONSTRAINT `c_fk_awrolecontrollprop_role_id` FOREIGN KEY (`role_id`) REFERENCES `awrole` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;

--
-- Constraints for table `awrolemenu`
--
ALTER TABLE `awrolemenu`
  ADD CONSTRAINT `c_fk_awrolemenu_menu_id` FOREIGN KEY (`menu_id`) REFERENCES `awmenu` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
  ADD CONSTRAINT `c_fk_awrolemenu_role_id` FOREIGN KEY (`role_id`) REFERENCES `awrole` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;

