[BLOB]',0,0,0),(62,'Testing Audio Upload','Testing Audio Upload',0,'<h2><span class=\"ql-font-monospace\">Testing Audio Upload</span></h2>','Testing Audio Upload','audio.3awaafi.com/31-10-2023-12-02-A2oul_Ansak_melody4arab.com.mp3',1,'2023-10-31 12:02:43.527014',NULL,'data:image/jpeg;base64,[BLOB]',0,0,0),(63,'TESTING Audio','TESTING Audio',0,'<h1><span class=\"ql-font-monospace\">TESTING Audio<span class=\"ql-cursor\">﻿</span></span></h1>','x','audio.3awaafi.com/31-10-2023-12-29-7abeby_Ya_melody4arab.com_.mp3',1,'2023-10-31 12:29:27.610979',NULL,'data:image/jpeg;base64,[BLOB]',0,0,0),(64,'test','ssssss',0,'<h1>sssssss</h1>','00000','audioclinic.nxtserver.com/uploads/30-11-2023-11-21-Ahl_El_Hawa_melody4arab.com (1).mp3',1,'2023-11-30 11:21:07.880171',NULL,'data:image/jpeg;base64,[BLOB]',0,0,0),(65,'tttt','ssss',0,'sssss','ssssss','audioclinic.nxtserver.com/uploads/30-11-2023-11-23-Al_Qalb_Yaashak_melody4arab.com.mp3',1,'2023-11-30 11:23:08.999284',NULL,'AAAA',0,0,0),(66,'ninjarun','ddd',0,'<h2>sssssss</h2>','vvvvvvv','audioclinic.nxtserver.com/uploads/30-11-2023-11-24-Hazehi_Laylaty_melody4arab.com.mp3',1,'2023-11-30 11:24:36.000095',NULL,'data:image/jpeg;base64,[BLOB]',0,0,0);

--
-- Table structure for table `doctorschedules`
--

CREATE TABLE `doctorschedules` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `DoctorId` varchar(255) NOT NULL,
  `Day` int NOT NULL,
  `Month` int NOT NULL,
  `Year` int NOT NULL,
  `Hour` int NOT NULL,
  `Minute` int NOT NULL,
  `MinutesDuration` int NOT NULL,
  `WeekScheduleId` int NOT NULL,
  `Start` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_DoctorSchedules_WeekScheduleId` (`WeekScheduleId`),
  KEY `IX_DoctorSchedules_DoctorId` (`DoctorId`),
  CONSTRAINT `FK_DoctorSchedules_AspNetUsers_DoctorId` FOREIGN KEY (`DoctorId`) REFERENCES `aspnetusers` (`Id`) ON DELETE CASCADE,
  CONSTRAINT `FK_DoctorSchedules_WeekSchedules_WeekScheduleId` FOREIGN KEY (`WeekScheduleId`) REFERENCES `weekschedules` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `doctorschedules`
--


--
-- Table structure for table `medicaltests`
--

CREATE TABLE `medicaltests` (
  `Id` char(36) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `Name` longtext NOT NULL,
  `NameAR` longtext NOT NULL,
  `Description` longtext NOT NULL,
  `DescriptionAR` longtext NOT NULL,
  `Img` longtext NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `UpdateDate` datetime(6) NOT NULL,
  `IsDeleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `medicaltests`
--

INSERT INTO `medicaltests` VALUES ('08dbec23-202f-4bbe-8ca9-8acc3092bf55','string','stءring','string','string','string','2023-11-23 12:53:01.090849','2023-11-23 14:48:48.072130',1),('08dbec23-44a6-4a03-8c6d-1fc246ff2364','test','test','test','test','xx','2023-11-23 12:54:02.283129','2023-11-23 12:56:01.600340',1),('08dbec23-d337-4b20-81a9-39b245b06b4a','tt','tt','tt','tt','xx','2023-11-23 12:58:01.470954','2023-11-23 12:58:25.540073',1),('08dbec23-db7f-4b93-812a-702bd6d31971','merooOOOOO','mmmmm','mrroooo','ccccccccccc','xx','0001-01-01 00:00:00.000000','2023-11-23 14:48:53.011445',1),('08dbec25-3a8b-460f-8886-d8adab84426d','merrroo','merrroo','merrroo','merrroo','xx','2023-11-23 13:08:04.321393','2023-11-23 14:48:56.884341',1),('08dbec2b-647b-448e-894e-8fe3b3389c03','HAMILTON DEPRESSION RATING SCALE','مقياس هاملتون للإكتئاب ','Depression test','اختبار الاكتئاب ','xx','0001-01-01 00:00:00.000000','0001-01-01 00:00:00.000000',0),('08dbece9-d837-4646-8228-0c14b3cdd77a','Byk depression test','مقياس بيك للإكتئاب','Depression test','اختبار الإكتئاب','xx','2023-11-24 12:35:30.196247','0001-01-01 00:00:00.000000',0),('08dbf0ab-d92d-4532-8a75-19e530c644f5','TEST','TEST','TEST','TEST','xx','2023-11-29 07:21:47.662019','2023-11-29 07:31:58.673329',1),('08dbf0af-4de3-4204-8da7-16c89a48b72f','t','t','t','t','xx','2023-11-29 07:46:31.972486','2023-11-29 07:52:05.057726',1),('08dbf0c1-bb01-4355-899a-273e60bf7042','ttt','t','t','t','xx','2023-11-29 09:58:25.982886','2023-11-30 11:28:38.470053',1),('08dbf3dc-9d44-4fa8-8d48-12c8bad17140','xxx','xxxx','xxxx','xxxx','xx','2023-12-03 08:48:25.994645','2023-12-03 08:48:58.005109',1),('08dbf3dc-a9d5-4f11-8644-e95ca4c18366','vvvvvv','vvvvvvvv','vvvvvvvvv','vvvvvvvvvv','xx','2023-12-03 08:48:47.078131','2023-12-03 09:09:55.937031',1),('08dbf3dc-bd35-40d2-8a8e-9715842156e8','xxxxxxxxx','xxxxxxxxxx','xxxxxxxxxxxxxxx','xxxxxxxxxxxxx','xx','2023-12-03 08:49:19.578153','2023-12-03 11:03:24.221892',1),('08dbf3eb-95c2-475a-8637-fad6d2a84c81','z','z','z','z','xx','2023-12-03 10:35:35.846958','2023-12-03 10:46:22.759572',1),('08dbf3ed-2e0e-4434-8a3a-49da173801d7','xxxxxxxxxxxxxxxxxxx','xxxxxxxxx','xxxxxxxxxxxxx','xxxxxxxxxx','xx','2023-12-03 10:47:00.854128','2023-12-03 11:03:38.360905',1),('08dbf3ef-4a07-43d0-81bd-57e4df007788','test ','test ','test ','test ','xx','2023-12-03 11:02:06.777817','2023-12-03 11:17:19.232532',1),('08dbf3f0-da66-42ae-842e-e6620c060968','Medical Test ','Medical Test ','Medical Test ','Medical Test ','xx','2023-12-03 11:13:18.488587','2023-12-05 10:55:41.775295',1),('08dbf3fb-72f2-4b87-8adc-8d076fcf8bd4','xxx','xxx','xxx','xxxx','xx','2023-12-03 12:29:09.390693','2023-12-03 12:30:52.750715',1),('08dbf3fb-abd7-4846-8f1e-129c291e39cd','Miro ','مييرووز','test','test','xx','2023-12-03 12:30:44.842546','2023-12-05 10:55:36.144463',1);

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

CREATE TABLE `messages` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Email` longtext NOT NULL,
  `Name` longtext,
  `Phone` longtext,
  `Address` longtext,
  `Gender` int DEFAULT NULL,
  `Title` longtext NOT NULL,
  `Body` longtext NOT NULL,
  `UserId` varchar(255) DEFAULT NULL,
  `CreatedAt` datetime(6) NOT NULL DEFAULT '0001-01-01 00:00:00.000000',
  PRIMARY KEY (`Id`),
  KEY `IX_Messages_UserId` (`UserId`),
  CONSTRAINT `FK_Messages_AspNetUsers_UserId` FOREIGN KEY (`UserId`) REFERENCES `aspnetusers` (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `messages` VALUES (1,'strinxxxg','strixxxxng','string','string',0,'string','string',NULL,'2023-11-26 09:30:37.559546'),(2,'miroosalih@gmail.com','Marwa Salih','+24999999999','Kh - Sudan',0,'Test Title','Test Message',NULL,'2023-11-26 10:07:11.927876');

--
-- Table structure for table `questionanswers`
--

CREATE TABLE `questionanswers` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `QuestionId` int NOT NULL,
  `TestId` char(36) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `Answer` longtext NOT NULL,
  `AnswerAR` longtext NOT NULL,
  `Weight` int NOT NULL,
  `IsDeleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`Id`),
  KEY `IX_QuestionAnswers_QuestionId` (`QuestionId`),
  KEY `IX_QuestionAnswers_TestId` (`TestId`),
  CONSTRAINT `FK_QuestionAnswers_MedicalTests_TestId` FOREIGN KEY (`TestId`) REFERENCES `medicaltests` (`Id`) ON DELETE CASCADE,
  CONSTRAINT `FK_QuestionAnswers_TestQuestions_QuestionId` FOREIGN KEY (`QuestionId`) REFERENCES `testquestions` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=240 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `questionanswers`
--

INSERT INTO `questionanswers` VALUES (1,1,'08dbec23-db7f-4b93-812a-702bd6d31971','azz','zzz',12,1),(2,2,'08dbec23-db7f-4b93-812a-702bd6d31971','sss','ssss',12,0),(3,1,'08dbec23-db7f-4b93-812a-702bd6d31971','azz','zzz',22222,1),(4,3,'08dbec23-db7f-4b93-812a-702bd6d31971','xxxxx','xxxxxxxxxxx',12,0),(5,1,'08dbec23-db7f-4b93-812a-702bd6d31971','azz','zzz',22222,1),(6,1,'08dbec23-db7f-4b93-812a-702bd6d31971','azz','zzz',22222,1),(7,1,'08dbec23-db7f-4b93-812a-702bd6d31971','azz','zzz',22222,1),(8,1,'08dbec23-db7f-4b93-812a-702bd6d31971','azz','zzz',22222,0),(9,4,'08dbec23-202f-4bbe-8ca9-8acc3092bf55','xx','xx',111,1),(10,4,'08dbec23-202f-4bbe-8ca9-8acc3092bf55','meroo','xx',200,0),(11,5,'08dbec25-3a8b-460f-8886-d8adab84426d','ans','anns',90,1),(12,5,'08dbec25-3a8b-460f-8886-d8adab84426d','ans','anns',90,1),(13,5,'08dbec25-3a8b-460f-8886-d8adab84426d','ans','anns',90,0),(14,6,'08dbec2b-647b-448e-894e-8fe3b3389c03','Absent','لا يوجد ',0,1),(15,6,'08dbec2b-647b-448e-894e-8fe3b3389c03','Sadness, etc.','حزن,الخ',1,1),(16,6,'08dbec2b-647b-448e-894e-8fe3b3389c03','Occasional weeping','بكاء بين الحين والاخر',2,1),(17,6,'08dbec2b-647b-448e-894e-8fe3b3389c03','Frequent weeping','البكاء بشكل متكرر',3,1),(18,6,'08dbec2b-647b-448e-894e-8fe3b3389c03','Extreme symptoms','اعراض حزن شديدة',4,1),(19,6,'08dbec2b-647b-448e-894e-8fe3b3389c03','Absent','لا يوجد ',0,1),(20,6,'08dbec2b-647b-448e-894e-8fe3b3389c03','Sadness, etc.','حزن,الخ',1,1),(21,6,'08dbec2b-647b-448e-894e-8fe3b3389c03','Occasional weeping','بكاء بين الحين والاخر',2,1),(22,6,'08dbec2b-647b-448e-894e-8fe3b3389c03','Frequent weeping','البكاء بشكل متكرر',3,1),(23,6,'08dbec2b-647b-448e-894e-8fe3b3389c03','Extreme symptoms','اعراض حزن شديدة',4,1),(24,6,'08dbec2b-647b-448e-894e-8fe3b3389c03','Absent','لا يوجد ',0,0),(25,6,'08dbec2b-647b-448e-894e-8fe3b3389c03','Sadness, etc.','حزن,الخ',1,0),(26,6,'08dbec2b-647b-448e-894e-8fe3b3389c03','Occasional weeping','بكاء بين الحين والاخر',2,0),(27,6,'08dbec2b-647b-448e-894e-8fe3b3389c03','Frequent weeping','البكاء بشكل متكرر',3,0),(28,6,'08dbec2b-647b-448e-894e-8fe3b3389c03','Extreme symptoms','اعراض حزن شديدة',4,0),(29,7,'08dbec2b-647b-448e-894e-8fe3b3389c03','Absent','لا يوجد',0,0),(30,7,'08dbec2b-647b-448e-894e-8fe3b3389c03','Self-reproach, feels he/she has let people down','لوم النفس ، والشعور بأنه خيب ظن اللآخرين فيه',1,0),(31,7,'08dbec2b-647b-448e-894e-8fe3b3389c03','Ideas of guilt','أفكار بشأن أنه مذنب ',2,0),(32,7,'08dbec2b-647b-448e-894e-8fe3b3389c03','Present illness is a punishment; delusions  of guilt','مرضه الحالي عقاب نزل به ',3,0),(33,7,'08dbec2b-647b-448e-894e-8fe3b3389c03','Hallucinations of guilt','هلاويس بشأن الإحساس بالذنب',4,0),(34,8,'08dbec2b-647b-448e-894e-8fe3b3389c03','Absent','لا يوجد',0,0),(35,8,'08dbec2b-647b-448e-894e-8fe3b3389c03','Feels life is not worth living','يشعر أن الحياة لا تستحق العيش',1,0),(36,8,'08dbec2b-647b-448e-894e-8fe3b3389c03','Wishes he/she were dead','تتمنى لو مات',2,0),(37,8,'08dbec2b-647b-448e-894e-8fe3b3389c03','Suicidal ideas or gestures','أفكار بشأن الانتحار',3,0),(38,8,'08dbec2b-647b-448e-894e-8fe3b3389c03','Attempts at suicide','محاولات الانتحار',4,0),(39,9,'08dbec2b-647b-448e-894e-8fe3b3389c03','Absent','لا يوجد',0,0),(40,9,'08dbec2b-647b-448e-894e-8fe3b3389c03','Occasional','احيانا',1,0),(41,9,'08dbec2b-647b-448e-894e-8fe3b3389c03','Frequent','متكرر',2,0),(42,10,'08dbec2b-647b-448e-894e-8fe3b3389c03','Absent','لا يوجد',0,0),(43,10,'08dbec2b-647b-448e-894e-8fe3b3389c03','Occasional','احيانا',1,0),(44,10,'08dbec2b-647b-448e-894e-8fe3b3389c03','Frequent','متكرر',2,0),(45,11,'08dbec2b-647b-448e-894e-8fe3b3389c03','Absent','لا يوجد',0,0),(46,11,'08dbec2b-647b-448e-894e-8fe3b3389c03','Occasional','احيانا',1,0),(47,11,'08dbec2b-647b-448e-894e-8fe3b3389c03','Frequent','متكرر',2,0),(48,12,'08dbec2b-647b-448e-894e-8fe3b3389c03','No difficulty','لا توجد صعوبة',0,0),(49,12,'08dbec2b-647b-448e-894e-8fe3b3389c03','Feelings of incapacity, listlessness, indecision and vacillation','مشاعر العجز ، الخمول ، التردد والتذبذب',1,0),(50,12,'08dbec2b-647b-448e-894e-8fe3b3389c03',' Loss of interest in hobbies, decreased social activities','فقدان الاهتمام بالهوايات ، انخفاض الأنشطة الاجتماعية',2,0),(51,12,'08dbec2b-647b-448e-894e-8fe3b3389c03','Productivity decreased','انخفاض الإنتاجية ',3,0),(52,12,'08dbec2b-647b-448e-894e-8fe3b3389c03','Unable to work. Stopped working because of present illness only. (Absence from work after treatment or recovery may rate a lower score)','غير قادر على العمل. توقف عن العمل بسبب المرض الحالي فقط. (قد يؤدي الغياب عن العمل بعد العلاج أو الشفاء درجة أقل).',4,0),(53,13,'08dbec2b-647b-448e-894e-8fe3b3389c03','No difficulty','لا توجد صعوبة',0,1),(54,13,'08dbec2b-647b-448e-894e-8fe3b3389c03','Feelings of incapacity, listlessness, indecision and vacillation','مشاعر العجز ، الخمول ، التردد والتذبذب',1,1),(55,13,'08dbec2b-647b-448e-894e-8fe3b3389c03',' Loss of interest in hobbies, decreased social activities','فقدان الاهتمام بالهوايات ، انخفاض الأنشطة الاجتماعية',2,1),(56,13,'08dbec2b-647b-448e-894e-8fe3b3389c03','Productivity decreased','انخفاض الإنتاجية ',3,1),(57,13,'08dbec2b-647b-448e-894e-8fe3b3389c03','Unable to work. Stopped working because of present illness only. (Absence from work after treatment or recovery may rate a lower score)','غير قادر على العمل. توقف عن العمل بسبب المرض الحالي فقط. (قد يؤدي الغياب عن العمل بعد العلاج أو الشفاء درجة أقل).',4,1),(58,14,'08dbec2b-647b-448e-894e-8fe3b3389c03','Absent','لايوجد',0,0),(59,14,'08dbec2b-647b-448e-894e-8fe3b3389c03','Slight retardation at interview','تأخير طفيف أثناء الحديث مع شخص اخر',1,0),(60,14,'08dbec2b-647b-448e-894e-8fe3b3389c03','Obvious retardation at interview','تأخير واضح أثناء الحديث مع شخص اخر',2,0),(61,14,'08dbec2b-647b-448e-894e-8fe3b3389c03','Interview difficult','صعوبات أثناء الحديث مع شخص اخر',3,0),(62,14,'08dbec2b-647b-448e-894e-8fe3b3389c03','Complete stupor','ذهول كامل أثناء الحديث ',4,0),(63,15,'08dbec2b-647b-448e-894e-8fe3b3389c03','Absent','لايوجد',0,1),(64,15,'08dbec2b-647b-448e-894e-8fe3b3389c03','Slight retardation at interview','تأخير طفيف أثناء الحديث مع شخص اخر',1,1),(65,15,'08dbec2b-647b-448e-894e-8fe3b3389c03','Obvious retardation at interview','تأخير واضح أثناء الحديث مع شخص اخر',2,1),(66,15,'08dbec2b-647b-448e-894e-8fe3b3389c03','Interview difficult','صعوبات أثناء الحديث مع شخص اخر',3,1),(67,15,'08dbec2b-647b-448e-894e-8fe3b3389c03','Complete stupor','ذهول كامل أثناء الحديث ',4,1),(68,16,'08dbec2b-647b-448e-894e-8fe3b3389c03','Absent','لا يوجد',0,0),(69,16,'08dbec2b-647b-448e-894e-8fe3b3389c03','Occasional','احيانا',1,0),(70,16,'08dbec2b-647b-448e-894e-8fe3b3389c03','Frequent','متكرر',2,0),(71,17,'08dbec2b-647b-448e-894e-8fe3b3389c03','No difficulty','لا توجد',0,0),(72,17,'08dbec2b-647b-448e-894e-8fe3b3389c03','Tension and irritability','التوتر والتهيج',1,0),(73,17,'08dbec2b-647b-448e-894e-8fe3b3389c03','Worrying about minor matters','القلق بشأن الأمور البسيطة',2,0),(74,17,'08dbec2b-647b-448e-894e-8fe3b3389c03','Apprehensive attitude','سلوك عصبي',3,0),(75,17,'08dbec2b-647b-448e-894e-8fe3b3389c03','Fears','المخاوف',4,0),(76,18,'08dbec2b-647b-448e-894e-8fe3b3389c03','Absent','لا يوجد',0,0),(77,18,'08dbec2b-647b-448e-894e-8fe3b3389c03','Mild','خفيف',1,0),(78,18,'08dbec2b-647b-448e-894e-8fe3b3389c03','Moderate','متوسط',2,0),(79,18,'08dbec2b-647b-448e-894e-8fe3b3389c03','Severe','شديد',3,0),(80,18,'08dbec2b-647b-448e-894e-8fe3b3389c03','Incapacitating','يسبب العجز',4,0),(81,19,'08dbec2b-647b-448e-894e-8fe3b3389c03','Absent','لا يوجد',0,0),(82,19,'08dbec2b-647b-448e-894e-8fe3b3389c03','Mild','خفيف',1,0),(83,19,'08dbec2b-647b-448e-894e-8fe3b3389c03','Severe','شديد',2,0),(84,20,'08dbec2b-647b-448e-894e-8fe3b3389c03','Absent','لا يوجد',0,0),(85,20,'08dbec2b-647b-448e-894e-8fe3b3389c03',' Mild','خفيف',1,0),(86,20,'08dbec2b-647b-448e-894e-8fe3b3389c03','Severe','شديد',2,0),(87,21,'08dbec2b-647b-448e-894e-8fe3b3389c03','Absent','لا يوجد',0,0),(88,21,'08dbec2b-647b-448e-894e-8fe3b3389c03',' Mild','خفيف',1,0),(89,21,'08dbec2b-647b-448e-894e-8fe3b3389c03','Severe','شديد',2,0),(90,22,'08dbec2b-647b-448e-894e-8fe3b3389c03','Absent','لا يوجد',0,0),(91,22,'08dbec2b-647b-448e-894e-8fe3b3389c03','Mild','خفيف',1,0),(92,22,'08dbec2b-647b-448e-894e-8fe3b3389c03','Severe','متوسط',2,0),(93,23,'08dbec2b-647b-448e-894e-8fe3b3389c03','Not present','لا يوجد ',0,0),(94,23,'08dbec2b-647b-448e-894e-8fe3b3389c03','Self-absorption (bodily)','انهماك ذاتي',1,0),(95,23,'08dbec2b-647b-448e-894e-8fe3b3389c03','Preoccupation with health','انشغال بالأفكارالمتعلقة بالصحة',2,0),(96,23,'08dbec2b-647b-448e-894e-8fe3b3389c03',' Querulous attitude','سلوك معاتب أو نكدي',3,0),(97,23,'08dbec2b-647b-448e-894e-8fe3b3389c03','Hypochondriacal delusions','أوهام المرض ',4,0),(98,24,'08dbec2b-647b-448e-894e-8fe3b3389c03','No weight loss','لا يوجد فقدان للوزن',0,0),(99,24,'08dbec2b-647b-448e-894e-8fe3b3389c03','Slight','طفيف',1,0),(100,24,'08dbec2b-647b-448e-894e-8fe3b3389c03','Obvious or severe','واضح أو شديد',2,0),(101,25,'08dbec2b-647b-448e-894e-8fe3b3389c03','No loss','لا خسارة',0,0),(102,25,'08dbec2b-647b-448e-894e-8fe3b3389c03','Partial or doubtfull loss','خسارة جزئية',1,0),(103,25,'08dbec2b-647b-448e-894e-8fe3b3389c03','Loss of insight','فقدان الفطنة',2,0),(104,26,'08dbec2b-647b-448e-894e-8fe3b3389c03','No variation','لا يوجد اختلاف',0,0),(105,26,'08dbec2b-647b-448e-894e-8fe3b3389c03','Mild variation; AM ( ) PM ( )','اختلاف خفيف ؛ صباحا () مساء ()',1,0),(106,26,'08dbec2b-647b-448e-894e-8fe3b3389c03','Severe variation; AM ( ) PM ( )','اختلاف شديد ؛ صباحا () مساء ()',2,0),(107,27,'08dbec2b-647b-448e-894e-8fe3b3389c03','No variation','لا يوجد اختلاف',0,1),(108,27,'08dbec2b-647b-448e-894e-8fe3b3389c03','Mild variation; AM ( ) PM ( )','اختلاف خفيف ؛ صباحا () مساء ()',1,1),(109,27,'08dbec2b-647b-448e-894e-8fe3b3389c03','Severe variation; AM ( ) PM ( )','اختلاف شديد ؛ صباحا () مساء ()',2,1),(110,28,'08dbec2b-647b-448e-894e-8fe3b3389c03','Absent','لا يوجد',0,0),(111,28,'08dbec2b-647b-448e-894e-8fe3b3389c03','Mild','بسيط',1,0),(112,28,'08dbec2b-647b-448e-894e-8fe3b3389c03','Moderate','متوسط',2,0),(113,28,'08dbec2b-647b-448e-894e-8fe3b3389c03','Severe','شديد',3,0),(114,28,'08dbec2b-647b-448e-894e-8fe3b3389c03','Incapacitating','يسبب العجز',4,0),(115,29,'08dbec2b-647b-448e-894e-8fe3b3389c03','None','لا شيء',0,0),(116,29,'08dbec2b-647b-448e-894e-8fe3b3389c03','Suspicious','مشبوه',1,0),(117,29,'08dbec2b-647b-448e-894e-8fe3b3389c03','Ideas of reference','افكار مرجعية',2,0),(118,29,'08dbec2b-647b-448e-894e-8fe3b3389c03','Delusions of reference and persecution','أوهام مرجعية واضطهاد',3,0),(119,29,'08dbec2b-647b-448e-894e-8fe3b3389c03',' Hallucinations, persecutory','هلوسة ، اضطهاد',4,0),(120,30,'08dbec2b-647b-448e-894e-8fe3b3389c03','None','لا شيء',0,0),(121,30,'08dbec2b-647b-448e-894e-8fe3b3389c03','Suspicious','مشبوه',1,0),(122,30,'08dbec2b-647b-448e-894e-8fe3b3389c03','Ideas of reference','افكار مرجعية',2,0),(123,30,'08dbec2b-647b-448e-894e-8fe3b3389c03','Delusions of reference and persecution','أوهام مرجعية واضطهاد',3,0),(124,30,'08dbec2b-647b-448e-894e-8fe3b3389c03',' Hallucinations, persecutory','هلوسة ، اضطهاد',4,0),(125,31,'08dbec2b-647b-448e-894e-8fe3b3389c03','Absen','لا يوجد',0,0),(126,31,'08dbec2b-647b-448e-894e-8fe3b3389c03',' Mild','خفيف',1,0),(127,31,'08dbec2b-647b-448e-894e-8fe3b3389c03',' Severe','شديد',2,0),(128,32,'08dbece9-d837-4646-8228-0c14b3cdd77a','Don’t feel sad','لا اشعر بالحزن',0,0),(129,32,'08dbece9-d837-4646-8228-0c14b3cdd77a','I feel sad','اشعر بالحزن',1,0),(130,32,'08dbece9-d837-4646-8228-0c14b3cdd77a','I’m sad all the time, and I can’t get over it','اشعر بالحزن طوال الوقت ولا استطيع ان اتخلص منه',2,0),(131,32,'08dbece9-d837-4646-8228-0c14b3cdd77a','I’m so sad that I can’t stand it','حزين بدرجة لا استطيع تحملها',3,0),(132,33,'08dbece9-d837-4646-8228-0c14b3cdd77a','I’m not pessimistic about the future','لست متشائما بالنسبة للمستقبل ',0,0),(133,33,'08dbece9-d837-4646-8228-0c14b3cdd77a','I feel pessimistic about the future','اشعر بتشائم بالنسبة للمستقبل ',1,0),(134,33,'08dbece9-d837-4646-8228-0c14b3cdd77a','I feel like there is nothing that draws me to the future','اشعر بانه ليس هنالك شيء يشدني للمستقبل',2,0),(135,33,'08dbece9-d837-4646-8228-0c14b3cdd77a','I feel that the future is unbearable and that things will not get better','اشعر ان المستقبل لا امل فيه وان الامور لن تتحسن',3,0),(136,34,'08dbece9-d837-4646-8228-0c14b3cdd77a','I don’t feel like a failure','لا اشعر بأني فاشل',0,0),(137,34,'08dbece9-d837-4646-8228-0c14b3cdd77a','I feel like I failed more than usual','اشعر انني فشلت اكثر من المعتاد',1,0),(138,34,'08dbece9-d837-4646-8228-0c14b3cdd77a','When I look at my past years, I only see a fiasco','عندما انظر الى ما مضى من سنوات عمري فأنا لا ارى الا الفشل الذريع',2,0),(139,34,'08dbece9-d837-4646-8228-0c14b3cdd77a','I feel like a total failure','اشعر بانني شخص فاشل تماما',3,0),(140,35,'08dbece9-d837-4646-8228-0c14b3cdd77a','Enjoy the aspects of life as I used to','استمتع بدرجة كافيةبجوانب الحياة كما اعتدت من قبل',0,0),(141,35,'08dbece9-d837-4646-8228-0c14b3cdd77a','I don’t enjoy the aspect of life as I used to','لا استمتع بجوانب الحياة على النحو الذي تعودت عليه',1,0),(142,35,'08dbece9-d837-4646-8228-0c14b3cdd77a','I don’t have real fun in anything in life','لم اعد احصل على استمتاع حقيقيفي اي شيئ في الحياة',2,0),(143,35,'08dbece9-d837-4646-8228-0c14b3cdd77a','I never enjoy anything in life','لا استمتع اطلاقا بأي شيء في الحياة',3,0),(144,36,'08dbece9-d837-4646-8228-0c14b3cdd77a','I don’t feel guilty','لا اشعر بالذنب',0,0),(145,36,'08dbece9-d837-4646-8228-0c14b3cdd77a','I don’t feel like I’m guilty','اشعر بأني قد اكون مذنبا ',1,0),(146,36,'08dbece9-d837-4646-8228-0c14b3cdd77a','I feel deeply guilty most of the time','اشعر بشعور عميق بالذنب في اغلب الاوقات',2,0),(147,36,'08dbece9-d837-4646-8228-0c14b3cdd77a','I feel generally guilty','اشعر بالذنب بصفة عامة',3,0),(148,37,'08dbece9-d837-4646-8228-0c14b3cdd77a','I don’t feel like I’m getting a punishment','لا اشعر بأني اتلقى عقابا',0,0),(149,37,'08dbece9-d837-4646-8228-0c14b3cdd77a','I feel that I may be punished','اشعر باني فد اتعرض للعقاب',1,0),(150,37,'08dbece9-d837-4646-8228-0c14b3cdd77a','I expect to be punished','اتوقع ان اعاقب',2,0),(151,37,'08dbece9-d837-4646-8228-0c14b3cdd77a','I feel like I’m receiving a punishment','اشعر بأني اتلقى عقابا',3,0),(152,38,'08dbece9-d837-4646-8228-0c14b3cdd77a','I don’t feel dissatisfied with myself','لا اشعر بعدم الرضا عن نفسي',0,0),(153,38,'08dbece9-d837-4646-8228-0c14b3cdd77a','I’m not satisfied with myself','انا غير راضي عن نفسي',1,0),(154,38,'08dbece9-d837-4646-8228-0c14b3cdd77a','I’m angry with myself','انا ممتعض من نفسي',2,0),(155,38,'08dbece9-d837-4646-8228-0c14b3cdd77a','I hate myself','اكره نفسي',4,0),(156,39,'08dbece9-d837-4646-8228-0c14b3cdd77a','I don’t feel I’m worse than others','لا اشعر باني اسوء من الاخرين',0,0),(157,39,'08dbece9-d837-4646-8228-0c14b3cdd77a','I criticize myself for my weaknesses and my mistakes','انقد نفسي بسبب ضعفي واخطائي',1,0),(158,39,'08dbece9-d837-4646-8228-0c14b3cdd77a','I blame myself most of the time for my mistakes','الوم نفسي معظم الوقت على اخطائي',2,0),(159,39,'08dbece9-d837-4646-8228-0c14b3cdd77a','I blame myself for everything bad that happens','الوم نفسي على كل شيء يحدث',3,0),(160,40,'08dbece9-d837-4646-8228-0c14b3cdd77a','I feel bad about life','اشعر بضيق من الحياة',0,0),(161,40,'08dbece9-d837-4646-8228-0c14b3cdd77a','I have no desire to live','ليس لي رغبة في الحياة',1,0),(162,40,'08dbece9-d837-4646-8228-0c14b3cdd77a','I hate life','اصبحت اكره الحياة',2,0),(163,40,'08dbece9-d837-4646-8228-0c14b3cdd77a','I wish I could die if I found an opportunity','اتمنى الموت اذا وجدت فرصة لذلك',3,0),(164,41,'08dbece9-d837-4646-8228-0c14b3cdd77a','I don’t cry more than usual','لا ابكي اكثر من المعتاد',0,0),(165,41,'08dbece9-d837-4646-8228-0c14b3cdd77a','I’m currently crying more than before','ابكي الان اكثر من ذي قبل',1,0),(166,41,'08dbece9-d837-4646-8228-0c14b3cdd77a','I’m crying all the time','ابكي طوال الوقت',2,0),(167,41,'08dbece9-d837-4646-8228-0c14b3cdd77a','I was able to cry in the past, but now I can’t cry, even if I have a desire','لقد كنت قادرا على البكاء فيما مضى لكنني الان لااستطيع البكاء حتى لو كانتلي رغبة في ذلك',3,0),(168,42,'08dbece9-d837-4646-8228-0c14b3cdd77a','I’m not more nervous than before','لست متوتر اكثر من ذي قبل',0,0),(169,42,'08dbece9-d837-4646-8228-0c14b3cdd77a','I get annoyed or nervous more quickly than before','اتضايق او اتوتر بسرعة اكثر من ذي قبل',1,0),(170,42,'08dbece9-d837-4646-8228-0c14b3cdd77a','I feel nervous all the time','اشعر بالتوتر كل وقت',2,0),(171,42,'08dbece9-d837-4646-8228-0c14b3cdd77a','I never get nervous about the things that used to make me nervous','لا اتوتر ابدا من الاشياء التي كانت توترني فيما مضى ',3,0),(172,43,'08dbece9-d837-4646-8228-0c14b3cdd77a','I didn’t lose caring for other people','لم افقد الاهتمام بالناس الاخرين',0,0),(173,43,'08dbece9-d837-4646-8228-0c14b3cdd77a','I’m less caring about others than I used to be','اني اقل اهتماما بالاخرين مما كنت عليه من ذي قبل ',1,0),(174,43,'08dbece9-d837-4646-8228-0c14b3cdd77a','I lost most of my attention on other people','لقد فقدت معظم اهتمامي بالناس الاخرين',2,0),(175,43,'08dbece9-d837-4646-8228-0c14b3cdd77a','I lost all my attention on other people','لقد فقدت كل اهتمامي بالناس الاخرين',3,0),(176,44,'08dbece9-d837-4646-8228-0c14b3cdd77a','I make decisions on the same level I used to','اتخذت قرارات بنفس المستوى الذي اعتدت عليه',0,0),(177,44,'08dbece9-d837-4646-8228-0c14b3cdd77a','I’ve stopped making decisions more than ever before','لقد توقفت عن اتخاذ القرارات بصورة اكبر من ما مضى',1,0),(178,44,'08dbece9-d837-4646-8228-0c14b3cdd77a','I find it more difficult to make decisions than I used to','اجد صعوبة اكبر في اتخاذ القرارات عما كنت اقوم به',2,0),(179,44,'08dbece9-d837-4646-8228-0c14b3cdd77a','I can’t make decisions anymore','لم اعد استطيع اخذ القرارات على الاطلاق',3,0),(180,45,'08dbece9-d837-4646-8228-0c14b3cdd77a','I make decisions on the same level I used to','اتخذت قرارات بنفس المستوى الذي اعتدت عليه',0,1),(181,45,'08dbece9-d837-4646-8228-0c14b3cdd77a','I’ve stopped making decisions more than ever before','لقد توقفت عن اتخاذ القرارات بصورة اكبر من ما مضى',1,1),(182,45,'08dbece9-d837-4646-8228-0c14b3cdd77a','I find it more difficult to make decisions than I used to','اجد صعوبة اكبر في اتخاذ القرارات عما كنت اقوم به',2,1),(183,45,'08dbece9-d837-4646-8228-0c14b3cdd77a','I can’t make decisions anymore','لم اعد استطيع اخذ القرارات على الاطلاق',3,1),(184,46,'08dbece9-d837-4646-8228-0c14b3cdd77a','I don’t feel worse than I used to be','لا اشعر اني ابدو في حالة اسوء مما كنت عليه ',0,0),(185,46,'08dbece9-d837-4646-8228-0c14b3cdd77a','I’m worried about looking older and less lively','يقلقني ان ابدو اكبر سنا واقل حيوية',1,0),(186,46,'08dbece9-d837-4646-8228-0c14b3cdd77a','I feel that there are permanent changes in my appearance that make me look less lively','اشعر ان هالك تغيرات مستديمة في مظهري تجعلني ابدو اقل حيوية',2,0),(187,46,'08dbece9-d837-4646-8228-0c14b3cdd77a','I think I look ugly','اعتقد اني ابدو قبيحا ',3,0),(188,47,'08dbece9-d837-4646-8228-0c14b3cdd77a','I can do my job as I used to','استطيع ان اقوم بعملي كما تعودت',0,0),(189,47,'08dbece9-d837-4646-8228-0c14b3cdd77a','I need a lot of effort to start doing something','احتاج الى جهد كبير لكي ابدا بعمل شيء ما ',1,0),(190,47,'08dbece9-d837-4646-8228-0c14b3cdd77a','I have to press myself too hard to do anything','ان علي ان اضغط على نفسي بشدة لعمل اي شيء ',2,0),(191,47,'08dbece9-d837-4646-8228-0c14b3cdd77a','I can’t do anything at all','لا استطيع ان اقوم بعمل اي شيء على الاطلاق',3,0),(192,48,'08dbece9-d837-4646-8228-0c14b3cdd77a','I can sleep as usual','استطيع ان انام كالمعتاد',0,0),(193,48,'08dbece9-d837-4646-8228-0c14b3cdd77a','I don’t sleep as usual','انا انام كالمعتاد',1,0),(194,48,'08dbece9-d837-4646-8228-0c14b3cdd77a','I get up an hour or two before my time and I find it difficult to fall asleep again','استيقظ قبل موعدي بساعة او ساعتينواجد صعوبة في النوم مرة اخرى',2,0),(195,48,'08dbece9-d837-4646-8228-0c14b3cdd77a','I get up a few hours before my usual time and I can’t go back to sleep again','استيقظ قبل بضعة ساعات من موعدي المعتاد ولا استطيع العودة للنوم مرة اخرى ',3,0),(196,49,'08dbece9-d837-4646-8228-0c14b3cdd77a','I don’t feel tired more than usual','لا اشعر بتعب اكثر من المعتاد',0,0),(197,49,'08dbece9-d837-4646-8228-0c14b3cdd77a','I get tired quickly','اتعب بسرعة عن المعتاد ',1,0),(198,49,'08dbece9-d837-4646-8228-0c14b3cdd77a','I get tired of doing anything','اتعب من القيام بأي جهد في عمل اي شيء ',2,0),(199,49,'08dbece9-d837-4646-8228-0c14b3cdd77a','I’m so tired that I can’t do any work','اني اتعب لدرجة انني لا استطيع القيام باي عمل ',3,0),(200,50,'08dbece9-d837-4646-8228-0c14b3cdd77a','my appetite for food is no less than usual','ان شهيتي للطعام ليست اقل من المعتاد',0,0),(201,50,'08dbece9-d837-4646-8228-0c14b3cdd77a','my appetite for food is as good as usual','ان شهيتي للطعام ليست جيدة كالمعتاد',1,0),(202,50,'08dbece9-d837-4646-8228-0c14b3cdd77a','my appetite for food is much worse now','ان شهيتي للطعام اسوء كثيرا الان',2,0),(203,50,'08dbece9-d837-4646-8228-0c14b3cdd77a','I don’t have any appetite at all, right now','ليس لدي شهية على الاطلاق في الوقت الحاضر ',3,0),(204,51,'08dbece9-d837-4646-8228-0c14b3cdd77a','I haven’t lost weight lately','لم ينقص وزني في الاونة الاخيرة',0,0),(205,51,'08dbece9-d837-4646-8228-0c14b3cdd77a','I lost more than a kilogram of weight','فقدت اكثر من كيلوجرامات من وزني ',1,0),(206,51,'08dbece9-d837-4646-8228-0c14b3cdd77a','I lost four kilograms of weight','فقدت اربعه كيلوجرامات من وزني ',2,0),(207,51,'08dbece9-d837-4646-8228-0c14b3cdd77a','I lost six kilograms of weight','فقدت سته كيلوجرامات من وزني ',3,0),(208,52,'08dbece9-d837-4646-8228-0c14b3cdd77a','I’m not busy with my health more than before','لست مشغولا على صحتي اكثر من السابق',0,0),(209,52,'08dbece9-d837-4646-8228-0c14b3cdd77a','I’m very busy with some physical problems such as aches, stomach disorders and constipation','اني مشغول جدا ببعض المشكلات البدنية مثل الاوجاع واضطرابات المعدة والامساك',1,0),(210,52,'08dbece9-d837-4646-8228-0c14b3cdd77a','I’m very busy with some daily problems and it’s hard to think about anything else','اني مشغول جدا ببعض المشكلات اليومية ومن الصعب ان افكر بأي شيء اخر ',2,0),(211,52,'08dbece9-d837-4646-8228-0c14b3cdd77a','I’m so busy with some physical problems that I can’t think of anything else','اني مشغول ببعض المكلات البدنية بحيث لا يمكنني التفكير باي شيء اخر ',3,0),(212,53,'08dbece9-d837-4646-8228-0c14b3cdd77a','I haven’t noticed any recent changes in my sexual interest','لم الاحظ اي تغيرات حديثة في اهتمامي الجنسي ',0,0),(213,53,'08dbece9-d837-4646-8228-0c14b3cdd77a','I’m less interested in sex than usual','انني اقل اهتماما بالجنس من المعتاد',1,0),(214,53,'08dbece9-d837-4646-8228-0c14b3cdd77a','I’m now less interested in sex','لقد قل الان اهتمامي بالجنس كثيرا ',2,0),(215,53,'08dbece9-d837-4646-8228-0c14b3cdd77a','I lost totally my interest in sex','لقد فقدت اهتمامي بالجنس تماما ',3,0),(216,54,'08dbf0ab-d92d-4532-8a75-19e530c644f5','Ans','Ans',10,0),(217,55,'08dbf0af-4de3-4204-8da7-16c89a48b72f','a','a',11,1),(218,56,'08dbf0c1-bb01-4355-899a-273e60bf7042','ff','ff',11,1),(219,57,'08dbf0c1-bb01-4355-899a-273e60bf7042','ssss','aaaa',3,0),(220,57,'08dbf0c1-bb01-4355-899a-273e60bf7042','ssss','dddd',4,0),(221,58,'08dbf3eb-95c2-475a-8637-fad6d2a84c81','ans','ans',1,1),(222,59,'08dbf3eb-95c2-475a-8637-fad6d2a84c81','ans','ans',1,1),(223,60,'08dbf3eb-95c2-475a-8637-fad6d2a84c81','ans','ans',1,0),(224,61,'08dbf3eb-95c2-475a-8637-fad6d2a84c81','q','q',11,0),(225,62,'08dbf3eb-95c2-475a-8637-fad6d2a84c81','x','x',1,0),(226,63,'08dbf3eb-95c2-475a-8637-fad6d2a84c81','ssss','sssss',12,1),(227,64,'08dbf3eb-95c2-475a-8637-fad6d2a84c81','tt','tt',12,0),(228,65,'08dbf3dc-bd35-40d2-8a8e-9715842156e8','x','x',12,0),(229,66,'08dbf3dc-bd35-40d2-8a8e-9715842156e8','ss','ss',1,0),(230,67,'08dbf3dc-bd35-40d2-8a8e-9715842156e8','cc','cc',12,0),(231,68,'08dbf3ef-4a07-43d0-81bd-57e4df007788','test ','test ',1,1),(232,68,'08dbf3ef-4a07-43d0-81bd-57e4df007788','test ','test ',2,1),(233,68,'08dbf3ef-4a07-43d0-81bd-57e4df007788','test ','test ',3,1),(234,69,'08dbf3ef-4a07-43d0-81bd-57e4df007788','ans1','ans1',1,0),(235,69,'08dbf3ef-4a07-43d0-81bd-57e4df007788','ans2','ans2',2,0),(236,69,'08dbf3ef-4a07-43d0-81bd-57e4df007788','ans3','ans3',3,0),(237,70,'08dbf3ef-4a07-43d0-81bd-57e4df007788','ans','ans',1,1),(238,71,'08dbf3f0-da66-42ae-842e-e6620c060968','Medical Test ','Medical Test ',1,0),(239,71,'08dbf3f0-da66-42ae-842e-e6620c060968','Medical Test ','Medical Test ',2,0);

--
-- Table structure for table `testquestions`
--

CREATE TABLE `testquestions` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `Question` longtext NOT NULL,
  `QuestionAR` longtext NOT NULL,
  `TestId` char(36) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `CreatedDate` datetime(6) NOT NULL,
  `UpdateDate` datetime(6) NOT NULL,
  `IsDeleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`Id`),
  KEY `IX_TestQuestions_TestId` (`TestId`),
  CONSTRAINT `FK_TestQuestions_MedicalTests_TestId` FOREIGN KEY (`TestId`) REFERENCES `medicaltests` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `testquestions`
--

INSERT INTO `testquestions` VALUES (1,'Q1','q1','08dbec23-db7f-4b93-812a-702bd6d31971','0001-01-01 00:00:00.000000','0001-01-01 00:00:00.000000',0),(2,'vvv','vvvv','08dbec23-db7f-4b93-812a-702bd6d31971','2023-11-23 13:05:50.591791','0001-01-01 00:00:00.000000',0),(3,'xxxxxxxxxx','xxxxxxxxxxxxxxx','08dbec23-db7f-4b93-812a-702bd6d31971','2023-11-23 13:08:29.542604','0001-01-01 00:00:00.000000',0),(4,'xx','xx','08dbec23-202f-4bbe-8ca9-8acc3092bf55','0001-01-01 00:00:00.000000','0001-01-01 00:00:00.000000',0),(5,'test','test','08dbec25-3a8b-460f-8886-d8adab84426d','0001-01-01 00:00:00.000000','0001-01-01 00:00:00.000000',0),(6,'DEPRESSED MOOD','المزاج الإكتئابي','08dbec2b-647b-448e-894e-8fe3b3389c03','0001-01-01 00:00:00.000000','0001-01-01 00:00:00.000000',0),(7,'FEELINGS OF GUILT','الشعور بالذنب ','08dbec2b-647b-448e-894e-8fe3b3389c03','2023-11-23 14:05:08.833093','0001-01-01 00:00:00.000000',0),(8,'SUICIDE','الانتحار','08dbec2b-647b-448e-894e-8fe3b3389c03','2023-11-23 14:08:02.294464','0001-01-01 00:00:00.000000',0),(9,'INSOMNIA - Initial','الأرق - في بداية الليل ( صعوبة النوم)','08dbec2b-647b-448e-894e-8fe3b3389c03','2023-11-23 14:10:29.841611','0001-01-01 00:00:00.000000',0),(10,'INSOMNIA - Middle (Complains of being restless and disturbed during the night. Waking during the night.)','الأرق - في منتصف الليل  (يشكو من القلق والانزعاج أثناء الليل. الاستيقاظ أثناء الليل.)','08dbec2b-647b-448e-894e-8fe3b3389c03','2023-11-23 14:13:13.022286','0001-01-01 00:00:00.000000',0),(11,'INSOMNIA - Delayed (Waking in early hours of the morning and  unable to fall asleep again)','الأرق –  ساعة متأخرة من الليل','08dbec2b-647b-448e-894e-8fe3b3389c03','2023-11-23 14:14:52.237694','0001-01-01 00:00:00.000000',0),(12,'WORK AND INTERESTS','العمل والاهتمامات','08dbec2b-647b-448e-894e-8fe3b3389c03','2023-11-23 14:17:33.674689','0001-01-01 00:00:00.000000',0),(13,'WORK AND INTERESTS','العمل والاهتمامات','08dbec2b-647b-448e-894e-8fe3b3389c03','2023-11-23 14:17:33.711701','0001-01-01 00:00:00.000000',1),(14,'RETARDATION (Slowness of thought, speech, and activity;  apathy; stupor.)','التأخير (بطء في الفكر والكلام والنشاط ؛ اللامبالاة ؛ الذهول.)','08dbec2b-647b-448e-894e-8fe3b3389c03','2023-11-23 14:20:23.137253','0001-01-01 00:00:00.000000',0),(15,'RETARDATION (Slowness of thought, speech, and activity;  apathy; stupor.)','التأخير (بطء في الفكر والكلام والنشاط ؛ اللامبالاة ؛ الذهول.)','08dbec2b-647b-448e-894e-8fe3b3389c03','2023-11-23 14:20:23.233134','0001-01-01 00:00:00.000000',1),(16,'AGITATION','الإنفعال (الضجر المرتبط بالقلق)','08dbec2b-647b-448e-894e-8fe3b3389c03','2023-11-23 14:22:03.245498','0001-01-01 00:00:00.000000',0),(17,'ANXIETY - PSYCHIC','القلق - تأثيره على الحالة النفسية','08dbec2b-647b-448e-894e-8fe3b3389c03','2023-11-23 14:25:00.416170','0001-01-01 00:00:00.000000',0),(18,'ANXIETY - SOMATIC Gastrointestinal, indigestion Cardiovascular, palpitation, Headaches Respiratory, Genito-urinary, etc.','القلق - تأثيره على الجهاز الهضمي الجسدي ،  وعسر الهضم القلبي الوعائي ، والخفقان ،  والصداع التنفسي ، والأعضاء التناسلية البولية ، إلخ','08dbec2b-647b-448e-894e-8fe3b3389c03','2023-11-23 14:27:55.915964','0001-01-01 00:00:00.000000',0),(19,'SOMATIC SYMPTOMS -  GASTROINTESTINAL (Loss of appetite , heavy feeling in abdomen; constipation)','الأعراض الجسدية – الجهاز الهضمي  (فقدان الشهية ، الشعور الثقيل في البطن ؛ الإمساك)','08dbec2b-647b-448e-894e-8fe3b3389c03','2023-11-23 14:29:18.263423','0001-01-01 00:00:00.000000',0),(20,'SOMATIC SYMPTOMS - GENERAL (Heaviness in limbs, back or head; diffuse backache; loss of energy and fatiguability)','13-	الأعراض الجسدية – عامة  (ثقل في الأطراف أو الظهر أو الرأس ؛ آلام في الظهر ؛ فقدان الطاقة والإرهاق)','08dbec2b-647b-448e-894e-8fe3b3389c03','2023-11-23 14:30:53.506510','0001-01-01 00:00:00.000000',0),(21,'SOMATIC SYMPTOMS - GENERAL (Heaviness in limbs, back or head; diffuse backache; loss of energy and fatiguability)','13-	الأعراض الجسدية – عامة  (ثقل في الأطراف أو الظهر أو الرأس ؛ آلام في الظهر ؛ فقدان الطاقة والإرهاق)','08dbec2b-647b-448e-894e-8fe3b3389c03','2023-11-23 14:30:53.552413','0001-01-01 00:00:00.000000',0),(22,'GENITAL SYMPTOMS (Loss of libido, menstrual disturbances)','أعراض الأعضاء التناسلية  (فقدان الرغبة الجنسية ، اضطرابات الدورة الشهرية)','08dbec2b-647b-448e-894e-8fe3b3389c03','2023-11-23 14:32:24.321629','0001-01-01 00:00:00.000000',0),(23,'HYPOCHONDRIASIS','الوسواس المرضي ','08dbec2b-647b-448e-894e-8fe3b3389c03','2023-11-23 14:34:52.873762','0001-01-01 00:00:00.000000',0),(24,'WEIGHT LOSS','فقدان الوزن','08dbec2b-647b-448e-894e-8fe3b3389c03','2023-11-23 14:36:26.025154','0001-01-01 00:00:00.000000',0),(25,'INSIGHT (Insight must be interpreted in terms of patient’s understanding and backgrou',' الفطنة (يجب تفسير الفطنة من حيث فهم المريض وخلفيته.)','08dbec2b-647b-448e-894e-8fe3b3389c03','2023-11-23 14:38:11.897818','0001-01-01 00:00:00.000000',0),(26,'DIURNAL VARIATION (Symptoms worse in morning or evening. Note which it is. ) ','التباين النهاري  (لاحظ للأعراض: هل أسوأ في الصباح أو في المساء)','08dbec2b-647b-448e-894e-8fe3b3389c03','2023-11-23 14:40:32.212443','0001-01-01 00:00:00.000000',0),(27,'DIURNAL VARIATION (Symptoms worse in morning or evening. Note which it is. ) ','التباين النهاري  (لاحظ للأعراض: هل أسوأ في الصباح أو في المساء)','08dbec2b-647b-448e-894e-8fe3b3389c03','2023-11-23 14:40:32.229452','0001-01-01 00:00:00.000000',1),(28,'DEPERSONALIZATION AND  DEREALIZATION (feelings of unreality, nihilistic ideas)',' تبدد الشخصية وتجاهلها  (مشاعر غير واقعية ، أفكار عدمية)','08dbec2b-647b-448e-894e-8fe3b3389c03','2023-11-23 14:43:08.357543','0001-01-01 00:00:00.000000',0),(29,'PARANOID SYMPTOMS (Not with a depressive quality)','أعراض بجنون العظمة  (ليس بجودة اكتئابية)','08dbec2b-647b-448e-894e-8fe3b3389c03','2023-11-23 14:45:30.232298','0001-01-01 00:00:00.000000',0),(30,'PARANOID SYMPTOMS (Not with a depressive quality)','أعراض بجنون العظمة  (ليس بجودة اكتئابية)','08dbec2b-647b-448e-894e-8fe3b3389c03','2023-11-23 14:45:30.280093','0001-01-01 00:00:00.000000',0),(31,'OBSESSIONAL SYMPTOMS (Obsessive thoughts and compulsions against which the patient struggles)','أعراض الوسواس (الأفكار الوسواسية والإكراهات التي يكافح المريض ضدها)','08dbec2b-647b-448e-894e-8fe3b3389c03','2023-11-23 14:46:50.252811','0001-01-01 00:00:00.000000',0),(32,'SAD','الحزن','08dbece9-d837-4646-8228-0c14b3cdd77a','2023-11-24 12:41:24.197474','0001-01-01 00:00:00.000000',0),(33,'Pessimism','التشائم','08dbece9-d837-4646-8228-0c14b3cdd77a','2023-11-24 12:49:39.206121','0001-01-01 00:00:00.000000',0),(34,' Failure','الفشل','08dbece9-d837-4646-8228-0c14b3cdd77a','2023-11-24 12:52:57.178833','0001-01-01 00:00:00.000000',0),(35,'Enjoying life','الاستمتاع بالحياة ','08dbece9-d837-4646-8228-0c14b3cdd77a','2023-11-24 13:01:36.204848','0001-01-01 00:00:00.000000',0),(36,'Guilt','الذنب','08dbece9-d837-4646-8228-0c14b3cdd77a','2023-11-24 13:03:56.448415','0001-01-01 00:00:00.000000',0),(37,'Punishment','العقاب','08dbece9-d837-4646-8228-0c14b3cdd77a','2023-11-24 13:06:37.633890','0001-01-01 00:00:00.000000',0),(38,'Satisfaction','الرضاء','08dbece9-d837-4646-8228-0c14b3cdd77a','2023-11-24 13:09:43.928048','0001-01-01 00:00:00.000000',0),(39,'Blame','اللوم','08dbece9-d837-4646-8228-0c14b3cdd77a','2023-11-24 13:14:19.326083','0001-01-01 00:00:00.000000',0),(40,'Death','الموت','08dbece9-d837-4646-8228-0c14b3cdd77a','2023-11-24 13:17:06.036146','0001-01-01 00:00:00.000000',0),(41,'Crying','البكاء','08dbece9-d837-4646-8228-0c14b3cdd77a','2023-11-24 13:19:40.124230','0001-01-01 00:00:00.000000',0),(42,'Tension','التوتر','08dbece9-d837-4646-8228-0c14b3cdd77a','2023-11-24 14:03:33.005098','0001-01-01 00:00:00.000000',0),(43,'Caring','الاهتمام','08dbece9-d837-4646-8228-0c14b3cdd77a','2023-11-24 14:07:21.622155','0001-01-01 00:00:00.000000',0),(44,'Making decisions','اخذ القرارات ','08dbece9-d837-4646-8228-0c14b3cdd77a','2023-11-24 14:13:25.916387','0001-01-01 00:00:00.000000',0),(45,'Making decisions','اخذ القرارات ','08dbece9-d837-4646-8228-0c14b3cdd77a','2023-11-24 14:14:32.693707','0001-01-01 00:00:00.000000',1),(46,'The Appearance','المظهر','08dbece9-d837-4646-8228-0c14b3cdd77a','2023-11-24 14:18:07.271133','0001-01-01 00:00:00.000000',0),(47,'Doing work','اداء العمل','08dbece9-d837-4646-8228-0c14b3cdd77a','2023-11-24 14:21:01.904720','0001-01-01 00:00:00.000000',0),(48,'Sleeping','النوم','08dbece9-d837-4646-8228-0c14b3cdd77a','2023-11-24 14:25:25.796637','0001-01-01 00:00:00.000000',0),(49,'Tired','التعب','08dbece9-d837-4646-8228-0c14b3cdd77a','2023-11-24 14:31:13.374951','0001-01-01 00:00:00.000000',0),(50,'Appetite','الشهية','08dbece9-d837-4646-8228-0c14b3cdd77a','2023-11-24 14:33:49.814965','0001-01-01 00:00:00.000000',0),(51,'Weight loss ','خسارة الوزن','08dbece9-d837-4646-8228-0c14b3cdd77a','2023-11-24 14:36:22.642044','0001-01-01 00:00:00.000000',0),(52,'Health problems','مشاكل صحية','08dbece9-d837-4646-8228-0c14b3cdd77a','2023-11-24 14:40:37.482756','0001-01-01 00:00:00.000000',0),(53,'Sexual interest','الاهتمام الجنسي ','08dbece9-d837-4646-8228-0c14b3cdd77a','2023-11-24 14:43:56.457008','0001-01-01 00:00:00.000000',0),(54,'Q1','Q1','08dbf0ab-d92d-4532-8a75-19e530c644f5','2023-11-29 07:22:12.731507','0001-01-01 00:00:00.000000',0),(55,'q','q','08dbf0af-4de3-4204-8da7-16c89a48b72f','2023-11-29 07:46:45.624287','0001-01-01 00:00:00.000000',1),(56,'f','f','08dbf0c1-bb01-4355-899a-273e60bf7042','2023-11-29 09:58:49.083942','0001-01-01 00:00:00.000000',1),(57,'AAAA','سسسسس','08dbf0c1-bb01-4355-899a-273e60bf7042','2023-11-30 11:26:46.302145','0001-01-01 00:00:00.000000',0),(58,'q','q','08dbf3eb-95c2-475a-8637-fad6d2a84c81','2023-12-03 10:35:54.500474','0001-01-01 00:00:00.000000',1),(59,'q','q','08dbf3eb-95c2-475a-8637-fad6d2a84c81','2023-12-03 10:35:56.067223','0001-01-01 00:00:00.000000',1),(60,'q','q','08dbf3eb-95c2-475a-8637-fad6d2a84c81','2023-12-03 10:35:59.984350','0001-01-01 00:00:00.000000',0),(61,'qqqq','qqqqqqq','08dbf3eb-95c2-475a-8637-fad6d2a84c81','2023-12-03 10:41:41.624744','0001-01-01 00:00:00.000000',0),(62,'xx','xx','08dbf3eb-95c2-475a-8637-fad6d2a84c81','2023-12-03 10:42:40.051222','0001-01-01 00:00:00.000000',0),(63,'sssssssssssss','sssssssssssssss','08dbf3eb-95c2-475a-8637-fad6d2a84c81','2023-12-03 10:44:55.391962','0001-01-01 00:00:00.000000',1),(64,'test','ttt','08dbf3eb-95c2-475a-8637-fad6d2a84c81','2023-12-03 10:46:01.791592','0001-01-01 00:00:00.000000',0),(65,'xxxx','xxxxx','08dbf3dc-bd35-40d2-8a8e-9715842156e8','2023-12-03 10:46:33.516122','0001-01-01 00:00:00.000000',0),(66,'s','sss','08dbf3dc-bd35-40d2-8a8e-9715842156e8','2023-12-03 10:46:42.807149','0001-01-01 00:00:00.000000',0),(67,'ccc','ccccc','08dbf3dc-bd35-40d2-8a8e-9715842156e8','2023-12-03 10:47:30.315765','0001-01-01 00:00:00.000000',0),(68,'test ','test ','08dbf3ef-4a07-43d0-81bd-57e4df007788','2023-12-03 11:02:33.674448','0001-01-01 00:00:00.000000',1),(69,'q1','q1','08dbf3ef-4a07-43d0-81bd-57e4df007788','2023-12-03 11:04:23.835867','0001-01-01 00:00:00.000000',0),(70,'q2','q2','08dbf3ef-4a07-43d0-81bd-57e4df007788','2023-12-03 11:11:47.469002','0001-01-01 00:00:00.000000',1),(71,'q1','q1','08dbf3f0-da66-42ae-842e-e6620c060968','2023-12-03 11:13:39.832921','0001-01-01 00:00:00.000000',0);

--
-- Table structure for table `testranges`
--

CREATE TABLE `testranges` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `From` int NOT NULL,
  `To` int NOT NULL,
  `MedicalTestId` char(36) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL,
  `ResultDescription` longtext NOT NULL,
  `ResultDescriptionAR` longtext NOT NULL,
  `IsDeleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`Id`),
  KEY `IX_TestRanges_MedicalTestId` (`MedicalTestId`),
  CONSTRAINT `FK_TestRanges_MedicalTests_MedicalTestId` FOREIGN KEY (`MedicalTestId`) REFERENCES `medicaltests` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `testranges`
--

INSERT INTO `testranges` VALUES (1,0,0,'08dbec23-202f-4bbe-8ca9-8acc3092bf55','string','string',0),(2,1,10,'08dbec23-44a6-4a03-8c6d-1fc246ff2364','test','test',0),(3,1,10,'08dbec23-d337-4b20-81a9-39b245b06b4a','tttt','tttt',0),(4,1,10,'08dbec23-db7f-4b93-812a-702bd6d31971','vvvvvvvvv','vvvvvvv',1),(5,1,10,'08dbec23-db7f-4b93-812a-702bd6d31971','vvvvvvvvv','vvvvvvv',1),(6,1,10,'08dbec25-3a8b-460f-8886-d8adab84426d','rrrr','rrrr',0),(7,1,10,'08dbec23-db7f-4b93-812a-702bd6d31971','vvvvvvvvv','vvvvvvv',1),(8,1,10,'08dbec23-db7f-4b93-812a-702bd6d31971','vvvvvvvvv','vvvvvvv',0),(9,0,7,'08dbec2b-647b-448e-894e-8fe3b3389c03','Normal','عادي',1),(10,8,13,'08dbec2b-647b-448e-894e-8fe3b3389c03','Mild Depression','اكتئاب خفيف',1),(11,14,18,'08dbec2b-647b-448e-894e-8fe3b3389c03','Moderate Depression','اكتئاب معتدل',1),(12,19,22,'08dbec2b-647b-448e-894e-8fe3b3389c03','Severe Depression','اكتئاب شديد',1),(13,23,100,'08dbec2b-647b-448e-894e-8fe3b3389c03','Very Severe Depression','اكتئاب شديد جدا ',1),(14,0,9,'08dbece9-d837-4646-8228-0c14b3cdd77a','Normal','لا يوجد اكتئاب',0),(15,10,15,'08dbece9-d837-4646-8228-0c14b3cdd77a','Mild Depression','اكتئاب بسيط',0),(16,16,23,'08dbece9-d837-4646-8228-0c14b3cdd77a','Moderate Depression','اكتئاب متوسط',0),(17,24,36,'08dbece9-d837-4646-8228-0c14b3cdd77a','Severe Depression','اكتئاب شديد',0),(18,37,1000,'08dbece9-d837-4646-8228-0c14b3cdd77a','Very Severe Depression','اكتئاب شديد جدا ',0),(19,0,7,'08dbec2b-647b-448e-894e-8fe3b3389c03','Normal','عادي',1),(20,8,13,'08dbec2b-647b-448e-894e-8fe3b3389c03','Mild Depression','اكتئاب خفيف',1),(21,14,18,'08dbec2b-647b-448e-894e-8fe3b3389c03','Moderate Depression','اكتئاب معتدل',0),(22,19,22,'08dbec2b-647b-448e-894e-8fe3b3389c03','Severe Depression','اكتئاب شديد',0),(23,23,100,'08dbec2b-647b-448e-894e-8fe3b3389c03','Very Severe Depression','اكتئاب شديد جدا ',0),(24,1,10,'08dbf0ab-d92d-4532-8a75-19e530c644f5','xxxx','xxxx',0),(25,1,11,'08dbf0af-4de3-4204-8da7-16c89a48b72f','rrrr','rrrr',0),(26,1,11,'08dbf0c1-bb01-4355-899a-273e60bf7042','tttt','ttttt',0),(27,2,2,'08dbf0c1-bb01-4355-899a-273e60bf7042','rrrrr','rrrrrrrr',1),(28,33,33,'08dbf0c1-bb01-4355-899a-273e60bf7042','ffff','ffffffff',1),(29,1,2,'08dbf3dc-9d44-4fa8-8d48-12c8bad17140','xxxx','xxxx',0),(30,1,2,'08dbf3dc-a9d5-4f11-8644-e95ca4c18366','xxxx','xxxx',0),(31,1,2,'08dbf3dc-bd35-40d2-8a8e-9715842156e8','zzzzz','zzzzz',0),(32,1,11,'08dbf3eb-95c2-475a-8637-fad6d2a84c81','zzzz','zzzz',0),(33,1,10,'08dbf3ed-2e0e-4434-8a3a-49da173801d7','xxxx','xxxx',1),(34,1,10,'08dbf3ef-4a07-43d0-81bd-57e4df007788','test ','test ',0),(35,10,20,'08dbf3ef-4a07-43d0-81bd-57e4df007788','test ','test ',1),(36,20,30,'08dbf3ef-4a07-43d0-81bd-57e4df007788','test ','test ',1),(37,30,40,'08dbf3ef-4a07-43d0-81bd-57e4df007788','test ','test ',1),(38,1,10,'08dbf3f0-da66-42ae-842e-e6620c060968','Medical Test ','Medical Test ',0),(39,10,20,'08dbf3f0-da66-42ae-842e-e6620c060968','Medical Test ','Medical Test ',0),(40,30,40,'08dbf3f0-da66-42ae-842e-e6620c060968','Medical Test ','Medical Test ',0),(41,1,10,'08dbf3fb-72f2-4b87-8adc-8d076fcf8bd4','xxxx','xxxx',0),(42,1,11,'08dbf3fb-abd7-4846-8f1e-129c291e39cd','zzzz','zzzz',0);

--
-- Table structure for table `useranswers`
--

CREATE TABLE `useranswers` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `UserTestId` int NOT NULL,
  `AnswerId` int NOT NULL,
  `QuestionId` int NOT NULL,
  PRIMARY KEY (`Id`),
  KEY `IX_UserAnswers_AnswerId` (`AnswerId`),
  KEY `IX_UserAnswers_QuestionId` (`QuestionId`),
  KEY `IX_UserAnswers_UserTestId` (`UserTestId`),
  CONSTRAINT `FK_UserAnswers_QuestionAnswers_AnswerId` FOREIGN KEY (`AnswerId`) REFERENCES `questionanswers` (`Id`) ON DELETE CASCADE,
  CONSTRAINT `FK_UserAnswers_TestQuestions_QuestionId` FOREIGN KEY (`QuestionId`) REFERENCES `testquestions` (`Id`) ON DELETE CASCADE,
  CONSTRAINT `FK_UserAnswers_UserResults_UserTestId` FOREIGN KEY (`UserTestId`) REFERENCES `userresults` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=201 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `useranswers`
--

INSERT INTO `useranswers` VALUES (1,1,27,6),(2,1,30,7),(3,1,35,8),(4,2,27,6),(5,1,39,9),(6,1,43,10),(7,2,30,7),(8,1,45,11),(9,2,35,8),(10,1,54,13),(11,2,39,9),(12,1,64,15),(13,1,70,16),(14,2,43,10),(15,1,74,17),(16,2,45,11),(17,1,76,18),(18,2,54,13),(19,1,82,19),(20,2,64,15),(21,1,87,21),(22,2,70,16),(23,1,90,22),(24,2,74,17),(25,1,96,23),(26,2,76,18),(27,1,99,24),(28,2,82,19),(29,1,101,25),(30,2,87,21),(31,1,107,27),(32,2,90,22),(33,1,114,28),(34,2,96,23),(35,1,124,30),(36,2,99,24),(37,1,126,31),(38,2,101,25),(39,2,107,27),(40,2,114,28),(41,2,124,30),(42,2,126,31),(43,3,25,6),(44,3,30,7),(45,3,36,8),(46,3,40,9),(47,3,43,10),(48,3,46,11),(49,3,53,13),(50,3,64,15),(51,3,68,16),(52,3,71,17),(53,3,79,18),(54,3,82,19),(55,3,87,21),(56,3,91,22),(57,3,93,23),(58,3,98,24),(59,3,103,25),(60,3,107,27),(61,3,110,28),(62,3,120,30),(63,3,126,31),(64,4,24,6),(65,4,29,7),(66,4,34,8),(67,4,39,9),(68,4,42,10),(69,4,45,11),(70,4,53,13),(71,4,63,15),(72,4,68,16),(73,4,71,17),(74,4,76,18),(75,4,81,19),(76,4,87,21),(77,4,90,22),(78,4,93,23),(79,4,98,24),(80,4,101,25),(81,4,107,27),(82,4,110,28),(83,4,120,30),(84,4,125,31),(85,5,129,32),(86,6,26,6),(87,6,30,7),(88,6,37,8),(89,6,40,9),(90,6,42,10),(91,6,45,11),(92,6,54,13),(93,6,63,15),(94,6,69,16),(95,6,74,17),(96,6,76,18),(97,6,81,19),(98,6,87,21),(99,6,90,22),(100,6,94,23),(101,6,98,24),(102,6,101,25),(103,6,107,27),(104,6,114,28),(105,6,120,30),(106,6,126,31),(107,7,130,32),(108,7,133,33),(109,7,139,34),(110,7,141,35),(111,7,145,36),(112,7,151,37),(113,7,154,38),(114,7,158,39),(115,7,161,40),(116,7,165,41),(117,8,129,32),(118,8,134,33),(119,8,138,34),(120,8,141,35),(121,8,144,36),(122,8,148,37),(123,8,152,38),(124,8,158,39),(125,8,160,40),(126,8,164,41),(127,8,168,42),(128,8,174,43),(129,8,180,45),(130,8,186,46),(131,8,188,47),(132,8,192,48),(133,8,196,49),(134,8,200,50),(135,8,204,51),(136,8,208,52),(137,8,214,53),(138,9,129,32),(139,9,132,33),(140,9,137,34),(141,9,140,35),(142,9,144,36),(143,9,151,37),(144,9,152,38),(145,9,156,39),(146,9,163,40),(147,9,164,41),(148,9,171,42),(149,9,172,43),(150,9,176,44),(151,9,184,46),(152,9,190,47),(153,9,195,48),(154,9,196,49),(155,9,200,50),(156,9,205,51),(157,9,208,52),(158,9,212,53),(159,10,128,32),(160,10,132,33),(161,10,136,34),(162,10,140,35),(163,10,146,36),(164,10,151,37),(165,10,152,38),(166,10,156,39),(167,10,160,40),(168,10,164,41),(169,10,171,42),(170,10,172,43),(171,10,176,44),(172,10,184,46),(173,10,188,47),(174,10,195,48),(175,10,196,49),(176,10,200,50),(177,10,205,51),(178,10,208,52),(179,10,212,53),(180,11,128,32),(181,11,132,33),(182,11,137,34),(183,11,141,35),(184,11,144,36),(185,11,149,37),(186,11,153,38),(187,11,157,39),(188,11,160,40),(189,11,164,41),(190,11,171,42),(191,11,172,43),(192,11,176,44),(193,11,184,46),(194,11,188,47),(195,11,192,48),(196,11,197,49),(197,11,200,50),(198,11,204,51),(199,11,208,52),(200,11,212,53);

--
-- Table structure for table `userresults`
--

CREATE TABLE `userresults` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `CreateDate` datetime(6) NOT NULL DEFAULT '0001-01-01 00:00:00.000000',
  `Email` longtext NOT NULL,
  `Score` int NOT NULL DEFAULT '0',
  `TestId` char(36) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  `UserId` longtext,
  PRIMARY KEY (`Id`),
  KEY `IX_UserResults_TestId` (`TestId`),
  CONSTRAINT `FK_UserResults_MedicalTests_TestId` FOREIGN KEY (`TestId`) REFERENCES `medicaltests` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `userresults`
--

INSERT INTO `userresults` VALUES (1,'2023-11-23 16:17:45.301345','motazsiam@gmail.com',27,'08dbec2b-647b-448e-894e-8fe3b3389c03',NULL),(2,'2023-11-23 16:17:45.285945','motazsiam@gmail.com',27,'08dbec2b-647b-448e-894e-8fe3b3389c03',NULL),(3,'2023-11-24 12:30:47.372716','moganomos@gmail.com',16,'08dbec2b-647b-448e-894e-8fe3b3389c03',NULL),(4,'2023-11-24 12:36:32.630133','hareef9@hotmail.com',0,'08dbec2b-647b-448e-894e-8fe3b3389c03',NULL),(5,'2023-11-24 12:49:52.697228','motazsiam@gmail.com',1,'08dbece9-d837-4646-8228-0c14b3cdd77a',NULL),(6,'2023-11-24 12:53:03.874833','motazsiam@gmail.com',18,'08dbec2b-647b-448e-894e-8fe3b3389c03',NULL),(7,'2023-11-24 13:23:57.944777','motazsiam@gmail.com',17,'08dbece9-d837-4646-8228-0c14b3cdd77a',NULL),(8,'2023-11-24 14:53:49.498607','miroosalih@gmail.com',14,'08dbece9-d837-4646-8228-0c14b3cdd77a',NULL),(9,'2023-12-05 08:12:52.572436','mohamed.g@nxt-level.co',17,'08dbece9-d837-4646-8228-0c14b3cdd77a',NULL),(10,'2023-12-05 10:57:11.354311','mutaz.s@nxt-level.co',12,'08dbece9-d837-4646-8228-0c14b3cdd77a',NULL),(11,'2023-12-05 11:06:15.477540','tazykaharaba2@gmail.com',9,'08dbece9-d837-4646-8228-0c14b3cdd77a',NULL);

--
-- Table structure for table `weekschedules`
--

CREATE TABLE `weekschedules` (
  `Id` int NOT NULL AUTO_INCREMENT,
  `DoctorId` varchar(255) NOT NULL,
  `DayNumber` int NOT NULL,
  `Hour` int NOT NULL,
  `Minute` int NOT NULL,
  `MinutesDuration` int NOT NULL,
  `IsDeleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `IX_WeekSchedules_DoctorId_DayNumber_Hour_IsDeleted` (`DoctorId`,`DayNumber`,`Hour`,`IsDeleted`),
  CONSTRAINT `FK_WeekSchedules_AspNetUsers_DoctorId` FOREIGN KEY (`DoctorId`) REFERENCES `aspnetusers` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `weekschedules`
--



