-- Table structure for table `dtvs`
--

CREATE TABLE `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;

--
-- Dumping data for table `dtvs`
--


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

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

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

INSERT INTO `education` 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 `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;

--
-- Dumping data for table `endvisitreports`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `eprep`
--


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

CREATE TABLE `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;

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


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

CREATE TABLE `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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `examination`
--

INSERT INTO `examination` VALUES (1,'2',2,'2024-10-27','2024-10-27','','','','','',NULL,'','','','','',0,NULL);

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

CREATE TABLE `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;

--
-- Dumping data for table `examinationabdomen`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `examinationchest`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `examinationextremitis`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `examinationhead`
--


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

--
-- Dumping data for table `examinationpelvis`
--


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

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

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

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

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

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

--
-- Dumping data for table `excelinfopatients`
--

INSERT INTO `excelinfopatients` VALUES (1,2,2);

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

CREATE TABLE `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;

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


--
-- Table structure for table `floors`
--

CREATE TABLE `floors` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `deleted` int(11) DEFAULT '0',
  `default_value` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `floors`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `folliculom`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `followup`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `followupcard`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `followupcarddrugs`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `followupdiagnosis`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `followupexam`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `followupinvest`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `followupvisit`
--


--
-- Table structure for table `four_d`
--

CREATE TABLE `four_d` (
  `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;

--
-- Dumping data for table `four_d`
--


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

--
-- Dumping data for table `gtdetail`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `gtimage`
--


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

CREATE TABLE `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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `gyna`
--

INSERT INTO `gyna` VALUES (1,2,'2024-10-27','','','h gjhg jh h j ghg jhgjhg jhg ',0,2,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

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

CREATE TABLE `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 AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `gynadrugs`
--

INSERT INTO `gynadrugs` VALUES (1,2,'2024-10-27','9','Tab','قرص  يوميا   بانتظام',0,2,'Activelle',0,0,0),(2,2,'2024-10-27','22','Amp','حقنة عضل  صباحاً  ومساء',0,2,'Adwiflam',0,0,0),(3,2,'2024-10-27','56','Tab','  قرص قبل الغذاء ثم  قرص بعد الغذاءجرعه واحده  للزوجين',0,2,'Amebazole',0,0,0),(4,2,'2024-10-27','3','Tab','قرص بعد الأكل عند اللزوم',0,2,'Abimol',0,0,0),(5,2,'2024-10-27','','','',0,2,NULL,0,0,0);

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

CREATE TABLE `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;

--
-- Dumping data for table `gynainfertility`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `gynainfertilityplan`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `gynainfertilitytype`
--


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

CREATE TABLE `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 AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `gynainvestigation`
--

INSERT INTO `gynainvestigation` VALUES (1,2,'2024-10-27',79,'12',0,2,0),(2,2,'2024-10-27',80,'12',0,2,0),(3,2,'2024-10-27',81,'10',0,2,0);

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

CREATE TABLE `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;

--
-- Dumping data for table `gynasheet`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `gynasheetdrugs`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `gynasheetinvest`
--


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

CREATE TABLE `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';

--
-- Dumping data for table `gynaus`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `gynausficils`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `help`
--


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

--
-- Dumping data for table `hormon`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `hormonalprofile`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `hormonalprofile2`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `hospitalnames`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `hsg`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `hsginfertility`
--


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

--
-- Dumping data for table `hus_previous_marriage`
--


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

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

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

INSERT INTO `husbandjobs` 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 `husbandtypes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL,
  `del` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

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

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

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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

--
-- Dumping data for table `hysteroscopy`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `hysteroscopyinfertility`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `icsi`
--


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

--
-- Dumping data for table `importbill`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `importdetails`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `importtdetails`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `infertility`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `infertilitydiagnosis`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `infertilitydrugs`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `infertilitygyna`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `infertilityinvest`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `infertilitylmp`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `infertilitynotes`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `infertilitysheet`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `infertilitysheetdrugs`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `infertilitysheetinvest`
--


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

CREATE TABLE `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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `instruction`
--

INSERT INTO `instruction` VALUES (1,1,'تعليمات الوقاية من التهاب الاذن الوسطى','<p>تعليمات الوقاية من التهاب الاذن الوسطى</p>\r\n\r\n<p>تعليمات الوقاية من التهاب الاذن الوسطى</p>\r\n\r\n<p>تعليمات الوقاية من التهاب الاذن الوسطى</p>\r\n\r\n<p>تعليمات الوقاية من التهاب الاذن الوسطى</p>\r\n\r\n<p>تعليمات الوقاية من التهاب الاذن الوسطى</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n','0');

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

CREATE TABLE `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 AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT COMMENT='cats for invests appear in gyna and antenatal ';

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

INSERT INTO `investcats` 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 `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,
  `invesdogtt2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `investigations`
--


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

CREATE TABLE `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 AUTO_INCREMENT=277 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT COMMENT=' invests appear in gyna and antenatal ';

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

INSERT INTO `invests` 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 `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,
  `pla2cen` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sheetyear` int(11) unsigned DEFAULT NULL,
  `sheetmonth` int(11) unsigned DEFAULT NULL,
  `bmi` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ivfsheet`
--


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

CREATE TABLE `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 AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

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

INSERT INTO `jncision` 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 `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

--
-- Dumping data for table `laparoscopy`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `laparoscopyinfertility`
--


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lastvisit`
--

INSERT INTO `lastvisit` VALUES (1,2,'gyna');

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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


--
-- Table structure for table `locations`
--

CREATE TABLE `locations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `deleted` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `locations`
--


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

CREATE TABLE `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,
  `sex` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `mainantenental`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `mainantenentaldrugs`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `mainantenentalinvest`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `mainantenentalus`
--


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

CREATE TABLE `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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `maingyna`
--

INSERT INTO `maingyna` VALUES (1,2,'2024-10-27 10:10:20','',NULL);

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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `message` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sender_id` int(11) unsigned DEFAULT NULL,
  `receiver_id` int(11) unsigned DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `index_foreignkey_messages_sender` (`sender_id`),
  KEY `index_foreignkey_messages_receiver` (`receiver_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `messages`
--


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

CREATE TABLE `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 AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

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

INSERT INTO `midlinejncision` 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 `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;

--
-- Dumping data for table `mointoringsheet`
--


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

CREATE TABLE `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;

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


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

CREATE TABLE `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',
  `mointoringsheetid` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `mointoringsheetdrugs`
--


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

--
-- Dumping data for table `mointoringsheethcg`
--


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

CREATE TABLE `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;

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


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

CREATE TABLE `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,
  `mointoringsheetid` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `mointoringsheetinvestigation`
--


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

--
-- Dumping data for table `mointoringsheetvisits`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `mrict`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `newvisit`
--


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

CREATE TABLE `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;

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


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

CREATE TABLE `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` text COLLATE utf8mb4_unicode_ci,
  `usvsdtv` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `newvisitg`
--


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

--
-- Dumping data for table `old_visits`
--


--
-- Table structure for table `op_4d_list`
--

CREATE TABLE `op_4d_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `patientid` int(11) DEFAULT '0',
  `ancsheetid` int(11) DEFAULT '0',
  `opdate` date DEFAULT NULL,
  `four_d` 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,
  `t1` int(11) DEFAULT '0',
  `t11` int(11) DEFAULT '0',
  `t12` int(11) DEFAULT '0',
  `t2` int(11) DEFAULT '0',
  `t21` int(11) DEFAULT '0',
  `t22` int(11) DEFAULT '0',
  `done` int(11) DEFAULT '0',
  `confirm` int(11) DEFAULT '0',
  `t1_userid` int(11) DEFAULT '0',
  `t2_userid` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `op_4d_list`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `op_wait_list`
--


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

CREATE TABLE `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 AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

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

INSERT INTO `operation` 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 `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;

--
-- Dumping data for table `operationids`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `operations`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `operativedetails`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `operativedetailsdrugs`
--


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

--
-- Dumping data for table `otherinvestigations`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `otherinvestigationsrows`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `otherinvestigationsvalues`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `ovst`
--


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

--
-- Dumping data for table `patientfiles`
--


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

CREATE TABLE `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,
  `gender` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `createdate` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `statusno` (`statusno`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `patients`
--

INSERT INTO `patients` VALUES (1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'0000-00-00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0,'','','','',0,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'هدى محمد احمد',1,'1994-01-01',NULL,30,'20','38','',0,'2024-10-27',NULL,NULL,2,NULL,NULL,NULL,'1969-12-31',NULL,NULL,NULL,NULL,'دمياط','01045405450','02154','ملاحظات هامة','',NULL,'',2,1,'','','','',0,'2024-10-27 20:05:09',2,NULL,NULL,'$2y$10$l8NQmAjMOvqXOg7UYBxsDe9IqGy4kqi3H0/t8UU7sZfNz3FxIIKjC',NULL,NULL,NULL,NULL,NULL,'1','2024-10-27 10:05:09');

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

CREATE TABLE `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;

--
-- Dumping data for table `patients_tmp`
--


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

CREATE TABLE `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` 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,
  `userid_edit` int(11) DEFAULT '0',
  `date_edit` datetime DEFAULT NULL,
  `patientid_edit` int(11) DEFAULT '0',
  `gender` tinyint(1) unsigned DEFAULT NULL,
  `createdate` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `statusno` (`statusno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `patients_updates`
--


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

--
-- Dumping data for table `pharmacystore`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `phcontraception`
--


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `phfamily`
--

INSERT INTO `phfamily` VALUES (1,'2',2,'2024-10-27','1','1','',0);

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

CREATE TABLE `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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `phfamilydisease`
--

INSERT INTO `phfamilydisease` VALUES (1,'hyper',0);

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

CREATE TABLE `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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `phfamilyrelative`
--

INSERT INTO `phfamilyrelative` VALUES (1,'mother',0);

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

CREATE TABLE `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;

--
-- Dumping data for table `phmenstrual`
--


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

--
-- Dumping data for table `phobstericterplace`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `phobstetric`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `phpastart`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `phpastartcenter`
--


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

--
-- Dumping data for table `phpastgynecological`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `phpastgynecologicaloperation`
--


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

CREATE TABLE `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,
  `frozen` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bhcg` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fhr` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phpasticsi`
--


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

CREATE TABLE `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,
  `for_husband` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `phpastmedical`
--

INSERT INTO `phpastmedical` VALUES (1,'2','2024-10-27','1','',0,2,0);

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

CREATE TABLE `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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `phpastmedicaldisease`
--

INSERT INTO `phpastmedicaldisease` VALUES (1,'hyper',0);

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

CREATE TABLE `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,
  `for_husband` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `phpastsurgical`
--

INSERT INTO `phpastsurgical` VALUES (1,2,2,'2024-10-27','1','2021','','',0,0);

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

CREATE TABLE `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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `phpastsurgicaloperation`
--

INSERT INTO `phpastsurgicaloperation` VALUES (1,'fffff',0);

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

CREATE TABLE `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;

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


--
-- Table structure for table `pla2cen`
--

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

--
-- Dumping data for table `pla2cen`
--


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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 ';

--
-- Dumping data for table `presenthistoryanswers`
--


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

CREATE TABLE `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 ';

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


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

CREATE TABLE `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;

--
-- Dumping data for table `previous_marriage`
--


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

CREATE TABLE `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',
  `barcode_print` int(11) DEFAULT '0',
  `serial_month` varchar(191) DEFAULT NULL,
  `last_serial` int(11) unsigned DEFAULT '0',
  `last_refund_serial` int(11) unsigned DEFAULT '0',
  `branches` int(11) DEFAULT '0',
  `printserial` int(11) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

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

INSERT INTO `programesetting` VALUES (1,'','','','','','429e9f43800a60bec13d37452e5a0287.jpg',NULL,5.6,1.5,NULL,NULL,NULL,NULL,NULL,24,24,'0','1','0',5,1,0,NULL,0,1,1,1,0,'3dc7359216f58b9f75ea75c50d240a80.jpg',NULL,'',0,'','','',0,0,0,0,0,0,0,NULL,NULL,NULL,1,NULL,NULL,NULL,1,1,1,1,NULL,NULL,NULL,NULL,NULL,'20',0,0,NULL,'E:\\Wamp\\Bin\\php\\php5.5.12',NULL,1,NULL,NULL,0,'2024-10',1,1,NULL,NULL);

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

CREATE TABLE `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;

--
-- Dumping data for table `receiptdrugs`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `recepittmp`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `records`
--


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

CREATE TABLE `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,
  `rplace` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `registeration`
--


--
-- Table structure for table `screen_slider`
--

CREATE TABLE `screen_slider` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `screen_slider`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `semen`
--


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

CREATE TABLE `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;

--
-- Dumping data for table `semen2`
--


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

--
-- Dumping data for table `semeninfertility`
--


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

--
-- Dumping data for table `sis`
--


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

CREATE TABLE `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 AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `sonar`
--

INSERT INTO `sonar` VALUES (1,2,'2024-10-27','7db4d74eeeb59b0e016645e4064f3e00.png','nb nnb m m',NULL,'0',0,NULL),(2,2,'2024-10-27','e872ca51d68e5c289a47e30384e1ed40.png',' m bnmnb',NULL,'0',0,NULL);

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

CREATE TABLE `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;

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


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

CREATE TABLE `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;

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


--
-- Table structure for table `sseemmen`
--

CREATE TABLE `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;

--
-- Dumping data for table `sseemmen`
--


--
-- Table structure for table `ssemen`
--

CREATE TABLE `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;

--
-- Dumping data for table `ssemen`
--


--
-- Table structure for table `surgicalhistory`
--

CREATE TABLE `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;

--
-- Dumping data for table `surgicalhistory`
--


--
-- Table structure for table `surgicalhistorydm`
--

CREATE TABLE `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;

--
-- Dumping data for table `surgicalhistorydm`
--


--
-- Table structure for table `table2`
--

CREATE TABLE `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;

--
-- Dumping data for table `table2`
--


--
-- Table structure for table `table3`
--

CREATE TABLE `table3` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `table3`
--


--
-- Table structure for table `tablename`
--

CREATE TABLE `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;

--
-- Dumping data for table `tablename`
--


--
-- Table structure for table `testtbl1`
--

CREATE TABLE `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;

--
-- Dumping data for table `testtbl1`
--


--
-- Table structure for table `testtbl2`
--

CREATE TABLE `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;

--
-- Dumping data for table `testtbl2`
--


--
-- Table structure for table `totalbalance`
--

CREATE TABLE `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;

--
-- Dumping data for table `totalbalance`
--


--
-- Table structure for table `totalbalancepaids`
--

CREATE TABLE `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;

--
-- Dumping data for table `totalbalancepaids`
--


--
-- Table structure for table `tttda`
--

CREATE TABLE `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;

--
-- Dumping data for table `tttda`
--


--
-- Table structure for table `tttmetformin`
--

CREATE TABLE `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;

--
-- Dumping data for table `tttmetformin`
--


--
-- Table structure for table `tttresponse`
--

CREATE TABLE `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;

--
-- Dumping data for table `tttresponse`
--


--
-- Table structure for table `ttttype`
--

CREATE TABLE `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;

--
-- Dumping data for table `ttttype`
--


--
-- Table structure for table `tvs`
--

CREATE TABLE `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;

--
-- Dumping data for table `tvs`
--


--
-- Table structure for table `tvscx`
--

CREATE TABLE `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;

--
-- Dumping data for table `tvscx`
--


--
-- Table structure for table `tvslo`
--

CREATE TABLE `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;

--
-- Dumping data for table `tvslo`
--


--
-- Table structure for table `tvspelvis`
--

CREATE TABLE `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;

--
-- Dumping data for table `tvspelvis`
--


--
-- Table structure for table `tvsro`
--

CREATE TABLE `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;

--
-- Dumping data for table `tvsro`
--


--
-- Table structure for table `tvsut`
--

CREATE TABLE `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;

--
-- Dumping data for table `tvsut`
--


--
-- Table structure for table `type`
--

CREATE TABLE `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;

--
-- Dumping data for table `type`
--


--
-- Table structure for table `typeinf`
--

CREATE TABLE `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;

--
-- Dumping data for table `typeinf`
--


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

CREATE TABLE `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;

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


--
-- Table structure for table `ultrasounddetail`
--

CREATE TABLE `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;

--
-- Dumping data for table `ultrasounddetail`
--


--
-- Table structure for table `ultrasoundgyna`
--

CREATE TABLE `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;

--
-- Dumping data for table `ultrasoundgyna`
--


--
-- Table structure for table `ultrasoundobst`
--

CREATE TABLE `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;

--
-- Dumping data for table `ultrasoundobst`
--


--
-- Table structure for table `ultrasoundobstdetail`
--

CREATE TABLE `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;

--
-- Dumping data for table `ultrasoundobstdetail`
--


--
-- Table structure for table `usaf`
--

CREATE TABLE `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;

--
-- Dumping data for table `usaf`
--


--
-- Table structure for table `usn`
--

CREATE TABLE `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;

--
-- Dumping data for table `usn`
--


--
-- Table structure for table `usplace`
--

CREATE TABLE `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;

--
-- Dumping data for table `usplace`
--


--
-- Table structure for table `ustv`
--

CREATE TABLE `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;

--
-- Dumping data for table `ustv`
--


--
-- Table structure for table `vacations`
--

CREATE TABLE `vacations` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `vacation_date` date DEFAULT NULL,
  `vacation_reason` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `created_by` int(11) unsigned DEFAULT NULL,
  `updated_by` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vacations`
--


--
-- Table structure for table `visit_periods`
--

CREATE TABLE `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;

--
-- Dumping data for table `visit_periods`
--


--
-- Table structure for table `visits`
--

CREATE TABLE `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,
  `card_add` int(11) DEFAULT '0',
  `printserial` int(11) DEFAULT '0',
  `sms_send` int(11) DEFAULT '0',
  `branch_id` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT '0',
  `visit_order` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `visits`
--

INSERT INTO `visits` VALUES (1,2,'2024-10-27',NULL,1,250,50,150,0,50,0,2,1,0,0,NULL,NULL,NULL,NULL,0,1,NULL,2,0,'2024-10-27 08:05:09',0,0,NULL,0,0,0,'0',NULL),(2,2,'2024-10-27','10:06:00',999,0,0,50,0,0,0,0,0,0,0,NULL,NULL,'',NULL,NULL,NULL,0,2,0,NULL,1,0,NULL,0,1,0,'0',NULL);

--
-- Table structure for table `visits_updates`
--

CREATE TABLE `visits_updates` (
  `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,
  `detectionvalue` int(11) unsigned DEFAULT NULL,
  `clinic_id` int(11) unsigned DEFAULT NULL,
  `visit_order` int(11) DEFAULT '0',
  `userid_edit` int(11) DEFAULT '0',
  `date_edit` datetime DEFAULT NULL,
  `patientid_edit` int(11) DEFAULT '0',
  `card_add` tinyint(1) unsigned DEFAULT NULL,
  `printserial` int(11) unsigned DEFAULT NULL,
  `sms_send` tinyint(1) unsigned DEFAULT NULL,
  `branch_id` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `index_foreignkey_visits_updates_branch` (`branch_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;

--
-- Dumping data for table `visits_updates`
--


--
-- Table structure for table `wifeepc`
--

CREATE TABLE `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;

--
-- Dumping data for table `wifeepc`
--


--
-- Table structure for table `wifeepcobst`
--

CREATE TABLE `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;

--
-- Dumping data for table `wifeepcobst`
--


--
-- Table structure for table `wifeepcttt`
--

CREATE TABLE `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;

--
-- Dumping data for table `wifeepcttt`
--


--
-- Table structure for table `wifeepctype`
--

CREATE TABLE `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;

--
-- Dumping data for table `wifeepctype`
--


--
-- Table structure for table `wifejobs`
--

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

--
-- Dumping data for table `wifejobs`
--

INSERT INTO `wifejobs` 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),(52,'مبرمج',NULL),(53,'موظÙ بالجامعه',NULL),(54,'دكتور عظام',NULL),(55,'مندوب',NULL),(56,'تسويق',NULL),(57,' مهندس',NULL),(58,'مستشار',NULL),(59,'صنايعى',NULL),(60,'اخصائية تمريض',NULL),(61,'سياحة',NULL);

--
-- Table structure for table `wifemodeofd`
--

CREATE TABLE `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;

--
-- Dumping data for table `wifemodeofd`
--


--
-- Table structure for table `wifeobst`
--

CREATE TABLE `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;

--
-- Dumping data for table `wifeobst`
--


--
-- Table structure for table `wifep`
--

CREATE TABLE `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;

--
-- Dumping data for table `wifep`
--


--
-- Table structure for table `wifepmethod`
--

CREATE TABLE `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;

--
-- Dumping data for table `wifepmethod`
--


--
-- Table structure for table `wifesex`
--

CREATE TABLE `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;

--
-- Dumping data for table `wifesex`
--


--
-- Table structure for table `wifestatus`
--

CREATE TABLE `wifestatus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(55) NOT NULL,
  `del` int(11) unsigned DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `wifestatus`
--

INSERT INTO `wifestatus` VALUES (1,'انسة',0),(2,'متزوجة',0),(3,'مطلقة',0),(8,'متزجه للمره الثانيه',0),(9,'ارمله ',0),(10,'متزوج',0),(11,'ارمل',0),(12,'',0);

--
-- Table structure for table `wifetypeofd`
--

CREATE TABLE `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;

--
-- Dumping data for table `wifetypeofd`
--


--
-- Table structure for table `wifetypes`
--

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

--
-- Dumping data for table `wifetypes`
--

INSERT INTO `wifetypes` VALUES (1,'مدام',NULL),(2,'آنسة',NULL),(3,'استاذ',NULL),(4,'دكتور',NULL),(5,'حاجه',NULL),(6,'طÙلة',NULL),(7,'حاج',0);


