-- phpMyAdmin SQL Dump -- version 5.2.2 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Feb 07, 2026 at 03:14 PM -- Server version: 8.0.36 -- PHP Version: 8.3.25 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `sevenpoi_myconsultation_db` -- -- -------------------------------------------------------- -- -- Table structure for table `client_blood_test_reports` -- CREATE TABLE `client_blood_test_reports` ( `report_id` int NOT NULL, `client_consultation_id` int NOT NULL, `report_date` varchar(10) DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `client_blood_test_reports` -- INSERT INTO `client_blood_test_reports` (`report_id`, `client_consultation_id`, `report_date`, `created_at`, `updated_at`) VALUES (1, 3, '14/01/2026', '2026-02-02 11:16:41', '2026-02-02 11:16:41'), (2, 4, '2026-01-27', '2026-02-04 12:40:22', '2026-02-04 12:40:22'); -- -------------------------------------------------------- -- -- Table structure for table `client_blood_test_results` -- CREATE TABLE `client_blood_test_results` ( `result_id` int NOT NULL, `report_id` int NOT NULL, `test_code` varchar(100) NOT NULL COMMENT 'e.g., hemoglobin, total_wbc. This should match the name attribute prefix in your form.', `value` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `client_blood_test_results` -- INSERT INTO `client_blood_test_results` (`result_id`, `report_id`, `test_code`, `value`) VALUES (1, 1, 'hemoglobin', '11.9 gm/dL'), (2, 1, 'total_wbc', '5910'), (3, 1, 'total_rbc', '4.9'), (4, 1, 'platelet', '331'), (5, 1, 'pcv', '38.1'), (6, 1, 'mcv', '77.8'), (7, 1, 'mch', '24.3'), (8, 1, 'mchc', '31.2'), (9, 1, 'rdw', '15.2'), (10, 1, 'eosinophils', '2.4'), (11, 1, 'fasting_glucose', '80'), (12, 1, 'fasting_insulin', '5.1'), (13, 1, 'hba1c_hplc', '5.2'), (14, 1, 'avg_plasma_glucose', '102.54'), (15, 1, 'uric_acid', '4.6'), (16, 1, 'bun', '10.9'), (17, 1, 's_creatinine', '0.71'), (18, 1, 'sodium', '137'), (19, 1, 'chloride', '105'), (20, 1, 'egfr', '121.7'), (21, 1, 'bilirubin_total', '0.3'), (22, 1, 'bilirubin_direct', '0.1'), (23, 1, 'bilirubin_indirect', '0.2'), (24, 1, 'sgpt_alt', '7'), (25, 1, 'sgot', '15'), (26, 1, 'protein', '7.1'), (27, 1, 'albumin', '4.55'), (28, 1, 'globulin', '2.55'), (29, 1, 'ag_ratio', '1.78'), (30, 1, 'homocystin', '10.22'), (31, 1, 'cholesterol', '176'), (32, 1, 'triglyceride', '77'), (33, 1, 'hdl', '47'), (34, 1, 'ldl', '113.6'), (35, 1, 'vldl', '15.4'), (36, 1, 'ldl_hdl_ratio', '2.4'), (37, 1, 'chol_hdl_ratio', '3.74'), (38, 1, 'crp', '1.08'), (39, 1, 'vit_d3', '20.2'), (40, 1, 'vit_b12', '355'), (41, 1, 't3', '2.38'), (42, 1, 't4', '0.95'), (43, 1, 'tsh', '1.02'), (44, 2, 'hemoglobin', '12.17'), (45, 2, 'total_rbc', '4.53'), (46, 2, 'platelet', '407 thou/mm3'), (47, 2, 'pcv', '37.20'), (48, 2, 'mcv', '82.20'), (49, 2, 'mch', '26.90'), (50, 2, 'mchc', '32.70'), (51, 2, 'rdw', '14.70'), (52, 2, 'eosinophils', '4.80'), (53, 2, 'fasting_glucose', '105'), (54, 2, 'hba1c_hplc', '5.8'), (55, 2, 'uric_acid', '4.52'), (56, 2, 'bun', '9.96'), (57, 2, 's_creatinine', '0.71'), (58, 2, 'bun_creatinine_ratio', '14'), (59, 2, 'sodium', '137'), (60, 2, 'chloride', '102'), (61, 2, 'egfr', '120'), (62, 2, 'bilirubin_total', '0.43'), (63, 2, 'bilirubin_direct', '0.07'), (64, 2, 'bilirubin_indirect', '0.36'), (65, 2, 'sgpt_alt', '11.5'), (66, 2, 'sgot', '21.9'), (67, 2, 'protein', '7.71'), (68, 2, 'albumin', '4.65'), (69, 2, 'globulin', '3.06'), (70, 2, 'ag_ratio', '1.52'), (71, 2, 'cholesterol', '208.97'), (72, 2, 'triglyceride', '104.80'), (73, 2, 'hdl', '42.18'), (74, 2, 'ldl', '145.83'), (75, 2, 'vldl', '20.96'), (76, 2, 'homocystin', '8.32'), (77, 2, 'crp', '5.19'), (78, 2, 'vit_d3', '33.06 nmol/L'), (79, 2, 'vit_b12', '461.53'), (80, 2, 'testosterone', '26.83'), (81, 2, 't3', '0.86 ng/ml'), (82, 2, 't4', '8.81 ug/dl'), (83, 2, 'tsh', '1.57 ulu/ml'); -- -------------------------------------------------------- -- -- Table structure for table `client_consultations` -- CREATE TABLE `client_consultations` ( `client_consultation_id` int NOT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `consultation_date` datetime DEFAULT CURRENT_TIMESTAMP, `gender` varchar(10) DEFAULT NULL COMMENT 'Male, Female, Other', `marital_status` varchar(20) DEFAULT NULL COMMENT 'Single, Married, Divorced, Widowed, Prefer not to say', `height_cms` decimal(5,1) DEFAULT NULL, `weight_kg` decimal(5,1) DEFAULT NULL, `age_years` int DEFAULT NULL, `shift_duty` varchar(3) DEFAULT NULL COMMENT 'Yes, No', `joint_family` varchar(3) DEFAULT NULL COMMENT 'Yes, No', `is_vegetarian` varchar(3) DEFAULT NULL COMMENT 'Yes, No', `is_vegan` varchar(3) DEFAULT NULL COMMENT 'Yes, No', `is_jain` varchar(3) DEFAULT NULL COMMENT 'Yes, No', `has_lactose_intolerance` varchar(3) DEFAULT NULL COMMENT 'Yes, No', `date_of_payment` date DEFAULT NULL, `health_issues` text, `food_liking` text, `food_disliking` text, `job_description` text, `job_timings` varchar(100) DEFAULT NULL, `sedentary_status` varchar(10) DEFAULT NULL COMMENT 'Yes, No, Partly', `travelling_frequency` varchar(20) DEFAULT NULL COMMENT 'No, Sometimes, Extensively', `is_latest` tinyint(1) DEFAULT '1', `is_finalized` tinyint(1) DEFAULT '0', `is_food_plan_complete` tinyint(1) DEFAULT '0' COMMENT '0=Pending, 1=Completed', `user_id` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `client_consultations` -- INSERT INTO `client_consultations` (`client_consultation_id`, `created_at`, `updated_at`, `consultation_date`, `gender`, `marital_status`, `height_cms`, `weight_kg`, `age_years`, `shift_duty`, `joint_family`, `is_vegetarian`, `is_vegan`, `is_jain`, `has_lactose_intolerance`, `date_of_payment`, `health_issues`, `food_liking`, `food_disliking`, `job_description`, `job_timings`, `sedentary_status`, `travelling_frequency`, `is_latest`, `is_finalized`, `is_food_plan_complete`, `user_id`) VALUES (1, '2026-01-12 12:34:55', '2026-01-12 12:34:55', '2026-01-12 18:04:55', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0, 2), (2, '2026-01-18 07:31:20', '2026-01-18 07:36:36', '2026-01-18 13:01:20', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0, 3), (3, '2026-01-23 16:20:27', '2026-02-02 11:55:28', '2026-01-23 21:50:27', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0, 4), (4, '2026-01-30 06:55:15', '2026-02-05 06:08:57', '2026-01-30 12:25:15', 'Female', 'Single', 153.6, 48.0, 26, 'No', 'No', 'Yes', 'No', 'No', 'Yes', '2026-01-30', 'acidity, eyesight, inflammation on the face, acne-prone skin, anxiety', 'paratha bread aalo sabzi idli dosa pav bhaji pani puri soup pasta bajra roti with gud daal chawal', 'karela tinda roti ', 'Architect', NULL, NULL, 'Extensively', 1, 0, 0, 5), (5, '2026-02-01 12:00:04', '2026-02-02 11:28:52', '2026-02-01 17:30:04', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0, 6), (6, '2026-02-01 12:59:42', '2026-02-01 12:59:42', '2026-02-01 18:29:42', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0, 7), (7, '2026-02-02 11:24:27', '2026-02-02 11:24:27', '2026-02-02 16:54:27', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0, 8), (8, '2026-02-02 11:32:58', '2026-02-02 11:32:58', '2026-02-02 17:02:58', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 0, 9), (9, '2026-02-03 15:58:42', '2026-02-05 08:10:08', '2026-02-03 21:28:42', 'Female', 'Married', 5.0, 68.0, 36, 'No', 'Yes', 'No', NULL, 'Yes', NULL, '2026-02-03', 'sugar ,cholesterol high, weekness ', 'normal ', NULL, 'seating job - back office 9 hr insurer company ', '9.30 to 7', 'Yes', 'Extensively', 1, 0, 0, 10); -- -------------------------------------------------------- -- -- Table structure for table `client_follow_ups` -- CREATE TABLE `client_follow_ups` ( `follow_up_id` int NOT NULL, `client_id` int NOT NULL, `follow_up_date` date NOT NULL, `client_report` text, `admin_instructions` text, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `client_food_plans` -- CREATE TABLE `client_food_plans` ( `plan_id` int NOT NULL, `client_consultation_id` int NOT NULL, `general_recommendations` text, `additional_personal_recommendations` text, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `created_by_admin_id` int DEFAULT NULL, `created_by_nutritionist_id` int UNSIGNED DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `client_food_plans` -- INSERT INTO `client_food_plans` (`plan_id`, `client_consultation_id`, `general_recommendations`, `additional_personal_recommendations`, `created_at`, `updated_at`, `created_by_admin_id`, `created_by_nutritionist_id`) VALUES (1, 2, NULL, NULL, '2026-01-18 07:36:36', '2026-01-18 07:36:36', NULL, NULL), (2, 5, NULL, NULL, '2026-02-02 11:28:52', '2026-02-02 11:28:52', NULL, NULL), (4, 3, NULL, '
  1. Take colostrum daily once 
  2. Take Vit D 60 k once a week for 8 weeks and then once a month for 12 months 
', '2026-02-03 21:43:03', '2026-02-03 21:43:03', 1, NULL), (6, 4, NULL, '
  1. Grape seed extracts {HImalayan Organics) twice a day for 3 months 
', '2026-02-06 00:57:34', '2026-02-06 00:57:34', 1, NULL); -- -------------------------------------------------------- -- -- Table structure for table `client_food_plan_hourly_details` -- CREATE TABLE `client_food_plan_hourly_details` ( `detail_id` int NOT NULL, `plan_id` int NOT NULL, `time_slot` varchar(10) NOT NULL COMMENT 'e.g., 06:00, 13:00', `present_intake` text, `proposed_structure` text, `additional_points` text ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `client_food_plan_hourly_details` -- INSERT INTO `client_food_plan_hourly_details` (`detail_id`, `plan_id`, `time_slot`, `present_intake`, `proposed_structure`, `additional_points`) VALUES (1, 1, '06:00', 'ukala', NULL, NULL), (19, 4, '08:00', 'Water', NULL, NULL), (20, 4, '09:00', 'Water + Dry fruits', 'Avoid any type of food at this time', NULL), (21, 4, '10:00', 'Water + Fruits\nBanana/ kiwi/ Orange/ Blueberry/ Pomegranate/ Pineapple', 'Avoid any type of fruit at this time', NULL), (22, 4, '11:00', 'Water + Breakfast\neggs, tomato, lettuce, cheese, Meal replacement drink (Huel)', 'Soup or Vegetable Juice, Soaked nuts, Seasonal Fruits (Please eat fruits 20 minutes before other food)', NULL), (23, 4, '12:00', 'Water', NULL, NULL), (24, 4, '13:00', 'Water', NULL, NULL), (25, 4, '14:00', 'Water + Lunch\nveg: Rice, dal, potato paratha, rajma, chole, protein wraps with brocoli,corn,onion,tomato,lettuce,potato pattice\nNon-veg: chicken, egg, rice, chapati, protein wraps with brocoli,corn,onion,tomato,lettuce,chicken', 'Your food intake for lunch is correct but also take Milkshake with Protein, curd, limboo pickle', NULL), (26, 4, '15:00', 'Water', NULL, NULL), (27, 4, '16:00', 'Water', NULL, NULL), (28, 4, '17:00', 'Water', NULL, NULL), (29, 4, '18:00', 'Water + Chiracafe', 'Chiracafe is ok ,but without milk', NULL), (30, 4, '19:00', 'Water', NULL, NULL), (31, 4, '20:00', 'Water', NULL, NULL), (32, 4, '21:00', 'Water + Lunch\nveg: Rice, dal, potato paratha, rajma, chole, protein wraps with brocoli,corn,onion,tomato,lettuce,potato pattice\nNon-veg: chicken, egg, rice, chapati, protein wraps with brocoli,corn,onion,tomato,lettuce,chicken, egg fried rice and chicken', 'Your food intake for dinner is correct but In addition to your food intake take curd, galic pickle, flax seed chatni, ', NULL), (33, 4, '22:00', 'Water', NULL, NULL), (34, 4, '23:00', 'Water', NULL, NULL), (35, 4, '00:00', 'Water', NULL, NULL), (41, 6, '09:00', 'chia seed-soaked nuts peanut butter bread banana', 'Vegetable Juice, Soaked nuts / Paneer recipe ', NULL), (42, 6, '11:00', 'papaya protein powder', 'Protein Ladoo / Bar / DRufruit Chikki', NULL), (43, 6, '13:00', '2 wheat roti sabji dahi ', 'Jawar / Bajra Bhakri , Palebhaji, curd, 3 colored salad, falx seed chatni, dryfruit milkshake with Whey protein + fruit smoothie', NULL), (44, 6, '16:00', 'bread butter', 'Detox Drink ( I will send the recipe) ', NULL), (45, 6, '21:00', 'dal chawal paneer ghee ', 'Soup + green smoothie, Usal, Rice, Paneer, Curd, 3 colored salad, Garlic pickle', NULL); -- -------------------------------------------------------- -- -- Table structure for table `client_medical_history` -- CREATE TABLE `client_medical_history` ( `history_id` int NOT NULL, `client_consultation_id` int NOT NULL, `family_medical_history` text, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `client_medical_history` -- INSERT INTO `client_medical_history` (`history_id`, `client_consultation_id`, `family_medical_history`, `created_at`, `updated_at`) VALUES (1, 3, 'No medical history.\n', '2026-02-02 11:18:13', '2026-02-02 11:18:13'), (3, 4, 'Sugar and arthritis ', '2026-02-04 12:08:11', '2026-02-04 12:08:11'); -- -------------------------------------------------------- -- -- Table structure for table `client_medications` -- CREATE TABLE `client_medications` ( `medication_id` int NOT NULL, `history_id` int NOT NULL, `diagnosis` varchar(255) DEFAULT NULL, `medicine_name` varchar(255) DEFAULT NULL, `power` varchar(100) DEFAULT NULL, `timing` varchar(100) DEFAULT NULL, `since_when` varchar(100) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `general_food_recommendations` -- CREATE TABLE `general_food_recommendations` ( `id` int NOT NULL, `recommendations_text` text, `last_updated_by` int DEFAULT NULL, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `general_food_recommendations` -- INSERT INTO `general_food_recommendations` (`id`, `recommendations_text`, `last_updated_by`, `updated_at`) VALUES (1, '

General guidelines:-

(1) Vegetable Juice means - Doodhi (1) : Kakdi (1) : Gajar (1/2) : Beet (1/4) :Tomato (1/4) in this proportion. Use Juiceer as far as possible. If you add little water , Mixer will also do. But drink CLEAR Juice, without fiber.

(2) For Curcumin, Omega 3 capsule please contact Prasanna Rasayan, Thane – 9869418118.

(3) For 7.4 Farsan and Sweets Please either make it at home or get it from Rajashree Shivpuje, Kurla Mumbai - 9322594323

(4) If possible, change from A1 milk to A2 milk.

(5) For CMD (concentrated minerals drops) contact Dr Ketan Patkar – 9222221620

(6) If you feel hungry in between twi food servings you may have any of these drinks --Ukala / 7.4 Coffee / Butter milk / Masala milk / Soup / Limboo Sarbat / Solkadhi / Kheer – Doodhi / Carrot / Lalbhopla, khova, nuts, milk masala.Hibiscus tea, Jasmine tea,  [(Pudina + Coriender + Panipuri masala + Ginger Shot (simple words- Panipuri water) + Chia seeds water.] (Use Stevia as a sweetener)   

(7) Paan : Paan + Pumpkin seeds + Flax seed + Ilachi + Ghreen Patti + Jysthimadh + Katha + chuna.

(8) Link for Himalayan Organics - Multivitamin with probiotics - https://www.amazon.in/Himalayan-Organics-Multivitamin-Probiotics-Ingredients/dp/B0B5R7FX3H/ref=sr_1_5adgrpid=1327112144297213&hvadid=82944767671541&hvbmt=be&hvdev=c&hvlocphy=90&hvnetw=o&hvqmt=e&hvtargid=kwd-82945389859439%3Aloc-90&hydadcr=2534_1936664&keywords=himalayan+organics+multivitamin+with+probiotics&qid=1683773166&sr=8-5

(9) LInk for Himalayan Organics   - Grape seed Extracts - https://www.amazon.in/Himalayan-Organics-Antioxidant-Supplement-Cholesterol/dp/B09X5D5BJG?th=1

(10) For Stevia (natural alternative to sugar)  contact Arvind Sane -  9850746172

(11) For FOS (natural alternative to sugar)- Dr Mrunal Saraf - 9324140899

Personal Guidlines:-

(1)  Please practice every day for 15 minutes – Kapalbhati, Agnisar Anulom Vilom

(2) 15 minutes sleeping resting posture as given in my book 7.4 or You Tube

(3) 30 minutes casual walk and drink 150 ml water per hour.

(4) Himalayan multivitamin tablets with probiotic twice a day for 3 months

(5) 10 CMD (concentrated minerals drops) in the morning with 150 ml water (for 6 months)

(6) Implement the above food plan step by step. Follow 36 hours fasting (only water) every 15 days. You may proceed step by step, it is ok

(7) Learn and Practice Dhanwantary Yog for 15 minutes daily.

(8) I have observed that many a times clients feel that there is no variety and within a short period he gets bored with the food plan. To address this issue I give below following links to help you out of this problems. The ingrediants used are not 7.4 compatible. But you can select healthy options and make these racipes and enjoy. 

  1.  

     

     

     

', 1, '2026-02-03 08:06:39'); -- -------------------------------------------------------- -- -- Table structure for table `roles` -- CREATE TABLE `roles` ( `role_id` int NOT NULL, `role_name` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `roles` -- INSERT INTO `roles` (`role_id`, `role_name`) VALUES (1, 'admin'), (2, 'client'), (5, 'executive'), (4, 'nutritionist'), (3, 'staff'); -- -------------------------------------------------------- -- -- Table structure for table `users_v2` -- CREATE TABLE `users_v2` ( `user_id` int NOT NULL, `first_name` varchar(255) NOT NULL, `last_name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `password_hash` varchar(255) NOT NULL, `mobile_number` varchar(20) DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT '1', `is_email_verified` tinyint(1) NOT NULL DEFAULT '0', `email_verification_token` varchar(255) DEFAULT NULL, `password_reset_token` varchar(255) DEFAULT NULL, `password_reset_expires_at` datetime DEFAULT NULL, `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `address_1` varchar(255) DEFAULT NULL, `address_2` varchar(255) DEFAULT NULL, `address_3` varchar(255) DEFAULT NULL, `city` varchar(100) DEFAULT NULL, `pincode` varchar(10) DEFAULT NULL, `reference_source` varchar(255) DEFAULT NULL, `assigned_nutritionist_id` int DEFAULT NULL, `assigned_executive_id` int DEFAULT NULL, `email_otp` varchar(10) DEFAULT NULL, `email_otp_expires_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `users_v2` -- INSERT INTO `users_v2` (`user_id`, `first_name`, `last_name`, `email`, `password_hash`, `mobile_number`, `is_active`, `is_email_verified`, `email_verification_token`, `password_reset_token`, `password_reset_expires_at`, `created_at`, `updated_at`, `address_1`, `address_2`, `address_3`, `city`, `pincode`, `reference_source`, `assigned_nutritionist_id`, `assigned_executive_id`, `email_otp`, `email_otp_expires_at`) VALUES (1, 'Madhav', 'Joshi', 'madhavjoshi02@example.com', '$2a$12$ONvYUcRyl5BBThoU1kjTveFebSdRLHSEUhjgCgDHuZDVEx.gPFZk6', NULL, 1, 1, NULL, NULL, NULL, '2025-12-21 10:44:37', '2025-12-21 10:44:37', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (2, 'Manasi', 'A', 'manasi@example.com', '$2a$12$ONvYUcRyl5BBThoU1kjTveFebSdRLHSEUhjgCgDHuZDVEx.gPFZk6', '1234567890', 1, 1, NULL, NULL, NULL, '2026-01-12 12:34:55', '2026-01-12 19:14:21', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (3, 'Asmita', 'A', 'asmita@example.com', '$2a$12$ONvYUcRyl5BBThoU1kjTveFebSdRLHSEUhjgCgDHuZDVEx.gPFZk6', '1234567891', 1, 1, NULL, NULL, NULL, '2026-01-18 07:31:20', '2026-01-18 07:33:02', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4, 'Shreya R', 'Bane', 'shreya@example.com', '$2a$12$ONvYUcRyl5BBThoU1kjTveFebSdRLHSEUhjgCgDHuZDVEx.gPFZk6', '1234567892', 1, 1, NULL, NULL, NULL, '2026-01-23 16:20:27', '2026-01-24 02:03:24', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (5, 'Sanskruti', 'T', 'sanskruti@example.com', '$2a$12$ONvYUcRyl5BBThoU1kjTveFebSdRLHSEUhjgCgDHuZDVEx.gPFZk6', '1234567893', 1, 1, NULL, NULL, NULL, '2026-01-30 06:55:15', '2026-02-05 06:08:57', 'Vedant Sapphire Sneh Nagar ', '', '', 'Nagpur', '440015', 'Mona Jain', NULL, NULL, NULL, NULL), (6, 'Vrushali', 'B', 'vrushali@example.com', '$2a$12$ONvYUcRyl5BBThoU1kjTveFebSdRLHSEUhjgCgDHuZDVEx.gPFZk6', '1234567894', 1, 1, NULL, NULL, NULL, '2026-02-01 12:00:04', '2026-02-01 12:08:45', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (7, 'Dr Saylee', 'U', 'drsaylee@example.com', '$2a$12$ONvYUcRyl5BBThoU1kjTveFebSdRLHSEUhjgCgDHuZDVEx.gPFZk6', '1234567895', 1, 1, NULL, NULL, NULL, '2026-02-01 12:59:42', '2026-02-01 19:17:11', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (8, 'Vidya', 'K', 'vidya@example.com', '$2a$12$ONvYUcRyl5BBThoU1kjTveFebSdRLHSEUhjgCgDHuZDVEx.gPFZk6', '+1234567896', 1, 1, NULL, NULL, NULL, '2026-02-02 11:24:27', '2026-02-02 11:34:46', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (9, 'Asawari', 'V', 'asawari@example.com', '$2a$12$ONvYUcRyl5BBThoU1kjTveFebSdRLHSEUhjgCgDHuZDVEx.gPFZk6', '1234567897', 1, 1, NULL, NULL, NULL, '2026-02-02 11:32:58', '2026-02-02 11:34:49', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), (10, 'Ashwini ', 'C', 'ashwini@example.com', '$2a$12$ONvYUcRyl5BBThoU1kjTveFebSdRLHSEUhjgCgDHuZDVEx.gPFZk6', '1234567898', 1, 1, NULL, NULL, NULL, '2026-02-03 15:58:42', '2026-02-05 08:10:08', '24 /C/003 Sai sadan chandivali mahada colony andheri east 4000072', '', '', '', '400072', 'prakalp Talwalkar', NULL, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `user_roles` -- CREATE TABLE `user_roles` ( `user_id` int NOT NULL, `role_id` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `user_roles` -- INSERT INTO `user_roles` (`user_id`, `role_id`) VALUES (1, 1), (2, 2), (3, 2), (4, 2), (5, 2), (6, 2), (7, 2), (8, 2), (9, 2), (10, 2); -- -- Indexes for dumped tables -- -- -- Indexes for table `client_blood_test_reports` -- ALTER TABLE `client_blood_test_reports` ADD PRIMARY KEY (`report_id`), ADD KEY `client_consultation_id` (`client_consultation_id`); -- -- Indexes for table `client_blood_test_results` -- ALTER TABLE `client_blood_test_results` ADD PRIMARY KEY (`result_id`), ADD KEY `report_id` (`report_id`), ADD KEY `test_code` (`test_code`); -- -- Indexes for table `client_consultations` -- ALTER TABLE `client_consultations` ADD PRIMARY KEY (`client_consultation_id`), ADD KEY `fk_consultation_user` (`user_id`); -- -- Indexes for table `client_follow_ups` -- ALTER TABLE `client_follow_ups` ADD PRIMARY KEY (`follow_up_id`), ADD UNIQUE KEY `client_id` (`client_id`,`follow_up_date`); -- -- Indexes for table `client_food_plans` -- ALTER TABLE `client_food_plans` ADD PRIMARY KEY (`plan_id`), ADD KEY `fk_created_by_admin` (`created_by_admin_id`), ADD KEY `client_food_plans_ibfk_1` (`client_consultation_id`); -- -- Indexes for table `client_food_plan_hourly_details` -- ALTER TABLE `client_food_plan_hourly_details` ADD PRIMARY KEY (`detail_id`), ADD KEY `plan_id` (`plan_id`,`time_slot`); -- -- Indexes for table `client_medical_history` -- ALTER TABLE `client_medical_history` ADD PRIMARY KEY (`history_id`), ADD KEY `client_consultation_id` (`client_consultation_id`); -- -- Indexes for table `client_medications` -- ALTER TABLE `client_medications` ADD PRIMARY KEY (`medication_id`), ADD KEY `history_id` (`history_id`); -- -- Indexes for table `general_food_recommendations` -- ALTER TABLE `general_food_recommendations` ADD PRIMARY KEY (`id`), ADD KEY `last_updated_by` (`last_updated_by`); -- -- Indexes for table `roles` -- ALTER TABLE `roles` ADD PRIMARY KEY (`role_id`), ADD UNIQUE KEY `role_name` (`role_name`); -- -- Indexes for table `users_v2` -- ALTER TABLE `users_v2` ADD PRIMARY KEY (`user_id`), ADD UNIQUE KEY `email` (`email`), ADD KEY `fk_users_v2_nutritionist` (`assigned_nutritionist_id`), ADD KEY `fk_users_v2_executive` (`assigned_executive_id`); -- -- Indexes for table `user_roles` -- ALTER TABLE `user_roles` ADD PRIMARY KEY (`user_id`,`role_id`), ADD KEY `fk_user_roles_role_id` (`role_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `client_blood_test_reports` -- ALTER TABLE `client_blood_test_reports` MODIFY `report_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `client_blood_test_results` -- ALTER TABLE `client_blood_test_results` MODIFY `result_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=84; -- -- AUTO_INCREMENT for table `client_consultations` -- ALTER TABLE `client_consultations` MODIFY `client_consultation_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `client_follow_ups` -- ALTER TABLE `client_follow_ups` MODIFY `follow_up_id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `client_food_plans` -- ALTER TABLE `client_food_plans` MODIFY `plan_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `client_food_plan_hourly_details` -- ALTER TABLE `client_food_plan_hourly_details` MODIFY `detail_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46; -- -- AUTO_INCREMENT for table `client_medical_history` -- ALTER TABLE `client_medical_history` MODIFY `history_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `client_medications` -- ALTER TABLE `client_medications` MODIFY `medication_id` int NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `general_food_recommendations` -- ALTER TABLE `general_food_recommendations` MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `roles` -- ALTER TABLE `roles` MODIFY `role_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `users_v2` -- ALTER TABLE `users_v2` MODIFY `user_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- Constraints for dumped tables -- -- -- Constraints for table `client_blood_test_reports` -- ALTER TABLE `client_blood_test_reports` ADD CONSTRAINT `client_blood_test_reports_ibfk_1` FOREIGN KEY (`client_consultation_id`) REFERENCES `client_consultations` (`client_consultation_id`) ON DELETE CASCADE; -- -- Constraints for table `client_blood_test_results` -- ALTER TABLE `client_blood_test_results` ADD CONSTRAINT `client_blood_test_results_ibfk_1` FOREIGN KEY (`report_id`) REFERENCES `client_blood_test_reports` (`report_id`) ON DELETE CASCADE; -- -- Constraints for table `client_consultations` -- ALTER TABLE `client_consultations` ADD CONSTRAINT `fk_consultation_user` FOREIGN KEY (`user_id`) REFERENCES `users_v2` (`user_id`) ON DELETE CASCADE; -- -- Constraints for table `client_food_plans` -- ALTER TABLE `client_food_plans` ADD CONSTRAINT `client_food_plans_ibfk_1` FOREIGN KEY (`client_consultation_id`) REFERENCES `client_consultations` (`client_consultation_id`) ON DELETE CASCADE; -- -- Constraints for table `client_food_plan_hourly_details` -- ALTER TABLE `client_food_plan_hourly_details` ADD CONSTRAINT `client_food_plan_hourly_details_ibfk_1` FOREIGN KEY (`plan_id`) REFERENCES `client_food_plans` (`plan_id`) ON DELETE CASCADE; -- -- Constraints for table `client_medical_history` -- ALTER TABLE `client_medical_history` ADD CONSTRAINT `client_medical_history_ibfk_1` FOREIGN KEY (`client_consultation_id`) REFERENCES `client_consultations` (`client_consultation_id`) ON DELETE CASCADE; -- -- Constraints for table `client_medications` -- ALTER TABLE `client_medications` ADD CONSTRAINT `client_medications_ibfk_1` FOREIGN KEY (`history_id`) REFERENCES `client_medical_history` (`history_id`) ON DELETE CASCADE; -- -- Constraints for table `users_v2` -- ALTER TABLE `users_v2` ADD CONSTRAINT `fk_users_v2_executive` FOREIGN KEY (`assigned_executive_id`) REFERENCES `users_v2` (`user_id`) ON DELETE SET NULL, ADD CONSTRAINT `fk_users_v2_nutritionist` FOREIGN KEY (`assigned_nutritionist_id`) REFERENCES `users_v2` (`user_id`) ON DELETE SET NULL; -- -- Constraints for table `user_roles` -- ALTER TABLE `user_roles` ADD CONSTRAINT `fk_user_roles_role_id` FOREIGN KEY (`role_id`) REFERENCES `roles` (`role_id`) ON DELETE CASCADE, ADD CONSTRAINT `fk_user_roles_user_id` FOREIGN KEY (`user_id`) REFERENCES `users_v2` (`user_id`) ON DELETE CASCADE; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;