ohctech/ohctechv3
Template
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
main
ohctechv3/.svn/pristine/6b/6b1381070680f31761ac75c1d42694be48a3a4e7.svn-base
raj_mehra 4d410ad0e1 first commit
2024-10-28 15:03:36 +05:30

4157 lines
141 KiB
Plaintext
Raw Permalink Blame History

-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Sep 19, 2024 at 06:35 AM
-- Server version: 10.4.24-MariaDB
-- PHP Version: 7.4.29
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: `ohctech`
--
-- --------------------------------------------------------
--
-- Table structure for table `abnormality`
--
CREATE TABLE `abnormality` (
`abnormality_id` bigint(20) NOT NULL,
`abnormality_name` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`wellness_program` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `abnormality`
--
INSERT INTO `abnormality` (`abnormality_id`, `abnormality_name`, `last_modified`, `modified_by`, `wellness_program`) VALUES
(1, 'test', '2024-09-10 20:38:00.000000', 2, '1,2'),
(2, 'test1', '2024-09-10 19:44:47.000000', 2, '2,1'),
(4, 'test55', '2024-09-11 09:55:36.000000', 2, '1,2');
-- --------------------------------------------------------
--
-- Table structure for table `add_filter_master`
--
CREATE TABLE `add_filter_master` (
`filter_id` bigint(20) NOT NULL,
`filter_code` varchar(255) DEFAULT NULL,
`filter_name` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `add_filter_master`
--
INSERT INTO `add_filter_master` (`filter_id`, `filter_code`, `filter_name`, `last_modified`, `modified_by`) VALUES
(1, 'testt', 'testt', '2024-09-03 17:11:26.000000', 2),
(3, 'test2', 'test2', '2024-09-03 17:12:05.000000', 2);
-- --------------------------------------------------------
--
-- Table structure for table `ailment`
--
CREATE TABLE `ailment` (
`ailment_id` bigint(20) NOT NULL,
`ailment_code` varchar(10) DEFAULT NULL,
`ailment_desc` varchar(255) DEFAULT NULL,
`ailment_name` varchar(255) DEFAULT NULL,
`is_active` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `ailment`
--
INSERT INTO `ailment` (`ailment_id`, `ailment_code`, `ailment_desc`, `ailment_name`, `is_active`, `last_modified`, `modified_by`) VALUES
(1, 'ASG3435', '# BOTH BONES LEFT FOREARM', '# BOTH BONES LEFT FOREARM', 'Yes', '2024-09-09 19:23:44.000000', 2),
(2, 'ASG3435', 'test', 'test', 'No', '2024-09-12 19:12:37.000000', 2),
(3, 'test1', 'test1', 'test1', 'No', '2024-09-12 19:12:49.000000', 2),
(4, 'ASG3435', '# BOTH BONES LEFT FOREARM', 'test1', 'No', '2024-09-13 10:58:48.000000', 2);
-- --------------------------------------------------------
--
-- Table structure for table `ailment_system`
--
CREATE TABLE `ailment_system` (
`ailment_sys_id` bigint(20) NOT NULL,
`ailment_sys_code` varchar(20) DEFAULT NULL,
`ailment_sys_desc` varchar(255) DEFAULT NULL,
`ailment_sys_name` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `ailment_system`
--
INSERT INTO `ailment_system` (`ailment_sys_id`, `ailment_sys_code`, `ailment_sys_desc`, `ailment_sys_name`, `last_modified`, `modified_by`) VALUES
(1, 'CARDIO', 'CARDIOVASCULAR', 'CARDIOVASCULAR SYSTEM', '2024-09-09 19:19:58.000000', 2),
(2, 'testt', 'testt', 'CENTRAL NERVOUS SYSTEM', '2024-09-09 19:20:54.000000', 2);
-- --------------------------------------------------------
--
-- Table structure for table `ambulance_category`
--
CREATE TABLE `ambulance_category` (
`ambulance_category_id` bigint(20) NOT NULL,
`ambulance_category` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `ambulance_category`
--
INSERT INTO `ambulance_category` (`ambulance_category_id`, `ambulance_category`, `last_modified`, `modified_by`) VALUES
(1, 'Non Ac', '2024-09-06 08:41:21.000000', 2),
(2, 'Ac', '2024-09-06 08:44:05.000000', 2);
-- --------------------------------------------------------
--
-- Table structure for table `ambulance_details_new`
--
CREATE TABLE `ambulance_details_new` (
`ambulance_id` bigint(20) NOT NULL,
`ambulance_name` varchar(255) DEFAULT NULL,
`ambulance_number` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`ambulance_category_id` bigint(20) DEFAULT NULL,
`ohc_type_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `ambulance_details_new`
--
INSERT INTO `ambulance_details_new` (`ambulance_id`, `ambulance_name`, `ambulance_number`, `last_modified`, `modified_by`, `ambulance_category_id`, `ohc_type_id`) VALUES
(1, 'test', 'test', '2024-09-06 15:00:59.000000', 2, 1, 2),
(2, 'test11', 'test11', '2024-09-06 15:06:44.000000', 2, 2, 1),
(4, 'test2', 'test2', '2024-09-06 16:17:13.000000', 2, 1, 1),
(5, 'test333', 'test333', '2024-09-06 16:23:26.000000', 2, 2, 2),
(6, 'test11', 'test11', '2024-09-06 17:52:06.000000', 2, 1, 1),
(7, 'test1', 'test1', '2024-09-10 17:19:10.000000', 2, 1, 1);
-- --------------------------------------------------------
--
-- Table structure for table `appoinment_slots`
--
CREATE TABLE `appoinment_slots` (
`slot_id` bigint(20) NOT NULL,
`app_type` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`slot` time(6) DEFAULT NULL,
`slot_count` int(11) DEFAULT NULL,
`slot_end` time(6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `appoinment_slots`
--
INSERT INTO `appoinment_slots` (`slot_id`, `app_type`, `last_modified`, `modified_by`, `slot`, `slot_count`, `slot_end`) VALUES
(1, 'Periodic Health Checkup', '2024-09-09 14:49:19.000000', 2, '14:49:00.000000', 5, '14:49:00.000000'),
(2, 'Periodic Health Checkup', '2024-09-11 16:17:58.000000', 2, '18:17:00.000000', 4, '18:17:00.000000');
-- --------------------------------------------------------
--
-- Table structure for table `bio_medical_waste`
--
CREATE TABLE `bio_medical_waste` (
`waste_id` bigint(20) NOT NULL,
`approval_status` varchar(255) DEFAULT NULL,
`approved_by` int(11) DEFAULT NULL,
`blue_bags` int(11) DEFAULT NULL,
`challan_no` varchar(255) DEFAULT NULL,
`collected_by` varchar(255) DEFAULT NULL,
`forward_status` int(11) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`plant_blue_qty` float DEFAULT NULL,
`plant_red_qty` float DEFAULT NULL,
`plant_white_qty` float DEFAULT NULL,
`plant_yellow_qty` float DEFAULT NULL,
`red_bags` int(11) DEFAULT NULL,
`surveillance_by` varchar(255) DEFAULT NULL,
`vehicle_no` varchar(255) DEFAULT NULL,
`waste_gen_date` datetime(6) DEFAULT NULL,
`white_bags` int(11) DEFAULT NULL,
`yellow_bags` int(11) DEFAULT NULL,
`dis_agncy` bigint(20) DEFAULT NULL,
`ohc_type_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `bio_medical_waste`
--
INSERT INTO `bio_medical_waste` (`waste_id`, `approval_status`, `approved_by`, `blue_bags`, `challan_no`, `collected_by`, `forward_status`, `last_modified`, `modified_by`, `plant_blue_qty`, `plant_red_qty`, `plant_white_qty`, `plant_yellow_qty`, `red_bags`, `surveillance_by`, `vehicle_no`, `waste_gen_date`, `white_bags`, `yellow_bags`, `dis_agncy`, `ohc_type_id`) VALUES
(1, NULL, NULL, NULL, NULL, 'test', NULL, '2024-09-07 18:30:18.000000', 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1),
(3, NULL, NULL, NULL, NULL, 'test1', NULL, '2024-09-07 19:04:36.000000', 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 2),
(4, NULL, NULL, NULL, NULL, 'test2', NULL, '2024-09-07 19:06:03.000000', 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1),
(5, NULL, NULL, NULL, NULL, 'test', NULL, '2024-09-12 12:02:23.000000', 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1);
-- --------------------------------------------------------
--
-- Table structure for table `bio_medical_waste_new`
--
CREATE TABLE `bio_medical_waste_new` (
`waste_id` bigint(20) NOT NULL,
`collected_by` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`ohc_type_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `bio_medical_waste_new`
--
INSERT INTO `bio_medical_waste_new` (`waste_id`, `collected_by`, `last_modified`, `modified_by`, `ohc_type_id`) VALUES
(1, 'Meera Envirotech Private Limited', '2024-09-07 16:45:50.000000', 2, 1),
(2, 'sd', '2024-09-07 16:59:53.000000', 2, 1),
(3, 'test', '2024-09-07 17:00:03.000000', 2, 1);
-- --------------------------------------------------------
--
-- Table structure for table `body_measurement_master`
--
CREATE TABLE `body_measurement_master` (
`body_measurement_id` bigint(20) NOT NULL,
`bm_code` varchar(255) DEFAULT NULL,
`bm_name` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`remark` varchar(255) DEFAULT NULL,
`unit_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `body_measurement_master`
--
INSERT INTO `body_measurement_master` (`body_measurement_id`, `bm_code`, `bm_name`, `last_modified`, `modified_by`, `remark`, `unit_id`) VALUES
(1, 'h_code', 'height ', '2024-08-08 21:19:46.000000', 1, 'patient height', 6),
(2, 'weight', 'weight', '2024-08-08 15:52:12.000000', 1, 'weight', 1),
(3, 'bp', 'BP', '2024-08-08 15:55:05.000000', 1, 'blood pressure', 7),
(4, 'pulse', 'Heart Rate', '2024-08-08 15:56:34.000000', 1, 'pulses', 8),
(5, 'fbs', 'FBS', '2024-08-08 15:57:40.000000', 1, '', 9),
(6, 'test_code', 'test', '2024-08-28 17:14:42.000000', 1, 'test', 1);
-- --------------------------------------------------------
--
-- Table structure for table `business_reports_filter_master`
--
CREATE TABLE `business_reports_filter_master` (
`business_reports_filter_master_id` bigint(20) NOT NULL,
`is_patient_specific` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`filter_id` bigint(20) DEFAULT NULL,
`report_id` bigint(20) DEFAULT NULL,
`filter_ids` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `business_reports_filter_master`
--
INSERT INTO `business_reports_filter_master` (`business_reports_filter_master_id`, `is_patient_specific`, `last_modified`, `modified_by`, `filter_id`, `report_id`, `filter_ids`) VALUES
(1, 'Yes', '2024-09-07 10:24:22.000000', 2, NULL, 1, '1,3'),
(2, 'Yes', '2024-09-07 10:37:40.000000', 2, NULL, 1, '1'),
(4, 'No', '2024-09-07 10:56:40.000000', 2, NULL, 2, '1,3'),
(5, 'Yes', '2024-09-09 11:11:43.000000', 2, NULL, 1, '1'),
(6, 'Yes', '2024-09-10 19:35:13.000000', 2, NULL, 1, '1,3');
-- --------------------------------------------------------
--
-- Table structure for table `bussiness_unit`
--
CREATE TABLE `bussiness_unit` (
`bu_id` bigint(20) NOT NULL,
`bu_email` varchar(255) DEFAULT NULL,
`bu_headname` varchar(255) DEFAULT NULL,
`bu_name` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `calibration_item_tbl`
--
CREATE TABLE `calibration_item_tbl` (
`calibration_id` bigint(20) NOT NULL,
`cali_on` date DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`next_cali` date DEFAULT NULL,
`qty` int(11) DEFAULT NULL,
`cat_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `calibration_item_tbl`
--
INSERT INTO `calibration_item_tbl` (`calibration_id`, `cali_on`, `last_modified`, `modified_by`, `next_cali`, `qty`, `cat_id`) VALUES
(1, NULL, '2024-09-07 15:45:00.000000', 2, NULL, 100, 1),
(2, '2024-09-06', '2024-09-07 15:45:52.000000', 2, '2024-09-07', 100, 1),
(4, '2024-09-05', '2024-09-07 15:49:29.000000', 2, '2024-09-26', 50000, 2);
-- --------------------------------------------------------
--
-- Table structure for table `canteen_master`
--
CREATE TABLE `canteen_master` (
`canteen_id` bigint(20) NOT NULL,
`canteen_code` varchar(255) DEFAULT NULL,
`canteen_location` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`type` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `canteen_master`
--
INSERT INTO `canteen_master` (`canteen_id`, `canteen_code`, `canteen_location`, `last_modified`, `modified_by`, `type`) VALUES
(1, 'TEST1234', 'testt', '2024-09-11 20:02:55.000000', 2, 'Kitchen'),
(2, 'test234', 'test1', '2024-09-11 20:01:29.000000', 2, 'Kitchen');
-- --------------------------------------------------------
--
-- Table structure for table `checkup_form`
--
CREATE TABLE `checkup_form` (
`checkup_id` bigint(20) NOT NULL,
`bmi` varchar(255) DEFAULT NULL,
`checkup_date` datetime(6) DEFAULT NULL,
`health_index` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`emp_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `checkup_form_key_value`
--
CREATE TABLE `checkup_form_key_value` (
`checkup_form_key_value_id` bigint(20) NOT NULL,
`checkup_form_key` varchar(255) DEFAULT NULL,
`checkup_form_value` varchar(255) DEFAULT NULL,
`checkup_value1` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`checkup_form_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `checkup_form_section`
--
CREATE TABLE `checkup_form_section` (
`section_id` bigint(20) NOT NULL,
`comments` varchar(255) DEFAULT NULL,
`display_order` int(11) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`notes` varchar(255) DEFAULT NULL,
`rule_ids` varchar(255) DEFAULT NULL,
`section_desc` varchar(255) DEFAULT NULL,
`section_name` varchar(255) DEFAULT NULL,
`status` varchar(255) DEFAULT NULL,
`interpretation` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `checkup_form_section`
--
INSERT INTO `checkup_form_section` (`section_id`, `comments`, `display_order`, `last_modified`, `modified_by`, `notes`, `rule_ids`, `section_desc`, `section_name`, `status`, `interpretation`) VALUES
(5, '', 1, '2024-09-05 12:27:53.884695', 5, '', '1', '', 'new', 'Active', 3),
(6, '', 1, '2024-09-05 12:27:53.884695', 5, '', '1,2', '', 'test', 'Active', 3);
-- --------------------------------------------------------
--
-- Table structure for table `checkup_parameter`
--
CREATE TABLE `checkup_parameter` (
`checkup_parameter_id` bigint(20) NOT NULL,
`column_name` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`parameter_name` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `checkup_parameter_unit_master`
--
CREATE TABLE `checkup_parameter_unit_master` (
`unit_id` bigint(20) NOT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`unit_code` varchar(255) DEFAULT NULL,
`unit_desc` varchar(255) DEFAULT NULL,
`unit_name` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `checkup_parameter_unit_master`
--
INSERT INTO `checkup_parameter_unit_master` (`unit_id`, `last_modified`, `modified_by`, `unit_code`, `unit_desc`, `unit_name`) VALUES
(2, '2024-09-13 18:03:22.000000', 2, NULL, NULL, 'kg'),
(3, '2024-09-13 17:57:48.000000', 2, NULL, NULL, 'g'),
(4, '2024-09-13 17:57:48.000000', 2, NULL, NULL, 'cals');
-- --------------------------------------------------------
--
-- Table structure for table `checkup_parameter_value`
--
CREATE TABLE `checkup_parameter_value` (
`parameter_value_id` bigint(20) NOT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`parameter_value_name` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `checkup_type`
--
CREATE TABLE `checkup_type` (
`checkup_type_id` bigint(20) NOT NULL,
`checkup_form_section_ids` varchar(255) DEFAULT NULL,
`checkup_type_code` varchar(255) DEFAULT NULL,
`checkup_type_name` varchar(255) DEFAULT NULL,
`cost` int(11) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`ohc_ids` varchar(255) DEFAULT NULL,
`sec_choice` varchar(255) DEFAULT NULL,
`type_status` enum('ACTIVE','INACTIVE') DEFAULT NULL,
`type_state` varchar(255) DEFAULT NULL,
`valid_upto` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `citys`
--
CREATE TABLE `citys` (
`city_id` bigint(20) NOT NULL,
`ac_amb_charge` int(11) DEFAULT NULL,
`ac_cost` int(11) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`non_ac_amb_charge` int(11) DEFAULT NULL,
`non_ac_cost` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `company_profile`
--
CREATE TABLE `company_profile` (
`company_id` bigint(20) NOT NULL,
`address` varchar(255) DEFAULT NULL,
`company_code` varchar(255) DEFAULT NULL,
`company_logo` tinyblob DEFAULT NULL,
`company_name` varchar(255) DEFAULT NULL,
`company_website` varchar(255) DEFAULT NULL,
`fax` varchar(255) DEFAULT NULL,
`image_type` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`ohc_details` varchar(255) DEFAULT NULL,
`primary_email` varchar(255) DEFAULT NULL,
`primary_phone` varchar(255) DEFAULT NULL,
`right_com_logo` tinyblob DEFAULT NULL,
`right_image_type` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `complaints`
--
CREATE TABLE `complaints` (
`complaint_id` bigint(20) NOT NULL,
`complaint` varchar(255) DEFAULT NULL,
`complaint_desc` varchar(255) DEFAULT NULL,
`is_active` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `complaints`
--
INSERT INTO `complaints` (`complaint_id`, `complaint`, `complaint_desc`, `is_active`, `last_modified`, `modified_by`) VALUES
(1, 'test', 'test', 'Yes', '2024-09-09 19:34:07.000000', 2),
(2, 'BOTH EYE IRRETATION', 'BOTH EYE IRRETATION', 'Yes', '2024-09-10 15:35:03.000000', 2),
(3, 'RT EYE IRRETATION', 'RT EYE IRRETATION', 'No', '2024-09-10 15:35:18.000000', 2),
(4, 'MIGRAIN', 'MIGRAIN', 'No', '2024-09-10 15:35:29.000000', 2),
(5, 'test', 'MIGRAIN', 'Yes', '2024-09-13 11:09:44.000000', 2),
(6, 'test', 'MIGRAIN', 'No', '2024-09-13 11:09:56.000000', 2);
-- --------------------------------------------------------
--
-- Table structure for table `config`
--
CREATE TABLE `config` (
`id` bigint(20) NOT NULL,
`key_name` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`value` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `config`
--
INSERT INTO `config` (`id`, `key_name`, `last_modified`, `modified_by`, `value`) VALUES
(1, 'Weeklyy', '2024-09-09 13:59:46.000000', 2, '14'),
(3, 'month', '2024-09-09 14:00:09.000000', 2, '31'),
(4, 'testttttt', '2024-09-09 14:03:28.000000', 2, 'testttt'),
(12, 'test', '2024-09-09 14:31:25.000000', 2, 'sumit@1223'),
(13, 'test', '2024-09-09 14:31:25.000000', 2, 'sumit@1223'),
(15, 'test', '2024-09-09 14:43:02.000000', 2, 'sumit@1223');
-- --------------------------------------------------------
--
-- Table structure for table `covid_wah_questions`
--
CREATE TABLE `covid_wah_questions` (
`question_id` bigint(20) NOT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`question` varchar(255) DEFAULT NULL,
`question_hindi` varchar(255) DEFAULT NULL,
`sequence` int(11) DEFAULT NULL,
`type` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `department`
--
CREATE TABLE `department` (
`dept_id` bigint(20) NOT NULL,
`dept_email` varchar(255) DEFAULT NULL,
`dept_headname` varchar(255) DEFAULT NULL,
`dept_name` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`bu_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `designation`
--
CREATE TABLE `designation` (
`designation_id` bigint(20) NOT NULL,
`designation_code` varchar(255) DEFAULT NULL,
`designation_collar` varchar(255) DEFAULT NULL,
`designation_desc` varchar(255) DEFAULT NULL,
`designation_name` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `designation`
--
INSERT INTO `designation` (`designation_id`, `designation_code`, `designation_collar`, `designation_desc`, `designation_name`, `last_modified`, `modified_by`) VALUES
(1, 'SE001', 'White', 'Responsible for software development', 'Software Engineer', '2024-09-02 09:54:15.000000', NULL),
(2, 'test', 'test', 'test', 'test', '2024-08-31 14:32:55.000000', NULL),
(4, 'digital ', 'msnsger col', 'test', 'msnsger', '2024-08-31 14:58:58.000000', NULL),
(5, 'test2', 'test2', 'test2', 'test2', '2024-08-31 16:13:49.000000', NULL),
(6, 'test3', 'test3', 'test3', 'testttt3', '2024-08-31 16:28:50.000000', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `device_mapping_master`
--
CREATE TABLE `device_mapping_master` (
`id` bigint(20) NOT NULL,
`checkup_section` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`device_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `device_mapping_master`
--
INSERT INTO `device_mapping_master` (`id`, `checkup_section`, `last_modified`, `modified_by`, `device_id`) VALUES
(1, '5', '2024-09-12 17:09:16.000000', 2, 1),
(2, '6,5', '2024-09-12 17:09:29.000000', 2, 2);
-- --------------------------------------------------------
--
-- Table structure for table `device_master`
--
CREATE TABLE `device_master` (
`id` bigint(20) NOT NULL,
`device_name` varchar(255) DEFAULT NULL,
`is_active` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `device_master`
--
INSERT INTO `device_master` (`id`, `device_name`, `is_active`, `last_modified`, `modified_by`) VALUES
(1, 'test', 'Yes', '2024-09-09 10:40:31.000000', 2),
(2, 'BIOS', 'Yes', '2024-09-11 12:57:17.000000', 2),
(3, 'DIRUI', 'No', '2024-09-11 12:57:26.000000', 2),
(4, 'TOSHO', 'Yes', '2024-09-11 12:57:34.000000', 2);
-- --------------------------------------------------------
--
-- Table structure for table `device_parameter`
--
CREATE TABLE `device_parameter` (
`id` bigint(20) NOT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`para_code` varchar(20) DEFAULT NULL,
`para_name` varchar(255) DEFAULT NULL,
`device_name` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `device_parameter_map`
--
CREATE TABLE `device_parameter_map` (
`device_parameter_id` bigint(20) NOT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`parameter_code` varchar(20) DEFAULT NULL,
`parameter_name` varchar(255) DEFAULT NULL,
`device_name` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `diagnosis_chronic_mapping`
--
CREATE TABLE `diagnosis_chronic_mapping` (
`diagnosis_chronic_mapping_id` bigint(20) NOT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`chronic_id` bigint(20) DEFAULT NULL,
`ailment_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `diagnosis_chronic_mapping`
--
INSERT INTO `diagnosis_chronic_mapping` (`diagnosis_chronic_mapping_id`, `last_modified`, `modified_by`, `chronic_id`, `ailment_id`) VALUES
(1, '2024-09-12 21:52:24.000000', 2, 1, 2),
(2, '2024-09-09 19:31:05.000000', 2, 1, 1),
(5, '2024-09-12 21:51:48.000000', 2, 1, 1);
-- --------------------------------------------------------
--
-- Table structure for table `dignosys_wise_bodysystem`
--
CREATE TABLE `dignosys_wise_bodysystem` (
`id` bigint(20) NOT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`ailment_id` bigint(20) DEFAULT NULL,
`ailment_sys_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `dignosys_wise_bodysystem`
--
INSERT INTO `dignosys_wise_bodysystem` (`id`, `last_modified`, `modified_by`, `ailment_id`, `ailment_sys_id`) VALUES
(3, '2024-09-12 20:56:37.000000', 2, 1, 1),
(4, '2024-09-12 20:44:03.000000', 2, 2, 1),
(5, '2024-09-12 20:56:31.000000', 2, 3, 1);
-- --------------------------------------------------------
--
-- Table structure for table `disposal_agency`
--
CREATE TABLE `disposal_agency` (
`agency_id` bigint(20) NOT NULL,
`agency_address` varchar(255) DEFAULT NULL,
`agency_name` varchar(255) DEFAULT NULL,
`allocated_reg_no` varchar(255) DEFAULT NULL,
`hod_email` varchar(255) DEFAULT NULL,
`hod_name` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`regestration_no` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `disposal_agency`
--
INSERT INTO `disposal_agency` (`agency_id`, `agency_address`, `agency_name`, `allocated_reg_no`, `hod_email`, `hod_name`, `last_modified`, `modified_by`, `regestration_no`) VALUES
(1, '1/4, 3rd Floor, BVR Lake Front, Outer Ring Rd, Nagavara, Bengaluru, Karnataka 560045 Contract No. 09', 'Meera Envirotech Private Limited', NULL, 'test', 'test', '2024-09-07 18:20:16.000000', 2, 'U74900KA2008PTC046820');
-- --------------------------------------------------------
--
-- Table structure for table `doctors_master`
--
CREATE TABLE `doctors_master` (
`doctor_id` bigint(20) NOT NULL,
`doctor_desc` varchar(255) DEFAULT NULL,
`doctor_emp_id` varchar(255) DEFAULT NULL,
`doctor_name` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `doctors_master`
--
INSERT INTO `doctors_master` (`doctor_id`, `doctor_desc`, `doctor_emp_id`, `doctor_name`, `last_modified`, `modified_by`) VALUES
(1, 'test', 'Active', 'test', '2024-09-07 11:15:46.000000', 2),
(2, 'dr avinash', 'AV229292', 'dr. avinash', '2024-09-07 16:11:52.000000', 2);
-- --------------------------------------------------------
--
-- Table structure for table `dosage_category`
--
CREATE TABLE `dosage_category` (
`dosage_category_id` bigint(20) NOT NULL,
`dosage_category` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`remarks` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `dosage_category`
--
INSERT INTO `dosage_category` (`dosage_category_id`, `dosage_category`, `last_modified`, `modified_by`, `remarks`) VALUES
(1, 'test', '2024-09-03 18:02:29.000000', 2, 'check'),
(2, 'test11', '2024-09-03 18:06:37.000000', 2, 'test11');
-- --------------------------------------------------------
--
-- Table structure for table `duty_master`
--
CREATE TABLE `duty_master` (
`duty_id` bigint(20) NOT NULL,
`duty_type` varchar(255) DEFAULT NULL,
`duty_type_code` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `employee_appointment`
--
CREATE TABLE `employee_appointment` (
`appointment_id` bigint(20) NOT NULL,
`appointment_date` datetime(6) DEFAULT NULL,
`blood_sugar_fbs` varchar(255) DEFAULT NULL,
`blood_sugar_ppbs` varchar(255) DEFAULT NULL,
`blood_sugar_rbs` varchar(255) DEFAULT NULL,
`bmi` int(11) DEFAULT NULL,
`bp_dbp` varchar(255) DEFAULT NULL,
`bp_sbp` varchar(255) DEFAULT NULL,
`heart_rate` int(11) DEFAULT NULL,
`height` int(11) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`weight` float DEFAULT NULL,
`emp_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `employer_contractor`
--
CREATE TABLE `employer_contractor` (
`employer_contractor_id` bigint(20) NOT NULL,
`employer_contractor_address` varchar(255) DEFAULT NULL,
`employer_contractor_code` varchar(255) DEFAULT NULL,
`employer_contractor_contact` varchar(255) DEFAULT NULL,
`employer_contractor_desc` varchar(255) DEFAULT NULL,
`employer_contractor_email` varchar(255) DEFAULT NULL,
`employer_contractor_name` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `emp_cadre`
--
CREATE TABLE `emp_cadre` (
`emp_cadre_id` bigint(20) NOT NULL,
`emp_cadre` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`medical_claim_limit` int(11) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`remarks` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `exercise`
--
CREATE TABLE `exercise` (
`exe_id` bigint(20) NOT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`minutes` bigint(20) DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
`exercise_id` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `exercise_master`
--
CREATE TABLE `exercise_master` (
`exercise_id` bigint(20) NOT NULL,
`exercise_name` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`remark` varchar(255) DEFAULT NULL,
`unit_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `exercise_master`
--
INSERT INTO `exercise_master` (`exercise_id`, `exercise_name`, `last_modified`, `modified_by`, `remark`, `unit_id`) VALUES
(1, 'Badminton', '2024-08-08 14:52:48.000000', 1, 'badminton ', 3),
(2, 'swimming', '2024-08-08 14:53:06.000000', 1, 'swimming', 3),
(3, 'Cricket', '2024-08-08 14:53:58.000000', 1, 'cricket', 3),
(4, 'Cycling', '2024-08-17 15:04:51.000000', 1, 'cycling', 3),
(5, 'Jump Rope', '2024-08-17 15:05:17.000000', 1, 'jump rope', 3),
(6, 'Yoga', '2024-08-17 15:08:08.000000', 1, 'yoga', 3),
(7, 'Jogging', '2024-08-17 15:09:39.000000', 1, 'jogging', 3),
(8, 'Brisk Walking', '2024-08-17 15:09:53.000000', 1, 'walking', 3),
(9, 'Push-Ups', '2024-08-17 15:10:36.000000', 1, '3 sets of 15 reps', 3),
(10, 'Squats', '2024-08-17 15:10:52.000000', 1, '3 sets of 20 reps (10 minutes total)', 3),
(11, 'Plank Holds', '2024-08-17 15:11:18.000000', 1, '3 sets of 1 minute (5 minutes total)', 3),
(12, 'Dumbbell Rows', '2024-08-17 15:11:52.000000', 1, '3 sets of 12 reps per arm (10 minutes total)', 3),
(13, 'Stretching Routine', '2024-08-17 15:12:25.000000', 1, 'stretching', 3);
-- --------------------------------------------------------
--
-- Table structure for table `first_aid_box`
--
CREATE TABLE `first_aid_box` (
`id` bigint(20) NOT NULL,
`box_code` varchar(255) DEFAULT NULL,
`box_loc` varchar(255) DEFAULT NULL,
`box_name` varchar(255) DEFAULT NULL,
`first_aider` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `first_aid_box`
--
INSERT INTO `first_aid_box` (`id`, `box_code`, `box_loc`, `box_name`, `first_aider`, `last_modified`, `modified_by`) VALUES
(6, 'test', 'test', 'test', '1,2', '2024-09-05 17:20:36.000000', 2),
(7, 'test', 'test', 'test', '1,3', '2024-09-05 17:20:57.000000', 2),
(9, 'test1', 'test1', 'test1', '1,3,2', '2024-09-05 19:16:02.000000', 2);
-- --------------------------------------------------------
--
-- Table structure for table `food_master`
--
CREATE TABLE `food_master` (
`food_id` bigint(20) NOT NULL,
`base_quantity` bigint(20) DEFAULT NULL,
`food_code` varchar(255) DEFAULT NULL,
`food_name` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`remark` varchar(255) DEFAULT NULL,
`unit_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `food_master`
--
INSERT INTO `food_master` (`food_id`, `base_quantity`, `food_code`, `food_name`, `last_modified`, `modified_by`, `remark`, `unit_id`) VALUES
(1, 100, 'paneer_code', 'Paneer', '2024-08-08 14:59:29.000000', 1, '100g paneer', 2),
(2, 100, 'dalt', 'Dal Tadka', '2024-08-08 15:00:29.000000', 1, '100g dal', 2),
(3, 100, 'rice', 'Rice', '2024-08-08 15:01:36.000000', 1, '100g rice', 2);
-- --------------------------------------------------------
--
-- Table structure for table `food_nutrient_mapping_values`
--
CREATE TABLE `food_nutrient_mapping_values` (
`food_nutrient_id` bigint(20) NOT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`nutrient_value` double DEFAULT NULL,
`food_id` bigint(20) DEFAULT NULL,
`nutrient_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `food_nutrient_mapping_values`
--
INSERT INTO `food_nutrient_mapping_values` (`food_nutrient_id`, `last_modified`, `modified_by`, `nutrient_value`, `food_id`, `nutrient_id`) VALUES
(1, '2024-08-09 11:53:38.000000', 1, 18, 1, 1),
(2, '2024-08-09 11:53:38.000000', 1, 250, 1, 2),
(3, '2024-08-09 11:53:38.000000', 1, 12, 1, 3),
(4, '2024-08-09 11:53:38.000000', 1, 0, 1, 4),
(5, '2024-08-09 11:53:38.000000', 1, 0, 1, 5),
(6, '2024-08-09 20:45:25.000000', 1, 9, 2, 1),
(7, '2024-08-09 20:45:25.000000', 1, 116, 2, 2),
(8, '2024-08-09 20:45:25.000000', 1, 0.1, 2, 3),
(9, '2024-08-09 20:45:25.000000', 1, 8, 2, 4),
(10, '2024-08-09 20:45:25.000000', 1, 0, 2, 5);
-- --------------------------------------------------------
--
-- Table structure for table `grade_master`
--
CREATE TABLE `grade_master` (
`id` bigint(20) NOT NULL,
`grade_name` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `group_items`
--
CREATE TABLE `group_items` (
`group_item_id` bigint(20) NOT NULL,
`cost` int(11) DEFAULT NULL,
`item_type` int(11) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`qty` decimal(38,2) DEFAULT NULL,
`group_id` bigint(20) DEFAULT NULL,
`item_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `group_items`
--
INSERT INTO `group_items` (`group_item_id`, `cost`, `item_type`, `last_modified`, `modified_by`, `qty`, `group_id`, `item_id`) VALUES
(8, 2000, 1, '2024-09-17 19:08:21.000000', 2, '0.10', 9, 8),
(9, 2000, 1, '2024-09-17 19:08:21.000000', 2, '0.20', 9, 10),
(10, 2000, 1, '2024-09-17 19:08:21.000000', 2, '0.30', 9, 11);
-- --------------------------------------------------------
--
-- Table structure for table `habits`
--
CREATE TABLE `habits` (
`id` bigint(20) NOT NULL,
`habit` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `health_advice`
--
CREATE TABLE `health_advice` (
`health_advice_id` bigint(20) NOT NULL,
`health_advice_cat` varchar(255) DEFAULT NULL,
`health_advice_name` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `health_risk`
--
CREATE TABLE `health_risk` (
`health_risk_id` bigint(20) NOT NULL,
`health_risk_cat` int(11) DEFAULT NULL,
`health_risk_name` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `injury_class`
--
CREATE TABLE `injury_class` (
`inj_class_id` bigint(20) NOT NULL,
`inj_class_code` varchar(255) DEFAULT NULL,
`inj_class_desc` varchar(255) DEFAULT NULL,
`inj_class_name` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `injury_class`
--
INSERT INTO `injury_class` (`inj_class_id`, `inj_class_code`, `inj_class_desc`, `inj_class_name`, `last_modified`, `modified_by`) VALUES
(1, 'test', 'test', 'test', '2024-09-09 10:34:38.000000', 2),
(2, 'test1', 'test1', 'test1', '2024-09-09 10:34:48.000000', 2);
-- --------------------------------------------------------
--
-- Table structure for table `injury_part`
--
CREATE TABLE `injury_part` (
`inj_id` bigint(20) NOT NULL,
`inj_code` varchar(255) DEFAULT NULL,
`inj_desc` varchar(255) DEFAULT NULL,
`inj_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`inj_name` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `injury_part`
--
INSERT INTO `injury_part` (`inj_id`, `inj_code`, `inj_desc`, `inj_modified`, `modified_by`, `inj_name`) VALUES
(1, 'test', 'test', '2024-09-09 10:56:29.000000', 2, 'test');
-- --------------------------------------------------------
--
-- Table structure for table `injury_type`
--
CREATE TABLE `injury_type` (
`injury_type_id` bigint(20) NOT NULL,
`injury_type_code` varchar(255) DEFAULT NULL,
`injury_type_desc` varchar(255) DEFAULT NULL,
`injury_type_name` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `injury_type`
--
INSERT INTO `injury_type` (`injury_type_id`, `injury_type_code`, `injury_type_desc`, `injury_type_name`, `last_modified`, `modified_by`) VALUES
(1, 'test', 'test', 'test', '2024-09-09 10:54:26.000000', 2);
-- --------------------------------------------------------
--
-- Table structure for table `interpretation_detail`
--
CREATE TABLE `interpretation_detail` (
`interpretation_detail_id` bigint(20) NOT NULL,
`interpretation_key` longtext DEFAULT NULL,
`interpretation_value` longtext DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`interpretation_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `interpretation_detail`
--
INSERT INTO `interpretation_detail` (`interpretation_detail_id`, `interpretation_key`, `interpretation_value`, `last_modified`, `modified_by`, `interpretation_id`) VALUES
(1, 'test', 'value', NULL, NULL, 3);
-- --------------------------------------------------------
--
-- Table structure for table `interpretation_master`
--
CREATE TABLE `interpretation_master` (
`id` bigint(20) NOT NULL,
`interpretation_header` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `interpretation_master`
--
INSERT INTO `interpretation_master` (`id`, `interpretation_header`, `last_modified`, `modified_by`) VALUES
(3, 'New Interpretation', '2024-09-05 07:54:52.200832', 5);
-- --------------------------------------------------------
--
-- Table structure for table `job_profile`
--
CREATE TABLE `job_profile` (
`job_profile_id` bigint(20) NOT NULL,
`job_profile_code` varchar(255) DEFAULT NULL,
`job_profile_name` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `job_profile`
--
INSERT INTO `job_profile` (`job_profile_id`, `job_profile_code`, `job_profile_name`, `last_modified`, `modified_by`) VALUES
(1, 'COOK_01', 'COOK', '2024-09-11 20:17:04.000000', 2),
(2, 'test_code_111', 'test11', '2024-09-11 20:20:31.000000', 2);
-- --------------------------------------------------------
--
-- Table structure for table `key_health_reportable_parameter_master`
--
CREATE TABLE `key_health_reportable_parameter_master` (
`key_param_id` bigint(20) NOT NULL,
`key_param_name` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `key_health_reportable_parameter_master`
--
INSERT INTO `key_health_reportable_parameter_master` (`key_param_id`, `key_param_name`, `last_modified`, `modified_by`) VALUES
(1, 'total cholesterol', NULL, NULL),
(2, 'triglyceride', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `medicine_form`
--
CREATE TABLE `medicine_form` (
`form_id` bigint(20) NOT NULL,
`form_code` varchar(255) DEFAULT NULL,
`form_name` varchar(255) DEFAULT NULL,
`is_qty_fixed` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `medicine_form`
--
INSERT INTO `medicine_form` (`form_id`, `form_code`, `form_name`, `is_qty_fixed`, `last_modified`, `modified_by`) VALUES
(1, 'tab0666', 'testtt', 'No', '2024-09-05 10:02:40.000000', 2);
-- --------------------------------------------------------
--
-- Table structure for table `medicine_frequency`
--
CREATE TABLE `medicine_frequency` (
`frequency_id` bigint(20) NOT NULL,
`active` varchar(255) DEFAULT NULL,
`display_order` varchar(255) DEFAULT NULL,
`frequency_description` varchar(255) DEFAULT NULL,
`is_default` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`medicine_frequency` varchar(255) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`qty` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `medicine_frequency`
--
INSERT INTO `medicine_frequency` (`frequency_id`, `active`, `display_order`, `frequency_description`, `is_default`, `last_modified`, `medicine_frequency`, `modified_by`, `qty`) VALUES
(1, 'Active', '1', '1-0-0-1', 'Yes', '2024-09-09 19:14:38.000000', '1-0-0-1', 2, 0),
(2, 'Not Active', 'test1', 'test1', 'Yes', '2024-09-09 19:16:20.000000', 'test1', 2, 5);
-- --------------------------------------------------------
--
-- Table structure for table `medicine_timings`
--
CREATE TABLE `medicine_timings` (
`timing_id` bigint(20) NOT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`medicine_timing` varchar(255) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`timing_description` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `medicine_timings`
--
INSERT INTO `medicine_timings` (`timing_id`, `last_modified`, `medicine_timing`, `modified_by`, `timing_description`) VALUES
(1, '2024-09-09 19:16:54.000000', 'BEFORE MEAL', 2, 'BEFORE MEAL'),
(2, '2024-09-09 19:17:16.000000', 'after lunch', 2, 'after lunch'),
(4, '2024-09-13 10:58:22.000000', 'test', 2, 'BEFORE MEAL'),
(5, '2024-09-13 11:10:19.000000', 'test', 2, 'BEFORE MEAL'),
(6, '2024-09-13 11:11:21.000000', 'after lunch', 2, 'BEFORE MEAL'),
(7, '2024-09-13 11:11:34.000000', 'BEFORE MEAL', 2, 'BEFORE MEAL'),
(8, '2024-09-13 11:11:57.000000', 'BEFORE MEAL', 2, 'BEFORE MEAL'),
(9, '2024-09-13 11:12:11.000000', 'after lunch', 2, 'BEFORE MEAL'),
(10, '2024-09-13 11:13:40.000000', 'BEFORE MEAL', 2, 'BEFORE MEAL');
-- --------------------------------------------------------
--
-- Table structure for table `medicine_usage_cat`
--
CREATE TABLE `medicine_usage_cat` (
`medicine_usage_cat_id` bigint(20) NOT NULL,
`cat_desc` varchar(255) DEFAULT NULL,
`code` bigint(20) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`medicine_usage_cat_name` varchar(255) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `medicine_usage_cat`
--
INSERT INTO `medicine_usage_cat` (`medicine_usage_cat_id`, `cat_desc`, `code`, `last_modified`, `medicine_usage_cat_name`, `modified_by`) VALUES
(1, 'DRUG THAT CAN CURE A COLD, THE ACHES, PAINS', 1, '2024-09-04 12:06:07.000000', 'ANALGESICS', 2),
(2, 'DRUGS THAT RELIEVE INDIGESTION AND HEARTBURN BY NE', 0, '2024-09-04 12:07:00.000000', 'ANTACIDS', 2),
(4, 'testt', 1, '2024-09-04 12:15:44.000000', 'testt', 2);
-- --------------------------------------------------------
--
-- Table structure for table `menu_master`
--
CREATE TABLE `menu_master` (
`id` bigint(20) NOT NULL,
`display_sequence` int(11) DEFAULT NULL,
`icon_text` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`menu_description` varchar(255) DEFAULT NULL,
`menu_name` varchar(255) DEFAULT NULL,
`menu_url` varchar(255) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`parent_menu_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `menu_master`
--
INSERT INTO `menu_master` (`id`, `display_sequence`, `icon_text`, `last_modified`, `menu_description`, `menu_name`, `menu_url`, `modified_by`, `parent_menu_id`) VALUES
(1, 0, 'DutyRooster', '2024-08-08 14:07:25.000000', 'master at doctor role', 'Master', '', NULL, NULL),
(2, 0, '', '2024-08-08 14:16:59.000000', 'food item master', 'Food Item', '/food-item', NULL, 1),
(3, 1, '', '2024-08-08 14:19:35.000000', 'exercise master for patient ', 'Exercise Master', '/exercise-master', NULL, 1),
(4, 2, '', '2024-08-08 14:20:20.000000', 'unit master', 'Unit Master', '/unit-master', NULL, 1),
(5, 3, '', '2024-08-08 14:21:45.000000', 'nutrient master ', 'Nutrient Master', '/nutrient-master', NULL, 1),
(6, 4, '', '2024-08-08 14:25:13.000000', 'food nutrition mapping master', 'Food Nutrition Master', '/food-nutrition', NULL, 1),
(7, 6, '', '2024-08-08 14:27:22.000000', 'health parameter', 'Body Measurement Parameter', '/health-parameter', NULL, 1),
(8, 0, 'PatientManagement', '2024-08-08 14:28:37.000000', 'patient management grid', 'Patient Management', '', NULL, NULL),
(9, 1, '', '2024-08-08 14:34:09.000000', 'user list', 'Patient', '/patients', NULL, 8),
(10, 1, 'DataSetup', '2024-09-02 15:19:10.000000', 'data setup for application admin', 'Data Setup', 'data-setup', NULL, NULL),
(11, 2, 'PatientManagement', '2024-09-02 16:26:52.000000', 'patient profile setup', 'Patient Profile Setup', '', NULL, NULL),
(12, 1, NULL, '2024-09-02 14:07:11.000000', 'designation master', 'Designation', '/patient-profile-setup/designation', NULL, 11),
(13, 1, NULL, '2024-09-02 16:36:27.000000', 'user management ', 'User Management', '', NULL, 10),
(14, NULL, NULL, '2024-09-02 15:49:24.000000', 'menus', 'Menu', 'data-setup/user-management/menus', NULL, 13),
(15, 2, NULL, '2024-09-02 15:50:37.000000', 'roles on user management', 'Roles', 'data-setup/user-management/roles', NULL, 13),
(16, 3, '', '2024-09-02 15:51:16.000000', 'users master on user management', 'Users', 'data-setup/user-management/users', NULL, 13),
(17, 1, '', '2024-09-02 14:04:34.000000', 'division in patient profile setup', 'Division', 'patient-profile-setup/division', NULL, 11),
(18, 2, '', '2024-09-02 14:04:58.000000', 'department master ', 'Department', '/patient-profile-setup/department', NULL, 11),
(19, 4, '', '2024-09-02 14:06:48.000000', 'section master', 'Section', '/patient-profile-setup/section', NULL, 11),
(20, 5, '', '2024-09-02 14:03:57.000000', 'employee master', 'Employee Cadre', '/patient-profile-setup/employee-cadre', NULL, 11),
(21, 6, '', '2024-09-02 14:04:17.000000', 'employer/contractor master', 'Employer/contractor', '/patient-profile-setup/employer-contractor', NULL, 11),
(22, 2, '', '2024-09-02 12:24:07.000000', 'mastere in data setup', 'Masters', '', NULL, 10),
(23, 4, '', '2024-09-02 12:28:21.000000', 'medical items ', 'Medical Items', '', NULL, 10),
(24, NULL, '', '2024-09-02 17:12:45.000000', 'frequency master', 'Frequency Master', 'data-setup/masters/task-frequency', NULL, 22),
(25, NULL, '', '2024-09-02 17:18:45.000000', 'appointment slots', 'Appointment Slots', 'data-setup/masters/appointment', NULL, 22),
(26, NULL, '', '2024-09-02 17:30:09.000000', 'device master', 'Device Master', 'data-setup/masters/device', NULL, 22),
(27, NULL, '', '2024-09-02 17:43:51.000000', 'device mapping master', 'Device Mapping Master', 'data-setup/masters/device-mapping', NULL, 22),
(28, NULL, '', '2024-09-02 17:46:40.000000', 'salt master', 'Salt Master', 'data-setup/masters/salt', NULL, 22),
(29, NULL, '', '2024-09-02 17:47:49.000000', 'habit master', 'Habit Master', 'data-setup/masters/habit', NULL, 22),
(30, NULL, '', '2024-09-02 17:56:02.000000', '', 'Bio Waste Collectors', 'data-setup/masters/bio-wast-collectors', NULL, 22),
(31, NULL, '', '2024-09-02 17:59:06.000000', '', 'Plant Master', 'data-setup/masters/plant', NULL, 22),
(32, NULL, '', '2024-09-02 18:01:25.000000', '', 'Vaccine Master', 'data-setup/masters/vaccine', NULL, 22),
(33, NULL, '', '2024-09-02 18:03:18.000000', '', 'Unit Master', 'data-setup/masters/unit', NULL, 22),
(34, NULL, '', '2024-09-02 18:19:30.000000', '', 'Config Master', 'data-setup/masters/config', NULL, 22),
(35, NULL, '', '2024-09-02 18:26:43.000000', '', 'Disposal Agency', 'data-setup/masters/disposal-agency', NULL, 22),
(36, NULL, '', '2024-09-02 18:32:37.000000', '', 'Report Master', 'data-setup/masters/report', NULL, 22),
(37, 3, 'OPDSetupMaster', '2024-09-03 09:31:00.000000', 'opd setup master', 'OPD Setup Master', '', NULL, NULL),
(38, 4, '', '2024-09-03 09:38:39.000000', 'medical checkup master', 'Medical Checkup Master', '', NULL, NULL),
(39, 5, 'ChronicIllness', '2024-09-03 10:14:34.000000', 'chromic illness', 'Chronic Illness', '', NULL, NULL),
(40, 6, 'Inventory', '2024-09-03 10:20:58.000000', 'inventory menu', 'Inventory', '', NULL, NULL),
(41, NULL, '', '2024-09-03 16:57:39.000000', '', 'Add Filter Master', 'data-setup/masters/add-filter', NULL, 22),
(42, NULL, '', '2024-09-03 17:52:37.000000', 'administration route', 'Administration Route', 'data-setup/masters/route-administration', NULL, 22),
(43, NULL, '', '2024-09-04 11:31:03.000000', 'Medicine Frequency master', 'Dosage', 'opd-setup-master/medicine-frequency', NULL, 37),
(44, NULL, '', '2024-09-04 17:48:47.000000', 'medicine timing list', 'Medicine Timing', 'opd-setup-master/medicine-timing', NULL, 37),
(45, NULL, '', '2024-09-04 18:04:44.000000', 'refferal point list', 'Refferal Point', 'opd-setup-master/refferal-point', NULL, 37),
(46, NULL, '', '2024-09-04 18:05:20.000000', 'ailment system', 'Ailment System', 'opd-setup-master/ailment-system', NULL, 37),
(47, NULL, '', '2024-09-04 18:05:46.000000', 'Diagnosis List', 'Diagnosis List', 'opd-setup-master/diagnosis', NULL, 37),
(48, NULL, '', '2024-09-04 18:06:20.000000', 'Reffered By', 'Reffered By', 'opd-setup-master/reffered-by', NULL, 37),
(49, NULL, '', '2024-09-04 18:06:39.000000', 'Abnormality List', 'Abnormality Master', 'opd-setup-master/abnormality', NULL, 37),
(50, NULL, '', '2024-09-07 14:36:10.000000', ' Add Doctor List', 'Referral Doctors List', 'opd-setup-master/referral-doctor', NULL, 37),
(51, NULL, '', '2024-09-09 19:01:16.000000', 'Complaints List', 'Complaint List', 'opd-setup-master/complaint', NULL, 37),
(52, NULL, '', '2024-09-10 15:50:25.000000', 'Diagnosis Body System Map', 'Map Diagnosis And Body System', 'opd-setup-master/diagnosis-body-system-mapping', NULL, 37),
(53, NULL, '', '2024-09-10 15:54:57.000000', 'Diagnosis Treatment List', 'Diagnosis Wise Treatment Master', 'opd-setup-master/diagnosis-treatment', NULL, 37),
(54, NULL, '', '2024-09-07 16:21:20.000000', 'Diagnosis Chronic Illness Mapping', 'Diagnosis Chronic Illness Mapping', 'opd-setup-master/diagnosis-chronic-illness', NULL, 37),
(55, NULL, '', '2024-09-05 11:53:42.000000', 'Medicine Category', 'Category Usage', 'data-setup/medical/medicine-category', NULL, 23),
(56, NULL, '', '2024-09-05 11:01:30.000000', 'manage category', 'Item Category', 'data-setup/medical/manage-category', NULL, 23),
(57, NULL, '', '2024-09-05 11:02:39.000000', 'Medical Form', 'Medical Form', 'data-setup/medical/medical-form', NULL, 23),
(58, NULL, '', '2024-09-05 11:34:48.000000', 'first aid box', 'First-aid Box', 'data-setup/masters/first-aid-box', NULL, 22),
(59, NULL, '', '2024-09-06 08:40:26.000000', 'ambulance categories', 'Ambulance Category', 'inventory/ambulance-categories', NULL, 40),
(60, NULL, '', '2024-09-06 08:49:36.000000', 'ambulance master', 'Ambulance Master', 'data-setup/masters/ambulance', NULL, 22),
(61, NULL, '', '2024-09-06 18:50:38.000000', 'business report', 'Business Report Filter Master', 'data-setup/masters/business-report-filter', NULL, 22),
(62, NULL, '', '2024-09-05 19:22:31.000000', 'Checkup Parameter Group', 'Checkup Parameter Group', 'medical-checkup-master/checkup-parameter-group', NULL, 38),
(63, NULL, '', '2024-09-05 19:31:58.000000', 'Checkup Section Master', 'Checkup Section Master', 'medical-checkup-master/checkup-section master', NULL, 38),
(64, NULL, '', '2024-09-05 19:41:08.000000', 'Checkup Parameter Value', 'Checkup Parameter Value', 'medical-checkup-master/checkup-parameter-value', NULL, 38),
(65, NULL, '', '2024-09-05 19:45:14.000000', 'Health Advice', 'Heath Advice', 'medical-checkup-master/health-advice', NULL, 38),
(66, NULL, '', '2024-09-05 19:48:37.000000', 'Health Risk', 'Health Risk', 'medical-checkup-master/health-risk', NULL, 38),
(67, NULL, '', '2024-09-05 19:52:57.000000', 'Covid WAH Master', 'Covid WAH Master', 'medical-checkup-master/covid-wah-master', NULL, 38),
(68, NULL, '', '2024-09-05 19:55:32.000000', 'Questionair Master', 'Questionair Master', 'medical-checkup-master/questionair-master', NULL, 38),
(69, NULL, '', '2024-09-05 19:58:56.000000', 'Job Profile', 'Job Profile', 'medical-checkup-master/job-profile', NULL, 38),
(70, NULL, '', '2024-09-05 20:02:32.000000', 'Food Canteen Location', 'Food Canteen Location', 'medical-checkup-master/food-canteen-location', NULL, 38),
(71, NULL, '', '2024-09-05 20:06:06.000000', 'Health Reportable Parameter', 'Health Reportable Parameter', 'medical-checkup-master/health-reportable-parameter', NULL, 38),
(72, NULL, '', '2024-09-05 20:09:06.000000', 'Parameter Unit Master', 'Parameter Unit Master', 'medical-checkup-master/parameter-unit-master', NULL, 38),
(73, NULL, '', '2024-09-05 20:11:26.000000', 'Device Link', 'Device Link', 'medical-checkup-master/device-link', NULL, 38),
(74, NULL, '', '2024-09-05 20:14:56.000000', 'Checkup Type Name', 'Checkup Type Name', 'medical-checkup-master/checkup-type-name', NULL, 38),
(75, NULL, '', '2024-09-05 20:18:55.000000', 'Rule Generation', 'Rule Generation', 'medical-checkup-master/rule-generation', NULL, 38),
(76, NULL, '', '2024-09-07 15:21:04.000000', 'calibration master', 'Calibration Master', 'data-setup/masters/calibration-equipment', NULL, 22),
(77, NULL, '', '2024-09-09 10:12:20.000000', 'injury ailment', 'Injury/Ailment', '', NULL, 37),
(78, NULL, '', '2024-09-09 10:33:15.000000', 'injury classification in injury/ailment parent', 'Injury Classification', 'opd-setup-master/injury-ailment/injury-classes', NULL, 77),
(79, NULL, '', '2024-09-09 10:50:19.000000', 'injury type master in injury/ailment', 'Injury Type', 'opd-setup-master/injury-ailment/injury-type', NULL, 77),
(80, NULL, '', '2024-09-09 10:51:14.000000', 'injury part master in injury ailment ', 'Injury Part', 'opd-setup-master/injury-ailment/injury-part', NULL, 77),
(81, NULL, '', '2024-09-16 10:28:31.000000', 'group items in medical item', 'Group Item', 'data-setup/medical/group-items', NULL, 23),
(82, NULL, '', '2024-09-16 17:57:46.000000', 'medical item master from medical item ', 'Medical Item', 'data-setup/medical/medical-item', NULL, 23);
-- --------------------------------------------------------
--
-- Table structure for table `nutrient_master`
--
CREATE TABLE `nutrient_master` (
`nutrient_id` bigint(20) NOT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`nutrient_code` varchar(255) DEFAULT NULL,
`nutrient_name` varchar(255) DEFAULT NULL,
`remark` varchar(255) DEFAULT NULL,
`unit_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `nutrient_master`
--
INSERT INTO `nutrient_master` (`nutrient_id`, `last_modified`, `modified_by`, `nutrient_code`, `nutrient_name`, `remark`, `unit_id`) VALUES
(1, '2024-08-08 15:02:37.000000', 1, 'protein', 'Protein', 'protein', 2),
(2, '2024-08-08 15:06:16.000000', 1, 'colories', 'Calories', '', 4),
(3, '2024-08-08 15:07:23.000000', 1, 'colories', 'Saturated fats', '', 2),
(4, '2024-08-08 15:07:57.000000', 1, 'fiber', 'Fibre', '', 2),
(5, '2024-08-08 15:08:16.000000', 1, 'sugar', 'Added sugar', '', 2);
-- --------------------------------------------------------
--
-- Table structure for table `ohc_type`
--
CREATE TABLE `ohc_type` (
`id` bigint(20) NOT NULL,
`address` varchar(255) DEFAULT NULL,
`fax` varchar(255) DEFAULT NULL,
`icon_color` varchar(255) DEFAULT NULL,
`icon_text` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`ohc_category` varchar(255) DEFAULT NULL,
`ohc_code` varchar(255) DEFAULT NULL,
`ohc_desc` varchar(255) DEFAULT NULL,
`ohc_logo` longblob DEFAULT NULL,
`ohc_logo_type` varchar(255) DEFAULT NULL,
`ohc_name` varchar(255) DEFAULT NULL,
`ohc_type` varchar(255) DEFAULT NULL,
`pin_code` int(11) DEFAULT NULL,
`primary_email` varchar(255) DEFAULT NULL,
`primary_phone` bigint(20) DEFAULT NULL,
`state` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `ohc_type`
--
INSERT INTO `ohc_type` (`id`, `address`, `fax`, `icon_color`, `icon_text`, `last_modified`, `modified_by`, `ohc_category`, `ohc_code`, `ohc_desc`, `ohc_logo`, `ohc_logo_type`, `ohc_name`, `ohc_type`, `pin_code`, `primary_email`, `primary_phone`, `state`) VALUES
(1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'OHC1', NULL, NULL, NULL, NULL, NULL),
(2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'OHC2', NULL, NULL, NULL, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `patient_body_measurement_plan`
--
CREATE TABLE `patient_body_measurement_plan` (
`patient_measurement_id` bigint(20) NOT NULL,
`remark` varchar(255) DEFAULT NULL,
`measurement_value` double DEFAULT NULL,
`body_measurement_id` bigint(20) DEFAULT NULL,
`consultation_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `patient_body_measurement_plan`
--
INSERT INTO `patient_body_measurement_plan` (`patient_measurement_id`, `remark`, `measurement_value`, `body_measurement_id`, `consultation_id`) VALUES
(1, 'patient height', 171, 1, 1),
(2, 'patient height', 171, 1, 2),
(3, 'weight', 80, 2, 2),
(4, 'bpm', 70, 4, 2),
(5, 'fbs', 140, 5, 2),
(6, 'height', 181, 1, 3),
(7, 'weight', 100, 2, 3),
(8, 'bpm', 70, 4, 3),
(9, 'fbs', 140, 5, 3),
(16, 'weight', 65, 2, 7),
(19, 'height', 182, 1, 12),
(20, 'weight', 80, 2, 12),
(21, 'bp', 80, 3, 12),
(22, 'bpm', 70, 4, 12),
(23, 'fbs', 140, 5, 12),
(24, 'weight', 60, 2, 13),
(25, 'weight', 87.5, 2, 14),
(26, 'bp', 80, 3, 14),
(27, 'bpm', 70, 4, 14),
(28, 'fbs', 140, 5, 14),
(29, 'weight', 80, 2, 15),
(30, 'bp', 80, 3, 15),
(31, 'bpm', 80, 4, 15),
(32, 'height', 181, 1, 16),
(33, 'weight', 80, 2, 16),
(34, '85 pulse', 85, 4, 16),
(35, 'fbs', 140, 5, 16);
-- --------------------------------------------------------
--
-- Table structure for table `patient_consultation`
--
CREATE TABLE `patient_consultation` (
`consultation_id` bigint(20) NOT NULL,
`complaint` varchar(255) DEFAULT NULL,
`consultation_date` date NOT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`consultation_remark` varchar(255) DEFAULT NULL,
`emp_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `patient_consultation`
--
INSERT INTO `patient_consultation` (`consultation_id`, `complaint`, `consultation_date`, `last_modified`, `modified_by`, `consultation_remark`, `emp_id`) VALUES
(1, 'over weight ', '2024-08-08', '2024-08-08 16:36:36.000000', 1, 'target 80kg', 1),
(2, 'fitness', '2024-08-08', '2024-08-08 21:45:28.000000', 1, 'target 75kg', 1),
(3, 'over weight ', '2024-08-14', '2024-08-14 14:33:12.000000', 1, '100kg, over weight', 2),
(7, 'test4', '2024-08-14', '2024-08-14 15:31:59.000000', 1, 'test4', 2),
(12, 'fitness', '2024-08-17', '2024-08-17 16:00:20.000000', 1, '100 kg', 3),
(13, 'test', '2024-08-17', '2024-08-17 14:40:25.000000', 1, 'test', 3),
(14, 'fitness', '2024-08-20', '2024-08-20 10:18:10.000000', 1, 'target 80kg', 2),
(15, 'over weight ', '2024-08-21', '2024-08-28 16:06:28.000000', 1, '80kg target', 1),
(16, 'over weight ', '2024-08-28', '2024-08-28 17:18:19.000000', 1, 'target 80kg', 1);
-- --------------------------------------------------------
--
-- Table structure for table `patient_daily_body_measurement`
--
CREATE TABLE `patient_daily_body_measurement` (
`patient_daily_body_measurement_id` bigint(20) NOT NULL,
`daily_measurement_date` date DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`remark` varchar(255) DEFAULT NULL,
`measurement_value` double DEFAULT NULL,
`body_measurement_id` bigint(20) DEFAULT NULL,
`emp_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `patient_daily_body_measurement`
--
INSERT INTO `patient_daily_body_measurement` (`patient_daily_body_measurement_id`, `daily_measurement_date`, `last_modified`, `modified_by`, `remark`, `measurement_value`, `body_measurement_id`, `emp_id`) VALUES
(2, '2024-08-10', '2024-08-24 09:31:34.000000', 1, 'weight', 88, 2, 1),
(3, '2024-08-10', '2024-08-24 09:31:34.000000', 1, 'bp', 120, 3, 1),
(4, '2024-08-10', '2024-08-24 09:31:34.000000', 1, 'bpm', 80, 4, 1),
(5, '2024-08-10', '2024-08-24 09:31:34.000000', 1, 'fbs', 140, 5, 1),
(6, '2024-08-17', '2024-08-24 09:31:19.000000', 1, 'weight', 87, 2, 1),
(7, '2024-08-17', '2024-08-24 09:31:19.000000', 1, 'bp', 80, 3, 1),
(8, '2024-08-17', '2024-08-24 09:31:19.000000', 1, 'bpm', 76, 4, 1),
(10, '2024-08-21', '2024-08-22 18:27:02.000000', 1, 'weight', 86.5, 2, 1),
(11, '2024-08-21', '2024-08-21 11:51:25.000000', 1, 'bp', 80, 3, 1),
(12, '2024-08-21', '2024-08-21 11:51:25.000000', 1, 'bpm', 80, 4, 1),
(13, '2024-08-21', '2024-08-21 11:51:25.000000', 1, 'fbs', 140, 5, 1),
(17, '2024-08-22', '2024-08-22 18:31:42.000000', 1, 'weight', 85.3, 2, 1),
(18, '2024-08-22', '2024-08-22 17:25:35.000000', 1, 'bpm', 80, 4, 1),
(19, '2024-08-22', '2024-08-22 17:25:35.000000', 1, 'fbs', 140, 5, 1),
(22, '2024-08-23', '2024-08-26 23:55:54.000000', 1, 'weight', 85, 2, 1),
(23, '2024-08-23', '2024-08-23 10:21:16.000000', 1, 'bpm', 85, 4, 1),
(24, '2024-08-23', '2024-08-23 10:21:16.000000', 1, 'fbs', 130, 5, 1),
(25, '2024-08-24', '2024-08-24 09:32:36.000000', 1, 'weight', 84.7, 2, 1),
(26, '2024-08-24', '2024-08-24 09:32:36.000000', 1, 'bpm', 80, 4, 1),
(27, '2024-08-24', '2024-08-24 09:32:36.000000', 1, 'fbs', 132, 5, 1),
(28, '2024-08-26', '2024-08-26 23:56:30.000000', 1, 'weight', 84.4, 2, 1),
(29, '2024-08-26', '2024-08-26 22:45:23.000000', 1, '85 pulse', 85, 4, 1),
(30, '2024-08-28', '2024-08-28 15:55:29.000000', 1, 'weight', 84.3, 2, 1),
(31, '2024-08-28', '2024-08-28 15:55:29.000000', 1, 'bpm', 90, 4, 1),
(32, '2024-08-28', '2024-08-28 15:55:29.000000', 1, 'fbs', 140, 5, 1),
(33, '2024-08-29', '2024-08-29 14:13:24.000000', 1, 'weight', 84.2, 2, 1),
(34, '2024-08-29', '2024-08-29 09:57:17.000000', 1, 'bp', 120, 3, 1),
(35, '2024-08-29', '2024-08-29 09:57:17.000000', 1, 'bpm', 90, 4, 1);
-- --------------------------------------------------------
--
-- Table structure for table `patient_daily_diet`
--
CREATE TABLE `patient_daily_diet` (
`patient_daily_diet_id` bigint(20) NOT NULL,
`daily_diet_date` date DEFAULT NULL,
`intake_quantity` double DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`meals` varchar(255) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`food_id` bigint(20) DEFAULT NULL,
`emp_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `patient_daily_diet`
--
INSERT INTO `patient_daily_diet` (`patient_daily_diet_id`, `daily_diet_date`, `intake_quantity`, `last_modified`, `meals`, `modified_by`, `food_id`, `emp_id`) VALUES
(4, '2024-08-21', 100, '2024-08-21 11:46:56.000000', 'Breakfast', 1, 1, 1),
(5, '2024-08-21', 100, '2024-08-21 11:47:54.000000', 'Breakfast', 1, 2, 1),
(6, '2024-08-21', 100, '2024-08-21 13:45:17.000000', 'Lunch', 1, 1, 1),
(7, '2024-08-21', 100, '2024-08-21 14:27:52.000000', 'Lunch', 1, 1, 1),
(8, '2024-08-21', 100, '2024-08-21 15:13:21.000000', 'Lunch', 1, 1, 1),
(9, '2024-08-21', 100, '2024-08-21 16:31:50.000000', 'Evening Snacks', 1, 2, 1),
(10, '2024-08-21', 200, '2024-08-21 16:51:11.000000', 'Evening Snacks', 1, 2, 1),
(11, '2024-08-21', 100, '2024-08-21 16:57:21.000000', 'Evening Snacks', 1, 2, 1),
(12, '2024-08-21', 100, '2024-08-21 16:58:05.000000', 'Evening Snacks', 1, 2, 1),
(13, '2024-08-21', 100, '2024-08-21 16:58:11.000000', 'Evening Snacks', 1, 1, 1),
(15, '2024-08-22', 100, '2024-08-24 09:54:01.000000', 'Evening Snacks', 1, 2, 1),
(16, '2024-08-23', 100, '2024-08-24 12:01:07.000000', 'Breakfast', 1, 1, 1),
(17, '2024-08-23', 100, '2024-08-24 12:01:07.000000', 'Breakfast', 1, 1, 1),
(18, '2024-08-23', 100, '2024-08-24 12:01:07.000000', 'Breakfast', 1, 1, 1),
(19, '2024-08-24', 100, '2024-08-24 12:15:26.000000', 'Lunch', 1, 1, 1),
(20, '2024-08-24', 100, '2024-08-24 12:15:32.000000', 'Lunch', 1, 2, 1),
(21, '2024-08-26', 100, '2024-08-26 22:46:14.000000', 'Dinner', 1, 1, 1),
(22, '2024-08-26', 100, '2024-08-26 22:46:18.000000', 'Dinner', 1, 2, 1),
(23, '2024-08-28', 100, '2024-08-28 15:57:44.000000', 'Evening Snacks', 1, 1, 1),
(24, '2024-08-28', 100, '2024-08-28 15:57:48.000000', 'Evening Snacks', 1, 2, 1),
(25, '2024-08-28', 100, '2024-08-28 17:25:39.000000', 'Evening Snacks', 1, 1, 1);
-- --------------------------------------------------------
--
-- Table structure for table `patient_daily_diet_nutrient`
--
CREATE TABLE `patient_daily_diet_nutrient` (
`id` bigint(20) NOT NULL,
`nutrient_id` bigint(20) DEFAULT NULL,
`value` double DEFAULT NULL,
`patient_daily_diet_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `patient_daily_diet_nutrient`
--
INSERT INTO `patient_daily_diet_nutrient` (`id`, `nutrient_id`, `value`, `patient_daily_diet_id`) VALUES
(16, 1, 18, 4),
(17, 2, 250, 4),
(18, 3, 12, 4),
(19, 4, 0, 4),
(20, 5, 0, 4),
(21, 1, 9, 5),
(22, 2, 116, 5),
(23, 3, 0.1, 5),
(24, 4, 8, 5),
(25, 5, 0, 5),
(26, 1, 18, 6),
(27, 2, 250, 6),
(28, 3, 12, 6),
(29, 4, 0, 6),
(30, 5, 0, 6),
(31, 1, 18, 7),
(32, 2, 250, 7),
(33, 3, 12, 7),
(34, 4, 0, 7),
(35, 5, 0, 7),
(36, 1, 18, 8),
(37, 2, 250, 8),
(38, 3, 12, 8),
(39, 4, 0, 8),
(40, 5, 0, 8),
(41, 1, 9, 9),
(42, 2, 116, 9),
(43, 3, 0.1, 9),
(44, 4, 8, 9),
(45, 5, 0, 9),
(46, 1, 9, 10),
(47, 2, 116, 10),
(48, 3, 0.1, 10),
(49, 4, 8, 10),
(50, 5, 0, 10),
(51, 1, 9, 11),
(52, 2, 116, 11),
(53, 3, 0.1, 11),
(54, 4, 8, 11),
(55, 5, 0, 11),
(56, 1, 9, 12),
(57, 2, 116, 12),
(58, 3, 0.1, 12),
(59, 4, 8, 12),
(60, 5, 0, 12),
(61, 1, 18, 13),
(62, 2, 250, 13),
(63, 3, 12, 13),
(64, 4, 0, 13),
(65, 5, 0, 13),
(71, 1, 9, 15),
(72, 2, 116, 15),
(73, 3, 0.1, 15),
(74, 4, 8, 15),
(75, 5, 0, 15),
(91, 1, 18, 16),
(92, 2, 250, 16),
(93, 3, 12, 16),
(94, 4, 0, 16),
(95, 5, 0, 16),
(96, 1, 18, 17),
(97, 2, 250, 17),
(98, 3, 12, 17),
(99, 4, 0, 17),
(100, 5, 0, 17),
(101, 1, 18, 18),
(102, 2, 250, 18),
(103, 3, 12, 18),
(104, 4, 0, 18),
(105, 5, 0, 18),
(106, 1, 18, 19),
(107, 2, 250, 19),
(108, 3, 12, 19),
(109, 4, 0, 19),
(110, 5, 0, 19),
(111, 1, 9, 20),
(112, 2, 116, 20),
(113, 3, 0.1, 20),
(114, 4, 8, 20),
(115, 5, 0, 20),
(116, 1, 18, 21),
(117, 2, 250, 21),
(118, 3, 12, 21),
(119, 4, 0, 21),
(120, 5, 0, 21),
(121, 1, 9, 22),
(122, 2, 116, 22),
(123, 3, 0.1, 22),
(124, 4, 8, 22),
(125, 5, 0, 22),
(126, 1, 18, 23),
(127, 2, 250, 23),
(128, 3, 12, 23),
(129, 4, 0, 23),
(130, 5, 0, 23),
(131, 1, 9, 24),
(132, 2, 116, 24),
(133, 3, 0.1, 24),
(134, 4, 8, 24),
(135, 5, 0, 24),
(136, 1, 18, 25),
(137, 2, 250, 25),
(138, 3, 12, 25),
(139, 4, 0, 25),
(140, 5, 0, 25);
-- --------------------------------------------------------
--
-- Table structure for table `patient_daily_exercise`
--
CREATE TABLE `patient_daily_exercise` (
`patient_daily_exercise_id` bigint(20) NOT NULL,
`daily_exercise_date` date DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`remark` varchar(255) DEFAULT NULL,
`exercise_value` double DEFAULT NULL,
`exercise_id` bigint(20) DEFAULT NULL,
`emp_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `patient_daily_exercise`
--
INSERT INTO `patient_daily_exercise` (`patient_daily_exercise_id`, `daily_exercise_date`, `last_modified`, `modified_by`, `remark`, `exercise_value`, `exercise_id`, `emp_id`) VALUES
(3, '2024-08-17', '2024-08-17 17:10:17.000000', NULL, '60 min', 65, 3, 1),
(4, '2024-08-17', '2024-08-17 17:10:17.000000', NULL, '20 cycling', 20, 4, 1),
(5, '2024-08-17', '2024-08-17 17:10:17.000000', NULL, '10 mins yoga', 10, 6, 1),
(6, '2024-08-20', '2024-08-20 23:41:06.000000', 1, 'for 20 mins only', 20, 1, 1),
(7, '2024-08-20', '2024-08-20 14:31:01.000000', 1, '10 mins only', 7, 2, 1),
(8, '2024-08-20', '2024-08-20 14:31:01.000000', 1, '60 min', 57, 3, 1),
(9, '2024-08-20', '2024-08-20 14:31:01.000000', 1, '20 min', 20, 4, 1),
(10, '2024-08-21', '2024-08-22 18:56:09.000000', 1, 'for 20 mins only', 24, 1, 1),
(11, '2024-08-21', '2024-08-21 14:11:48.000000', 1, '10 mins only', 10, 2, 1),
(12, '2024-08-21', '2024-08-21 14:11:48.000000', 1, '60 min', 60, 3, 1),
(13, '2024-08-21', '2024-08-21 14:11:48.000000', 1, '20', 20, 4, 1),
(14, '2024-08-21', '2024-08-21 14:11:48.000000', 1, '12 mins', 12, 5, 1),
(15, '2024-08-22', '2024-08-22 18:56:00.000000', 1, 'for 20 mins only', 24, 1, 1),
(16, '2024-08-22', '2024-08-22 15:55:39.000000', 1, '10 mins only', 10, 2, 1),
(17, '2024-08-22', '2024-08-22 15:55:39.000000', 1, '60 min', 60, 3, 1),
(18, '2024-08-23', '2024-08-23 10:29:52.000000', 1, 'play for 25mins', 25, 1, 1),
(19, '2024-08-23', '2024-08-23 10:29:52.000000', 1, '10 mins only', 10, 2, 1),
(20, '2024-08-23', '2024-08-23 10:29:52.000000', 1, '60 min', 60, 3, 1),
(21, '2024-08-23', '2024-08-23 10:29:52.000000', 1, '20 min', 20, 4, 1),
(22, '2024-08-23', '2024-08-23 10:29:52.000000', 1, '12 mins', 12, 5, 1),
(23, '2024-08-23', '2024-08-23 10:29:52.000000', 1, '20', 20, 8, 1),
(24, '2024-08-24', '2024-08-24 12:19:27.000000', 1, 'for 20 mins only', 20, 1, 1),
(25, '2024-08-24', '2024-08-24 12:19:27.000000', 1, '10', 10, 2, 1),
(26, '2024-08-24', '2024-08-24 12:19:27.000000', 1, '60 min', 60, 3, 1),
(27, '2024-08-24', '2024-08-24 12:19:27.000000', 1, '15 min', 15, 8, 1),
(28, '2024-08-26', '2024-08-26 22:46:04.000000', 1, 'for 20 mins only', 20, 1, 1),
(29, '2024-08-26', '2024-08-26 22:46:04.000000', 1, '10 mins only', 10, 2, 1),
(30, '2024-08-26', '2024-08-26 22:46:04.000000', 1, '15 mins', 16, 13, 1),
(31, '2024-08-28', '2024-08-28 15:57:06.000000', 1, 'for 20 mins only', 20, 1, 1),
(32, '2024-08-28', '2024-08-28 15:57:06.000000', 1, '10 mins only', 10, 2, 1),
(33, '2024-08-28', '2024-08-28 15:57:06.000000', 1, '20', 20, 4, 1),
(34, '2024-08-28', '2024-08-28 15:57:06.000000', 1, '10 mins', 10, 6, 1),
(35, '2024-08-29', '2024-08-29 09:59:24.000000', 1, '20 mins', 20, 1, 1),
(36, '2024-08-29', '2024-08-29 09:59:24.000000', 1, '10 mins only', 10, 2, 1),
(37, '2024-08-29', '2024-08-29 09:59:24.000000', 1, '10 min', 10, 4, 1),
(38, '2024-08-29', '2024-08-29 09:59:24.000000', 1, '5 mins', 5, 11, 1);
-- --------------------------------------------------------
--
-- Table structure for table `patient_diet_plan`
--
CREATE TABLE `patient_diet_plan` (
`patient_diet_plan_id` bigint(20) NOT NULL,
`remark` varchar(255) DEFAULT NULL,
`nutrient_value` double DEFAULT NULL,
`consultation_id` bigint(20) DEFAULT NULL,
`nutrient_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `patient_diet_plan`
--
INSERT INTO `patient_diet_plan` (`patient_diet_plan_id`, `remark`, `nutrient_value`, `consultation_id`, `nutrient_id`) VALUES
(1, '4g Saturated fat', 4, 2, 5),
(2, '4g Saturated fat', 4, 3, 5),
(5, '120 g protein', 65, 7, 1),
(6, '2000 calories', 2000, 7, 2),
(7, '4 g fiber', 4, 7, 3),
(8, '25g sugar', 25, 7, 4),
(9, '4.5g Saturated fat', 4.5, 7, 5),
(13, '100 g protein', 130, 12, 1),
(14, '2000 calories', 2000, 12, 2),
(15, '4 g fiber', 4, 12, 3),
(16, '30 gram', 30, 12, 4),
(17, '6 added sugar', 6, 12, 5),
(18, '2000 calories', 2000, 13, 2),
(19, '100 g protein', 120, 14, 1),
(20, '2000 calories', 2000, 14, 2),
(21, '5g', 5, 14, 3),
(22, '30g sugar', 30, 14, 4),
(23, '5 gram', 5, 14, 5),
(24, '100 g protein', 100, 15, 1),
(25, '2000 calories', 2000, 15, 2),
(26, '4 g ', 4, 15, 3),
(27, '30g sugar', 30, 15, 4),
(28, '4.5g Saturated fat', 4.5, 15, 5),
(29, '120 g protein', 120, 16, 1),
(30, '2000 calories', 2000, 16, 2),
(31, '8 g ', 8, 16, 3),
(32, '30g', 30, 16, 4),
(33, '4g', 4, 16, 5);
-- --------------------------------------------------------
--
-- Table structure for table `patient_exercise_plan`
--
CREATE TABLE `patient_exercise_plan` (
`patient_exercise_plan_id` bigint(20) NOT NULL,
`remark` varchar(255) DEFAULT NULL,
`exercise_value` double DEFAULT NULL,
`consultation_id` bigint(20) DEFAULT NULL,
`exercise_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `patient_exercise_plan`
--
INSERT INTO `patient_exercise_plan` (`patient_exercise_plan_id`, `remark`, `exercise_value`, `consultation_id`, `exercise_id`) VALUES
(1, 'for 20 mins only', 20, 1, 1),
(2, '10 mins only', 10, 1, 2),
(3, 'for 20 mins only', 20, 2, 1),
(4, '10 mins only', 10, 2, 2),
(5, '60 min', 60, 2, 3),
(6, 'play for 10mins', 10, 3, 1),
(7, 'for 10 mins', 10, 3, 2),
(8, '60 min', 60, 3, 3),
(13, 'for 20 mins only', 65, 7, 1),
(14, '60 min', 40, 7, 3),
(17, 'for 20 mins only', 20, 12, 1),
(18, '10 mins only', 10, 12, 2),
(19, '60 min', 60, 12, 3),
(20, '10 mins only', 10, 13, 2),
(21, '10 mins only', 15, 14, 2),
(22, '60 min', 59, 14, 3),
(23, '20', 19, 14, 4),
(24, '12 mins', 12, 14, 5),
(25, '10 min', 9, 14, 6),
(26, '25', 27, 14, 7),
(27, '20 mins', 15, 14, 9),
(28, 'for 20 mins only', 20, 15, 1),
(29, '10 mins only', 10, 15, 2),
(30, '30 min', 25, 15, 3),
(31, '10 min', 7, 15, 6),
(32, '15', 17, 15, 13),
(33, 'for 10 min', 9, 16, 1),
(34, '20 mins', 19, 16, 2),
(35, '20 mins', 19, 16, 4),
(36, '10 min', 9, 16, 6),
(37, '25 mins', 26, 16, 7);
-- --------------------------------------------------------
--
-- Table structure for table `patient_master_new`
--
CREATE TABLE `patient_master_new` (
`patient_master_id` bigint(20) NOT NULL,
`aadhar_no` varchar(255) DEFAULT NULL,
`blood_group` varchar(255) DEFAULT NULL,
`district` varchar(255) DEFAULT NULL,
`dob` date DEFAULT NULL,
`email_id` varchar(255) DEFAULT NULL,
`father_name` varchar(255) DEFAULT NULL,
`gender` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`patient_name` varchar(255) DEFAULT NULL,
`personal_phone` varchar(255) DEFAULT NULL,
`pin_code` int(11) DEFAULT NULL,
`post` varchar(255) DEFAULT NULL,
`primary_contact_no` varchar(255) DEFAULT NULL,
`primary_contact_person` varchar(255) DEFAULT NULL,
`primary_phone` varchar(255) DEFAULT NULL,
`ps` varchar(255) DEFAULT NULL,
`secondary_contact_no` varchar(255) DEFAULT NULL,
`secondary_contact_person` varchar(255) DEFAULT NULL,
`state` varchar(255) DEFAULT NULL,
`tehsil` varchar(255) DEFAULT NULL,
`village` varchar(255) DEFAULT NULL,
`emp_code` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `patient_master_new`
--
INSERT INTO `patient_master_new` (`patient_master_id`, `aadhar_no`, `blood_group`, `district`, `dob`, `email_id`, `father_name`, `gender`, `last_modified`, `modified_by`, `patient_name`, `personal_phone`, `pin_code`, `post`, `primary_contact_no`, `primary_contact_person`, `primary_phone`, `ps`, `secondary_contact_no`, `secondary_contact_person`, `state`, `tehsil`, `village`, `emp_code`) VALUES
(1, '12345679', 'B+', 'raipur', '1997-06-11', 'Awtar@gmail.com', 'SUDHIR YADAV', 'Male', '2024-08-28 16:27:59.000000', 1, 'Awtar Sharm', '6546454644', 479939, 'raipur', NULL, NULL, '09340555123', 'VERAVAL', NULL, NULL, 'Chhattisgarh', 'AKOA', '', 'NVG0456'),
(2, '', 'A+', 'MUMBAI ', '1999-06-09', NULL, 'Jaya prakash', 'Male', '2024-08-14 14:30:26.000000', 1, 'Sumit sharma', NULL, 495661, '', NULL, NULL, '', '', NULL, NULL, 'MAHARASHTRA ', '', '', 'DFG456'),
(3, '12345679', 'AB+', '', '1999-02-04', NULL, 'aaddf', 'Male', '2024-08-17 14:34:21.000000', 1, 'Avinash', NULL, NULL, '', NULL, NULL, '', '', NULL, NULL, '', '', '', 'FDS879'),
(4, '', 'A+', '', '2024-08-28', NULL, '', 'Male', '2024-08-28 17:11:46.000000', 1, 'vikas', NULL, NULL, '', NULL, NULL, '', '', NULL, NULL, '', '', '', 'EFR368');
-- --------------------------------------------------------
--
-- Table structure for table `plant_master`
--
CREATE TABLE `plant_master` (
`id` bigint(20) NOT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`plant_name` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `plant_master`
--
INSERT INTO `plant_master` (`id`, `last_modified`, `modified_by`, `plant_name`) VALUES
(1, '2024-09-13 11:02:17.000000', 2, 'test'),
(2, '2024-09-13 11:02:58.000000', 2, 'test'),
(3, '2024-09-13 11:03:47.000000', 2, 'test5'),
(4, '2024-09-13 11:04:30.000000', 2, 'test6'),
(5, '2024-09-13 11:05:36.000000', 2, 'test7');
-- --------------------------------------------------------
--
-- Table structure for table `prescription_master`
--
CREATE TABLE `prescription_master` (
`prescription_id` bigint(20) NOT NULL,
`admin_route` varchar(255) DEFAULT NULL,
`diagnosis` varchar(255) DEFAULT NULL,
`diagnosis_date` varchar(255) DEFAULT NULL,
`diseases` varchar(255) DEFAULT NULL,
`dose_qty` varchar(255) DEFAULT NULL,
`duration` varchar(255) DEFAULT NULL,
`emp_id` varchar(255) DEFAULT NULL,
`health_advices` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`medicine_frequency` varchar(255) DEFAULT NULL,
`medicine_name` varchar(255) DEFAULT NULL,
`medicine_timing` varchar(255) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`ohc_type_id` int(11) DEFAULT NULL,
`remark` varchar(255) DEFAULT NULL,
`remission_date` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `questionaire_master`
--
CREATE TABLE `questionaire_master` (
`question_id` bigint(20) NOT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`question` varchar(255) DEFAULT NULL,
`question_local_lang` varchar(255) DEFAULT NULL,
`question_sequence` int(11) DEFAULT NULL,
`question_type` varchar(255) DEFAULT NULL,
`section_name` varchar(255) DEFAULT NULL,
`sub_section_available` varchar(255) DEFAULT NULL,
`sub_section_order` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `referral_point`
--
CREATE TABLE `referral_point` (
`referral_point_id` bigint(20) NOT NULL,
`address` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`contact_detail` varchar(255) DEFAULT NULL,
`created_time` datetime(6) DEFAULT NULL,
`hospital_name` varchar(255) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`referral_point_name` varchar(255) DEFAULT NULL,
`id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `referral_point`
--
INSERT INTO `referral_point` (`referral_point_id`, `address`, `city`, `contact_detail`, `created_time`, `hospital_name`, `modified_by`, `referral_point_name`, `id`) VALUES
(1, 'bangaluru', 'BENGALURU', '5565656564656', '2024-09-09 19:18:18.000000', 'APOLLO hospital', 2, 'APOLLO SPECIALITY HOSPITAL JA', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `referred_by_master`
--
CREATE TABLE `referred_by_master` (
`id` bigint(20) NOT NULL,
`description` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`referred_by` varchar(255) DEFAULT NULL,
`remarks` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `referred_by_master`
--
INSERT INTO `referred_by_master` (`id`, `description`, `last_modified`, `modified_by`, `referred_by`, `remarks`) VALUES
(1, 'HUMAN RESOURCES', '2024-09-10 12:57:57.000000', 2, 'HR', 'NA'),
(2, 'test', '2024-09-10 12:58:06.000000', 2, 'test', 'test');
-- --------------------------------------------------------
--
-- Table structure for table `refresh_token`
--
CREATE TABLE `refresh_token` (
`id` bigint(20) NOT NULL,
`expiration_time_in_millis` datetime(6) DEFAULT NULL,
`token` text DEFAULT NULL,
`user_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `refresh_token`
--
INSERT INTO `refresh_token` (`id`, `expiration_time_in_millis`, `token`, `user_id`) VALUES
(1, '2024-09-14 21:33:03.000000', 'eyJraWQiOiIyMjBlMGM2Mi05MDkyLTQ0ZDQtOTU0Ni03Yzg1MjA3NzExYjEiLCJhbGciOiJSUzI1NiJ9.eyJpc3MiOiJzZWxmIiwic3ViIjoiRG9jdG9yIiwiZXhwIjoxNzI2MzQ5NTgzLCJpYXQiOjE3MjYyODk1ODMsInNjb3BlIjoiUGF0aWVudCBSb2xlIERvY3RvciBSb2xlIn0.KcorACNEfTJkOhseyFyBtLr5qh1XuY681YV8pRJb5wzB33ILXPxPa8fyAc7ocXWl1JZlJrFVMR76VzWvWk4Qs8-pAl6Z_aGxOrHEqJQ08rM7Bzew5-lkAfWntH3aL3VLNsAReEjIOKjzt_rKQak3yLD7mhyCWqWHiir_XMtb0dWFTAew8WOFxjrTAHpHi9D8PLqsSLjSw-2qN0-vjykq6g1palgaP-IbIwv_Fgq0rP7na4eVyvsWB03iRsydwkvtIbJQBcH8rLIemX52-1dysyYl5JIDyloeQ2IdzPFQyG0g11zf_JA_RVOv5cyUWyauE8Fzc2z3i0lasrViTmeKLg', 1),
(2, '2024-09-18 20:59:46.000000', 'eyJraWQiOiIxYzkwNjE2My0xMjZlLTQzYzMtODdiZi1jOTdkYmMxYTc5N2YiLCJhbGciOiJSUzI1NiJ9.eyJpc3MiOiJzZWxmIiwic3ViIjoiYWRtaW4iLCJleHAiOjE3MjY2OTMxODYsImlhdCI6MTcyNjYzMzE4Niwic2NvcGUiOiJBcHBsaWNhdGlvbiBBZG1pbiJ9.BOTkzcA999fp0q0jorLPq42I302ghuHruJNMs7GjcbeiZs6zy0R_Dts1677N9UEVcxtacSUZEhu2_qK_V6TUSPDGykqxOOto0QyHt0G0qRl2LB614AIGS9A4GIY-5R8cRMNLxJCY5RkDRqNf3PcbumaCwTDpe89xk4WO1vQF7YBtw3ruLvthnTg1m8kEI_kXQPHLA09Qlb0fg2-5XhpYEOA5BByrK6URE1Acy1r23tH99m1cvfXQ-18y-lHt2rnY7t7MSiyeGCpjz8aRr8HSxRbffFbP8Gkssqc_xcj-0x_znCRpdXRiwTjm5s7dhEzWYsCzcPzeXVDAlrvOkgPB6g', 2);
-- --------------------------------------------------------
--
-- Table structure for table `report_master`
--
CREATE TABLE `report_master` (
`report_id` bigint(20) NOT NULL,
`fun_name` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`report_code` varchar(255) DEFAULT NULL,
`report_name` varchar(255) DEFAULT NULL,
`report_type` varchar(255) DEFAULT NULL,
`report_url` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `report_master`
--
INSERT INTO `report_master` (`report_id`, `fun_name`, `last_modified`, `modified_by`, `report_code`, `report_name`, `report_type`, `report_url`) VALUES
(1, ' 1 AWED Age Wise Emp Distribution D report_master.php addingRowsForAgeWiseEmpDist()', '2024-09-06 17:40:51.000000', 2, 'AWED', 'Age Wise Emp Distribution', 'Dashboard', 'report_master.php'),
(2, ' 1 AWED Age Wise Emp Distribution D report_master.php addingRowsForAgeWiseEmpDist()', '2024-09-06 17:52:37.000000', 2, 'test', 'test', 'Dashboard', 'report.jsx');
-- --------------------------------------------------------
--
-- Table structure for table `roles`
--
CREATE TABLE `roles` (
`id` bigint(20) NOT NULL,
`icon_color` varchar(255) DEFAULT NULL,
`icon_text` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`role_code` enum('ADM','DOC','LAB','RCP','EMP','STR','DIS','DOC_WELLNESS','EMP_WELLNESS') DEFAULT NULL,
`role_description` varchar(255) DEFAULT NULL,
`role_home_page` varchar(255) DEFAULT NULL,
`role_name` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `roles`
--
INSERT INTO `roles` (`id`, `icon_color`, `icon_text`, `last_modified`, `modified_by`, `role_code`, `role_description`, `role_home_page`, `role_name`) VALUES
(1, NULL, 'CMO', NULL, NULL, 'DOC_WELLNESS', 'doctor role', NULL, 'Doctor Role'),
(2, NULL, 'EMP', NULL, NULL, 'EMP_WELLNESS', 'patient role', NULL, 'Patient Role'),
(3, NULL, 'AA', NULL, NULL, 'ADM', 'Application admin', 'application admin', 'Application Admin');
-- --------------------------------------------------------
--
-- Table structure for table `role_menu_access`
--
CREATE TABLE `role_menu_access` (
`access_level` enum('READ','WRITE','DELETE') DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
`menu_id` bigint(20) NOT NULL,
`role_id` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `role_menu_access`
--
INSERT INTO `role_menu_access` (`access_level`, `last_modified`, `modified_by`, `menu_id`, `role_id`) VALUES
('DELETE', NULL, NULL, 1, 1),
('DELETE', NULL, NULL, 8, 1),
('DELETE', NULL, NULL, 10, 3),
('DELETE', NULL, NULL, 11, 3),
('DELETE', NULL, NULL, 37, 3),
('DELETE', NULL, NULL, 38, 3),
('DELETE', NULL, NULL, 39, 3),
('DELETE', NULL, NULL, 40, 3);
-- --------------------------------------------------------
--
-- Table structure for table `rule_equation`
--
CREATE TABLE `rule_equation` (
`rule_eq_id` bigint(20) NOT NULL,
`advices` varchar(255) DEFAULT NULL,
`color` varchar(255) DEFAULT NULL,
`cout` int(11) DEFAULT NULL,
`is_string_rule` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`range_type` varchar(255) DEFAULT NULL,
`result` int(11) DEFAULT NULL,
`result_disp` varchar(255) DEFAULT NULL,
`risks` varchar(255) DEFAULT NULL,
`rule_age_end` int(11) DEFAULT NULL,
`rule_age_start` int(11) DEFAULT NULL,
`rule_equation` varchar(255) DEFAULT NULL,
`rule_gender` varchar(255) DEFAULT NULL,
`abnormality` bigint(20) DEFAULT NULL,
`checkup_form_section_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `rule_equation`
--
INSERT INTO `rule_equation` (`rule_eq_id`, `advices`, `color`, `cout`, `is_string_rule`, `last_modified`, `modified_by`, `range_type`, `result`, `result_disp`, `risks`, `rule_age_end`, `rule_age_start`, `rule_equation`, `rule_gender`, `abnormality`, `checkup_form_section_id`) VALUES
(3, '', '', 5, 'false', '2024-09-05 09:51:19.653408', 5, '', 0, '', '', 6, 2, 'sample', '', 1, NULL),
(4, 'test', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'test_equation', NULL, 2, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `salt_master`
--
CREATE TABLE `salt_master` (
`salt_id` bigint(20) NOT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`salt_name` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `salt_master`
--
INSERT INTO `salt_master` (`salt_id`, `last_modified`, `modified_by`, `salt_name`) VALUES
(1, '2024-09-13 10:59:22.000000', 2, 'acarbose'),
(2, '2024-09-13 10:59:31.000000', 2, 'test'),
(4, '2024-09-13 11:06:41.000000', 2, 'test1'),
(5, '2024-09-13 11:07:39.000000', 2, 'test2'),
(6, '2024-09-13 11:08:29.000000', 2, 'test3');
-- --------------------------------------------------------
--
-- Table structure for table `section`
--
CREATE TABLE `section` (
`section_id` bigint(20) NOT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`section_head_email` varchar(255) DEFAULT NULL,
`section_headname` varchar(255) DEFAULT NULL,
`section_name` varchar(255) DEFAULT NULL,
`bu_id` bigint(20) DEFAULT NULL,
`dept_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `shift_details`
--
CREATE TABLE `shift_details` (
`shift_id` bigint(20) NOT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`shift_date` date NOT NULL,
`shift_status` varchar(255) DEFAULT NULL,
`ohc_type_id` bigint(20) DEFAULT NULL,
`emp_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `shift_status_details`
--
CREATE TABLE `shift_status_details` (
`shift_details_id` bigint(20) NOT NULL,
`current_status` varchar(255) DEFAULT NULL,
`end_date_time` datetime(6) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`record_date` date DEFAULT NULL,
`start_date_time` datetime(6) DEFAULT NULL,
`ohc_location_id` bigint(20) DEFAULT NULL,
`shift_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `task_frequency_master`
--
CREATE TABLE `task_frequency_master` (
`frequency_id` bigint(20) NOT NULL,
`frequency_code` varchar(20) DEFAULT NULL,
`frequency_name` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `task_frequency_master`
--
INSERT INTO `task_frequency_master` (`frequency_id`, `frequency_code`, `frequency_name`, `last_modified`, `modified_by`) VALUES
(1, 'W', 'Weekly', '2024-09-03 11:38:16.000000', 2),
(3, 'tt', 'test', '2024-09-03 11:44:25.000000', 2),
(4, 'test', 'test', '2024-09-03 16:07:57.000000', 2),
(7, 'test4', 'test4', '2024-09-03 16:41:57.000000', 2),
(8, 'test55', 'test55', '2024-09-03 17:38:11.000000', 2);
-- --------------------------------------------------------
--
-- Table structure for table `tbl_categories`
--
CREATE TABLE `tbl_categories` (
`cat_id` bigint(20) NOT NULL,
`cat_name` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`remarks` mediumtext DEFAULT NULL,
`status` varchar(255) DEFAULT NULL,
`cat_code` varchar(255) DEFAULT NULL,
`parent_id` bigint(20) NOT NULL,
`sequence` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `tbl_categories`
--
INSERT INTO `tbl_categories` (`cat_id`, `cat_name`, `last_modified`, `modified_by`, `remarks`, `status`, `cat_code`, `parent_id`, `sequence`) VALUES
(1, 'Capital/Nonconsumable/Intruments', '2024-09-04 12:52:25.000000', 2, 'Capital/Nonconsumable/Intruments', 'Active', NULL, 0, NULL),
(2, 'Medicine_Ear Drop/Eye Drop', '2024-09-04 12:52:47.000000', 2, 'Medicine_Ear Drop/Eye Drop', 'Active', NULL, 0, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `tbl_items`
--
CREATE TABLE `tbl_items` (
`item_id` bigint(20) NOT NULL,
`ailments` varchar(255) DEFAULT NULL,
`contra_indication` varchar(255) DEFAULT NULL,
`indent_percent_reorder_level` int(11) DEFAULT 10,
`indication` varchar(255) DEFAULT NULL,
`interaction` varchar(255) DEFAULT NULL,
`is_group_item` set('P','C','N') DEFAULT 'N',
`is_packaging_item` set('P','N','C') DEFAULT 'N',
`is_prescription` set('1','0') DEFAULT NULL,
`item_alternate` varchar(255) DEFAULT NULL,
`item_code` varchar(255) DEFAULT NULL,
`item_name` varchar(255) DEFAULT NULL,
`item_precaution` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`max_indent_level` float DEFAULT NULL,
`min_dispensary_level` float DEFAULT NULL,
`min_indent_level` float DEFAULT NULL,
`min_store_level` float DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`remarks` varchar(255) DEFAULT NULL,
`reorder_dispensary_level` float DEFAULT NULL,
`reorder_store_level` float DEFAULT NULL,
`composition` varchar(255) DEFAULT NULL,
`side_effects` varchar(255) DEFAULT NULL,
`status` enum('0','1') DEFAULT '1',
`sub_classification` varchar(255) DEFAULT NULL,
`vendor_id` varchar(255) DEFAULT NULL,
`cat` bigint(20) DEFAULT NULL,
`item_form_id` bigint(20) DEFAULT NULL,
`medicine_usage_cat_id` bigint(20) DEFAULT NULL,
`ohc_type_id` bigint(20) DEFAULT NULL,
`unit_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `tbl_items`
--
INSERT INTO `tbl_items` (`item_id`, `ailments`, `contra_indication`, `indent_percent_reorder_level`, `indication`, `interaction`, `is_group_item`, `is_packaging_item`, `is_prescription`, `item_alternate`, `item_code`, `item_name`, `item_precaution`, `last_modified`, `max_indent_level`, `min_dispensary_level`, `min_indent_level`, `min_store_level`, `modified_by`, `remarks`, `reorder_dispensary_level`, `reorder_store_level`, `composition`, `side_effects`, `status`, `sub_classification`, `vendor_id`, `cat`, `item_form_id`, `medicine_usage_cat_id`, `ohc_type_id`, `unit_id`) VALUES
(8, '1', NULL, 10, NULL, NULL, 'N', 'P', '1', NULL, 'ITEM008', 'Sample Item', NULL, '2024-09-19 17:26:20.000000', NULL, NULL, NULL, NULL, 5, 'Some remarks', NULL, NULL, '2', NULL, '0', NULL, NULL, 1, 1, 1, 1, 1),
(9, '1', NULL, 10, NULL, NULL, 'N', 'P', '1', NULL, 'ITEM009', 'Dressing', NULL, '2024-09-03 18:41:55.000000', NULL, NULL, NULL, NULL, 5, 'Some remarks', NULL, NULL, '2', NULL, '0', NULL, NULL, 1, 1, 1, 1, 1),
(10, '1', NULL, 10, NULL, NULL, 'N', 'P', '1', NULL, 'ITEM0010', 'Sample Item 1', NULL, '2024-09-04 19:00:27.000000', NULL, NULL, NULL, NULL, 5, 'Some remarks', NULL, NULL, '2', NULL, '0', NULL, NULL, 1, 1, 1, 1, 1),
(11, '1', NULL, 10, NULL, NULL, 'N', 'P', '1', NULL, 'ITEM0011', 'Sample Item 2', NULL, '2024-09-04 00:00:00.000000', NULL, NULL, NULL, NULL, 5, 'Some remarks', NULL, NULL, '2', NULL, '0', NULL, NULL, 1, 1, 1, 1, 1),
(12, '1', '', 10, '', '', '', '', '1', '', 'item code', 'item name', '', '2024-09-18 18:58:20.000000', NULL, NULL, NULL, NULL, 2, '', NULL, NULL, '1,4', '', '0', '', '', 1, 1, 1, 1, 3);
-- --------------------------------------------------------
--
-- Table structure for table `training_master`
--
CREATE TABLE `training_master` (
`training_master_id` bigint(20) NOT NULL,
`description` varchar(255) DEFAULT NULL,
`duration` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`training_name` varchar(255) DEFAULT NULL,
`type_of_training` varchar(255) DEFAULT NULL,
`key_health_parameter` bigint(20) DEFAULT NULL,
`mode_of_training` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `training_master`
--
INSERT INTO `training_master` (`training_master_id`, `description`, `duration`, `last_modified`, `modified_by`, `training_name`, `type_of_training`, `key_health_parameter`, `mode_of_training`) VALUES
(1, 'fire safety training', NULL, NULL, NULL, 'FIRE SAFETY TRAINING', NULL, 1, 1),
(2, 'first aid training', NULL, NULL, NULL, 'FIRST AID TRAINING', NULL, 1, 1);
-- --------------------------------------------------------
--
-- Table structure for table `training_mode`
--
CREATE TABLE `training_mode` (
`id` bigint(20) NOT NULL,
`training_mode` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `training_mode`
--
INSERT INTO `training_mode` (`id`, `training_mode`) VALUES
(1, 'test'),
(2, 'test1');
-- --------------------------------------------------------
--
-- Table structure for table `unit_master`
--
CREATE TABLE `unit_master` (
`id` bigint(20) NOT NULL,
`remarks` varchar(255) DEFAULT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`unit_code` varchar(255) DEFAULT NULL,
`unit_name` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `unit_master`
--
INSERT INTO `unit_master` (`id`, `remarks`, `last_modified`, `modified_by`, `unit_code`, `unit_name`) VALUES
(1, 'kg', '2024-08-08 14:52:04.000000', 1, 'kilogram', 'kg'),
(2, 'gram', '2024-08-08 14:52:11.000000', 1, 'gram', 'g'),
(3, 'minute', '2024-08-08 14:52:24.000000', 1, 'minute', 'min'),
(4, 'unit for calories', '2024-08-08 15:05:10.000000', 1, 'cal', 'cal'),
(5, 'calories from protein', '2024-08-08 15:05:51.000000', 1, 'percantage', '%'),
(6, 'height', '2024-08-08 15:51:03.000000', 1, 'centi meter', 'cm'),
(7, 'unit', '2024-08-08 15:54:15.000000', 1, 'mmgh', 'mmHg'),
(8, 'pulse', '2024-08-08 15:55:56.000000', 1, 'bpm', 'bpm'),
(9, '', '2024-08-08 15:57:16.000000', 1, 'mg/dl', 'mg/dL');
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` bigint(20) NOT NULL,
`failed_attempt` int(11) DEFAULT NULL,
`is_account_non_expired` bit(1) DEFAULT NULL,
`is_account_non_locked` bit(1) DEFAULT NULL,
`is_credentials_non_expired` bit(1) DEFAULT NULL,
`is_enabled` bit(1) DEFAULT NULL,
`password` varchar(255) NOT NULL,
`username` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `failed_attempt`, `is_account_non_expired`, `is_account_non_locked`, `is_credentials_non_expired`, `is_enabled`, `password`, `username`) VALUES
(1, NULL, b'1', b'1', b'1', b'1', '$2a$10$HJPEdE/U5xU4CjAf1W9egO9iDSCthSWmOWJ5t1yL1qnXZ./ibIlU.', 'Doctor'),
(2, NULL, b'1', b'1', b'1', b'1', '$2a$10$XHpQw32hdoNG8Ej6cZCQHOOWndhiCqQUTkNJddCb6Qdxi8DlzPa9a', 'admin');
-- --------------------------------------------------------
--
-- Table structure for table `users_ohcs`
--
CREATE TABLE `users_ohcs` (
`user_id` bigint(20) NOT NULL,
`ohc_id` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- --------------------------------------------------------
--
-- Table structure for table `users_roles`
--
CREATE TABLE `users_roles` (
`user_id` bigint(20) NOT NULL,
`role_id` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `users_roles`
--
INSERT INTO `users_roles` (`user_id`, `role_id`) VALUES
(1, 1),
(1, 2),
(2, 3);
-- --------------------------------------------------------
--
-- Table structure for table `vaccine_master`
--
CREATE TABLE `vaccine_master` (
`id` bigint(20) NOT NULL,
`last_modified` datetime(6) DEFAULT NULL,
`modified_by` bigint(20) DEFAULT NULL,
`vaccine_company` varchar(255) DEFAULT NULL,
`vaccine_desc` varchar(255) DEFAULT NULL,
`vaccine_name` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `vaccine_master`
--
INSERT INTO `vaccine_master` (`id`, `last_modified`, `modified_by`, `vaccine_company`, `vaccine_desc`, `vaccine_name`) VALUES
(1, '2024-09-09 14:02:20.000000', 2, 'test-company', 'test-description', 'test-name'),
(2, '2024-09-09 14:02:20.000000', 2, 'test-company', 'test-description', 'test-name');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `abnormality`
--
ALTER TABLE `abnormality`
ADD PRIMARY KEY (`abnormality_id`);
--
-- Indexes for table `add_filter_master`
--
ALTER TABLE `add_filter_master`
ADD PRIMARY KEY (`filter_id`);
--
-- Indexes for table `ailment`
--
ALTER TABLE `ailment`
ADD PRIMARY KEY (`ailment_id`);
--
-- Indexes for table `ailment_system`
--
ALTER TABLE `ailment_system`
ADD PRIMARY KEY (`ailment_sys_id`);
--
-- Indexes for table `ambulance_category`
--
ALTER TABLE `ambulance_category`
ADD PRIMARY KEY (`ambulance_category_id`);
--
-- Indexes for table `ambulance_details_new`
--
ALTER TABLE `ambulance_details_new`
ADD PRIMARY KEY (`ambulance_id`),
ADD KEY `FKim5vilv94d92dx44cqeynoth0` (`ambulance_category_id`),
ADD KEY `FK8qwvunayubqjji9kovbfyo1nh` (`ohc_type_id`);
--
-- Indexes for table `appoinment_slots`
--
ALTER TABLE `appoinment_slots`
ADD PRIMARY KEY (`slot_id`);
--
-- Indexes for table `bio_medical_waste`
--
ALTER TABLE `bio_medical_waste`
ADD PRIMARY KEY (`waste_id`),
ADD KEY `FK4domgnwxomvlgf4ylrekrmri2` (`dis_agncy`),
ADD KEY `FKfyciy82xlvn5hascw1jc45jw4` (`ohc_type_id`);
--
-- Indexes for table `bio_medical_waste_new`
--
ALTER TABLE `bio_medical_waste_new`
ADD PRIMARY KEY (`waste_id`),
ADD KEY `FK4qixku6lvoejek68vavg7bp3r` (`ohc_type_id`);
--
-- Indexes for table `body_measurement_master`
--
ALTER TABLE `body_measurement_master`
ADD PRIMARY KEY (`body_measurement_id`),
ADD KEY `FK3aoum26i1d58lghpl76latdk` (`unit_id`);
--
-- Indexes for table `business_reports_filter_master`
--
ALTER TABLE `business_reports_filter_master`
ADD PRIMARY KEY (`business_reports_filter_master_id`),
ADD KEY `FK1bgtpudaccukq8215mwkwyg95` (`filter_id`),
ADD KEY `FKplxcdcy3x46jwguiubqp84kwb` (`report_id`);
--
-- Indexes for table `bussiness_unit`
--
ALTER TABLE `bussiness_unit`
ADD PRIMARY KEY (`bu_id`);
--
-- Indexes for table `calibration_item_tbl`
--
ALTER TABLE `calibration_item_tbl`
ADD PRIMARY KEY (`calibration_id`),
ADD KEY `FKai28tq65hg1ld0wlrrc5nx4bn` (`cat_id`);
--
-- Indexes for table `canteen_master`
--
ALTER TABLE `canteen_master`
ADD PRIMARY KEY (`canteen_id`);
--
-- Indexes for table `checkup_form`
--
ALTER TABLE `checkup_form`
ADD PRIMARY KEY (`checkup_id`),
ADD KEY `FKi55idrbqxmcbdqvj0ue31da8l` (`emp_id`);
--
-- Indexes for table `checkup_form_key_value`
--
ALTER TABLE `checkup_form_key_value`
ADD PRIMARY KEY (`checkup_form_key_value_id`),
ADD KEY `FK3n6gagexumtvty2yxpovsdu6j` (`checkup_form_id`);
--
-- Indexes for table `checkup_form_section`
--
ALTER TABLE `checkup_form_section`
ADD PRIMARY KEY (`section_id`),
ADD KEY `FKquni2722kfpde6it4k86pnm7q` (`interpretation`);
--
-- Indexes for table `checkup_parameter`
--
ALTER TABLE `checkup_parameter`
ADD PRIMARY KEY (`checkup_parameter_id`);
--
-- Indexes for table `checkup_parameter_unit_master`
--
ALTER TABLE `checkup_parameter_unit_master`
ADD PRIMARY KEY (`unit_id`);
--
-- Indexes for table `checkup_parameter_value`
--
ALTER TABLE `checkup_parameter_value`
ADD PRIMARY KEY (`parameter_value_id`);
--
-- Indexes for table `checkup_type`
--
ALTER TABLE `checkup_type`
ADD PRIMARY KEY (`checkup_type_id`);
--
-- Indexes for table `citys`
--
ALTER TABLE `citys`
ADD PRIMARY KEY (`city_id`);
--
-- Indexes for table `company_profile`
--
ALTER TABLE `company_profile`
ADD PRIMARY KEY (`company_id`);
--
-- Indexes for table `complaints`
--
ALTER TABLE `complaints`
ADD PRIMARY KEY (`complaint_id`);
--
-- Indexes for table `config`
--
ALTER TABLE `config`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `covid_wah_questions`
--
ALTER TABLE `covid_wah_questions`
ADD PRIMARY KEY (`question_id`);
--
-- Indexes for table `department`
--
ALTER TABLE `department`
ADD PRIMARY KEY (`dept_id`),
ADD KEY `FK48gsgjulg5j1g2g69g23l150n` (`bu_id`);
--
-- Indexes for table `designation`
--
ALTER TABLE `designation`
ADD PRIMARY KEY (`designation_id`);
--
-- Indexes for table `device_mapping_master`
--
ALTER TABLE `device_mapping_master`
ADD PRIMARY KEY (`id`),
ADD KEY `FK4rjd1gn6tl4eectaevsx2v8ah` (`device_id`);
--
-- Indexes for table `device_master`
--
ALTER TABLE `device_master`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `device_parameter`
--
ALTER TABLE `device_parameter`
ADD PRIMARY KEY (`id`),
ADD KEY `FKob9f5gd8dxeiyym5kjx8477yi` (`device_name`);
--
-- Indexes for table `device_parameter_map`
--
ALTER TABLE `device_parameter_map`
ADD PRIMARY KEY (`device_parameter_id`),
ADD KEY `FKhqeo2nnho0fmqi42kptmdvysb` (`device_name`);
--
-- Indexes for table `diagnosis_chronic_mapping`
--
ALTER TABLE `diagnosis_chronic_mapping`
ADD PRIMARY KEY (`diagnosis_chronic_mapping_id`),
ADD KEY `FK1kaqyx6n1vlxyr8wr467o0jw2` (`chronic_id`),
ADD KEY `FKoqmy9m9hivl0no70h24euqf3d` (`ailment_id`);
--
-- Indexes for table `dignosys_wise_bodysystem`
--
ALTER TABLE `dignosys_wise_bodysystem`
ADD PRIMARY KEY (`id`),
ADD KEY `FK60msl8bufitcoidqsa0lmvrk9` (`ailment_id`),
ADD KEY `FKdsx5wp5q1nfl8o2mq03jdoyt1` (`ailment_sys_id`);
--
-- Indexes for table `disposal_agency`
--
ALTER TABLE `disposal_agency`
ADD PRIMARY KEY (`agency_id`);
--
-- Indexes for table `doctors_master`
--
ALTER TABLE `doctors_master`
ADD PRIMARY KEY (`doctor_id`);
--
-- Indexes for table `dosage_category`
--
ALTER TABLE `dosage_category`
ADD PRIMARY KEY (`dosage_category_id`);
--
-- Indexes for table `duty_master`
--
ALTER TABLE `duty_master`
ADD PRIMARY KEY (`duty_id`);
--
-- Indexes for table `employee_appointment`
--
ALTER TABLE `employee_appointment`
ADD PRIMARY KEY (`appointment_id`),
ADD KEY `FK1hujjcm9n5ple50c195iu67gb` (`emp_id`);
--
-- Indexes for table `employer_contractor`
--
ALTER TABLE `employer_contractor`
ADD PRIMARY KEY (`employer_contractor_id`);
--
-- Indexes for table `emp_cadre`
--
ALTER TABLE `emp_cadre`
ADD PRIMARY KEY (`emp_cadre_id`);
--
-- Indexes for table `exercise`
--
ALTER TABLE `exercise`
ADD PRIMARY KEY (`exe_id`),
ADD KEY `FKnx2bev110jmo7448v07ge3ub7` (`exercise_id`);
--
-- Indexes for table `exercise_master`
--
ALTER TABLE `exercise_master`
ADD PRIMARY KEY (`exercise_id`),
ADD KEY `FKlf4tlrk7wwajksgto7h2cpjhh` (`unit_id`);
--
-- Indexes for table `first_aid_box`
--
ALTER TABLE `first_aid_box`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `food_master`
--
ALTER TABLE `food_master`
ADD PRIMARY KEY (`food_id`),
ADD UNIQUE KEY `UK_87y9nt40ogvsjpirx3cvf2vdj` (`food_name`),
ADD KEY `FKdf8rjfad7v3ptal4oiy48je1t` (`unit_id`);
--
-- Indexes for table `food_nutrient_mapping_values`
--
ALTER TABLE `food_nutrient_mapping_values`
ADD PRIMARY KEY (`food_nutrient_id`),
ADD KEY `FKgr13qxtk023pxiudy52au5n7d` (`food_id`),
ADD KEY `FKfvnjpb4sv2oq863my4alqu9kd` (`nutrient_id`);
--
-- Indexes for table `grade_master`
--
ALTER TABLE `grade_master`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `group_items`
--
ALTER TABLE `group_items`
ADD PRIMARY KEY (`group_item_id`),
ADD KEY `FKfpxps556bajtbhnrlcjt6kjdb` (`group_id`),
ADD KEY `FKamrvolf1cdr1bsl10is1q43br` (`item_id`);
--
-- Indexes for table `habits`
--
ALTER TABLE `habits`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `health_advice`
--
ALTER TABLE `health_advice`
ADD PRIMARY KEY (`health_advice_id`);
--
-- Indexes for table `health_risk`
--
ALTER TABLE `health_risk`
ADD PRIMARY KEY (`health_risk_id`);
--
-- Indexes for table `injury_class`
--
ALTER TABLE `injury_class`
ADD PRIMARY KEY (`inj_class_id`);
--
-- Indexes for table `injury_part`
--
ALTER TABLE `injury_part`
ADD PRIMARY KEY (`inj_id`);
--
-- Indexes for table `injury_type`
--
ALTER TABLE `injury_type`
ADD PRIMARY KEY (`injury_type_id`);
--
-- Indexes for table `interpretation_detail`
--
ALTER TABLE `interpretation_detail`
ADD PRIMARY KEY (`interpretation_detail_id`),
ADD KEY `FK6mukg1qxixnf2lghnkqobx2qk` (`interpretation_id`);
--
-- Indexes for table `interpretation_master`
--
ALTER TABLE `interpretation_master`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `job_profile`
--
ALTER TABLE `job_profile`
ADD PRIMARY KEY (`job_profile_id`);
--
-- Indexes for table `key_health_reportable_parameter_master`
--
ALTER TABLE `key_health_reportable_parameter_master`
ADD PRIMARY KEY (`key_param_id`);
--
-- Indexes for table `medicine_form`
--
ALTER TABLE `medicine_form`
ADD PRIMARY KEY (`form_id`);
--
-- Indexes for table `medicine_frequency`
--
ALTER TABLE `medicine_frequency`
ADD PRIMARY KEY (`frequency_id`);
--
-- Indexes for table `medicine_timings`
--
ALTER TABLE `medicine_timings`
ADD PRIMARY KEY (`timing_id`);
--
-- Indexes for table `medicine_usage_cat`
--
ALTER TABLE `medicine_usage_cat`
ADD PRIMARY KEY (`medicine_usage_cat_id`);
--
-- Indexes for table `menu_master`
--
ALTER TABLE `menu_master`
ADD PRIMARY KEY (`id`),
ADD KEY `FK2q0ww6hwx961rlgmfh24yo72k` (`parent_menu_id`);
--
-- Indexes for table `nutrient_master`
--
ALTER TABLE `nutrient_master`
ADD PRIMARY KEY (`nutrient_id`),
ADD KEY `FKplnyxivaedy5kk5rg1ec040c6` (`unit_id`);
--
-- Indexes for table `ohc_type`
--
ALTER TABLE `ohc_type`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `patient_body_measurement_plan`
--
ALTER TABLE `patient_body_measurement_plan`
ADD PRIMARY KEY (`patient_measurement_id`),
ADD KEY `FKcy8tm13rt6gqvmndrhaxfjkl` (`body_measurement_id`),
ADD KEY `FK1mm5t1ujhbas2clwnia09f5yb` (`consultation_id`);
--
-- Indexes for table `patient_consultation`
--
ALTER TABLE `patient_consultation`
ADD PRIMARY KEY (`consultation_id`),
ADD KEY `FKdsbv641ay7m8rygo1y5hd0cy` (`emp_id`);
--
-- Indexes for table `patient_daily_body_measurement`
--
ALTER TABLE `patient_daily_body_measurement`
ADD PRIMARY KEY (`patient_daily_body_measurement_id`),
ADD KEY `FK6oh9it546s8u6xmt0edrl6yd6` (`body_measurement_id`),
ADD KEY `FKmwfq49koxxldnu25dseoof775` (`emp_id`);
--
-- Indexes for table `patient_daily_diet`
--
ALTER TABLE `patient_daily_diet`
ADD PRIMARY KEY (`patient_daily_diet_id`),
ADD KEY `FKo1dhr7ckpifduvpcinpevfyby` (`food_id`),
ADD KEY `FKmyh9b47h5gt9xyvxdnkeskeyj` (`emp_id`);
--
-- Indexes for table `patient_daily_diet_nutrient`
--
ALTER TABLE `patient_daily_diet_nutrient`
ADD PRIMARY KEY (`id`),
ADD KEY `FK8v361eeqvekdcpt1tdcpp539q` (`patient_daily_diet_id`);
--
-- Indexes for table `patient_daily_exercise`
--
ALTER TABLE `patient_daily_exercise`
ADD PRIMARY KEY (`patient_daily_exercise_id`),
ADD KEY `FKrkohktcdpxoea3ijx9rvbt69g` (`exercise_id`),
ADD KEY `FKbjul4hst4gdaf64fyeu2r545v` (`emp_id`);
--
-- Indexes for table `patient_diet_plan`
--
ALTER TABLE `patient_diet_plan`
ADD PRIMARY KEY (`patient_diet_plan_id`),
ADD KEY `FKk4ojyq2bpsork7mcot784po9e` (`consultation_id`),
ADD KEY `FKsylff3rqvqkvw9ox4jjse740i` (`nutrient_id`);
--
-- Indexes for table `patient_exercise_plan`
--
ALTER TABLE `patient_exercise_plan`
ADD PRIMARY KEY (`patient_exercise_plan_id`),
ADD KEY `FK72sexh1ehtm2d1303ja1h0fc9` (`consultation_id`),
ADD KEY `FK1gj6lbvks7kp07ld7c3auesqx` (`exercise_id`);
--
-- Indexes for table `patient_master_new`
--
ALTER TABLE `patient_master_new`
ADD PRIMARY KEY (`patient_master_id`);
--
-- Indexes for table `plant_master`
--
ALTER TABLE `plant_master`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `prescription_master`
--
ALTER TABLE `prescription_master`
ADD PRIMARY KEY (`prescription_id`);
--
-- Indexes for table `questionaire_master`
--
ALTER TABLE `questionaire_master`
ADD PRIMARY KEY (`question_id`);
--
-- Indexes for table `referral_point`
--
ALTER TABLE `referral_point`
ADD PRIMARY KEY (`referral_point_id`),
ADD KEY `FK4iwtnu0v36xhhdifthdvkshtx` (`id`);
--
-- Indexes for table `referred_by_master`
--
ALTER TABLE `referred_by_master`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `refresh_token`
--
ALTER TABLE `refresh_token`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `UK_f95ixxe7pa48ryn1awmh2evt7` (`user_id`);
--
-- Indexes for table `report_master`
--
ALTER TABLE `report_master`
ADD PRIMARY KEY (`report_id`);
--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `role_menu_access`
--
ALTER TABLE `role_menu_access`
ADD PRIMARY KEY (`menu_id`,`role_id`),
ADD KEY `FK2whnycvr16xc1f10lesg6b1cc` (`role_id`);
--
-- Indexes for table `rule_equation`
--
ALTER TABLE `rule_equation`
ADD PRIMARY KEY (`rule_eq_id`),
ADD KEY `FKrvu3hmikeh8kpp1i5po0g8hjo` (`abnormality`),
ADD KEY `FKkawadf63dobw8l378ro35po8a` (`checkup_form_section_id`);
--
-- Indexes for table `salt_master`
--
ALTER TABLE `salt_master`
ADD PRIMARY KEY (`salt_id`);
--
-- Indexes for table `section`
--
ALTER TABLE `section`
ADD PRIMARY KEY (`section_id`),
ADD KEY `FKiyp2fc2oyyce2l0drctoe1sqj` (`bu_id`),
ADD KEY `FKdjkexvff7j1w5t83rniou6hbt` (`dept_id`);
--
-- Indexes for table `shift_details`
--
ALTER TABLE `shift_details`
ADD PRIMARY KEY (`shift_id`),
ADD KEY `FKqvtd39vmn53i3bi1h8oudxuie` (`ohc_type_id`),
ADD KEY `FK9gkxjbrq0ktjy3ix5bi9ruxt8` (`emp_id`);
--
-- Indexes for table `shift_status_details`
--
ALTER TABLE `shift_status_details`
ADD PRIMARY KEY (`shift_details_id`),
ADD KEY `FKg8m0tywfh7fn8y3prrfd7ofx4` (`ohc_location_id`),
ADD KEY `FKlp5om7nm5t0gdc3msmoyd686w` (`shift_id`);
--
-- Indexes for table `task_frequency_master`
--
ALTER TABLE `task_frequency_master`
ADD PRIMARY KEY (`frequency_id`);
--
-- Indexes for table `tbl_categories`
--
ALTER TABLE `tbl_categories`
ADD PRIMARY KEY (`cat_id`);
--
-- Indexes for table `tbl_items`
--
ALTER TABLE `tbl_items`
ADD PRIMARY KEY (`item_id`),
ADD UNIQUE KEY `UK_slm1wtxf3u6vv6de0c07kw06b` (`item_code`),
ADD KEY `FKhpjlsxllpq66s2gqivk7j2elr` (`cat`),
ADD KEY `FKkcd90qd0scr389d2ohp7hlj07` (`item_form_id`),
ADD KEY `FKojbk6f3t4yy1d9wcb05fiq16a` (`medicine_usage_cat_id`),
ADD KEY `FKg5ari94i6ewfq1lbke0ts9e8x` (`ohc_type_id`),
ADD KEY `FKe223koyyv40i1d3ycxofj8yfb` (`unit_id`);
--
-- Indexes for table `training_master`
--
ALTER TABLE `training_master`
ADD PRIMARY KEY (`training_master_id`),
ADD KEY `FKmmrw2lopcfc2p95o5i74i5oue` (`key_health_parameter`),
ADD KEY `FKlsx8gi64avu7kt6e64ejxecec` (`mode_of_training`);
--
-- Indexes for table `training_mode`
--
ALTER TABLE `training_mode`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `unit_master`
--
ALTER TABLE `unit_master`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `UK_r43af9ap4edm43mmtq01oddj6` (`username`);
--
-- Indexes for table `users_ohcs`
--
ALTER TABLE `users_ohcs`
ADD PRIMARY KEY (`user_id`,`ohc_id`),
ADD KEY `FKsf5u71qtpouakvib8mf7stpin` (`ohc_id`);
--
-- Indexes for table `users_roles`
--
ALTER TABLE `users_roles`
ADD PRIMARY KEY (`user_id`,`role_id`),
ADD KEY `FKj6m8fwv7oqv74fcehir1a9ffy` (`role_id`);
--
-- Indexes for table `vaccine_master`
--
ALTER TABLE `vaccine_master`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `abnormality`
--
ALTER TABLE `abnormality`
MODIFY `abnormality_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `add_filter_master`
--
ALTER TABLE `add_filter_master`
MODIFY `filter_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `ailment`
--
ALTER TABLE `ailment`
MODIFY `ailment_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `ailment_system`
--
ALTER TABLE `ailment_system`
MODIFY `ailment_sys_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `ambulance_category`
--
ALTER TABLE `ambulance_category`
MODIFY `ambulance_category_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `ambulance_details_new`
--
ALTER TABLE `ambulance_details_new`
MODIFY `ambulance_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `appoinment_slots`
--
ALTER TABLE `appoinment_slots`
MODIFY `slot_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `bio_medical_waste`
--
ALTER TABLE `bio_medical_waste`
MODIFY `waste_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `bio_medical_waste_new`
--
ALTER TABLE `bio_medical_waste_new`
MODIFY `waste_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `body_measurement_master`
--
ALTER TABLE `body_measurement_master`
MODIFY `body_measurement_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `business_reports_filter_master`
--
ALTER TABLE `business_reports_filter_master`
MODIFY `business_reports_filter_master_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `bussiness_unit`
--
ALTER TABLE `bussiness_unit`
MODIFY `bu_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `calibration_item_tbl`
--
ALTER TABLE `calibration_item_tbl`
MODIFY `calibration_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `canteen_master`
--
ALTER TABLE `canteen_master`
MODIFY `canteen_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `checkup_form`
--
ALTER TABLE `checkup_form`
MODIFY `checkup_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `checkup_form_key_value`
--
ALTER TABLE `checkup_form_key_value`
MODIFY `checkup_form_key_value_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `checkup_form_section`
--
ALTER TABLE `checkup_form_section`
MODIFY `section_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `checkup_parameter`
--
ALTER TABLE `checkup_parameter`
MODIFY `checkup_parameter_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `checkup_parameter_unit_master`
--
ALTER TABLE `checkup_parameter_unit_master`
MODIFY `unit_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `checkup_parameter_value`
--
ALTER TABLE `checkup_parameter_value`
MODIFY `parameter_value_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `checkup_type`
--
ALTER TABLE `checkup_type`
MODIFY `checkup_type_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `citys`
--
ALTER TABLE `citys`
MODIFY `city_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `company_profile`
--
ALTER TABLE `company_profile`
MODIFY `company_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `complaints`
--
ALTER TABLE `complaints`
MODIFY `complaint_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `config`
--
ALTER TABLE `config`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT for table `covid_wah_questions`
--
ALTER TABLE `covid_wah_questions`
MODIFY `question_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `department`
--
ALTER TABLE `department`
MODIFY `dept_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `designation`
--
ALTER TABLE `designation`
MODIFY `designation_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `device_mapping_master`
--
ALTER TABLE `device_mapping_master`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `device_master`
--
ALTER TABLE `device_master`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `device_parameter`
--
ALTER TABLE `device_parameter`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `device_parameter_map`
--
ALTER TABLE `device_parameter_map`
MODIFY `device_parameter_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `diagnosis_chronic_mapping`
--
ALTER TABLE `diagnosis_chronic_mapping`
MODIFY `diagnosis_chronic_mapping_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `dignosys_wise_bodysystem`
--
ALTER TABLE `dignosys_wise_bodysystem`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `disposal_agency`
--
ALTER TABLE `disposal_agency`
MODIFY `agency_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `doctors_master`
--
ALTER TABLE `doctors_master`
MODIFY `doctor_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `dosage_category`
--
ALTER TABLE `dosage_category`
MODIFY `dosage_category_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `duty_master`
--
ALTER TABLE `duty_master`
MODIFY `duty_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `employee_appointment`
--
ALTER TABLE `employee_appointment`
MODIFY `appointment_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `employer_contractor`
--
ALTER TABLE `employer_contractor`
MODIFY `employer_contractor_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `emp_cadre`
--
ALTER TABLE `emp_cadre`
MODIFY `emp_cadre_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `exercise`
--
ALTER TABLE `exercise`
MODIFY `exe_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `exercise_master`
--
ALTER TABLE `exercise_master`
MODIFY `exercise_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
--
-- AUTO_INCREMENT for table `first_aid_box`
--
ALTER TABLE `first_aid_box`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `food_master`
--
ALTER TABLE `food_master`
MODIFY `food_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `food_nutrient_mapping_values`
--
ALTER TABLE `food_nutrient_mapping_values`
MODIFY `food_nutrient_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `grade_master`
--
ALTER TABLE `grade_master`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `group_items`
--
ALTER TABLE `group_items`
MODIFY `group_item_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `habits`
--
ALTER TABLE `habits`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `health_advice`
--
ALTER TABLE `health_advice`
MODIFY `health_advice_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `health_risk`
--
ALTER TABLE `health_risk`
MODIFY `health_risk_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `injury_class`
--
ALTER TABLE `injury_class`
MODIFY `inj_class_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `injury_part`
--
ALTER TABLE `injury_part`
MODIFY `inj_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `injury_type`
--
ALTER TABLE `injury_type`
MODIFY `injury_type_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `interpretation_detail`
--
ALTER TABLE `interpretation_detail`
MODIFY `interpretation_detail_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `interpretation_master`
--
ALTER TABLE `interpretation_master`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `job_profile`
--
ALTER TABLE `job_profile`
MODIFY `job_profile_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `key_health_reportable_parameter_master`
--
ALTER TABLE `key_health_reportable_parameter_master`
MODIFY `key_param_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `medicine_form`
--
ALTER TABLE `medicine_form`
MODIFY `form_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `medicine_frequency`
--
ALTER TABLE `medicine_frequency`
MODIFY `frequency_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `medicine_timings`
--
ALTER TABLE `medicine_timings`
MODIFY `timing_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `medicine_usage_cat`
--
ALTER TABLE `medicine_usage_cat`
MODIFY `medicine_usage_cat_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `menu_master`
--
ALTER TABLE `menu_master`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=83;
--
-- AUTO_INCREMENT for table `nutrient_master`
--
ALTER TABLE `nutrient_master`
MODIFY `nutrient_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `ohc_type`
--
ALTER TABLE `ohc_type`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `patient_body_measurement_plan`
--
ALTER TABLE `patient_body_measurement_plan`
MODIFY `patient_measurement_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;
--
-- AUTO_INCREMENT for table `patient_consultation`
--
ALTER TABLE `patient_consultation`
MODIFY `consultation_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `patient_daily_body_measurement`
--
ALTER TABLE `patient_daily_body_measurement`
MODIFY `patient_daily_body_measurement_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;
--
-- AUTO_INCREMENT for table `patient_daily_diet`
--
ALTER TABLE `patient_daily_diet`
MODIFY `patient_daily_diet_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;
--
-- AUTO_INCREMENT for table `patient_daily_diet_nutrient`
--
ALTER TABLE `patient_daily_diet_nutrient`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=141;
--
-- AUTO_INCREMENT for table `patient_daily_exercise`
--
ALTER TABLE `patient_daily_exercise`
MODIFY `patient_daily_exercise_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;
--
-- AUTO_INCREMENT for table `patient_diet_plan`
--
ALTER TABLE `patient_diet_plan`
MODIFY `patient_diet_plan_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;
--
-- AUTO_INCREMENT for table `patient_exercise_plan`
--
ALTER TABLE `patient_exercise_plan`
MODIFY `patient_exercise_plan_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;
--
-- AUTO_INCREMENT for table `patient_master_new`
--
ALTER TABLE `patient_master_new`
MODIFY `patient_master_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `plant_master`
--
ALTER TABLE `plant_master`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `prescription_master`
--
ALTER TABLE `prescription_master`
MODIFY `prescription_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `questionaire_master`
--
ALTER TABLE `questionaire_master`
MODIFY `question_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `referral_point`
--
ALTER TABLE `referral_point`
MODIFY `referral_point_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `referred_by_master`
--
ALTER TABLE `referred_by_master`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `refresh_token`
--
ALTER TABLE `refresh_token`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `report_master`
--
ALTER TABLE `report_master`
MODIFY `report_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `rule_equation`
--
ALTER TABLE `rule_equation`
MODIFY `rule_eq_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `salt_master`
--
ALTER TABLE `salt_master`
MODIFY `salt_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `section`
--
ALTER TABLE `section`
MODIFY `section_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `shift_details`
--
ALTER TABLE `shift_details`
MODIFY `shift_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `shift_status_details`
--
ALTER TABLE `shift_status_details`
MODIFY `shift_details_id` bigint(20) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `task_frequency_master`
--
ALTER TABLE `task_frequency_master`
MODIFY `frequency_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `tbl_categories`
--
ALTER TABLE `tbl_categories`
MODIFY `cat_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `tbl_items`
--
ALTER TABLE `tbl_items`
MODIFY `item_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT for table `training_master`
--
ALTER TABLE `training_master`
MODIFY `training_master_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `training_mode`
--
ALTER TABLE `training_mode`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `unit_master`
--
ALTER TABLE `unit_master`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `vaccine_master`
--
ALTER TABLE `vaccine_master`
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- Constraints for dumped tables
--
--
-- Constraints for table `ambulance_details_new`
--
ALTER TABLE `ambulance_details_new`
ADD CONSTRAINT `FK8qwvunayubqjji9kovbfyo1nh` FOREIGN KEY (`ohc_type_id`) REFERENCES `ohc_type` (`id`),
ADD CONSTRAINT `FKim5vilv94d92dx44cqeynoth0` FOREIGN KEY (`ambulance_category_id`) REFERENCES `ambulance_category` (`ambulance_category_id`);
--
-- Constraints for table `bio_medical_waste`
--
ALTER TABLE `bio_medical_waste`
ADD CONSTRAINT `FK4domgnwxomvlgf4ylrekrmri2` FOREIGN KEY (`dis_agncy`) REFERENCES `disposal_agency` (`agency_id`),
ADD CONSTRAINT `FKfyciy82xlvn5hascw1jc45jw4` FOREIGN KEY (`ohc_type_id`) REFERENCES `ohc_type` (`id`);
--
-- Constraints for table `bio_medical_waste_new`
--
ALTER TABLE `bio_medical_waste_new`
ADD CONSTRAINT `FK4qixku6lvoejek68vavg7bp3r` FOREIGN KEY (`ohc_type_id`) REFERENCES `ohc_type` (`id`);
--
-- Constraints for table `body_measurement_master`
--
ALTER TABLE `body_measurement_master`
ADD CONSTRAINT `FK3aoum26i1d58lghpl76latdk` FOREIGN KEY (`unit_id`) REFERENCES `unit_master` (`id`);
--
-- Constraints for table `business_reports_filter_master`
--
ALTER TABLE `business_reports_filter_master`
ADD CONSTRAINT `FK1bgtpudaccukq8215mwkwyg95` FOREIGN KEY (`filter_id`) REFERENCES `add_filter_master` (`filter_id`),
ADD CONSTRAINT `FKplxcdcy3x46jwguiubqp84kwb` FOREIGN KEY (`report_id`) REFERENCES `report_master` (`report_id`);
--
-- Constraints for table `calibration_item_tbl`
--
ALTER TABLE `calibration_item_tbl`
ADD CONSTRAINT `FKai28tq65hg1ld0wlrrc5nx4bn` FOREIGN KEY (`cat_id`) REFERENCES `tbl_categories` (`cat_id`);
--
-- Constraints for table `checkup_form`
--
ALTER TABLE `checkup_form`
ADD CONSTRAINT `FKi55idrbqxmcbdqvj0ue31da8l` FOREIGN KEY (`emp_id`) REFERENCES `patient_master_new` (`patient_master_id`);
--
-- Constraints for table `checkup_form_key_value`
--
ALTER TABLE `checkup_form_key_value`
ADD CONSTRAINT `FK3n6gagexumtvty2yxpovsdu6j` FOREIGN KEY (`checkup_form_id`) REFERENCES `checkup_form` (`checkup_id`);
--
-- Constraints for table `checkup_form_section`
--
ALTER TABLE `checkup_form_section`
ADD CONSTRAINT `FKquni2722kfpde6it4k86pnm7q` FOREIGN KEY (`interpretation`) REFERENCES `interpretation_master` (`id`);
--
-- Constraints for table `department`
--
ALTER TABLE `department`
ADD CONSTRAINT `FK48gsgjulg5j1g2g69g23l150n` FOREIGN KEY (`bu_id`) REFERENCES `bussiness_unit` (`bu_id`);
--
-- Constraints for table `device_mapping_master`
--
ALTER TABLE `device_mapping_master`
ADD CONSTRAINT `FK4rjd1gn6tl4eectaevsx2v8ah` FOREIGN KEY (`device_id`) REFERENCES `device_master` (`id`);
--
-- Constraints for table `device_parameter`
--
ALTER TABLE `device_parameter`
ADD CONSTRAINT `FKob9f5gd8dxeiyym5kjx8477yi` FOREIGN KEY (`device_name`) REFERENCES `device_master` (`id`);
--
-- Constraints for table `device_parameter_map`
--
ALTER TABLE `device_parameter_map`
ADD CONSTRAINT `FKhqeo2nnho0fmqi42kptmdvysb` FOREIGN KEY (`device_name`) REFERENCES `device_master` (`id`);
--
-- Constraints for table `diagnosis_chronic_mapping`
--
ALTER TABLE `diagnosis_chronic_mapping`
ADD CONSTRAINT `FK1kaqyx6n1vlxyr8wr467o0jw2` FOREIGN KEY (`chronic_id`) REFERENCES `abnormality` (`abnormality_id`),
ADD CONSTRAINT `FKoqmy9m9hivl0no70h24euqf3d` FOREIGN KEY (`ailment_id`) REFERENCES `ailment` (`ailment_id`);
--
-- Constraints for table `dignosys_wise_bodysystem`
--
ALTER TABLE `dignosys_wise_bodysystem`
ADD CONSTRAINT `FK60msl8bufitcoidqsa0lmvrk9` FOREIGN KEY (`ailment_id`) REFERENCES `ailment` (`ailment_id`),
ADD CONSTRAINT `FKdsx5wp5q1nfl8o2mq03jdoyt1` FOREIGN KEY (`ailment_sys_id`) REFERENCES `ailment_system` (`ailment_sys_id`);
--
-- Constraints for table `employee_appointment`
--
ALTER TABLE `employee_appointment`
ADD CONSTRAINT `FK1hujjcm9n5ple50c195iu67gb` FOREIGN KEY (`emp_id`) REFERENCES `patient_master_new` (`patient_master_id`);
--
-- Constraints for table `exercise`
--
ALTER TABLE `exercise`
ADD CONSTRAINT `FKnx2bev110jmo7448v07ge3ub7` FOREIGN KEY (`exercise_id`) REFERENCES `exercise_master` (`exercise_id`);
--
-- Constraints for table `exercise_master`
--
ALTER TABLE `exercise_master`
ADD CONSTRAINT `FKlf4tlrk7wwajksgto7h2cpjhh` FOREIGN KEY (`unit_id`) REFERENCES `unit_master` (`id`);
--
-- Constraints for table `food_master`
--
ALTER TABLE `food_master`
ADD CONSTRAINT `FKdf8rjfad7v3ptal4oiy48je1t` FOREIGN KEY (`unit_id`) REFERENCES `unit_master` (`id`);
--
-- Constraints for table `food_nutrient_mapping_values`
--
ALTER TABLE `food_nutrient_mapping_values`
ADD CONSTRAINT `FKfvnjpb4sv2oq863my4alqu9kd` FOREIGN KEY (`nutrient_id`) REFERENCES `nutrient_master` (`nutrient_id`),
ADD CONSTRAINT `FKgr13qxtk023pxiudy52au5n7d` FOREIGN KEY (`food_id`) REFERENCES `food_master` (`food_id`);
--
-- Constraints for table `group_items`
--
ALTER TABLE `group_items`
ADD CONSTRAINT `FKamrvolf1cdr1bsl10is1q43br` FOREIGN KEY (`item_id`) REFERENCES `tbl_items` (`item_id`),
ADD CONSTRAINT `FKfpxps556bajtbhnrlcjt6kjdb` FOREIGN KEY (`group_id`) REFERENCES `tbl_items` (`item_id`);
--
-- Constraints for table `interpretation_detail`
--
ALTER TABLE `interpretation_detail`
ADD CONSTRAINT `FK6mukg1qxixnf2lghnkqobx2qk` FOREIGN KEY (`interpretation_id`) REFERENCES `interpretation_master` (`id`);
--
-- Constraints for table `menu_master`
--
ALTER TABLE `menu_master`
ADD CONSTRAINT `FK2q0ww6hwx961rlgmfh24yo72k` FOREIGN KEY (`parent_menu_id`) REFERENCES `menu_master` (`id`);
--
-- Constraints for table `nutrient_master`
--
ALTER TABLE `nutrient_master`
ADD CONSTRAINT `FKplnyxivaedy5kk5rg1ec040c6` FOREIGN KEY (`unit_id`) REFERENCES `unit_master` (`id`);
--
-- Constraints for table `patient_body_measurement_plan`
--
ALTER TABLE `patient_body_measurement_plan`
ADD CONSTRAINT `FK1mm5t1ujhbas2clwnia09f5yb` FOREIGN KEY (`consultation_id`) REFERENCES `patient_consultation` (`consultation_id`),
ADD CONSTRAINT `FKcy8tm13rt6gqvmndrhaxfjkl` FOREIGN KEY (`body_measurement_id`) REFERENCES `body_measurement_master` (`body_measurement_id`);
--
-- Constraints for table `patient_consultation`
--
ALTER TABLE `patient_consultation`
ADD CONSTRAINT `FKdsbv641ay7m8rygo1y5hd0cy` FOREIGN KEY (`emp_id`) REFERENCES `patient_master_new` (`patient_master_id`);
--
-- Constraints for table `patient_daily_body_measurement`
--
ALTER TABLE `patient_daily_body_measurement`
ADD CONSTRAINT `FK6oh9it546s8u6xmt0edrl6yd6` FOREIGN KEY (`body_measurement_id`) REFERENCES `body_measurement_master` (`body_measurement_id`),
ADD CONSTRAINT `FKmwfq49koxxldnu25dseoof775` FOREIGN KEY (`emp_id`) REFERENCES `patient_master_new` (`patient_master_id`);
--
-- Constraints for table `patient_daily_diet`
--
ALTER TABLE `patient_daily_diet`
ADD CONSTRAINT `FKmyh9b47h5gt9xyvxdnkeskeyj` FOREIGN KEY (`emp_id`) REFERENCES `patient_master_new` (`patient_master_id`),
ADD CONSTRAINT `FKo1dhr7ckpifduvpcinpevfyby` FOREIGN KEY (`food_id`) REFERENCES `food_master` (`food_id`);
--
-- Constraints for table `patient_daily_diet_nutrient`
--
ALTER TABLE `patient_daily_diet_nutrient`
ADD CONSTRAINT `FK8v361eeqvekdcpt1tdcpp539q` FOREIGN KEY (`patient_daily_diet_id`) REFERENCES `patient_daily_diet` (`patient_daily_diet_id`);
--
-- Constraints for table `patient_daily_exercise`
--
ALTER TABLE `patient_daily_exercise`
ADD CONSTRAINT `FKbjul4hst4gdaf64fyeu2r545v` FOREIGN KEY (`emp_id`) REFERENCES `patient_master_new` (`patient_master_id`),
ADD CONSTRAINT `FKrkohktcdpxoea3ijx9rvbt69g` FOREIGN KEY (`exercise_id`) REFERENCES `exercise_master` (`exercise_id`);
--
-- Constraints for table `patient_diet_plan`
--
ALTER TABLE `patient_diet_plan`
ADD CONSTRAINT `FKk4ojyq2bpsork7mcot784po9e` FOREIGN KEY (`consultation_id`) REFERENCES `patient_consultation` (`consultation_id`),
ADD CONSTRAINT `FKsylff3rqvqkvw9ox4jjse740i` FOREIGN KEY (`nutrient_id`) REFERENCES `nutrient_master` (`nutrient_id`);
--
-- Constraints for table `patient_exercise_plan`
--
ALTER TABLE `patient_exercise_plan`
ADD CONSTRAINT `FK1gj6lbvks7kp07ld7c3auesqx` FOREIGN KEY (`exercise_id`) REFERENCES `exercise_master` (`exercise_id`),
ADD CONSTRAINT `FK72sexh1ehtm2d1303ja1h0fc9` FOREIGN KEY (`consultation_id`) REFERENCES `patient_consultation` (`consultation_id`);
--
-- Constraints for table `referral_point`
--
ALTER TABLE `referral_point`
ADD CONSTRAINT `FK4iwtnu0v36xhhdifthdvkshtx` FOREIGN KEY (`id`) REFERENCES `ohc_type` (`id`);
--
-- Constraints for table `refresh_token`
--
ALTER TABLE `refresh_token`
ADD CONSTRAINT `FKjtx87i0jvq2svedphegvdwcuy` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);
--
-- Constraints for table `role_menu_access`
--
ALTER TABLE `role_menu_access`
ADD CONSTRAINT `FK2whnycvr16xc1f10lesg6b1cc` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`),
ADD CONSTRAINT `FKo46b5od3j5yngke9v5cwgde88` FOREIGN KEY (`menu_id`) REFERENCES `menu_master` (`id`);
--
-- Constraints for table `rule_equation`
--
ALTER TABLE `rule_equation`
ADD CONSTRAINT `FKkawadf63dobw8l378ro35po8a` FOREIGN KEY (`checkup_form_section_id`) REFERENCES `checkup_form_section` (`section_id`),
ADD CONSTRAINT `FKrvu3hmikeh8kpp1i5po0g8hjo` FOREIGN KEY (`abnormality`) REFERENCES `abnormality` (`abnormality_id`);
--
-- Constraints for table `section`
--
ALTER TABLE `section`
ADD CONSTRAINT `FKdjkexvff7j1w5t83rniou6hbt` FOREIGN KEY (`dept_id`) REFERENCES `department` (`dept_id`),
ADD CONSTRAINT `FKiyp2fc2oyyce2l0drctoe1sqj` FOREIGN KEY (`bu_id`) REFERENCES `bussiness_unit` (`bu_id`);
--
-- Constraints for table `shift_details`
--
ALTER TABLE `shift_details`
ADD CONSTRAINT `FK9gkxjbrq0ktjy3ix5bi9ruxt8` FOREIGN KEY (`emp_id`) REFERENCES `patient_master_new` (`patient_master_id`),
ADD CONSTRAINT `FKqvtd39vmn53i3bi1h8oudxuie` FOREIGN KEY (`ohc_type_id`) REFERENCES `ohc_type` (`id`);
--
-- Constraints for table `shift_status_details`
--
ALTER TABLE `shift_status_details`
ADD CONSTRAINT `FKg8m0tywfh7fn8y3prrfd7ofx4` FOREIGN KEY (`ohc_location_id`) REFERENCES `ohc_type` (`id`),
ADD CONSTRAINT `FKlp5om7nm5t0gdc3msmoyd686w` FOREIGN KEY (`shift_id`) REFERENCES `shift_details` (`shift_id`);
--
-- Constraints for table `tbl_items`
--
ALTER TABLE `tbl_items`
ADD CONSTRAINT `FKe223koyyv40i1d3ycxofj8yfb` FOREIGN KEY (`unit_id`) REFERENCES `unit_master` (`id`),
ADD CONSTRAINT `FKg5ari94i6ewfq1lbke0ts9e8x` FOREIGN KEY (`ohc_type_id`) REFERENCES `ohc_type` (`id`),
ADD CONSTRAINT `FKhpjlsxllpq66s2gqivk7j2elr` FOREIGN KEY (`cat`) REFERENCES `tbl_categories` (`cat_id`),
ADD CONSTRAINT `FKkcd90qd0scr389d2ohp7hlj07` FOREIGN KEY (`item_form_id`) REFERENCES `medicine_form` (`form_id`),
ADD CONSTRAINT `FKojbk6f3t4yy1d9wcb05fiq16a` FOREIGN KEY (`medicine_usage_cat_id`) REFERENCES `medicine_usage_cat` (`medicine_usage_cat_id`);
--
-- Constraints for table `training_master`
--
ALTER TABLE `training_master`
ADD CONSTRAINT `FKlsx8gi64avu7kt6e64ejxecec` FOREIGN KEY (`mode_of_training`) REFERENCES `training_mode` (`id`),
ADD CONSTRAINT `FKmmrw2lopcfc2p95o5i74i5oue` FOREIGN KEY (`key_health_parameter`) REFERENCES `key_health_reportable_parameter_master` (`key_param_id`);
--
-- Constraints for table `users_ohcs`
--
ALTER TABLE `users_ohcs`
ADD CONSTRAINT `FKi8psypl4fa547hr7bnswaayix` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FKsf5u71qtpouakvib8mf7stpin` FOREIGN KEY (`ohc_id`) REFERENCES `ohc_type` (`id`);
--
-- Constraints for table `users_roles`
--
ALTER TABLE `users_roles`
ADD CONSTRAINT `FK2o0jvgh89lemvvo17cbqvdxaa` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
ADD CONSTRAINT `FKj6m8fwv7oqv74fcehir1a9ffy` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`);
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 */;
Reference in New Issue View Git Blame Copy Permalink