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

START TRANSACTION;



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

--
-- Table structure for table `appointments`
--

CREATE TABLE `appointments` (
  `id` int(11) NOT NULL,
  `patient_id` int(11) DEFAULT NULL,
  `date_of_request` date NOT NULL,
  `phone` varchar(20) NOT NULL,
  `status` enum('Pending','Confirmed','Canceled') NOT NULL DEFAULT 'Pending',
  `appointment_date` datetime DEFAULT NULL,
  `meeting_type` enum('Face to face','Online') NOT NULL,
  `guest_name` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `appointments`
--

INSERT INTO `appointments` (`id`, `patient_id`, `date_of_request`, `phone`, `status`, `appointment_date`, `meeting_type`, `guest_name`) VALUES
(1, 3, '2021-01-10', '0231516', 'Canceled', '2021-01-11 14:50:00', 'Face to face', NULL),
(2, 2, '2021-02-07', '0992556654', 'Pending', '2021-01-10 00:00:00', 'Face to face', NULL),
(8, NULL, '2021-02-07', '0992556654', 'Pending', NULL, 'Online', 'Ali Ahmad'),
(11, NULL, '2021-03-11', '0992556658', 'Pending', NULL, 'Face to face', 'Ahmad Ali'),
(13, NULL, '2021-02-08', '0992556654', 'Confirmed', '2021-03-13 00:00:00', 'Online', 'dalal ahmad'),
(14, NULL, '2021-02-08', '0992556654', 'Pending', '2021-03-12 00:00:00', 'Online', 'dalal ahmad'),
(21, NULL, '2021-02-08', '0992556654', 'Pending', '2021-03-10 00:00:00', 'Face to face', 'nada yusuf'),
(23, NULL, '2021-02-08', '0992556654', 'Pending', NULL, 'Online', 'dalal yusuf'),
(24, NULL, '2021-02-11', '0992556654', 'Pending', NULL, 'Online', 'Dalal Yusuf'),
(25, NULL, '2021-02-17', '0992556654', 'Pending', NULL, 'Face to face', 'Dalal Yusuf'),
(26, NULL, '2021-02-17', '0992556654', 'Pending', NULL, 'Face to face', 'Dalal Yusuf'),
(27, 3, '2021-02-25', '+963992556', 'Pending', NULL, 'Online', NULL),
(28, 3, '2021-02-25', '+963992556', 'Pending', NULL, 'Online', NULL),
(29, 3, '2021-02-25', '+963992556', 'Pending', NULL, 'Online', NULL),
(30, 3, '2021-02-25', '+963992556', 'Confirmed', '2021-04-12 14:50:00', 'Online', NULL),
(31, 3, '2021-02-25', '+963992556', 'Canceled', '2021-03-25 05:50:00', 'Online', NULL),
(32, 3, '2021-02-25', '+963992556', 'Canceled', NULL, 'Face to face', NULL),
(33, 3, '2021-02-25', '+963992556', 'Canceled', '2021-03-26 07:30:00', 'Online', NULL),
(34, NULL, '2021-02-25', '096325841', 'Pending', NULL, 'Online', 'غاخاخاخا ةنىنىنىن'),
(35, 3, '2021-02-25', '+958451541', 'Canceled', '2021-01-11 14:50:00', 'Online', NULL),
(36, 3, '2021-02-25', '+958451541', 'Pending', NULL, 'Face to face', NULL),
(37, 3, '2021-02-25', '+958451541', 'Pending', NULL, 'Online', NULL),
(38, 3, '2021-02-25', '+958451541', 'Pending', NULL, 'Online', NULL),
(39, 3, '2021-03-01', '+958451541', 'Pending', NULL, 'Face to face', NULL),
(40, 3, '2021-03-01', '+958451541', 'Pending', NULL, 'Face to face', NULL),
(41, 3, '2021-03-01', '+958451541', 'Pending', NULL, 'Face to face', NULL),
(42, 3, '2021-03-01', '+958451541', 'Pending', NULL, 'Online', NULL),
(43, 3, '2021-03-22', '0992556654', 'Pending', '2021-03-23 00:00:00', 'Face to face', NULL),
(46, NULL, '2021-03-22', '0992556654', 'Pending', '2021-03-24 00:00:00', 'Online', 'Salma Ali'),
(49, NULL, '2021-03-22', '0992556654', 'Confirmed', '2021-03-31 06:30:00', 'Face to face', 'Salma Ali'),
(50, 3, '2021-03-22', '0992556654', 'Confirmed', '2021-03-16 14:50:00', 'Face to face', NULL),
(51, 3, '2021-03-23', '0992556654', 'Confirmed', '2021-03-27 15:50:00', 'Face to face', NULL),
(55, 3, '2021-03-24', '0992556654', 'Confirmed', '0000-00-00 00:00:00', 'Face to face', NULL),
(56, 3, '2021-03-24', '0992556654', 'Confirmed', '2021-05-07 10:30:27', 'Face to face', NULL),
(57, 3, '2021-03-24', '0992556654', 'Confirmed', '2021-05-14 03:35:56', 'Online', NULL),
(59, 3, '2021-03-25', '0992556654', 'Confirmed', '2021-05-07 11:35:06', 'Face to face', NULL),
(60, 3, '2021-03-25', '0992556654', 'Canceled', '2021-04-16 10:35:06', 'Face to face', NULL),
(61, 3, '2021-04-05', '0958451541', 'Confirmed', '2021-03-26 11:30:00', 'Face to face', NULL),
(62, NULL, '2021-04-01', '0992556654', 'Pending', NULL, 'Online', 'Dalal Yusuf'),
(63, NULL, '2021-04-01', '0992556654', 'Pending', NULL, 'Online', 'Dalal Yusuf'),
(64, NULL, '2021-04-01', '0992556654', 'Pending', NULL, 'Face to face', 'Ali Yusuf'),
(65, NULL, '2021-04-01', '0992556654', 'Pending', NULL, 'Online', 'Amer Ali'),
(66, NULL, '2021-04-01', '0953486585', 'Pending', NULL, 'Online', 'Ali Ahmad'),
(67, NULL, '2021-04-01', '0992555624', 'Pending', NULL, 'Online', 'Salma Ali'),
(68, NULL, '2021-04-01', '0955656535', 'Pending', NULL, 'Face to face', 'Ali Ali'),
(69, NULL, '2021-04-01', '0995356865', 'Pending', NULL, 'Online', 'admin admin'),
(70, NULL, '2021-04-01', '0952842', 'Pending', NULL, 'Online', 'bibhib nibu'),
(71, NULL, '2021-04-01', '0963258', 'Pending', NULL, 'Face to face', 'ibibi h8hoh'),
(72, NULL, '2021-04-01', '0963258', 'Pending', NULL, 'Face to face', 'jonon bibi'),
(73, 3, '2021-04-01', '0958451541', 'Pending', NULL, 'Online', NULL),
(74, 3, '2021-04-26', '0992556654', 'Confirmed', '2021-04-27 02:30:51', 'Face to face', NULL),
(75, 3, '2021-04-26', '0992556654', 'Confirmed', '2021-04-27 10:15:20', 'Face to face', NULL),
(76, 3, '2021-04-29', '0992556', 'Confirmed', '2021-05-01 15:30:00', 'Face to face', NULL),
(77, 3, '2021-05-02', '0992556', 'Confirmed', '2021-05-04 10:50:00', 'Online', NULL),
(78, NULL, '2021-05-03', '094464474', 'Confirmed', NULL, 'Online', 'akfk bdhd'),
(79, NULL, '2021-05-03', '093737377', 'Pending', NULL, 'Face to face', 'Ali Ali'),
(80, 3, '2021-06-06', '+963992556659', 'Canceled', '2021-06-26 11:25:46', 'Face to face', NULL),
(81, NULL, '2021-06-06', '+963992556659', 'Confirmed', '2021-06-29 01:50:08', 'Face to face', 'Ali Ali'),
(82, 3, '2022-03-14', '', 'Canceled', '2022-03-30 03:35:18', 'Face to face', NULL),
(83, 4, '2022-03-14', '0958451541', 'Confirmed', '2022-03-30 03:35:18', 'Online', NULL),
(84, 15, '2022-06-02', '+963933269044', 'Confirmed', '2022-06-02 03:00:00', 'Online', NULL),
(85, 24, '2022-06-17', '00963933269044', 'Confirmed', '2022-06-28 12:30:17', 'Online', NULL);

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

--
-- Table structure for table `appointments_management`
--

CREATE TABLE `appointments_management` (
  `id` int(11) NOT NULL,
  `status` enum('Active','Inactive') DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `appointments_management`
--

INSERT INTO `appointments_management` (`id`, `status`, `start_date`, `end_date`) VALUES
(2, 'Active', '2021-03-24', '2021-03-31'),
(4, 'Active', '2021-03-25', '2021-04-16'),
(5, 'Active', '2021-05-04', '2021-05-06'),
(6, 'Active', '2021-06-13', '2021-06-23'),
(7, 'Active', '2022-03-16', '2022-03-20');

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

--
-- Table structure for table `body_measures`
--

CREATE TABLE `body_measures` (
  `id` int(11) NOT NULL,
  `body_measure` varchar(100) NOT NULL,
  `status` enum('Active','Inactive') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `body_measures`
--

INSERT INTO `body_measures` (`id`, `body_measure`, `status`) VALUES
(6, 'HT', 'Active'),
(7, 'WT', 'Active'),
(8, 'Body Fat mass %', 'Active'),
(9, 'Body muscle Mass %', 'Active'),
(10, 'Visceral Fat', 'Inactive'),
(11, 'RM', 'Inactive'),
(12, 'WT 5 years ago', 'Inactive'),
(13, 'BFM', 'Inactive'),
(14, 'Arm circ', 'Inactive'),
(15, 'Breast circ', 'Inactive'),
(16, 'Thigh circ', 'Inactive'),
(17, 'Waste circ', 'Inactive'),
(19, 'BMI', 'Active'),
(22, 'Basic measure', 'Inactive'),
(23, 'Weight goal', 'Active'),
(25, 'new body measure', 'Inactive'),
(26, 'new measure', 'Inactive');

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

--
-- Table structure for table `calorie_plans`
--

CREATE TABLE `calorie_plans` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `standard_cho` int(11) NOT NULL,
  `standard_protein` int(11) NOT NULL,
  `standard_fat` int(11) NOT NULL,
  `allowed_cho` float(11,2) NOT NULL,
  `allowed_protein` float(11,2) NOT NULL,
  `allowed_fat` float(11,2) NOT NULL,
  `status` enum('Active','Inactive') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `calorie_plans`
--

INSERT INTO `calorie_plans` (`id`, `name`, `standard_cho`, `standard_protein`, `standard_fat`, `allowed_cho`, `allowed_protein`, `allowed_fat`, `status`) VALUES
(1, 'Plan 1', 0, 0, 0, 0.00, 0.00, 0.00, 'Inactive'),
(2, '1000 cal', 50, 20, 30, 54.62, 20.77, 25.10, 'Active'),
(3, 'XYZ', 2, 2, 2, 2.00, 2.00, 2.00, 'Inactive'),
(4, '2200 cal plan', 8, 9, 9, 5.00, 2.00, 5.00, 'Active'),
(5, '2800 cal plan', 9, 7, 8, 5.00, 4.00, 6.00, 'Active'),
(6, 'New Plan', 4, 3, 4, 4.00, 4.00, 4.00, 'Active'),
(7, 'New Plan1', 26, 22, 34, 13.00, 35.00, 27.00, 'Active'),
(8, '1300 (Low Fat Milk)', 50, 20, 30, 51.40, 18.49, 30.00, 'Active'),
(9, '1300 ( Skimmed Fat Milk) ', 50, 20, 30, 58.83, 18.65, 26.39, 'Active'),
(10, '1500 ', 50, 20, 30, 50.40, 19.47, 29.40, 'Active'),
(11, '1800', 50, 20, 30, 49.37, 20.06, 29.75, 'Active'),
(12, '2000 (Skimmed Milk)', 0, 0, 0, 49.19, 19.75, 29.78, 'Active'),
(13, '2200 (Skimmed Milk)', 50, 20, 30, 49.62, 20.13, 28.72, 'Active'),
(14, '2400 (Skimmed Milk)', 50, 20, 30, 50.97, 18.31, 29.32, 'Active');

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

--
-- Table structure for table `calorie_plans_properties`
--

CREATE TABLE `calorie_plans_properties` (
  `id` int(11) NOT NULL,
  `calorie_plan_id` int(11) NOT NULL,
  `ingredient_category` int(11) NOT NULL,
  `nutritional_value` int(11) NOT NULL,
  `value` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `calorie_plans_properties`
--

INSERT INTO `calorie_plans_properties` (`id`, `calorie_plan_id`, `ingredient_category`, `nutritional_value`, `value`) VALUES
(56, 2, 1, 1, 7),
(57, 2, 1, 2, 105),
(58, 2, 1, 3, 14),
(59, 2, 1, 4, 7),
(60, 2, 1, 5, 560),
(61, 2, 2, 1, 3),
(62, 2, 2, 2, 45),
(63, 2, 2, 3, 0),
(64, 2, 2, 4, 0),
(65, 2, 2, 5, 180),
(66, 2, 3, 1, 2),
(67, 2, 3, 2, 30),
(68, 2, 3, 3, 0),
(69, 2, 3, 4, 0),
(70, 2, 3, 5, 120),
(71, 2, 4, 1, 7),
(72, 2, 4, 2, 35),
(73, 2, 4, 3, 14),
(74, 2, 4, 4, 0),
(75, 2, 4, 5, 175),
(76, 2, 5, 1, 0),
(77, 2, 5, 2, 0),
(78, 2, 5, 3, 0),
(79, 2, 5, 4, 0),
(80, 2, 5, 5, 0),
(81, 2, 6, 1, 2),
(82, 2, 6, 2, 24),
(83, 2, 6, 3, 16),
(84, 2, 6, 4, 10),
(85, 2, 6, 5, 240),
(86, 2, 7, 1, 0),
(87, 2, 7, 2, 0),
(88, 2, 7, 3, 0),
(89, 2, 7, 4, 0),
(90, 2, 7, 5, 0),
(91, 2, 8, 1, 0),
(92, 2, 8, 2, 0),
(93, 2, 8, 3, 0),
(94, 2, 8, 4, 0),
(95, 2, 8, 5, 0),
(96, 2, 9, 1, 6),
(97, 2, 9, 2, 0),
(98, 2, 9, 3, 42),
(99, 2, 9, 4, 30),
(100, 2, 9, 5, 450),
(101, 2, 10, 1, 0),
(102, 2, 10, 2, 0),
(103, 2, 10, 3, 0),
(104, 2, 10, 4, 0),
(105, 2, 10, 5, 0),
(106, 2, 11, 1, 3),
(107, 2, 11, 2, 0),
(108, 2, 11, 3, 0),
(109, 2, 11, 4, 15),
(110, 2, 11, 5, 135),
(111, 3, 1, 1, 7),
(112, 3, 1, 2, 105),
(113, 3, 1, 3, 14),
(114, 3, 1, 4, 7),
(115, 3, 1, 5, 560),
(116, 3, 2, 1, 3),
(117, 3, 2, 2, 45),
(118, 3, 2, 3, 0),
(119, 3, 2, 4, 0),
(120, 3, 2, 5, 180),
(121, 3, 3, 1, 2),
(122, 3, 3, 2, 30),
(123, 3, 3, 3, 0),
(124, 3, 3, 4, 0),
(125, 3, 3, 5, 120),
(126, 3, 4, 1, 7),
(127, 3, 4, 2, 35),
(128, 3, 4, 3, 14),
(129, 3, 4, 4, 0),
(130, 3, 4, 5, 175),
(131, 3, 5, 1, 0),
(132, 3, 5, 2, 0),
(133, 3, 5, 3, 0),
(134, 3, 5, 4, 0),
(135, 3, 5, 5, 0),
(136, 3, 6, 1, 2),
(137, 3, 6, 2, 24),
(138, 3, 6, 3, 16),
(139, 3, 6, 4, 10),
(140, 3, 6, 5, 240),
(141, 3, 7, 1, 0),
(142, 3, 7, 2, 0),
(143, 3, 7, 3, 0),
(144, 3, 7, 4, 0),
(145, 3, 7, 5, 0),
(146, 3, 8, 1, 0),
(147, 3, 8, 2, 0),
(148, 3, 8, 3, 0),
(149, 3, 8, 4, 0),
(150, 3, 8, 5, 0),
(151, 3, 9, 1, 6),
(152, 3, 9, 2, 0),
(153, 3, 9, 3, 42),
(154, 3, 9, 4, 30),
(155, 3, 9, 5, 450),
(156, 3, 10, 1, 0),
(157, 3, 10, 2, 0),
(158, 3, 10, 3, 0),
(159, 3, 10, 4, 0),
(160, 3, 10, 5, 0),
(161, 3, 11, 1, 3),
(162, 3, 11, 2, 0),
(163, 3, 11, 3, 0),
(164, 3, 11, 4, 15),
(165, 3, 11, 5, 135),
(166, 4, 1, 1, 7),
(167, 4, 1, 2, 105),
(168, 4, 1, 3, 14),
(169, 4, 1, 4, 7),
(170, 4, 1, 5, 560),
(171, 4, 2, 1, 3),
(172, 4, 2, 2, 45),
(173, 4, 2, 3, 0),
(174, 4, 2, 4, 0),
(175, 4, 2, 5, 180),
(176, 4, 3, 1, 2),
(177, 4, 3, 2, 30),
(178, 4, 3, 3, 0),
(179, 4, 3, 4, 0),
(180, 4, 3, 5, 120),
(181, 4, 4, 1, 7),
(182, 4, 4, 2, 35),
(183, 4, 4, 3, 14),
(184, 4, 4, 4, 0),
(185, 4, 4, 5, 175),
(186, 4, 5, 1, 0),
(187, 4, 5, 2, 0),
(188, 4, 5, 3, 0),
(189, 4, 5, 4, 0),
(190, 4, 5, 5, 0),
(191, 4, 6, 1, 2),
(192, 4, 6, 2, 24),
(193, 4, 6, 3, 16),
(194, 4, 6, 4, 10),
(195, 4, 6, 5, 240),
(196, 4, 7, 1, 0),
(197, 4, 7, 2, 0),
(198, 4, 7, 3, 0),
(199, 4, 7, 4, 0),
(200, 4, 7, 5, 0),
(201, 4, 8, 1, 0),
(202, 4, 8, 2, 0),
(203, 4, 8, 3, 0),
(204, 4, 8, 4, 0),
(205, 4, 8, 5, 0),
(206, 4, 9, 1, 6),
(207, 4, 9, 2, 0),
(208, 4, 9, 3, 42),
(209, 4, 9, 4, 30),
(210, 4, 9, 5, 450),
(211, 4, 10, 1, 0),
(212, 4, 10, 2, 0),
(213, 4, 10, 3, 0),
(214, 4, 10, 4, 0),
(215, 4, 10, 5, 0),
(216, 4, 11, 1, 3),
(217, 4, 11, 2, 0),
(218, 4, 11, 3, 0),
(219, 4, 11, 4, 15),
(220, 4, 11, 5, 135),
(221, 5, 1, 1, 7),
(222, 5, 1, 2, 105),
(223, 5, 1, 3, 14),
(224, 5, 1, 4, 7),
(225, 5, 1, 5, 560),
(226, 5, 2, 1, 3),
(227, 5, 2, 2, 45),
(228, 5, 2, 3, 0),
(229, 5, 2, 4, 0),
(230, 5, 2, 5, 180),
(231, 5, 3, 1, 2),
(232, 5, 3, 2, 30),
(233, 5, 3, 3, 0),
(234, 5, 3, 4, 0),
(235, 5, 3, 5, 120),
(236, 5, 4, 1, 7),
(237, 5, 4, 2, 35),
(238, 5, 4, 3, 14),
(239, 5, 4, 4, 0),
(240, 5, 4, 5, 175),
(241, 5, 5, 1, 0),
(242, 5, 5, 2, 0),
(243, 5, 5, 3, 0),
(244, 5, 5, 4, 0),
(245, 5, 5, 5, 0),
(246, 5, 6, 1, 2),
(247, 5, 6, 2, 24),
(248, 5, 6, 3, 16),
(249, 5, 6, 4, 10),
(250, 5, 6, 5, 240),
(251, 5, 7, 1, 0),
(252, 5, 7, 2, 0),
(253, 5, 7, 3, 0),
(254, 5, 7, 4, 0),
(255, 5, 7, 5, 0),
(256, 5, 8, 1, 0),
(257, 5, 8, 2, 0),
(258, 5, 8, 3, 0),
(259, 5, 8, 4, 0),
(260, 5, 8, 5, 0),
(261, 5, 9, 1, 6),
(262, 5, 9, 2, 0),
(263, 5, 9, 3, 42),
(264, 5, 9, 4, 30),
(265, 5, 9, 5, 450),
(266, 5, 10, 1, 0),
(267, 5, 10, 2, 0),
(268, 5, 10, 3, 0),
(269, 5, 10, 4, 0),
(270, 5, 10, 5, 0),
(271, 5, 11, 1, 3),
(272, 5, 11, 2, 0),
(273, 5, 11, 3, 0),
(274, 5, 11, 4, 15),
(275, 5, 11, 5, 135),
(276, 6, 1, 1, 7),
(277, 6, 1, 2, 105),
(278, 6, 1, 3, 14),
(279, 6, 1, 4, 7),
(280, 6, 1, 5, 560),
(281, 6, 2, 1, 3),
(282, 6, 2, 2, 45),
(283, 6, 2, 3, 0),
(284, 6, 2, 4, 0),
(285, 6, 2, 5, 180),
(286, 6, 3, 1, 2),
(287, 6, 3, 2, 30),
(288, 6, 3, 3, 0),
(289, 6, 3, 4, 0),
(290, 6, 3, 5, 120),
(291, 6, 4, 1, 7),
(292, 6, 4, 2, 35),
(293, 6, 4, 3, 14),
(294, 6, 4, 4, 0),
(295, 6, 4, 5, 175),
(296, 6, 5, 1, 0),
(297, 6, 5, 2, 0),
(298, 6, 5, 3, 0),
(299, 6, 5, 4, 0),
(300, 6, 5, 5, 0),
(301, 6, 6, 1, 2),
(302, 6, 6, 2, 24),
(303, 6, 6, 3, 16),
(304, 6, 6, 4, 10),
(305, 6, 6, 5, 240),
(306, 6, 7, 1, 0),
(307, 6, 7, 2, 0),
(308, 6, 7, 3, 0),
(309, 6, 7, 4, 0),
(310, 6, 7, 5, 0),
(311, 6, 8, 1, 0),
(312, 6, 8, 2, 0),
(313, 6, 8, 3, 0),
(314, 6, 8, 4, 0),
(315, 6, 8, 5, 0),
(316, 6, 9, 1, 6),
(317, 6, 9, 2, 0),
(318, 6, 9, 3, 42),
(319, 6, 9, 4, 30),
(320, 6, 9, 5, 450),
(321, 6, 10, 1, 0),
(322, 6, 10, 2, 0),
(323, 6, 10, 3, 0),
(324, 6, 10, 4, 0),
(325, 6, 10, 5, 0),
(326, 6, 11, 1, 3),
(327, 6, 11, 2, 0),
(328, 6, 11, 3, 0),
(329, 6, 11, 4, 15),
(330, 6, 11, 5, 135),
(331, 7, 1, 1, 7),
(332, 7, 1, 2, 105),
(333, 7, 1, 3, 14),
(334, 7, 1, 4, 7),
(335, 7, 1, 5, 560),
(336, 7, 2, 1, 3),
(337, 7, 2, 2, 45),
(338, 7, 2, 3, 0),
(339, 7, 2, 4, 0),
(340, 7, 2, 5, 180),
(341, 7, 3, 1, 2),
(342, 7, 3, 2, 30),
(343, 7, 3, 3, 0),
(344, 7, 3, 4, 0),
(345, 7, 3, 5, 120),
(346, 7, 4, 1, 7),
(347, 7, 4, 2, 35),
(348, 7, 4, 3, 14),
(349, 7, 4, 4, 0),
(350, 7, 4, 5, 175),
(351, 7, 5, 1, 0),
(352, 7, 5, 2, 0),
(353, 7, 5, 3, 0),
(354, 7, 5, 4, 0),
(355, 7, 5, 5, 0),
(356, 7, 6, 1, 2),
(357, 7, 6, 2, 24),
(358, 7, 6, 3, 16),
(359, 7, 6, 4, 10),
(360, 7, 6, 5, 240),
(361, 7, 7, 1, 0),
(362, 7, 7, 2, 0),
(363, 7, 7, 3, 0),
(364, 7, 7, 4, 0),
(365, 7, 7, 5, 0),
(366, 7, 8, 1, 0),
(367, 7, 8, 2, 0),
(368, 7, 8, 3, 0),
(369, 7, 8, 4, 0),
(370, 7, 8, 5, 0),
(371, 7, 9, 1, 6),
(372, 7, 9, 2, 0),
(373, 7, 9, 3, 42),
(374, 7, 9, 4, 30),
(375, 7, 9, 5, 450),
(376, 7, 10, 1, 0),
(377, 7, 10, 2, 0),
(378, 7, 10, 3, 0),
(379, 7, 10, 4, 0),
(380, 7, 10, 5, 0),
(381, 7, 11, 1, 3),
(382, 7, 11, 2, 0),
(383, 7, 11, 3, 0),
(384, 7, 11, 4, 15),
(385, 7, 11, 5, 135),
(386, 8, 1, 1, 7),
(387, 8, 1, 2, 105),
(388, 8, 1, 3, 14),
(389, 8, 1, 4, 7),
(390, 8, 1, 5, 560),
(391, 8, 2, 1, 3),
(392, 8, 2, 2, 45),
(393, 8, 2, 3, 0),
(394, 8, 2, 4, 0),
(395, 8, 2, 5, 180),
(396, 8, 3, 1, 2),
(397, 8, 3, 2, 30),
(398, 8, 3, 3, 0),
(399, 8, 3, 4, 0),
(400, 8, 3, 5, 120),
(401, 8, 4, 1, 7),
(402, 8, 4, 2, 35),
(403, 8, 4, 3, 14),
(404, 8, 4, 4, 0),
(405, 8, 4, 5, 175),
(406, 8, 5, 1, 0),
(407, 8, 5, 2, 0),
(408, 8, 5, 3, 0),
(409, 8, 5, 4, 0),
(410, 8, 5, 5, 0),
(411, 8, 6, 1, 2),
(412, 8, 6, 2, 24),
(413, 8, 6, 3, 16),
(414, 8, 6, 4, 10),
(415, 8, 6, 5, 240),
(416, 8, 7, 1, 0),
(417, 8, 7, 2, 0),
(418, 8, 7, 3, 0),
(419, 8, 7, 4, 0),
(420, 8, 7, 5, 0),
(421, 8, 8, 1, 0),
(422, 8, 8, 2, 0),
(423, 8, 8, 3, 0),
(424, 8, 8, 4, 0),
(425, 8, 8, 5, 0),
(426, 8, 9, 1, 6),
(427, 8, 9, 2, 0),
(428, 8, 9, 3, 42),
(429, 8, 9, 4, 30),
(430, 8, 9, 5, 450),
(431, 8, 10, 1, 0),
(432, 8, 10, 2, 0),
(433, 8, 10, 3, 0),
(434, 8, 10, 4, 0),
(435, 8, 10, 5, 0),
(436, 8, 11, 1, 3),
(437, 8, 11, 2, 0),
(438, 8, 11, 3, 0),
(439, 8, 11, 4, 15),
(440, 8, 11, 5, 135),
(441, 9, 1, 1, 5),
(442, 9, 1, 2, 75),
(443, 9, 1, 3, 10),
(444, 9, 1, 4, 5),
(445, 9, 1, 5, 400),
(446, 9, 2, 1, 2),
(447, 9, 2, 2, 30),
(448, 9, 2, 3, 0),
(449, 9, 2, 4, 0),
(450, 9, 2, 5, 120),
(451, 9, 3, 1, 2),
(452, 9, 3, 2, 30),
(453, 9, 3, 3, 0),
(454, 9, 3, 4, 0),
(455, 9, 3, 5, 120),
(456, 9, 4, 1, 4),
(457, 9, 4, 2, 20),
(458, 9, 4, 3, 8),
(459, 9, 4, 4, 0),
(460, 9, 4, 5, 100),
(461, 9, 5, 1, 2),
(462, 9, 5, 2, 24),
(463, 9, 5, 3, 16),
(464, 9, 5, 4, 4),
(465, 9, 5, 5, 200),
(466, 9, 6, 1, 0),
(467, 9, 6, 2, 0),
(468, 9, 6, 3, 0),
(469, 9, 6, 4, 0),
(470, 9, 6, 5, 0),
(471, 9, 7, 1, 0),
(472, 9, 7, 2, 0),
(473, 9, 7, 3, 0),
(474, 9, 7, 4, 0),
(475, 9, 7, 5, 0),
(476, 9, 8, 1, 0),
(477, 9, 8, 2, 0),
(478, 9, 8, 3, 0),
(479, 9, 8, 4, 0),
(480, 9, 8, 5, 0),
(481, 9, 9, 1, 4),
(482, 9, 9, 2, 0),
(483, 9, 9, 3, 28),
(484, 9, 9, 4, 20),
(485, 9, 9, 5, 300),
(486, 9, 10, 1, 0),
(487, 9, 10, 2, 0),
(488, 9, 10, 3, 0),
(489, 9, 10, 4, 0),
(490, 9, 10, 5, 0),
(491, 9, 11, 1, 2),
(492, 9, 11, 2, 0),
(493, 9, 11, 3, 0),
(494, 9, 11, 4, 10),
(495, 9, 11, 5, 90),
(496, 10, 1, 1, 5),
(497, 10, 1, 2, 75),
(498, 10, 1, 3, 10),
(499, 10, 1, 4, 5),
(500, 10, 1, 5, 400),
(501, 10, 2, 1, 3),
(502, 10, 2, 2, 45),
(503, 10, 2, 3, 0),
(504, 10, 2, 4, 0),
(505, 10, 2, 5, 180),
(506, 10, 3, 1, 1),
(507, 10, 3, 2, 15),
(508, 10, 3, 3, 0),
(509, 10, 3, 4, 0),
(510, 10, 3, 5, 60),
(511, 10, 4, 1, 6),
(512, 10, 4, 2, 30),
(513, 10, 4, 3, 12),
(514, 10, 4, 4, 0),
(515, 10, 4, 5, 150),
(516, 10, 5, 1, 2),
(517, 10, 5, 2, 24),
(518, 10, 5, 3, 16),
(519, 10, 5, 4, 4),
(520, 10, 5, 5, 200),
(521, 10, 6, 1, 0),
(522, 10, 6, 2, 0),
(523, 10, 6, 3, 0),
(524, 10, 6, 4, 0),
(525, 10, 6, 5, 0),
(526, 10, 7, 1, 0),
(527, 10, 7, 2, 0),
(528, 10, 7, 3, 0),
(529, 10, 7, 4, 0),
(530, 10, 7, 5, 0),
(531, 10, 8, 1, 0),
(532, 10, 8, 2, 0),
(533, 10, 8, 3, 0),
(534, 10, 8, 4, 0),
(535, 10, 8, 5, 0),
(536, 10, 9, 1, 5),
(537, 10, 9, 2, 0),
(538, 10, 9, 3, 35),
(539, 10, 9, 4, 25),
(540, 10, 9, 5, 375),
(541, 10, 10, 1, 0),
(542, 10, 10, 2, 0),
(543, 10, 10, 3, 0),
(544, 10, 10, 4, 0),
(545, 10, 10, 5, 0),
(546, 10, 11, 1, 3),
(547, 10, 11, 2, 0),
(548, 10, 11, 3, 0),
(549, 10, 11, 4, 15),
(550, 10, 11, 5, 135),
(551, 11, 1, 1, 6),
(552, 11, 1, 2, 90),
(553, 11, 1, 3, 12),
(554, 11, 1, 4, 6),
(555, 11, 1, 5, 480),
(556, 11, 2, 1, 3),
(557, 11, 2, 2, 45),
(558, 11, 2, 3, 0),
(559, 11, 2, 4, 0),
(560, 11, 2, 5, 180),
(561, 11, 3, 1, 2),
(562, 11, 3, 2, 30),
(563, 11, 3, 3, 0),
(564, 11, 3, 4, 0),
(565, 11, 3, 5, 120),
(566, 11, 4, 1, 7),
(567, 11, 4, 2, 35),
(568, 11, 4, 3, 14),
(569, 11, 4, 4, 0),
(570, 11, 4, 5, 175),
(571, 11, 5, 1, 2),
(572, 11, 5, 2, 24),
(573, 11, 5, 3, 16),
(574, 11, 5, 4, 4),
(575, 11, 5, 5, 200),
(576, 11, 6, 1, 0),
(577, 11, 6, 2, 0),
(578, 11, 6, 3, 0),
(579, 11, 6, 4, 0),
(580, 11, 6, 5, 0),
(581, 11, 7, 1, 0),
(582, 11, 7, 2, 0),
(583, 11, 7, 3, 0),
(584, 11, 7, 4, 0),
(585, 11, 7, 5, 0),
(586, 11, 8, 1, 0),
(587, 11, 8, 2, 0),
(588, 11, 8, 3, 0),
(589, 11, 8, 4, 0),
(590, 11, 8, 5, 0),
(591, 11, 9, 1, 7),
(592, 11, 9, 2, 0),
(593, 11, 9, 3, 49),
(594, 11, 9, 4, 35),
(595, 11, 9, 5, 525),
(596, 11, 10, 1, 0),
(597, 11, 10, 2, 0),
(598, 11, 10, 3, 0),
(599, 11, 10, 4, 0),
(600, 11, 10, 5, 0),
(601, 11, 11, 1, 3),
(602, 11, 11, 2, 0),
(603, 11, 11, 3, 0),
(604, 11, 11, 4, 15),
(605, 11, 11, 5, 135),
(606, 12, 1, 1, 8),
(607, 12, 1, 2, 120),
(608, 12, 1, 3, 16),
(609, 12, 1, 4, 8),
(610, 12, 1, 5, 640),
(611, 12, 2, 1, 4),
(612, 12, 2, 2, 60),
(613, 12, 2, 3, 0),
(614, 12, 2, 4, 0),
(615, 12, 2, 5, 240),
(616, 12, 3, 1, 1),
(617, 12, 3, 2, 15),
(618, 12, 3, 3, 0),
(619, 12, 3, 4, 0),
(620, 12, 3, 5, 60),
(621, 12, 4, 1, 5),
(622, 12, 4, 2, 30),
(623, 12, 4, 3, 12),
(624, 12, 4, 4, 0),
(625, 12, 4, 5, 150),
(626, 12, 5, 1, 1),
(627, 12, 5, 2, 24),
(628, 12, 5, 3, 16),
(629, 12, 5, 4, 4),
(630, 12, 5, 5, 200),
(631, 12, 6, 1, 0),
(632, 12, 6, 2, 0),
(633, 12, 6, 3, 0),
(634, 12, 6, 4, 0),
(635, 12, 6, 5, 0),
(636, 12, 7, 1, 0),
(637, 12, 7, 2, 0),
(638, 12, 7, 3, 0),
(639, 12, 7, 4, 0),
(640, 12, 7, 5, 0),
(641, 12, 8, 1, 0),
(642, 12, 8, 2, 0),
(643, 12, 8, 3, 0),
(644, 12, 8, 4, 0),
(645, 12, 8, 5, 0),
(646, 12, 9, 1, 8),
(647, 12, 9, 2, 0),
(648, 12, 9, 3, 56),
(649, 12, 9, 4, 40),
(650, 12, 9, 5, 600),
(651, 12, 10, 1, 0),
(652, 12, 10, 2, 0),
(653, 12, 10, 3, 0),
(654, 12, 10, 4, 0),
(655, 12, 10, 5, 0),
(656, 12, 11, 1, 3),
(657, 12, 11, 2, 0),
(658, 12, 11, 3, 0),
(659, 12, 11, 4, 15),
(660, 12, 11, 5, 135),
(661, 13, 1, 1, 10),
(662, 13, 1, 2, 150),
(663, 13, 1, 3, 20),
(664, 13, 1, 4, 10),
(665, 13, 1, 5, 800),
(666, 13, 2, 1, 3),
(667, 13, 2, 2, 45),
(668, 13, 2, 3, 0),
(669, 13, 2, 4, 0),
(670, 13, 2, 5, 180),
(671, 13, 3, 1, 1),
(672, 13, 3, 2, 15),
(673, 13, 3, 3, 0),
(674, 13, 3, 4, 0),
(675, 13, 3, 5, 60),
(676, 13, 4, 1, 6),
(677, 13, 4, 2, 30),
(678, 13, 4, 3, 12),
(679, 13, 4, 4, 0),
(680, 13, 4, 5, 150),
(681, 13, 5, 1, 3),
(682, 13, 5, 2, 36),
(683, 13, 5, 3, 24),
(684, 13, 5, 4, 6),
(685, 13, 5, 5, 300),
(686, 13, 6, 1, 0),
(687, 13, 6, 2, 0),
(688, 13, 6, 3, 0),
(689, 13, 6, 4, 0),
(690, 13, 6, 5, 0),
(691, 13, 7, 1, 0),
(692, 13, 7, 2, 0),
(693, 13, 7, 3, 0),
(694, 13, 7, 4, 0),
(695, 13, 7, 5, 0),
(696, 13, 8, 1, 0),
(697, 13, 8, 2, 0),
(698, 13, 8, 3, 0),
(699, 13, 8, 4, 0),
(700, 13, 8, 5, 0),
(701, 13, 9, 1, 8),
(702, 13, 9, 2, 0),
(703, 13, 9, 3, 56),
(704, 13, 9, 4, 40),
(705, 13, 9, 5, 600),
(706, 13, 10, 1, 0),
(707, 13, 10, 2, 0),
(708, 13, 10, 3, 0),
(709, 13, 10, 4, 0),
(710, 13, 10, 5, 0),
(711, 13, 11, 1, 3),
(712, 13, 11, 2, 0),
(713, 13, 11, 3, 0),
(714, 13, 11, 4, 15),
(715, 13, 11, 5, 135),
(716, 14, 1, 1, 10),
(717, 14, 1, 2, 150),
(718, 14, 1, 3, 20),
(719, 14, 1, 4, 10),
(720, 14, 1, 5, 800),
(721, 14, 2, 1, 4),
(722, 14, 2, 2, 60),
(723, 14, 2, 3, 0),
(724, 14, 2, 4, 0),
(725, 14, 2, 5, 240),
(726, 14, 3, 1, 3),
(727, 14, 3, 2, 45),
(728, 14, 3, 3, 0),
(729, 14, 3, 4, 0),
(730, 14, 3, 5, 180),
(731, 14, 4, 1, 6),
(732, 14, 4, 2, 30),
(733, 14, 4, 3, 12),
(734, 14, 4, 4, 0),
(735, 14, 4, 5, 150),
(736, 14, 5, 1, 2),
(737, 14, 5, 2, 24),
(738, 14, 5, 3, 16),
(739, 14, 5, 4, 4),
(740, 14, 5, 5, 200),
(741, 14, 6, 1, 0),
(742, 14, 6, 2, 0),
(743, 14, 6, 3, 0),
(744, 14, 6, 4, 0),
(745, 14, 6, 5, 0),
(746, 14, 7, 1, 0),
(747, 14, 7, 2, 0),
(748, 14, 7, 3, 0),
(749, 14, 7, 4, 0),
(750, 14, 7, 5, 0),
(751, 14, 8, 1, 0),
(752, 14, 8, 2, 0),
(753, 14, 8, 3, 0),
(754, 14, 8, 4, 0),
(755, 14, 8, 5, 0),
(756, 14, 9, 1, 9),
(757, 14, 9, 2, 0),
(758, 14, 9, 3, 63),
(759, 14, 9, 4, 45),
(760, 14, 9, 5, 675),
(761, 14, 10, 1, 0),
(762, 14, 10, 2, 0),
(763, 14, 10, 3, 0),
(764, 14, 10, 4, 0),
(765, 14, 10, 5, 0),
(766, 14, 11, 1, 4),
(767, 14, 11, 2, 0),
(768, 14, 11, 3, 0),
(769, 14, 11, 4, 20),
(770, 14, 11, 5, 180);

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `name` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `name`) VALUES
(1, 'Starch'),
(2, 'Fruits'),
(3, 'Other CHO'),
(4, 'Vegetables'),
(5, 'Milk (skimmed)'),
(6, 'Milk (reduced)'),
(7, 'Milk (full fat)'),
(8, 'Meat (lean)'),
(9, 'Meat (med)'),
(10, 'Meat (high)'),
(11, 'Fat');

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

--
-- Table structure for table `days`
--

CREATE TABLE `days` (
  `id` int(11) NOT NULL,
  `diet_program_id` int(11) NOT NULL,
  `meals_number` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `days`
--

INSERT INTO `days` (`id`, `diet_program_id`, `meals_number`) VALUES
(69, 27, 4),
(70, 27, 2),
(71, 27, 2),
(72, 27, NULL),
(73, 27, NULL),
(74, 27, NULL),
(75, 27, NULL),
(76, 28, NULL);

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

--
-- Table structure for table `diseases`
--

CREATE TABLE `diseases` (
  `id` int(11) NOT NULL,
  `disease_name` varchar(30) NOT NULL,
  `type` enum('Text','Radio') NOT NULL,
  `status` enum('Active','Inactive') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `diseases`
--

INSERT INTO `diseases` (`id`, `disease_name`, `type`, `status`) VALUES
(1, 'Headach', 'Text', 'Inactive'),
(2, 'Diabets', 'Radio', 'Inactive'),
(3, 'Corona', 'Radio', 'Inactive'),
(4, 'Diabetes', 'Radio', 'Active'),
(5, 'Anemia', 'Radio', 'Active'),
(6, 'Cardio Vascular Disease (CVD)', 'Radio', 'Active'),
(7, 'Renal Disease', 'Radio', 'Active'),
(8, 'Gastrointestenal  disease', 'Text', 'Active'),
(9, 'Hypertention (HTN)', 'Radio', 'Active'),
(10, 'Osteoporosis', 'Radio', 'Active'),
(11, 'Cholesterol', 'Radio', 'Active'),
(12, 'Triglyceride ', 'Radio', 'Active'),
(13, 'Thyroid Gland', 'Radio', 'Active'),
(14, 'POS', 'Radio', 'Active'),
(15, 'Other Diseases', 'Text', 'Active'),
(16, 'General Disease', 'Radio', 'Inactive'),
(17, 'new disease', 'Radio', 'Inactive'),
(19, 'HDL', 'Text', 'Active'),
(20, 'LDL', 'Text', 'Active');

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

--
-- Table structure for table `diseases_options`
--

CREATE TABLE `diseases_options` (
  `id` int(11) NOT NULL,
  `disease_id` int(11) NOT NULL,
  `disease_option` varchar(30) NOT NULL,
  `status` enum('Active','Inactive') NOT NULL DEFAULT 'Active'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `diseases_options`
--

INSERT INTO `diseases_options` (`id`, `disease_id`, `disease_option`, `status`) VALUES
(1, 1, 'Yes', 'Inactive'),
(47, 1, 'Yes', 'Inactive'),
(65, 3, 'A', 'Active'),
(66, 3, 'B', 'Active'),
(73, 2, 'Type', 'Active'),
(74, 2, '1', 'Active'),
(75, 2, '2', 'Active'),
(78, 5, 'Yes', 'Active'),
(79, 5, 'No', 'Active'),
(80, 6, 'Yes', 'Active'),
(81, 6, 'No', 'Active'),
(82, 7, 'Yes', 'Active'),
(83, 7, 'No', 'Active'),
(84, 9, 'Yes', 'Active'),
(85, 9, 'No', 'Active'),
(86, 4, 'Type 1', 'Active'),
(87, 4, 'Type 2', 'Active'),
(88, 4, 'No', 'Active'),
(89, 10, 'Yes', 'Active'),
(90, 10, 'No', 'Active'),
(91, 11, 'Yes', 'Active'),
(92, 11, 'No', 'Active'),
(93, 12, 'Yes', 'Active'),
(94, 12, 'No', 'Active'),
(95, 13, 'Yes', 'Active'),
(96, 13, 'No', 'Active'),
(97, 14, 'Yes', 'Active'),
(98, 14, 'No', 'Active'),
(102, 16, 'A', 'Active'),
(109, 16, 'B', 'Active'),
(110, 16, 'C', 'Active'),
(112, 17, 'A', 'Active'),
(113, 17, 'B', 'Active');

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

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `id` int(11) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date DEFAULT NULL,
  `title` varchar(200) NOT NULL,
  `content` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `events`
--

INSERT INTO `events` (`id`, `start_date`, `end_date`, `title`, `content`) VALUES
(1, '2021-01-30', '2021-01-30', 'First Event', '<p><img src=\"/food2fit-dalal/web/events-images/13/39c0bc1651-log-in-background.jpg\"></p><p>First Event</p>');

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

--
-- Table structure for table `general_advices`
--

CREATE TABLE `general_advices` (
  `id` int(11) NOT NULL,
  `title` varchar(250) NOT NULL,
  `body` text NOT NULL,
  `image_url` text DEFAULT NULL,
  `status` enum('Published','Draft') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `general_advices`
--

INSERT INTO `general_advices` (`id`, `title`, `body`, `image_url`, `status`) VALUES
(37, 'باذنجان مقلي صحي', '<p style=\"text-align: right; padding-left: 40px;\">أصبح بالإمكان تناول طبق الباذنجان المقلي الذي يحتوي على سعرات حرارية عالية ,بطريقة صحية و حريرات&nbsp; &nbsp; منخفضة عن طريق دهنه بالزيت و وضعه بالفرن&nbsp;</p>', 'uploads/1_1655898017.jpg', 'Published'),
(38, 'الخبز الأسمر', '<p style=\"text-align: right;\">تساعد الألياف في الخبز الأسمر على الشعور بالشبع و تقليل الإمساك مقارنة بالخبز الأبيض&nbsp;</p>', 'uploads/2_1655980113.jpg', 'Published'),
(39, 'أطعمة تحافظ على صحة القلب', '<div dir=\"auto\" style=\"font-family: \'Segoe UI Historic\', \'Segoe UI\', Helvetica, Arial, sans-serif; color: #050505; font-size: 18.75px; white-space: pre-wrap; background-color: #ffffff;\">اطعمة تحافظ على صحة القلب:</div>\r\n<div dir=\"auto\" style=\"font-family: \'Segoe UI Historic\', \'Segoe UI\', Helvetica, Arial, sans-serif; color: #050505; font-size: 18.75px; white-space: pre-wrap; background-color: #ffffff;\">-اللوز و الجوز.</div>\r\n<div dir=\"auto\" style=\"font-family: \'Segoe UI Historic\', \'Segoe UI\', Helvetica, Arial, sans-serif; color: #050505; font-size: 18.75px; white-space: pre-wrap; background-color: #ffffff;\">- الشعير.</div>\r\n<div dir=\"auto\" style=\"font-family: \'Segoe UI Historic\', \'Segoe UI\', Helvetica, Arial, sans-serif; color: #050505; font-size: 18.75px; white-space: pre-wrap; background-color: #ffffff;\">- الشوفان .</div>\r\n<div dir=\"auto\" style=\"font-family: \'Segoe UI Historic\', \'Segoe UI\', Helvetica, Arial, sans-serif; color: #050505; font-size: 18.75px; white-space: pre-wrap; background-color: #ffffff;\">- بذور الكتان .</div>\r\n<div dir=\"auto\" style=\"font-family: \'Segoe UI Historic\', \'Segoe UI\', Helvetica, Arial, sans-serif; color: #050505; font-size: 18.75px; white-space: pre-wrap; background-color: #ffffff;\">-فاصوليا حب سوداء.</div>\r\n<div dir=\"auto\" style=\"font-family: \'Segoe UI Historic\', \'Segoe UI\', Helvetica, Arial, sans-serif; color: #050505; font-size: 18.75px; white-space: pre-wrap; background-color: #ffffff;\">- الكرز و التوت البري .</div>\r\n<div dir=\"auto\" style=\"font-family: \'Segoe UI Historic\', \'Segoe UI\', Helvetica, Arial, sans-serif; color: #050505; font-size: 18.75px; white-space: pre-wrap; background-color: #ffffff;\">-البرتقال .</div>\r\n<div dir=\"auto\" style=\"font-family: \'Segoe UI Historic\', \'Segoe UI\', Helvetica, Arial, sans-serif; color: #050505; font-size: 18.75px; white-space: pre-wrap; background-color: #ffffff;\">- زيت الزيتون .</div>\r\n<div dir=\"auto\" style=\"font-family: \'Segoe UI Historic\', \'Segoe UI\', Helvetica, Arial, sans-serif; color: #050505; font-size: 18.75px; white-space: pre-wrap; background-color: #ffffff;\">- سمك السالمون .</div>\r\n<div dir=\"auto\" style=\"font-family: \'Segoe UI Historic\', \'Segoe UI\', Helvetica, Arial, sans-serif; color: #050505; font-size: 18.75px; white-space: pre-wrap; background-color: #ffffff;\">-التونا .</div>\r\n<div dir=\"auto\" style=\"font-family: \'Segoe UI Historic\', \'Segoe UI\', Helvetica, Arial, sans-serif; color: #050505; font-size: 18.75px; white-space: pre-wrap; background-color: #ffffff;\">-بطاطا حلوة .</div>', 'uploads/Healthy-heart-pic_1655980827.png', 'Published'),
(40, 'أطعمة ترفع المناعة الجسم', '<p>أطعمة ترفع المناعة الجسم</p>', 'uploads/4_1655981434.jpg', 'Published'),
(41, 'Food Mental Health', '<p style=\"text-align: right;\"><span style=\"color: #050505; font-family: \'Segoe UI Historic\', \'Segoe UI\', Helvetica, Arial, sans-serif; font-size: 18.75px; background-color: #ffffff;\">لصحة عقلية سليمة :</span><br style=\"color: #050505; font-family: \'Segoe UI Historic\', \'Segoe UI\', Helvetica, Arial, sans-serif; font-size: 18.75px; background-color: #ffffff;\" /><span style=\"color: #050505; font-family: \'Segoe UI Historic\', \'Segoe UI\', Helvetica, Arial, sans-serif; font-size: 18.75px; background-color: #ffffff;\">-ممارسة الرياضة بشكل منتظم.</span><br style=\"color: #050505; font-family: \'Segoe UI Historic\', \'Segoe UI\', Helvetica, Arial, sans-serif; font-size: 18.75px; background-color: #ffffff;\" /><span style=\"color: #050505; font-family: \'Segoe UI Historic\', \'Segoe UI\', Helvetica, Arial, sans-serif; font-size: 18.75px; background-color: #ffffff;\">- التغذية السليمة.</span><br style=\"color: #050505; font-family: \'Segoe UI Historic\', \'Segoe UI\', Helvetica, Arial, sans-serif; font-size: 18.75px; background-color: #ffffff;\" /><span style=\"color: #050505; font-family: \'Segoe UI Historic\', \'Segoe UI\', Helvetica, Arial, sans-serif; font-size: 18.75px; background-color: #ffffff;\">- اخذ قسط كافي من النوم .</span><br style=\"color: #050505; font-family: \'Segoe UI Historic\', \'Segoe UI\', Helvetica, Arial, sans-serif; font-size: 18.75px; background-color: #ffffff;\" /><span style=\"color: #050505; font-family: \'Segoe UI Historic\', \'Segoe UI\', Helvetica, Arial, sans-serif; font-size: 18.75px; background-color: #ffffff;\">- الحد من تناول الكحول.</span><br style=\"color: #050505; font-family: \'Segoe UI Historic\', \'Segoe UI\', Helvetica, Arial, sans-serif; font-size: 18.75px; background-color: #ffffff;\" /><span style=\"color: #050505; font-family: \'Segoe UI Historic\', \'Segoe UI\', Helvetica, Arial, sans-serif; font-size: 18.75px; background-color: #ffffff;\">- تخصيص وقت للمشاركات الاجتماعية .</span></p>', 'uploads/mental health_1655981687.jpg', 'Published'),
(42, 'لحم الغنم', '<p style=\"padding-left: 40px; text-align: right;\">يحتوي لحم الغنم على نسبة دسم أعلى بكثير من لحم العجل, حتى لو تم إزالة الدهون, حيث أن تركيب الخلية العضلية في لحم الغنم تحتوي كمية دهون أعلى منها في لحم العجل</p>', 'uploads/beef_1656499147.png', 'Published'),
(45, 'فيتامين سي ', '<p style=\"text-align: right;\">أثبتت الدراسات أن تناول كمية مناسبة من فيتامين سي يوميا تعمل على زيادة مناعة الجسم ضد الإلتهابات و تخفف من أعراض الرشح و الزكام&nbsp;&nbsp;</p>', 'uploads/vit C_1656499778.png', 'Published'),
(46, 'المرض الصامت', '<p style=\"text-align: right;\">هو مرض ترقق الذي يحدث دون أي أعراض, و يصيب النساء أكثر من الرجال بسبب نقص الكالسيوم في العظام, لذلك يجب المداومة على تناول الحليب و مشتقاته لأنها تعتبر من أغنى مصادر الكالسيوم</p>', 'uploads/كالسيوم_1656502356.png', 'Published'),
(47, 'معلومة ع السريع ', '<p style=\"text-align: right;\">&nbsp;رياضة المشي&nbsp;</p>', 'uploads/walk_1656583556.png', 'Published'),
(48, 'معلومة مهمة', '<p style=\"text-align: right;\">ما هو الهدف من الحمية الغذائية ؟؟</p>', 'uploads/الهدف من الحمية الغذائية_1656583991.png', 'Published'),
(49, 'الصحن الصحي', '<p style=\"text-align: right;\">كمية الخضار مع البروتين (لحم, دجاج او سمك) في الصحن&nbsp; يجب أن تكون ضعف كمية النشويات (رز, معكرونة, برغل ..)&nbsp;</p>', 'uploads/الصحن الصحي_1656585673.png', 'Published');

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

--
-- Table structure for table `ingredients`
--

CREATE TABLE `ingredients` (
  `id` int(11) NOT NULL,
  `english_name` varchar(50) NOT NULL,
  `arabic_name` varchar(50) NOT NULL,
  `category_id` int(11) NOT NULL,
  `english_unit_of_measure` enum('TS','TBS','Gram','Cup','Piece','Palm of hand') NOT NULL,
  `arabic_unit_of_measure` enum('ملعقة طعام','ملعقة صغيرة','غرام','كوب','حبة','قطعة بحجم اليد') NOT NULL,
  `status` enum('Active','Inactive') DEFAULT NULL,
  `quantity_per_exchange` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ingredients`
--

INSERT INTO `ingredients` (`id`, `english_name`, `arabic_name`, `category_id`, `english_unit_of_measure`, `arabic_unit_of_measure`, `status`, `quantity_per_exchange`) VALUES
(2, 'Tomato', 'طماطم', 2, 'Cup', 'كوب', 'Inactive', 2),
(3, 'Grapes', 'عنب', 2, 'TS', 'ملعقة طعام', 'Inactive', 1.5),
(6, 'Potatos', 'بطاطا', 4, 'Piece', 'حبة', 'Active', 3),
(8, 'Orange', 'برتقال', 4, 'Piece', 'حبة', 'Active', 1),
(9, 'Figs', 'تين', 2, 'Gram', 'غرام', 'Active', 1),
(10, 'Peach', 'دراق', 2, 'Piece', 'حبة', 'Active', 3),
(13, 'banana', 'موز', 2, 'Piece', 'حبة', 'Inactive', 2.5),
(15, 'pear', 'إجاص', 2, 'Piece', 'حبة', 'Active', 2),
(16, 'Tomato', 'بندورة', 4, 'Cup', 'كوب', 'Active', 1),
(17, 'Cucamber', 'خيار', 4, 'Cup', 'كوب', 'Active', 1),
(18, 'Onion', 'بصل', 4, 'Cup', 'كوب', 'Active', 1),
(19, 'Lettuce', 'خس', 4, 'Cup', 'كوب', 'Active', 1),
(20, 'Lemon', 'ليمون', 4, 'Cup', 'كوب', 'Active', 1),
(21, 'ِArtichoke ', 'أرضي شوكي', 4, 'Cup', 'كوب', 'Active', 1),
(22, 'Carrots', 'جزر', 4, 'Cup', 'كوب', 'Active', 1),
(23, 'Pepper', 'فليفلة ', 4, 'Cup', 'كوب', 'Active', 1),
(24, 'Aspargus', 'هليون ', 4, 'Cup', 'كوب', 'Active', 1),
(25, 'Broccoli', 'بروكولي', 4, 'Cup', 'كوب', 'Active', 1),
(26, 'Cabbage', 'ملفوف', 4, 'Cup', 'كوب', 'Active', 1),
(27, 'Cauliflower', 'زهرة', 4, 'Cup', 'كوب', 'Active', 1),
(28, 'Eggplant', 'باذنجان', 4, 'Cup', 'كوب', 'Active', 1),
(29, 'Spanich', 'سبانخ', 4, 'Cup', 'كوب', 'Active', 1),
(30, 'Okra', 'بامية', 4, 'Cup', 'كوب', 'Active', 1),
(31, 'Pepper', 'فليفلة ', 4, 'Cup', 'كوب', 'Active', 1),
(32, 'Leeks', 'الكراث', 4, 'Cup', 'كوب', 'Active', 1),
(33, 'Mushroom', 'فطر', 4, 'Cup', 'كوب', 'Active', 1),
(34, 'Radishes', 'فجل', 4, 'Cup', 'كوب', 'Active', 1),
(35, 'squash', 'قرع', 4, 'Cup', 'كوب', 'Active', 1),
(36, 'Beets', 'شوندر', 4, 'Cup', 'كوب', 'Active', 1),
(37, 'Baby corn', 'ذؤة صغيرة', 4, 'Cup', 'كوب', 'Active', 1),
(38, 'Been sprouts', 'فاصوليا', 4, 'Cup', 'كوب', 'Active', 1),
(39, 'Green Onions', 'بصل أخضر ', 4, 'Cup', 'كوب', 'Active', 1),
(40, 'Celery', 'كرفس', 4, 'Cup', 'كوب', 'Active', 1),
(41, 'Mix vegetables  (without corn, peas)', 'خضار مشكلة  ( بدون ذرة و بازلاء) ', 4, 'Cup', 'كوب', 'Active', 1),
(42, 'Turnip', 'لفت ', 4, 'Cup', 'كوب', 'Active', 1),
(43, 'Corn', 'ذرة ', 4, 'Cup', 'كوب', 'Active', 0.5),
(44, 'Cob Corn', 'غرنوس ذرة ', 4, 'Piece', 'حبة', 'Active', 0.5),
(45, 'Mixed vegetables with ( corn, peas or pasta ) ', 'خضار مشكلة مع ذرة, بازلاء و باستا ', 4, 'Cup', 'كوب', 'Active', 1),
(46, 'Peas', ' بازلاء ', 4, 'Cup', 'كوب', 'Active', 0.5),
(47, 'Potato', 'بطاطا ', 4, 'Piece', 'حبة', 'Active', 0.5),
(48, 'Mashed potato', 'بطاطا بيريه ', 4, 'Cup', 'كوب', 'Active', 0.5),
(49, 'French Fries ', 'بطاطا مقلية ', 4, 'Cup', 'كوب', 'Active', 1),
(50, 'Pumpkin', 'قرغ ', 4, 'Cup', 'كوب', 'Active', 1),
(51, 'Sweet potato', 'بطاطا حلوة ', 4, 'Cup', 'كوب', 'Active', 0.5),
(52, 'Apple', 'تقاح ', 2, 'Piece', 'حبة', 'Active', 1),
(53, 'Apricot ( fresh)', 'مشمش ', 2, 'Piece', 'حبة', 'Active', 3),
(54, 'Apricot (Dried) ', 'مشمش مجفف', 2, 'Piece', 'حبة', 'Active', 4),
(55, 'Banana', 'موز', 2, 'Piece', 'حبة', 'Active', 1),
(56, 'grapes', 'عنب', 2, 'Piece', 'حبة', 'Active', 17),
(57, 'Dates', 'تمر ', 2, 'Piece', 'حبة', 'Active', 3),
(59, 'kiwi', 'كيوي ', 2, 'Piece', 'حبة', 'Active', 1),
(60, 'Grapefruit ', 'جريفون ', 2, 'Piece', 'حبة', 'Active', 0.5),
(61, 'Cantalope', 'شمام ', 2, 'Cup', 'كوب', 'Active', 1),
(62, 'Cherry ', 'كرز ', 2, 'Piece', 'حبة', 'Active', 12),
(63, 'Dried Fruits  (Blueberris, cherries, cranberries)', 'فواكه مجففة (توت بري, كرز, توت) ', 2, 'TBS', 'ملعقة صغيرة', 'Active', 2),
(64, 'Raisens', 'زبيب ', 2, 'TBS', 'ملعقة صغيرة', 'Active', 2),
(65, 'Mango ', 'مانجو ', 2, 'Piece', 'حبة', 'Active', 0.5),
(66, 'Nectarine', 'دراق ', 2, 'Piece', 'حبة', 'Active', 1),
(67, 'Orange ', 'برتفال', 2, 'Piece', 'حبة', 'Active', 1),
(68, 'papaya ', 'بابايا', 2, 'Cup', 'كوب', 'Active', 1),
(69, 'Peach', 'خوخ', 2, 'Piece', 'حبة', 'Active', 1),
(70, 'Pineapple (canned)', 'أناناس (معلب)', 2, 'Cup', 'كوب', 'Active', 0.5),
(71, 'Plums (Dried)', 'خوخ مجفف', 2, 'Piece', 'حبة', 'Active', 3),
(72, 'Plums (small)', 'خوخ (حبة صغيرة)', 2, 'Piece', 'حبة', 'Active', 2),
(73, 'Plums (canned)', 'خوخ (معلب)', 2, 'Cup', 'كوب', 'Active', 0.5),
(74, 'Raspberry', 'توت العليق ', 2, 'Cup', 'كوب', 'Active', 1),
(75, 'Strawberry', 'فراولة ', 2, 'Piece', 'حبة', 'Active', 8),
(76, 'Watermelon', 'بطيخ أحمر', 2, 'Cup', 'كوب', 'Active', 1.25),
(77, 'Tangerines', 'يوسف أفندي ', 2, 'Piece', 'حبة', 'Active', 2),
(78, 'Apple juice', 'عصير تفاح ', 2, 'Cup', 'كوب', 'Active', 0.5),
(79, 'Fruit juice blend', 'كوكتيل فواكه ', 2, 'Cup', 'كوب', 'Active', 0.3),
(80, 'Grape juice', 'عصير جريفون ', 2, 'Cup', 'كوب', 'Active', 0.3),
(81, 'Orange juice', ' عصير برتفال', 2, 'Cup', 'كوب', 'Active', 0.5),
(82, 'Pineapple juice', ' عصير الأناناس', 2, 'Cup', 'كوب', 'Active', 0.5),
(83, 'milk (ful fat)', 'حليب كامل الدسم ', 7, 'Cup', 'كوب', 'Active', 1),
(84, 'Yogurt', 'لبن', 7, 'Cup', 'كوب', 'Active', 1),
(85, 'Milk (Reduced fat 2%)', 'حليب قليل الدسم', 6, 'Cup', 'كوب', 'Active', 1),
(86, 'milk (skimmed 1%)', 'حليب (خالي الدسم)', 5, 'Cup', 'كوب', 'Active', 1),
(87, 'Chocolate milk (Fat Free)', 'حليب الشوكولا ', 5, 'Cup', 'كوب', 'Active', 1),
(88, 'Chocolate milk (Whole)', 'حليب الشوكولا ', 7, 'Cup', 'كوب', 'Active', 1),
(89, 'Leen Meat ', '(لحمة هبرة )', 8, 'Gram', 'غرام', 'Active', 30),
(90, 'Meat (medium fat)', 'لحم (دهن وسط)', 9, 'Gram', 'غرام', 'Active', 30),
(91, 'Meat (High Fat)', 'لحم (عالي الدهن )', 10, 'Gram', 'غرام', 'Active', 30),
(92, 'Cheese ', 'جبنة ', 9, 'Gram', 'غرام', 'Active', 30),
(93, 'Egg', 'بيض ', 8, 'Piece', 'حبة', 'Active', 1),
(94, ' Egg whites', 'بياض البيض ', 7, 'Piece', 'حبة', 'Active', 2),
(95, 'Tuna (In water)', 'تونة (بالماء)', 8, 'Gram', 'غرام', 'Active', 30),
(96, 'Labnah', 'لبنة ', 9, 'TBS', 'ملعقة صغيرة', 'Active', 1),
(97, 'Olive Oil', 'زيت الزيتون ', 11, 'TS', 'ملعقة طعام', 'Active', 1),
(98, 'Black Olives', 'زيتون أسود', 11, 'Piece', 'حبة', 'Active', 8),
(99, 'Green Olives', 'زيتون أخضر ', 11, 'Piece', 'حبة', 'Active', 10),
(100, 'Tahini', 'طحينة ', 11, 'TS', 'ملعقة طعام', 'Active', 2),
(101, 'Oil', 'زيت', 11, 'TS', 'ملعقة طعام', 'Active', 1),
(102, 'bread', 'خبز ', 1, 'Gram', 'غرام', 'Active', 30),
(103, 'Bran Bread', 'خبز أسمر ', 1, 'Gram', 'غرام', 'Active', 30),
(104, 'pasta', 'معكرونة', 1, 'Cup', 'كوب', 'Active', 0.3),
(105, 'Granola (Low |Fat)', 'شوفان (قليل الدسم)', 1, 'Cup', 'كوب', 'Active', 0.25),
(106, 'Granola (Low |Fat)', 'شوفان (قليل الدسم)', 1, 'Cup', 'كوب', 'Active', 0.25),
(107, 'Granola (Regular)', 'شوفان', 1, 'Cup', 'كوب', 'Active', 0.25),
(108, 'Cooked Rice (White)', 'رز أبيض مطبوخ', 1, 'Cup', 'كوب', 'Active', 0.3),
(109, 'Cooked Rice (Brown)', 'رز أسمر مطبوخ ', 1, 'Cup', 'كوب', 'Active', 0.3),
(110, 'Quinoa (Cooked)', 'كينوا مطبوخة ', 1, 'Cup', 'كوب', 'Active', 0.3),
(111, 'Bulgur (Cooked)', 'برغل ', 1, 'Cup', 'كوب', 'Active', 0.5),
(112, 'Grits (Cooked)', 'فريكة', 1, 'Cup', 'كوب', 'Active', 0.5),
(113, 'Tabbouleh ', 'تبولة ', 1, 'Cup', 'كوب', 'Active', 0.5),
(114, 'Pancake ', 'بانكيك', 1, 'Piece', 'حبة', 'Active', 1),
(115, 'Biscuit ', 'بسكويت ', 1, 'Piece', 'حبة', 'Active', 1),
(116, 'Cereals (unsweatened)', 'كورن فليكس (غير محلى)', 1, 'Cup', 'كوب', 'Active', 0.75),
(117, 'Cooked Vegetable', 'خضار مطبوخة ', 4, 'Cup', 'كوب', 'Active', 0.5),
(118, 'Cooked Vegetable with oil', 'خضار بالزيت ', 4, 'Cup', 'كوب', 'Active', 0.5),
(119, 'Mfaraka (vegtable)', 'مفركة (نوع خضار )', 4, 'Cup', 'كوب', 'Active', 0.5),
(120, 'Green Salad (Meduim Plate)', 'سلطة خضراء (صحن حجم وسط)', 4, 'Cup', 'كوب', 'Active', 1),
(121, 'zucchini', 'كوسا', 4, 'Piece', 'حبة', 'Active', 3),
(122, 'White Sugar', 'سكر أبيض ', 3, 'TBS', 'ملعقة صغيرة', 'Active', 1),
(123, 'Honey', 'عسل ', 3, 'TBS', 'ملعقة صغيرة', 'Active', 1),
(124, 'Jam ', 'مربى', 3, 'TBS', 'ملعقة صغيرة', 'Active', 1),
(125, 'Chocolate', ' شوكولا ', 3, 'Gram', 'غرام', 'Active', 30),
(126, 'Barbeque Sauce', 'باربيكيو سوس ', 3, 'TBS', 'ملعقة صغيرة', 'Active', 3),
(127, 'Chicken  Breast', 'صدر دجاج ', 8, 'Gram', 'غرام', 'Active', 30),
(128, 'Chicken Thigh (without skin)', 'فخذ دجاج (بدون جلد)', 9, 'Gram', 'غرام', 'Active', 30),
(129, 'Chicken Thigh (without skin)', 'فخذ دجاج (بدون جلد)', 9, 'Gram', 'غرام', 'Active', 30),
(130, 'Toast (Bran)', 'توست أسمر', 1, 'Gram', 'غرام', 'Active', 30),
(131, 'Sandwich (Bran)', 'سندويش (أسمر)', 1, 'Gram', 'غرام', 'Active', 30),
(132, 'Cake', 'كيك سادة ', 3, 'Gram', 'غرام', 'Active', 30),
(133, 'Cookies', 'كوكيز', 3, 'Piece', 'حبة', 'Active', 2);

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

--
-- Table structure for table `meals`
--

CREATE TABLE `meals` (
  `id` int(11) NOT NULL,
  `name` enum('Breakfast','Lunch','Dinner','Snack') NOT NULL,
  `day_id` int(11) NOT NULL,
  `english_textual_explanation` text NOT NULL,
  `arabic_textual_explanation` text NOT NULL,
  `time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `meals`
--

INSERT INTO `meals` (`id`, `name`, `day_id`, `english_textual_explanation`, `arabic_textual_explanation`, `time`) VALUES
(121, 'Breakfast', 69, '60 Gram of Bran Bread\r\n60 Gram of Cheese \r\n1 Cup of Cucamber\r\n3 TBS of Labnah\r\n1 TS of Olive Oil', '60 غرام خبز أسمر \r\n60 غرام جبنة \r\n1 كوب خيار\r\n3 ملعقة صغيرة لبنة \r\n1 ملعقة طعام زيت الزيتون ', '10:00:00'),
(122, 'Snack', 69, '1 Piece of Apple\r\n1 Cup of Milk (Reduced fat 2%)', '1 حبة تقاح \r\n1 كوب حليب قليل الدسم', '12:00:00'),
(123, 'Lunch', 69, '1 Cup of Cooked Rice (White)\r\n1 Cup of Cooked Vegetable\r\n30 Gram of Meat (medium fat)\r\n2 Cup of Green Salad (Meduim Plate)', '1 كوب رز أبيض مطبوخ\r\n1 كوب خضار مطبوخة \r\n30 غرام لحم (دهن وسط)\r\n2 كوب سلطة خضراء (صحن حجم وسط)', '03:00:00'),
(124, 'Snack', 69, '1 Piece of Biscuit \r\n1 Piece of Orange ', '1 حبة بسكويت \r\n1 حبة برتفال', '05:00:00'),
(128, 'Breakfast', 70, '60 Gram of bread\r\n2 Piece of Egg\r\n1 Cup of Tomato\r\n1 Cup of Onion\r\n1 Cup of Cucamber', '60 غرام خبز \r\n2 حبة بيض \r\n1 كوب بندورة\r\n1 كوب بصل\r\n1 كوب خيار', '07:00:00'),
(129, 'Snack', 70, '1 Cup of Milk (Reduced fat 2%)\r\n1 Piece of Banana\r\n1 Cup of Milk (Reduced fat 2%)', '1 كوب حليب قليل الدسم\r\n1 حبة موز\r\n1 كوب حليب قليل الدسم', '12:00:00'),
(136, 'Breakfast', 71, '2 Gram of Toast (Bran)\r\n1 Cup of Lettuce\r\n60 Gram of Cheese \r\n1 TS of Olive Oil', '2 غرام توست أسمر\r\n1 كوب خس\r\n60 غرام جبنة \r\n1 ملعقة طعام زيت الزيتون ', '08:00:00'),
(137, 'Lunch', 71, '1 Cup of Cooked Rice (White)\r\n1 Cup of Cooked Vegetable\r\n90 Gram of Meat (medium fat)\r\n2 Cup of Green Salad (Meduim Plate)', '1 كوب رز أبيض مطبوخ\r\n1 كوب خضار مطبوخة \r\n90 غرام لحم (دهن وسط)\r\n2 كوب سلطة خضراء (صحن حجم وسط)', '02:00:00');

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

--
-- Table structure for table `meals_ingredients`
--

CREATE TABLE `meals_ingredients` (
  `id` int(11) NOT NULL,
  `meal_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `ingredient_id` int(11) NOT NULL,
  `quantity` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `meals_ingredients`
--

INSERT INTO `meals_ingredients` (`id`, `meal_id`, `category_id`, `ingredient_id`, `quantity`) VALUES
(228, 121, 1, 103, 60),
(229, 121, 9, 92, 60),
(230, 121, 4, 17, 1),
(231, 121, 9, 96, 3),
(232, 121, 11, 97, 1),
(233, 122, 2, 52, 1),
(234, 122, 6, 85, 1),
(235, 123, 1, 108, 1),
(236, 123, 4, 117, 1),
(237, 123, 9, 90, 30),
(238, 123, 4, 120, 2),
(239, 124, 1, 115, 1),
(240, 124, 2, 67, 1),
(250, 128, 1, 102, 60),
(251, 128, 8, 93, 2),
(252, 128, 4, 16, 1),
(253, 128, 4, 18, 1),
(254, 128, 4, 17, 1),
(255, 129, 6, 85, 1),
(256, 129, 2, 55, 1),
(257, 129, 6, 85, 1),
(279, 136, 1, 130, 2),
(280, 136, 4, 19, 1),
(281, 136, 9, 92, 60),
(282, 136, 11, 97, 1),
(283, 137, 1, 108, 1),
(284, 137, 4, 117, 1),
(285, 137, 9, 90, 90),
(286, 137, 4, 120, 2);

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

--
-- Table structure for table `medical_tests`
--

CREATE TABLE `medical_tests` (
  `id` int(11) NOT NULL,
  `patient_id` int(11) NOT NULL,
  `date` datetime NOT NULL,
  `fill_status` enum('Filled','Unfilled','Uploaded') NOT NULL DEFAULT 'Unfilled'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `medical_tests`
--

INSERT INTO `medical_tests` (`id`, `patient_id`, `date`, `fill_status`) VALUES
(2, 3, '2021-02-09 00:00:00', 'Filled'),
(4, 3, '2021-02-16 10:09:09', 'Filled'),
(24, 3, '2021-03-03 10:31:20', 'Uploaded'),
(26, 1, '2021-03-03 12:20:03', 'Unfilled'),
(27, 3, '2021-03-15 13:51:14', 'Filled'),
(28, 3, '2021-03-17 14:39:00', 'Uploaded'),
(29, 9, '2021-03-18 09:55:20', 'Unfilled'),
(30, 2, '2021-03-28 14:16:12', 'Unfilled'),
(31, 2, '2021-03-28 14:17:01', 'Unfilled'),
(32, 3, '2021-04-26 14:06:15', 'Filled'),
(33, 3, '2021-04-26 14:08:06', 'Filled'),
(34, 3, '2021-05-03 08:15:56', 'Uploaded'),
(35, 4, '2021-05-21 10:02:46', 'Uploaded'),
(36, 22, '2021-06-02 09:52:55', 'Unfilled'),
(37, 22, '2021-06-02 10:48:11', 'Filled'),
(38, 22, '2021-06-03 09:15:10', 'Filled'),
(39, 3, '2022-03-14 09:40:33', 'Filled'),
(40, 4, '2022-03-14 11:12:11', 'Filled'),
(41, 24, '2022-06-03 11:33:04', 'Filled');

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

--
-- Table structure for table `medical_tests_images`
--

CREATE TABLE `medical_tests_images` (
  `id` int(11) NOT NULL,
  `medical_test_id` int(11) NOT NULL,
  `image_path` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `medical_tests_images`
--

INSERT INTO `medical_tests_images` (`id`, `medical_test_id`, `image_path`) VALUES
(3, 2, 'uploads/logo_image_1612444840.png'),
(4, 4, 'uploads/2703208-0.png'),
(8, 24, 'medical-tests-images/24/Screenshot_20210310-190319_Facebook.jpg'),
(9, 34, 'medical-tests-images/34/IMG-20210405-WA0001.jpg'),
(10, 28, 'medical-tests-images/28/IMG-20210401-WA0001.jpg'),
(11, 27, 'medical-tests-images/27/IMG-20210314-WA0003.jpg'),
(12, 27, 'medical-tests-images/27/IMG-20210221-WA0000.jpg'),
(13, 35, 'medical-tests-images/35/IMG-20211225-WA0009.jpg'),
(14, 40, 'medical-tests-images/40/IMG_20220314_1314334806670530599267990.jpg');

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

--
-- Table structure for table `medical_tests_properties_options`
--

CREATE TABLE `medical_tests_properties_options` (
  `id` int(11) NOT NULL,
  `property_type_id` int(11) NOT NULL,
  `property_type_option` varchar(30) NOT NULL,
  `status` enum('Active','Inactive') NOT NULL DEFAULT 'Active'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `medical_tests_properties_options`
--

INSERT INTO `medical_tests_properties_options` (`id`, `property_type_id`, `property_type_option`, `status`) VALUES
(4, 29, 'B', 'Inactive'),
(5, 31, 'A', 'Inactive'),
(6, 31, 'B', 'Inactive'),
(7, 29, 'A', 'Inactive'),
(8, 31, 'A', 'Active'),
(9, 31, 'B', 'Active'),
(10, 31, 'A', 'Active'),
(11, 31, 'B', 'Active'),
(20, 84, '36%', 'Active'),
(21, 84, '51%', 'Active');

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

--
-- Table structure for table `medical_tests_results`
--

CREATE TABLE `medical_tests_results` (
  `id` int(11) NOT NULL,
  `medical_test_id` int(11) NOT NULL,
  `property_id` int(11) NOT NULL,
  `option_id` int(11) DEFAULT NULL,
  `property_value` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `medical_tests_results`
--

INSERT INTO `medical_tests_results` (`id`, `medical_test_id`, `property_id`, `option_id`, `property_value`) VALUES
(20, 4, 5, NULL, '5'),
(21, 4, 30, NULL, '7'),
(22, 4, 31, 5, NULL);

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

--
-- Table structure for table `medical_tests_types`
--

CREATE TABLE `medical_tests_types` (
  `id` int(11) NOT NULL,
  `type_name` varchar(250) NOT NULL,
  `description` text DEFAULT NULL,
  `status` enum('Active','Inactive') NOT NULL DEFAULT 'Active'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `medical_tests_types`
--

INSERT INTO `medical_tests_types` (`id`, `type_name`, `description`, `status`) VALUES
(1, 'CBC', 'Blood test', 'Active'),
(2, 'Cholesterol', 'Blood Lipids', 'Active'),
(14, 'Iron', ' Blood Type Test', 'Active'),
(15, 'Ferritin', 'Blood Test Type', 'Active'),
(23, 'Calcium', 'Blood Type Test', 'Active'),
(34, 'Glucose', 'Blood Type Test', 'Active'),
(35, ' Triglyceride', 'Blood Lipids', 'Active'),
(39, 'Vitamin D', 'Blood Type Test', 'Active'),
(40, 'HDL', 'Blood Lipids', 'Active'),
(41, 'LDL', 'Blood Lipids', 'Active');

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

--
-- Table structure for table `medical_tests_types_properties`
--

CREATE TABLE `medical_tests_types_properties` (
  `id` int(11) NOT NULL,
  `type_id` int(11) NOT NULL,
  `property_name` varchar(250) NOT NULL,
  `property_type` enum('Text','Numeric','Radio') NOT NULL,
  `status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  `min_normal_range_value` decimal(14,4) DEFAULT NULL,
  `max_normal_range_value` decimal(14,4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `medical_tests_types_properties`
--

INSERT INTO `medical_tests_types_properties` (`id`, `type_id`, `property_name`, `property_type`, `status`, `min_normal_range_value`, `max_normal_range_value`) VALUES
(1, 1, 'Hematocrit (MALE)', 'Numeric', 'Active', '13.2000', '16.6000'),
(5, 2, 'property4', 'Text', 'Inactive', NULL, NULL),
(23, 1, 'Hemoglobin (MALE)', 'Text', 'Inactive', NULL, NULL),
(29, 2, 'property11', 'Radio', 'Inactive', NULL, NULL),
(30, 2, 'property7', 'Numeric', 'Inactive', '4.0000', '10.0000'),
(31, 2, 'property3', 'Radio', 'Inactive', NULL, NULL),
(49, 14, 'property1', 'Text', 'Inactive', NULL, NULL),
(50, 15, 'Ferritin (MALE)', 'Numeric', 'Active', '24.0000', '336.0000'),
(56, 23, 'Calcium', 'Numeric', 'Active', '8.5000', '10.2000'),
(61, 2, 'property28', 'Text', 'Inactive', NULL, NULL),
(68, 34, 'Glucose', 'Text', 'Inactive', NULL, NULL),
(69, 35, 'Hemoglobin', 'Numeric', 'Active', '11.7000', '14.5000'),
(70, 35, 'Hematocrit', 'Numeric', 'Active', '35.0000', '45.0000'),
(71, 35, 'Iron', 'Numeric', 'Active', '37.0000', '193.0000'),
(72, 35, 'Ferritin (MALE)', 'Numeric', 'Active', '24.0000', '336.0000'),
(73, 35, 'Calcium', 'Numeric', 'Active', '8.6000', '10.3000'),
(74, 35, 'Vitamin D', 'Numeric', 'Active', '25.0000', '80.0000'),
(75, 35, 'Cholesterol', 'Numeric', 'Active', '0.0000', '200.0000'),
(76, 35, 'Triglyceride', 'Numeric', 'Active', '0.0000', '150.0000'),
(77, 35, 'Glucose', 'Numeric', 'Active', '70.0000', '100.0000'),
(84, 1, 'Hematocrit (FEMALE)', 'Radio', 'Active', NULL, NULL),
(85, 1, 'Hemoglobin (children)', 'Numeric', 'Active', '11.0000', '16.0000'),
(86, 1, 'Hemoglobin (FEMALE)', 'Numeric', 'Active', '12.0000', '15.5000'),
(87, 35, 'Ferritin (FEMALE)', 'Numeric', 'Active', '11.0000', '307.0000'),
(92, 14, 'Iron', 'Numeric', 'Active', '60.0000', '170.0000'),
(93, 15, 'Ferritin (FEMALE)', 'Numeric', 'Active', '11.0000', '307.0000'),
(94, 2, 'Cholesterol', 'Numeric', 'Active', '0.0000', '200.0000'),
(96, 39, 'Vitamin D', 'Numeric', 'Active', '50.0000', '125.0000'),
(97, 40, 'HDL', 'Numeric', 'Active', '40.0000', NULL),
(98, 41, 'LDL', 'Numeric', 'Active', '0.0000', '100.0000');

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` int(11) NOT NULL,
  `account_id` int(11) NOT NULL,
  `patient_id` int(11) NOT NULL,
  `title` varchar(250) NOT NULL,
  `content` text NOT NULL,
  `date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` (`id`, `account_id`, `patient_id`, `title`, `content`, `date`) VALUES
(1, 16, 5, 'First notification', 'First notification First notification First notification First notification', '2021-01-10 00:00:00'),
(2, 16, 5, 'Second Notification', 'fkljsfskjfsljkfklgjskdawqe', '2021-02-09 00:00:00'),
(3, 22, 3, 'New diet program', 'A new diet program has been added for you', '2021-02-09 00:00:00'),
(4, 22, 3, 'Payment', 'You have paid 30$ in your last visit  ', '2021-02-25 00:00:00'),
(5, 22, 3, 'notification test', 'test', '2021-02-28 15:38:07'),
(6, 22, 3, 'notification test', 'test1', '2021-02-28 15:41:24'),
(7, 12, 2, 'multi notification test', 'multi notification test', '2021-02-28 16:08:37'),
(8, 16, 5, 'multi notification test', 'multi notification test', '2021-02-28 16:08:37'),
(9, 22, 3, 'multi patient notification test', 'multi patient notification test', '2021-02-28 16:09:28'),
(10, 14, 4, 'multi patient notification test', 'multi patient notification test', '2021-02-28 16:09:28'),
(11, 16, 5, 'multi patient notification test', 'multi patient notification test', '2021-02-28 16:09:28'),
(12, 22, 3, 'notification test', 'notification test', '2021-03-01 09:19:56'),
(13, 22, 3, 'notification test', 'notification test', '2021-03-01 09:22:57'),
(14, 22, 3, 'notification test', 'notification test', '2021-03-01 09:29:07'),
(15, 22, 4, 'notification test', 'notification test', '2021-03-01 09:29:07'),
(16, 22, 3, 'xdfdxf', 'sdfdsf', '2021-03-01 09:37:43'),
(17, 22, 3, 'New Payment', 'You have paid 10000SYP in your last visit', '2021-04-25 00:00:00'),
(25, 22, 3, 'New Payment', 'You have paid 5000SYP in your last visit', '2021-04-26 00:00:00'),
(26, 22, 3, 'New Payment', 'You have paid 12000SYP in your last visit', '2021-04-26 00:00:00'),
(27, 22, 3, 'New Payment', 'You have paid 30000SYP in your last visit', '2021-04-26 00:00:00'),
(28, 22, 3, 'New Diet Program', 'You have a new diet program has been created at 2021-04-26 10:49:07', '2021-04-26 00:00:00'),
(29, 13, 3, 'New Medical Test Request', 'You have a new medical test request, please check it', '2021-04-26 14:06:15'),
(30, 13, 3, 'New Medical Test Request', 'You have a new medical test request, please check it', '2021-04-26 14:06:22'),
(31, 13, 3, 'New Medical Test Request', 'You have a new medical test request, please check it', '2021-04-26 14:06:28'),
(32, 13, 3, 'Filled Medical Test', 'Your medical test has been filled with results, please check it', '2021-04-26 14:07:09'),
(33, 13, 3, 'New Medical Test Request', 'You have a new medical test request, please check it', '2021-04-26 14:08:06'),
(34, 13, 3, 'New Payment', 'You have paid 12000SYP in your last visit', '2021-04-26 14:09:00'),
(35, 13, 3, 'New Payment', 'You have paid 12000SYP in your last visit', '2021-04-26 14:11:05'),
(36, 13, 3, 'New Appointment', 'You have a new appointment at 2021-04-27 10:15:20', '2021-04-26 14:13:33'),
(37, 13, 3, 'notification test', 'test', '2021-04-26 14:14:35'),
(38, 13, 8, 'notification test', 'test', '2021-04-26 14:14:36'),
(39, 13, 3, 'notification test', 'test', '2021-04-26 14:16:32'),
(40, 22, 4, 'notification test', 'test', '2021-04-26 14:16:32'),
(41, 13, 3, 'notification test 2', 'test', '2021-04-26 14:19:03'),
(42, 13, 8, 'notification test 2', 'test', '2021-04-26 14:19:03'),
(43, 13, 3, 'ssdf', 'kjgjhbj', '2021-04-26 14:29:14'),
(44, 13, 8, 'ssdf', 'kjgjhbj', '2021-04-26 14:29:14'),
(45, 13, 3, 'notification test', 'dsfsfsd', '2021-04-26 14:31:39'),
(46, 13, 8, 'notification test', 'dsfsfsd', '2021-04-26 14:31:39'),
(47, 13, 3, 'notification test', 'bbhjb', '2021-04-26 14:32:21'),
(48, 13, 8, 'notification test', 'bbhjb', '2021-04-26 14:32:21'),
(49, 13, 3, 'ssdf', 'iorwerop', '2021-04-26 14:33:27'),
(50, 22, 4, 'ssdf', 'iorwerop', '2021-04-26 14:33:27'),
(51, 13, 3, 'Canceledappointment', 'Your appointment at 2021-04-16 10:35:06has been Canceled', '2021-04-26 14:47:03'),
(52, 13, 3, 'Confirmed appointment', 'Your appointment at 2021-03-26 11:30 has been Confirmed', '2021-04-26 14:52:49'),
(53, 13, 3, 'Canceled appointment', 'Your appointment at  has been Canceled', '2021-04-26 14:53:42'),
(54, 13, 3, 'Confirmed appointment', 'Your appointment at 2021-03-26 07:30 has been Confirmed', '2021-04-27 08:31:44'),
(55, 13, 3, 'Confirmed appointment', 'Your appointment at 2021-03-25 05:50 has been Confirmed', '2021-04-27 08:34:08'),
(56, 13, 3, 'Canceled appointment', 'Your appointment at 2021-03-25 05:50:00 has been Canceled', '2021-04-27 08:34:31'),
(57, 13, 3, 'Confirmed appointment', 'Your appointment at 2021-05-01 15:30 has been Confirmed', '2021-04-29 07:22:42'),
(58, 13, 3, 'New Diet Program', 'You have a new diet program has been created at 2021-04-29 07:41:31', '2021-04-29 07:41:31'),
(59, 13, 3, 'New Diet Program', 'You have a new diet program has been created at 2021-04-29 07:53:08', '2021-04-29 07:53:08'),
(60, 13, 3, 'New Diet Program', 'You have a new diet program has been created at 2021-04-29 07:54:17', '2021-04-29 07:54:17'),
(61, 13, 3, 'New Diet Program', 'You have a new diet program has been created at 2021-04-29 08:10:54', '2021-04-29 08:10:54'),
(62, 13, 3, 'Filled Medical Test', 'Your medical test has been filled with results, please check it', '2021-04-29 08:15:34'),
(63, 13, 3, 'New Diet Program', 'You have a new diet program has been created at 2021-04-29 09:39:57', '2021-04-29 09:39:57'),
(64, 13, 3, 'New Diet Program', 'You have a new diet program has been created at 2021-04-29 10:04:14', '2021-04-29 10:04:15'),
(65, 13, 3, 'New Diet Program', 'You have a new diet program has been created at 2021-04-29 10:12:00', '2021-04-29 10:12:00'),
(66, 13, 3, 'New Diet Program', 'You have a new diet program has been created at 2021-04-29 10:14:32', '2021-04-29 10:14:32'),
(67, 22, 4, 'notification test', 'notification test', '2021-04-29 10:39:08'),
(68, 22, 7, 'notification test', 'notification test', '2021-04-29 10:39:08'),
(69, 22, 4, 'notification test', 'notification test', '2021-04-29 10:39:48'),
(70, 22, 7, 'notification test', 'notification test', '2021-04-29 10:39:48'),
(71, 13, 3, 'New Diet Program', 'You have a new diet program has been created at 2021-04-29 10:40:59', '2021-04-29 10:41:00'),
(72, 13, 3, 'New Payment', 'You have paid 9000SYP in your last visit', '2021-04-29 10:42:41'),
(73, 13, 3, 'notification test', 'test', '2021-04-29 10:46:36'),
(74, 13, 8, 'notification test', 'test', '2021-04-29 10:46:36'),
(75, 13, 3, 'notification test', 'test2', '2021-04-29 10:48:51'),
(76, 13, 3, 'New Payment', 'You have paid 12000SYP in your last visit', '2021-04-29 11:38:35'),
(77, 13, 3, 'Confirmed appointment', 'Your appointment at 2021-04-12 14:50 has been Confirmed', '2021-04-29 11:40:19'),
(78, 13, 3, 'New Diet Program', 'You have a new diet program has been created at 2021-04-29 11:42:50', '2021-04-29 11:42:50'),
(79, 13, 3, 'New Diet Program', 'You have a new diet program has been created at 2021-04-29 12:37:37', '2021-04-29 12:37:37'),
(80, 13, 3, 'New Medical Test Request', 'You have a new medical test request, please check it', '2021-05-03 08:15:57'),
(81, 13, 3, 'New Medical Test Request', 'You have a new medical test request, please check it', '2021-05-03 08:15:57'),
(82, 13, 3, 'Confirmed appointment', 'Your appointment has been Confirmed', '2021-05-04 06:16:06'),
(83, 13, 3, 'Confirmed appointment', 'Your appointment at 2021-05-04 10:50 has been Confirmed', '2021-05-04 06:17:22'),
(84, 22, 4, 'New Medical Test Request', 'You have a new medical test request, please check it', '2021-05-21 10:02:47'),
(85, 22, 4, 'New Medical Test Request', 'You have a new medical test request, please check it', '2021-05-21 10:02:47'),
(86, 13, 8, 'New Diet Program', 'You have a new diet program has been created at 2021-05-26 07:50:49', '2021-05-26 07:50:49'),
(87, 27, 22, 'New Payment', 'You have paid 10000SYP in your last visit', '2021-06-02 09:49:48'),
(88, 27, 22, 'New Medical Test Request', 'You have a new medical test request, please check it', '2021-06-02 09:52:55'),
(89, 27, 22, 'New Medical Test Request', 'You have a new medical test request, please check it', '2021-06-02 09:52:55'),
(90, 27, 22, 'New Medical Test Request', 'You have a new medical test request, please check it', '2021-06-02 09:52:56'),
(91, 27, 22, 'New Medical Test Request', 'You have a new medical test request, please check it', '2021-06-02 10:48:11'),
(92, 27, 22, 'New Medical Test Request', 'You have a new medical test request, please check it', '2021-06-02 10:48:12'),
(93, 27, 22, 'New Medical Test Request', 'You have a new medical test request, please check it', '2021-06-02 10:48:12'),
(94, 27, 22, 'New Medical Test Request', 'You have a new medical test request, please check it', '2021-06-02 10:48:12'),
(95, 27, 22, 'New Medical Test Request', 'You have a new medical test request, please check it', '2021-06-02 10:48:12'),
(96, 27, 22, 'New Medical Test Request', 'You have a new medical test request, please check it', '2021-06-02 10:48:12'),
(97, 27, 22, 'New Medical Test Request', 'You have a new medical test request, please check it', '2021-06-02 10:48:12'),
(98, 27, 22, 'Filled Medical Test', 'Your medical test has been filled with results, please check it', '2021-06-02 11:25:03'),
(99, 27, 22, 'Filled Medical Test', 'Your medical test has been filled with results, please check it', '2021-06-02 11:26:05'),
(100, 27, 22, 'New Payment', 'You have paid 7500SYP in your last visit', '2021-06-03 07:32:13'),
(101, 27, 22, 'New Medical Test Request', 'You have a new medical test request, please check it', '2021-06-03 09:15:10'),
(102, 27, 22, 'New Medical Test Request', 'You have a new medical test request, please check it', '2021-06-03 09:15:10'),
(103, 27, 22, 'New Medical Test Request', 'You have a new medical test request, please check it', '2021-06-03 09:15:11'),
(104, 27, 22, 'New Medical Test Request', 'You have a new medical test request, please check it', '2021-06-03 09:15:11'),
(105, 27, 22, 'New Medical Test Request', 'You have a new medical test request, please check it', '2021-06-03 09:15:11'),
(106, 27, 22, 'New Medical Test Request', 'You have a new medical test request, please check it', '2021-06-03 09:15:11'),
(107, 13, 3, 'Filled Medical Test', 'Your medical test has been filled with results, please check it', '2021-06-03 09:26:58'),
(108, 11, 2, 'New Notification Test 100', '100', '2021-06-06 12:27:56'),
(109, 11, 10, 'New Notification Test 100', '100', '2021-06-06 12:27:56'),
(110, 13, 3, 'New Notification Test 101', 'content', '2021-06-06 12:28:30'),
(111, 15, 5, 'New Notification Test 101', 'content', '2021-06-06 12:28:30'),
(112, 27, 22, 'New Payment', 'You have paid 10000SYP in your last visit', '2021-06-06 12:30:23'),
(113, 13, 3, 'New Appointment', 'You have a new appointment at 2021-06-26 11:25:46', '2021-06-06 12:35:51'),
(114, 13, 3, 'Canceled appointment', 'Your appointment at 2021-06-26 11:25:46 has been Canceled', '2021-06-06 12:36:03'),
(115, 27, 22, 'Filled Medical Test', 'Your medical test has been filled with results, please check it', '2021-06-06 12:37:34'),
(116, 13, 3, 'new notification', 'This is a new notification', '2022-03-14 09:29:39'),
(117, 22, 4, 'new notification', 'This is a new notification', '2022-03-14 09:29:40'),
(118, 13, 3, 'New Medical Test Request', 'You have a new medical test request, please check it', '2022-03-14 09:40:33'),
(119, 13, 3, 'New Medical Test Request', 'You have a new medical test request, please check it', '2022-03-14 09:40:33'),
(120, 13, 3, 'New Medical Test Request', 'You have a new medical test request, please check it', '2022-03-14 09:40:33'),
(121, 13, 3, 'New Medical Test Request', 'You have a new medical test request, please check it', '2022-03-14 09:40:33'),
(122, 13, 3, 'New Medical Test Request', 'You have a new medical test request, please check it', '2022-03-14 09:40:34'),
(123, 13, 3, 'New Medical Test Request', 'You have a new medical test request, please check it', '2022-03-14 09:40:34'),
(124, 13, 3, 'New Medical Test Request', 'You have a new medical test request, please check it', '2022-03-14 09:40:34'),
(125, 13, 3, 'Filled Medical Test', 'Your medical test has been filled with results, please check it', '2022-03-14 09:41:50'),
(126, 13, 3, 'Filled Medical Test', 'Your medical test has been filled with results, please check it', '2022-03-14 09:42:29'),
(127, 13, 3, 'New Appointment', 'You have a new appointment at 2022-03-30 3:35:18', '2022-03-14 09:45:14'),
(128, 13, 3, 'Canceled appointment', 'Your appointment at 2022-03-30 03:35:18 has been Canceled', '2022-03-14 09:45:39'),
(129, 13, 3, 'New Payment', 'You have paid 20000SYP in your last visit', '2022-03-14 09:46:28'),
(130, 13, 3, 'New Diet Program', 'You have a new diet program has been created at 2022-03-14 09:49:46', '2022-03-14 09:49:46'),
(131, 22, 4, 'New General Advice', 'New General Advice', '2022-03-14 10:58:08'),
(132, 22, 7, 'New General Advice', 'New General Advice', '2022-03-14 10:58:08'),
(133, 13, 3, 'new notification', 'New General Advice', '2022-03-14 10:58:26'),
(134, 15, 5, 'new notification', 'New General Advice', '2022-03-14 10:58:26'),
(135, 22, 4, 'Confirmed appointment', 'Your appointment at 2022-03-30 3:35:18 has been Confirmed', '2022-03-14 11:04:58'),
(136, 22, 4, 'New Diet Program', 'You have a new diet program has been created at 2022-03-14 11:07:59', '2022-03-14 11:07:59'),
(137, 22, 4, 'New Medical Test Request', 'You have a new medical test request, please check it', '2022-03-14 11:12:11'),
(138, 22, 4, 'New Medical Test Request', 'You have a new medical test request, please check it', '2022-03-14 11:12:12'),
(139, 22, 4, 'New Medical Test Request', 'You have a new medical test request, please check it', '2022-03-14 11:12:12'),
(140, 22, 4, 'New Medical Test Request', 'You have a new medical test request, please check it', '2022-03-14 11:12:12'),
(141, 22, 4, 'New Medical Test Request', 'You have a new medical test request, please check it', '2022-03-14 11:12:12'),
(142, 22, 4, 'New Medical Test Request', 'You have a new medical test request, please check it', '2022-03-14 11:12:13'),
(143, 22, 4, 'New Medical Test Request', 'You have a new medical test request, please check it', '2022-03-14 11:12:13'),
(144, 22, 4, 'Filled Medical Test', 'Your medical test has been filled with results, please check it', '2022-03-14 11:18:22'),
(145, 39, 15, 'New Diet Program', 'You have a new diet program has been created at 2022-03-25 11:41:59', '2022-03-25 11:41:59'),
(146, 39, 15, 'Confirmed appointment', 'Your appointment at 2022-06-02 3:0:0 has been Confirmed', '2022-06-02 13:31:18'),
(147, 44, 24, 'New Medical Test Request', 'You have a new medical test request, please check it', '2022-06-03 11:33:05'),
(148, 44, 24, 'New Medical Test Request', 'You have a new medical test request, please check it', '2022-06-03 11:33:05'),
(149, 44, 24, 'New Medical Test Request', 'You have a new medical test request, please check it', '2022-06-03 11:33:05'),
(150, 44, 24, 'New Medical Test Request', 'You have a new medical test request, please check it', '2022-06-03 11:33:05'),
(151, 44, 24, 'New Medical Test Request', 'You have a new medical test request, please check it', '2022-06-03 11:33:05'),
(152, 44, 24, 'Filled Medical Test', 'Your medical test has been filled with results, please check it', '2022-06-03 11:57:18'),
(153, 44, 24, 'Filled Medical Test', 'Your medical test has been filled with results, please check it', '2022-06-03 11:58:08'),
(154, 44, 24, 'New Diet Program', 'You have a new diet program has been created at 2022-06-03 11:59:04', '2022-06-03 11:59:06'),
(155, 44, 24, 'New Diet Program', 'You have a new diet program has been created at 2022-06-04 12:23:03', '2022-06-04 12:23:05'),
(156, 44, 24, 'Confirmed appointment', 'Your appointment at 2022-06-28 12:30:17 has been Confirmed', '2022-06-17 11:51:30'),
(157, 44, 24, 'Filled Medical Test', 'Your medical test has been filled with results, please check it', '2022-06-22 11:51:04'),
(158, 44, 24, 'New Diet Program', 'You have a new diet program has been created at 2022-08-07 12:23:09', '2022-08-07 12:23:10');

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

--
-- Table structure for table `nutritional_values`
--

CREATE TABLE `nutritional_values` (
  `id` int(11) NOT NULL,
  `name` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `nutritional_values`
--

INSERT INTO `nutritional_values` (`id`, `name`) VALUES
(1, 'Exchange'),
(2, 'CHO'),
(3, 'Protein'),
(4, 'Fat'),
(5, 'Kcal');

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

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

CREATE TABLE `patients` (
  `id` int(11) NOT NULL,
  `first_name` varchar(70) NOT NULL,
  `last_name` varchar(70) NOT NULL,
  `birth_date` date NOT NULL,
  `gender` enum('Male','Female') NOT NULL,
  `qualifications` varchar(255) NOT NULL,
  `social_status` enum('Single','Married','Separated','Widow') DEFAULT NULL,
  `children_number` int(11) DEFAULT NULL,
  `work` varchar(255) NOT NULL,
  `work_hours` int(11) NOT NULL,
  `partner_work` varchar(255) DEFAULT NULL,
  `get_to_know` varchar(255) NOT NULL,
  `living_location` varchar(255) NOT NULL,
  `registration_date` datetime NOT NULL,
  `status` enum('Active','Inactive') DEFAULT NULL,
  `account_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `patients` (`id`, `first_name`, `last_name`, `birth_date`, `gender`, `qualifications`, `social_status`, `children_number`, `work`, `work_hours`, `partner_work`, `get_to_know`, `living_location`, `registration_date`, `status`, `account_id`) VALUES
(1, 'Ibrahim', 'Alfarra', '1997-03-18', 'Female', 'Junior high School', 'Married', 0, 'web developer', 9, '-', 'From a friend', 'Damascus, Qudsayya', '2021-03-14 14:33:01', 'Inactive', 12),
(2, 'Ibrahim', 'Alfarra', '1981-04-16', 'Male', 'Undergraduate', 'Single', NULL, 'web developer', 9, '', 'Internet', 'Damascus, Baghdad ave', '2020-10-25 11:08:09', 'Active', 11),
(3, 'Flex', 'Solutions', '2020-10-01', 'Male', 'Bachelor', 'Single', NULL, 'backend developer', 9, '', 'From a friend', 'Damascus, Baghdad ave', '2021-04-27 09:06:04', 'Active', 13),
(4, 'asmaa', 'yusuf', '1995-01-20', 'Female', 'Undergraduate', 'Married', 0, 'backend developer', 8, 'null', 'Social Media', 'Damascus', '2021-02-08 10:57:47', 'Active', 22),
(5, 'Nada', 'Yusuf', '1999-01-20', 'Female', 'Post Graduate', 'Single', NULL, 'backend developer', 3, '', 'From a friend', 'Damascus', '2021-02-22 14:05:37', 'Active', 15),
(6, 'Duaa', 'Yusuf', '1996-04-29', 'Female', 'Master', 'Married', 1, 'doctor', 8, 'partner', 'From a friend', 'Damascus - katana', '2021-03-14 14:37:27', 'Active', 15),
(7, 'Duaa', 'Yusuf', '1996-04-29', 'Female', 'Master', 'Married', 1, 'doctor', 8, 'partner', 'From a friend', 'Damascus - katana', '2021-03-01 11:01:03', 'Inactive', 22),
(8, 'dalal', 'Yusuf', '1995-01-20', 'Female', 'Senior high School', 'Single', NULL, 'doctor', 9, '', 'From a friend', 'Damascus', '2021-03-14 14:41:14', 'Active', 13),
(9, 'Nedaa', 'Yusuf', '1999-09-20', 'Female', 'Undergraduate', 'Separated', 0, 'doctor', 10, 'no work', 'From a friend', 'Damascus', '2021-03-18 09:07:26', 'Active', 27),
(10, 'Duaa', 'Solutions', '1996-04-29', 'Female', 'Elementary School', 'Single', NULL, 'doctor', 5, '', 'From a friend', 'Damascus - katana', '2021-04-19 12:16:02', 'Active', 11),
(11, 'test', 'test', '1999-09-20', 'Male', 'Undergraduate', 'Single', NULL, 'doctor', 5, '', 'From a friend', 'Damascus', '2021-04-19 13:20:34', 'Active', 12),
(12, 'test', 'test', '1999-09-20', 'Male', 'Undergraduate', 'Single', NULL, 'doctor', 5, '', 'From a friend', 'Damascus', '2021-04-19 13:22:11', 'Active', 12),
(13, 'test', 'test', '1999-09-20', 'Male', 'Undergraduate', 'Single', NULL, 'doctor', 5, '', 'From a friend', 'Damascus', '2021-04-20 13:23:47', 'Active', 12),
(14, 'test', 'test', '1999-09-20', 'Male', 'Undergraduate', 'Single', NULL, 'doctor', 5, '', 'From a friend', 'Damascus', '2021-04-20 13:56:17', 'Active', 12),
(15, 'Hani', 'Altawil', '1984-03-27', 'Male', 'Post Graduate', 'Married', 3, 'Pilot, IT', 8, 'Dietitian', 'From a friend', 'Damascus', '2021-05-26 07:58:04', 'Active', 39),
(16, 'Hani', 'Altawil', '1984-03-27', 'Male', 'Post Graduate', 'Married', 3, 'Pilot, IT', 8, 'Dietitian', 'From a friend', 'Damascus', '2021-05-26 08:14:27', 'Active', 39),
(17, 'Ahmad', 'Yusuf', '1986-04-29', 'Male', 'Senior high School', 'Married', 4, 'doctor', 8, 'no work', 'From a friend', 'Damascus - katana', '2021-05-27 06:41:59', 'Active', 39),
(18, 'Hani', 'Al-Taweel', '1986-03-27', 'Male', 'Master', 'Married', 2, 'manager', 9, 'Doctor', 'From a friend', 'Damascus', '2021-05-27 06:26:49', 'Active', 39),
(19, 'Hani', 'Al-Taweel 2', '1986-03-27', 'Male', 'Master', 'Married', 2, 'manager', 9, 'Doctor', 'From a friend', 'Damascus', '2021-05-27 06:44:14', 'Inactive', 39),
(20, 'Hani', 'Al-Taweel 2', '1986-03-27', 'Male', 'Master', 'Married', 2, 'manager', 9, 'Doctor', 'From a friend', 'Damascus', '2021-05-27 06:44:56', 'Inactive', 39),
(21, 'Hani', 'Al-Taweel 3', '1986-03-27', 'Male', 'Master', 'Married', 3, 'manager', 9, 'Doctor', 'Internet', 'Damascus', '2021-05-27 06:57:53', 'Inactive', 39),
(22, 'Dala', 'Yusuf', '2019-03-28', 'Female', 'Master', 'Single', NULL, 'Developer', 8, '', 'From a friend', 'Damascus', '2021-06-03 07:20:50', 'Active', 27),
(23, 'Flex', 'Solutions', '1981-08-21', 'Female', 'Master', 'Married', 2, 'doctor', 8, 'doctor', 'From a friend', 'Mazzeh', '2022-03-14 11:01:07', 'Active', 41),
(24, 'hani', 'tawil111', '2022-06-03', 'Male', 'Undergraduate', 'Single', NULL, 'pilot', 8, '', 'From a friend', 'mazze', '2022-06-14 12:27:31', 'Active', 44),
(25, 'hanoshi', 'hanoshi', '1985-07-01', 'Male', 'Master', 'Married', 2, 'pilot', 4, '-', 'Social Media', 'maze', '2022-07-01 11:49:57', 'Active', 47);

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

--
-- Table structure for table `patients_body_measures`
--

CREATE TABLE `patients_body_measures` (
  `id` int(11) NOT NULL,
  `patient_id` int(11) NOT NULL,
  `body_measure_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `measure` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `patients_body_measures`
--

INSERT INTO `patients_body_measures` (`id`, `patient_id`, `body_measure_id`, `date`, `measure`) VALUES
(21, 3, 14, '2020-11-03', 4.3),
(22, 3, 13, '2020-11-03', 5.2),
(23, 3, 8, '2020-11-03', 60),
(24, 3, 9, '2020-11-03', 5.59),
(25, 3, 15, '2020-11-03', 4),
(26, 3, 16, '2020-11-03', 1.2),
(27, 3, 10, '2020-11-03', 20),
(28, 3, 17, '2020-11-03', 6.9),
(29, 3, 7, '2020-11-03', 53.49),
(30, 3, 14, '2020-11-03', 2.4),
(53, 3, 14, '2021-01-25', 8.9),
(54, 3, 13, '2021-01-25', 1.1),
(55, 3, 8, '2021-01-25', 13),
(56, 3, 9, '2021-01-25', 4),
(57, 3, 15, '2021-01-25', 50),
(58, 3, 16, '2021-01-25', 3.5),
(59, 3, 10, '2021-01-25', 24.3),
(60, 3, 17, '2021-01-25', 21),
(61, 3, 7, '2021-01-25', 32),
(62, 3, 14, '2021-01-25', 30.2),
(63, 3, 13, '2021-01-25', 10.7),
(64, 3, 8, '2021-01-25', 22),
(65, 3, 9, '2021-01-25', 5.83),
(66, 3, 15, '2021-01-25', 4.5),
(67, 3, 16, '2021-01-25', 9.5),
(68, 3, 10, '2021-01-25', NULL),
(69, 3, 17, '2021-01-25', NULL),
(70, 3, 7, '2021-01-25', NULL),
(93, 2, 14, '2021-01-25', NULL),
(94, 2, 22, '2021-01-25', NULL),
(95, 2, 13, '2021-01-25', NULL),
(96, 2, 19, '2021-01-25', NULL),
(97, 2, 8, '2021-01-25', NULL),
(98, 2, 9, '2021-01-25', NULL),
(99, 2, 15, '2021-01-25', NULL),
(100, 2, 16, '2021-01-25', NULL),
(101, 2, 10, '2021-01-25', NULL),
(102, 2, 17, '2021-01-25', NULL),
(103, 2, 7, '2021-01-25', NULL),
(104, 2, 14, '2021-01-25', NULL),
(105, 2, 22, '2021-01-25', NULL),
(106, 2, 13, '2021-01-25', NULL),
(107, 2, 19, '2021-01-25', NULL),
(108, 2, 8, '2021-01-25', NULL),
(109, 2, 9, '2021-01-25', NULL),
(110, 2, 15, '2021-01-25', NULL),
(111, 2, 16, '2021-01-25', NULL),
(112, 2, 10, '2021-01-25', NULL),
(113, 2, 17, '2021-01-25', NULL),
(114, 2, 7, '2021-01-25', NULL),
(321, 4, 14, '2021-01-25', NULL),
(322, 4, 22, '2021-01-25', NULL),
(323, 4, 13, '2021-01-25', NULL),
(324, 4, 19, '2021-01-25', NULL),
(325, 4, 8, '2021-01-25', NULL),
(326, 4, 9, '2021-01-25', NULL),
(327, 4, 15, '2021-01-25', NULL),
(328, 4, 6, '2021-01-25', NULL),
(329, 4, 11, '2021-01-25', NULL),
(330, 4, 16, '2021-01-25', NULL),
(331, 4, 10, '2021-01-25', NULL),
(332, 4, 17, '2021-01-25', NULL),
(333, 4, 7, '2021-01-25', NULL),
(334, 4, 12, '2021-01-25', NULL),
(388, 5, 14, '2021-01-31', NULL),
(389, 5, 22, '2021-01-31', NULL),
(390, 5, 13, '2021-01-31', NULL),
(391, 5, 19, '2021-01-31', NULL),
(392, 5, 8, '2021-01-31', NULL),
(393, 5, 9, '2021-01-31', NULL),
(394, 5, 15, '2021-01-31', NULL),
(395, 5, 6, '2021-01-31', NULL),
(396, 5, 11, '2021-01-31', NULL),
(397, 5, 16, '2021-01-31', NULL),
(398, 5, 10, '2021-01-31', NULL),
(399, 5, 17, '2021-01-31', NULL),
(400, 5, 7, '2021-01-31', NULL),
(401, 5, 12, '2021-01-31', NULL),
(413, 3, 23, '2021-02-25', NULL),
(474, 7, 14, '2021-03-01', NULL),
(475, 7, 22, '2021-03-01', NULL),
(476, 7, 13, '2021-03-01', NULL),
(477, 7, 19, '2021-03-01', NULL),
(478, 7, 8, '2021-03-01', NULL),
(479, 7, 9, '2021-03-01', NULL),
(480, 7, 15, '2021-03-01', NULL),
(481, 7, 6, '2021-03-01', NULL),
(482, 7, 11, '2021-03-01', NULL),
(483, 7, 16, '2021-03-01', NULL),
(484, 7, 10, '2021-03-01', NULL),
(485, 7, 17, '2021-03-01', NULL),
(486, 7, 23, '2021-03-01', NULL),
(487, 7, 7, '2021-03-01', NULL),
(488, 7, 12, '2021-03-01', NULL),
(522, 1, 14, '2021-03-14', NULL),
(523, 1, 22, '2021-03-14', NULL),
(524, 1, 13, '2021-03-14', NULL),
(525, 1, 19, '2021-03-14', NULL),
(526, 1, 8, '2021-03-14', NULL),
(527, 1, 9, '2021-03-14', NULL),
(528, 1, 15, '2021-03-14', NULL),
(529, 1, 16, '2021-03-14', NULL),
(530, 1, 10, '2021-03-14', NULL),
(531, 1, 17, '2021-03-14', NULL),
(532, 1, 23, '2021-03-14', NULL),
(533, 1, 7, '2021-03-14', NULL),
(534, 8, 14, '2021-03-14', NULL),
(535, 8, 22, '2021-03-14', NULL),
(536, 8, 13, '2021-03-14', NULL),
(537, 8, 19, '2021-03-14', NULL),
(538, 8, 8, '2021-03-14', NULL),
(539, 8, 9, '2021-03-14', NULL),
(540, 8, 15, '2021-03-14', NULL),
(541, 8, 6, '2021-03-14', NULL),
(542, 8, 11, '2021-03-14', NULL),
(543, 8, 16, '2021-03-14', NULL),
(544, 8, 10, '2021-03-14', NULL),
(545, 8, 17, '2021-03-14', NULL),
(546, 8, 23, '2021-03-14', NULL),
(547, 8, 7, '2021-03-14', NULL),
(548, 8, 12, '2021-03-14', NULL),
(615, 3, 14, '2021-03-15', NULL),
(616, 3, 22, '2021-03-15', NULL),
(617, 3, 13, '2021-03-15', NULL),
(618, 3, 19, '2021-03-15', NULL),
(619, 3, 8, '2021-03-15', NULL),
(620, 3, 9, '2021-03-15', NULL),
(621, 3, 15, '2021-03-15', NULL),
(622, 3, 16, '2021-03-15', NULL),
(623, 3, 10, '2021-03-15', NULL),
(624, 3, 17, '2021-03-15', NULL),
(625, 3, 23, '2021-03-15', NULL),
(626, 3, 7, '2021-03-15', NULL),
(649, 9, 14, '2021-03-18', NULL),
(650, 9, 22, '2021-03-18', NULL),
(651, 9, 13, '2021-03-18', NULL),
(652, 9, 19, '2021-03-18', NULL),
(653, 9, 8, '2021-03-18', NULL),
(654, 9, 9, '2021-03-18', NULL),
(655, 9, 15, '2021-03-18', NULL),
(656, 9, 6, '2021-03-18', NULL),
(657, 9, 11, '2021-03-18', NULL),
(658, 9, 16, '2021-03-18', NULL),
(659, 9, 10, '2021-03-18', NULL),
(660, 9, 17, '2021-03-18', NULL),
(661, 9, 23, '2021-03-18', NULL),
(662, 9, 7, '2021-03-18', NULL),
(663, 9, 12, '2021-03-18', NULL),
(664, 1, 22, '2021-03-18', NULL),
(665, 3, 7, '2021-03-24', 5.4),
(666, 3, 7, '2021-03-24', 6.1),
(667, 4, 7, '2021-03-24', 3.39),
(668, 10, 6, '2021-04-19', 170),
(669, 10, 7, '2021-04-19', 60),
(670, 10, 8, '2021-04-19', 10),
(671, 10, 9, '2021-04-19', 1.5),
(672, 10, 10, '2021-04-19', 2),
(673, 10, 11, '2021-04-19', 4),
(674, 10, 12, '2021-04-19', 70),
(675, 10, 13, '2021-04-19', 24),
(676, 10, 14, '2021-04-19', 23),
(677, 10, 15, '2021-04-19', 3),
(678, 10, 16, '2021-04-19', 2),
(679, 10, 17, '2021-04-19', 23.1),
(680, 10, 22, '2021-04-19', 54),
(681, 10, 23, '2021-04-19', 55),
(682, 11, 6, '2021-04-19', 160),
(683, 11, 7, '2021-04-19', 60),
(684, 11, 8, '2021-04-19', 30),
(685, 11, 9, '2021-04-19', 20),
(686, 11, 10, '2021-04-19', 10),
(687, 11, 11, '2021-04-19', 12),
(688, 11, 12, '2021-04-19', 55),
(689, 11, 13, '2021-04-19', 10),
(690, 11, 14, '2021-04-19', 2),
(691, 11, 15, '2021-04-19', 2),
(692, 11, 16, '2021-04-19', 1),
(693, 11, 17, '2021-04-19', 21),
(694, 11, 22, '2021-04-19', 2),
(695, 11, 23, '2021-04-19', 50),
(696, 12, 6, '2021-04-19', 160),
(697, 12, 7, '2021-04-19', 60),
(698, 12, 8, '2021-04-19', 30),
(699, 12, 9, '2021-04-19', 20),
(700, 12, 10, '2021-04-19', 10),
(701, 12, 11, '2021-04-19', 12),
(702, 12, 12, '2021-04-19', 55),
(703, 12, 13, '2021-04-19', 10),
(704, 12, 14, '2021-04-19', 2),
(705, 12, 15, '2021-04-19', 2),
(706, 12, 16, '2021-04-19', 1),
(707, 12, 17, '2021-04-19', 21),
(708, 12, 22, '2021-04-19', 2),
(709, 12, 23, '2021-04-19', 50),
(755, 3, 6, '2021-04-19', 177),
(756, 3, 7, '2021-04-19', 55),
(757, 3, 23, '2021-04-19', 50),
(758, 3, 19, '2021-04-19', 17.555619394172),
(759, 13, 6, '2021-04-19', 160),
(760, 13, 7, '2021-04-19', 60),
(761, 13, 8, '2021-04-19', 30),
(762, 13, 9, '2021-04-19', 20),
(763, 13, 10, '2021-04-19', 10),
(764, 13, 11, '2021-04-19', 12),
(765, 13, 12, '2021-04-19', 55),
(766, 13, 13, '2021-04-19', 10),
(767, 13, 14, '2021-04-19', 2),
(768, 13, 15, '2021-04-19', 2),
(769, 13, 16, '2021-04-19', 1),
(770, 13, 17, '2021-04-19', 21),
(771, 13, 22, '2021-04-19', 2),
(772, 13, 23, '2021-04-19', 50),
(773, 13, 19, '2021-04-20', 23.4375),
(774, 14, 6, '2021-04-19', 165),
(775, 14, 7, '2021-04-19', 60),
(776, 14, 8, '2021-04-19', 30),
(777, 14, 9, '2021-04-19', 20),
(778, 14, 10, '2021-04-19', 10),
(779, 14, 11, '2021-04-19', 12),
(780, 14, 12, '2021-04-19', 55),
(781, 14, 13, '2021-04-19', 10),
(782, 14, 14, '2021-04-19', 2),
(783, 14, 15, '2021-04-19', 2),
(784, 14, 16, '2021-04-19', 1),
(785, 14, 17, '2021-04-19', 21),
(786, 14, 22, '2021-04-19', 2),
(787, 14, 23, '2021-04-19', 50),
(788, 14, 19, '2021-04-20', 22.038567493113),
(789, 3, 16, '2021-04-20', 70),
(790, 3, 19, '2021-04-20', 17.555619394172),
(802, 3, 22, '2021-04-21', 5),
(810, 3, 8, '2021-04-21', 10),
(811, 3, 9, '2021-04-21', 6),
(812, 3, 10, '2021-04-21', 2),
(813, 3, 11, '2021-04-21', 24),
(814, 3, 12, '2021-04-21', 50),
(815, 3, 13, '2021-04-21', 10),
(816, 3, 14, '2021-04-21', 4),
(817, 3, 15, '2021-04-21', 45),
(818, 3, 17, '2021-04-21', 30),
(819, 3, 6, '2021-04-21', 200),
(820, 3, 19, '2021-04-21', 12.5),
(823, 3, 7, '2021-04-21', 50),
(824, 3, 23, '2021-04-21', 20),
(945, 3, 13, '2020-11-01', 1),
(946, 3, 8, '2020-11-01', 1),
(947, 3, 9, '2020-11-01', 20),
(948, 3, 15, '2020-11-01', 30),
(949, 3, 6, '2020-11-01', 170),
(950, 3, 11, '2020-11-01', 3),
(951, 3, 16, '2020-11-01', 4),
(952, 3, 10, '2020-11-01', 10),
(953, 3, 17, '2020-11-01', 3),
(954, 3, 7, '2020-11-01', 50),
(955, 3, 12, '2020-11-01', 55),
(956, 3, 19, '2020-11-01', 12.5),
(957, 3, 7, '2021-05-03', 53),
(958, 3, 19, '2021-05-03', 13.25),
(959, 3, 22, '2021-05-03', 3),
(960, 15, 6, '2021-05-26', 179),
(961, 15, 7, '2021-05-26', 106),
(962, 15, 8, '2021-05-26', 0),
(963, 15, 9, '2021-05-26', 0),
(964, 15, 23, '2021-05-26', 84),
(965, 15, 19, '2021-05-26', 33.082612902219),
(966, 16, 6, '2021-05-26', 179),
(967, 16, 7, '2021-05-26', 106),
(968, 16, 8, '2021-05-26', 1),
(969, 16, 9, '2021-05-26', 1),
(970, 16, 23, '2021-05-26', 84),
(971, 16, 19, '2021-05-26', 33.082612902219),
(996, 18, 6, '2021-05-27', 170),
(997, 18, 7, '2021-05-27', 75),
(998, 18, 8, '2021-05-27', 30),
(999, 18, 9, '2021-05-27', 20),
(1000, 18, 23, '2021-05-27', 70),
(1001, 18, 19, '2021-05-27', 25.951557093426),
(1020, 17, 6, '2021-05-27', 160),
(1021, 17, 7, '2021-05-27', 77),
(1022, 17, 8, '2021-05-27', 20),
(1023, 17, 9, '2021-05-27', 30),
(1024, 17, 23, '2021-05-27', 70),
(1025, 17, 19, '2021-05-27', 30.078125),
(1026, 19, 6, '2021-05-27', 170),
(1027, 19, 7, '2021-05-27', 77),
(1028, 19, 8, '2021-05-27', 30),
(1029, 19, 9, '2021-05-27', 20),
(1030, 19, 23, '2021-05-27', 70),
(1031, 19, 19, '2021-05-27', 26.643598615917),
(1038, 20, 6, '2021-05-27', 170),
(1039, 20, 7, '2021-05-27', 77),
(1040, 20, 8, '2021-05-27', 30),
(1041, 20, 9, '2021-05-27', 20),
(1042, 20, 23, '2021-05-27', 70),
(1043, 20, 19, '2021-05-27', 26.643598615917),
(1044, 21, 6, '2021-05-27', 170),
(1045, 21, 7, '2021-05-27', 77),
(1046, 21, 8, '2021-05-27', 30),
(1047, 21, 9, '2021-05-27', 20),
(1048, 21, 23, '2021-05-27', 70),
(1049, 21, 19, '2021-05-27', 26.643598615917),
(1062, 22, 6, '2021-06-02', 152),
(1063, 22, 7, '2021-06-02', 54),
(1064, 22, 8, '2021-06-02', 1),
(1065, 22, 9, '2021-06-02', 2),
(1066, 22, 19, '2021-06-02', 23.37),
(1067, 22, 23, '2021-06-02', 53),
(1068, 22, 6, '2021-06-03', 152),
(1069, 22, 7, '2021-06-03', 55),
(1070, 22, 9, '2021-06-03', 3),
(1071, 22, 19, '2021-06-03', 23.80540166205),
(1072, 22, 8, '2021-06-03', 2),
(1080, 23, 6, '2022-03-14', 160),
(1081, 23, 7, '2022-03-14', 67),
(1082, 23, 8, '2022-03-14', 4),
(1083, 23, 9, '2022-03-14', 30),
(1084, 23, 19, '2022-03-14', 26.17),
(1085, 23, 23, '2022-03-14', 50),
(1086, 23, 25, '2022-03-14', 10),
(1099, 24, 6, '2022-06-03', 180),
(1100, 24, 7, '2022-06-03', 110),
(1101, 24, 8, '2022-06-03', 20),
(1102, 24, 9, '2022-06-03', 40),
(1103, 24, 19, '2022-06-03', 33.95),
(1104, 24, 23, '2022-06-03', 100),
(1105, 24, 6, '2022-06-14', 178),
(1106, 24, 19, '2022-06-14', 23.671253629592),
(1107, 24, 7, '2022-06-14', 75),
(1108, 25, 6, '2022-07-01', 180),
(1109, 25, 7, '2022-07-01', 100),
(1110, 25, 8, '2022-07-01', 0),
(1111, 25, 9, '2022-07-01', 0),
(1112, 25, 19, '2022-07-01', 30.86),
(1113, 25, 23, '2022-07-01', 0);

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

--
-- Table structure for table `patients_diet_programs`
--

CREATE TABLE `patients_diet_programs` (
  `id` int(11) NOT NULL,
  `patient_id` int(11) NOT NULL,
  `type` enum('Normal','Shock','Medical') NOT NULL,
  `condition` text DEFAULT NULL,
  `days_number` int(11) NOT NULL,
  `calorie_plan_id` int(11) NOT NULL,
  `created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `patients_diet_programs`
--

INSERT INTO `patients_diet_programs` (`id`, `patient_id`, `type`, `condition`, `days_number`, `calorie_plan_id`, `created_at`) VALUES
(27, 24, 'Normal', '', 7, 10, '2022-06-04 12:23:03'),
(28, 24, 'Normal', '', 1, 10, '2022-08-07 12:23:09');

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

--
-- Table structure for table `patients_diseases`
--

CREATE TABLE `patients_diseases` (
  `id` int(11) NOT NULL,
  `patient_id` int(11) NOT NULL,
  `disease_id` int(11) NOT NULL,
  `option_id` int(11) DEFAULT NULL,
  `value` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `patients_diseases`
--

INSERT INTO `patients_diseases` (`id`, `patient_id`, `disease_id`, `option_id`, `value`) VALUES
(1, 2, 1, 1, NULL),
(44, 4, 1, 47, NULL),
(53, 5, 1, 47, NULL),
(65, 7, 1, 47, NULL),
(75, 9, 2, 73, NULL),
(82, 13, 2, 73, NULL),
(83, 13, 3, 65, NULL),
(84, 14, 1, NULL, 'headach'),
(85, 14, 2, 73, NULL),
(86, 14, 3, 65, NULL),
(107, 3, 2, 73, NULL),
(108, 3, 3, 65, NULL),
(109, 3, 1, NULL, NULL),
(127, 3, 16, 102, NULL),
(129, 22, 9, 84, NULL),
(130, 22, 5, 78, NULL),
(135, 23, 4, 86, NULL),
(136, 23, 7, 82, NULL),
(137, 23, 9, 84, NULL),
(138, 23, 10, 90, NULL),
(139, 23, 15, NULL, 'No'),
(140, 23, 17, 112, NULL),
(169, 24, 4, 88, NULL),
(170, 24, 5, 79, NULL),
(171, 24, 6, 81, NULL),
(172, 24, 7, 83, NULL),
(173, 24, 8, NULL, '-'),
(174, 24, 9, 85, NULL),
(175, 24, 10, 90, NULL),
(176, 24, 11, 92, NULL),
(177, 24, 12, 94, NULL),
(178, 24, 13, 96, NULL),
(179, 24, 14, 98, NULL),
(180, 24, 15, NULL, '-'),
(181, 24, 19, NULL, '150'),
(182, 24, 20, NULL, '100');

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

--
-- Table structure for table `patient_medical_test_requests`
--

CREATE TABLE `patient_medical_test_requests` (
  `id` int(11) NOT NULL,
  `medical_test_id` int(11) NOT NULL,
  `medical_test_type_id` int(11) NOT NULL,
  `property_id` int(11) NOT NULL,
  `property_value` text DEFAULT NULL,
  `option_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `patient_medical_test_requests`
--

INSERT INTO `patient_medical_test_requests` (`id`, `medical_test_id`, `medical_test_type_id`, `property_id`, `property_value`, `option_id`) VALUES
(18, 24, 2, 5, NULL, NULL),
(19, 24, 2, 30, NULL, NULL),
(30, 2, 2, 30, '13', NULL),
(32, 2, 2, 31, NULL, 5),
(33, 26, 2, 5, NULL, NULL),
(34, 26, 2, 30, NULL, 5),
(35, 26, 2, 31, 'xyx', NULL),
(36, 26, 14, 49, NULL, NULL),
(37, 27, 2, 30, '7', NULL),
(38, 27, 2, 31, NULL, 9),
(40, 28, 34, 68, NULL, NULL),
(41, 29, 2, 61, NULL, NULL),
(42, 29, 2, 30, NULL, NULL),
(43, 30, 2, 29, NULL, NULL),
(44, 30, 2, 61, NULL, NULL),
(45, 30, 2, 30, NULL, NULL),
(46, 31, 23, 56, NULL, NULL),
(47, 32, 2, 29, NULL, 4),
(48, 32, 2, 61, '43', NULL),
(49, 32, 2, 30, '7', NULL),
(50, 33, 15, 50, '133', NULL),
(51, 34, 2, 29, NULL, NULL),
(52, 34, 2, 30, NULL, NULL),
(53, 35, 1, 23, NULL, NULL),
(54, 35, 1, 1, NULL, NULL),
(65, 37, 1, 1, '23', NULL),
(66, 37, 35, 71, '2.1', NULL),
(67, 37, 35, 76, '4.1', NULL),
(68, 37, 35, 74, '90', NULL),
(69, 38, 1, 23, '5', NULL),
(70, 38, 1, 1, '1.2', NULL),
(71, 38, 35, 73, '2', NULL),
(72, 38, 35, 69, '12', NULL),
(73, 38, 35, 71, '33', NULL),
(74, 38, 35, 74, '88', NULL),
(113, 36, 1, 1, NULL, NULL),
(114, 36, 35, 73, NULL, NULL),
(115, 36, 35, 75, NULL, NULL),
(116, 36, 35, 72, NULL, NULL),
(117, 36, 35, 70, NULL, NULL),
(118, 36, 35, 69, NULL, NULL),
(119, 36, 35, 74, NULL, NULL),
(127, 39, 1, 1, '5', NULL),
(128, 39, 35, 73, '6', NULL),
(129, 39, 35, 69, '12', NULL),
(130, 39, 35, 71, '50', NULL),
(131, 39, 35, 76, '150', NULL),
(132, 39, 35, 74, '24', NULL),
(133, 40, 1, 1, '40', NULL),
(134, 40, 35, 73, '5', NULL),
(135, 40, 35, 75, '16', NULL),
(136, 40, 35, 77, '100', NULL),
(137, 40, 35, 71, '25', NULL),
(138, 40, 35, 76, '100', NULL),
(139, 40, 35, 74, '35', NULL),
(140, 41, 1, 84, NULL, 20),
(141, 41, 1, 1, '14', NULL),
(142, 41, 1, 85, '0', NULL),
(143, 41, 1, 86, '13', NULL),
(144, 41, 2, 94, '88', NULL);

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

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` int(11) NOT NULL,
  `patient_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `amount` float NOT NULL,
  `notes` text DEFAULT NULL,
  `type` enum('PAYPAL','Cash') NOT NULL,
  `currency` enum('SYP','AED','BD','JOD','$','£') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `payments`
--

INSERT INTO `payments` (`id`, `patient_id`, `date`, `amount`, `notes`, `type`, `currency`) VALUES
(1, 3, '2020-10-26', 2000, 'Paid when visited at: 2020-10-26 09:26:49', 'PAYPAL', '£'),
(12, 1, '2021-01-31', 9000, 'Paid when visited at: 2021-01-31 08:32', 'PAYPAL', 'BD'),
(13, 1, '2021-01-31', 12000, 'Paid when visited at: 2021-01-31 03:40', 'PAYPAL', 'JOD'),
(14, 1, '2021-01-31', 30000, 'Paid when visited at: 2021-01-31 03:44', 'Cash', 'SYP'),
(15, 3, '2021-01-31', 9000, 'Paid when visited at: 2021-01-31 03:45', 'PAYPAL', 'SYP'),
(38, 22, '2021-06-03', 6000, 'Paid when visited at: 2021-06-03 07:33', 'PAYPAL', NULL),
(39, 22, '2021-06-03', 3000, 'Paid when visited at: 2021-06-03 07:34', 'PAYPAL', NULL),
(40, 22, '2021-06-03', 4000, 'Paid when visited at: 2021-06-03 07:35', 'Cash', 'SYP'),
(41, 22, '2021-06-03', 5000000000, 'Paid when visited at: 2021-06-03 07:40', 'Cash', 'SYP'),
(42, 22, '2021-06-03', 4000000000, 'Paid when visited at: 2021-06-03 07:42', 'PAYPAL', NULL),
(44, 23, '2022-03-14', 5000, 'Paid when visited at: 2022-03-14 09:38', 'Cash', 'SYP'),
(46, 4, '2022-03-14', 30000, 'Paid when visited at: 2022-03-14 11:19', 'Cash', 'SYP');

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

--
-- Table structure for table `questions`
--

CREATE TABLE `questions` (
  `id` int(11) NOT NULL,
  `question_text` varchar(250) NOT NULL,
  `default_value` varchar(200) DEFAULT NULL,
  `mandatory` tinyint(1) NOT NULL,
  `status` enum('Active','Inactive') NOT NULL DEFAULT 'Active'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `questions`
--

INSERT INTO `questions` (`id`, `question_text`, `default_value`, `mandatory`, `status`) VALUES
(1, 'How many cups of water do u drink a day?', '5', 1, 'Active'),
(3, 'How many cups of milk do you drink a day ?', '1', 0, 'Inactive'),
(4, 'How many cups of milk do you drink a month?', '1', 0, 'Inactive'),
(5, 'How many cups of milk do you drink a year?', '10', 0, 'Inactive'),
(6, 'How many cups of water do you drink a year?', '500', 1, 'Inactive'),
(7, 'How many cups of milk do you drink a year?', '', 0, 'Inactive'),
(9, 'How many cups of tea do u drink a day? sugar?', '1 cup with 1 tsp sugar', 1, 'Active'),
(10, 'How many cups of coffee do u drink a day? sugar?', '1 cup with 1 tsp sugar', 1, 'Active'),
(11, 'How many cups of nescafe do u drink a day? sugar?', '1 Mug with 1 tsp sugar', 1, 'Active'),
(12, 'Other drinks??', '', 0, 'Active'),
(13, 'How many meals do u eat a day?', '3', 1, 'Active'),
(14, 'Do u like  to drink milk?', 'Yes', 1, 'Active'),
(15, 'Do u like to drink yogurt?', 'Yes', 1, 'Active'),
(16, 'Do u eat sweets?', 'Yes', 1, 'Active'),
(17, 'Do you eat junk food? Frequency a week?', 'Yes - once', 1, 'Active'),
(18, 'Do u drink Soda drinks?', 'Yes', 0, 'Active'),
(19, 'Do you eat red meat?', 'Yes', 1, 'Active'),
(20, 'Do you eat chicken ? type ?', 'Yes ', 1, 'Active'),
(21, 'Do you eat Fish?', 'Yes', 1, 'Active'),
(22, 'Do you eat Tuna?', 'Yes', 1, 'Active'),
(23, 'Do you eat Egg?', 'Yes', 1, 'Active'),
(24, 'Do you eat Cheese?', 'Yes', 1, 'Active'),
(25, 'Do you eat salads?', 'Yes', 1, 'Active'),
(26, 'Do you eat fruits?', 'Yes', 1, 'Active'),
(27, 'Do you drink Cocktails/Juices?', 'Yes', 0, 'Inactive'),
(28, 'Do you eat Nuts?', 'Yes', 1, 'Active'),
(29, 'Do you smoke?', 'Yes', 1, 'Active'),
(30, 'Do you drink alcohol?', 'No', 1, 'Active'),
(31, 'Do you take any medicine?', 'No', 1, 'Active'),
(32, 'Do you have any food allergy?', 'No', 1, 'Active'),
(33, 'Do you often eat when you are bothered, annoyed, or sad?', 'Yes', 1, 'Active'),
(34, 'Do you play Sport?', 'Yes', 1, 'Active'),
(35, 'Type of eating?', 'Breakfast:  food @ 09:00AM -- Snack: food @ 11:00AM -- Lunch: food @ 02:00PM -- Snack: food @ 05:00PM -- Dinner: food @ 08:00PM ', 0, 'Active'),
(36, 'Prefered Food?', '', 1, 'Active'),
(37, 'Dislike any Food?', '', 1, 'Active'),
(39, 'How many cups of water do you drink?', '5', 0, 'Inactive');

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

--
-- Table structure for table `questions_answers`
--

CREATE TABLE `questions_answers` (
  `id` int(11) NOT NULL,
  `question_id` int(11) NOT NULL,
  `patient_id` int(11) NOT NULL,
  `answer` mediumtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `questions_answers`
--

INSERT INTO `questions_answers` (`id`, `question_id`, `patient_id`, `answer`) VALUES
(1, 1, 2, '3'),
(58, 1, 4, '3'),
(59, 3, 4, '1'),
(60, 4, 4, '1'),
(77, 1, 5, '3'),
(78, 3, 5, '1'),
(79, 4, 5, '1'),
(80, 5, 5, '10'),
(85, 1, 6, '3'),
(86, 3, 6, '1'),
(87, 4, 6, '1'),
(88, 5, 6, '10'),
(89, 6, 6, '1000'),
(105, 1, 7, '3'),
(106, 3, 7, '1'),
(107, 4, 7, '1'),
(108, 5, 7, '10'),
(109, 6, 7, '1000'),
(119, 1, 8, '3'),
(120, 3, 8, '1'),
(121, 4, 8, '1'),
(122, 6, 8, '10000'),
(147, 1, 9, '3'),
(148, 3, 9, '1'),
(149, 4, 9, '1'),
(150, 6, 9, '10000'),
(151, 1, 1, '1'),
(152, 3, 1, '1'),
(164, 1, 13, '3'),
(165, 3, 13, '1'),
(166, 4, 13, '1'),
(167, 7, 13, '10'),
(168, 6, 13, '10000'),
(169, 4, 12, '1'),
(170, 1, 14, '3'),
(171, 3, 14, '1'),
(172, 4, 14, '1'),
(173, 7, 14, '10'),
(214, 1, 3, '4'),
(215, 4, 3, '1'),
(216, 6, 3, '1000'),
(217, 7, 3, '10'),
(218, 1, 15, '3-5'),
(219, 9, 15, '1 cup with 1.5 tsp sugar'),
(220, 10, 15, '0'),
(221, 11, 15, '2 Mug with 2 tsp sugar'),
(222, 12, 15, ''),
(223, 13, 15, '2'),
(224, 14, 15, 'Yes'),
(225, 15, 15, 'Yes'),
(226, 16, 15, 'Yes'),
(227, 17, 15, 'Yes - twice at least'),
(228, 18, 15, 'Yes'),
(229, 19, 15, 'Yes'),
(230, 20, 15, 'Yes'),
(231, 21, 15, 'Yes'),
(232, 22, 15, 'Yes'),
(233, 23, 15, 'Yes'),
(234, 24, 15, 'Yes'),
(235, 25, 15, 'Yes'),
(236, 26, 15, 'Yes'),
(237, 27, 15, 'Yes'),
(238, 28, 15, 'Yes'),
(239, 29, 15, 'No'),
(240, 30, 15, 'No'),
(241, 31, 15, 'No'),
(242, 32, 15, 'No'),
(243, 33, 15, 'Yes'),
(244, 34, 15, 'No'),
(245, 35, 15, 'Breakfast:  food @ 08:00AM -- Snack: food @ 12:00AM -- Lunch: food @ 05:00PM -- Snack: food @ 07:00PM -- Dinner: food @ 09:00PM '),
(246, 36, 15, 'All kind of delcious food'),
(247, 37, 15, 'none.'),
(248, 1, 16, '3-5'),
(249, 9, 16, '1 cup with 1 tsp sugar'),
(250, 10, 16, '0'),
(251, 11, 16, '2 Mug with 2 tsp sugar'),
(252, 12, 16, ''),
(253, 13, 16, '2'),
(254, 14, 16, 'Yes'),
(255, 15, 16, 'Yes'),
(256, 16, 16, 'Yes'),
(257, 17, 16, 'Yes - twice at least'),
(258, 18, 16, 'Yes'),
(259, 19, 16, 'Yes'),
(260, 20, 16, 'Yes'),
(261, 21, 16, 'Yes'),
(262, 22, 16, 'Yes'),
(263, 23, 16, 'Yes'),
(264, 24, 16, 'Yes'),
(265, 25, 16, 'Yes'),
(266, 26, 16, 'Yes'),
(267, 27, 16, 'Yes'),
(268, 28, 16, 'Yes'),
(269, 29, 16, 'No'),
(270, 30, 16, 'No'),
(271, 31, 16, 'No'),
(272, 32, 16, 'No'),
(273, 33, 16, 'Yes'),
(274, 34, 16, 'No'),
(275, 35, 16, 'Breakfast:  food @ 08:00AM -- Snack: food @ 12:00AM -- Lunch: food @ 05:00PM -- Snack: food @ 07:00PM -- Dinner: food @ 09:00PM'),
(276, 36, 16, 'All kind of delcious food'),
(277, 37, 16, 'none.'),
(396, 1, 18, '3-5'),
(397, 9, 18, '1 cup with 1 tsp sugar'),
(398, 10, 18, '1 cup with 1 tsp sugar'),
(399, 11, 18, '1 Mug with 1 tsp sugar'),
(400, 13, 18, '2'),
(401, 14, 18, 'Yes'),
(402, 15, 18, 'Yes'),
(403, 16, 18, 'Yes'),
(404, 17, 18, 'Yes - once'),
(405, 18, 18, 'Yes'),
(406, 19, 18, 'Yes'),
(407, 20, 18, 'Yes'),
(408, 21, 18, 'Yes'),
(409, 22, 18, 'Yes'),
(410, 23, 18, 'Yes'),
(411, 24, 18, 'Yes'),
(412, 25, 18, 'Yes'),
(413, 26, 18, 'Yes'),
(414, 27, 18, 'Yes'),
(415, 28, 18, 'Yes'),
(416, 29, 18, 'Yes'),
(417, 30, 18, 'No'),
(418, 31, 18, 'No'),
(419, 32, 18, 'No'),
(420, 33, 18, 'Yes'),
(421, 34, 18, 'Yes'),
(422, 35, 18, 'Breakfast:  food @ 09:00AM -- Snack: food @ 11:00AM -- Lunch: food @ 02:00PM -- Snack: food @ 05:00PM -- Dinner: food @ 08:00PM '),
(423, 36, 18, 'Salad'),
(424, 37, 18, 'No'),
(512, 1, 17, '3-5'),
(513, 9, 17, '1 cup with 1 tsp sugar'),
(514, 10, 17, '1 cup with 1 tsp sugar'),
(515, 11, 17, '1 Mug with 1 tsp sugar'),
(516, 13, 17, '2'),
(517, 14, 17, 'Yes'),
(518, 15, 17, 'Yes'),
(519, 16, 17, 'Yes'),
(520, 17, 17, 'Yes - once'),
(521, 18, 17, 'Yes'),
(522, 19, 17, 'Yes'),
(523, 20, 17, 'Yes'),
(524, 21, 17, 'Yes'),
(525, 22, 17, 'Yes'),
(526, 23, 17, 'Yes'),
(527, 24, 17, 'Yes'),
(528, 25, 17, 'Yes'),
(529, 26, 17, 'Yes'),
(530, 27, 17, 'Yes'),
(531, 28, 17, 'Yes'),
(532, 29, 17, 'Yes'),
(533, 30, 17, 'No'),
(534, 31, 17, 'No'),
(535, 32, 17, 'No'),
(536, 33, 17, 'Yes'),
(537, 34, 17, 'Yes'),
(538, 35, 17, 'Breakfast:  food @ 09:00AM -- Snack: food @ 11:00AM -- Lunch: food @ 02:00PM -- Snack: food @ 05:00PM -- Dinner: food @ 08:00PM '),
(539, 36, 17, 'Salad'),
(540, 37, 17, 'No'),
(541, 1, 19, '3-5'),
(542, 9, 19, '1 cup with 1 tsp sugar'),
(543, 10, 19, '1 cup with 1 tsp sugar'),
(544, 11, 19, '1 Mug with 1 tsp sugar'),
(545, 12, 19, ''),
(546, 13, 19, '2'),
(547, 14, 19, 'Yes'),
(548, 15, 19, 'Yes'),
(549, 16, 19, 'Yes'),
(550, 17, 19, 'Yes - once'),
(551, 18, 19, 'Yes'),
(552, 19, 19, 'Yes'),
(553, 20, 19, 'Yes'),
(554, 21, 19, 'Yes'),
(555, 22, 19, 'Yes'),
(556, 23, 19, 'Yes'),
(557, 24, 19, 'Yes'),
(558, 25, 19, 'Yes'),
(559, 26, 19, 'Yes'),
(560, 27, 19, 'Yes'),
(561, 28, 19, 'Yes'),
(562, 29, 19, 'Yes'),
(563, 30, 19, 'No'),
(564, 31, 19, 'No'),
(565, 32, 19, 'No'),
(566, 33, 19, 'Yes'),
(567, 34, 19, 'Yes'),
(568, 35, 19, 'Breakfast:  food @ 09:00AM -- Snack: food @ 11:00AM -- Lunch: food @ 02:00PM -- Snack: food @ 05:00PM -- Dinner: food @ 08:00PM '),
(569, 36, 19, 'Salad'),
(570, 37, 19, 'No'),
(601, 1, 20, '3-5'),
(602, 9, 20, '1 cup with 1 tsp sugar'),
(603, 10, 20, '1 cup with 1 tsp sugar'),
(604, 11, 20, '1 Mug with 1 tsp sugar'),
(605, 13, 20, '2'),
(606, 14, 20, 'Yes'),
(607, 15, 20, 'Yes'),
(608, 16, 20, 'Yes'),
(609, 17, 20, 'Yes - once'),
(610, 18, 20, 'Yes'),
(611, 19, 20, 'Yes'),
(612, 20, 20, 'Yes'),
(613, 21, 20, 'Yes'),
(614, 22, 20, 'Yes'),
(615, 23, 20, 'Yes'),
(616, 24, 20, 'Yes'),
(617, 25, 20, 'Yes'),
(618, 26, 20, 'Yes'),
(619, 27, 20, 'Yes'),
(620, 28, 20, 'Yes'),
(621, 29, 20, 'Yes'),
(622, 30, 20, 'No'),
(623, 31, 20, 'No'),
(624, 32, 20, 'No'),
(625, 33, 20, 'Yes'),
(626, 34, 20, 'Yes'),
(627, 35, 20, 'Breakfast:  food @ 09:00AM -- Snack: food @ 11:00AM -- Lunch: food @ 02:00PM -- Snack: food @ 05:00PM -- Dinner: food @ 08:00PM '),
(628, 36, 20, 'Salad'),
(629, 37, 20, 'No'),
(630, 1, 21, '3-5'),
(631, 9, 21, '1 cup with 1 tsp sugar'),
(632, 10, 21, '1 cup with 1 tsp sugar'),
(633, 11, 21, '1 Mug with 1 tsp sugar'),
(634, 12, 21, ''),
(635, 13, 21, '2'),
(636, 14, 21, 'Yes'),
(637, 15, 21, 'Yes'),
(638, 16, 21, 'Yes'),
(639, 17, 21, 'Yes - once'),
(640, 18, 21, 'Yes'),
(641, 19, 21, 'Yes'),
(642, 20, 21, 'Yes'),
(643, 21, 21, 'Yes'),
(644, 22, 21, 'Yes'),
(645, 23, 21, 'Yes'),
(646, 24, 21, 'Yes'),
(647, 25, 21, 'Yes'),
(648, 26, 21, 'Yes'),
(649, 27, 21, 'Yes'),
(650, 28, 21, 'Yes'),
(651, 29, 21, 'Yes'),
(652, 30, 21, 'No'),
(653, 31, 21, 'No'),
(654, 32, 21, 'No'),
(655, 33, 21, 'Yes'),
(656, 34, 21, 'Yes'),
(657, 35, 21, 'Breakfast:  food @ 09:00AM -- Snack: food @ 11:00AM -- Lunch: food @ 02:00PM -- Snack: food @ 05:00PM -- Dinner: food @ 08:00PM '),
(658, 36, 21, 'Salad'),
(659, 37, 21, 'No'),
(719, 1, 22, '3-5'),
(720, 9, 22, '1 cup with 1 tsp sugar'),
(721, 10, 22, '1 cup with 1 tsp sugar'),
(722, 11, 22, '1 Mug with 1 tsp sugar'),
(723, 13, 22, '3'),
(724, 14, 22, 'Yes'),
(725, 15, 22, 'Yes'),
(726, 16, 22, 'Yes'),
(727, 17, 22, 'Yes - once'),
(728, 18, 22, 'Yes'),
(729, 19, 22, 'Yes'),
(730, 20, 22, 'Yes'),
(731, 21, 22, 'Yes'),
(732, 22, 22, 'Yes'),
(733, 23, 22, 'Yes'),
(734, 24, 22, 'Yes'),
(735, 25, 22, 'Yes'),
(736, 26, 22, 'Yes'),
(737, 27, 22, 'Yes'),
(738, 28, 22, 'Yes'),
(739, 29, 22, 'Yes'),
(740, 30, 22, 'No'),
(741, 31, 22, 'No'),
(742, 32, 22, 'No'),
(743, 33, 22, 'Yes'),
(744, 34, 22, 'Yes'),
(745, 35, 22, 'Breakfast:  food @ 09:00AM -- Snack: food @ 11:00AM -- Lunch: food @ 02:00PM -- Snack: food @ 05:00PM -- Dinner: food @ 08:00PM '),
(746, 36, 22, 'Salad'),
(747, 37, 22, 'No'),
(748, 12, 22, 'No'),
(781, 1, 23, '5'),
(782, 3, 23, '1'),
(783, 9, 23, '1 cup with 1 tsp sugar'),
(784, 10, 23, '1 cup with 1 tsp sugar'),
(785, 11, 23, '1 Mug with 1 tsp sugar'),
(786, 13, 23, '3'),
(787, 14, 23, 'Yes'),
(788, 15, 23, 'Yes'),
(789, 16, 23, 'Yes'),
(790, 17, 23, 'Yes - once'),
(791, 18, 23, 'No'),
(792, 19, 23, 'Yes'),
(793, 20, 23, 'Yes'),
(794, 21, 23, 'Yes'),
(795, 22, 23, 'No'),
(796, 23, 23, 'Yes'),
(797, 24, 23, 'Yes'),
(798, 25, 23, 'Yes'),
(799, 26, 23, 'Yes'),
(800, 27, 23, 'Yes'),
(801, 28, 23, 'Yes'),
(802, 29, 23, 'Yes'),
(803, 30, 23, 'No'),
(804, 31, 23, 'No'),
(805, 32, 23, 'No'),
(806, 33, 23, 'Yes'),
(807, 34, 23, 'Yes'),
(808, 35, 23, 'Breakfast:  food @ 09:00AM -- Snack: food @ 11:00AM -- Lunch: food @ 02:00PM -- Snack: food @ 05:00PM -- Dinner: food @ 08:00PM '),
(809, 36, 23, 'Rice'),
(810, 37, 23, 'no'),
(811, 39, 23, '5'),
(870, 1, 24, '5'),
(871, 9, 24, '1 cup with 1 tsp sugar'),
(872, 10, 24, '1 cup with 1 tsp sugar'),
(873, 11, 24, '1 Mug with 1 tsp sugar'),
(874, 12, 24, 'no'),
(875, 13, 24, '3'),
(876, 14, 24, 'Yes'),
(877, 15, 24, 'Yes'),
(878, 16, 24, 'Yes'),
(879, 17, 24, 'Yes - once'),
(880, 18, 24, 'Yes'),
(881, 19, 24, 'Yes'),
(882, 20, 24, 'Yes '),
(883, 21, 24, 'Yes'),
(884, 22, 24, 'Yes'),
(885, 23, 24, 'Yes'),
(886, 24, 24, 'Yes'),
(887, 25, 24, 'Yes'),
(888, 26, 24, 'Yes'),
(889, 28, 24, 'Yes'),
(890, 29, 24, 'Yes'),
(891, 30, 24, 'No'),
(892, 31, 24, 'No'),
(893, 32, 24, 'No'),
(894, 33, 24, 'Yes'),
(895, 34, 24, 'Yes'),
(896, 35, 24, 'Breakfast: coffe @ 09:00AM -- Snack: apple @ 11:00AM -- Lunch: steak@ 02:00PM -- Snack:banana @ 05:00PM -- Dinner:milk@ 08:00PM '),
(897, 36, 24, 'pasta'),
(898, 37, 24, 'veg'),
(899, 1, 25, '5'),
(900, 9, 25, '1 cup with 1 tsp sugar'),
(901, 10, 25, '1 cup with 1 tsp sugar'),
(902, 11, 25, '1 Mug with 1 tsp sugar'),
(903, 12, 25, ''),
(904, 13, 25, '3'),
(905, 14, 25, 'Yes'),
(906, 15, 25, 'Yes'),
(907, 16, 25, 'Yes'),
(908, 17, 25, 'Yes - once'),
(909, 18, 25, 'Yes'),
(910, 19, 25, 'Yes'),
(911, 20, 25, 'Yes '),
(912, 21, 25, 'Yes'),
(913, 22, 25, 'Yes'),
(914, 23, 25, 'Yes'),
(915, 24, 25, 'Yes'),
(916, 25, 25, 'Yes'),
(917, 26, 25, 'Yes'),
(918, 28, 25, 'Yes'),
(919, 29, 25, 'Yes'),
(920, 30, 25, 'No'),
(921, 31, 25, 'No'),
(922, 32, 25, 'No'),
(923, 33, 25, 'Yes'),
(924, 34, 25, 'Yes'),
(925, 35, 25, 'Breakfast:  food @ 09:00AM -- Snack: food @ 11:00AM -- Lunch: food @ 02:00PM -- Snack: food @ 05:00PM -- Dinner: food @ 08:00PM '),
(926, 36, 25, 'pasta'),
(927, 37, 25, 'veg');

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

--
-- Table structure for table `system_configurations`
--

CREATE TABLE `system_configurations` (
  `id` int(11) NOT NULL,
  `config_options` varchar(50) NOT NULL,
  `value` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `system_configurations`
--

INSERT INTO `system_configurations` (`id`, `config_options`, `value`) VALUES
(1, 'weekend', 'Sunday Saturday'),
(2, 'work_start_hour', '11:00 AM'),
(3, 'work_end_hour', '02:00 PM'),
(5, 'address', 'Mazzeh, city mall, floor 1'),
(6, 'request_appointment_limit', '5'),
(7, 'measures_update_period', '1'),
(8, 'clinic_phone_number', '+96311 6667466'),
(9, 'mobile_phone_number', '+963 949280073'),
(10, 'event_notification', 'Off'),
(11, 'general_event_notification', 'On'),
(12, 'about', 'Nutrition and health clinic'),
(14, 'facebook_contact', 'facebook.com/FoodToFitClinic'),
(15, 'instagram_contact', 'instagram.com/FoodToFitClinic');

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

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

CREATE TABLE `visits` (
  `id` int(11) NOT NULL,
  `patient_id` int(11) NOT NULL,
  `date_time` datetime NOT NULL,
  `diagnosis` text NOT NULL,
  `payment_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `visits` (`id`, `patient_id`, `date_time`, `diagnosis`, `payment_id`) VALUES
(2, 2, '2020-10-26 09:26:49', 'abc', 1),
(3, 2, '2020-10-26 01:20:32', '1234', NULL),
(6, 4, '2021-01-25 14:41:40', 'Register appointment (first visit)', NULL),
(7, 4, '2021-01-28 08:18:59', 'diagnosis', NULL),
(9, 1, '2021-01-31 08:32:24', '9598+626', 12),
(10, 5, '2021-01-31 15:11:50', 'Register appointment (first visit)', NULL),
(11, 1, '2021-01-31 03:40:33', 'dia', 13),
(12, 1, '2021-01-31 03:44:37', 'diagnosis', 14),
(13, 3, '2021-01-31 03:45:16', 'Obvious improvement in your health and body mesaures', 15),
(14, 3, '2021-02-10 12:56:00', 'diagnosis', NULL),
(16, 7, '2021-03-01 11:58:26', 'Register appointment (first visit)', NULL),
(17, 8, '2021-03-14 15:41:14', 'Register appointment (first visit)', NULL),
(18, 2, '2021-03-15 02:27:00', 'diagnosis', NULL),
(19, 9, '2021-03-18 10:07:27', 'Register appointment (first visit)', NULL),
(21, 14, '2021-04-19 14:25:40', 'Register appointment (first visit)', NULL),
(22, 17, '2021-05-27 06:53:23', 'Register appointment (first visit)', NULL),
(23, 20, '2021-05-27 07:44:35', 'Register appointment (first visit)', NULL),
(24, 22, '2021-06-02 10:48:00', 'Register appointment (first visit)', NULL),
(26, 22, '2021-06-03 07:33:00', 'visit', 38),
(27, 22, '2021-06-03 07:34:00', 'visit 2', 39),
(28, 22, '2021-06-03 07:35:39', 'daignosis', 40),
(29, 22, '2021-06-03 07:40:44', 'diagnosis', 41),
(30, 22, '2021-06-03 07:41:00', 'dia', 42),
(31, 23, '2022-03-14 09:36:25', 'Register appointment (first visit)', NULL),
(32, 23, '2022-03-14 09:38:47', 'visit', 44),
(33, 4, '2022-03-14 11:19:48', 'new visit', 46),
(34, 24, '2022-06-03 11:32:01', 'Register appointment (first visit)', NULL),
(35, 25, '2022-07-01 11:49:58', 'Register appointment (first visit)', NULL);

--
-- Indexes for table `appointments`
--
ALTER TABLE `appointments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `patient_id` (`patient_id`);

--
-- Indexes for table `appointments_management`
--
ALTER TABLE `appointments_management`
  ADD PRIMARY KEY (`id`);

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

--
-- Indexes for table `calorie_plans`
--
ALTER TABLE `calorie_plans`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `calorie_plans_properties`
--
ALTER TABLE `calorie_plans_properties`
  ADD PRIMARY KEY (`id`),
  ADD KEY `calorie_plan_id` (`calorie_plan_id`),
  ADD KEY `ingredient_category` (`ingredient_category`),
  ADD KEY `nutritional_value` (`nutritional_value`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `days`
--
ALTER TABLE `days`
  ADD PRIMARY KEY (`id`),
  ADD KEY `diet_program_id` (`diet_program_id`);

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

--
-- Indexes for table `diseases_options`
--
ALTER TABLE `diseases_options`
  ADD PRIMARY KEY (`id`),
  ADD KEY `disease_id` (`disease_id`);

--
-- Indexes for table `events`
--
ALTER TABLE `events`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `general_advices`
--
ALTER TABLE `general_advices`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ingredients`
--
ALTER TABLE `ingredients`
  ADD PRIMARY KEY (`id`),
  ADD KEY `category_id` (`category_id`);

--
-- Indexes for table `meals`
--
ALTER TABLE `meals`
  ADD PRIMARY KEY (`id`),
  ADD KEY `day_id` (`day_id`);

--
-- Indexes for table `meals_ingredients`
--
ALTER TABLE `meals_ingredients`
  ADD PRIMARY KEY (`id`),
  ADD KEY `meal_id` (`meal_id`),
  ADD KEY `ingredient_id` (`ingredient_id`),
  ADD KEY `category_id` (`category_id`);

--
-- Indexes for table `medical_tests`
--
ALTER TABLE `medical_tests`
  ADD PRIMARY KEY (`id`),
  ADD KEY `patient_id` (`patient_id`);

--
-- Indexes for table `medical_tests_images`
--
ALTER TABLE `medical_tests_images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `medical_test_id` (`medical_test_id`);

--
-- Indexes for table `medical_tests_properties_options`
--
ALTER TABLE `medical_tests_properties_options`
  ADD PRIMARY KEY (`id`),
  ADD KEY `property_type_id` (`property_type_id`);

--
-- Indexes for table `medical_tests_results`
--
ALTER TABLE `medical_tests_results`
  ADD PRIMARY KEY (`id`),
  ADD KEY `medical_test_id` (`medical_test_id`),
  ADD KEY `property_id` (`property_id`),
  ADD KEY `option_id` (`option_id`);

--
-- Indexes for table `medical_tests_types`
--
ALTER TABLE `medical_tests_types`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `medical_tests_types_properties`
--
ALTER TABLE `medical_tests_types_properties`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_index` (`type_id`,`property_name`),
  ADD KEY `type_id` (`type_id`);

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `FK_AccountNotification` (`account_id`),
  ADD KEY `FK_PatientNotification` (`patient_id`);

--
-- Indexes for table `nutritional_values`
--
ALTER TABLE `nutritional_values`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `patients`
--
ALTER TABLE `patients`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_patients_account_id` (`account_id`);

--
-- Indexes for table `patients_body_measures`
--
ALTER TABLE `patients_body_measures`
  ADD PRIMARY KEY (`id`),
  ADD KEY `body_measure_id` (`body_measure_id`);

--
-- Indexes for table `patients_diet_programs`
--
ALTER TABLE `patients_diet_programs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `patient_id` (`patient_id`),
  ADD KEY `calorie_plan_id` (`calorie_plan_id`);

--
-- Indexes for table `patients_diseases`
--
ALTER TABLE `patients_diseases`
  ADD PRIMARY KEY (`id`),
  ADD KEY `disease_id` (`disease_id`),
  ADD KEY `patient_id` (`patient_id`),
  ADD KEY `option_id` (`option_id`);

--
-- Indexes for table `patient_medical_test_requests`
--
ALTER TABLE `patient_medical_test_requests`
  ADD PRIMARY KEY (`id`),
  ADD KEY `FK_medicalTest` (`medical_test_id`),
  ADD KEY `FK_medicalTestType` (`medical_test_type_id`),
  ADD KEY `FK_medicalTestTypeProperties` (`property_id`),
  ADD KEY `FK_medicalTestTypeOptions` (`option_id`);

--
-- Indexes for table `payments`
--
ALTER TABLE `payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `patient_id` (`patient_id`);

--
-- Indexes for table `questions`
--
ALTER TABLE `questions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `questions_answers`
--
ALTER TABLE `questions_answers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `question_id` (`question_id`);

--
-- Indexes for table `system_configurations`
--
ALTER TABLE `system_configurations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `visits`
--
ALTER TABLE `visits`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `payment_id` (`payment_id`),
  ADD KEY `patient_id` (`patient_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `appointments`
--
ALTER TABLE `appointments`
  ADD CONSTRAINT `appointments_ibfk_1` FOREIGN KEY (`patient_id`) REFERENCES `patients` (`id`);

--
-- Constraints for table `calorie_plans_properties`
--
ALTER TABLE `calorie_plans_properties`
  ADD CONSTRAINT `calorie_plans_properties_ibfk_1` FOREIGN KEY (`calorie_plan_id`) REFERENCES `calorie_plans` (`id`),
  ADD CONSTRAINT `calorie_plans_properties_ibfk_2` FOREIGN KEY (`ingredient_category`) REFERENCES `categories` (`id`),
  ADD CONSTRAINT `calorie_plans_properties_ibfk_3` FOREIGN KEY (`nutritional_value`) REFERENCES `nutritional_values` (`id`);

--
-- Constraints for table `days`
--
ALTER TABLE `days`
  ADD CONSTRAINT `days_ibfk_1` FOREIGN KEY (`diet_program_id`) REFERENCES `patients_diet_programs` (`id`);

--
-- Constraints for table `diseases_options`
--
ALTER TABLE `diseases_options`
  ADD CONSTRAINT `diseases_options_ibfk_1` FOREIGN KEY (`disease_id`) REFERENCES `diseases` (`id`);

--
-- Constraints for table `ingredients`
--
ALTER TABLE `ingredients`
  ADD CONSTRAINT `ingredients_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`);

--
-- Constraints for table `meals`
--
ALTER TABLE `meals`
  ADD CONSTRAINT `meals_ibfk_1` FOREIGN KEY (`day_id`) REFERENCES `days` (`id`);

--
-- Constraints for table `meals_ingredients`
--
ALTER TABLE `meals_ingredients`
  ADD CONSTRAINT `meals_ingredients_ibfk_1` FOREIGN KEY (`meal_id`) REFERENCES `meals` (`id`),
  ADD CONSTRAINT `meals_ingredients_ibfk_2` FOREIGN KEY (`ingredient_id`) REFERENCES `ingredients` (`id`),
  ADD CONSTRAINT `meals_ingredients_ibfk_3` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`);

--
-- Constraints for table `medical_tests`
--
ALTER TABLE `medical_tests`
  ADD CONSTRAINT `medical_tests_ibfk_1` FOREIGN KEY (`patient_id`) REFERENCES `patients` (`id`);

--
-- Constraints for table `medical_tests_images`
--
ALTER TABLE `medical_tests_images`
  ADD CONSTRAINT `medical_tests_images_ibfk_1` FOREIGN KEY (`medical_test_id`) REFERENCES `medical_tests` (`id`);

--
-- Constraints for table `medical_tests_properties_options`
--
ALTER TABLE `medical_tests_properties_options`
  ADD CONSTRAINT `medical_tests_properties_options_ibfk_1` FOREIGN KEY (`property_type_id`) REFERENCES `medical_tests_types_properties` (`id`);

--
-- Constraints for table `medical_tests_results`
--
ALTER TABLE `medical_tests_results`
  ADD CONSTRAINT `medical_tests_results_ibfk_1` FOREIGN KEY (`medical_test_id`) REFERENCES `medical_tests` (`id`),
  ADD CONSTRAINT `medical_tests_results_ibfk_2` FOREIGN KEY (`property_id`) REFERENCES `medical_tests_types_properties` (`id`),
  ADD CONSTRAINT `medical_tests_results_ibfk_3` FOREIGN KEY (`option_id`) REFERENCES `medical_tests_properties_options` (`id`);

--
-- Constraints for table `medical_tests_types_properties`
--
ALTER TABLE `medical_tests_types_properties`
  ADD CONSTRAINT `medical_tests_types_properties_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `medical_tests_types` (`id`);

--
-- Constraints for table `notifications`
--
ALTER TABLE `notifications`
  ADD CONSTRAINT `FK_AccountNotification` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`),
  ADD CONSTRAINT `FK_PatientNotification` FOREIGN KEY (`patient_id`) REFERENCES `patients` (`id`);

--
-- Constraints for table `patients`
--
ALTER TABLE `patients`
  ADD CONSTRAINT `fk_patients_account_id` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`);

--
-- Constraints for table `patients_body_measures`
--
ALTER TABLE `patients_body_measures`
  ADD CONSTRAINT `patients_body_measures_ibfk_1` FOREIGN KEY (`body_measure_id`) REFERENCES `body_measures` (`id`);

--
-- Constraints for table `patients_diet_programs`
--
ALTER TABLE `patients_diet_programs`
  ADD CONSTRAINT `patients_diet_programs_ibfk_1` FOREIGN KEY (`patient_id`) REFERENCES `patients` (`id`),
  ADD CONSTRAINT `patients_diet_programs_ibfk_2` FOREIGN KEY (`calorie_plan_id`) REFERENCES `calorie_plans` (`id`);

--
-- Constraints for table `patients_diseases`
--
ALTER TABLE `patients_diseases`
  ADD CONSTRAINT `patients_diseases_ibfk_1` FOREIGN KEY (`disease_id`) REFERENCES `diseases` (`id`),
  ADD CONSTRAINT `patients_diseases_ibfk_2` FOREIGN KEY (`patient_id`) REFERENCES `patients` (`id`),
  ADD CONSTRAINT `patients_diseases_ibfk_3` FOREIGN KEY (`option_id`) REFERENCES `diseases_options` (`id`);

--
-- Constraints for table `patient_medical_test_requests`
--
ALTER TABLE `patient_medical_test_requests`
  ADD CONSTRAINT `FK_medicalTest` FOREIGN KEY (`medical_test_id`) REFERENCES `medical_tests` (`id`),
  ADD CONSTRAINT `FK_medicalTestType` FOREIGN KEY (`medical_test_type_id`) REFERENCES `medical_tests_types` (`id`),
  ADD CONSTRAINT `FK_medicalTestTypeOptions` FOREIGN KEY (`option_id`) REFERENCES `medical_tests_properties_options` (`id`),
  ADD CONSTRAINT `FK_medicalTestTypeProperties` FOREIGN KEY (`property_id`) REFERENCES `medical_tests_types_properties` (`id`);

--
-- Constraints for table `payments`
--
ALTER TABLE `payments`
  ADD CONSTRAINT `payments_ibfk_1` FOREIGN KEY (`patient_id`) REFERENCES `patients` (`id`);

--
-- Constraints for table `questions_answers`
--
ALTER TABLE `questions_answers`
  ADD CONSTRAINT `questions_answers_ibfk_1` FOREIGN KEY (`question_id`) REFERENCES `questions` (`id`);

--
-- Constraints for table `visits`
--
ALTER TABLE `visits`
  ADD CONSTRAINT `visits_ibfk_1` FOREIGN KEY (`patient_id`) REFERENCES `patients` (`id`),
  ADD CONSTRAINT `visits_ibfk_2` FOREIGN KEY (`payment_id`) REFERENCES `payments` (`id`);
COMMIT;

