-- phpMyAdmin SQL Dump
-- version 5.2.3
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Sep 27, 2026 at 06:57 PM
-- Server version: 8.0.46
-- PHP Version: 8.4.25

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET FOREIGN_KEY_CHECKS = 0;
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: `arogyada_Shayya_setu`
--

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

--
-- Table structure for table `abdm_consents`
--

CREATE TABLE `abdm_consents` (
  `id` bigint UNSIGNED NOT NULL,
  `consent_request_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `artefact_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `abha_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `hospital_id` int NOT NULL,
  `patient_id` int DEFAULT NULL,
  `admission_id` int DEFAULT NULL,
  `purpose_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'CARETREAT',
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'REQUESTED',
  `permission_date_from` datetime DEFAULT NULL,
  `permission_date_to` datetime DEFAULT NULL,
  `expiry_at` datetime DEFAULT NULL,
  `granted_at` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `admissions`
--

CREATE TABLE `admissions` (
  `id` bigint UNSIGNED NOT NULL,
  `hospital_id` int NOT NULL,
  `patient_id` int NOT NULL,
  `department_id` int NOT NULL,
  `current_bed_id` int DEFAULT NULL,
  `triage_level` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'YELLOW',
  `admitting_doctor_id` int NOT NULL,
  `consultant_approved` tinyint(1) NOT NULL DEFAULT '0',
  `consultant_approved_by` int DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ADMITTED',
  `discharge_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `discharge_summary` text COLLATE utf8mb4_unicode_ci,
  `discharge_approved_by` int DEFAULT NULL,
  `admitted_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `discharged_at` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admissions`
--

INSERT INTO `admissions` (`id`, `hospital_id`, `patient_id`, `department_id`, `current_bed_id`, `triage_level`, `admitting_doctor_id`, `consultant_approved`, `consultant_approved_by`, `status`, `discharge_type`, `discharge_summary`, `discharge_approved_by`, `admitted_at`, `discharged_at`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 2, 1, 8, 81, 'YELLOW', 21, 0, NULL, 'ADMITTED', NULL, NULL, NULL, '2026-09-24 17:20:49', NULL, '2026-09-26 17:20:49', '2026-09-26 17:20:49', NULL),
(2, 2, 3, 8, 119, 'RED', 21, 1, 19, 'ADMITTED', NULL, NULL, NULL, '2026-09-26 11:20:49', NULL, '2026-09-26 17:20:49', '2026-09-26 17:20:49', NULL),
(3, 2, 5, 8, NULL, 'GREEN', 21, 0, NULL, 'DISCHARGED', 'STANDARD', 'Patient admitted with Community Acquired Pneumonia. Successfully treated with IV ceftriaxone, azithromycin, and oxygen therapy.\nVitals at discharge: BP 124/82 mmHg, Pulse 76/min, SpO2 99% room air.\nAdvised complete rest for 5 days, oral cefixime 200mg BD for 5 days. Follow up in Chest OPD after 1 week.', NULL, '2026-09-21 17:20:49', '2026-09-26 15:20:49', '2026-09-26 17:20:49', '2026-09-26 17:20:49', NULL);

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

--
-- Table structure for table `ambulance_dispatches`
--

CREATE TABLE `ambulance_dispatches` (
  `id` bigint UNSIGNED NOT NULL,
  `dispatch_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `service_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '108_ALS',
  `patient_category_id` int NOT NULL,
  `caller_district_id` int NOT NULL,
  `source_lat` decimal(10,2) NOT NULL,
  `source_lng` decimal(10,2) NOT NULL,
  `destination_hospital_id` int NOT NULL,
  `held_bed_id` int DEFAULT NULL,
  `eta_minutes` int NOT NULL DEFAULT '20',
  `eta_at` datetime DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'DISPATCHED',
  `referral_ticket_id` int DEFAULT NULL,
  `paramedic_notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `audit_logs`
--

CREATE TABLE `audit_logs` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` int DEFAULT NULL,
  `action` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `object_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `object_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `details` text COLLATE utf8mb4_unicode_ci,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `audit_logs`
--

INSERT INTO `audit_logs` (`id`, `user_id`, `action`, `object_type`, `object_id`, `ip_address`, `user_agent`, `details`, `created_at`) VALUES
(1, NULL, 'DEMO_ENVIRONMENT_RESET', 'SYSTEM_DEMO', 'RESET-20260926172049', '127.0.0.1', 'Symfony', '{\"duration_seconds\":7.37,\"hospitals\":10}', '2026-09-26 17:20:49'),
(2, 23, 'USER_LOGIN', 'USER', '23', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) HeadlessChrome/153.0.8010.12 Safari/537.36', '{\"role\":\"BED_MANAGER\",\"hospital_id\":2,\"scope\":\"HOSPITAL\"}', '2026-09-26 17:23:41'),
(3, 19, 'USER_LOGIN', 'USER', '19', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) HeadlessChrome/153.0.8010.12 Safari/537.36', '{\"role\":\"MEDICAL_SUPERINTENDENT\",\"hospital_id\":2,\"scope\":\"HOSPITAL\"}', '2026-09-26 17:24:03'),
(4, 23, 'USER_LOGIN', 'USER', '23', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) HeadlessChrome/153.0.8010.12 Safari/537.36', '{\"role\":\"BED_MANAGER\",\"hospital_id\":2,\"scope\":\"HOSPITAL\"}', '2026-09-26 17:24:11'),
(5, 19, 'USER_LOGIN', 'USER', '19', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) HeadlessChrome/153.0.8010.12 Safari/537.36', '{\"role\":\"MEDICAL_SUPERINTENDENT\",\"hospital_id\":2,\"scope\":\"HOSPITAL\"}', '2026-09-26 17:24:31'),
(6, 16, 'USER_LOGIN', 'USER', '16', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) HeadlessChrome/153.0.8010.12 Safari/537.36', '{\"role\":\"DISTRICT_NODAL_OFFICER\",\"hospital_id\":null,\"scope\":\"DISTRICT\"}', '2026-09-26 17:24:40'),
(7, 16, 'USER_LOGIN', 'USER', '16', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) HeadlessChrome/153.0.8010.12 Safari/537.36', '{\"role\":\"DISTRICT_NODAL_OFFICER\",\"hospital_id\":null,\"scope\":\"DISTRICT\"}', '2026-09-26 17:25:07'),
(8, 14, 'USER_LOGIN', 'USER', '14', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) HeadlessChrome/153.0.8010.12 Safari/537.36', '{\"role\":\"STATE_ADMIN\",\"hospital_id\":null,\"scope\":\"STATE\"}', '2026-09-26 17:25:31'),
(9, 14, 'USER_LOGIN', 'USER', '14', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) HeadlessChrome/153.0.8010.12 Safari/537.36', '{\"role\":\"STATE_ADMIN\",\"hospital_id\":null,\"scope\":\"STATE\"}', '2026-09-26 17:25:46'),
(10, 23, 'USER_LOGIN', 'USER', '23', '127.0.0.1', 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_0 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.0 Mobile/15E148 Safari/604.1', '{\"role\":\"BED_MANAGER\",\"hospital_id\":2,\"scope\":\"HOSPITAL\"}', '2026-09-26 17:26:03'),
(11, 22, 'USER_LOGIN', 'USER', '22', '127.0.0.1', 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_0 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.0 Mobile/15E148 Safari/604.1', '{\"role\":\"STAFF_NURSE\",\"hospital_id\":2,\"scope\":\"WARD\"}', '2026-09-26 17:26:17'),
(12, 16, 'USER_LOGIN', 'USER', '16', '127.0.0.1', 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_0 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.0 Mobile/15E148 Safari/604.1', '{\"role\":\"DISTRICT_NODAL_OFFICER\",\"hospital_id\":null,\"scope\":\"DISTRICT\"}', '2026-09-26 17:26:21'),
(13, 23, 'USER_LOGIN', 'USER', '23', '127.0.0.1', 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_0 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.0 Mobile/15E148 Safari/604.1', '{\"role\":\"BED_MANAGER\",\"hospital_id\":2,\"scope\":\"HOSPITAL\"}', '2026-09-26 17:26:28'),
(14, 22, 'USER_LOGIN', 'USER', '22', '127.0.0.1', 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_0 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.0 Mobile/15E148 Safari/604.1', '{\"role\":\"STAFF_NURSE\",\"hospital_id\":2,\"scope\":\"WARD\"}', '2026-09-26 17:26:41'),
(15, 16, 'USER_LOGIN', 'USER', '16', '127.0.0.1', 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_0 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.0 Mobile/15E148 Safari/604.1', '{\"role\":\"DISTRICT_NODAL_OFFICER\",\"hospital_id\":null,\"scope\":\"DISTRICT\"}', '2026-09-26 17:26:45'),
(16, 23, 'USER_LOGIN', 'USER', '23', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) HeadlessChrome/153.0.8010.12 Safari/537.36', '{\"role\":\"BED_MANAGER\",\"hospital_id\":2,\"scope\":\"HOSPITAL\"}', '2026-09-27 01:44:15'),
(17, 19, 'USER_LOGIN', 'USER', '19', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) HeadlessChrome/153.0.8010.12 Safari/537.36', '{\"role\":\"MEDICAL_SUPERINTENDENT\",\"hospital_id\":2,\"scope\":\"HOSPITAL\"}', '2026-09-27 01:44:40'),
(18, 23, 'USER_LOGIN', 'USER', '23', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) HeadlessChrome/153.0.8010.12 Safari/537.36', '{\"role\":\"BED_MANAGER\",\"hospital_id\":2,\"scope\":\"HOSPITAL\"}', '2026-09-27 01:44:49'),
(19, 19, 'USER_LOGIN', 'USER', '19', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) HeadlessChrome/153.0.8010.12 Safari/537.36', '{\"role\":\"MEDICAL_SUPERINTENDENT\",\"hospital_id\":2,\"scope\":\"HOSPITAL\"}', '2026-09-27 01:45:09'),
(20, 16, 'USER_LOGIN', 'USER', '16', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) HeadlessChrome/153.0.8010.12 Safari/537.36', '{\"role\":\"DISTRICT_NODAL_OFFICER\",\"hospital_id\":null,\"scope\":\"DISTRICT\"}', '2026-09-27 01:45:17'),
(21, 16, 'USER_LOGIN', 'USER', '16', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) HeadlessChrome/153.0.8010.12 Safari/537.36', '{\"role\":\"DISTRICT_NODAL_OFFICER\",\"hospital_id\":null,\"scope\":\"DISTRICT\"}', '2026-09-27 01:45:44'),
(22, 14, 'USER_LOGIN', 'USER', '14', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) HeadlessChrome/153.0.8010.12 Safari/537.36', '{\"role\":\"STATE_ADMIN\",\"hospital_id\":null,\"scope\":\"STATE\"}', '2026-09-27 01:46:09'),
(23, 14, 'USER_LOGIN', 'USER', '14', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) HeadlessChrome/153.0.8010.12 Safari/537.36', '{\"role\":\"STATE_ADMIN\",\"hospital_id\":null,\"scope\":\"STATE\"}', '2026-09-27 01:46:25'),
(24, 23, 'USER_LOGIN', 'USER', '23', '127.0.0.1', 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_0 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.0 Mobile/15E148 Safari/604.1', '{\"role\":\"BED_MANAGER\",\"hospital_id\":2,\"scope\":\"HOSPITAL\"}', '2026-09-27 01:46:41'),
(25, 22, 'USER_LOGIN', 'USER', '22', '127.0.0.1', 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_0 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.0 Mobile/15E148 Safari/604.1', '{\"role\":\"STAFF_NURSE\",\"hospital_id\":2,\"scope\":\"WARD\"}', '2026-09-27 01:46:56'),
(26, 16, 'USER_LOGIN', 'USER', '16', '127.0.0.1', 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_0 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.0 Mobile/15E148 Safari/604.1', '{\"role\":\"DISTRICT_NODAL_OFFICER\",\"hospital_id\":null,\"scope\":\"DISTRICT\"}', '2026-09-27 01:46:59'),
(27, 23, 'USER_LOGIN', 'USER', '23', '127.0.0.1', 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_0 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.0 Mobile/15E148 Safari/604.1', '{\"role\":\"BED_MANAGER\",\"hospital_id\":2,\"scope\":\"HOSPITAL\"}', '2026-09-27 01:47:08'),
(28, 22, 'USER_LOGIN', 'USER', '22', '127.0.0.1', 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_0 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.0 Mobile/15E148 Safari/604.1', '{\"role\":\"STAFF_NURSE\",\"hospital_id\":2,\"scope\":\"WARD\"}', '2026-09-27 01:47:21'),
(29, 16, 'USER_LOGIN', 'USER', '16', '127.0.0.1', 'Mozilla/5.0 (iPhone; CPU iPhone OS 16_0 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.0 Mobile/15E148 Safari/604.1', '{\"role\":\"DISTRICT_NODAL_OFFICER\",\"hospital_id\":null,\"scope\":\"DISTRICT\"}', '2026-09-27 01:47:24'),
(30, 9, 'USER_LOGIN', 'USER', '9', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', '{\"role\":\"STAFF_NURSE\",\"hospital_id\":1,\"scope\":\"WARD\"}', '2026-09-27 05:01:08');

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

--
-- Table structure for table `beds`
--

CREATE TABLE `beds` (
  `id` int NOT NULL,
  `hospital_id` int NOT NULL,
  `ward_id` int NOT NULL,
  `category_id` int NOT NULL,
  `bed_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `room_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'AVAILABLE',
  `status_changed_at` datetime DEFAULT NULL,
  `is_surge` tinyint(1) NOT NULL DEFAULT '0',
  `notes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `beds`
--

INSERT INTO `beds` (`id`, `hospital_id`, `ward_id`, `category_id`, `bed_number`, `room_number`, `status`, `status_changed_at`, `is_surge`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 1, 1, 'MED-B01', 'R-1', 'AVAILABLE', '2026-09-26 15:16:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(2, 1, 1, 1, 'MED-B02', 'R-1', 'OCCUPIED', '2026-09-26 15:27:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(3, 1, 1, 1, 'MED-B03', 'R-1', 'CLEANING', '2026-09-26 14:43:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(4, 1, 1, 1, 'MED-B04', 'R-1', 'CLEANING', '2026-09-26 13:07:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(5, 1, 1, 1, 'MED-B05', 'R-2', 'OCCUPIED', '2026-09-26 14:21:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(6, 1, 1, 1, 'MED-B06', 'R-2', 'AVAILABLE', '2026-09-26 15:48:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(7, 1, 1, 1, 'MED-B07', 'R-2', 'OCCUPIED', '2026-09-26 15:22:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(8, 1, 1, 1, 'MED-B08', 'R-2', 'OCCUPIED', '2026-09-26 15:07:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(9, 1, 1, 1, 'MED-B09', 'R-3', 'OCCUPIED', '2026-09-26 15:27:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(10, 1, 1, 1, 'MED-B10', 'R-3', 'OCCUPIED', '2026-09-26 15:49:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(11, 1, 2, 1, 'MED-B01', 'R-1', 'AVAILABLE', '2026-09-26 16:59:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(12, 1, 2, 1, 'MED-B02', 'R-1', 'AVAILABLE', '2026-09-26 16:17:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(13, 1, 2, 1, 'MED-B03', 'R-1', 'RESERVED', '2026-09-26 13:11:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(14, 1, 2, 1, 'MED-B04', 'R-1', 'CLEANING', '2026-09-26 12:47:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(15, 1, 2, 1, 'MED-B05', 'R-2', 'AVAILABLE', '2026-09-26 14:16:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(16, 1, 2, 1, 'MED-B06', 'R-2', 'OCCUPIED', '2026-09-26 15:42:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(17, 1, 2, 1, 'MED-B07', 'R-2', 'OCCUPIED', '2026-09-26 16:16:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(18, 1, 2, 1, 'MED-B08', 'R-2', 'AVAILABLE', '2026-09-26 16:42:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(19, 1, 2, 1, 'MED-B09', 'R-3', 'RESERVED', '2026-09-26 13:44:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(20, 1, 2, 1, 'MED-B10', 'R-3', 'RESERVED', '2026-09-26 14:33:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(21, 1, 3, 1, 'SUR-B01', 'R-1', 'AVAILABLE', '2026-09-26 14:21:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(22, 1, 3, 1, 'SUR-B02', 'R-1', 'OCCUPIED', '2026-09-26 16:24:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(23, 1, 3, 1, 'SUR-B03', 'R-1', 'AVAILABLE', '2026-09-26 13:07:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(24, 1, 3, 1, 'SUR-B04', 'R-1', 'RESERVED', '2026-09-26 12:56:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(25, 1, 3, 1, 'SUR-B05', 'R-2', 'OCCUPIED', '2026-09-26 14:21:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(26, 1, 3, 1, 'SUR-B06', 'R-2', 'AVAILABLE', '2026-09-26 13:18:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(27, 1, 3, 1, 'SUR-B07', 'R-2', 'AVAILABLE', '2026-09-26 16:44:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(28, 1, 3, 1, 'SUR-B08', 'R-2', 'OCCUPIED', '2026-09-26 15:11:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(29, 1, 3, 1, 'SUR-B09', 'R-3', 'OCCUPIED', '2026-09-26 15:29:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(30, 1, 3, 1, 'SUR-B10', 'R-3', 'OCCUPIED', '2026-09-26 13:36:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(31, 1, 4, 1, 'SUR-B01', 'R-1', 'AVAILABLE', '2026-09-26 16:17:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(32, 1, 4, 1, 'SUR-B02', 'R-1', 'CLEANING', '2026-09-26 16:51:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(33, 1, 4, 1, 'SUR-B03', 'R-1', 'OCCUPIED', '2026-09-26 16:01:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(34, 1, 4, 1, 'SUR-B04', 'R-1', 'OCCUPIED', '2026-09-26 16:35:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(35, 1, 4, 1, 'SUR-B05', 'R-2', 'RESERVED', '2026-09-26 16:49:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(36, 1, 4, 1, 'SUR-B06', 'R-2', 'OCCUPIED', '2026-09-26 13:39:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(37, 1, 4, 1, 'SUR-B07', 'R-2', 'AVAILABLE', '2026-09-26 16:20:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(38, 1, 4, 1, 'SUR-B08', 'R-2', 'AVAILABLE', '2026-09-26 17:09:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(39, 1, 4, 1, 'SUR-B09', 'R-3', 'AVAILABLE', '2026-09-26 17:09:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(40, 1, 4, 1, 'SUR-B10', 'R-3', 'AVAILABLE', '2026-09-26 16:32:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(41, 1, 5, 3, 'EME-B01', 'R-1', 'AVAILABLE', '2026-09-26 12:22:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(42, 1, 5, 3, 'EME-B02', 'R-1', 'OCCUPIED', '2026-09-26 14:18:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(43, 1, 5, 3, 'EME-B03', 'R-1', 'CLEANING', '2026-09-26 13:46:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(44, 1, 5, 3, 'EME-B04', 'R-1', 'AVAILABLE', '2026-09-26 13:54:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(45, 1, 5, 3, 'EME-B05', 'R-2', 'AVAILABLE', '2026-09-26 16:16:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(46, 1, 5, 3, 'EME-B06', 'R-2', 'CLEANING', '2026-09-26 13:50:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(47, 1, 6, 2, 'EME-B01', 'R-1', 'AVAILABLE', '2026-09-26 17:04:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(48, 1, 6, 2, 'EME-B02', 'R-1', 'RESERVED', '2026-09-26 16:03:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(49, 1, 6, 2, 'EME-B03', 'R-1', 'OCCUPIED', '2026-09-26 16:11:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(50, 1, 6, 2, 'EME-B04', 'R-1', 'AVAILABLE', '2026-09-26 15:27:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(51, 1, 6, 2, 'EME-B05', 'R-2', 'CLEANING', '2026-09-26 16:29:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(52, 1, 6, 2, 'EME-B06', 'R-2', 'CLEANING', '2026-09-26 16:09:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(53, 1, 6, 2, 'EME-B07', 'R-2', 'OCCUPIED', '2026-09-26 14:56:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(54, 1, 6, 2, 'EME-B08', 'R-2', 'AVAILABLE', '2026-09-26 13:14:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(55, 1, 6, 2, 'EME-B09', 'R-3', 'CLEANING', '2026-09-26 14:00:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(56, 1, 6, 2, 'EME-B10', 'R-3', 'RESERVED', '2026-09-26 17:01:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(57, 1, 7, 5, 'CAR-B01', 'R-1', 'AVAILABLE', '2026-09-26 12:52:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(58, 1, 7, 5, 'CAR-B02', 'R-1', 'AVAILABLE', '2026-09-26 14:24:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(59, 1, 7, 5, 'CAR-B03', 'R-1', 'OCCUPIED', '2026-09-26 13:02:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(60, 1, 7, 5, 'CAR-B04', 'R-1', 'CLEANING', '2026-09-26 15:42:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(61, 1, 7, 5, 'CAR-B05', 'R-2', 'OCCUPIED', '2026-09-26 15:00:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(62, 1, 7, 5, 'CAR-B06', 'R-2', 'RESERVED', '2026-09-26 14:34:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(63, 1, 8, 4, 'PAE-B01', 'R-1', 'AVAILABLE', '2026-09-26 14:31:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(64, 1, 8, 4, 'PAE-B02', 'R-1', 'OCCUPIED', '2026-09-26 13:32:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(65, 1, 8, 4, 'PAE-B03', 'R-1', 'AVAILABLE', '2026-09-26 17:10:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(66, 1, 8, 4, 'PAE-B04', 'R-1', 'OCCUPIED', '2026-09-26 13:26:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(67, 1, 8, 4, 'PAE-B05', 'R-2', 'CLEANING', '2026-09-26 14:57:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(68, 1, 8, 4, 'PAE-B06', 'R-2', 'CLEANING', '2026-09-26 12:28:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(69, 1, 9, 1, 'PAE-B01', 'R-1', 'AVAILABLE', '2026-09-26 14:07:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(70, 1, 9, 1, 'PAE-B02', 'R-1', 'RESERVED', '2026-09-26 13:02:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(71, 1, 9, 1, 'PAE-B03', 'R-1', 'RESERVED', '2026-09-26 17:09:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(72, 1, 9, 1, 'PAE-B04', 'R-1', 'OCCUPIED', '2026-09-26 16:41:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(73, 1, 9, 1, 'PAE-B05', 'R-2', 'AVAILABLE', '2026-09-26 13:21:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(74, 1, 9, 1, 'PAE-B06', 'R-2', 'OCCUPIED', '2026-09-26 16:29:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(75, 1, 9, 1, 'PAE-B07', 'R-2', 'RESERVED', '2026-09-26 13:54:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(76, 1, 9, 1, 'PAE-B08', 'R-2', 'RESERVED', '2026-09-26 17:06:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(77, 1, 9, 1, 'PAE-B09', 'R-3', 'RESERVED', '2026-09-26 15:05:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(78, 1, 9, 1, 'PAE-B10', 'R-3', 'OCCUPIED', '2026-09-26 13:26:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(79, 2, 10, 1, 'MED-B01', 'R-1', 'AVAILABLE', '2026-09-26 16:26:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(80, 2, 10, 1, 'MED-B02', 'R-1', 'CLEANING', '2026-09-26 15:20:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(81, 2, 10, 1, 'MED-B03', 'R-1', 'OCCUPIED', '2026-09-26 16:01:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(82, 2, 10, 1, 'MED-B04', 'R-1', 'OCCUPIED', '2026-09-26 13:27:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(83, 2, 10, 1, 'MED-B05', 'R-2', 'OCCUPIED', '2026-09-26 15:52:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(84, 2, 10, 1, 'MED-B06', 'R-2', 'OCCUPIED', '2026-09-26 17:01:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(85, 2, 10, 1, 'MED-B07', 'R-2', 'AVAILABLE', '2026-09-26 12:36:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(86, 2, 10, 1, 'MED-B08', 'R-2', 'OCCUPIED', '2026-09-26 14:24:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(87, 2, 10, 1, 'MED-B09', 'R-3', 'OCCUPIED', '2026-09-26 15:05:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(88, 2, 10, 1, 'MED-B10', 'R-3', 'CLEANING', '2026-09-26 13:52:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(89, 2, 11, 1, 'MED-B01', 'R-1', 'AVAILABLE', '2026-09-26 15:42:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(90, 2, 11, 1, 'MED-B02', 'R-1', 'OCCUPIED', '2026-09-26 16:09:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(91, 2, 11, 1, 'MED-B03', 'R-1', 'AVAILABLE', '2026-09-26 14:57:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(92, 2, 11, 1, 'MED-B04', 'R-1', 'OCCUPIED', '2026-09-26 12:43:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(93, 2, 11, 1, 'MED-B05', 'R-2', 'OCCUPIED', '2026-09-26 12:39:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(94, 2, 11, 1, 'MED-B06', 'R-2', 'RESERVED', '2026-09-26 13:26:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(95, 2, 11, 1, 'MED-B07', 'R-2', 'OCCUPIED', '2026-09-26 15:40:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(96, 2, 11, 1, 'MED-B08', 'R-2', 'AVAILABLE', '2026-09-26 12:49:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(97, 2, 11, 1, 'MED-B09', 'R-3', 'AVAILABLE', '2026-09-26 13:40:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(98, 2, 11, 1, 'MED-B10', 'R-3', 'CLEANING', '2026-09-26 12:22:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(99, 2, 12, 1, 'SUR-B01', 'R-1', 'AVAILABLE', '2026-09-26 17:04:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(100, 2, 12, 1, 'SUR-B02', 'R-1', 'OCCUPIED', '2026-09-26 13:14:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(101, 2, 12, 1, 'SUR-B03', 'R-1', 'RESERVED', '2026-09-26 14:52:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(102, 2, 12, 1, 'SUR-B04', 'R-1', 'OCCUPIED', '2026-09-26 16:15:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(103, 2, 12, 1, 'SUR-B05', 'R-2', 'OCCUPIED', '2026-09-26 13:10:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(104, 2, 12, 1, 'SUR-B06', 'R-2', 'OCCUPIED', '2026-09-26 14:28:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(105, 2, 12, 1, 'SUR-B07', 'R-2', 'OCCUPIED', '2026-09-26 16:04:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(106, 2, 12, 1, 'SUR-B08', 'R-2', 'OCCUPIED', '2026-09-26 14:43:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(107, 2, 12, 1, 'SUR-B09', 'R-3', 'RESERVED', '2026-09-26 15:50:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(108, 2, 12, 1, 'SUR-B10', 'R-3', 'OCCUPIED', '2026-09-26 16:21:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(109, 2, 13, 1, 'SUR-B01', 'R-1', 'AVAILABLE', '2026-09-26 15:55:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(110, 2, 13, 1, 'SUR-B02', 'R-1', 'AVAILABLE', '2026-09-26 16:02:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(111, 2, 13, 1, 'SUR-B03', 'R-1', 'CLEANING', '2026-09-26 17:02:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(112, 2, 13, 1, 'SUR-B04', 'R-1', 'AVAILABLE', '2026-09-26 14:55:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(113, 2, 13, 1, 'SUR-B05', 'R-2', 'AVAILABLE', '2026-09-26 14:05:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(114, 2, 13, 1, 'SUR-B06', 'R-2', 'RESERVED', '2026-09-26 16:32:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(115, 2, 13, 1, 'SUR-B07', 'R-2', 'OCCUPIED', '2026-09-26 13:31:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(116, 2, 13, 1, 'SUR-B08', 'R-2', 'RESERVED', '2026-09-26 12:50:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(117, 2, 13, 1, 'SUR-B09', 'R-3', 'CLEANING', '2026-09-26 14:30:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(118, 2, 13, 1, 'SUR-B10', 'R-3', 'OCCUPIED', '2026-09-26 13:00:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(119, 2, 14, 3, 'EME-B01', 'R-1', 'AVAILABLE', '2026-09-26 15:06:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(120, 2, 14, 3, 'EME-B02', 'R-1', 'OCCUPIED', '2026-09-26 12:41:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(121, 2, 14, 3, 'EME-B03', 'R-1', 'AVAILABLE', '2026-09-26 15:52:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(122, 2, 14, 3, 'EME-B04', 'R-1', 'OCCUPIED', '2026-09-26 13:08:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(123, 2, 14, 3, 'EME-B05', 'R-2', 'RESERVED', '2026-09-26 16:30:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(124, 2, 14, 3, 'EME-B06', 'R-2', 'OCCUPIED', '2026-09-26 12:23:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(125, 2, 15, 2, 'EME-B01', 'R-1', 'AVAILABLE', '2026-09-26 12:37:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(126, 2, 15, 2, 'EME-B02', 'R-1', 'AVAILABLE', '2026-09-26 12:44:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(127, 2, 15, 2, 'EME-B03', 'R-1', 'AVAILABLE', '2026-09-26 14:36:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(128, 2, 15, 2, 'EME-B04', 'R-1', 'OCCUPIED', '2026-09-26 14:04:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(129, 2, 15, 2, 'EME-B05', 'R-2', 'AVAILABLE', '2026-09-26 13:36:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(130, 2, 15, 2, 'EME-B06', 'R-2', 'AVAILABLE', '2026-09-26 15:05:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(131, 2, 15, 2, 'EME-B07', 'R-2', 'AVAILABLE', '2026-09-26 13:08:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(132, 2, 15, 2, 'EME-B08', 'R-2', 'OCCUPIED', '2026-09-26 14:39:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(133, 2, 15, 2, 'EME-B09', 'R-3', 'AVAILABLE', '2026-09-26 15:18:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(134, 2, 15, 2, 'EME-B10', 'R-3', 'RESERVED', '2026-09-26 16:23:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(135, 3, 16, 1, 'IPD-B01', 'R-1', 'AVAILABLE', '2026-09-26 15:06:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(136, 3, 16, 1, 'IPD-B02', 'R-1', 'CLEANING', '2026-09-26 16:51:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(137, 3, 16, 1, 'IPD-B03', 'R-1', 'RESERVED', '2026-09-26 15:17:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(138, 3, 16, 1, 'IPD-B04', 'R-1', 'CLEANING', '2026-09-26 12:41:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(139, 3, 16, 1, 'IPD-B05', 'R-2', 'RESERVED', '2026-09-26 16:45:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(140, 3, 16, 1, 'IPD-B06', 'R-2', 'OCCUPIED', '2026-09-26 16:17:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(141, 3, 16, 1, 'IPD-B07', 'R-2', 'CLEANING', '2026-09-26 12:41:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(142, 3, 16, 1, 'IPD-B08', 'R-2', 'OCCUPIED', '2026-09-26 14:32:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(143, 3, 16, 1, 'IPD-B09', 'R-3', 'OCCUPIED', '2026-09-26 16:10:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(144, 3, 16, 1, 'IPD-B10', 'R-3', 'CLEANING', '2026-09-26 15:31:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(145, 3, 17, 1, 'IPD-B01', 'R-1', 'AVAILABLE', '2026-09-26 16:12:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(146, 3, 17, 1, 'IPD-B02', 'R-1', 'CLEANING', '2026-09-26 15:50:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(147, 3, 17, 1, 'IPD-B03', 'R-1', 'OCCUPIED', '2026-09-26 13:43:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(148, 3, 17, 1, 'IPD-B04', 'R-1', 'OCCUPIED', '2026-09-26 16:53:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(149, 3, 17, 1, 'IPD-B05', 'R-2', 'OCCUPIED', '2026-09-26 12:48:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(150, 3, 17, 1, 'IPD-B06', 'R-2', 'OCCUPIED', '2026-09-26 16:23:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(151, 3, 17, 1, 'IPD-B07', 'R-2', 'CLEANING', '2026-09-26 16:32:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(152, 3, 17, 1, 'IPD-B08', 'R-2', 'RESERVED', '2026-09-26 13:53:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(153, 3, 17, 1, 'IPD-B09', 'R-3', 'AVAILABLE', '2026-09-26 14:43:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(154, 3, 17, 1, 'IPD-B10', 'R-3', 'RESERVED', '2026-09-26 15:08:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(155, 3, 18, 3, 'EME-B01', 'R-1', 'AVAILABLE', '2026-09-26 16:18:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(156, 3, 18, 3, 'EME-B02', 'R-1', 'OCCUPIED', '2026-09-26 12:45:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(157, 3, 18, 3, 'EME-B03', 'R-1', 'OCCUPIED', '2026-09-26 12:28:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(158, 3, 18, 3, 'EME-B04', 'R-1', 'OCCUPIED', '2026-09-26 16:02:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(159, 3, 18, 3, 'EME-B05', 'R-2', 'AVAILABLE', '2026-09-26 15:26:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(160, 3, 18, 3, 'EME-B06', 'R-2', 'OCCUPIED', '2026-09-26 12:56:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(161, 3, 19, 2, 'EME-B01', 'R-1', 'AVAILABLE', '2026-09-26 16:02:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(162, 3, 19, 2, 'EME-B02', 'R-1', 'OCCUPIED', '2026-09-26 15:20:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(163, 3, 19, 2, 'EME-B03', 'R-1', 'OCCUPIED', '2026-09-26 16:40:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(164, 3, 19, 2, 'EME-B04', 'R-1', 'RESERVED', '2026-09-26 16:03:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(165, 3, 19, 2, 'EME-B05', 'R-2', 'OCCUPIED', '2026-09-26 15:28:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(166, 3, 19, 2, 'EME-B06', 'R-2', 'OCCUPIED', '2026-09-26 13:01:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(167, 3, 19, 2, 'EME-B07', 'R-2', 'OCCUPIED', '2026-09-26 16:07:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(168, 3, 19, 2, 'EME-B08', 'R-2', 'AVAILABLE', '2026-09-26 13:34:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(169, 3, 19, 2, 'EME-B09', 'R-3', 'AVAILABLE', '2026-09-26 14:16:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(170, 3, 19, 2, 'EME-B10', 'R-3', 'RESERVED', '2026-09-26 15:21:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(171, 4, 20, 1, 'IPD-B01', 'R-1', 'AVAILABLE', '2026-09-26 13:44:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(172, 4, 20, 1, 'IPD-B02', 'R-1', 'OCCUPIED', '2026-09-26 13:31:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(173, 4, 20, 1, 'IPD-B03', 'R-1', 'AVAILABLE', '2026-09-26 13:35:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(174, 4, 20, 1, 'IPD-B04', 'R-1', 'AVAILABLE', '2026-09-26 14:48:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(175, 4, 20, 1, 'IPD-B05', 'R-2', 'RESERVED', '2026-09-26 15:01:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(176, 4, 20, 1, 'IPD-B06', 'R-2', 'RESERVED', '2026-09-26 17:02:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(177, 4, 20, 1, 'IPD-B07', 'R-2', 'AVAILABLE', '2026-09-26 16:20:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(178, 4, 20, 1, 'IPD-B08', 'R-2', 'RESERVED', '2026-09-26 16:46:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(179, 4, 20, 1, 'IPD-B09', 'R-3', 'OCCUPIED', '2026-09-26 14:52:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(180, 4, 20, 1, 'IPD-B10', 'R-3', 'AVAILABLE', '2026-09-26 16:30:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(181, 4, 21, 1, 'IPD-B01', 'R-1', 'AVAILABLE', '2026-09-26 15:08:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(182, 4, 21, 1, 'IPD-B02', 'R-1', 'CLEANING', '2026-09-26 14:26:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(183, 4, 21, 1, 'IPD-B03', 'R-1', 'OCCUPIED', '2026-09-26 16:14:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(184, 4, 21, 1, 'IPD-B04', 'R-1', 'OCCUPIED', '2026-09-26 15:47:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(185, 4, 21, 1, 'IPD-B05', 'R-2', 'OCCUPIED', '2026-09-26 14:14:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(186, 4, 21, 1, 'IPD-B06', 'R-2', 'AVAILABLE', '2026-09-26 12:23:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(187, 4, 21, 1, 'IPD-B07', 'R-2', 'AVAILABLE', '2026-09-26 12:42:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(188, 4, 21, 1, 'IPD-B08', 'R-2', 'OCCUPIED', '2026-09-26 14:34:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(189, 4, 21, 1, 'IPD-B09', 'R-3', 'OCCUPIED', '2026-09-26 12:39:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(190, 4, 21, 1, 'IPD-B10', 'R-3', 'OCCUPIED', '2026-09-26 14:09:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(191, 4, 22, 3, 'EME-B01', 'R-1', 'AVAILABLE', '2026-09-26 13:28:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(192, 4, 22, 3, 'EME-B02', 'R-1', 'OCCUPIED', '2026-09-26 14:44:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(193, 4, 22, 3, 'EME-B03', 'R-1', 'AVAILABLE', '2026-09-26 13:17:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(194, 4, 22, 3, 'EME-B04', 'R-1', 'RESERVED', '2026-09-26 15:26:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(195, 4, 22, 3, 'EME-B05', 'R-2', 'RESERVED', '2026-09-26 13:04:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(196, 4, 22, 3, 'EME-B06', 'R-2', 'OCCUPIED', '2026-09-26 15:47:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(197, 4, 23, 2, 'EME-B01', 'R-1', 'AVAILABLE', '2026-09-26 17:01:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(198, 4, 23, 2, 'EME-B02', 'R-1', 'AVAILABLE', '2026-09-26 16:52:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(199, 4, 23, 2, 'EME-B03', 'R-1', 'RESERVED', '2026-09-26 15:12:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(200, 4, 23, 2, 'EME-B04', 'R-1', 'OCCUPIED', '2026-09-26 13:53:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(201, 4, 23, 2, 'EME-B05', 'R-2', 'AVAILABLE', '2026-09-26 14:45:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(202, 4, 23, 2, 'EME-B06', 'R-2', 'OCCUPIED', '2026-09-26 12:32:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(203, 4, 23, 2, 'EME-B07', 'R-2', 'AVAILABLE', '2026-09-26 12:46:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(204, 4, 23, 2, 'EME-B08', 'R-2', 'OCCUPIED', '2026-09-26 16:56:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(205, 4, 23, 2, 'EME-B09', 'R-3', 'OCCUPIED', '2026-09-26 15:34:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(206, 4, 23, 2, 'EME-B10', 'R-3', 'OCCUPIED', '2026-09-26 13:19:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(207, 5, 24, 3, 'CRI-B01', 'R-1', 'AVAILABLE', '2026-09-26 17:07:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(208, 5, 24, 3, 'CRI-B02', 'R-1', 'OCCUPIED', '2026-09-26 13:42:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(209, 5, 24, 3, 'CRI-B03', 'R-1', 'AVAILABLE', '2026-09-26 14:16:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(210, 5, 24, 3, 'CRI-B04', 'R-1', 'CLEANING', '2026-09-26 16:43:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(211, 5, 24, 3, 'CRI-B05', 'R-2', 'OCCUPIED', '2026-09-26 13:00:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(212, 5, 24, 3, 'CRI-B06', 'R-2', 'CLEANING', '2026-09-26 16:00:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(213, 5, 25, 2, 'CRI-B01', 'R-1', 'AVAILABLE', '2026-09-26 16:34:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(214, 5, 25, 2, 'CRI-B02', 'R-1', 'OCCUPIED', '2026-09-26 14:13:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(215, 5, 25, 2, 'CRI-B03', 'R-1', 'AVAILABLE', '2026-09-26 13:46:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(216, 5, 25, 2, 'CRI-B04', 'R-1', 'RESERVED', '2026-09-26 15:27:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(217, 5, 25, 2, 'CRI-B05', 'R-2', 'RESERVED', '2026-09-26 14:37:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(218, 5, 25, 2, 'CRI-B06', 'R-2', 'AVAILABLE', '2026-09-26 13:19:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(219, 5, 25, 2, 'CRI-B07', 'R-2', 'OCCUPIED', '2026-09-26 13:23:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(220, 5, 25, 2, 'CRI-B08', 'R-2', 'OCCUPIED', '2026-09-26 15:52:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(221, 5, 25, 2, 'CRI-B09', 'R-3', 'RESERVED', '2026-09-26 14:50:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(222, 5, 25, 2, 'CRI-B10', 'R-3', 'OCCUPIED', '2026-09-26 16:22:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(223, 5, 26, 5, 'CAR-B01', 'R-1', 'AVAILABLE', '2026-09-26 12:28:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(224, 5, 26, 5, 'CAR-B02', 'R-1', 'OCCUPIED', '2026-09-26 15:18:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(225, 5, 26, 5, 'CAR-B03', 'R-1', 'OCCUPIED', '2026-09-26 15:08:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(226, 5, 26, 5, 'CAR-B04', 'R-1', 'CLEANING', '2026-09-26 13:29:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(227, 5, 26, 5, 'CAR-B05', 'R-2', 'RESERVED', '2026-09-26 13:07:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(228, 5, 26, 5, 'CAR-B06', 'R-2', 'OCCUPIED', '2026-09-26 12:36:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(229, 5, 27, 1, 'GEN-B01', 'R-1', 'AVAILABLE', '2026-09-26 16:03:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(230, 5, 27, 1, 'GEN-B02', 'R-1', 'CLEANING', '2026-09-26 14:53:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(231, 5, 27, 1, 'GEN-B03', 'R-1', 'RESERVED', '2026-09-26 15:21:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(232, 5, 27, 1, 'GEN-B04', 'R-1', 'OCCUPIED', '2026-09-26 15:58:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(233, 5, 27, 1, 'GEN-B05', 'R-2', 'OCCUPIED', '2026-09-26 14:37:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(234, 5, 27, 1, 'GEN-B06', 'R-2', 'AVAILABLE', '2026-09-26 13:24:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(235, 5, 27, 1, 'GEN-B07', 'R-2', 'CLEANING', '2026-09-26 12:26:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(236, 5, 27, 1, 'GEN-B08', 'R-2', 'CLEANING', '2026-09-26 15:14:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(237, 5, 27, 1, 'GEN-B09', 'R-3', 'OCCUPIED', '2026-09-26 13:35:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(238, 5, 27, 1, 'GEN-B10', 'R-3', 'CLEANING', '2026-09-26 14:46:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(239, 5, 28, 1, 'GEN-B01', 'R-1', 'AVAILABLE', '2026-09-26 13:02:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(240, 5, 28, 1, 'GEN-B02', 'R-1', 'OCCUPIED', '2026-09-26 13:38:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(241, 5, 28, 1, 'GEN-B03', 'R-1', 'OCCUPIED', '2026-09-26 15:53:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(242, 5, 28, 1, 'GEN-B04', 'R-1', 'AVAILABLE', '2026-09-26 16:42:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(243, 5, 28, 1, 'GEN-B05', 'R-2', 'AVAILABLE', '2026-09-26 15:44:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(244, 5, 28, 1, 'GEN-B06', 'R-2', 'AVAILABLE', '2026-09-26 14:47:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(245, 5, 28, 1, 'GEN-B07', 'R-2', 'OCCUPIED', '2026-09-26 15:01:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(246, 5, 28, 1, 'GEN-B08', 'R-2', 'AVAILABLE', '2026-09-26 16:24:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(247, 5, 28, 1, 'GEN-B09', 'R-3', 'RESERVED', '2026-09-26 13:09:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(248, 5, 28, 1, 'GEN-B10', 'R-3', 'OCCUPIED', '2026-09-26 15:08:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(249, 6, 29, 3, 'CRI-B01', 'R-1', 'AVAILABLE', '2026-09-26 13:12:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(250, 6, 29, 3, 'CRI-B02', 'R-1', 'AVAILABLE', '2026-09-26 17:06:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(251, 6, 29, 3, 'CRI-B03', 'R-1', 'OCCUPIED', '2026-09-26 13:11:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(252, 6, 29, 3, 'CRI-B04', 'R-1', 'OCCUPIED', '2026-09-26 13:23:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(253, 6, 29, 3, 'CRI-B05', 'R-2', 'OCCUPIED', '2026-09-26 16:17:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(254, 6, 29, 3, 'CRI-B06', 'R-2', 'OCCUPIED', '2026-09-26 12:31:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(255, 6, 30, 2, 'CRI-B01', 'R-1', 'AVAILABLE', '2026-09-26 13:22:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(256, 6, 30, 2, 'CRI-B02', 'R-1', 'OCCUPIED', '2026-09-26 15:45:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(257, 6, 30, 2, 'CRI-B03', 'R-1', 'CLEANING', '2026-09-26 13:39:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(258, 6, 30, 2, 'CRI-B04', 'R-1', 'CLEANING', '2026-09-26 13:18:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(259, 6, 30, 2, 'CRI-B05', 'R-2', 'OCCUPIED', '2026-09-26 16:52:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(260, 6, 30, 2, 'CRI-B06', 'R-2', 'AVAILABLE', '2026-09-26 12:30:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(261, 6, 30, 2, 'CRI-B07', 'R-2', 'AVAILABLE', '2026-09-26 12:23:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(262, 6, 30, 2, 'CRI-B08', 'R-2', 'OCCUPIED', '2026-09-26 15:22:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(263, 6, 30, 2, 'CRI-B09', 'R-3', 'OCCUPIED', '2026-09-26 16:00:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(264, 6, 30, 2, 'CRI-B10', 'R-3', 'OCCUPIED', '2026-09-26 13:49:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(265, 6, 31, 1, 'IPD-B01', 'R-1', 'AVAILABLE', '2026-09-26 12:53:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(266, 6, 31, 1, 'IPD-B02', 'R-1', 'OCCUPIED', '2026-09-26 14:32:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(267, 6, 31, 1, 'IPD-B03', 'R-1', 'RESERVED', '2026-09-26 14:37:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(268, 6, 31, 1, 'IPD-B04', 'R-1', 'OCCUPIED', '2026-09-26 12:42:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(269, 6, 31, 1, 'IPD-B05', 'R-2', 'OCCUPIED', '2026-09-26 12:38:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(270, 6, 31, 1, 'IPD-B06', 'R-2', 'RESERVED', '2026-09-26 12:33:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(271, 6, 31, 1, 'IPD-B07', 'R-2', 'RESERVED', '2026-09-26 15:27:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(272, 6, 31, 1, 'IPD-B08', 'R-2', 'AVAILABLE', '2026-09-26 14:04:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(273, 6, 31, 1, 'IPD-B09', 'R-3', 'CLEANING', '2026-09-26 16:27:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(274, 6, 31, 1, 'IPD-B10', 'R-3', 'OCCUPIED', '2026-09-26 13:31:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(275, 6, 32, 1, 'IPD-B01', 'R-1', 'AVAILABLE', '2026-09-26 12:37:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(276, 6, 32, 1, 'IPD-B02', 'R-1', 'RESERVED', '2026-09-26 17:04:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(277, 6, 32, 1, 'IPD-B03', 'R-1', 'AVAILABLE', '2026-09-26 12:20:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(278, 6, 32, 1, 'IPD-B04', 'R-1', 'AVAILABLE', '2026-09-26 16:10:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(279, 6, 32, 1, 'IPD-B05', 'R-2', 'OCCUPIED', '2026-09-26 16:20:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(280, 6, 32, 1, 'IPD-B06', 'R-2', 'AVAILABLE', '2026-09-26 13:31:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(281, 6, 32, 1, 'IPD-B07', 'R-2', 'OCCUPIED', '2026-09-26 15:11:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(282, 6, 32, 1, 'IPD-B08', 'R-2', 'OCCUPIED', '2026-09-26 14:51:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(283, 6, 32, 1, 'IPD-B09', 'R-3', 'OCCUPIED', '2026-09-26 16:21:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(284, 6, 32, 1, 'IPD-B10', 'R-3', 'AVAILABLE', '2026-09-26 13:08:42', 0, 'Standard equipped station', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(285, 7, 33, 1, 'GEN-B01', 'R-1', 'AVAILABLE', '2026-09-26 12:20:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(286, 7, 33, 1, 'GEN-B02', 'R-1', 'OCCUPIED', '2026-09-26 13:07:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(287, 7, 33, 1, 'GEN-B03', 'R-1', 'RESERVED', '2026-09-26 15:54:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(288, 7, 33, 1, 'GEN-B04', 'R-1', 'RESERVED', '2026-09-26 13:33:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(289, 7, 33, 1, 'GEN-B05', 'R-2', 'AVAILABLE', '2026-09-26 15:22:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(290, 7, 33, 1, 'GEN-B06', 'R-2', 'AVAILABLE', '2026-09-26 15:04:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(291, 7, 33, 1, 'GEN-B07', 'R-2', 'OCCUPIED', '2026-09-26 15:30:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(292, 7, 33, 1, 'GEN-B08', 'R-2', 'OCCUPIED', '2026-09-26 14:42:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(293, 7, 33, 1, 'GEN-B09', 'R-3', 'CLEANING', '2026-09-26 16:09:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(294, 7, 33, 1, 'GEN-B10', 'R-3', 'OCCUPIED', '2026-09-26 16:46:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(295, 7, 34, 1, 'GEN-B01', 'R-1', 'AVAILABLE', '2026-09-26 13:41:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(296, 7, 34, 1, 'GEN-B02', 'R-1', 'OCCUPIED', '2026-09-26 16:49:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(297, 7, 34, 1, 'GEN-B03', 'R-1', 'AVAILABLE', '2026-09-26 14:23:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(298, 7, 34, 1, 'GEN-B04', 'R-1', 'AVAILABLE', '2026-09-26 15:33:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(299, 7, 34, 1, 'GEN-B05', 'R-2', 'AVAILABLE', '2026-09-26 12:43:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(300, 7, 34, 1, 'GEN-B06', 'R-2', 'AVAILABLE', '2026-09-26 13:35:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(301, 7, 34, 1, 'GEN-B07', 'R-2', 'OCCUPIED', '2026-09-26 15:13:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(302, 7, 34, 1, 'GEN-B08', 'R-2', 'OCCUPIED', '2026-09-26 14:07:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(303, 7, 34, 1, 'GEN-B09', 'R-3', 'OCCUPIED', '2026-09-26 15:03:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(304, 7, 34, 1, 'GEN-B10', 'R-3', 'OCCUPIED', '2026-09-26 15:26:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(305, 7, 35, 1, 'ICU-B01', 'R-1', 'AVAILABLE', '2026-09-26 15:41:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(306, 7, 35, 1, 'ICU-B02', 'R-1', 'AVAILABLE', '2026-09-26 13:13:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(307, 7, 35, 1, 'ICU-B03', 'R-1', 'OCCUPIED', '2026-09-26 14:44:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(308, 7, 35, 1, 'ICU-B04', 'R-1', 'AVAILABLE', '2026-09-26 17:01:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(309, 7, 35, 1, 'ICU-B05', 'R-2', 'OCCUPIED', '2026-09-26 13:14:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(310, 7, 35, 1, 'ICU-B06', 'R-2', 'AVAILABLE', '2026-09-26 12:58:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(311, 7, 35, 1, 'ICU-B07', 'R-2', 'CLEANING', '2026-09-26 14:54:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(312, 7, 35, 1, 'ICU-B08', 'R-2', 'OCCUPIED', '2026-09-26 16:04:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(313, 7, 35, 1, 'ICU-B09', 'R-3', 'RESERVED', '2026-09-26 12:45:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(314, 7, 35, 1, 'ICU-B10', 'R-3', 'OCCUPIED', '2026-09-26 15:34:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(315, 7, 36, 1, 'ICU-B01', 'R-1', 'AVAILABLE', '2026-09-26 16:39:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(316, 7, 36, 1, 'ICU-B02', 'R-1', 'OCCUPIED', '2026-09-26 14:21:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(317, 7, 36, 1, 'ICU-B03', 'R-1', 'AVAILABLE', '2026-09-26 12:34:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(318, 7, 36, 1, 'ICU-B04', 'R-1', 'RESERVED', '2026-09-26 16:57:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(319, 7, 36, 1, 'ICU-B05', 'R-2', 'RESERVED', '2026-09-26 16:24:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(320, 7, 36, 1, 'ICU-B06', 'R-2', 'OCCUPIED', '2026-09-26 17:04:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(321, 7, 36, 1, 'ICU-B07', 'R-2', 'RESERVED', '2026-09-26 14:41:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(322, 7, 36, 1, 'ICU-B08', 'R-2', 'AVAILABLE', '2026-09-26 15:48:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(323, 7, 36, 1, 'ICU-B09', 'R-3', 'OCCUPIED', '2026-09-26 13:34:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(324, 7, 36, 1, 'ICU-B10', 'R-3', 'AVAILABLE', '2026-09-26 13:37:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(325, 8, 37, 1, 'GEN-B01', 'R-1', 'AVAILABLE', '2026-09-26 16:09:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(326, 8, 37, 1, 'GEN-B02', 'R-1', 'CLEANING', '2026-09-26 16:31:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(327, 8, 37, 1, 'GEN-B03', 'R-1', 'OCCUPIED', '2026-09-26 15:09:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(328, 8, 37, 1, 'GEN-B04', 'R-1', 'OCCUPIED', '2026-09-26 14:09:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL);
INSERT INTO `beds` (`id`, `hospital_id`, `ward_id`, `category_id`, `bed_number`, `room_number`, `status`, `status_changed_at`, `is_surge`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES
(329, 8, 37, 1, 'GEN-B05', 'R-2', 'RESERVED', '2026-09-26 13:54:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(330, 8, 37, 1, 'GEN-B06', 'R-2', 'RESERVED', '2026-09-26 15:13:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(331, 8, 37, 1, 'GEN-B07', 'R-2', 'AVAILABLE', '2026-09-26 14:40:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(332, 8, 37, 1, 'GEN-B08', 'R-2', 'RESERVED', '2026-09-26 15:39:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(333, 8, 37, 1, 'GEN-B09', 'R-3', 'CLEANING', '2026-09-26 15:58:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(334, 8, 37, 1, 'GEN-B10', 'R-3', 'CLEANING', '2026-09-26 12:27:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(335, 8, 38, 1, 'GEN-B01', 'R-1', 'AVAILABLE', '2026-09-26 16:49:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(336, 8, 38, 1, 'GEN-B02', 'R-1', 'OCCUPIED', '2026-09-26 16:48:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(337, 8, 38, 1, 'GEN-B03', 'R-1', 'OCCUPIED', '2026-09-26 14:59:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(338, 8, 38, 1, 'GEN-B04', 'R-1', 'OCCUPIED', '2026-09-26 15:30:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(339, 8, 38, 1, 'GEN-B05', 'R-2', 'OCCUPIED', '2026-09-26 13:22:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(340, 8, 38, 1, 'GEN-B06', 'R-2', 'OCCUPIED', '2026-09-26 14:36:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(341, 8, 38, 1, 'GEN-B07', 'R-2', 'AVAILABLE', '2026-09-26 13:58:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(342, 8, 38, 1, 'GEN-B08', 'R-2', 'OCCUPIED', '2026-09-26 14:51:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(343, 8, 38, 1, 'GEN-B09', 'R-3', 'OCCUPIED', '2026-09-26 15:52:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(344, 8, 38, 1, 'GEN-B10', 'R-3', 'OCCUPIED', '2026-09-26 15:22:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(345, 8, 39, 3, 'CRI-B01', 'R-1', 'AVAILABLE', '2026-09-26 16:33:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(346, 8, 39, 3, 'CRI-B02', 'R-1', 'OCCUPIED', '2026-09-26 15:15:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(347, 8, 39, 3, 'CRI-B03', 'R-1', 'AVAILABLE', '2026-09-26 13:50:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(348, 8, 39, 3, 'CRI-B04', 'R-1', 'OCCUPIED', '2026-09-26 14:31:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(349, 8, 39, 3, 'CRI-B05', 'R-2', 'CLEANING', '2026-09-26 14:23:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(350, 8, 39, 3, 'CRI-B06', 'R-2', 'AVAILABLE', '2026-09-26 13:20:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(351, 8, 40, 2, 'CRI-B01', 'R-1', 'AVAILABLE', '2026-09-26 13:37:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(352, 8, 40, 2, 'CRI-B02', 'R-1', 'OCCUPIED', '2026-09-26 16:21:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(353, 8, 40, 2, 'CRI-B03', 'R-1', 'AVAILABLE', '2026-09-26 12:22:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(354, 8, 40, 2, 'CRI-B04', 'R-1', 'OCCUPIED', '2026-09-26 15:49:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(355, 8, 40, 2, 'CRI-B05', 'R-2', 'AVAILABLE', '2026-09-26 17:01:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(356, 8, 40, 2, 'CRI-B06', 'R-2', 'AVAILABLE', '2026-09-26 12:50:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(357, 8, 40, 2, 'CRI-B07', 'R-2', 'CLEANING', '2026-09-26 15:11:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(358, 8, 40, 2, 'CRI-B08', 'R-2', 'AVAILABLE', '2026-09-26 13:07:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(359, 8, 40, 2, 'CRI-B09', 'R-3', 'OCCUPIED', '2026-09-26 14:41:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(360, 8, 40, 2, 'CRI-B10', 'R-3', 'AVAILABLE', '2026-09-26 12:54:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(361, 9, 41, 1, 'GEN-B01', 'R-1', 'AVAILABLE', '2026-09-26 14:09:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(362, 9, 41, 1, 'GEN-B02', 'R-1', 'CLEANING', '2026-09-26 13:52:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(363, 9, 41, 1, 'GEN-B03', 'R-1', 'AVAILABLE', '2026-09-26 13:55:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(364, 9, 41, 1, 'GEN-B04', 'R-1', 'RESERVED', '2026-09-26 16:52:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(365, 9, 41, 1, 'GEN-B05', 'R-2', 'OCCUPIED', '2026-09-26 16:36:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(366, 9, 41, 1, 'GEN-B06', 'R-2', 'RESERVED', '2026-09-26 13:27:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(367, 9, 41, 1, 'GEN-B07', 'R-2', 'AVAILABLE', '2026-09-26 14:48:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(368, 9, 41, 1, 'GEN-B08', 'R-2', 'RESERVED', '2026-09-26 12:50:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(369, 9, 41, 1, 'GEN-B09', 'R-3', 'AVAILABLE', '2026-09-26 14:11:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(370, 9, 41, 1, 'GEN-B10', 'R-3', 'OCCUPIED', '2026-09-26 13:13:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(371, 9, 42, 1, 'GEN-B01', 'R-1', 'AVAILABLE', '2026-09-26 14:00:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(372, 9, 42, 1, 'GEN-B02', 'R-1', 'AVAILABLE', '2026-09-26 14:35:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(373, 9, 42, 1, 'GEN-B03', 'R-1', 'AVAILABLE', '2026-09-26 16:46:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(374, 9, 42, 1, 'GEN-B04', 'R-1', 'CLEANING', '2026-09-26 13:54:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(375, 9, 42, 1, 'GEN-B05', 'R-2', 'OCCUPIED', '2026-09-26 13:50:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(376, 9, 42, 1, 'GEN-B06', 'R-2', 'AVAILABLE', '2026-09-26 13:11:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(377, 9, 42, 1, 'GEN-B07', 'R-2', 'RESERVED', '2026-09-26 13:15:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(378, 9, 42, 1, 'GEN-B08', 'R-2', 'OCCUPIED', '2026-09-26 16:41:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(379, 9, 42, 1, 'GEN-B09', 'R-3', 'AVAILABLE', '2026-09-26 13:02:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(380, 9, 42, 1, 'GEN-B10', 'R-3', 'AVAILABLE', '2026-09-26 16:48:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(381, 9, 43, 3, 'CRI-B01', 'R-1', 'AVAILABLE', '2026-09-26 13:14:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(382, 9, 43, 3, 'CRI-B02', 'R-1', 'CLEANING', '2026-09-26 14:02:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(383, 9, 43, 3, 'CRI-B03', 'R-1', 'OCCUPIED', '2026-09-26 15:54:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(384, 9, 43, 3, 'CRI-B04', 'R-1', 'CLEANING', '2026-09-26 15:19:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(385, 9, 43, 3, 'CRI-B05', 'R-2', 'OCCUPIED', '2026-09-26 14:36:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(386, 9, 43, 3, 'CRI-B06', 'R-2', 'AVAILABLE', '2026-09-26 14:18:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(387, 9, 44, 2, 'CRI-B01', 'R-1', 'AVAILABLE', '2026-09-26 13:05:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(388, 9, 44, 2, 'CRI-B02', 'R-1', 'CLEANING', '2026-09-26 14:03:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(389, 9, 44, 2, 'CRI-B03', 'R-1', 'AVAILABLE', '2026-09-26 15:00:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(390, 9, 44, 2, 'CRI-B04', 'R-1', 'AVAILABLE', '2026-09-26 15:44:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(391, 9, 44, 2, 'CRI-B05', 'R-2', 'CLEANING', '2026-09-26 12:57:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(392, 9, 44, 2, 'CRI-B06', 'R-2', 'OCCUPIED', '2026-09-26 12:24:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(393, 9, 44, 2, 'CRI-B07', 'R-2', 'OCCUPIED', '2026-09-26 14:47:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(394, 9, 44, 2, 'CRI-B08', 'R-2', 'OCCUPIED', '2026-09-26 14:40:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(395, 9, 44, 2, 'CRI-B09', 'R-3', 'OCCUPIED', '2026-09-26 13:36:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(396, 9, 44, 2, 'CRI-B10', 'R-3', 'AVAILABLE', '2026-09-26 16:59:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(397, 10, 45, 4, 'PAE-B01', 'R-1', 'AVAILABLE', '2026-09-26 14:19:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(398, 10, 45, 4, 'PAE-B02', 'R-1', 'AVAILABLE', '2026-09-26 13:23:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(399, 10, 45, 4, 'PAE-B03', 'R-1', 'OCCUPIED', '2026-09-26 12:55:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(400, 10, 45, 4, 'PAE-B04', 'R-1', 'AVAILABLE', '2026-09-26 13:35:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(401, 10, 45, 4, 'PAE-B05', 'R-2', 'AVAILABLE', '2026-09-26 16:26:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(402, 10, 45, 4, 'PAE-B06', 'R-2', 'OCCUPIED', '2026-09-26 13:56:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(403, 10, 46, 1, 'PAE-B01', 'R-1', 'AVAILABLE', '2026-09-26 16:04:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(404, 10, 46, 1, 'PAE-B02', 'R-1', 'OCCUPIED', '2026-09-26 14:34:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(405, 10, 46, 1, 'PAE-B03', 'R-1', 'AVAILABLE', '2026-09-26 12:46:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(406, 10, 46, 1, 'PAE-B04', 'R-1', 'AVAILABLE', '2026-09-26 13:53:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(407, 10, 46, 1, 'PAE-B05', 'R-2', 'AVAILABLE', '2026-09-26 14:13:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(408, 10, 46, 1, 'PAE-B06', 'R-2', 'AVAILABLE', '2026-09-26 13:20:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(409, 10, 46, 1, 'PAE-B07', 'R-2', 'OCCUPIED', '2026-09-26 13:21:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(410, 10, 46, 1, 'PAE-B08', 'R-2', 'OCCUPIED', '2026-09-26 15:06:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(411, 10, 46, 1, 'PAE-B09', 'R-3', 'AVAILABLE', '2026-09-26 14:00:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(412, 10, 46, 1, 'PAE-B10', 'R-3', 'OCCUPIED', '2026-09-26 15:24:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(413, 10, 47, 1, 'IPD-B01', 'R-1', 'AVAILABLE', '2026-09-26 15:01:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(414, 10, 47, 1, 'IPD-B02', 'R-1', 'AVAILABLE', '2026-09-26 16:50:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(415, 10, 47, 1, 'IPD-B03', 'R-1', 'OCCUPIED', '2026-09-26 16:26:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(416, 10, 47, 1, 'IPD-B04', 'R-1', 'CLEANING', '2026-09-26 15:54:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(417, 10, 47, 1, 'IPD-B05', 'R-2', 'OCCUPIED', '2026-09-26 12:57:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(418, 10, 47, 1, 'IPD-B06', 'R-2', 'AVAILABLE', '2026-09-26 14:25:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(419, 10, 47, 1, 'IPD-B07', 'R-2', 'CLEANING', '2026-09-26 16:53:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(420, 10, 47, 1, 'IPD-B08', 'R-2', 'AVAILABLE', '2026-09-26 13:53:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(421, 10, 47, 1, 'IPD-B09', 'R-3', 'OCCUPIED', '2026-09-26 13:02:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(422, 10, 47, 1, 'IPD-B10', 'R-3', 'OCCUPIED', '2026-09-26 15:55:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(423, 10, 48, 1, 'IPD-B01', 'R-1', 'AVAILABLE', '2026-09-26 14:46:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(424, 10, 48, 1, 'IPD-B02', 'R-1', 'OCCUPIED', '2026-09-26 12:22:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(425, 10, 48, 1, 'IPD-B03', 'R-1', 'CLEANING', '2026-09-26 16:32:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(426, 10, 48, 1, 'IPD-B04', 'R-1', 'CLEANING', '2026-09-26 15:09:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(427, 10, 48, 1, 'IPD-B05', 'R-2', 'OCCUPIED', '2026-09-26 14:25:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(428, 10, 48, 1, 'IPD-B06', 'R-2', 'OCCUPIED', '2026-09-26 17:10:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(429, 10, 48, 1, 'IPD-B07', 'R-2', 'OCCUPIED', '2026-09-26 13:33:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(430, 10, 48, 1, 'IPD-B08', 'R-2', 'OCCUPIED', '2026-09-26 15:41:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(431, 10, 48, 1, 'IPD-B09', 'R-3', 'CLEANING', '2026-09-26 13:29:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(432, 10, 48, 1, 'IPD-B10', 'R-3', 'RESERVED', '2026-09-26 16:56:43', 0, 'Standard equipped station', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL);

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

--
-- Table structure for table `bed_categories`
--

CREATE TABLE `bed_categories` (
  `id` int NOT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_hi` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_surge` tinyint(1) NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bed_categories`
--

INSERT INTO `bed_categories` (`id`, `code`, `name_en`, `name_hi`, `is_surge`, `is_active`, `description`, `created_at`, `updated_at`) VALUES
(1, 'GENERAL', 'General Ward Bed', 'सामान्य वार्ड शैय्या', 0, 1, 'Standard inpatient care bed for routine medical/surgical admissions.', '2026-09-26 17:20:42', '2026-09-26 17:20:42'),
(2, 'HDU', 'High Dependency Unit (HDU)', 'उच्च निर्भरता इकाई (HDU)', 0, 1, 'Intermediate step-down bed with continuous oxygen and patient monitoring.', '2026-09-26 17:20:42', '2026-09-26 17:20:42'),
(3, 'ICU', 'Intensive Care Unit (ICU)', 'गहन चिकित्सा इकाई (ICU)', 0, 1, 'Critical care bed with mechanical ventilators, invasive monitoring, and 1:1 nursing.', '2026-09-26 17:20:42', '2026-09-26 17:20:42'),
(4, 'NICU', 'Neonatal Intensive Care Unit (NICU)', 'नवजात गहन चिकित्सा इकाई (NICU)', 0, 1, 'Specialized intensive care radiant warmers and incubators for critically ill newborns.', '2026-09-26 17:20:42', '2026-09-26 17:20:42'),
(5, 'ICCU', 'Intensive Coronary Care Unit (ICCU)', 'गहन कोरोनरी देखभाल इकाई (ICCU)', 0, 1, 'Specialized cardiac intensive bed for acute coronary events and rhythm management.', '2026-09-26 17:20:42', '2026-09-26 17:20:42'),
(6, 'SURGE', 'Surge Bed (Temporary Emergency)', 'आकस्मिक वृद्धि शैय्या (अस्थाई)', 1, 1, 'Temporary capacity deployed during health emergencies, declared only by the Medical Superintendent.', '2026-09-26 17:20:42', '2026-09-26 17:20:42');

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

--
-- Table structure for table `bed_events`
--

CREATE TABLE `bed_events` (
  `id` bigint UNSIGNED NOT NULL,
  `event_uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `hospital_id` int NOT NULL,
  `bed_id` int NOT NULL,
  `category_id` int NOT NULL,
  `old_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `new_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_at` datetime NOT NULL,
  `entered_at` datetime NOT NULL,
  `is_late_entry` tinyint(1) NOT NULL DEFAULT '0',
  `is_correction` tinyint(1) NOT NULL DEFAULT '0',
  `correction_reason` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `source` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'WEB_CONSOLE',
  `reason` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bed_events`
--

INSERT INTO `bed_events` (`id`, `event_uuid`, `hospital_id`, `bed_id`, `category_id`, `old_status`, `new_status`, `event_at`, `entered_at`, `is_late_entry`, `is_correction`, `correction_reason`, `user_id`, `source`, `reason`, `created_at`) VALUES
(1, '836f1e7a-768c-46ec-98e4-8c0a696eb90a', 1, 1, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 16:20:48', '2026-09-26 16:22:48', 0, 0, NULL, 7, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:20:48'),
(2, 'e5ea8818-66a9-4d38-ba07-7ab5230ad4aa', 1, 1, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 16:57:48', '2026-09-26 16:58:48', 0, 0, NULL, 7, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:57:48'),
(3, '58f73951-497d-45ee-962e-3c16e6c8e0d8', 1, 2, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 16:19:48', '2026-09-26 16:21:48', 0, 0, NULL, 7, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:19:48'),
(4, 'e938bee2-8b60-4e6b-af88-d4c0bbed0efc', 1, 2, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 16:55:48', '2026-09-26 16:56:48', 0, 0, NULL, 7, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:55:48'),
(5, '7aa4d90a-eee5-45c6-ba51-9e08716beb3a', 1, 3, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 16:13:48', '2026-09-26 16:15:48', 0, 0, NULL, 7, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:13:48'),
(6, 'e9bc1438-6223-4b5e-9011-dccce678e816', 1, 3, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 16:52:48', '2026-09-26 16:53:48', 0, 0, NULL, 7, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:52:48'),
(7, '503dfa86-63eb-445e-bb2e-b21d8798cd3e', 1, 4, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 15:57:48', '2026-09-26 15:59:48', 0, 0, NULL, 7, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 15:57:48'),
(8, '18f31771-b440-4afa-af7d-eaa8325de18b', 1, 4, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 16:29:48', '2026-09-26 16:30:48', 0, 0, NULL, 7, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:29:48'),
(9, '8757af6b-27e9-46b8-9713-fdde365ee8d6', 1, 5, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 16:29:48', '2026-09-26 16:31:48', 0, 0, NULL, 7, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:29:48'),
(10, '59b27c5c-6836-4313-af2d-005cc76f0172', 1, 5, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 17:07:48', '2026-09-26 17:08:48', 0, 0, NULL, 7, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 17:07:48'),
(11, '6689e6d7-f25c-4352-a1e3-cdd6f401bdd1', 2, 79, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 16:06:48', '2026-09-26 16:08:48', 0, 0, NULL, 12, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:06:48'),
(12, '12587d3c-20e3-478c-882d-f5759ca5c4e7', 2, 79, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 16:34:48', '2026-09-26 16:35:48', 0, 0, NULL, 12, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:34:48'),
(13, '286783b2-60fd-4bc7-9cda-3ea702b56efb', 2, 80, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 16:06:48', '2026-09-26 16:08:48', 0, 0, NULL, 12, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:06:48'),
(14, '32173cd1-4b90-47dc-8768-0ab7499089cf', 2, 80, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 16:43:48', '2026-09-26 16:44:48', 0, 0, NULL, 12, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:43:48'),
(15, '2fea4de3-98df-4d81-80a6-6a9a5cec1890', 2, 81, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 16:20:48', '2026-09-26 16:22:48', 0, 0, NULL, 12, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:20:48'),
(16, '51d76caf-7f76-4f5d-a3c2-1bc00454d25b', 2, 81, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 16:55:48', '2026-09-26 16:56:48', 0, 0, NULL, 12, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:55:48'),
(17, '8dc53eca-6722-44fe-9e85-5d170f2bd3b0', 2, 82, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 16:08:48', '2026-09-26 16:10:48', 0, 0, NULL, 12, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:08:48'),
(18, 'b9392187-0ad3-48db-9678-aed8f40ab4f5', 2, 82, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 16:45:48', '2026-09-26 16:46:48', 0, 0, NULL, 12, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:45:48'),
(19, 'c2a90cc1-542b-4253-a609-4de179eeb025', 2, 83, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 16:04:48', '2026-09-26 16:06:48', 0, 0, NULL, 12, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:04:48'),
(20, '4ce3db41-1be9-44b5-a6f5-e8b2cec539ad', 2, 83, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 16:41:48', '2026-09-26 16:42:48', 0, 0, NULL, 12, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:41:48'),
(21, '9106ecd7-96d1-4259-8794-13b5ac228e96', 3, 135, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 15:50:48', '2026-09-26 15:52:48', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 15:50:48'),
(22, 'c41fa7d1-bf43-4566-b8f6-cda8c31d9eda', 3, 135, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 16:27:48', '2026-09-26 16:28:48', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:27:48'),
(23, 'c3efa8fa-4d2c-481f-b245-8cc9559037a3', 3, 136, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 16:32:48', '2026-09-26 16:34:48', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:32:48'),
(24, 'da8eed11-2467-4b7d-8049-c8f765fc143d', 3, 136, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 16:58:48', '2026-09-26 16:59:48', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:58:48'),
(25, '30f52465-a6a7-47f7-8fd6-97f6780bfa9b', 3, 137, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 16:16:48', '2026-09-26 16:18:48', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:16:48'),
(26, '52c79d52-905a-46d4-a638-e7c16f24d184', 3, 137, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 16:49:48', '2026-09-26 16:50:48', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:49:48'),
(27, '11bdc9a9-0b14-4357-88cf-2f53fad7f98b', 3, 138, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 15:58:48', '2026-09-26 16:00:48', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 15:58:48'),
(28, 'f0a54bd5-0f83-4fd1-8236-635f8be1afc4', 3, 138, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 16:36:48', '2026-09-26 16:37:48', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:36:48'),
(29, '395311e3-be67-4244-8216-07ec192d8da9', 3, 139, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 15:59:48', '2026-09-26 16:01:48', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 15:59:48'),
(30, '6b54488c-088a-49ca-9e27-0a31325151ee', 3, 139, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 16:31:48', '2026-09-26 16:32:48', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:31:48'),
(31, 'ccf40caf-9943-4ef6-be31-529623ce1fa2', 4, 171, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 15:52:48', '2026-09-26 15:54:48', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 15:52:48'),
(32, '144d3b44-7021-4d50-925f-8bd5ecc12118', 4, 171, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 16:32:48', '2026-09-26 16:33:48', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:32:48'),
(33, '63b3ec0d-fb93-4b0b-a0fb-36e057a5be40', 4, 172, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 16:03:48', '2026-09-26 16:05:48', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:03:48'),
(34, 'e8bb117b-a72d-40ec-becf-ca537d2a77b8', 4, 172, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 16:36:48', '2026-09-26 16:37:48', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:36:48'),
(35, 'e430bb3a-adeb-45e1-8296-13818ecd5c0a', 4, 173, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 16:21:48', '2026-09-26 16:23:48', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:21:48'),
(36, 'f87107d8-ea93-4aec-ae59-6a77c401ae12', 4, 173, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 16:53:48', '2026-09-26 16:54:48', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:53:48'),
(37, 'dd6edcb7-65ef-4a5d-8f23-c5e8ba48225b', 4, 174, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 16:18:48', '2026-09-26 16:20:48', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:18:48'),
(38, '7631551e-cf46-42ca-ae1f-611de1040ac4', 4, 174, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 16:47:48', '2026-09-26 16:48:48', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:47:48'),
(39, '5997a72f-92b2-4ae2-969b-a1a3ef7d3410', 4, 175, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 16:21:49', '2026-09-26 16:23:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:21:49'),
(40, 'e02c5989-929d-4433-b53c-a7f228854da4', 4, 175, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 16:48:49', '2026-09-26 16:49:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:48:49'),
(41, '8fe7febd-228c-4710-9f52-159508bf45f3', 5, 207, 3, 'OCCUPIED', 'CLEANING', '2026-09-26 16:02:49', '2026-09-26 16:04:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:02:49'),
(42, '667b0929-8296-4d8d-9e29-2b9154a3ca48', 5, 207, 3, 'CLEANING', 'AVAILABLE', '2026-09-26 16:37:49', '2026-09-26 16:38:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:37:49'),
(43, 'd883876e-9e6a-4233-8158-4097e2201e34', 5, 208, 3, 'OCCUPIED', 'CLEANING', '2026-09-26 15:59:49', '2026-09-26 16:01:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 15:59:49'),
(44, 'a9ef209e-1735-4923-9ede-e2cb3acd8d83', 5, 208, 3, 'CLEANING', 'AVAILABLE', '2026-09-26 16:35:49', '2026-09-26 16:36:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:35:49'),
(45, 'ff029e99-1b8f-4955-b6ff-f37016dafd10', 5, 209, 3, 'OCCUPIED', 'CLEANING', '2026-09-26 16:11:49', '2026-09-26 16:13:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:11:49'),
(46, '9f2d0726-ee74-4cea-8f62-4f8e2696034e', 5, 209, 3, 'CLEANING', 'AVAILABLE', '2026-09-26 16:44:49', '2026-09-26 16:45:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:44:49'),
(47, 'fcce852d-3ee4-4275-a97a-0e98daeb6a43', 5, 210, 3, 'OCCUPIED', 'CLEANING', '2026-09-26 16:11:49', '2026-09-26 16:13:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:11:49'),
(48, 'b2e6e956-28d2-48a9-8142-79788ffaa4dc', 5, 210, 3, 'CLEANING', 'AVAILABLE', '2026-09-26 16:43:49', '2026-09-26 16:44:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:43:49'),
(49, '50136abb-277d-4be6-9ee9-25a4348ec21d', 5, 211, 3, 'OCCUPIED', 'CLEANING', '2026-09-26 16:11:49', '2026-09-26 16:13:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:11:49'),
(50, 'a64e95e1-e83f-4d00-b752-dc9540883b17', 5, 211, 3, 'CLEANING', 'AVAILABLE', '2026-09-26 16:42:49', '2026-09-26 16:43:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:42:49'),
(51, 'c1e5ba20-f4ff-496b-b7a5-0cdb4ffec5ca', 6, 249, 3, 'OCCUPIED', 'CLEANING', '2026-09-26 16:01:49', '2026-09-26 16:03:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:01:49'),
(52, '2420406b-2c32-4f70-ba4d-71e966ff6356', 6, 249, 3, 'CLEANING', 'AVAILABLE', '2026-09-26 16:32:49', '2026-09-26 16:33:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:32:49'),
(53, 'dd2d84c9-ae17-46c7-bf51-12933fc35066', 6, 250, 3, 'OCCUPIED', 'CLEANING', '2026-09-26 16:07:49', '2026-09-26 16:09:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:07:49'),
(54, '35023044-673b-4539-b8f3-ddbb56e34de7', 6, 250, 3, 'CLEANING', 'AVAILABLE', '2026-09-26 16:46:49', '2026-09-26 16:47:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:46:49'),
(55, '0a85ba65-228f-4195-97b6-bfeb2eaf73c8', 6, 251, 3, 'OCCUPIED', 'CLEANING', '2026-09-26 16:23:49', '2026-09-26 16:25:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:23:49'),
(56, '9bd57679-c9da-496a-8b5b-7fc5fdb8894a', 6, 251, 3, 'CLEANING', 'AVAILABLE', '2026-09-26 16:57:49', '2026-09-26 16:58:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:57:49'),
(57, '29233ba2-f89a-4ea0-a930-7b7503a712d2', 6, 252, 3, 'OCCUPIED', 'CLEANING', '2026-09-26 16:06:49', '2026-09-26 16:08:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:06:49'),
(58, '5099684e-b4bc-47f9-8e2d-d77c9187873e', 6, 252, 3, 'CLEANING', 'AVAILABLE', '2026-09-26 16:45:49', '2026-09-26 16:46:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:45:49'),
(59, 'c7d1e4e3-a50a-4a0d-841f-242c7d9b0cda', 6, 253, 3, 'OCCUPIED', 'CLEANING', '2026-09-26 16:28:49', '2026-09-26 16:30:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:28:49'),
(60, '0c568df1-cf3c-4d10-a667-ed79341d7eef', 6, 253, 3, 'CLEANING', 'AVAILABLE', '2026-09-26 17:06:49', '2026-09-26 17:07:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 17:06:49'),
(61, '95650357-15a6-4f87-8f84-699a5a80587b', 7, 285, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 15:51:49', '2026-09-26 15:53:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 15:51:49'),
(62, '0af58251-d406-49a9-beb1-d31ebe200f5a', 7, 285, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 16:29:49', '2026-09-26 16:30:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:29:49'),
(63, '92b2f469-c2fb-4082-9420-9dadacad4bfa', 7, 286, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 16:31:49', '2026-09-26 16:33:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:31:49'),
(64, '782c7ed1-6deb-4fbb-bffc-4545189edbf2', 7, 286, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 17:02:49', '2026-09-26 17:03:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 17:02:49'),
(65, 'f8a924f7-65ca-49c2-af40-7e82b6f69ae6', 7, 287, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 16:33:49', '2026-09-26 16:35:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:33:49'),
(66, '5b37f3f8-7665-4049-af70-f8a29404e7a7', 7, 287, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 16:59:49', '2026-09-26 17:00:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:59:49'),
(67, '36d004e4-663c-4df9-a6e2-3e298d64295b', 7, 288, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 15:52:49', '2026-09-26 15:54:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 15:52:49'),
(68, 'e2c52c55-485a-434d-886a-4eeba1654e1c', 7, 288, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 16:25:49', '2026-09-26 16:26:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:25:49'),
(69, '5f46be70-be06-4175-9f85-14055545be6f', 7, 289, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 16:27:49', '2026-09-26 16:29:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:27:49'),
(70, '9c20c116-400b-41bd-88ab-ab75da903bbc', 7, 289, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 17:01:49', '2026-09-26 17:02:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 17:01:49'),
(71, '405c9556-9b58-41c2-82e8-550a8eef76c6', 8, 325, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 16:10:49', '2026-09-26 16:12:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:10:49'),
(72, 'fc1807f3-58dc-40a6-885b-927d8db4f7f2', 8, 325, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 16:44:49', '2026-09-26 16:45:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:44:49'),
(73, '63f71d79-b747-4d27-9b55-4b24262d3c9c', 8, 326, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 16:21:49', '2026-09-26 16:23:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:21:49'),
(74, '7c816722-edb6-4410-884f-e21e72ddf7d1', 8, 326, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 16:57:49', '2026-09-26 16:58:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:57:49'),
(75, '9296cd88-b1ed-4346-b820-77ff0350c12a', 8, 327, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 16:09:49', '2026-09-26 16:11:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:09:49'),
(76, '50f17df2-9d34-4830-a01d-cf0571876119', 8, 327, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 16:43:49', '2026-09-26 16:44:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:43:49'),
(77, '1793e529-d7c8-42f2-8e2d-f37d12a61d92', 8, 328, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 16:31:49', '2026-09-26 16:33:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:31:49'),
(78, 'e93be4ba-8904-4aad-80d3-c30aa9c7b990', 8, 328, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 16:57:49', '2026-09-26 16:58:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:57:49'),
(79, '555268e8-125d-4c5e-b754-e8582bcff3b7', 8, 329, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 15:57:49', '2026-09-26 15:59:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 15:57:49'),
(80, '2ffec789-d5b6-434e-b2f0-a6cc21a38aee', 8, 329, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 16:34:49', '2026-09-26 16:35:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:34:49'),
(81, '19d1fdbc-2d4f-48fc-a9ba-47d7c56259df', 9, 361, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 16:35:49', '2026-09-26 16:37:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:35:49'),
(82, '86b6d043-4565-4020-b3f3-d125efcda909', 9, 361, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 17:01:49', '2026-09-26 17:02:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 17:01:49'),
(83, '4ed88951-f6f7-4d04-afc9-820b0f9967bb', 9, 362, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 16:30:49', '2026-09-26 16:32:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:30:49'),
(84, '0e724fe1-c951-4303-b11e-21988c211676', 9, 362, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 17:06:49', '2026-09-26 17:07:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 17:06:49'),
(85, '223326c4-13d4-4360-9cd3-fc22cf9891ef', 9, 363, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 15:51:49', '2026-09-26 15:53:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 15:51:49'),
(86, '8a4c15a5-4c08-41c8-abb5-11e1bc66d290', 9, 363, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 16:16:49', '2026-09-26 16:17:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:16:49'),
(87, '5b08f43b-5fff-49f7-ab5c-464160e3894e', 9, 364, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 16:04:49', '2026-09-26 16:06:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:04:49'),
(88, 'eac6a19d-f1d7-419a-8401-737940c24a63', 9, 364, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 16:34:49', '2026-09-26 16:35:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:34:49'),
(89, '8b0e631d-cdf4-4532-a991-aa912aaa3982', 9, 365, 1, 'OCCUPIED', 'CLEANING', '2026-09-26 15:56:49', '2026-09-26 15:58:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 15:56:49'),
(90, '57e948c5-52e3-433d-be8f-79aec0e41bcc', 9, 365, 1, 'CLEANING', 'AVAILABLE', '2026-09-26 16:23:49', '2026-09-26 16:24:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:23:49'),
(91, 'c1f5f5a4-a79a-4227-af71-7b6862e0c9f8', 10, 397, 4, 'OCCUPIED', 'CLEANING', '2026-09-26 15:57:49', '2026-09-26 15:59:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 15:57:49'),
(92, '180ed3be-e9c8-468d-9e34-408a8b1fed58', 10, 397, 4, 'CLEANING', 'AVAILABLE', '2026-09-26 16:23:49', '2026-09-26 16:24:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:23:49'),
(93, '76e4d73c-bb10-4b3e-83f1-f146f7070ad2', 10, 398, 4, 'OCCUPIED', 'CLEANING', '2026-09-26 16:12:49', '2026-09-26 16:14:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:12:49'),
(94, '3ce2ad40-d06a-45d1-b2b9-4db1904d033a', 10, 398, 4, 'CLEANING', 'AVAILABLE', '2026-09-26 16:40:49', '2026-09-26 16:41:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:40:49'),
(95, '9a6ede9a-2882-4881-8796-b7ff09a49e7f', 10, 399, 4, 'OCCUPIED', 'CLEANING', '2026-09-26 15:52:49', '2026-09-26 15:54:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 15:52:49'),
(96, '1a25f946-e37d-4f43-9898-cc9d8a76517d', 10, 399, 4, 'CLEANING', 'AVAILABLE', '2026-09-26 16:26:49', '2026-09-26 16:27:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:26:49'),
(97, '347067db-8a44-46e8-9f62-8008b5f82c40', 10, 400, 4, 'OCCUPIED', 'CLEANING', '2026-09-26 16:00:49', '2026-09-26 16:02:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:00:49'),
(98, '6df44c02-425e-4d8f-8bfe-edf902ea4ccf', 10, 400, 4, 'CLEANING', 'AVAILABLE', '2026-09-26 16:29:49', '2026-09-26 16:30:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 16:29:49'),
(99, 'e678131b-4ed1-436f-b4ee-19d3b58784f2', 10, 401, 4, 'OCCUPIED', 'CLEANING', '2026-09-26 16:32:49', '2026-09-26 16:34:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Patient vacated — sanitization initiated', '2026-09-26 16:32:49'),
(100, 'd0b5157c-86f4-4c02-ab53-5604faaa99af', 10, 401, 4, 'CLEANING', 'AVAILABLE', '2026-09-26 17:03:49', '2026-09-26 17:04:49', 0, 0, NULL, 1, 'WEB_CONSOLE', 'Linen changed, ward sanitization verified', '2026-09-26 17:03:49');

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

--
-- Table structure for table `bed_movements`
--

CREATE TABLE `bed_movements` (
  `id` bigint UNSIGNED NOT NULL,
  `hospital_id` int NOT NULL,
  `admission_id` int NOT NULL,
  `from_bed_id` int DEFAULT NULL,
  `to_bed_id` int NOT NULL,
  `reason` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `moved_by_user_id` int NOT NULL,
  `moved_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `bed_recertifications`
--

CREATE TABLE `bed_recertifications` (
  `id` bigint UNSIGNED NOT NULL,
  `hospital_id` int NOT NULL,
  `certified_by` int NOT NULL,
  `registered_beds` int NOT NULL,
  `physical_beds_counted` int NOT NULL,
  `variance_count` int NOT NULL DEFAULT '0',
  `variance_percentage` decimal(10,2) NOT NULL DEFAULT '0.00',
  `has_discrepancy_alert` tinyint(1) NOT NULL DEFAULT '0',
  `quarter_period` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `certification_hash` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `declaration_statement` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `certified_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `bed_reservations`
--

CREATE TABLE `bed_reservations` (
  `id` bigint UNSIGNED NOT NULL,
  `bed_id` int NOT NULL,
  `hospital_id` int NOT NULL,
  `reservation_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'INTERNAL_ADMISSION',
  `ticket_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reserved_by_user_id` int DEFAULT NULL,
  `reserved_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `expires_at` datetime NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ACTIVE',
  `released_at` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `blocks`
--

CREATE TABLE `blocks` (
  `id` bigint UNSIGNED NOT NULL,
  `district_id` int NOT NULL,
  `name_en` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_hi` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lgd_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blocks`
--

INSERT INTO `blocks` (`id`, `district_id`, `name_en`, `name_hi`, `lgd_code`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 'Achhnera', 'अछनेरा', 'BLK-AGR-01', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(2, 1, 'Akola', 'अकोला', 'BLK-AGR-02', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(3, 1, 'Bah', 'बाह', 'BLK-AGR-03', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(4, 1, 'Barauli Ahir', 'बरौली अहीर', 'BLK-AGR-04', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(5, 1, 'Bichpuri', 'बिचपुरी', 'BLK-AGR-05', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(6, 1, 'Etmadpur', 'एत्मादपुर', 'BLK-AGR-06', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(7, 1, 'Fatehabad', 'फतेहाबाद', 'BLK-AGR-07', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(8, 1, 'Fatehpur Sikri', 'फतेहपुर सीकरी', 'BLK-AGR-08', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(9, 1, 'Jagner', 'जगनेर', 'BLK-AGR-09', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(10, 1, 'Kheragarh', 'खेरागढ़', 'BLK-AGR-10', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(11, 1, 'Khandauli', 'खंदौली', 'BLK-AGR-11', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(12, 1, 'Saiyan', 'सैयां', 'BLK-AGR-12', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(13, 1, 'Shamsabad', 'शमसाबाद', 'BLK-AGR-13', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(14, 1, 'Pinahat', 'पिनाहट', 'BLK-AGR-14', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(15, 1, 'Jaitpur Kalan', 'जैतपुर कलां', 'BLK-AGR-15', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL);

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

--
-- Table structure for table `cache`
--

CREATE TABLE `cache` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `category_snapshots`
--

CREATE TABLE `category_snapshots` (
  `id` bigint UNSIGNED NOT NULL,
  `hospital_id` int NOT NULL,
  `category_id` int NOT NULL,
  `total_beds` int NOT NULL DEFAULT '0',
  `available_beds` int NOT NULL DEFAULT '0',
  `reserved_beds` int NOT NULL DEFAULT '0',
  `occupied_beds` int NOT NULL DEFAULT '0',
  `cleaning_beds` int NOT NULL DEFAULT '0',
  `unavailable_beds` int NOT NULL DEFAULT '0',
  `expected_discharges_4h` int NOT NULL DEFAULT '0',
  `avg_cleaning_minutes` decimal(10,2) DEFAULT NULL,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `category_snapshots`
--

INSERT INTO `category_snapshots` (`id`, `hospital_id`, `category_id`, `total_beds`, `available_beds`, `reserved_beds`, `occupied_beds`, `cleaning_beds`, `unavailable_beds`, `expected_discharges_4h`, `avg_cleaning_minutes`, `updated_at`) VALUES
(1, 1, 1, 50, 17, 10, 19, 4, 0, 0, 36.40, '2026-09-26 17:20:49'),
(2, 1, 3, 6, 3, 0, 1, 2, 0, 0, NULL, '2026-09-26 17:20:49'),
(3, 1, 2, 10, 3, 2, 2, 3, 0, 0, NULL, '2026-09-26 17:20:49'),
(4, 1, 5, 6, 2, 1, 2, 1, 0, 0, NULL, '2026-09-26 17:20:49'),
(5, 1, 4, 6, 2, 0, 2, 2, 0, 0, NULL, '2026-09-26 17:20:49'),
(6, 2, 1, 40, 11, 5, 19, 5, 0, 0, 34.80, '2026-09-26 17:20:49'),
(7, 2, 3, 6, 2, 1, 3, 0, 0, 0, NULL, '2026-09-26 17:20:49'),
(8, 2, 2, 10, 7, 1, 2, 0, 0, 0, NULL, '2026-09-26 17:20:49'),
(9, 3, 1, 20, 3, 4, 7, 6, 0, 0, 33.20, '2026-09-26 17:20:49'),
(10, 3, 3, 6, 2, 0, 4, 0, 0, 0, NULL, '2026-09-26 17:20:49'),
(11, 3, 2, 10, 3, 2, 5, 0, 0, 0, NULL, '2026-09-26 17:20:49'),
(12, 4, 1, 20, 8, 3, 8, 1, 0, 0, 32.20, '2026-09-26 17:20:49'),
(13, 4, 3, 6, 2, 2, 2, 0, 0, 0, NULL, '2026-09-26 17:20:49'),
(14, 4, 2, 10, 4, 1, 5, 0, 0, 0, NULL, '2026-09-26 17:20:49'),
(15, 5, 3, 6, 2, 0, 2, 2, 0, 0, 33.40, '2026-09-26 17:20:49'),
(16, 5, 2, 10, 3, 3, 4, 0, 0, 0, NULL, '2026-09-26 17:20:49'),
(17, 5, 5, 6, 1, 1, 3, 1, 0, 0, NULL, '2026-09-26 17:20:49'),
(18, 5, 1, 20, 7, 2, 7, 4, 0, 0, NULL, '2026-09-26 17:20:49'),
(19, 6, 3, 6, 2, 0, 4, 0, 0, 0, 36.20, '2026-09-26 17:20:49'),
(20, 6, 2, 10, 3, 0, 5, 2, 0, 0, NULL, '2026-09-26 17:20:49'),
(21, 6, 1, 20, 7, 4, 8, 1, 0, 0, NULL, '2026-09-26 17:20:49'),
(22, 7, 1, 40, 16, 6, 16, 2, 0, 0, 32.40, '2026-09-26 17:20:49'),
(23, 8, 1, 20, 4, 3, 10, 3, 0, 0, 33.40, '2026-09-26 17:20:49'),
(24, 8, 3, 6, 3, 0, 2, 1, 0, 0, NULL, '2026-09-26 17:20:49'),
(25, 8, 2, 10, 6, 0, 3, 1, 0, 0, NULL, '2026-09-26 17:20:49'),
(26, 9, 1, 20, 10, 4, 4, 2, 0, 0, 28.80, '2026-09-26 17:20:49'),
(27, 9, 3, 6, 2, 0, 2, 2, 0, 0, NULL, '2026-09-26 17:20:49'),
(28, 9, 2, 10, 4, 0, 4, 2, 0, 0, NULL, '2026-09-26 17:20:49'),
(29, 10, 4, 6, 4, 0, 2, 0, 0, 0, 29.60, '2026-09-26 17:20:49'),
(30, 10, 1, 30, 11, 1, 13, 5, 0, 0, NULL, '2026-09-26 17:20:49');

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

--
-- Table structure for table `clinical_notes`
--

CREATE TABLE `clinical_notes` (
  `id` bigint UNSIGNED NOT NULL,
  `hospital_id` int NOT NULL,
  `admission_id` int NOT NULL,
  `note_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PROGRESS',
  `note_body` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `author_id` int NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `clinical_notes`
--

INSERT INTO `clinical_notes` (`id`, `hospital_id`, `admission_id`, `note_type`, `note_body`, `author_id`, `created_at`) VALUES
(1, 2, 1, 'ROUTINE', 'Patient afebrile for last 24h. Vitals: BP 120/80, SpO2 98% on room air. Plan for discharge tomorrow morning.', 21, '2026-09-26 13:20:49'),
(2, 2, 2, 'CRITICAL', 'Continuous vitals monitoring. ABG shows improving PaO2. Police memo generated for unknown identity trace.', 21, '2026-09-26 16:20:49');

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

--
-- Table structure for table `death_records`
--

CREATE TABLE `death_records` (
  `id` bigint UNSIGNED NOT NULL,
  `hospital_id` int NOT NULL,
  `admission_id` int NOT NULL,
  `patient_id` int NOT NULL,
  `certificate_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deceased_at` datetime NOT NULL,
  `immediate_cause` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `antecedent_cause` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `underlying_cause` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contributory_conditions` text COLLATE utf8mb4_unicode_ci,
  `manner_of_death` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'NATURAL',
  `pregnancy_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'NOT_APPLICABLE',
  `attending_physician_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `attending_physician_reg_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `verification_hash` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `departments`
--

CREATE TABLE `departments` (
  `id` bigint UNSIGNED NOT NULL,
  `hospital_id` int NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_en` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_hi` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `departments`
--

INSERT INTO `departments` (`id`, `hospital_id`, `code`, `name_en`, `name_hi`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 'MED', 'General Medicine', 'सामान्य चिकित्सा', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(2, 1, 'SURG', 'General Surgery', 'सामान्य शल्य चिकित्सा', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(3, 1, 'EMERG', 'Emergency & Trauma', 'आपातकालीन एवं आघात', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(4, 1, 'CARD', 'Cardiology', 'हृदय रोग विभाग', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(5, 1, 'PAED', 'Paediatrics & Neonatology', 'बाल एवं नवजात शिशु रोग', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(6, 2, 'MED', 'Medicine', 'चिकित्सा', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(7, 2, 'SURG', 'Surgery', 'शल्य चिकित्सा', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(8, 2, 'EMERG', 'Emergency', 'आपातकालीन', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(9, 3, 'IPD', 'Inpatient General', 'सामान्य अंतरंग वार्ड', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(10, 3, 'EMERG', 'Emergency 24x7', 'आपातकालीन कक्ष', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(11, 4, 'IPD', 'Inpatient General', 'सामान्य अंतरंग वार्ड', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(12, 4, 'EMERG', 'Emergency Room', 'आपातकालीन', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(13, 5, 'CRIT', 'Critical Care & ICU', 'गहन चिकित्सा इकाई', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(14, 5, 'CARD', 'Cardiology & ICCU', 'हृदय रोग एवं ICCU', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(15, 5, 'GEN', 'Multi-Specialty Wards', 'मल्टी स्पेशियलिटी वार्ड', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(16, 6, 'CRIT', 'Intensive Care', 'गहन चिकित्सा', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(17, 6, 'IPD', 'Inpatient Ward', 'अंतरंग वार्ड', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(18, 7, 'GEN', 'General Ward', 'सामान्य वार्ड', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(19, 7, 'ICU', 'ICU Unit', 'आईसीयू यूनिट', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(20, 8, 'GEN', 'General Ward', 'सामान्य वार्ड', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(21, 8, 'CRIT', 'Critical Care Unit', 'गहन चिकित्सा इकाई', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(22, 9, 'GEN', 'General Ward', 'सामान्य वार्ड', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(23, 9, 'CRIT', 'ICU Ward', 'आईसीयू वार्ड', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(24, 10, 'PAED', 'Paediatrics & NICU', 'बाल एवं एनआईसीयू', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(25, 10, 'IPD', 'Maternity Ward', 'प्रसूति वार्ड', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL);

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

--
-- Table structure for table `districts`
--

CREATE TABLE `districts` (
  `id` int NOT NULL,
  `division_id` int NOT NULL,
  `name_en` varchar(255) NOT NULL,
  `name_hi` varchar(255) NOT NULL,
  `lgd_code` varchar(255) NOT NULL,
  `lat` decimal(10,2) NOT NULL,
  `lng` decimal(10,2) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `districts`
--

INSERT INTO `districts` (`id`, `division_id`, `name_en`, `name_hi`, `lgd_code`, `lat`, `lng`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 'Agra', 'आगरा', 'DIS-129', 27.1767, 78.0081, '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL);


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

--
-- Table structure for table `divisions`
--

CREATE TABLE `divisions` (
  `id` bigint UNSIGNED NOT NULL,
  `name_en` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_hi` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lgd_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `divisions`
--

INSERT INTO `divisions` (`id`, `name_en`, `name_hi`, `lgd_code`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Agra', 'आगरा', 'DIV-01', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL);


--

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

--
-- Table structure for table `elective_bookings`
--

CREATE TABLE `elective_bookings` (
  `id` bigint UNSIGNED NOT NULL,
  `booking_reference` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `hospital_id` int NOT NULL,
  `patient_id` int NOT NULL,
  `category_id` int NOT NULL,
  `booking_date` date NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'CONFIRMED',
  `held_bed_id` int DEFAULT NULL,
  `held_at` datetime DEFAULT NULL,
  `admitted_at` datetime DEFAULT NULL,
  `released_at` datetime DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `expected_discharges`
--

CREATE TABLE `expected_discharges` (
  `id` bigint UNSIGNED NOT NULL,
  `hospital_id` int NOT NULL,
  `category_id` int NOT NULL,
  `likely_discharges_count` int NOT NULL DEFAULT '0',
  `forecast_for_hours` int NOT NULL DEFAULT '4',
  `forecast_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `reported_by_user_id` int DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `expected_discharges`
--

INSERT INTO `expected_discharges` (`id`, `hospital_id`, `category_id`, `likely_discharges_count`, `forecast_for_hours`, `forecast_at`, `reported_by_user_id`, `created_at`, `updated_at`) VALUES
(1, 2, 1, 5, 4, '2026-09-26 17:20:49', 21, '2026-09-26 17:20:49', '2026-09-26 17:20:49');

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `heartbeats`
--

CREATE TABLE `heartbeats` (
  `id` bigint UNSIGNED NOT NULL,
  `hospital_id` int NOT NULL,
  `source` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'HIS_INTEGRATION',
  `ip_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ONLINE',
  `last_seen_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `helpdesk_tickets`
--

CREATE TABLE `helpdesk_tickets` (
  `id` bigint UNSIGNED NOT NULL,
  `ticket_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `hospital_id` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `assigned_to` int DEFAULT NULL,
  `category` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'GENERAL',
  `priority` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'MEDIUM',
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'OPEN',
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `resolution_notes` text COLLATE utf8mb4_unicode_ci,
  `resolved_at` datetime DEFAULT NULL,
  `closed_at` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `hospitals`
--

CREATE TABLE `hospitals` (
  `id` int NOT NULL,
  `hfr_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_hi` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'GOVERNMENT',
  `facility_level` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'CHC',
  `registered_beds` int NOT NULL DEFAULT '0',
  `lat` decimal(10,2) NOT NULL,
  `lng` decimal(10,2) NOT NULL,
  `district_id` int NOT NULL,
  `block_id` bigint UNSIGNED DEFAULT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `connection_mode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'MODULE',
  `api_token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_person` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `last_heartbeat_at` datetime DEFAULT NULL,
  `data_quality_score` decimal(10,2) NOT NULL DEFAULT '100.00',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hospitals`
--

INSERT INTO `hospitals` (`id`, `hfr_id`, `name_en`, `name_hi`, `type`, `facility_level`, `registered_beds`, `lat`, `lng`, `district_id`, `block_id`, `address`, `connection_mode`, `api_token`, `contact_person`, `contact_phone`, `is_active`, `last_heartbeat_at`, `data_quality_score`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'UP-AGR-001', 'Sarojini Naidu Medical College (SNMC) (Demo)', 'सरोजिनी नायडू मेडिकल कॉलेज (SNMC) (डेमो)', 'GOVERNMENT', 'MEDICAL_COLLEGE', 1000, 27.19, 78.00, 1, NULL, 'Moti Katra, Mantola, Agra, Uttar Pradesh 282002', 'MODULE', '1HpFjAQPsbQDKzThDxdSzYgvu78nyXWUDfvhbVps', 'Dr. Prashant Gupta (Principal/CMS)', '0562-2260353', 1, '2026-09-26 16:45:42', 100.00, '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(2, 'UP-AGR-002', 'District Hospital Agra (Pt. Deen Dayal Upadhyaya Hospital) (Demo)', 'जिला चिकित्सालय आगरा (पं. दीनदयाल उपाध्याय चिकित्सालय) (डेमो)', 'GOVERNMENT', 'DISTRICT_HOSPITAL', 300, 27.19, 78.01, 1, NULL, 'Near Collectorate, Agra, Uttar Pradesh 282001', 'MODULE', 'crmlN9SGYdL8jTG4xUWljQT6FbGwlTkLTnRjsvF0', 'Dr. A.K. Sharma (CMS)', '0562-2420102', 1, '2026-09-26 17:18:42', 100.00, '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(3, 'UP-AGR-003', 'Community Health Centre (CHC) Fatehabad (Demo)', 'सामुदायिक स्वास्थ्य केंद्र (CHC) फतेहाबाद (डेमो)', 'GOVERNMENT', 'CHC', 30, 27.02, 78.31, 1, 7, 'Bypass Road, Fatehabad, Agra, UP 283111', 'MODULE', 'v7wFUGEevhztBrvKWO4QKG6Zn1knULqC82uLRXUL', 'Dr. R.K. Verma (MOIC)', '9412000001', 1, '2026-09-26 17:03:42', 100.00, '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(4, 'UP-AGR-004', 'Community Health Centre (CHC) Achhnera (Demo)', 'सामुदायिक स्वास्थ्य केंद्र (CHC) अछनेरा (डेमो)', 'GOVERNMENT', 'CHC', 30, 27.18, 77.76, 1, 1, 'Main Road, Achhnera, Agra, UP 283101', 'MODULE', '6TSdo7T2GDhoyh5KIOvLFCLWxSdTfuopEjWVLrFS', 'Dr. V.S. Yadav (MOIC)', '9412000002', 1, '2026-09-26 17:13:42', 100.00, '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(5, 'UP-AGR-005', 'Pushpanjali Hospital & Research Centre (Demo)', 'पुष्पांजलि हॉस्पिटल एवं रिसर्च सेन्टर (डेमो)', 'PRIVATE', 'PRIVATE_SUPER_SPECIALTY', 250, 27.16, 78.02, 1, NULL, 'Delhi Gate, Agra, Uttar Pradesh 282002', 'API', 'FHb6sVA0tFeCeL1A1XC4CEEfqk5Dxq0rPfzGocMK', 'Dr. V.D. Agarwal (Director)', '0562-2520000', 1, '2026-09-26 16:50:42', 100.00, '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(6, 'UP-AGR-006', 'Synergy Plus Hospital (Demo)', 'सिनर्जी प्लस हॉस्पिटल (डेमो)', 'PRIVATE', 'PRIVATE_HOSPITAL', 150, 27.16, 77.99, 1, NULL, 'NH-19, Sikandra, Agra, Uttar Pradesh 282007', 'MODULE', 'syoNKH0T8Uddr73BccUbjxBzZjA193clmb4Kr11I', 'Dr. M.K. Singhal', '0562-2601000', 1, '2026-09-26 17:01:42', 100.00, '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(7, 'UP-AGR-007', 'Lotus Super Speciality Hospital (Demo)', 'लोटस सुपर स्पेशियलिटी हॉस्पिटल (डेमो)', 'PRIVATE', 'PRIVATE_HOSPITAL', 100, 27.21, 78.02, 1, 6, 'Khandauli Road, Etmadpur, Agra, UP 283202', 'MODULE', 'LfdpeOSsW6kvWRDYD1Aeve3vY1D8ImuSEQo8szwT', 'Dr. Neeraj Tomar', '0562-2802000', 1, '2026-09-26 16:46:42', 100.00, '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(8, 'UP-AGR-008', 'Yamuna Care Hospital (Demo)', 'यमुना केयर हॉस्पिटल (डेमो)', 'PRIVATE', 'PRIVATE_HOSPITAL', 120, 27.18, 78.01, 1, NULL, 'Yamuna Kinara Road, Agra, UP 282004', 'MODULE', 'TBCeEFjIzxQs4Xs5VnoAnokNrK84RmpQhqZIqhVT', 'Dr. S.K. Bansal', '0562-2303000', 1, '2026-09-26 17:03:43', 100.00, '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(9, 'UP-AGR-009', 'Shanti Hospital (Demo)', 'शांति हॉस्पिटल (डेमो)', 'PRIVATE', 'PRIVATE_HOSPITAL', 80, 27.20, 78.03, 1, NULL, 'Trans-Yamuna Colony, Agra, UP 282006', 'MODULE', 'QCYl512TGL0cCGRR44s6niU6adMhOlVGs2xVcyXq', 'Dr. R.P. Mishra', '0562-2404000', 1, '2026-09-26 17:11:43', 100.00, '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(10, 'UP-AGR-010', 'Agra Mother & Child Hospital (Demo)', 'आगरा मातृ एवं शिशु चिकित्सालय (डेमो)', 'GOVERNMENT', 'DISTRICT_HOSPITAL', 150, 27.17, 77.99, 1, NULL, 'Fatehabad Road, Agra, UP 282001', 'MODULE', 'ZopcVHNTng5J2Z2osiP1EYUuMvV30iNaqtEfsA0I', 'Dr. Anita Gautam', '0562-2505000', 1, '2026-09-26 17:05:43', 100.00, '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL);

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` int NOT NULL,
  `reserved_at` int DEFAULT NULL,
  `available_at` int NOT NULL,
  `created_at` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` text COLLATE utf8mb4_unicode_ci,
  `cancelled_at` int DEFAULT NULL,
  `created_at` int NOT NULL,
  `finished_at` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` bigint UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2026_09_26_000001_create_geography_tables', 1),
(5, '2026_09_26_000002_create_hospitals_and_pmjay_tables', 1),
(6, '2026_09_26_000003_create_departments_wards_and_beds_tables', 1),
(7, '2026_09_26_000004_create_rosters_configs_and_audit_tables', 1),
(8, '2026_09_26_000005_create_clinical_store_tables', 1),
(9, '2026_09_26_000006_create_bed_events_and_snapshots_tables', 1),
(10, '2026_09_26_000007_create_unmet_demands_table', 1),
(11, '2026_09_26_000008_create_heartbeats_and_forecasts_tables', 1),
(12, '2026_09_26_000009_create_referral_tickets_table', 1),
(13, '2026_09_26_000010_create_system_alerts_table', 1),
(14, '2026_09_26_000011_create_spot_checks_table', 1),
(15, '2026_09_26_000012_create_phase9_statewide_and_dispatch_tables', 1),
(16, '2026_09_26_000013_create_sms_notifications_table', 1),
(17, '2026_09_26_000014_create_helpdesk_tickets_table', 1),
(18, '2026_09_26_000015_create_surge_activations_table', 1),
(19, '2026_09_26_000016_create_bed_recertifications_table', 1),
(20, '2026_09_26_000017_create_death_records_table', 1),
(21, '2026_09_26_072736_create_personal_access_tokens_table', 1);

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

--
-- Table structure for table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `patients` (
  `id` bigint UNSIGNED NOT NULL,
  `hospital_id` int NOT NULL,
  `uhid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abha_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `age` int NOT NULL,
  `sex` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `is_temporary` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `patients` (`id`, `hospital_id`, `uhid`, `abha_number`, `name`, `age`, `sex`, `contact_number`, `address`, `is_temporary`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 2, 'UP-AGR-002-2026-0001', NULL, 'Demo Patient Ramesh Kumar', 45, 'M', '9876543210', 'Demo Mohalla, Agra', 0, '2026-09-26 17:20:49', '2026-09-26 17:20:49', NULL),
(2, 2, 'UP-AGR-002-2026-0002', NULL, 'Demo Patient Sunita Sharma', 38, 'F', '9876543211', 'Demo Colony, Agra', 0, '2026-09-26 17:20:49', '2026-09-26 17:20:49', NULL),
(3, 2, 'UP-AGR-002-2026-0003', NULL, 'Demo Patient Unknown Male 50', 50, 'M', NULL, 'Emergency Trauma Intake, Agra', 1, '2026-09-26 17:20:49', '2026-09-26 17:20:49', NULL),
(4, 2, 'UP-AGR-002-2026-0004', NULL, 'Demo Patient Anita Devi', 29, 'F', '9876543212', 'Fatehabad Road, Agra', 0, '2026-09-26 17:20:49', '2026-09-26 17:20:49', NULL),
(5, 2, 'UP-AGR-002-2026-0005', NULL, 'Demo Patient Suresh Verma', 64, 'M', '9876543213', 'Kamla Nagar, Agra', 0, '2026-09-26 17:20:49', '2026-09-26 17:20:49', NULL);

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

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint UNSIGNED NOT NULL,
  `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` int NOT NULL,
  `name` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci,
  `last_used_at` datetime DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `pmjay_tags`
--

CREATE TABLE `pmjay_tags` (
  `id` bigint UNSIGNED NOT NULL,
  `hospital_id` int NOT NULL,
  `pmjay_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'EMPANELLED',
  `specialties` text COLLATE utf8mb4_unicode_ci,
  `last_verified_at` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pmjay_tags`
--

INSERT INTO `pmjay_tags` (`id`, `hospital_id`, `pmjay_id`, `status`, `specialties`, `last_verified_at`, `created_at`, `updated_at`) VALUES
(1, 1, 'PMJAY-UP-0012', 'EMPANELLED', '[\"General Medicine\",\"General Surgery\",\"Cardiology\",\"Neurosurgery\",\"Paediatrics\",\"Orthopaedics\"]', '2026-09-24 17:20:42', '2026-09-26 17:20:42', '2026-09-26 17:20:42'),
(2, 2, 'PMJAY-UP-0045', 'EMPANELLED', '[\"General Medicine\",\"General Surgery\",\"Paediatrics\",\"Gynaecology\"]', '2026-09-24 17:20:42', '2026-09-26 17:20:42', '2026-09-26 17:20:42'),
(3, 3, 'PMJAY-UP-0108', 'EMPANELLED', '[\"General Medicine\",\"Obstetrics & Gynaecology\"]', '2026-09-24 17:20:42', '2026-09-26 17:20:42', '2026-09-26 17:20:42'),
(4, 4, 'PMJAY-UP-0112', 'EMPANELLED', '[\"General Medicine\"]', '2026-09-24 17:20:42', '2026-09-26 17:20:42', '2026-09-26 17:20:42'),
(5, 5, 'PMJAY-UP-PVT-081', 'EMPANELLED', '[\"Cardiology\",\"Neurosurgery\",\"Nephrology\",\"Critical Care\",\"Orthopaedics\"]', '2026-09-24 17:20:42', '2026-09-26 17:20:42', '2026-09-26 17:20:42'),
(6, 6, 'PMJAY-UP-PVT-094', 'EMPANELLED', '[\"General Surgery\",\"General Medicine\",\"Critical Care\"]', '2026-09-24 17:20:42', '2026-09-26 17:20:42', '2026-09-26 17:20:42'),
(7, 7, 'PMJAY-UP-PVT-115', 'UNVERIFIED', '[\"General Medicine\",\"Paediatrics\"]', '2026-09-16 17:20:42', '2026-09-26 17:20:42', '2026-09-26 17:20:42'),
(8, 8, 'PMJAY-UP-PVT-130', 'EMPANELLED', '[\"General Medicine\",\"Critical Care\",\"Orthopaedics\"]', '2026-09-24 17:20:43', '2026-09-26 17:20:43', '2026-09-26 17:20:43'),
(9, 9, 'PMJAY-UP-PVT-142', 'EMPANELLED', '[\"General Medicine\",\"Critical Care\"]', '2026-09-24 17:20:43', '2026-09-26 17:20:43', '2026-09-26 17:20:43'),
(10, 10, 'PMJAY-UP-0155', 'EMPANELLED', '[\"Obstetrics & Gynaecology\",\"Paediatrics & Neonatology\"]', '2026-09-24 17:20:43', '2026-09-26 17:20:43', '2026-09-26 17:20:43');

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

--
-- Table structure for table `referral_links`
--

CREATE TABLE `referral_links` (
  `id` bigint UNSIGNED NOT NULL,
  `hospital_id` int NOT NULL,
  `ticket_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `admission_id` int NOT NULL,
  `link_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `referral_tickets`
--

CREATE TABLE `referral_tickets` (
  `id` int NOT NULL,
  `ticket_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `from_hospital_id` int NOT NULL,
  `to_hospital_id` int DEFAULT NULL,
  `category_id` int NOT NULL,
  `specialty` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `urgency` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'URGENT',
  `age_band` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ADULT',
  `sex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `oxygen_need` tinyint(1) NOT NULL DEFAULT '0',
  `ventilator_need` tinyint(1) NOT NULL DEFAULT '0',
  `pmjay_beneficiary` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'NOT_KNOWN',
  `clinical_reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RAISED',
  `reserved_bed_id` int DEFAULT NULL,
  `reservation_id` bigint UNSIGNED DEFAULT NULL,
  `offered_at` datetime DEFAULT NULL,
  `sla_minutes` int NOT NULL DEFAULT '30',
  `sla_expires_at` datetime DEFAULT NULL,
  `accepted_at` datetime DEFAULT NULL,
  `accepted_by_user_id` int DEFAULT NULL,
  `declined_at` datetime DEFAULT NULL,
  `declined_by_user_id` int DEFAULT NULL,
  `decline_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `decline_notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `departed_at` datetime DEFAULT NULL,
  `arrived_at` datetime DEFAULT NULL,
  `eta_at` datetime DEFAULT NULL,
  `escalation_level` int NOT NULL DEFAULT '0',
  `escalated_at` datetime DEFAULT NULL,
  `life_at_risk_override` tinyint(1) NOT NULL DEFAULT '0',
  `override_by_user_id` int DEFAULT NULL,
  `override_reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_by_user_id` int DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `referral_tickets`
--

INSERT INTO `referral_tickets` (`id`, `ticket_no`, `from_hospital_id`, `to_hospital_id`, `category_id`, `specialty`, `urgency`, `age_band`, `sex`, `oxygen_need`, `ventilator_need`, `pmjay_beneficiary`, `clinical_reason`, `status`, `reserved_bed_id`, `reservation_id`, `offered_at`, `sla_minutes`, `sla_expires_at`, `accepted_at`, `accepted_by_user_id`, `declined_at`, `declined_by_user_id`, `decline_reason`, `decline_notes`, `departed_at`, `arrived_at`, `eta_at`, `escalation_level`, `escalated_at`, `life_at_risk_override`, `override_by_user_id`, `override_reason`, `created_by_user_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'REF-UP-AGR-001-2026-0001', 3, 2, 3, 'Critical Care & ICU', 'CRITICAL', '40-60', 'M', 1, 1, 'YES', 'Acute respiratory distress syndrome secondary to severe pneumonia. CHC Fatehabad has no ICU bed.', 'OFFERED', NULL, NULL, '2026-09-26 17:17:49', 10, '2026-09-26 17:27:49', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '2026-09-26 17:20:49', '2026-09-26 17:20:49', NULL),
(2, 'REF-UP-AGR-002-2026-0002', 2, 1, 2, 'General Medicine', 'URGENT', '20-40', 'F', 1, 0, 'NO', 'Post-operative monitoring required in tertiary HDU facility.', 'ACCEPTED', NULL, NULL, '2026-09-26 17:00:49', 30, NULL, '2026-09-26 17:10:49', 21, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '2026-09-26 17:20:49', '2026-09-26 17:20:49', NULL),
(3, 'REF-UP-AGR-003-2026-0003', 2, 1, 3, 'Cardiology & ICCU', 'CRITICAL', '60+', 'M', 1, 1, 'YES', 'Acute anterior wall STEMI with cardiogenic shock. En route via 108 ALS ambulance.', 'IN_TRANSIT', NULL, NULL, '2026-09-26 16:55:49', 10, NULL, '2026-09-26 17:02:49', NULL, NULL, NULL, NULL, NULL, '2026-09-26 17:08:49', NULL, '2026-09-26 17:30:49', 0, NULL, 0, NULL, NULL, NULL, '2026-09-26 17:20:49', '2026-09-26 17:20:49', NULL);

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

--
-- Table structure for table `rosters`
--

CREATE TABLE `rosters` (
  `id` bigint UNSIGNED NOT NULL,
  `hospital_id` int NOT NULL,
  `shift_date` date NOT NULL,
  `shift_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bed_manager_id` int NOT NULL,
  `backup_id` int DEFAULT NULL,
  `notes` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rosters`
--

INSERT INTO `rosters` (`id`, `hospital_id`, `shift_date`, `shift_name`, `bed_manager_id`, `backup_id`, `notes`, `created_at`, `updated_at`) VALUES
(1, 2, '2026-09-26', 'MORNING', 23, 23, 'General morning round and referral desk duty', '2026-09-26 17:20:48', '2026-09-26 17:20:48'),
(2, 1, '2026-09-26', 'MORNING', 7, 8, 'General morning round and referral desk duty', '2026-09-26 17:20:48', '2026-09-26 17:20:48');

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int DEFAULT NULL,
  `ip_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('hB9ZrRazX18oJ6N2TjNng13by3La7wEWbQiLgYv4', NULL, '127.0.0.1', '', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibjl4Zld5R3dMUWhKbUlkelBmSVVOSzNxU2lOS3hkeGtuUGFDVlp4ViI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mjg6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9tYW51YWwiO3M6NToicm91dGUiO3M6MTI6Im1hbnVhbC5pbmRleCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1790484065),
('qQEdldliDs9CiacGVMLwZcqx6B101nBA1n1ArV98', 9, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/153.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoidHNoUGc3YXVRWWt2dkN1Z0hwTHZuZVQ3aVpwbFFsWkVIS2gxSU10MyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDc6Imh0dHA6Ly9sb2NhbGhvc3QvU2F5eWFfc2V0dS9wdWJsaWMvd2FyZC9iZWRzaWRlIjtzOjU6InJvdXRlIjtzOjE4OiJ3YXJkLmJlZHNpZGUuaW5kZXgiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aTo5O30=', 1790485342);

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

--
-- Table structure for table `sms_notifications`
--

CREATE TABLE `sms_notifications` (
  `id` bigint UNSIGNED NOT NULL,
  `recipient_phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `template_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notification_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message_body` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'SENT',
  `gateway_ref` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hospital_id` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `sent_at` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `spot_checks`
--

CREATE TABLE `spot_checks` (
  `id` bigint UNSIGNED NOT NULL,
  `hospital_id` int NOT NULL,
  `ward_id` int NOT NULL,
  `category_id` int NOT NULL,
  `physical_count` int NOT NULL,
  `system_count` int NOT NULL,
  `variance_percent` decimal(10,2) NOT NULL DEFAULT '0.00',
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'MATCHED',
  `conducted_by_user_id` int NOT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `surge_activations`
--

CREATE TABLE `surge_activations` (
  `id` bigint UNSIGNED NOT NULL,
  `hospital_id` int NOT NULL,
  `activated_by` int NOT NULL,
  `deactivated_by` int DEFAULT NULL,
  `reason` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `target_ward_id` int DEFAULT NULL,
  `beds_converted_count` int NOT NULL DEFAULT '0',
  `converted_bed_map` text COLLATE utf8mb4_unicode_ci,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ACTIVE',
  `activated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `deactivated_at` datetime DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `surge_activations`
--

INSERT INTO `surge_activations` (`id`, `hospital_id`, `activated_by`, `deactivated_by`, `reason`, `target_ward_id`, `beds_converted_count`, `converted_bed_map`, `status`, `activated_at`, `deactivated_at`, `notes`, `created_at`, `updated_at`) VALUES
(1, 2, 19, NULL, 'EPIDEMIC_SURGE', 10, 10, '[{\"bed_id\":1,\"from\":\"GENERAL\",\"to\":\"HDU\"},{\"bed_id\":2,\"from\":\"GENERAL\",\"to\":\"HDU\"}]', 'ACTIVE', '2026-09-26 15:20:49', NULL, 'Seasonal dengue and viral outbreak surge mode active in accordance with DG Health protocol.', '2026-09-26 17:20:49', '2026-09-26 17:20:49');

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

--
-- Table structure for table `system_alerts`
--

CREATE TABLE `system_alerts` (
  `id` bigint UNSIGNED NOT NULL,
  `district_id` int NOT NULL,
  `hospital_id` int DEFAULT NULL,
  `category_id` int DEFAULT NULL,
  `alert_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `severity` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'WARNING',
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `metadata` text COLLATE utf8mb4_unicode_ci,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'OPEN',
  `acknowledged_at` datetime DEFAULT NULL,
  `acknowledged_by_user_id` int DEFAULT NULL,
  `resolved_at` datetime DEFAULT NULL,
  `resolved_by_user_id` int DEFAULT NULL,
  `resolution_notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `system_alerts`
--

INSERT INTO `system_alerts` (`id`, `district_id`, `hospital_id`, `category_id`, `alert_type`, `severity`, `title`, `message`, `metadata`, `status`, `acknowledged_at`, `acknowledged_by_user_id`, `resolved_at`, `resolved_by_user_id`, `resolution_notes`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 2, 3, 'CAPACITY_CRITICAL', 'CRITICAL', 'गंभीर आईसीयू शैया तनाव — जिला चिकित्सालय आगरा (Demo)', 'जिला चिकित्सालय आगरा में आईसीयू शैया रिक्ति 10% से नीचे पहुंच गई है। आपातकालीन रेफरल डायवर्जन सक्रिय करें।', NULL, 'RESOLVED', NULL, NULL, '2026-09-26 17:24:58', NULL, 'स्वचालित समाधान: रिक्त शैयाएं उपलब्ध हो गई हैं।', '2026-09-26 17:05:49', '2026-09-26 17:24:58', NULL),
(2, 1, 1, 2, 'CAPACITY_WARNING', 'WARNING', 'एचडीयू शैया चेतावनी — एसएन मेडिकल कॉलेज (Demo)', 'एसएन मेडिकल कॉलेज में एचडीयू श्रेणी शैया रिक्ति 20% से नीचे है। स्वच्छता चक्र को त्वरित किया जाए।', NULL, 'RESOLVED', NULL, NULL, '2026-09-26 17:24:58', NULL, 'स्वचालित समाधान: रिक्त शैयाएं उपलब्ध हो गई हैं।', '2026-09-26 16:40:49', '2026-09-26 17:24:58', NULL),
(3, 1, 1, NULL, 'STALE_DATA', 'WARNING', 'डेटा अप्रचलन एवं कनेक्टिविटी बाधित: सरोजिनी नायडू मेडिकल कॉलेज (SNMC) (डेमो)', 'अस्पताल सरोजिनी नायडू मेडिकल कॉलेज (SNMC) (डेमो) (HFR: UP-AGR-001) से 4 घंटे से अधिक समय से कोई डेटा प्राप्त नहीं हुआ है। वास्तविक शैया स्थिति की पुष्टि करें।', '{\"hfr_id\":\"UP-AGR-001\",\"last_heartbeat_at\":\"2026-09-26T16:45:42+00:00\"}', 'OPEN', NULL, NULL, NULL, NULL, NULL, '2026-09-26 17:24:57', '2026-09-26 17:24:57', NULL),
(4, 1, 3, 1, 'CAPACITY_WARNING', 'WARNING', 'क्षमता दबाव चेतावनी: सामुदायिक स्वास्थ्य केंद्र (CHC) फतेहाबाद (डेमो) (सामान्य वार्ड शैया)', 'सामुदायिक स्वास्थ्य केंद्र (CHC) फतेहाबाद (डेमो) में सामान्य वार्ड शैया क्षमता 80% से अधिक भर चुकी है (3/20 रिक्त)।', '{\"total_beds\":20,\"available_beds\":3,\"category_code\":\"GENERAL\"}', 'OPEN', NULL, NULL, NULL, NULL, NULL, '2026-09-26 17:24:58', '2026-09-26 17:24:58', NULL),
(5, 1, 5, NULL, 'STALE_DATA', 'WARNING', 'डेटा अप्रचलन एवं कनेक्टिविटी बाधित: पुष्पांजलि हॉस्पिटल एवं रिसर्च सेन्टर (डेमो)', 'अस्पताल पुष्पांजलि हॉस्पिटल एवं रिसर्च सेन्टर (डेमो) (HFR: UP-AGR-005) से 4 घंटे से अधिक समय से कोई डेटा प्राप्त नहीं हुआ है। वास्तविक शैया स्थिति की पुष्टि करें।', '{\"hfr_id\":\"UP-AGR-005\",\"last_heartbeat_at\":\"2026-09-26T16:50:42+00:00\"}', 'OPEN', NULL, NULL, NULL, NULL, NULL, '2026-09-26 17:24:58', '2026-09-26 17:24:58', NULL),
(6, 1, 5, 5, 'CAPACITY_WARNING', 'WARNING', 'क्षमता दबाव चेतावनी: पुष्पांजलि हॉस्पिटल एवं रिसर्च सेन्टर (डेमो) (गहन कोरोनरी देखभाल इकाई (ICCU))', 'पुष्पांजलि हॉस्पिटल एवं रिसर्च सेन्टर (डेमो) में गहन कोरोनरी देखभाल इकाई (ICCU) क्षमता 80% से अधिक भर चुकी है (1/6 रिक्त)।', '{\"total_beds\":6,\"available_beds\":1,\"category_code\":\"ICCU\"}', 'OPEN', NULL, NULL, NULL, NULL, NULL, '2026-09-26 17:24:58', '2026-09-26 17:24:58', NULL),
(7, 1, 7, NULL, 'STALE_DATA', 'WARNING', 'डेटा अप्रचलन एवं कनेक्टिविटी बाधित: लोटस सुपर स्पेशियलिटी हॉस्पिटल (डेमो)', 'अस्पताल लोटस सुपर स्पेशियलिटी हॉस्पिटल (डेमो) (HFR: UP-AGR-007) से 4 घंटे से अधिक समय से कोई डेटा प्राप्त नहीं हुआ है। वास्तविक शैया स्थिति की पुष्टि करें।', '{\"hfr_id\":\"UP-AGR-007\",\"last_heartbeat_at\":\"2026-09-26T16:46:42+00:00\"}', 'OPEN', NULL, NULL, NULL, NULL, NULL, '2026-09-26 17:24:58', '2026-09-26 17:24:58', NULL),
(8, 1, 2, NULL, 'STALE_DATA', 'WARNING', 'डेटा अप्रचलन एवं कनेक्टिविटी बाधित: जिला चिकित्सालय आगरा (पं. दीनदयाल उपाध्याय चिकित्सालय) (डेमो)', 'अस्पताल जिला चिकित्सालय आगरा (पं. दीनदयाल उपाध्याय चिकित्सालय) (डेमो) (HFR: UP-AGR-002) से 4 घंटे से अधिक समय से कोई डेटा प्राप्त नहीं हुआ है। वास्तविक शैया स्थिति की पुष्टि करें।', '{\"hfr_id\":\"UP-AGR-002\",\"last_heartbeat_at\":\"2026-09-26T17:18:42+00:00\"}', 'OPEN', NULL, NULL, NULL, NULL, NULL, '2026-09-27 01:45:35', '2026-09-27 01:45:35', NULL),
(9, 1, 3, NULL, 'STALE_DATA', 'WARNING', 'डेटा अप्रचलन एवं कनेक्टिविटी बाधित: सामुदायिक स्वास्थ्य केंद्र (CHC) फतेहाबाद (डेमो)', 'अस्पताल सामुदायिक स्वास्थ्य केंद्र (CHC) फतेहाबाद (डेमो) (HFR: UP-AGR-003) से 4 घंटे से अधिक समय से कोई डेटा प्राप्त नहीं हुआ है। वास्तविक शैया स्थिति की पुष्टि करें।', '{\"hfr_id\":\"UP-AGR-003\",\"last_heartbeat_at\":\"2026-09-26T17:03:42+00:00\"}', 'OPEN', NULL, NULL, NULL, NULL, NULL, '2026-09-27 01:45:35', '2026-09-27 01:45:35', NULL),
(10, 1, 4, NULL, 'STALE_DATA', 'WARNING', 'डेटा अप्रचलन एवं कनेक्टिविटी बाधित: सामुदायिक स्वास्थ्य केंद्र (CHC) अछनेरा (डेमो)', 'अस्पताल सामुदायिक स्वास्थ्य केंद्र (CHC) अछनेरा (डेमो) (HFR: UP-AGR-004) से 4 घंटे से अधिक समय से कोई डेटा प्राप्त नहीं हुआ है। वास्तविक शैया स्थिति की पुष्टि करें।', '{\"hfr_id\":\"UP-AGR-004\",\"last_heartbeat_at\":\"2026-09-26T17:13:42+00:00\"}', 'OPEN', NULL, NULL, NULL, NULL, NULL, '2026-09-27 01:45:35', '2026-09-27 01:45:35', NULL),
(11, 1, 6, NULL, 'STALE_DATA', 'WARNING', 'डेटा अप्रचलन एवं कनेक्टिविटी बाधित: सिनर्जी प्लस हॉस्पिटल (डेमो)', 'अस्पताल सिनर्जी प्लस हॉस्पिटल (डेमो) (HFR: UP-AGR-006) से 4 घंटे से अधिक समय से कोई डेटा प्राप्त नहीं हुआ है। वास्तविक शैया स्थिति की पुष्टि करें।', '{\"hfr_id\":\"UP-AGR-006\",\"last_heartbeat_at\":\"2026-09-26T17:01:42+00:00\"}', 'OPEN', NULL, NULL, NULL, NULL, NULL, '2026-09-27 01:45:35', '2026-09-27 01:45:35', NULL),
(12, 1, 8, NULL, 'STALE_DATA', 'WARNING', 'डेटा अप्रचलन एवं कनेक्टिविटी बाधित: यमुना केयर हॉस्पिटल (डेमो)', 'अस्पताल यमुना केयर हॉस्पिटल (डेमो) (HFR: UP-AGR-008) से 4 घंटे से अधिक समय से कोई डेटा प्राप्त नहीं हुआ है। वास्तविक शैया स्थिति की पुष्टि करें।', '{\"hfr_id\":\"UP-AGR-008\",\"last_heartbeat_at\":\"2026-09-26T17:03:43+00:00\"}', 'OPEN', NULL, NULL, NULL, NULL, NULL, '2026-09-27 01:45:35', '2026-09-27 01:45:35', NULL),
(13, 1, 9, NULL, 'STALE_DATA', 'WARNING', 'डेटा अप्रचलन एवं कनेक्टिविटी बाधित: शांति हॉस्पिटल (डेमो)', 'अस्पताल शांति हॉस्पिटल (डेमो) (HFR: UP-AGR-009) से 4 घंटे से अधिक समय से कोई डेटा प्राप्त नहीं हुआ है। वास्तविक शैया स्थिति की पुष्टि करें।', '{\"hfr_id\":\"UP-AGR-009\",\"last_heartbeat_at\":\"2026-09-26T17:11:43+00:00\"}', 'OPEN', NULL, NULL, NULL, NULL, NULL, '2026-09-27 01:45:35', '2026-09-27 01:45:35', NULL),
(14, 1, 10, NULL, 'STALE_DATA', 'WARNING', 'डेटा अप्रचलन एवं कनेक्टिविटी बाधित: आगरा मातृ एवं शिशु चिकित्सालय (डेमो)', 'अस्पताल आगरा मातृ एवं शिशु चिकित्सालय (डेमो) (HFR: UP-AGR-010) से 4 घंटे से अधिक समय से कोई डेटा प्राप्त नहीं हुआ है। वास्तविक शैया स्थिति की पुष्टि करें।', '{\"hfr_id\":\"UP-AGR-010\",\"last_heartbeat_at\":\"2026-09-26T17:05:43+00:00\"}', 'OPEN', NULL, NULL, NULL, NULL, NULL, '2026-09-27 01:45:35', '2026-09-27 01:45:35', NULL);

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

--
-- Table structure for table `system_configs`
--

CREATE TABLE `system_configs` (
  `id` bigint UNSIGNED NOT NULL,
  `scope_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'STATE',
  `scope_id` int DEFAULT NULL,
  `config_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `config_value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `system_configs`
--

INSERT INTO `system_configs` (`id`, `scope_type`, `scope_id`, `config_key`, `config_value`, `description`, `created_at`, `updated_at`) VALUES
(1, 'STATE', NULL, 'bed_warning_threshold_pct', '20', 'Hospital alert when free beds drop below this percentage (FR-L-01)', '2026-09-26 17:20:48', '2026-09-26 17:20:48'),
(2, 'STATE', NULL, 'bed_district_alert_threshold_pct', '10', 'District alert when free beds drop below this percentage (FR-L-01)', '2026-09-26 17:20:48', '2026-09-26 17:20:48'),
(3, 'STATE', NULL, 'bed_critical_threshold_pct', '0', 'Critical emergency alert when 0 beds are available in category', '2026-09-26 17:20:48', '2026-09-26 17:20:48'),
(4, 'STATE', NULL, 'stale_hospital_warning_hours', '4', 'Hospital flagged as stale if no update within this window (FR-L-02)', '2026-09-26 17:20:48', '2026-09-26 17:20:48'),
(5, 'STATE', NULL, 'stale_hospital_exclude_hours', '12', 'Hospital excluded from free bed totals after this window (FR-C-04)', '2026-09-26 17:20:48', '2026-09-26 17:20:48'),
(6, 'STATE', NULL, 'referral_sla_critical_minutes', '10', 'SLA for receiving hospital to respond to critical referral ticket (FR-R-03)', '2026-09-26 17:20:48', '2026-09-26 17:20:48'),
(7, 'STATE', NULL, 'referral_sla_urgent_minutes', '30', 'SLA for receiving hospital to respond to urgent referral ticket (FR-R-03)', '2026-09-26 17:20:48', '2026-09-26 17:20:48'),
(8, 'STATE', NULL, 'referral_sla_routine_minutes', '120', 'SLA for receiving hospital to respond to routine referral ticket (FR-R-03)', '2026-09-26 17:20:48', '2026-09-26 17:20:48'),
(9, 'STATE', NULL, 'internal_reservation_hold_minutes', '60', 'Automatic release time for internal bed reservation hold (FR-B-04)', '2026-09-26 17:20:48', '2026-09-26 17:20:48'),
(10, 'STATE', NULL, 'inbound_referral_hold_buffer_minutes', '30', 'Buffer added to ETA for inbound referral bed reservation (FR-B-04)', '2026-09-26 17:20:48', '2026-09-26 17:20:48'),
(11, 'STATE', NULL, 'inbound_referral_max_hold_hours', '3', 'Maximum ceiling hold time for inbound referral bed reservation', '2026-09-26 17:20:48', '2026-09-26 17:20:48');

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

--
-- Table structure for table `unmet_demands`
--

CREATE TABLE `unmet_demands` (
  `id` int NOT NULL,
  `hospital_id` int NOT NULL,
  `category_id` int NOT NULL,
  `department_id` bigint UNSIGNED DEFAULT NULL,
  `urgency` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'URGENT',
  `requested_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `user_id` int DEFAULT NULL,
  `notes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_verified_at` datetime DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'STAFF_NURSE',
  `scope_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'HOSPITAL',
  `scope_id` int DEFAULT NULL,
  `hospital_id` int DEFAULT NULL,
  `department_id` bigint UNSIGNED DEFAULT NULL,
  `ward_id` int DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `last_login_at` datetime DEFAULT NULL,
  `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `phone`, `email_verified_at`, `password`, `role`, `scope_type`, `scope_id`, `hospital_id`, `department_id`, `ward_id`, `is_active`, `last_login_at`, `remember_token`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Sri Alok Kumar (IAS)', 'super.admin@shayyasetu.up.gov.in', '9999000001', NULL, '$2y$12$Lim//GiETiuw7ZsQuJsElu.T5VKJne/gMRSjzJm5TNX6e9sa1RDnq', 'SUPER_ADMIN', 'STATE', 1, NULL, NULL, NULL, 1, NULL, NULL, '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(2, 'Dr. Pinky Jowel (Mission Director NHM)', 'state.admin@shayyasetu.up.gov.in', '9999000002', NULL, '$2y$12$3RNa2pFvhaU/byAjghJjyuaFWw4QVso4SQhxFzEZ9.IvviCKDL5Si', 'STATE_ADMIN', 'STATE', 1, NULL, NULL, NULL, 1, '2026-09-27 08:57:09', 'ti7PXuctSlU97iUOsyewYUbVhvdEKcLXRPUNmDy1eJ7kTdyVJf1K12SaFIza', '2026-09-26 17:20:43', '2026-09-27 08:57:09', NULL),
(3, 'Dr. Sanjeev Yadav (Additional Director Health)', 'div.agra@shayyasetu.up.gov.in', '9999000003', NULL, '$2y$12$YOmSZIgjVqDFg2UoTOYNou0ykr3VWnhpCr3VaZ3o8i.3qJZBGArNO', 'DIVISIONAL_REVIEWER', 'DIVISION', 1, NULL, NULL, NULL, 1, NULL, NULL, '2026-09-26 17:20:44', '2026-09-26 17:20:44', NULL),
(4, 'Dr. Arun Srivastava (CMO Agra)', 'district.agra@shayyasetu.up.gov.in', '9999000004', NULL, '$2y$12$7IxgF76wsUHEnNuQ.nal1.ZSQHZulL10uGDYW0H//G52ZU79sdzwe', 'DISTRICT_NODAL_OFFICER', 'DISTRICT', 1, NULL, NULL, NULL, 1, '2026-09-27 08:41:04', 'cW2WuMf8OLTdizNXKcr3jgDbHthkWQVR9C9T6vVKJTSPbV75JlzQDhjRcKU2', '2026-09-26 17:20:44', '2026-09-27 08:41:04', NULL),
(5, 'Dr. Prashant Gupta (MS SNMC)', 'ms.snmc@shayyasetu.up.gov.in', '9999000005', NULL, '$2y$12$NsHZuymP9/SmTkm1tROs0.quDx4qRRDUKEyqifYJ1Xp.pxDRqPy56', 'MEDICAL_SUPERINTENDENT', 'HOSPITAL', 1, 1, NULL, NULL, 1, '2026-09-27 08:51:26', 'tLm3mm65ytx9cdmWjPWYGrYisr0mY09sizNrHRMiLLDyVpNQgZDL8lTAtoTp', '2026-09-26 17:20:44', '2026-09-27 08:51:26', NULL),
(6, 'Dr. T.P. Singh (Senior Consultant Medicine)', 'doctor.snmc@shayyasetu.up.gov.in', '9999000006', NULL, '$2y$12$Xr7ibLc8oLbUPHeGMUYD.Oj0xahdjLVjzt5xFlGbZZlNqY0/CLUni', 'CONSULTANT_DOCTOR', 'DEPARTMENT', 4, 1, 4, NULL, 1, '2026-09-27 08:52:01', '1bQaxTvmWoWZfEk8GPVn9vyy31Vtu0d4ZuV3o4MVbQNz4DlCJ9jYyP5sCQhl', '2026-09-26 17:20:44', '2026-09-27 08:52:01', NULL),
(7, 'Rakesh Kumar Sharma (Bed Manager SNMC)', 'bedmanager.snmc@shayyasetu.up.gov.in', '9999000007', NULL, '$2y$12$uOtKUxhpqFq2tEL1Vmu3COIGW3UlYfweUln5r0.y6u.F.vb70/IAu', 'BED_MANAGER', 'HOSPITAL', 1, 1, NULL, NULL, 1, '2026-09-27 08:50:43', '6JQ3UXBV7JUhBZqOYm7VdfDvfxecFlQlZDfe5rzt71PnSxRlCYpcHShRrDuL', '2026-09-26 17:20:45', '2026-09-27 08:50:43', NULL),
(8, 'Amit Upadhyay (Backup Bed Manager SNMC)', 'backup.snmc@shayyasetu.up.gov.in', '9999000008', NULL, '$2y$12$BrkXBGMNHwfMRwfU/TMC/e1XP1zCjWcV7TWmjdkpFIm8usuUjSS06', 'BED_MANAGER', 'HOSPITAL', 1, 1, NULL, NULL, 1, NULL, NULL, '2026-09-26 17:20:45', '2026-09-26 17:20:45', NULL),
(9, 'Sunita Devi (Staff Nurse ICU)', 'nurse.snmc@shayyasetu.up.gov.in', '9999000009', NULL, '$2y$12$B/MAtRhgeXA5hOgVKMbfL.EXf5GJMvzR398LeHWL95EJ0UikZJKjK', 'STAFF_NURSE', 'WARD', 1, 1, 4, 1, 1, '2026-09-27 05:01:08', '5irkMbGmGoa4HwWtOqQRKjTsreVJALotQUSCnQzBsrl8tz1FnApHlfTRASun', '2026-09-26 17:20:45', '2026-09-27 05:01:08', NULL),
(10, 'Manoj Verma (Registration Counter)', 'registration.snmc@shayyasetu.up.gov.in', '9999000010', NULL, '$2y$12$fvSNfB86v3X4RtHMiql3E.rE5NuQE4Ajkfji1H.X2VG/hBF0usuQq', 'REGISTRATION_STAFF', 'HOSPITAL', 1, 1, NULL, NULL, 1, NULL, NULL, '2026-09-26 17:20:45', '2026-09-26 17:20:45', NULL),
(11, 'Deepak Saxena (Bed Manager Pushpanjali)', 'bedmanager.pushpanjali@shayyasetu.up.gov.in', '9999000011', NULL, '$2y$12$jpuf0ER/JDczI4wY5k0RGujK5sRR/GL5oZHKT4Z2YQNDYg08BebqS', 'PRIVATE_BED_MANAGER', 'HOSPITAL', 5, 5, NULL, NULL, 1, '2026-09-27 08:54:23', 'LObS6i5LSiRomYHCQYu7yzHEilSSxgR5UuEixBdmYDhpwTGZpRbJ2eryCj4R', '2026-09-26 17:20:45', '2026-09-27 08:54:23', NULL),
(12, 'Rajendra Prasad (Bed Manager DH Agra)', 'bedmanager.dhagra@shayyasetu.up.gov.in', '9999000012', NULL, '$2y$12$dBVqsU25sAgBC4kKWCUfEuoYCTCQmfJhzijsP7uH6R3b24KXga8km', 'BED_MANAGER', 'HOSPITAL', 2, 2, NULL, NULL, 1, NULL, NULL, '2026-09-26 17:20:46', '2026-09-26 17:20:46', NULL),
(13, 'Super Administrator (Demo)', 'superadmin@shayyasetu.demo', '9000000015', NULL, '$2y$12$McZ5bqyBEiureg5chXWG0eaxL9XSiowFzRs0GpVRkmnj1oCfMgI5u', 'SUPER_ADMIN', 'STATE', 1, NULL, NULL, NULL, 1, NULL, NULL, '2026-09-26 17:20:46', '2026-09-26 17:20:46', NULL),
(14, 'State PMU Director (Demo)', 'state.pmu@shayyasetu.demo', '9000000010', NULL, '$2y$12$YuI3mlX.NvmqIqDon/YmHOhrOxWb7aJEmqrkvd.HoBNSK9ecbxdiy', 'STATE_ADMIN', 'STATE', 1, NULL, NULL, NULL, 1, '2026-09-27 01:46:25', 'MtBFuZJRiGggRJT87LtuSLra6VDsBCHJIKXkZ4PjVI5eBByR9IcL96kmtSa3', '2026-09-26 17:20:46', '2026-09-27 01:46:25', NULL),
(15, 'Divisional Health Reviewer (Demo)', 'division.agra@shayyasetu.demo', '9000000008', NULL, '$2y$12$g2tDsmj0m0fXXPC4stye/u5JhOP.5/e6FSty/t00t.a.0ZpjiVfPG', 'DIVISIONAL_REVIEWER', 'DIVISION', 1, NULL, NULL, NULL, 1, NULL, NULL, '2026-09-26 17:20:46', '2026-09-26 17:20:46', NULL),
(16, 'District Nodal Officer Agra (Demo)', 'officer.agra@shayyasetu.demo', '9000000007', NULL, '$2y$12$ngfkqkVflyIcNKGHAMWDvev0qLjgnrAV50uAep20pn9AH2YFmL5cy', 'DISTRICT_NODAL_OFFICER', 'DISTRICT', 1, NULL, NULL, NULL, 1, '2026-09-27 01:47:24', 'VyoIA1B6a3cUgKjbF5ZxJ4WZWW9nAelPRt4rtPkvJEtx6M5aaady8HWSbjZE', '2026-09-26 17:20:46', '2026-09-27 01:47:24', NULL),
(17, 'District Nodal Officer Agra (Demo)', 'dno.agra@shayyasetu.demo', '9000000016', NULL, '$2y$12$6OQXK6EIO/UJeabfYyiw..TPoCjgUH7klGW.uz5JG6WVO.n6uom62', 'DISTRICT_NODAL_OFFICER', 'DISTRICT', 1, NULL, NULL, NULL, 1, NULL, NULL, '2026-09-26 17:20:47', '2026-09-26 17:20:47', NULL),
(18, 'District Desk Operator (Demo)', 'operator.agra@shayyasetu.demo', '9000000009', NULL, '$2y$12$RXguAGMh0R3yh302ULVRKO/dRhVjA0pNzBRX1yYMpGCjH7bTVEany', 'DISTRICT_NODAL_OFFICER', 'DISTRICT', 1, NULL, NULL, NULL, 1, NULL, NULL, '2026-09-26 17:20:47', '2026-09-26 17:20:47', NULL),
(19, 'Medical Superintendent DH Agra (Demo)', 'ms.dh@shayyasetu.demo', '9000000002', NULL, '$2y$12$LJpZqDRHENcf0yVZPrdhVecIemS5UZzq.h23BuB0yEfpyHX6HsGZS', 'MEDICAL_SUPERINTENDENT', 'HOSPITAL', 2, 2, NULL, NULL, 1, '2026-09-27 01:45:09', 'vT5Ajj8co53CwXTvadcqmeImHY8v6BkyuqjEFpZH0zemCBWVYCb4gFQetk7K', '2026-09-26 17:20:47', '2026-09-27 01:45:09', NULL),
(20, 'Medical Superintendent SNMC (Demo)', 'ms.mch@shayyasetu.demo', '9000000013', NULL, '$2y$12$6Hszh/CbBLxSRwhXkBnPGO/d2f1NK0o0Ve/Pc0yYqz8OIUVf19V0m', 'MEDICAL_SUPERINTENDENT', 'HOSPITAL', 1, 1, NULL, NULL, 1, NULL, NULL, '2026-09-26 17:20:47', '2026-09-26 17:20:47', NULL),
(21, 'Dr. Sharma (Treating Doctor) (Demo)', 'doctor.dh@shayyasetu.demo', '9000000003', NULL, '$2y$12$5Eeexm.p47CjQw/rxL9XMOvBJbOe6yi5SFRECYBl2ufa6tmYJ3WXW', 'CONSULTANT_DOCTOR', 'DEPARTMENT', 8, 2, 8, NULL, 1, NULL, NULL, '2026-09-26 17:20:47', '2026-09-26 17:20:47', NULL),
(22, 'Nurse Sharma (Staff Nurse) (Demo)', 'nurse.dh@shayyasetu.demo', '9000000004', NULL, '$2y$12$Vez4xkMWqgCnhVrmcjNAY.f2QOw3u5TpqwX3WXUem1Ddto/NBWzmi', 'STAFF_NURSE', 'WARD', 10, 2, 8, 10, 1, '2026-09-27 01:47:21', 'Df3m6IxjgFn4SjVHckgbKLzOasEyBvrlNagW9mMyWigyWHPHuEgygx77WD9r', '2026-09-26 17:20:48', '2026-09-27 01:47:21', NULL),
(23, 'Bed Manager DH Agra (Demo)', 'bedmanager.dh@shayyasetu.demo', '9000000005', NULL, '$2y$12$sk9jb6u7j6m1D8uBGI9jIOnS0/f1GXuQrseyfbuuNz7I/0OO8hfxK', 'BED_MANAGER', 'HOSPITAL', 2, 2, NULL, NULL, 1, '2026-09-27 01:47:08', 'QlkKq6m7EhMUcdMMu4aPXyH4E4P5D9N874pTKvywccBWs59C29DfSebYGXBy', '2026-09-26 17:20:48', '2026-09-27 01:47:08', NULL),
(24, 'Registration Staff DH (Demo)', 'registration.dh@shayyasetu.demo', '9000000006', NULL, '$2y$12$o6UJ1eB7ZiaHF40YbYbGd.63shETk4PN2fDl4SMU5r3XAspuyFFFS', 'REGISTRATION_STAFF', 'HOSPITAL', 2, 2, NULL, NULL, 1, NULL, NULL, '2026-09-26 17:20:48', '2026-09-26 17:20:48', NULL),
(25, 'Bed Manager Yamuna Care (Demo)', 'bedmanager.yamuna@shayyasetu.demo', '9000000001', NULL, '$2y$12$2EyvSjz/LKDHSyHjiKTq8On0TXXLN9lkoNUlFUoUxCq8XXf.pywL6', 'PRIVATE_BED_MANAGER', 'HOSPITAL', 8, 8, NULL, NULL, 1, NULL, NULL, '2026-09-26 17:20:48', '2026-09-26 17:20:48', NULL);

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

--
-- Table structure for table `wards`
--

CREATE TABLE `wards` (
  `id` int NOT NULL,
  `hospital_id` int NOT NULL,
  `department_id` bigint UNSIGNED DEFAULT NULL,
  `name_en` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_hi` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `floor` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gender_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'MIXED',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wards`
--

INSERT INTO `wards` (`id`, `hospital_id`, `department_id`, `name_en`, `name_hi`, `floor`, `gender_type`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 1, 'General Medicine Male Ward', 'सामान्य चिकित्सा पुरुष वार्ड', '2nd Floor', 'MALE', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(2, 1, 1, 'General Medicine Female Ward', 'सामान्य चिकित्सा महिला वार्ड', '3rd Floor', 'FEMALE', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(3, 1, 2, 'General Surgery Male Ward', 'सामान्य शल्य चिकित्सा पुरुष वार्ड', '2nd Floor', 'MALE', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(4, 1, 2, 'General Surgery Female Ward', 'सामान्य शल्य चिकित्सा महिला वार्ड', '3rd Floor', 'FEMALE', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(5, 1, 3, 'ICU / Emergency Ward', 'आईसीयू / आपातकालीन वार्ड', 'Ground Floor', 'MIXED', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(6, 1, 3, 'HDU Ward', 'एचडीयू वार्ड', '1st Floor', 'MIXED', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(7, 1, 4, 'ICCU Ward', 'आईसीसीयू वार्ड', '2nd Floor', 'MIXED', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(8, 1, 5, 'NICU Ward', 'एनआईसीयू नवजात वार्ड', '1st Floor', 'NEONATAL', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(9, 1, 5, 'Paediatric Inpatient', 'बाल रोग वार्ड', '1st Floor', 'PAEDIATRIC', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(10, 2, 6, 'Medicine Male Ward', 'चिकित्सा पुरुष वार्ड', '2nd Floor', 'MALE', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(11, 2, 6, 'Medicine Female Ward', 'चिकित्सा महिला वार्ड', '3rd Floor', 'FEMALE', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(12, 2, 7, 'Surgery Male Ward', 'शल्य चिकित्सा पुरुष वार्ड', '2nd Floor', 'MALE', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(13, 2, 7, 'Surgery Female Ward', 'शल्य चिकित्सा महिला वार्ड', '3rd Floor', 'FEMALE', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(14, 2, 8, 'ICU / Emergency Ward', 'आईसीयू / आपातकालीन वार्ड', 'Ground Floor', 'MIXED', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(15, 2, 8, 'HDU Ward', 'एचडीयू वार्ड', '1st Floor', 'MIXED', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(16, 3, 9, 'Inpatient General Male Ward', 'सामान्य अंतरंग वार्ड पुरुष वार्ड', '2nd Floor', 'MALE', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(17, 3, 9, 'Inpatient General Female Ward', 'सामान्य अंतरंग वार्ड महिला वार्ड', '3rd Floor', 'FEMALE', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(18, 3, 10, 'ICU / Emergency Ward', 'आईसीयू / आपातकालीन वार्ड', 'Ground Floor', 'MIXED', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(19, 3, 10, 'HDU Ward', 'एचडीयू वार्ड', '1st Floor', 'MIXED', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(20, 4, 11, 'Inpatient General Male Ward', 'सामान्य अंतरंग वार्ड पुरुष वार्ड', '2nd Floor', 'MALE', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(21, 4, 11, 'Inpatient General Female Ward', 'सामान्य अंतरंग वार्ड महिला वार्ड', '3rd Floor', 'FEMALE', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(22, 4, 12, 'ICU / Emergency Ward', 'आईसीयू / आपातकालीन वार्ड', 'Ground Floor', 'MIXED', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(23, 4, 12, 'HDU Ward', 'एचडीयू वार्ड', '1st Floor', 'MIXED', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(24, 5, 13, 'ICU / Emergency Ward', 'आईसीयू / आपातकालीन वार्ड', 'Ground Floor', 'MIXED', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(25, 5, 13, 'HDU Ward', 'एचडीयू वार्ड', '1st Floor', 'MIXED', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(26, 5, 14, 'ICCU Ward', 'आईसीसीयू वार्ड', '2nd Floor', 'MIXED', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(27, 5, 15, 'Multi-Specialty Wards Male Ward', 'मल्टी स्पेशियलिटी वार्ड पुरुष वार्ड', '2nd Floor', 'MALE', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(28, 5, 15, 'Multi-Specialty Wards Female Ward', 'मल्टी स्पेशियलिटी वार्ड महिला वार्ड', '3rd Floor', 'FEMALE', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(29, 6, 16, 'ICU / Emergency Ward', 'आईसीयू / आपातकालीन वार्ड', 'Ground Floor', 'MIXED', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(30, 6, 16, 'HDU Ward', 'एचडीयू वार्ड', '1st Floor', 'MIXED', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(31, 6, 17, 'Inpatient Ward Male Ward', 'अंतरंग वार्ड पुरुष वार्ड', '2nd Floor', 'MALE', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(32, 6, 17, 'Inpatient Ward Female Ward', 'अंतरंग वार्ड महिला वार्ड', '3rd Floor', 'FEMALE', '2026-09-26 17:20:42', '2026-09-26 17:20:42', NULL),
(33, 7, 18, 'General Ward Male Ward', 'सामान्य वार्ड पुरुष वार्ड', '2nd Floor', 'MALE', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(34, 7, 18, 'General Ward Female Ward', 'सामान्य वार्ड महिला वार्ड', '3rd Floor', 'FEMALE', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(35, 7, 19, 'ICU Unit Male Ward', 'आईसीयू यूनिट पुरुष वार्ड', '2nd Floor', 'MALE', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(36, 7, 19, 'ICU Unit Female Ward', 'आईसीयू यूनिट महिला वार्ड', '3rd Floor', 'FEMALE', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(37, 8, 20, 'General Ward Male Ward', 'सामान्य वार्ड पुरुष वार्ड', '2nd Floor', 'MALE', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(38, 8, 20, 'General Ward Female Ward', 'सामान्य वार्ड महिला वार्ड', '3rd Floor', 'FEMALE', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(39, 8, 21, 'ICU / Emergency Ward', 'आईसीयू / आपातकालीन वार्ड', 'Ground Floor', 'MIXED', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(40, 8, 21, 'HDU Ward', 'एचडीयू वार्ड', '1st Floor', 'MIXED', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(41, 9, 22, 'General Ward Male Ward', 'सामान्य वार्ड पुरुष वार्ड', '2nd Floor', 'MALE', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(42, 9, 22, 'General Ward Female Ward', 'सामान्य वार्ड महिला वार्ड', '3rd Floor', 'FEMALE', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(43, 9, 23, 'ICU / Emergency Ward', 'आईसीयू / आपातकालीन वार्ड', 'Ground Floor', 'MIXED', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(44, 9, 23, 'HDU Ward', 'एचडीयू वार्ड', '1st Floor', 'MIXED', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(45, 10, 24, 'NICU Ward', 'एनआईसीयू नवजात वार्ड', '1st Floor', 'NEONATAL', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(46, 10, 24, 'Paediatric Inpatient', 'बाल रोग वार्ड', '1st Floor', 'PAEDIATRIC', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(47, 10, 25, 'Maternity Ward Male Ward', 'प्रसूति वार्ड पुरुष वार्ड', '2nd Floor', 'MALE', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL),
(48, 10, 25, 'Maternity Ward Female Ward', 'प्रसूति वार्ड महिला वार्ड', '3rd Floor', 'FEMALE', '2026-09-26 17:20:43', '2026-09-26 17:20:43', NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `abdm_consents`
--
ALTER TABLE `abdm_consents`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `abdm_consents_consent_request_id_unique` (`consent_request_id`),
  ADD UNIQUE KEY `abdm_consents_artefact_id_unique` (`artefact_id`),
  ADD KEY `hospital_id` (`hospital_id`);

--
-- Indexes for table `admissions`
--
ALTER TABLE `admissions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `admissions_hospital_id_index` (`hospital_id`),
  ADD KEY `admissions_patient_id_index` (`patient_id`),
  ADD KEY `admissions_department_id_index` (`department_id`),
  ADD KEY `admissions_current_bed_id_index` (`current_bed_id`),
  ADD KEY `admissions_admitting_doctor_id_index` (`admitting_doctor_id`);

--
-- Indexes for table `ambulance_dispatches`
--
ALTER TABLE `ambulance_dispatches`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `ambulance_dispatches_dispatch_number_unique` (`dispatch_number`),
  ADD KEY `patient_category_id` (`patient_category_id`),
  ADD KEY `caller_district_id` (`caller_district_id`),
  ADD KEY `destination_hospital_id` (`destination_hospital_id`),
  ADD KEY `held_bed_id` (`held_bed_id`),
  ADD KEY `referral_ticket_id` (`referral_ticket_id`);

--
-- Indexes for table `audit_logs`
--
ALTER TABLE `audit_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `beds`
--
ALTER TABLE `beds`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `beds_ward_id_bed_number_unique` (`ward_id`,`bed_number`),
  ADD KEY `beds_hospital_id_index` (`hospital_id`),
  ADD KEY `beds_ward_id_index` (`ward_id`),
  ADD KEY `beds_category_id_index` (`category_id`),
  ADD KEY `beds_status_index` (`status`);

--
-- Indexes for table `bed_categories`
--
ALTER TABLE `bed_categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `bed_categories_code_unique` (`code`);

--
-- Indexes for table `bed_events`
--
ALTER TABLE `bed_events`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `bed_events_event_uuid_unique` (`event_uuid`),
  ADD KEY `category_id` (`category_id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `bed_events_hospital_id_created_at_index` (`hospital_id`,`created_at`),
  ADD KEY `bed_events_bed_id_created_at_index` (`bed_id`,`created_at`);

--
-- Indexes for table `bed_movements`
--
ALTER TABLE `bed_movements`
  ADD PRIMARY KEY (`id`),
  ADD KEY `bed_movements_hospital_id_index` (`hospital_id`),
  ADD KEY `bed_movements_admission_id_index` (`admission_id`);

--
-- Indexes for table `bed_recertifications`
--
ALTER TABLE `bed_recertifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `hospital_id` (`hospital_id`),
  ADD KEY `certified_by` (`certified_by`);

--
-- Indexes for table `bed_reservations`
--
ALTER TABLE `bed_reservations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `bed_id` (`bed_id`),
  ADD KEY `hospital_id` (`hospital_id`),
  ADD KEY `reserved_by_user_id` (`reserved_by_user_id`),
  ADD KEY `bed_reservations_status_expires_at_index` (`status`,`expires_at`),
  ADD KEY `bed_reservations_ticket_no_index` (`ticket_no`);

--
-- Indexes for table `blocks`
--
ALTER TABLE `blocks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `district_id` (`district_id`);

--
-- Indexes for table `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`),
  ADD KEY `cache_expiration_index` (`expiration`);

--
-- Indexes for table `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`),
  ADD KEY `cache_locks_expiration_index` (`expiration`);

--
-- Indexes for table `category_snapshots`
--
ALTER TABLE `category_snapshots`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `category_snapshots_hospital_id_category_id_unique` (`hospital_id`,`category_id`),
  ADD KEY `category_id` (`category_id`);

--
-- Indexes for table `clinical_notes`
--
ALTER TABLE `clinical_notes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `clinical_notes_hospital_id_index` (`hospital_id`),
  ADD KEY `clinical_notes_admission_id_index` (`admission_id`);

--
-- Indexes for table `death_records`
--
ALTER TABLE `death_records`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `death_records_certificate_no_unique` (`certificate_no`),
  ADD KEY `death_records_hospital_id_index` (`hospital_id`),
  ADD KEY `death_records_admission_id_index` (`admission_id`),
  ADD KEY `death_records_patient_id_index` (`patient_id`);

--
-- Indexes for table `departments`
--
ALTER TABLE `departments`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `departments_hospital_id_code_unique` (`hospital_id`,`code`);

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

--
-- Indexes for table `divisions`
--
ALTER TABLE `divisions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `divisions_lgd_code_unique` (`lgd_code`);

--
-- Indexes for table `elective_bookings`
--
ALTER TABLE `elective_bookings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `elective_bookings_booking_reference_unique` (`booking_reference`),
  ADD KEY `hospital_id` (`hospital_id`),
  ADD KEY `category_id` (`category_id`),
  ADD KEY `held_bed_id` (`held_bed_id`);

--
-- Indexes for table `expected_discharges`
--
ALTER TABLE `expected_discharges`
  ADD PRIMARY KEY (`id`),
  ADD KEY `category_id` (`category_id`),
  ADD KEY `reported_by_user_id` (`reported_by_user_id`),
  ADD KEY `expected_discharges_hospital_id_category_id_forecast_at_index` (`hospital_id`,`category_id`,`forecast_at`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `heartbeats`
--
ALTER TABLE `heartbeats`
  ADD PRIMARY KEY (`id`),
  ADD KEY `heartbeats_hospital_id_last_seen_at_index` (`hospital_id`,`last_seen_at`);

--
-- Indexes for table `helpdesk_tickets`
--
ALTER TABLE `helpdesk_tickets`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `helpdesk_tickets_ticket_number_unique` (`ticket_number`),
  ADD KEY `hospital_id` (`hospital_id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `assigned_to` (`assigned_to`);

--
-- Indexes for table `hospitals`
--
ALTER TABLE `hospitals`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `hospitals_hfr_id_unique` (`hfr_id`),
  ADD KEY `hospitals_district_id_facility_level_index` (`district_id`,`facility_level`),
  ADD KEY `hospitals_block_id_index` (`block_id`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

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

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

--
-- Indexes for table `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- Indexes for table `patients`
--
ALTER TABLE `patients`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `patients_hospital_id_uhid_unique` (`hospital_id`,`uhid`),
  ADD KEY `patients_hospital_id_index` (`hospital_id`),
  ADD KEY `patients_abha_number_index` (`abha_number`);

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`),
  ADD KEY `personal_access_tokens_expires_at_index` (`expires_at`);

--
-- Indexes for table `pmjay_tags`
--
ALTER TABLE `pmjay_tags`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `pmjay_tags_pmjay_id_unique` (`pmjay_id`),
  ADD KEY `hospital_id` (`hospital_id`);

--
-- Indexes for table `referral_links`
--
ALTER TABLE `referral_links`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `referral_links_hospital_id_ticket_no_admission_id_unique` (`hospital_id`,`ticket_no`,`admission_id`),
  ADD KEY `referral_links_hospital_id_index` (`hospital_id`),
  ADD KEY `referral_links_ticket_no_index` (`ticket_no`),
  ADD KEY `referral_links_admission_id_index` (`admission_id`);

--
-- Indexes for table `referral_tickets`
--
ALTER TABLE `referral_tickets`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `referral_tickets_ticket_no_unique` (`ticket_no`),
  ADD KEY `referral_tickets_from_hospital_id_status_index` (`from_hospital_id`,`status`),
  ADD KEY `referral_tickets_to_hospital_id_status_index` (`to_hospital_id`,`status`),
  ADD KEY `referral_tickets_urgency_status_index` (`urgency`,`status`),
  ADD KEY `referral_tickets_sla_expires_at_index` (`sla_expires_at`);

--
-- Indexes for table `rosters`
--
ALTER TABLE `rosters`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `hospital_shift_unique` (`hospital_id`,`shift_date`,`shift_name`),
  ADD KEY `bed_manager_id` (`bed_manager_id`),
  ADD KEY `backup_id` (`backup_id`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Indexes for table `sms_notifications`
--
ALTER TABLE `sms_notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `hospital_id` (`hospital_id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `spot_checks`
--
ALTER TABLE `spot_checks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `hospital_id` (`hospital_id`),
  ADD KEY `ward_id` (`ward_id`),
  ADD KEY `category_id` (`category_id`),
  ADD KEY `conducted_by_user_id` (`conducted_by_user_id`);

--
-- Indexes for table `surge_activations`
--
ALTER TABLE `surge_activations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `hospital_id` (`hospital_id`),
  ADD KEY `activated_by` (`activated_by`),
  ADD KEY `deactivated_by` (`deactivated_by`),
  ADD KEY `target_ward_id` (`target_ward_id`);

--
-- Indexes for table `system_alerts`
--
ALTER TABLE `system_alerts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `category_id` (`category_id`),
  ADD KEY `acknowledged_by_user_id` (`acknowledged_by_user_id`),
  ADD KEY `resolved_by_user_id` (`resolved_by_user_id`),
  ADD KEY `system_alerts_district_id_status_index` (`district_id`,`status`),
  ADD KEY `system_alerts_hospital_id_status_index` (`hospital_id`,`status`),
  ADD KEY `system_alerts_alert_type_status_index` (`alert_type`,`status`),
  ADD KEY `system_alerts_severity_status_index` (`severity`,`status`);

--
-- Indexes for table `system_configs`
--
ALTER TABLE `system_configs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `config_unique_scope_key` (`scope_type`,`scope_id`,`config_key`);

--
-- Indexes for table `unmet_demands`
--
ALTER TABLE `unmet_demands`
  ADD PRIMARY KEY (`id`),
  ADD KEY `unmet_demands_hospital_id_requested_at_index` (`hospital_id`,`requested_at`),
  ADD KEY `unmet_demands_category_id_requested_at_index` (`category_id`,`requested_at`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`),
  ADD UNIQUE KEY `users_phone_unique` (`phone`),
  ADD KEY `users_hospital_id_index` (`hospital_id`),
  ADD KEY `users_department_id_index` (`department_id`),
  ADD KEY `users_ward_id_index` (`ward_id`);

--
-- Indexes for table `wards`
--
ALTER TABLE `wards`
  ADD PRIMARY KEY (`id`),
  ADD KEY `wards_hospital_id_index` (`hospital_id`),
  ADD KEY `wards_department_id_index` (`department_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `abdm_consents`
--
ALTER TABLE `abdm_consents`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `admissions`
--
ALTER TABLE `admissions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `ambulance_dispatches`
--
ALTER TABLE `ambulance_dispatches`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `audit_logs`
--
ALTER TABLE `audit_logs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `beds`
--
ALTER TABLE `beds`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=433;

--
-- AUTO_INCREMENT for table `bed_categories`
--
ALTER TABLE `bed_categories`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `bed_events`
--
ALTER TABLE `bed_events`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=101;

--
-- AUTO_INCREMENT for table `bed_movements`
--
ALTER TABLE `bed_movements`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bed_recertifications`
--
ALTER TABLE `bed_recertifications`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bed_reservations`
--
ALTER TABLE `bed_reservations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `blocks`
--
ALTER TABLE `blocks`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `category_snapshots`
--
ALTER TABLE `category_snapshots`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `clinical_notes`
--
ALTER TABLE `clinical_notes`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `death_records`
--
ALTER TABLE `death_records`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `departments`
--
ALTER TABLE `departments`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `divisions`
--
ALTER TABLE `divisions`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `elective_bookings`
--
ALTER TABLE `elective_bookings`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `expected_discharges`
--
ALTER TABLE `expected_discharges`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `heartbeats`
--
ALTER TABLE `heartbeats`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `helpdesk_tickets`
--
ALTER TABLE `helpdesk_tickets`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hospitals`
--
ALTER TABLE `hospitals`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `patients`
--
ALTER TABLE `patients`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pmjay_tags`
--
ALTER TABLE `pmjay_tags`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `referral_links`
--
ALTER TABLE `referral_links`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `referral_tickets`
--
ALTER TABLE `referral_tickets`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `rosters`
--
ALTER TABLE `rosters`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `sms_notifications`
--
ALTER TABLE `sms_notifications`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `spot_checks`
--
ALTER TABLE `spot_checks`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `surge_activations`
--
ALTER TABLE `surge_activations`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `system_alerts`
--
ALTER TABLE `system_alerts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `system_configs`
--
ALTER TABLE `system_configs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `unmet_demands`
--
ALTER TABLE `unmet_demands`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `wards`
--
ALTER TABLE `wards`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `abdm_consents`
--
ALTER TABLE `abdm_consents`
  ADD CONSTRAINT `abdm_consents_ibfk_1` FOREIGN KEY (`hospital_id`) REFERENCES `hospitals` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `ambulance_dispatches`
--
ALTER TABLE `ambulance_dispatches`
  ADD CONSTRAINT `ambulance_dispatches_ibfk_1` FOREIGN KEY (`patient_category_id`) REFERENCES `bed_categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `ambulance_dispatches_ibfk_2` FOREIGN KEY (`caller_district_id`) REFERENCES `districts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `ambulance_dispatches_ibfk_3` FOREIGN KEY (`destination_hospital_id`) REFERENCES `hospitals` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `ambulance_dispatches_ibfk_4` FOREIGN KEY (`held_bed_id`) REFERENCES `beds` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `ambulance_dispatches_ibfk_5` FOREIGN KEY (`referral_ticket_id`) REFERENCES `referral_tickets` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `audit_logs`
--
ALTER TABLE `audit_logs`
  ADD CONSTRAINT `audit_logs_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `bed_events`
--
ALTER TABLE `bed_events`
  ADD CONSTRAINT `bed_events_ibfk_1` FOREIGN KEY (`hospital_id`) REFERENCES `hospitals` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `bed_events_ibfk_2` FOREIGN KEY (`bed_id`) REFERENCES `beds` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `bed_events_ibfk_3` FOREIGN KEY (`category_id`) REFERENCES `bed_categories` (`id`),
  ADD CONSTRAINT `bed_events_ibfk_4` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `bed_recertifications`
--
ALTER TABLE `bed_recertifications`
  ADD CONSTRAINT `bed_recertifications_ibfk_1` FOREIGN KEY (`hospital_id`) REFERENCES `hospitals` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `bed_recertifications_ibfk_2` FOREIGN KEY (`certified_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `bed_reservations`
--
ALTER TABLE `bed_reservations`
  ADD CONSTRAINT `bed_reservations_ibfk_1` FOREIGN KEY (`bed_id`) REFERENCES `beds` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `bed_reservations_ibfk_2` FOREIGN KEY (`hospital_id`) REFERENCES `hospitals` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `bed_reservations_ibfk_3` FOREIGN KEY (`reserved_by_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `blocks`
--
ALTER TABLE `blocks`
  ADD CONSTRAINT `blocks_ibfk_1` FOREIGN KEY (`district_id`) REFERENCES `districts` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `category_snapshots`
--
ALTER TABLE `category_snapshots`
  ADD CONSTRAINT `category_snapshots_ibfk_1` FOREIGN KEY (`hospital_id`) REFERENCES `hospitals` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `category_snapshots_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `bed_categories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `departments`
--
ALTER TABLE `departments`
  ADD CONSTRAINT `departments_ibfk_1` FOREIGN KEY (`hospital_id`) REFERENCES `hospitals` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `elective_bookings`
--
ALTER TABLE `elective_bookings`
  ADD CONSTRAINT `elective_bookings_ibfk_1` FOREIGN KEY (`hospital_id`) REFERENCES `hospitals` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `elective_bookings_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `bed_categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `elective_bookings_ibfk_3` FOREIGN KEY (`held_bed_id`) REFERENCES `beds` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `expected_discharges`
--
ALTER TABLE `expected_discharges`
  ADD CONSTRAINT `expected_discharges_ibfk_1` FOREIGN KEY (`hospital_id`) REFERENCES `hospitals` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `expected_discharges_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `bed_categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `expected_discharges_ibfk_3` FOREIGN KEY (`reported_by_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `heartbeats`
--
ALTER TABLE `heartbeats`
  ADD CONSTRAINT `heartbeats_ibfk_1` FOREIGN KEY (`hospital_id`) REFERENCES `hospitals` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `helpdesk_tickets`
--
ALTER TABLE `helpdesk_tickets`
  ADD CONSTRAINT `helpdesk_tickets_ibfk_1` FOREIGN KEY (`hospital_id`) REFERENCES `hospitals` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `helpdesk_tickets_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `helpdesk_tickets_ibfk_3` FOREIGN KEY (`assigned_to`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `pmjay_tags`
--
ALTER TABLE `pmjay_tags`
  ADD CONSTRAINT `pmjay_tags_ibfk_1` FOREIGN KEY (`hospital_id`) REFERENCES `hospitals` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `rosters`
--
ALTER TABLE `rosters`
  ADD CONSTRAINT `rosters_ibfk_1` FOREIGN KEY (`hospital_id`) REFERENCES `hospitals` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `rosters_ibfk_2` FOREIGN KEY (`bed_manager_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `rosters_ibfk_3` FOREIGN KEY (`backup_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `sms_notifications`
--
ALTER TABLE `sms_notifications`
  ADD CONSTRAINT `sms_notifications_ibfk_1` FOREIGN KEY (`hospital_id`) REFERENCES `hospitals` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `sms_notifications_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `spot_checks`
--
ALTER TABLE `spot_checks`
  ADD CONSTRAINT `spot_checks_ibfk_1` FOREIGN KEY (`hospital_id`) REFERENCES `hospitals` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `spot_checks_ibfk_2` FOREIGN KEY (`ward_id`) REFERENCES `wards` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `spot_checks_ibfk_3` FOREIGN KEY (`category_id`) REFERENCES `bed_categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `spot_checks_ibfk_4` FOREIGN KEY (`conducted_by_user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `surge_activations`
--
ALTER TABLE `surge_activations`
  ADD CONSTRAINT `surge_activations_ibfk_1` FOREIGN KEY (`hospital_id`) REFERENCES `hospitals` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `surge_activations_ibfk_2` FOREIGN KEY (`activated_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `surge_activations_ibfk_3` FOREIGN KEY (`deactivated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `surge_activations_ibfk_4` FOREIGN KEY (`target_ward_id`) REFERENCES `wards` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `system_alerts`
--
ALTER TABLE `system_alerts`
  ADD CONSTRAINT `system_alerts_ibfk_1` FOREIGN KEY (`district_id`) REFERENCES `districts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `system_alerts_ibfk_2` FOREIGN KEY (`hospital_id`) REFERENCES `hospitals` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `system_alerts_ibfk_3` FOREIGN KEY (`category_id`) REFERENCES `bed_categories` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `system_alerts_ibfk_4` FOREIGN KEY (`acknowledged_by_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `system_alerts_ibfk_5` FOREIGN KEY (`resolved_by_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;
COMMIT;
SET FOREIGN_KEY_CHECKS = 1;

/*!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 */;