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

START TRANSACTION;



--
-- Database: `db_polyhair`
--

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

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

CREATE TABLE `appointments` (
  `id` bigint UNSIGNED NOT NULL,
  `booking_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `promotion_id` bigint UNSIGNED DEFAULT NULL,
  `discount_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `guest_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `guest_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `guest_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `employee_id` bigint UNSIGNED DEFAULT NULL,
  `status` enum('Chờ xử lý','Chờ xác nhận','Đã xác nhận','Đang thực hiện','Hoàn thành','Đã hủy','Chưa thanh toán','Đã thanh toán') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_at` timestamp NULL DEFAULT NULL,
  `end_at` timestamp NULL DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `cancellation_reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `appointments` (`id`, `booking_code`, `promotion_id`, `discount_amount`, `user_id`, `guest_name`, `guest_phone`, `guest_email`, `employee_id`, `status`, `start_at`, `end_at`, `note`, `cancellation_reason`, `created_at`, `updated_at`, `deleted_at`) VALUES
(162, 'POLY-HB-001', 29, '15000.00', 10, NULL, NULL, NULL, 1, 'Đã thanh toán', '2025-12-20 00:00:00', '2025-12-20 02:10:00', NULL, NULL, '2025-12-19 01:11:33', '2025-12-19 01:18:49', NULL),
(163, 'POLY-HB-002', NULL, '0.00', 10, NULL, NULL, NULL, 1, 'Đã xác nhận', '2025-12-20 00:00:00', '2025-12-20 01:10:00', NULL, NULL, '2025-12-19 01:20:44', '2025-12-19 01:21:10', NULL),
(164, 'POLY-HB-003', 29, '15000.00', 10, NULL, NULL, NULL, 1, 'Đã thanh toán', '2025-12-20 01:30:00', '2025-12-20 07:50:00', NULL, NULL, '2025-12-19 02:53:30', '2025-12-19 05:27:18', NULL),
(165, 'POLY-HB-004', NULL, '0.00', 10, NULL, NULL, NULL, 1, 'Hoàn thành', '2025-12-21 00:00:00', '2025-12-21 03:30:00', NULL, NULL, '2025-12-19 17:33:04', '2025-12-19 17:59:36', NULL),
(166, 'POLY-HB-005', NULL, '0.00', 10, NULL, NULL, NULL, 1, 'Chưa thanh toán', '2025-12-21 03:30:00', '2025-12-21 04:40:00', NULL, NULL, '2025-12-19 18:06:00', '2025-12-19 19:55:37', NULL),
(167, 'POLY-HB-006', NULL, '0.00', 10, NULL, NULL, NULL, 1, 'Đã thanh toán', '2025-12-21 03:30:00', '2025-12-21 06:00:00', NULL, NULL, '2025-12-19 20:31:03', '2025-12-19 20:39:36', NULL),
(168, 'POLY-HB-007', NULL, '0.00', 10, NULL, NULL, NULL, 1, 'Đã thanh toán', '2025-12-21 03:30:00', '2025-12-21 06:40:00', NULL, NULL, '2025-12-20 00:05:15', '2025-12-20 00:06:17', NULL),
(169, 'POLY-HB-008', NULL, '0.00', 10, NULL, NULL, NULL, 1, 'Đã thanh toán', '2025-12-21 03:30:00', '2025-12-21 05:30:00', NULL, NULL, '2025-12-20 00:15:05', '2025-12-20 00:15:46', NULL),
(170, 'POLY-HB-009', NULL, '0.00', 10, NULL, NULL, NULL, 1, 'Đã thanh toán', '2025-12-21 03:30:00', '2025-12-21 06:10:00', NULL, NULL, '2025-12-20 00:23:25', '2025-12-20 00:23:49', NULL),
(171, 'POLY-HB-010', NULL, '0.00', 10, NULL, NULL, NULL, 1, 'Đã xác nhận', '2025-12-21 03:30:00', '2025-12-21 05:10:00', NULL, NULL, '2025-12-20 00:28:28', '2025-12-20 02:03:26', NULL),
(172, 'POLY-HB-011', NULL, '0.00', 10, NULL, NULL, NULL, 5, 'Đã thanh toán', '2025-12-21 00:00:00', '2025-12-21 03:00:00', NULL, NULL, '2025-12-20 00:30:34', '2025-12-20 00:31:11', NULL),
(173, 'POLY-HB-012', NULL, '0.00', 10, NULL, NULL, NULL, 1, 'Hoàn thành', '2025-12-21 05:30:00', '2025-12-21 08:30:00', NULL, NULL, '2025-12-20 00:42:47', '2025-12-20 00:43:12', NULL),
(174, 'POLY-HB-013', NULL, '0.00', 10, NULL, NULL, NULL, 1, 'Hoàn thành', '2025-12-21 08:30:00', '2025-12-21 10:30:00', NULL, NULL, '2025-12-20 00:43:46', '2025-12-20 00:44:00', NULL),
(175, 'POLY-HB-014', NULL, '0.00', 10, NULL, NULL, NULL, 1, 'Đã thanh toán', '2025-12-21 10:30:00', '2025-12-21 12:30:00', NULL, NULL, '2025-12-20 00:50:55', '2025-12-20 00:51:56', NULL),
(176, 'POLY-HB-015', NULL, '0.00', 18, NULL, NULL, NULL, 1, 'Hoàn thành', '2025-12-21 10:30:00', '2025-12-21 13:30:00', NULL, NULL, '2025-12-20 00:53:16', '2025-12-20 00:57:33', NULL),
(177, 'POLY-HB-016', NULL, '0.00', 7, NULL, NULL, NULL, 1, 'Hoàn thành', '2025-12-21 13:30:00', '2025-12-21 15:00:00', NULL, NULL, '2025-12-20 01:12:18', '2025-12-20 01:12:42', NULL),
(178, 'POLY-HB-017', NULL, '0.00', 7, NULL, NULL, NULL, 5, 'Hoàn thành', '2025-12-21 00:00:00', '2025-12-21 02:00:00', NULL, NULL, '2025-12-20 01:14:24', '2025-12-20 01:15:12', NULL),
(179, 'POLY-HB-018', NULL, '0.00', 7, NULL, NULL, NULL, 5, 'Hoàn thành', '2025-12-21 02:00:00', '2025-12-21 03:10:00', NULL, NULL, '2025-12-20 01:21:11', '2025-12-20 01:23:01', NULL),
(180, 'POLY-HB-019', NULL, '0.00', 19, NULL, NULL, NULL, 5, 'Đã thanh toán', '2025-12-21 03:30:00', '2025-12-21 06:30:00', NULL, NULL, '2025-12-20 01:26:00', '2025-12-20 01:26:49', NULL),
(181, 'POLY-HB-020', NULL, '0.00', 19, NULL, NULL, NULL, 5, 'Đã thanh toán', '2025-12-21 03:30:00', '2025-12-21 06:00:00', NULL, NULL, '2025-12-20 01:36:32', '2025-12-20 01:37:49', NULL),
(182, 'POLY-HB-021', NULL, '0.00', 19, NULL, NULL, NULL, 5, 'Đã thanh toán', '2025-12-21 03:30:00', '2025-12-21 04:40:00', NULL, NULL, '2025-12-20 01:44:23', '2025-12-20 01:45:07', NULL),
(183, 'POLY-HB-022', NULL, '0.00', 19, NULL, NULL, NULL, 5, 'Đã xác nhận', '2025-12-21 03:30:00', '2025-12-21 05:00:00', NULL, NULL, '2025-12-20 01:58:49', '2025-12-20 02:08:27', NULL),
(184, 'POLY-HB-023', NULL, '0.00', 19, NULL, NULL, NULL, 5, 'Đã thanh toán', '2025-12-21 05:00:00', '2025-12-21 06:10:00', NULL, NULL, '2025-12-20 02:10:56', '2025-12-20 19:39:58', NULL),
(185, 'POLY-HB-024', 33, '15000.00', 7, NULL, NULL, NULL, 1, 'Đã thanh toán', '2025-12-22 00:00:00', '2025-12-22 01:10:00', NULL, NULL, '2025-12-20 07:05:34', '2025-12-20 19:41:09', NULL),
(186, 'POLY-HB-025', NULL, '0.00', 7, NULL, NULL, NULL, 5, 'Đã xác nhận', '2025-12-22 00:00:00', '2025-12-22 02:30:00', NULL, NULL, '2025-12-20 07:43:31', '2025-12-20 08:13:31', NULL),
(187, 'POLY-HB-026', NULL, '0.00', 20, NULL, NULL, NULL, 5, 'Đã xác nhận', '2025-12-23 00:00:00', '2025-12-23 00:10:00', 'ghi chú đặt lịch', NULL, '2025-12-20 18:20:34', '2025-12-20 19:41:56', NULL),
(188, 'POLY-HB-027', NULL, '0.00', 20, NULL, NULL, NULL, 5, 'Đã xác nhận', '2025-12-22 02:30:00', '2025-12-22 03:10:00', 'Lịch khám', NULL, '2025-12-20 19:11:49', '2025-12-20 19:41:57', NULL),
(189, 'POLY-HB-028', NULL, '0.00', 20, NULL, NULL, NULL, 5, 'Đã thanh toán', '2025-12-23 00:30:00', '2025-12-23 01:30:00', NULL, NULL, '2025-12-20 19:18:28', '2025-12-20 21:46:58', NULL),
(190, 'POLY-HB-029', NULL, '0.00', 20, NULL, NULL, NULL, 5, 'Đã thanh toán', '2025-12-22 03:30:00', '2025-12-22 04:30:00', NULL, NULL, '2025-12-20 19:44:19', '2025-12-20 19:46:44', NULL),
(191, 'POLY-HB-030', NULL, '0.00', 20, NULL, NULL, NULL, 5, 'Đã thanh toán', '2025-12-23 01:30:00', '2025-12-23 02:30:00', NULL, NULL, '2025-12-20 20:15:00', '2025-12-20 21:26:35', NULL),
(192, 'POLY-HB-031', NULL, '0.00', 20, NULL, NULL, NULL, 5, 'Đã thanh toán', '2025-12-24 00:00:00', '2025-12-24 00:10:00', NULL, NULL, '2025-12-20 21:28:41', '2025-12-20 21:35:06', NULL),
(193, 'POLY-HB-032', NULL, '0.00', 20, NULL, NULL, NULL, 5, 'Chờ xử lý', '2025-12-24 00:00:00', '2025-12-24 00:50:00', NULL, NULL, '2025-12-20 22:03:48', '2025-12-20 22:03:48', NULL),
(194, 'POLY-HB-033', NULL, '0.00', 20, NULL, NULL, NULL, 5, 'Chờ xử lý', '2025-12-26 00:00:00', '2025-12-26 00:10:00', NULL, NULL, '2025-12-20 22:08:41', '2025-12-20 22:08:41', NULL),
(195, 'POLY-HB-034', NULL, '0.00', 20, NULL, NULL, NULL, 5, 'Đã thanh toán', '2025-12-26 00:30:00', '2025-12-26 01:30:00', NULL, NULL, '2025-12-20 22:09:42', '2025-12-20 22:22:09', NULL),
(196, 'POLY-HB-035', NULL, '0.00', 20, NULL, NULL, NULL, 5, 'Chờ xử lý', '2025-12-27 00:00:00', '2025-12-27 00:10:00', NULL, NULL, '2025-12-20 22:19:06', '2025-12-20 22:19:06', NULL),
(197, 'POLY-HB-036', NULL, '0.00', 20, NULL, NULL, NULL, 5, 'Hoàn thành', '2025-12-27 00:30:00', '2025-12-27 01:10:00', NULL, NULL, '2025-12-20 22:23:55', '2025-12-20 22:25:00', NULL);

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

--
-- Table structure for table `appointment_details`
--

CREATE TABLE `appointment_details` (
  `id` bigint UNSIGNED NOT NULL,
  `appointment_id` bigint UNSIGNED DEFAULT NULL,
  `service_variant_id` bigint UNSIGNED DEFAULT NULL,
  `combo_id` bigint UNSIGNED DEFAULT NULL,
  `combo_item_id` bigint UNSIGNED DEFAULT NULL,
  `employee_id` bigint UNSIGNED DEFAULT NULL,
  `price_snapshot` decimal(10,2) DEFAULT NULL,
  `promotion_id` bigint UNSIGNED DEFAULT NULL,
  `duration` int DEFAULT NULL,
  `status` enum('Chờ','Xác nhận','Đang thực hiện','Hoàn thành','Hủy','Đã hủy') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `appointment_details`
--

INSERT INTO `appointment_details` (`id`, `appointment_id`, `service_variant_id`, `combo_id`, `combo_item_id`, `employee_id`, `price_snapshot`, `promotion_id`, `duration`, `status`, `notes`, `created_at`, `updated_at`) VALUES
(760, 162, NULL, NULL, NULL, 1, '34000.00', NULL, 10, 'Hoàn thành', 'Gội đầu', '2025-12-19 01:11:33', '2025-12-19 01:18:49'),
(761, 162, NULL, NULL, NULL, 1, '68000.00', NULL, 30, 'Hoàn thành', 'Cắt tóc nam', '2025-12-19 01:11:33', '2025-12-19 01:18:49'),
(762, 162, NULL, NULL, NULL, 1, '25500.00', NULL, 30, 'Hoàn thành', 'Cắt tóc trẻ em', '2025-12-19 01:11:33', '2025-12-19 01:18:49'),
(763, 162, NULL, NULL, NULL, 1, '118150.00', NULL, 30, 'Hoàn thành', 'Gội thư giãn cổ vai gáy', '2025-12-19 01:11:33', '2025-12-19 01:18:49'),
(764, 162, NULL, NULL, NULL, 1, '41650.00', NULL, 30, 'Hoàn thành', 'Đánh bay mụn cám lột mụn full face', '2025-12-19 01:11:33', '2025-12-19 01:18:49'),
(765, 163, NULL, NULL, NULL, 1, '34000.00', NULL, 10, 'Chờ', 'Gội đầu', '2025-12-19 01:20:44', '2025-12-19 01:20:44'),
(766, 163, NULL, NULL, NULL, 1, '68000.00', NULL, 30, 'Chờ', 'Cắt tóc nam', '2025-12-19 01:20:44', '2025-12-19 01:20:44'),
(767, 163, NULL, NULL, NULL, 1, '118150.00', NULL, 30, 'Chờ', 'Gội thư giãn cổ vai gáy', '2025-12-19 01:20:44', '2025-12-19 01:20:44'),
(768, 164, 18, NULL, NULL, 1, '127500.00', NULL, 60, 'Hoàn thành', NULL, '2025-12-19 02:53:30', '2025-12-19 02:57:20'),
(769, 164, NULL, 1, NULL, 1, '101150.00', NULL, 60, 'Hoàn thành', 'PolyCombo', '2025-12-19 02:53:30', '2025-12-19 02:57:20'),
(770, 164, NULL, NULL, NULL, 1, '68000.00', NULL, 30, 'Hoàn thành', 'Cắt tóc nam', '2025-12-19 02:53:30', '2025-12-19 02:57:20'),
(771, 164, NULL, NULL, NULL, 1, '41650.00', NULL, 30, 'Hoàn thành', 'Đánh bay mụn cám lột mụn full face', '2025-12-19 02:53:30', '2025-12-19 02:57:20'),
(772, 164, NULL, NULL, NULL, 1, '35000.00', NULL, 20, 'Hoàn thành', 'Tẩy da chết sủi bọt Hàn Quốc', '2025-12-19 04:06:00', '2025-12-19 05:17:30'),
(773, 164, 18, NULL, NULL, 1, '150000.00', NULL, 60, 'Hoàn thành', NULL, '2025-12-19 04:06:23', '2025-12-19 05:17:30'),
(774, 164, 29, NULL, NULL, 1, '424000.00', NULL, 120, 'Hoàn thành', NULL, '2025-12-19 04:21:54', '2025-12-19 05:17:30'),
(775, 165, 18, NULL, NULL, 1, '127500.00', NULL, 60, 'Hoàn thành', NULL, '2025-12-19 17:33:04', '2025-12-19 17:36:13'),
(776, 165, NULL, NULL, NULL, 1, '20000.00', NULL, 30, 'Hoàn thành', 'Cắt tóc trẻ em', '2025-12-19 17:33:04', '2025-12-19 17:36:13'),
(777, 165, NULL, NULL, NULL, 1, '68000.00', NULL, 30, 'Hoàn thành', 'Cắt tóc nam', '2025-12-19 17:33:04', '2025-12-19 17:36:13'),
(778, 165, 27, NULL, NULL, 1, '524000.00', NULL, 90, 'Hoàn thành', NULL, '2025-12-19 17:35:08', '2025-12-19 17:36:13'),
(779, 166, NULL, NULL, NULL, 1, '68000.00', NULL, 30, 'Chờ', 'Cắt tóc nam', '2025-12-19 18:06:00', '2025-12-19 18:06:00'),
(780, 166, NULL, NULL, NULL, 1, '20000.00', NULL, 30, 'Chờ', 'Cắt tóc trẻ em', '2025-12-19 18:06:00', '2025-12-19 18:06:00'),
(781, 166, NULL, NULL, NULL, 1, '30000.00', NULL, 10, 'Chờ', 'Gội đầu', '2025-12-19 18:06:00', '2025-12-19 18:06:00'),
(782, 167, 29, NULL, NULL, 1, '424000.00', NULL, 120, 'Hoàn thành', NULL, '2025-12-19 20:31:03', '2025-12-19 20:39:36'),
(783, 167, NULL, NULL, NULL, 1, '68000.00', NULL, 30, 'Hoàn thành', 'Cắt tóc nam', '2025-12-19 20:31:03', '2025-12-19 20:39:36'),
(784, 168, 29, NULL, NULL, 1, '424000.00', NULL, 120, 'Hoàn thành', NULL, '2025-12-20 00:05:15', '2025-12-20 00:06:17'),
(785, 168, NULL, NULL, NULL, 1, '68000.00', NULL, 30, 'Hoàn thành', 'Cắt tóc nam', '2025-12-20 00:05:15', '2025-12-20 00:06:17'),
(786, 168, NULL, NULL, NULL, 1, '20000.00', NULL, 30, 'Hoàn thành', 'Cắt tóc trẻ em', '2025-12-20 00:05:15', '2025-12-20 00:06:17'),
(787, 168, NULL, NULL, NULL, 1, '30000.00', NULL, 10, 'Hoàn thành', 'Gội đầu', '2025-12-20 00:05:15', '2025-12-20 00:06:17'),
(788, 169, 27, NULL, NULL, 1, '524000.00', NULL, 90, 'Hoàn thành', NULL, '2025-12-20 00:15:05', '2025-12-20 00:15:46'),
(789, 169, NULL, NULL, NULL, 1, '68000.00', NULL, 30, 'Hoàn thành', 'Cắt tóc nam', '2025-12-20 00:15:05', '2025-12-20 00:15:46'),
(790, 170, 29, NULL, NULL, 1, '424000.00', NULL, 120, 'Hoàn thành', NULL, '2025-12-20 00:23:25', '2025-12-20 00:23:49'),
(791, 170, NULL, NULL, NULL, 1, '68000.00', NULL, 30, 'Hoàn thành', 'Cắt tóc nam', '2025-12-20 00:23:25', '2025-12-20 00:23:49'),
(792, 170, NULL, NULL, NULL, 1, '30000.00', NULL, 10, 'Hoàn thành', 'Gội đầu', '2025-12-20 00:23:25', '2025-12-20 00:23:49'),
(793, 171, NULL, 1, NULL, 1, '101150.00', NULL, 60, 'Chờ', 'PolyCombo', '2025-12-20 00:28:28', '2025-12-20 00:28:28'),
(794, 171, NULL, NULL, NULL, 1, '30000.00', NULL, 10, 'Chờ', 'Gội đầu', '2025-12-20 00:28:28', '2025-12-20 00:28:28'),
(795, 171, NULL, NULL, NULL, 1, '118150.00', NULL, 30, 'Chờ', 'Gội thư giãn cổ vai gáy', '2025-12-20 00:28:28', '2025-12-20 00:28:28'),
(796, 172, 30, NULL, NULL, 5, '524000.00', NULL, 180, 'Hoàn thành', NULL, '2025-12-20 00:30:34', '2025-12-20 00:31:11'),
(797, 173, 30, NULL, NULL, 1, '524000.00', NULL, 180, 'Chờ', NULL, '2025-12-20 00:42:47', '2025-12-20 00:42:47'),
(798, 174, 29, NULL, NULL, 1, '424000.00', NULL, 120, 'Chờ', NULL, '2025-12-20 00:43:46', '2025-12-20 00:43:46'),
(799, 175, 29, NULL, NULL, 1, '439000.00', NULL, 120, 'Hoàn thành', NULL, '2025-12-20 00:50:55', '2025-12-20 00:51:56'),
(800, 176, 30, NULL, NULL, 1, '524000.00', NULL, 180, 'Chờ', NULL, '2025-12-20 00:53:16', '2025-12-20 00:53:16'),
(801, 177, 18, NULL, NULL, 1, '127500.00', NULL, 60, 'Chờ', NULL, '2025-12-20 01:12:18', '2025-12-20 01:12:18'),
(802, 177, NULL, NULL, NULL, 1, '68000.00', NULL, 30, 'Chờ', 'Cắt tóc nam', '2025-12-20 01:12:18', '2025-12-20 01:12:18'),
(803, 178, 29, NULL, NULL, 5, '424000.00', NULL, 120, 'Chờ', NULL, '2025-12-20 01:14:24', '2025-12-20 01:14:24'),
(804, 179, NULL, NULL, NULL, 5, '68000.00', NULL, 30, 'Chờ', 'Cắt tóc nam', '2025-12-20 01:21:11', '2025-12-20 01:21:11'),
(805, 179, NULL, NULL, NULL, 5, '30000.00', NULL, 10, 'Chờ', 'Gội đầu', '2025-12-20 01:21:11', '2025-12-20 01:21:11'),
(806, 179, NULL, NULL, NULL, 5, '118150.00', NULL, 30, 'Chờ', 'Gội thư giãn cổ vai gáy', '2025-12-20 01:21:11', '2025-12-20 01:21:11'),
(807, 180, 30, NULL, NULL, 5, '524000.00', NULL, 180, 'Hoàn thành', NULL, '2025-12-20 01:26:00', '2025-12-20 01:26:49'),
(808, 181, 29, NULL, NULL, 5, '439000.00', NULL, 120, 'Hoàn thành', NULL, '2025-12-20 01:36:32', '2025-12-20 01:37:49'),
(809, 181, NULL, NULL, NULL, 5, '20000.00', NULL, 30, 'Hoàn thành', 'Cắt tóc trẻ em', '2025-12-20 01:37:29', '2025-12-20 01:37:49'),
(810, 182, NULL, NULL, NULL, 5, '80000.00', NULL, 30, 'Hoàn thành', 'Cắt tóc nam', '2025-12-20 01:44:23', '2025-12-20 01:45:07'),
(811, 182, NULL, NULL, NULL, 5, '30000.00', NULL, 30, 'Hoàn thành', 'Cắt tóc trẻ em', '2025-12-20 01:44:23', '2025-12-20 01:45:07'),
(812, 182, NULL, NULL, NULL, 5, '30000.00', NULL, 10, 'Hoàn thành', 'Gội đầu', '2025-12-20 01:44:59', '2025-12-20 01:45:07'),
(813, 183, 18, NULL, NULL, 5, '150000.00', NULL, 60, 'Chờ', NULL, '2025-12-20 01:58:49', '2025-12-20 01:58:49'),
(814, 183, NULL, NULL, NULL, 5, '80000.00', NULL, 30, 'Chờ', 'Cắt tóc nam', '2025-12-20 01:58:49', '2025-12-20 01:58:49'),
(815, 184, NULL, NULL, NULL, 5, '80000.00', NULL, 30, 'Hoàn thành', 'Cắt tóc nam', '2025-12-20 02:10:56', '2025-12-20 19:39:58'),
(816, 184, NULL, NULL, NULL, 5, '30000.00', NULL, 30, 'Hoàn thành', 'Cắt tóc trẻ em', '2025-12-20 02:10:56', '2025-12-20 19:39:58'),
(817, 184, NULL, NULL, NULL, 5, '40000.00', NULL, 10, 'Hoàn thành', 'Gội đầu', '2025-12-20 02:10:56', '2025-12-20 19:39:58'),
(818, 185, 18, NULL, NULL, 1, '127500.00', NULL, 60, 'Hoàn thành', NULL, '2025-12-20 07:05:34', '2025-12-20 07:06:30'),
(819, 185, NULL, NULL, NULL, 1, '30000.00', NULL, 10, 'Hoàn thành', 'Gội đầu', '2025-12-20 07:05:34', '2025-12-20 07:06:30'),
(820, 186, 18, NULL, NULL, 5, '150000.00', NULL, 60, 'Chờ', NULL, '2025-12-20 07:43:31', '2025-12-20 07:43:31'),
(821, 186, NULL, 1, NULL, 5, '119000.00', NULL, 60, 'Chờ', 'PolyCombo', '2025-12-20 07:43:31', '2025-12-20 07:43:31'),
(822, 186, NULL, NULL, NULL, 5, '80000.00', NULL, 30, 'Chờ', 'Cắt tóc nam', '2025-12-20 07:43:31', '2025-12-20 07:43:31'),
(823, 187, NULL, NULL, NULL, 5, '40000.00', NULL, 10, 'Chờ', 'Gội đầu', '2025-12-20 18:20:34', '2025-12-20 18:20:34'),
(824, 188, NULL, NULL, NULL, 5, '46247.19', NULL, 30, 'Chờ', 'Đánh bay mụn cám lột mụn full face', '2025-12-20 19:11:49', '2025-12-20 19:11:49'),
(825, 188, NULL, NULL, NULL, 5, '37752.81', NULL, 10, 'Chờ', 'Gội đầu', '2025-12-20 19:11:49', '2025-12-20 19:11:49'),
(826, 189, NULL, NULL, NULL, 5, '23478.26', NULL, 10, 'Hoàn thành', 'Gội đầu', '2025-12-20 19:18:28', '2025-12-20 21:46:58'),
(827, 189, NULL, NULL, NULL, 5, '30521.74', NULL, 30, 'Hoàn thành', 'Đánh bay mụn cám lột mụn full face', '2025-12-20 19:18:28', '2025-12-20 21:46:58'),
(828, 190, NULL, NULL, NULL, 5, '24000.00', NULL, 10, 'Hoàn thành', 'Gội đầu', '2025-12-20 19:44:19', '2025-12-20 19:46:44'),
(829, 190, NULL, NULL, NULL, 5, '36000.00', NULL, 40, 'Hoàn thành', 'Chăm sóc da Ultrawhite', '2025-12-20 19:44:19', '2025-12-20 19:46:44'),
(830, 191, NULL, NULL, NULL, 5, '30000.00', NULL, 10, 'Hoàn thành', 'Gội đầu', '2025-12-20 20:15:00', '2025-12-20 21:26:35'),
(831, 191, NULL, NULL, NULL, 5, '45000.00', NULL, 40, 'Hoàn thành', 'Chăm sóc da Ultrawhite', '2025-12-20 20:15:00', '2025-12-20 21:26:35'),
(832, 192, NULL, NULL, NULL, 5, '40000.00', NULL, 10, 'Hoàn thành', 'Gội đầu', '2025-12-20 21:28:41', '2025-12-20 21:29:23'),
(833, 193, NULL, NULL, NULL, 5, '40000.00', NULL, 10, 'Chờ', 'Gội đầu', '2025-12-20 22:03:48', '2025-12-20 22:03:48'),
(834, 193, NULL, NULL, NULL, 5, '55000.00', NULL, 40, 'Chờ', 'Chăm sóc da Ultrawhite', '2025-12-20 22:03:48', '2025-12-20 22:03:48'),
(835, 194, NULL, NULL, NULL, 5, '30000.00', NULL, 10, 'Chờ', 'Gội đầu', '2025-12-20 22:08:41', '2025-12-20 22:08:41'),
(836, 195, NULL, NULL, NULL, 5, '45000.00', NULL, 40, 'Hoàn thành', 'Chăm sóc da Ultrawhite', '2025-12-20 22:09:42', '2025-12-20 22:22:09'),
(837, 195, NULL, NULL, NULL, 5, '30000.00', NULL, 10, 'Hoàn thành', 'Gội đầu', '2025-12-20 22:09:42', '2025-12-20 22:22:09'),
(838, 196, NULL, NULL, NULL, 5, '30000.00', NULL, 10, 'Chờ', 'Gội đầu', '2025-12-20 22:19:07', '2025-12-20 22:19:07'),
(839, 197, NULL, NULL, NULL, 5, '30000.00', NULL, 10, 'Hoàn thành', 'Gội đầu', '2025-12-20 22:23:55', '2025-12-20 22:25:00'),
(840, 197, NULL, NULL, NULL, 5, '20000.00', NULL, 30, 'Hoàn thành', 'Cắt tóc trẻ em', '2025-12-20 22:23:55', '2025-12-20 22:25:00');

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

--
-- Table structure for table `appointment_logs`
--

CREATE TABLE `appointment_logs` (
  `id` bigint UNSIGNED NOT NULL,
  `appointment_id` bigint UNSIGNED DEFAULT NULL,
  `status_from` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_to` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` bigint UNSIGNED DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `appointment_logs`
--

INSERT INTO `appointment_logs` (`id`, `appointment_id`, `status_from`, `status_to`, `modified_by`, `created_at`) VALUES
(329, 162, NULL, 'Chờ xử lý', 10, '2025-12-19 01:11:33'),
(330, 162, 'Chờ xử lý', 'Hoàn thành', 1, '2025-12-19 01:12:41'),
(331, 163, NULL, 'Chờ xử lý', 10, '2025-12-19 01:20:44'),
(332, 163, 'Chờ xử lý', 'Đã xác nhận', NULL, '2025-12-19 01:21:10'),
(333, 164, NULL, 'Chờ xử lý', 10, '2025-12-19 02:53:30'),
(334, 164, 'Chờ xử lý', 'Hoàn thành', 1, '2025-12-19 02:54:36'),
(335, 164, 'Đã thanh toán', 'Chờ xử lý', 1, '2025-12-19 04:06:00'),
(336, 164, 'Chờ xử lý', 'Hoàn thành', 1, '2025-12-19 04:23:13'),
(337, 164, 'Đã thanh toán', 'Hoàn thành', 1, '2025-12-19 05:18:19'),
(338, 164, 'Đã thanh toán', 'Hoàn thành', 1, '2025-12-19 05:20:40'),
(339, 165, NULL, 'Chờ xử lý', 10, '2025-12-19 17:33:04'),
(340, 165, 'Chờ xử lý', 'Hoàn thành', 1, '2025-12-19 17:35:08'),
(341, 165, 'Đã thanh toán', 'Hoàn thành', 1, '2025-12-19 17:59:36'),
(342, 166, NULL, 'Chờ xử lý', 10, '2025-12-19 18:06:00'),
(343, 166, 'Chờ xử lý', 'Hoàn thành', 1, '2025-12-19 18:06:26'),
(344, 167, NULL, 'Chờ xử lý', 10, '2025-12-19 20:31:03'),
(345, 167, 'Chờ xử lý', 'Hoàn thành', 1, '2025-12-19 20:31:54'),
(346, 168, NULL, 'Chờ xử lý', 10, '2025-12-20 00:05:15'),
(347, 168, 'Chờ xử lý', 'Hoàn thành', 1, '2025-12-20 00:05:59'),
(348, 169, NULL, 'Chờ xử lý', 10, '2025-12-20 00:15:05'),
(349, 169, 'Chờ xử lý', 'Hoàn thành', 1, '2025-12-20 00:15:34'),
(350, 170, NULL, 'Chờ xử lý', 10, '2025-12-20 00:23:25'),
(351, 170, 'Chờ xử lý', 'Hoàn thành', 1, '2025-12-20 00:23:42'),
(352, 171, NULL, 'Chờ xử lý', 10, '2025-12-20 00:28:28'),
(353, 172, NULL, 'Chờ xử lý', 10, '2025-12-20 00:30:34'),
(354, 172, 'Chờ xử lý', 'Hoàn thành', 1, '2025-12-20 00:31:02'),
(355, 173, NULL, 'Chờ xử lý', 10, '2025-12-20 00:42:47'),
(356, 173, 'Chờ xử lý', 'Hoàn thành', 1, '2025-12-20 00:43:12'),
(357, 174, NULL, 'Chờ xử lý', 10, '2025-12-20 00:43:46'),
(358, 174, 'Chờ xử lý', 'Hoàn thành', 1, '2025-12-20 00:44:00'),
(359, 175, NULL, 'Chờ xử lý', 10, '2025-12-20 00:50:55'),
(360, 175, 'Chờ xử lý', 'Hoàn thành', 1, '2025-12-20 00:51:38'),
(361, 176, NULL, 'Chờ xử lý', 18, '2025-12-20 00:53:16'),
(362, 176, 'Chờ xử lý', 'Hoàn thành', 1, '2025-12-20 00:57:33'),
(363, 177, NULL, 'Chờ xử lý', 7, '2025-12-20 01:12:18'),
(364, 177, 'Chờ xử lý', 'Hoàn thành', 1, '2025-12-20 01:12:42'),
(365, 178, NULL, 'Chờ xử lý', 7, '2025-12-20 01:14:24'),
(366, 178, 'Chờ xử lý', 'Hoàn thành', 1, '2025-12-20 01:15:12'),
(367, 179, NULL, 'Chờ xử lý', 7, '2025-12-20 01:21:11'),
(368, 179, 'Chờ xử lý', 'Hoàn thành', 1, '2025-12-20 01:23:01'),
(369, 180, NULL, 'Chờ xử lý', 19, '2025-12-20 01:26:00'),
(370, 180, 'Chờ xử lý', 'Hoàn thành', 1, '2025-12-20 01:26:36'),
(371, 181, NULL, 'Chờ xử lý', 19, '2025-12-20 01:36:32'),
(372, 181, 'Chờ xử lý', 'Hoàn thành', 1, '2025-12-20 01:37:29'),
(373, 182, NULL, 'Chờ xử lý', 19, '2025-12-20 01:44:23'),
(374, 182, 'Chờ xử lý', 'Hoàn thành', 1, '2025-12-20 01:44:59'),
(375, 183, NULL, 'Chờ xử lý', 19, '2025-12-20 01:58:49'),
(376, 171, 'Chờ xử lý', 'Đã xác nhận', NULL, '2025-12-20 02:03:26'),
(377, 183, 'Chờ xử lý', 'Đã xác nhận', NULL, '2025-12-20 02:08:27'),
(378, 184, NULL, 'Chờ xử lý', 19, '2025-12-20 02:10:56'),
(379, 184, 'Chờ xử lý', 'Đã xác nhận', NULL, '2025-12-20 02:12:00'),
(380, 185, NULL, 'Chờ xử lý', 7, '2025-12-20 07:05:34'),
(381, 185, 'Chờ xử lý', 'Đã xác nhận', 17, '2025-12-20 07:05:53'),
(382, 185, 'Đã xác nhận', 'Đang thực hiện', 17, '2025-12-20 07:06:14'),
(383, 185, 'Đang thực hiện', 'Hoàn thành', 17, '2025-12-20 07:06:30'),
(384, 186, NULL, 'Chờ xử lý', 7, '2025-12-20 07:43:31'),
(385, 186, 'Chờ xử lý', 'Đã xác nhận', NULL, '2025-12-20 08:13:31'),
(386, 187, NULL, 'Chờ xử lý', 20, '2025-12-20 18:20:34'),
(387, 188, NULL, 'Chờ xử lý', 20, '2025-12-20 19:11:49'),
(388, 189, NULL, 'Chờ xử lý', 20, '2025-12-20 19:18:28'),
(389, 184, 'Đã xác nhận', 'Hoàn thành', 1, '2025-12-20 19:33:28'),
(390, 187, 'Chờ xử lý', 'Đã xác nhận', NULL, '2025-12-20 19:41:56'),
(391, 188, 'Chờ xử lý', 'Đã xác nhận', NULL, '2025-12-20 19:41:57'),
(392, 190, NULL, 'Chờ xử lý', 20, '2025-12-20 19:44:19'),
(393, 190, 'Chờ xử lý', 'Hoàn thành', 1, '2025-12-20 19:46:03'),
(394, 189, 'Chờ xử lý', 'Đã xác nhận', NULL, '2025-12-20 19:48:37'),
(395, 189, 'Đã xác nhận', 'Hoàn thành', 1, '2025-12-20 20:12:22'),
(396, 191, NULL, 'Chờ xử lý', 20, '2025-12-20 20:15:00'),
(397, 191, 'Chờ xử lý', 'Hoàn thành', 1, '2025-12-20 20:15:26'),
(398, 192, NULL, 'Chờ xử lý', 20, '2025-12-20 21:28:41'),
(399, 192, 'Chờ xử lý', 'Đã xác nhận', 2, '2025-12-20 21:29:00'),
(400, 192, 'Đã xác nhận', 'Đang thực hiện', 2, '2025-12-20 21:29:16'),
(401, 192, 'Đang thực hiện', 'Hoàn thành', 2, '2025-12-20 21:29:23'),
(402, 193, NULL, 'Chờ xử lý', 20, '2025-12-20 22:03:48'),
(403, 194, NULL, 'Chờ xử lý', 20, '2025-12-20 22:08:41'),
(404, 195, NULL, 'Chờ xử lý', 20, '2025-12-20 22:09:42'),
(405, 195, 'Chờ xử lý', 'Hoàn thành', 1, '2025-12-20 22:10:27'),
(406, 196, NULL, 'Chờ xử lý', 20, '2025-12-20 22:19:07'),
(407, 197, NULL, 'Chờ xử lý', 20, '2025-12-20 22:23:55'),
(408, 197, 'Chờ xử lý', 'Đã xác nhận', 5, '2025-12-20 22:24:45'),
(409, 197, 'Đã xác nhận', 'Đang thực hiện', 5, '2025-12-20 22:24:53'),
(410, 197, 'Đang thực hiện', 'Hoàn thành', 5, '2025-12-20 22:25:00');

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

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

CREATE TABLE `categories` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `images` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `combos`
--

CREATE TABLE `combos` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category_id` bigint UNSIGNED DEFAULT NULL,
  `owner_service_id` bigint UNSIGNED DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `duration` int DEFAULT NULL,
  `status` enum('Hoạt động','Vô hiệu hóa') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sort_order` int UNSIGNED NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `combos`
--

INSERT INTO `combos` (`id`, `name`, `slug`, `description`, `image`, `category_id`, `owner_service_id`, `price`, `duration`, `status`, `sort_order`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'PolyCombo', 'polycombo-69318da4ce6f3', NULL, '1764856541_kiem-tra-va-hoan-thien.jpg', 5, NULL, '119000.00', 60, 'Hoạt động', 0, '2025-12-04 06:33:24', '2025-12-04 15:20:18', NULL),
(2, 'test', 'test-693209abb88af', NULL, NULL, 7, NULL, '500000.00', 60, 'Hoạt động', 0, '2025-12-04 15:22:35', '2025-12-04 15:22:35', NULL),
(3, 'BOY', 'boy-69321070467fc', 'good', NULL, 9, NULL, '450000.00', 100, 'Hoạt động', 0, '2025-12-04 15:51:28', '2025-12-04 15:51:28', NULL),
(4, 't', 't-69321275655d2', NULL, NULL, 7, NULL, '100000.00', 70, 'Hoạt động', 0, '2025-12-04 16:00:05', '2025-12-04 16:00:05', NULL);

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

--
-- Table structure for table `combo_items`
--

CREATE TABLE `combo_items` (
  `id` bigint UNSIGNED NOT NULL,
  `combo_id` bigint UNSIGNED DEFAULT NULL,
  `service_id` bigint UNSIGNED DEFAULT NULL,
  `service_variant_id` bigint UNSIGNED DEFAULT NULL,
  `quantity` int UNSIGNED NOT NULL DEFAULT '1',
  `price_override` decimal(10,2) DEFAULT NULL,
  `notes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `combo_items`
--

INSERT INTO `combo_items` (`id`, `combo_id`, `service_id`, `service_variant_id`, `quantity`, `price_override`, `notes`, `created_at`, `updated_at`) VALUES
(35, 1, 10, NULL, 1, NULL, NULL, '2025-12-04 07:37:54', '2025-12-04 07:37:54'),
(36, 1, 12, NULL, 1, NULL, NULL, '2025-12-04 07:37:54', '2025-12-04 07:37:54'),
(37, 2, 10, NULL, 1, NULL, NULL, '2025-12-04 15:22:35', '2025-12-04 15:22:35'),
(38, 2, 12, NULL, 1, NULL, NULL, '2025-12-04 15:22:35', '2025-12-04 15:22:35'),
(39, 3, 10, NULL, 1, NULL, NULL, '2025-12-04 15:51:28', '2025-12-04 15:51:28'),
(40, 3, 21, NULL, 1, NULL, NULL, '2025-12-04 15:51:28', '2025-12-04 15:51:28'),
(41, 3, 16, 21, 1, NULL, NULL, '2025-12-04 15:51:28', '2025-12-04 15:51:28'),
(42, 4, 9, NULL, 1, NULL, NULL, '2025-12-04 16:00:05', '2025-12-04 16:00:05'),
(43, 4, 10, NULL, 1, NULL, NULL, '2025-12-04 16:00:05', '2025-12-04 16:00:05'),
(44, 4, 21, NULL, 1, NULL, NULL, '2025-12-04 16:00:05', '2025-12-04 16:00:05');

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

--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` bigint UNSIGNED NOT NULL,
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_product` bigint UNSIGNED NOT NULL,
  `id_user` bigint UNSIGNED NOT NULL,
  `approve` tinyint(1) NOT NULL DEFAULT '0',
  `parent_id` bigint UNSIGNED NOT NULL DEFAULT '0',
  `rating` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `employees`
--

CREATE TABLE `employees` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gender` enum('Nam','Nữ','Khác') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `position` enum('Stylist','Barber','Shampooer','Receptionist') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `level` enum('Intern','Junior','Middle','Senior') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `experience_years` tinyint DEFAULT NULL,
  `bio` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` enum('Đang làm việc','Nghỉ phép','Vô hiệu hóa') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `employees`
--

INSERT INTO `employees` (`id`, `user_id`, `avatar`, `gender`, `dob`, `position`, `level`, `experience_years`, `bio`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 2, NULL, NULL, NULL, 'Stylist', 'Senior', 5, 'Chuyên gia cắt tóc và tạo kiểu với hơn 5 năm kinh nghiệm', 'Đang làm việc', '2025-12-01 10:36:47', '2025-12-01 10:36:47', NULL),
(2, 3, NULL, NULL, NULL, 'Barber', 'Middle', 3, 'Thợ cắt tóc nam chuyên nghiệp', 'Đang làm việc', '2025-12-01 10:36:48', '2025-12-14 03:02:50', NULL),
(3, 4, NULL, NULL, NULL, 'Shampooer', 'Junior', 1, 'Nhân viên mới, nhiệt tình và chăm chỉ', 'Đang làm việc', '2025-12-01 10:36:49', '2025-12-14 03:03:19', NULL),
(4, 5, NULL, NULL, NULL, 'Receptionist', 'Middle', 2, 'Chuyên viên gội đầu và chăm sóc tóc', 'Đang làm việc', '2025-12-01 10:36:49', '2025-12-14 03:03:09', NULL),
(5, 17, NULL, 'Nam', '2005-12-12', 'Stylist', 'Senior', 2, NULL, 'Đang làm việc', '2025-12-15 19:56:57', '2025-12-16 19:04:14', NULL);

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

--
-- Table structure for table `employee_skills`
--

CREATE TABLE `employee_skills` (
  `id` bigint UNSIGNED NOT NULL,
  `employee_id` bigint UNSIGNED DEFAULT NULL,
  `service_id` bigint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `employee_skills`
--

INSERT INTO `employee_skills` (`id`, `employee_id`, `service_id`) VALUES
(1, 4, 11),
(2, 4, 15),
(3, 4, 21),
(4, 3, 10),
(5, 3, 9),
(6, 3, 15),
(7, 3, 16),
(8, 2, 13),
(9, 2, 15),
(10, 2, 14),
(11, 2, 19),
(12, 1, 10),
(13, 1, 20),
(14, 1, 17),
(15, 1, 18),
(16, 4, 13),
(17, 3, 21),
(18, 2, 10),
(19, 2, 11),
(20, 2, 9),
(21, 2, 16),
(22, 1, 16),
(23, 1, 19);

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

--
-- Table structure for table `evaluates`
--

CREATE TABLE `evaluates` (
  `id` bigint UNSIGNED NOT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `rating` tinyint NOT NULL DEFAULT '0',
  `id_user` bigint UNSIGNED NOT NULL,
  `id_appointment` bigint UNSIGNED DEFAULT NULL,
  `id_service` bigint UNSIGNED NOT NULL,
  `parent_id` bigint UNSIGNED NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

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

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

--
-- Dumping data for table `jobs`
--

INSERT INTO `jobs` (`id`, `queue`, `payload`, `attempts`, `reserved_at`, `available_at`, `created_at`) VALUES
(1, 'default', '{\"uuid\":\"3b0e4015-40ae-49a7-88af-8403d9b4bca8\",\"displayName\":\"App\\\\Events\\\\AppointmentStatusUpdated\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":16:{s:5:\\\"event\\\";O:35:\\\"App\\\\Events\\\\AppointmentStatusUpdated\\\":1:{s:11:\\\"appointment\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:22:\\\"App\\\\Models\\\\Appointment\\\";s:2:\\\"id\\\";i:69;s:9:\\\"relations\\\";a:6:{i:0;s:4:\\\"user\\\";i:1;s:8:\\\"employee\\\";i:2;s:13:\\\"employee.user\\\";i:3;s:18:\\\"appointmentDetails\\\";i:4;s:33:\\\"appointmentDetails.serviceVariant\\\";i:5;s:24:\\\"appointmentDetails.combo\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:13:\\\"maxExceptions\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:12:\\\"messageGroup\\\";N;s:12:\\\"deduplicator\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;}\"},\"createdAt\":1765413777,\"delay\":null}', 0, NULL, 1765413777, 1765413777),
(2, 'default', '{\"uuid\":\"5f4c0f9f-e762-4131-96f9-dfe7d48d6b67\",\"displayName\":\"App\\\\Events\\\\AppointmentStatusUpdated\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":16:{s:5:\\\"event\\\";O:35:\\\"App\\\\Events\\\\AppointmentStatusUpdated\\\":1:{s:11:\\\"appointment\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:22:\\\"App\\\\Models\\\\Appointment\\\";s:2:\\\"id\\\";i:69;s:9:\\\"relations\\\";a:6:{i:0;s:4:\\\"user\\\";i:1;s:8:\\\"employee\\\";i:2;s:13:\\\"employee.user\\\";i:3;s:18:\\\"appointmentDetails\\\";i:4;s:33:\\\"appointmentDetails.serviceVariant\\\";i:5;s:24:\\\"appointmentDetails.combo\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:13:\\\"maxExceptions\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:12:\\\"messageGroup\\\";N;s:12:\\\"deduplicator\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;}\"},\"createdAt\":1765413862,\"delay\":null}', 0, NULL, 1765413862, 1765413862),
(3, 'default', '{\"uuid\":\"6c31a6bf-8621-4c0a-8e33-a8a1584bbaeb\",\"displayName\":\"App\\\\Events\\\\AppointmentStatusUpdated\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":16:{s:5:\\\"event\\\";O:35:\\\"App\\\\Events\\\\AppointmentStatusUpdated\\\":1:{s:11:\\\"appointment\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:22:\\\"App\\\\Models\\\\Appointment\\\";s:2:\\\"id\\\";i:79;s:9:\\\"relations\\\";a:6:{i:0;s:4:\\\"user\\\";i:1;s:8:\\\"employee\\\";i:2;s:13:\\\"employee.user\\\";i:3;s:18:\\\"appointmentDetails\\\";i:4;s:33:\\\"appointmentDetails.serviceVariant\\\";i:5;s:24:\\\"appointmentDetails.combo\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:13:\\\"maxExceptions\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:12:\\\"messageGroup\\\";N;s:12:\\\"deduplicator\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;}\"},\"createdAt\":1765414041,\"delay\":null}', 0, NULL, 1765414041, 1765414041),
(4, 'default', '{\"uuid\":\"dd6d34d1-9e8f-41b5-8727-539a9c9e73b2\",\"displayName\":\"App\\\\Events\\\\AppointmentStatusUpdated\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":16:{s:5:\\\"event\\\";O:35:\\\"App\\\\Events\\\\AppointmentStatusUpdated\\\":1:{s:11:\\\"appointment\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:22:\\\"App\\\\Models\\\\Appointment\\\";s:2:\\\"id\\\";i:79;s:9:\\\"relations\\\";a:6:{i:0;s:4:\\\"user\\\";i:1;s:8:\\\"employee\\\";i:2;s:13:\\\"employee.user\\\";i:3;s:18:\\\"appointmentDetails\\\";i:4;s:33:\\\"appointmentDetails.serviceVariant\\\";i:5;s:24:\\\"appointmentDetails.combo\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:13:\\\"maxExceptions\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:12:\\\"messageGroup\\\";N;s:12:\\\"deduplicator\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;}\"},\"createdAt\":1765414066,\"delay\":null}', 0, NULL, 1765414066, 1765414066),
(5, 'default', '{\"uuid\":\"fa6005a0-b374-4b5c-b8cf-f0919628e901\",\"displayName\":\"App\\\\Events\\\\AppointmentStatusUpdated\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":16:{s:5:\\\"event\\\";O:35:\\\"App\\\\Events\\\\AppointmentStatusUpdated\\\":1:{s:11:\\\"appointment\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:22:\\\"App\\\\Models\\\\Appointment\\\";s:2:\\\"id\\\";i:79;s:9:\\\"relations\\\";a:6:{i:0;s:4:\\\"user\\\";i:1;s:8:\\\"employee\\\";i:2;s:13:\\\"employee.user\\\";i:3;s:18:\\\"appointmentDetails\\\";i:4;s:33:\\\"appointmentDetails.serviceVariant\\\";i:5;s:24:\\\"appointmentDetails.combo\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:13:\\\"maxExceptions\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:12:\\\"messageGroup\\\";N;s:12:\\\"deduplicator\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;}\"},\"createdAt\":1765414087,\"delay\":null}', 0, NULL, 1765414087, 1765414087),
(6, 'default', '{\"uuid\":\"a6c38b20-a721-41c4-88a8-7e1d249b4531\",\"displayName\":\"App\\\\Events\\\\AppointmentStatusUpdated\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\",\"command\":\"O:38:\\\"Illuminate\\\\Broadcasting\\\\BroadcastEvent\\\":16:{s:5:\\\"event\\\";O:35:\\\"App\\\\Events\\\\AppointmentStatusUpdated\\\":1:{s:11:\\\"appointment\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:22:\\\"App\\\\Models\\\\Appointment\\\";s:2:\\\"id\\\";i:79;s:9:\\\"relations\\\";a:6:{i:0;s:4:\\\"user\\\";i:1;s:8:\\\"employee\\\";i:2;s:13:\\\"employee.user\\\";i:3;s:18:\\\"appointmentDetails\\\";i:4;s:33:\\\"appointmentDetails.serviceVariant\\\";i:5;s:24:\\\"appointmentDetails.combo\\\";}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}}s:5:\\\"tries\\\";N;s:7:\\\"timeout\\\";N;s:7:\\\"backoff\\\";N;s:13:\\\"maxExceptions\\\";N;s:10:\\\"connection\\\";N;s:5:\\\"queue\\\";N;s:12:\\\"messageGroup\\\";N;s:12:\\\"deduplicator\\\";N;s:5:\\\"delay\\\";N;s:11:\\\"afterCommit\\\";N;s:10:\\\"middleware\\\";a:0:{}s:7:\\\"chained\\\";a:0:{}s:15:\\\"chainConnection\\\";N;s:10:\\\"chainQueue\\\";N;s:19:\\\"chainCatchCallbacks\\\";N;}\"},\"createdAt\":1765414110,\"delay\":null}', 0, NULL, 1765414110, 1765414110);

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

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

CREATE TABLE `job_batches` (
  `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext CHARACTER SET utf8mb4 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` int UNSIGNED NOT NULL,
  `migration` varchar(255) CHARACTER SET utf8mb4 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, '2025_01_15_000001_create_roles_table', 1),
(5, '2025_01_15_000002_update_users_table', 1),
(6, '2025_01_15_000003_create_employees_table', 1),
(7, '2025_01_15_000004_create_skills_table', 1),
(8, '2025_01_15_000005_create_employee_skills_table', 1),
(9, '2025_01_15_000006_create_service_categories_table', 1),
(10, '2025_01_15_000007_create_services_table', 1),
(11, '2025_01_15_000008_create_service_variants_table', 1),
(12, '2025_01_15_000009_create_variant_attributes_table', 1),
(13, '2025_01_15_000010_create_combos_table', 1),
(14, '2025_01_15_000011_create_combo_items_table', 1),
(15, '2025_01_15_000012_create_working_shifts_table', 1),
(16, '2025_01_15_000013_create_working_schedule_table', 1),
(17, '2025_01_15_000014_create_appointments_table', 1),
(18, '2025_01_15_000015_create_appointment_details_table', 1),
(19, '2025_01_15_000016_create_appointment_logs_table', 1),
(20, '2025_01_15_000019_create_reviews_table', 1),
(21, '2025_01_15_000020_create_notifications_table', 1),
(22, '2025_01_15_000021_create_payments_table', 1),
(23, '2025_01_22_000001_change_employee_skills_to_services', 1),
(24, '2025_01_23_000001_change_working_schedule_status_enum', 1),
(25, '2025_11_11_165910_create_categories_table', 1),
(26, '2025_11_11_165931_create_types_table', 1),
(27, '2025_11_11_165954_create_products_table', 1),
(28, '2025_11_11_170040_create_word_time_table', 1),
(29, '2025_11_11_170147_create_orders_table', 1),
(30, '2025_11_11_170208_create_order_details_table', 1),
(31, '2025_11_11_170259_create_settings_table', 1),
(32, '2025_11_11_170325_create_news_table', 1),
(33, '2025_11_11_170359_create_comments_table', 1),
(34, '2025_11_11_170416_create_contacts_table', 1),
(35, '2025_11_11_170434_create_evaluates_table', 1),
(36, '2025_11_17_134709_refactor_services_module', 1),
(37, '2025_11_19_072124_add_deleted_at_to_categories_table', 1),
(38, '2025_11_21_071511_add_service_code_to_services_table', 1),
(39, '2025_11_22_094608_create_password_reset_otps_table', 1),
(40, '2025_11_22_095750_add_remember_token_to_users_table', 1),
(41, '2025_11_23_093134_drop_skills_table', 1),
(42, '2025_11_23_161006_remove_unique_constraint_from_users_email', 1),
(43, '2025_11_23_162049_remove_unique_constraint_from_users_phone', 1),
(44, '2025_11_24_125500_add_service_code_to_services_table', 1),
(45, '2025_11_28_000001_create_promotions_table', 1),
(46, '2025_11_28_000002_create_promotion_service_table', 1),
(47, '2025_11_28_160000_add_order_id_to_payments_table', 1),
(48, '2025_11_28_160500_add_invoice_code_to_payments_table', 1),
(49, '2025_11_28_163000_add_timestamps_to_payments_table', 1),
(50, '2025_11_29_154311_add_images_and_is_hidden_to_reviews_table', 2),
(51, '2025_11_28_000003_create_promotion_usages_table', 3),
(52, '2025_11_28_000003_drop_status_column_from_working_schedule_table', 3),
(53, '2025_12_04_141608_add_missing_columns_to_promotions_table', 4),
(54, '2025_12_03_000100_update_promotions_add_missing_columns', 5),
(55, '2025_12_03_000200_alter_promotions_nullable_discount_columns', 5),
(56, '2025_12_03_000300_create_promotion_usages_table', 5),
(57, '2025_12_04_210825_update_appointment_logs_status_columns', 6),
(58, '2025_12_04_215127_add_duration_to_combos_table', 7),
(59, '2025_12_06_103200_add_vnpay_to_payment_type_enum_in_payments_table', 8),
(60, '2025_12_06_103245_add_vnpay_to_payment_type_enum_in_payments_table', 8),
(61, '2025_12_06_120000_add_status_to_payments_table', 8),
(62, '2025_12_06_053515_add_booking_code_to_appointments_table', 9),
(63, '2025_12_12_015329_add_ban_fields_to_users_table', 10),
(64, '2025_12_12_081810_add_permanent_ban_to_users_table', 11),
(65, '2025_12_14_221000_modify_appointments_status_enum', 12),
(66, '2025_12_16_000500_add_usage_limit_to_promotions_table', 13),
(67, '2025_12_16_000600_add_min_customer_tier_to_promotions_table', 14),
(68, '2025_12_15_230000_modify_appointment_details_status_enum', 15),
(69, '2025_12_18_041000_add_service_promotion_id_to_appointments_table', 15),
(70, '2025_12_18_041655_remove_service_promotion_id_from_appointments_table', 16),
(71, '2025_12_18_042816_add_promotion_to_appointment_details_table', 17),
(72, '2025_12_18_120001_add_selected_promotion_to_appointments_table', 18),
(73, '2025_12_18_130000_add_soft_deletes_to_appointment_details_table', 19),
(74, '2025_12_19_002627_remove_promotion_columns_from_appointment_details_table', 20),
(75, '2025_12_19_002645_remove_selected_promotion_columns_from_appointments_table', 20),
(76, '2025_12_19_002659_remove_soft_deletes_from_appointment_details_table', 20),
(77, '2025_12_18_000001_add_guest_info_to_appointments_table', 21),
(78, '2025_12_19_004314_add_promotion_columns_to_appointment_details_table', 22),
(79, '2025_12_19_014925_remove_promotion_columns_from_appointment_details_table', 23),
(80, '2025_12_19_043802_add_promotion_fields_to_appointments_table', 24),
(81, '2025_12_19_120000_make_id_user_nullable_in_orders_table', 25),
(82, '2025_12_20_000001_add_promotion_id_to_appointment_details', 26);

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

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `id` bigint UNSIGNED NOT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `images` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id_user` bigint UNSIGNED NOT NULL,
  `views` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `notifications` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `type` enum('appointment','promotion','feedback','system') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference_id` int DEFAULT NULL,
  `is_read` tinyint(1) NOT NULL DEFAULT '0',
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` bigint UNSIGNED NOT NULL,
  `id_user` bigint UNSIGNED DEFAULT NULL,
  `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Chờ lấy hàng',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `order_details`
--

CREATE TABLE `order_details` (
  `id` bigint UNSIGNED NOT NULL,
  `id_order` bigint UNSIGNED NOT NULL,
  `id_product` bigint UNSIGNED NOT NULL,
  `quantity` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `payments` (
  `id` bigint UNSIGNED NOT NULL,
  `invoice_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `appointment_id` bigint UNSIGNED DEFAULT NULL,
  `order_id` bigint UNSIGNED DEFAULT NULL,
  `price` double DEFAULT NULL,
  `VAT` double DEFAULT NULL,
  `total` double DEFAULT NULL,
  `created_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_type` enum('cash','online','vnpay','momo','zalopay') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('pending','completed','failed','refunded') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `payments` (`id`, `invoice_code`, `user_id`, `appointment_id`, `order_id`, `price`, `VAT`, `total`, `created_by`, `payment_type`, `status`, `created_at`, `updated_at`) VALUES
(1, 'INV-20251204-CEWOMV', 1, NULL, NULL, 11052000, 1105200, 12157200, 'Administrator', 'cash', 'pending', '2025-12-04 07:26:25', '2025-12-04 07:26:25'),
(2, 'INV-20251204-NFZIIR', 1, NULL, NULL, 0, 0, 0, 'Administrator', 'cash', 'pending', '2025-12-04 09:40:49', '2025-12-04 09:40:49'),
(3, 'INV-20251204-BCWTWU', 7, NULL, NULL, 180000, 18000, 198000, 'Nguyễn Văn A', 'cash', 'pending', '2025-12-04 12:24:03', '2025-12-04 12:24:03'),
(4, 'INV-20251204-MIDSBV', 7, NULL, NULL, 60000, 6000, 66000, 'Nguyễn Văn A', 'cash', 'pending', '2025-12-04 12:28:25', '2025-12-04 12:28:25'),
(5, 'INV-20251204-HM6RMC', 7, NULL, NULL, 154000, 15400, 169400, 'Nguyễn Văn A', 'cash', 'pending', '2025-12-04 12:42:36', '2025-12-04 12:42:36'),
(6, 'INV-20251204-NME2U5', 7, NULL, NULL, 359000, 35900, 394900, 'Nguyễn Văn A', 'cash', 'pending', '2025-12-04 12:47:29', '2025-12-04 12:47:29'),
(7, 'INV-20251204-6IVK8U', 7, NULL, NULL, 95200, 9520, 104720, 'Nguyễn Văn A', 'cash', 'pending', '2025-12-04 12:51:20', '2025-12-04 12:51:20'),
(8, 'INV-20251204-IG90DY', 7, NULL, NULL, 88000, 8800, 96800, 'Nguyễn Văn A', 'cash', 'pending', '2025-12-04 12:57:32', '2025-12-04 12:57:32'),
(9, 'INV-20251204-TDGKLP', 7, NULL, NULL, 80000, 8000, 88000, 'Nguyễn Văn A', 'cash', 'pending', '2025-12-04 13:07:54', '2025-12-04 13:07:54'),
(10, 'INV-20251204-IPUSAC', 7, NULL, NULL, 96000, 9600, 105600, 'Nguyễn Văn A', 'cash', 'pending', '2025-12-04 13:18:53', '2025-12-04 13:18:53'),
(11, 'INV-20251204-AKK0DX', 7, NULL, NULL, 64000, 6400, 70400, 'Nguyễn Văn A', 'cash', 'pending', '2025-12-04 13:42:26', '2025-12-04 13:42:26'),
(12, 'INV-20251204-GGRSMX', 7, NULL, NULL, 64000, 6400, 70400, 'Nguyễn Văn A', 'cash', 'pending', '2025-12-04 13:47:40', '2025-12-04 13:47:40'),
(13, 'INV-20251204-RXLHQX', 7, NULL, NULL, 30000, 3000, 33000, 'Nguyễn Văn A', 'cash', 'pending', '2025-12-04 14:02:37', '2025-12-04 14:02:37'),
(14, 'INV-20251204-O5A2EO', 7, NULL, NULL, 120000, 12000, 132000, 'Trịnh Quang Lực', 'cash', 'pending', '2025-12-04 14:18:29', '2025-12-04 14:18:29'),
(15, 'INV-20251204-DAHUV1', 7, NULL, NULL, 219000, 21900, 240900, 'Trịnh Quang Lực', 'cash', 'pending', '2025-12-04 15:43:03', '2025-12-04 15:43:03'),
(16, 'INV-20251204-3APQAN', 7, NULL, NULL, 119000, 11900, 130900, 'Trịnh Quang Lực', 'cash', 'pending', '2025-12-04 16:02:27', '2025-12-04 16:02:27'),
(17, 'INV-20251204-RRYAKK', 7, NULL, NULL, 190000, 19000, 209000, 'Trịnh Quang Lực', 'cash', 'pending', '2025-12-04 16:12:25', '2025-12-04 16:12:25'),
(18, 'INV-20251204-2JA8JN', 7, NULL, NULL, 269000, 26900, 295900, 'Trịnh Quang Lực', 'cash', 'pending', '2025-12-04 16:25:20', '2025-12-04 16:25:20'),
(19, 'INV-20251204-KC4TDM', 7, NULL, NULL, 258000, 25800, 283800, 'Trịnh Quang Lực', 'cash', 'pending', '2025-12-04 16:27:07', '2025-12-04 16:27:07'),
(20, 'INV-20251206-ROY8C0', 8, NULL, NULL, 150000, 15000, 165000, 'Lê Đình Việt', 'cash', 'pending', '2025-12-05 21:49:28', '2025-12-05 21:49:28'),
(21, 'INV-20251206-SXLGJW', 8, NULL, NULL, 600000, 60000, 660000, 'Lê Đình Việt', 'cash', 'pending', '2025-12-05 22:37:19', '2025-12-05 22:37:19'),
(22, 'INV-20251206-B27SI8', 8, NULL, NULL, 200000, 20000, 220000, 'Lê Đình Việt', 'cash', 'pending', '2025-12-05 22:47:06', '2025-12-05 22:47:06'),
(23, 'INV-20251206-UF080T', 8, NULL, NULL, 180000, 18000, 198000, 'Lê Đình Việt', 'cash', 'pending', '2025-12-05 22:55:35', '2025-12-05 22:55:35'),
(24, 'INV-20251206-V8RXXM', 8, NULL, NULL, 200000, 20000, 220000, 'Lê Đình Việt', 'cash', 'pending', '2025-12-05 23:03:17', '2025-12-05 23:03:17'),
(25, 'INV-20251206-XOP7UX', 8, NULL, NULL, 200000, 20000, 220000, 'Lê Đình Việt', 'cash', 'pending', '2025-12-05 23:05:32', '2025-12-05 23:05:32'),
(26, 'INV-20251206-LE6T7Y', 9, NULL, NULL, 230000, 23000, 253000, 'Nguyễn Văn B', 'cash', 'pending', '2025-12-05 23:15:57', '2025-12-05 23:15:57'),
(27, 'INV-20251206-WTOIEI', 9, NULL, NULL, 200000, 20000, 220000, 'Nguyễn Văn B', 'cash', 'pending', '2025-12-05 23:17:07', '2025-12-05 23:17:07'),
(28, 'INV-20251206-DRARTR', 9, NULL, NULL, 200000, 20000, 220000, 'Nguyễn Văn B', 'cash', 'pending', '2025-12-05 23:26:05', '2025-12-05 23:26:05'),
(29, 'INV-20251206-VEEC1J', 9, NULL, NULL, 130000, 13000, 143000, 'Nguyễn Văn B', 'cash', 'pending', '2025-12-05 23:27:03', '2025-12-05 23:27:03'),
(30, 'INV-20251206-L05EJP', 9, NULL, NULL, 230000, 23000, 253000, 'Nguyễn Văn B', 'cash', 'pending', '2025-12-05 23:41:20', '2025-12-05 23:41:20'),
(31, 'INV-20251206-QCALHF', 9, NULL, NULL, 180000, 18000, 198000, 'Nguyễn Văn B', 'cash', 'pending', '2025-12-05 23:45:39', '2025-12-05 23:45:39'),
(32, 'INV-20251206-UKX1FL', 7, NULL, NULL, 230000, 23000, 253000, 'Quang Lực', 'cash', 'pending', '2025-12-06 00:37:27', '2025-12-06 00:37:27'),
(33, 'INV-20251206-RE9CB1', 10, NULL, NULL, 230000, 23000, 253000, 'Lực Quang', 'cash', 'pending', '2025-12-06 00:40:28', '2025-12-06 00:40:28'),
(34, 'INV-20251206-VTI8MY', 10, NULL, NULL, 150000, 15000, 165000, 'Lực Quang', 'cash', 'pending', '2025-12-06 00:51:35', '2025-12-06 00:51:35'),
(35, 'INV-20251207-SM12EH', 10, NULL, NULL, 200000, 20000, 220000, 'Lực Quang', 'cash', 'pending', '2025-12-07 04:25:07', '2025-12-07 04:25:07'),
(36, 'INV-20251207-UDYRMK', 10, NULL, NULL, 230000, 23000, 253000, 'Lực Quang', 'vnpay', 'pending', '2025-12-07 04:26:28', '2025-12-07 04:26:28'),
(37, 'INV-20251207-RBFFAI', 10, NULL, NULL, 200000, 20000, 220000, 'Lực Quang', 'cash', 'pending', '2025-12-07 04:28:57', '2025-12-07 04:28:57'),
(38, 'INV-20251207-L0VX9A', 10, NULL, NULL, 180000, 18000, 198000, 'Lực Quang', 'cash', 'pending', '2025-12-07 04:46:53', '2025-12-07 04:46:53'),
(39, 'INV-20251207-KR9J04', 10, NULL, NULL, 200000, 20000, 220000, 'Lực Quang', 'cash', 'pending', '2025-12-07 05:01:34', '2025-12-07 05:01:34'),
(40, 'INV-20251207-2SBJUZ', 10, NULL, NULL, 180000, 18000, 198000, 'Lực Quang', 'cash', 'pending', '2025-12-07 07:24:59', '2025-12-07 07:24:59'),
(41, 'INV-20251208-RLEYWL', 10, NULL, NULL, 180000, 18000, 198000, 'Lực Quang', 'cash', 'pending', '2025-12-07 21:12:00', '2025-12-07 21:12:00'),
(42, 'INV-20251208-XCV0II', 10, NULL, NULL, 210000, 21000, 231000, 'Lực Quang', 'cash', 'pending', '2025-12-07 22:51:34', '2025-12-07 22:51:34'),
(43, 'INV-20251208-3RWKF8', 10, NULL, NULL, 210000, 21000, 231000, 'Lực Quang', 'cash', 'pending', '2025-12-07 23:18:49', '2025-12-07 23:18:49'),
(44, 'INV-20251208-AXRHML', 10, NULL, NULL, 209000, 20900, 229900, 'Lực Quang', 'cash', 'pending', '2025-12-07 23:22:51', '2025-12-07 23:22:51'),
(45, 'INV-20251208-3IQYGK', 10, NULL, NULL, 369000, 36900, 405900, 'Lực Quang', 'cash', 'pending', '2025-12-07 23:42:19', '2025-12-07 23:42:19'),
(46, 'INV-20251208-4KLWCA', 10, NULL, NULL, 379000, 37900, 416900, 'Lực Quang', 'cash', 'pending', '2025-12-08 09:50:55', '2025-12-08 09:50:55'),
(47, 'INV-20251208-WOP04J', 10, NULL, NULL, 349000, 34900, 383900, 'Lực Quang', 'cash', 'pending', '2025-12-08 10:42:20', '2025-12-08 10:42:20'),
(48, 'INV-20251208-8CY0BT', 7, NULL, NULL, 130000, 13000, 143000, 'Quang Lực', 'cash', 'pending', '2025-12-08 10:45:23', '2025-12-08 10:45:23'),
(49, 'INV-20251208-L7BEHY', 7, NULL, NULL, 260000, 26000, 286000, 'Quang Lực', 'cash', 'pending', '2025-12-08 10:50:46', '2025-12-08 10:50:46'),
(50, 'INV-20251209-QMRALF', 10, NULL, NULL, 260000, 26000, 286000, 'Lực Quang', 'cash', 'pending', '2025-12-09 05:24:47', '2025-12-09 05:24:47'),
(51, 'INV-20251209-IFNEPV', 10, NULL, NULL, 280000, 28000, 308000, 'Lực Quang', 'cash', 'pending', '2025-12-09 05:30:57', '2025-12-09 05:30:57'),
(52, 'INV-20251209-MEVAHI', 10, NULL, NULL, 219000, 21900, 240900, 'Lực Quang', 'cash', 'pending', '2025-12-09 05:44:31', '2025-12-09 05:44:31'),
(53, 'INV-20251209-N0AHSL', 10, NULL, NULL, 319000, 31900, 350900, 'Lực Quang', 'cash', 'pending', '2025-12-09 05:45:09', '2025-12-09 05:45:09'),
(54, 'INV-20251210-KLGCTU', 7, NULL, NULL, 4093000, 409300, 4502300, 'Quang Lực', 'cash', 'pending', '2025-12-09 17:39:47', '2025-12-09 17:39:47'),
(55, 'INV-20251211-UL4LQB', 7, NULL, NULL, 230000, 23000, 253000, 'Quang Lực', 'cash', 'pending', '2025-12-10 23:52:16', '2025-12-10 23:52:16'),
(56, 'INV-20251211-TIXZ7A', 7, NULL, NULL, 180000, 18000, 198000, 'Quang Lực', 'cash', 'pending', '2025-12-11 00:01:28', '2025-12-11 00:01:28'),
(57, 'INV-20251211-8VKNIQ', 7, NULL, NULL, 180000, 18000, 198000, 'Quang Lực', 'cash', 'pending', '2025-12-11 00:46:11', '2025-12-11 00:46:11'),
(58, 'INV-20251211-L56ORY', 7, NULL, NULL, 210000, 21000, 231000, 'Quang Lực', 'cash', 'pending', '2025-12-11 00:46:58', '2025-12-11 00:46:58'),
(59, 'INV-20251212-Y9GE4Y', 10, NULL, NULL, 220000, 22000, 242000, 'Lực Quang', 'cash', 'pending', '2025-12-11 18:48:40', '2025-12-11 18:48:40'),
(60, 'INV-20251212-CRZ2OY', 10, NULL, NULL, 200000, 20000, 220000, 'Lực Quang', 'cash', 'pending', '2025-12-11 19:06:21', '2025-12-11 19:06:21'),
(61, 'INV-20251212-VY6PV1', 10, NULL, NULL, 230000, 23000, 253000, 'Lực Quang', 'cash', 'pending', '2025-12-11 19:07:19', '2025-12-11 19:07:19'),
(62, 'INV-20251212-RXMZGN', 10, NULL, NULL, 180000, 18000, 198000, 'Lực Quang', 'cash', 'pending', '2025-12-11 19:09:46', '2025-12-11 19:09:46'),
(63, 'INV-20251212-QEX5VH', 7, NULL, NULL, 230000, 23000, 253000, 'Quang Lực', 'cash', 'pending', '2025-12-12 01:11:39', '2025-12-12 01:11:39'),
(64, 'INV-20251212-TQBNGD', 9, NULL, NULL, 180000, 18000, 198000, 'Nguyễn Văn B', 'cash', 'pending', '2025-12-12 01:31:32', '2025-12-12 01:31:32'),
(65, 'INV-20251212-AMJY1G', 9, NULL, NULL, 230000, 23000, 253000, 'Nguyễn Văn B', 'cash', 'pending', '2025-12-12 01:32:09', '2025-12-12 01:32:09'),
(66, 'INV-20251212-XFILCK', 9, NULL, NULL, 230000, 23000, 253000, 'Nguyễn Văn B', 'cash', 'pending', '2025-12-12 01:32:43', '2025-12-12 01:32:43'),
(67, 'INV-20251212-QQFJZQ', 8, NULL, NULL, 180000, 18000, 198000, 'Lê Đình Việt', 'cash', 'pending', '2025-12-12 01:55:08', '2025-12-12 01:55:08'),
(68, 'INV-20251212-MNNU5A', 8, NULL, NULL, 230000, 23000, 253000, 'Lê Đình Việt', 'cash', 'pending', '2025-12-12 01:55:39', '2025-12-12 01:55:39'),
(69, 'INV-20251212-S0W57P', 8, NULL, NULL, 200000, 20000, 220000, 'Lê Đình Việt', 'cash', 'pending', '2025-12-12 01:56:14', '2025-12-12 01:56:14'),
(70, 'INV-20251212-V2D9YB', 11, NULL, NULL, 180000, 18000, 198000, 'Nguyễn Văn A', 'cash', 'pending', '2025-12-12 02:13:02', '2025-12-12 02:13:02'),
(71, 'INV-20251212-YXAGY4', 11, NULL, NULL, 230000, 23000, 253000, 'Nguyễn Văn A', 'cash', 'pending', '2025-12-12 02:13:53', '2025-12-12 02:13:53'),
(72, 'INV-20251212-X5KBSM', 11, NULL, NULL, 200000, 20000, 220000, 'Nguyễn Văn A', 'cash', 'pending', '2025-12-12 02:15:23', '2025-12-12 02:15:23'),
(73, 'INV-20251213-SF1UCY', 14, NULL, NULL, 180000, 18000, 198000, 'Lực', 'cash', 'pending', '2025-12-12 17:03:08', '2025-12-12 17:03:08'),
(74, 'INV-20251213-YYMHG3', 14, NULL, NULL, 150000, 15000, 165000, 'Lực', 'cash', 'pending', '2025-12-12 17:04:51', '2025-12-12 17:04:51'),
(75, 'INV-20251214-ABWAHV', 11, NULL, NULL, 180000, 18000, 198000, 'Nguyễn Văn A', 'cash', 'pending', '2025-12-14 03:00:55', '2025-12-14 03:00:55'),
(76, 'INV-20251214-NOK2BY', 11, NULL, NULL, 230000, 23000, 253000, 'Nguyễn Văn A', 'cash', 'pending', '2025-12-14 03:04:07', '2025-12-14 03:04:07'),
(77, 'INV-20251214-FCCNJY', 11, NULL, NULL, 110000, 11000, 121000, 'Nguyễn Văn A', 'cash', 'pending', '2025-12-14 03:04:38', '2025-12-14 03:04:38'),
(78, 'INV-20251214-OCHJTS', 1, NULL, NULL, 180000, 18000, 198000, 'Administrator', 'cash', 'pending', '2025-12-14 06:53:40', '2025-12-14 06:53:40'),
(79, 'INV-20251215-6SYV9Q', 1, NULL, NULL, 210000, NULL, 210000, 'Administrator', 'vnpay', 'pending', '2025-12-15 16:34:36', '2025-12-15 16:34:36'),
(80, 'INV-20251216-MTUCIF', 16, NULL, NULL, 3296000, NULL, 3296000, 'Quang Lực', 'cash', 'completed', '2025-12-15 20:28:17', '2025-12-15 20:28:17'),
(81, 'INV-20251216-54BENN', 1, NULL, NULL, 210000, NULL, 210000, 'Administrator', 'vnpay', 'completed', '2025-12-16 14:36:28', '2025-12-16 14:38:43'),
(82, 'INV-20251216-VASMNN', 1, NULL, NULL, 180000, NULL, 180000, 'Administrator', 'vnpay', 'failed', '2025-12-16 14:38:58', '2025-12-16 14:40:22'),
(83, 'INV-20251216-RB0HZ9', 16, NULL, NULL, 1798000, NULL, 1798000, 'Quang Lực', 'cash', 'completed', '2025-12-16 14:44:52', '2025-12-16 14:44:52'),
(84, 'INV-20251216-FSKHZ1', 1, NULL, NULL, 180000, NULL, 180000, 'Administrator', 'vnpay', 'failed', '2025-12-16 15:51:45', '2025-12-16 15:53:32'),
(85, 'INV-20251216-PQTQQU', 1, NULL, NULL, 180000, NULL, 180000, 'Administrator', 'vnpay', 'failed', '2025-12-16 15:53:37', '2025-12-16 15:54:26'),
(86, 'INV-20251216-QCIWUS', 1, NULL, NULL, 180000, NULL, 180000, 'Administrator', 'vnpay', 'failed', '2025-12-16 15:55:24', '2025-12-16 15:57:27'),
(87, 'INV-20251216-RLHPP1', 1, NULL, NULL, 180000, NULL, 180000, 'Administrator', 'vnpay', 'failed', '2025-12-16 16:10:37', '2025-12-16 16:11:47'),
(88, 'INV-20251217-ZNNCGI', 16, NULL, NULL, 180000, NULL, 180000, 'Quang Lực', 'vnpay', 'failed', '2025-12-16 17:55:11', '2025-12-16 17:55:17'),
(89, 'INV-20251217-RM4OPU', 16, NULL, NULL, 49000, NULL, 49000, 'Quang Lực', 'cash', 'completed', '2025-12-16 20:59:16', '2025-12-16 20:59:16'),
(90, 'INV-20251217-QPQVOR', 16, NULL, NULL, 50000, NULL, 50000, 'Quang Lực', 'cash', 'completed', '2025-12-16 21:24:53', '2025-12-16 21:24:53'),
(91, 'INV-20251218-HJW1IK', 16, NULL, NULL, 179000, NULL, 179000, 'Quang Lực', 'vnpay', 'pending', '2025-12-18 01:28:03', '2025-12-18 01:28:03'),
(92, 'INV-20251218-U4I9JK', 16, NULL, NULL, 135000, NULL, 135000, 'Quang Lực', 'cash', 'completed', '2025-12-18 03:29:00', '2025-12-18 03:29:00'),
(93, 'INV-20251218-RQYTNT', 16, NULL, NULL, 259000, NULL, 259000, 'Quang Lực', 'cash', 'completed', '2025-12-18 03:34:41', '2025-12-18 03:34:41'),
(94, 'INV-20251218-FSIJMF', 16, NULL, NULL, 218000, NULL, 218000, 'Quang Lực', 'cash', 'completed', '2025-12-18 06:50:24', '2025-12-18 06:50:24'),
(95, 'INV-20251218-U3W1PQ', 16, NULL, NULL, 100000, NULL, 100000, 'Quang Lực', 'cash', 'completed', '2025-12-18 07:01:29', '2025-12-18 07:01:29'),
(96, 'INV-20251218-PKKOU7', 10, NULL, NULL, 135800, NULL, 135800, 'Lực Quang', 'cash', 'completed', '2025-12-18 07:08:48', '2025-12-18 07:08:48'),
(97, 'INV-20251218-7B460X', 10, NULL, NULL, 339500, NULL, 339500, 'Lực Quang', 'cash', 'completed', '2025-12-18 07:10:27', '2025-12-18 07:10:27'),
(98, 'INV-20251218-JU9FTW', 10, NULL, NULL, 599000, NULL, 599000, 'Lực Quang', 'cash', 'completed', '2025-12-18 07:11:56', '2025-12-18 07:11:56'),
(99, 'INV-20251218-W8WCDT', 10, NULL, NULL, 200000, NULL, 200000, 'Lực Quang', 'cash', 'completed', '2025-12-18 08:07:42', '2025-12-18 08:07:42'),
(100, 'INV-20251218-BVKYJ4', 10, NULL, NULL, 36800, NULL, 36800, 'Lực Quang', 'cash', 'completed', '2025-12-18 12:16:49', '2025-12-18 12:16:49'),
(101, 'INV-20251219-VOEMLJ', 10, NULL, NULL, 1098000, NULL, 1098000, 'Lực Quang', 'cash', 'completed', '2025-12-18 21:08:16', '2025-12-18 21:08:16'),
(102, 'INV-20251219-HJPF5R', 10, NULL, NULL, 1098000, NULL, 1098000, 'Lực Quang', 'cash', 'completed', '2025-12-18 21:48:41', '2025-12-18 21:48:41'),
(103, 'INV-20251219-4AQYBH', 10, NULL, NULL, 86000, NULL, 86000, 'Lực Quang', 'cash', 'completed', '2025-12-18 22:42:52', '2025-12-18 22:42:52'),
(104, 'INV-20251219-9YXK1Q', 10, NULL, NULL, 859000, NULL, 859000, 'Lực Quang', 'cash', 'completed', '2025-12-18 23:02:03', '2025-12-18 23:02:03'),
(105, 'INV-20251219-Q6NIKQ', 10, NULL, NULL, 420000, NULL, 420000, 'Lực Quang', 'cash', 'completed', '2025-12-18 23:04:10', '2025-12-18 23:04:10'),
(106, 'INV-20251219-8R5WUM', 10, NULL, NULL, 495000, NULL, 495000, 'Lực Quang', 'cash', 'completed', '2025-12-18 23:13:35', '2025-12-18 23:13:35'),
(107, 'INV-20251219-EUECWT', 10, NULL, NULL, 445000, NULL, 445000, 'Lực Quang', 'cash', 'completed', '2025-12-18 23:19:52', '2025-12-18 23:19:52'),
(108, 'INV-20251219-C4VHOU', 10, NULL, NULL, 16000, NULL, 16000, 'Lực Quang', 'cash', 'completed', '2025-12-18 23:24:08', '2025-12-18 23:24:08'),
(109, 'INV-20251219-PYBQ7P', 10, NULL, NULL, 504000, NULL, 504000, 'Lực Quang', 'cash', 'completed', '2025-12-18 23:42:30', '2025-12-18 23:42:30'),
(110, 'INV-20251219-FC14VE', 10, NULL, NULL, 489000, NULL, 489000, 'Lực Quang', 'cash', 'completed', '2025-12-18 23:43:10', '2025-12-18 23:43:10'),
(111, 'INV-20251219-CI9GKL', 10, NULL, NULL, 30000, NULL, 30000, 'Lực Quang', 'cash', 'completed', '2025-12-19 00:00:45', '2025-12-19 00:00:45'),
(112, 'INV-20251219-CHLTWI', 10, NULL, NULL, 458000, NULL, 458000, 'Lực Quang', 'cash', 'completed', '2025-12-19 00:05:17', '2025-12-19 00:05:17'),
(113, 'INV-20251219-C2NV0B', 10, NULL, NULL, 386000, NULL, 386000, 'Lực Quang', 'cash', 'completed', '2025-12-19 00:12:22', '2025-12-19 00:12:22'),
(114, 'INV-20251219-KJSZSI', 10, NULL, NULL, 24000, NULL, 24000, 'Lực Quang', 'cash', 'completed', '2025-12-19 00:43:44', '2025-12-19 00:43:44'),
(115, 'INV-20251219-HXLBO3', 10, 162, NULL, 272300, NULL, 272300, 'Lực Quang', 'cash', 'completed', '2025-12-19 01:18:49', '2025-12-19 01:18:49'),
(116, 'INV-20251219-3VYXTB', 10, 164, NULL, 323300, NULL, 323300, 'Lực Quang', 'cash', 'completed', '2025-12-19 02:57:20', '2025-12-19 02:57:20'),
(117, 'INV-20251219-78Y1T6', 10, 164, NULL, 947300, NULL, 947300, 'Lực Quang', 'cash', 'completed', '2025-12-19 05:17:30', '2025-12-19 05:17:30'),
(118, 'INV-20251219-YPPV26', 10, 164, NULL, 897300, NULL, 897300, 'Lực Quang', 'cash', 'completed', '2025-12-19 05:19:24', '2025-12-19 05:19:24'),
(119, 'INV-20251219-GE4MD7', 10, 164, NULL, 710475, NULL, 710475, 'Lực Quang', 'cash', 'completed', '2025-12-19 05:27:18', '2025-12-19 05:27:18'),
(120, 'INV-20251220-SXE0AX', 10, 165, NULL, 689500, NULL, 689500, 'Lực Quang', 'cash', 'completed', '2025-12-19 17:36:13', '2025-12-19 17:36:13'),
(121, 'INV-20251220-NQJMYA', 10, 166, NULL, 88500, NULL, 88500, 'Lực Quang', 'vnpay', 'failed', '2025-12-19 19:44:37', '2025-12-19 19:44:54'),
(122, 'INV-20251220-5CTXG0', 10, 166, NULL, 88500, NULL, 88500, 'Lực Quang', 'vnpay', 'failed', '2025-12-19 19:54:35', '2025-12-19 19:55:37'),
(123, 'INV-20251220-QBTZOG', 10, 167, NULL, 369000, NULL, 369000, 'Lực Quang', 'cash', 'completed', '2025-12-19 20:39:36', '2025-12-19 20:39:36'),
(124, 'INV-20251220-XTPBZS', 10, 168, NULL, 542000, NULL, 542000, 'Lực Quang', 'cash', 'completed', '2025-12-20 00:06:17', '2025-12-20 00:06:17'),
(125, 'INV-20251220-Z4VV6H', 10, 169, NULL, 592000, NULL, 592000, 'Lực Quang', 'cash', 'completed', '2025-12-20 00:15:46', '2025-12-20 00:15:46'),
(126, 'INV-20251220-3SY3B0', 10, 170, NULL, 522000, NULL, 522000, 'Lực Quang', 'cash', 'completed', '2025-12-20 00:23:49', '2025-12-20 00:23:49'),
(127, 'INV-20251220-7ZQVPZ', 10, 172, NULL, 524000, NULL, 524000, 'Lực Quang', 'cash', 'completed', '2025-12-20 00:31:11', '2025-12-20 00:31:11'),
(128, 'INV-20251220-UDCGYT', 10, 175, NULL, 439000, NULL, 439000, 'Lực Quang', 'cash', 'completed', '2025-12-20 00:51:56', '2025-12-20 00:51:56'),
(129, 'INV-20251220-IZJC2X', 19, 180, NULL, 524000, NULL, 524000, 'VIET LE DINH', 'cash', 'completed', '2025-12-20 01:26:49', '2025-12-20 01:26:49'),
(130, 'INV-20251220-DWEQUD', 19, 181, NULL, 459000, NULL, 459000, 'VIET LE DINH', 'cash', 'completed', '2025-12-20 01:37:49', '2025-12-20 01:37:49'),
(131, 'INV-20251220-M8Z4MH', 19, 182, NULL, 140000, NULL, 140000, 'VIET LE DINH', 'cash', 'completed', '2025-12-20 01:45:07', '2025-12-20 01:45:07'),
(132, 'INV-20251221-DD864F', 19, 184, NULL, 145000, NULL, 145000, 'VIET LE DINH', 'cash', 'completed', '2025-12-20 19:39:58', '2025-12-20 19:39:58'),
(133, 'INV-20251221-X4WWK4', 7, 185, NULL, 142500, NULL, 142500, 'Lực Quang', 'cash', 'completed', '2025-12-20 19:41:09', '2025-12-20 19:41:09'),
(134, 'INV-20251221-FXF5ID', 20, 190, NULL, 55000, NULL, 55000, 'Nguyễn Văn Dược', 'cash', 'completed', '2025-12-20 19:46:44', '2025-12-20 19:46:44'),
(135, 'INV-20251221-ILTXNG', 20, 191, NULL, 70000, NULL, 70000, 'Nguyễn Văn Dược', 'cash', 'completed', '2025-12-20 21:26:35', '2025-12-20 21:26:35'),
(136, 'INV-20251221-LJEKRO', 20, 192, NULL, 36000, NULL, 36000, 'Nguyễn Văn Dược', 'cash', 'completed', '2025-12-20 21:35:05', '2025-12-20 21:35:05'),
(137, 'INV-20251221-AROLAU', 20, 189, NULL, 49000, NULL, 49000, 'Nguyễn Văn Dược', 'cash', 'completed', '2025-12-20 21:46:58', '2025-12-20 21:46:58'),
(138, 'INV-20251221-KFGCVY', 20, 195, NULL, 70000, NULL, 70000, 'Nguyễn Văn Dược', 'cash', 'completed', '2025-12-20 22:22:09', '2025-12-20 22:22:09');

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `sale` decimal(10,2) NOT NULL DEFAULT '0.00',
  `images` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id_category` bigint UNSIGNED NOT NULL,
  `status` tinyint NOT NULL DEFAULT '1',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `views` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `promotions`
--

CREATE TABLE `promotions` (
  `id` bigint UNSIGNED NOT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `discount_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'percent',
  `discount_percent` tinyint UNSIGNED DEFAULT NULL,
  `discount_amount` decimal(10,2) DEFAULT NULL,
  `apply_scope` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'service',
  `min_order_amount` decimal(10,2) DEFAULT NULL,
  `max_discount_amount` decimal(10,2) DEFAULT NULL,
  `per_user_limit` int UNSIGNED DEFAULT NULL,
  `usage_limit` int UNSIGNED DEFAULT NULL COMMENT 'Tổng số lượt mã khuyến mãi được dùng cho toàn bộ hệ thống',
  `min_customer_tier` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Áp dụng cho khách hàng từ hạng này trở lên (Khách thường, Silver, Gold, VIP)',
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `promotions`
--

INSERT INTO `promotions` (`id`, `code`, `name`, `description`, `discount_type`, `discount_percent`, `discount_amount`, `apply_scope`, `min_order_amount`, `max_discount_amount`, `per_user_limit`, `usage_limit`, `min_customer_tier`, `start_date`, `end_date`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(26, 'DONG2025', 'CHÀO ĐÔNG 2025', NULL, 'percent', 15, NULL, 'service', NULL, '25000.00', 1, 49, NULL, '2025-12-19', NULL, 'active', '2025-12-19 00:58:39', '2025-12-20 07:15:01', NULL),
(27, 'XUAN2026', 'CHÀO XUÂN 2026', NULL, 'amount', 0, '50000.00', 'order', '500000.00', NULL, 2, 98, NULL, '2025-12-19', NULL, 'active', '2025-12-19 01:00:11', '2025-12-19 17:36:13', NULL),
(28, 'XUANN2026', 'CHÀO XUÂN 2026', NULL, 'amount', 0, '50000.00', 'order', '500000.00', NULL, 2, 100, NULL, '2025-12-19', NULL, 'active', '2025-12-19 01:00:20', '2025-12-19 01:00:38', '2025-12-19 01:00:38'),
(29, 'TOCDEP2025', 'HAIR', NULL, 'percent', 25, NULL, 'order', '250000.00', '15000.00', 4, 48, NULL, '2025-12-19', NULL, 'active', '2025-12-19 01:01:40', '2025-12-20 06:57:30', NULL),
(30, 'VIP2025', 'VIP', NULL, 'percent', 25, NULL, 'customer_tier', NULL, NULL, 3, 17, 'VIP', '2025-12-19', NULL, 'active', '2025-12-19 01:02:26', '2025-12-19 20:39:36', NULL),
(31, 'GOLD2025', 'GOLD', NULL, 'percent', 15, NULL, 'customer_tier', NULL, NULL, 5, 100, 'Gold', '2025-12-19', NULL, 'active', '2025-12-19 01:03:13', '2025-12-20 20:42:28', NULL),
(32, 'SILVER2025', 'SILVER', NULL, 'percent', 10, NULL, 'customer_tier', NULL, '150000.00', 1, 50, 'Silver', '2025-12-19', NULL, 'active', '2025-12-19 01:04:06', '2025-12-19 01:04:06', NULL),
(33, 'KT2025', 'Khách thường', NULL, 'amount', 0, '15000.00', 'customer_tier', NULL, NULL, 2, 99, 'Khách thường', '2025-12-19', NULL, 'active', '2025-12-19 01:05:00', '2025-12-20 19:41:09', NULL),
(34, 'POLYHAIR', 'HAIR', NULL, 'amount', 0, '10000.00', 'service', NULL, NULL, 1, 98, NULL, '2025-12-19', NULL, 'active', '2025-12-19 01:06:22', '2025-12-20 07:15:20', NULL),
(35, 'TESTGIAM', 'TESTGIAM', 'TESTGIAM', 'percent', 10, NULL, 'order', '10000.00', '5000.00', 10, 15, NULL, '2025-12-18', '2025-12-31', 'active', '2025-12-20 18:58:23', '2025-12-20 22:27:18', NULL);

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

--
-- Table structure for table `promotion_service`
--

CREATE TABLE `promotion_service` (
  `id` bigint UNSIGNED NOT NULL,
  `promotion_id` bigint UNSIGNED NOT NULL,
  `service_id` bigint UNSIGNED DEFAULT NULL,
  `combo_id` bigint UNSIGNED DEFAULT NULL,
  `service_variant_id` bigint UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `promotion_service`
--

INSERT INTO `promotion_service` (`id`, `promotion_id`, `service_id`, `combo_id`, `service_variant_id`, `created_at`, `updated_at`) VALUES
(674, 26, 10, NULL, NULL, '2025-12-20 07:15:01', '2025-12-20 07:15:01'),
(675, 26, 9, NULL, NULL, '2025-12-20 07:15:01', '2025-12-20 07:15:01'),
(676, 26, 13, NULL, NULL, '2025-12-20 07:15:01', '2025-12-20 07:15:01'),
(677, 26, 15, NULL, NULL, '2025-12-20 07:15:01', '2025-12-20 07:15:01'),
(678, 26, 21, NULL, NULL, '2025-12-20 07:15:01', '2025-12-20 07:15:01'),
(679, 26, 12, NULL, NULL, '2025-12-20 07:15:01', '2025-12-20 07:15:01'),
(680, 26, 14, NULL, NULL, '2025-12-20 07:15:01', '2025-12-20 07:15:01'),
(681, 26, NULL, 1, NULL, '2025-12-20 07:15:01', '2025-12-20 07:15:01'),
(682, 26, NULL, 2, NULL, '2025-12-20 07:15:01', '2025-12-20 07:15:01'),
(683, 26, NULL, 3, NULL, '2025-12-20 07:15:01', '2025-12-20 07:15:01'),
(684, 26, NULL, 4, NULL, '2025-12-20 07:15:01', '2025-12-20 07:15:01'),
(685, 26, NULL, NULL, 17, '2025-12-20 07:15:01', '2025-12-20 07:15:01'),
(686, 26, NULL, NULL, 18, '2025-12-20 07:15:01', '2025-12-20 07:15:01'),
(687, 26, NULL, NULL, 19, '2025-12-20 07:15:01', '2025-12-20 07:15:01'),
(688, 26, NULL, NULL, 20, '2025-12-20 07:15:01', '2025-12-20 07:15:01'),
(689, 26, NULL, NULL, 21, '2025-12-20 07:15:01', '2025-12-20 07:15:01'),
(690, 26, NULL, NULL, 22, '2025-12-20 07:15:01', '2025-12-20 07:15:01'),
(691, 26, NULL, NULL, 23, '2025-12-20 07:15:01', '2025-12-20 07:15:01'),
(692, 26, NULL, NULL, 24, '2025-12-20 07:15:01', '2025-12-20 07:15:01'),
(693, 26, NULL, NULL, 25, '2025-12-20 07:15:01', '2025-12-20 07:15:01'),
(694, 26, NULL, NULL, 26, '2025-12-20 07:15:01', '2025-12-20 07:15:01'),
(695, 26, NULL, NULL, 27, '2025-12-20 07:15:01', '2025-12-20 07:15:01'),
(696, 26, NULL, NULL, 28, '2025-12-20 07:15:01', '2025-12-20 07:15:01'),
(697, 26, NULL, NULL, 29, '2025-12-20 07:15:01', '2025-12-20 07:15:01'),
(698, 26, NULL, NULL, 30, '2025-12-20 07:15:01', '2025-12-20 07:15:01'),
(699, 34, 10, NULL, NULL, '2025-12-20 07:15:20', '2025-12-20 07:15:20'),
(700, 34, 9, NULL, NULL, '2025-12-20 07:15:20', '2025-12-20 07:15:20'),
(701, 34, 13, NULL, NULL, '2025-12-20 07:15:20', '2025-12-20 07:15:20'),
(702, 34, 15, NULL, NULL, '2025-12-20 07:15:20', '2025-12-20 07:15:20'),
(703, 34, 21, NULL, NULL, '2025-12-20 07:15:20', '2025-12-20 07:15:20'),
(704, 34, 12, NULL, NULL, '2025-12-20 07:15:20', '2025-12-20 07:15:20'),
(705, 34, 14, NULL, NULL, '2025-12-20 07:15:20', '2025-12-20 07:15:20'),
(706, 34, NULL, 1, NULL, '2025-12-20 07:15:20', '2025-12-20 07:15:20'),
(707, 34, NULL, 2, NULL, '2025-12-20 07:15:20', '2025-12-20 07:15:20'),
(708, 34, NULL, 3, NULL, '2025-12-20 07:15:20', '2025-12-20 07:15:20'),
(709, 34, NULL, 4, NULL, '2025-12-20 07:15:20', '2025-12-20 07:15:20'),
(710, 34, NULL, NULL, 17, '2025-12-20 07:15:20', '2025-12-20 07:15:20'),
(711, 34, NULL, NULL, 18, '2025-12-20 07:15:20', '2025-12-20 07:15:20'),
(712, 34, NULL, NULL, 19, '2025-12-20 07:15:20', '2025-12-20 07:15:20'),
(713, 34, NULL, NULL, 20, '2025-12-20 07:15:20', '2025-12-20 07:15:20'),
(714, 34, NULL, NULL, 21, '2025-12-20 07:15:20', '2025-12-20 07:15:20'),
(715, 34, NULL, NULL, 22, '2025-12-20 07:15:20', '2025-12-20 07:15:20'),
(716, 34, NULL, NULL, 23, '2025-12-20 07:15:20', '2025-12-20 07:15:20'),
(717, 34, NULL, NULL, 24, '2025-12-20 07:15:20', '2025-12-20 07:15:20'),
(718, 34, NULL, NULL, 25, '2025-12-20 07:15:20', '2025-12-20 07:15:20'),
(719, 34, NULL, NULL, 26, '2025-12-20 07:15:20', '2025-12-20 07:15:20'),
(720, 34, NULL, NULL, 27, '2025-12-20 07:15:20', '2025-12-20 07:15:20'),
(721, 34, NULL, NULL, 28, '2025-12-20 07:15:20', '2025-12-20 07:15:20'),
(722, 34, NULL, NULL, 29, '2025-12-20 07:15:20', '2025-12-20 07:15:20'),
(723, 34, NULL, NULL, 30, '2025-12-20 07:15:20', '2025-12-20 07:15:20');

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

--
-- Table structure for table `promotion_usages`
--

CREATE TABLE `promotion_usages` (
  `id` bigint UNSIGNED NOT NULL,
  `promotion_id` bigint UNSIGNED NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `appointment_id` bigint UNSIGNED DEFAULT NULL,
  `used_at` timestamp NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `promotion_usages`
--

INSERT INTO `promotion_usages` (`id`, `promotion_id`, `user_id`, `appointment_id`, `used_at`) VALUES
(37, 29, 10, 162, '2025-12-19 01:18:49'),
(38, 29, 10, 164, '2025-12-19 02:57:20'),
(39, 27, 10, 164, '2025-12-19 05:19:24'),
(40, 30, 10, 164, '2025-12-19 05:27:18'),
(41, 27, 10, 165, '2025-12-19 17:36:13'),
(42, 30, 10, 166, '2025-12-19 19:44:37'),
(43, 30, 10, 167, '2025-12-19 20:39:36'),
(44, 26, 10, 164, '2025-12-19 02:53:30'),
(45, 26, 10, 165, '2025-12-19 17:33:04'),
(46, 26, 10, 167, '2025-12-19 20:31:03'),
(47, 26, 10, 168, '2025-12-20 00:05:15'),
(48, 26, 10, 169, '2025-12-20 00:15:05'),
(49, 26, 10, 170, '2025-12-20 00:23:25'),
(50, 26, 10, 172, '2025-12-20 00:30:34'),
(51, 34, 10, 175, '2025-12-20 00:51:56'),
(52, 26, 19, 180, '2025-12-20 01:26:49'),
(53, 34, 19, 181, '2025-12-20 01:37:49'),
(54, 35, 20, 188, '2025-12-20 19:11:49'),
(55, 33, 20, 189, '2025-12-20 19:18:28'),
(56, 35, 19, 184, '2025-12-20 19:39:58'),
(57, 33, 7, 185, '2025-12-20 19:41:09'),
(58, 33, 20, 190, '2025-12-20 19:44:19'),
(59, 35, 20, 190, '2025-12-20 19:46:44'),
(60, 35, 20, 191, '2025-12-20 21:26:35'),
(61, 35, 20, 192, '2025-12-20 21:35:05'),
(62, 35, 20, 189, '2025-12-20 21:46:58'),
(63, 35, 20, 195, '2025-12-20 22:22:09');

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

--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `id` bigint UNSIGNED NOT NULL,
  `appointment_id` bigint UNSIGNED DEFAULT NULL,
  `service_id` bigint UNSIGNED DEFAULT NULL,
  `employee_id` bigint UNSIGNED DEFAULT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `rating` int DEFAULT NULL,
  `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `images` json DEFAULT NULL,
  `is_hidden` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reviews`
--

INSERT INTO `reviews` (`id`, `appointment_id`, `service_id`, `employee_id`, `user_id`, `rating`, `comment`, `images`, `is_hidden`, `created_at`, `updated_at`) VALUES
(1, NULL, 14, NULL, 1, NULL, '234rtyu', NULL, 0, '2025-12-15 20:32:57', '2025-12-15 20:32:57');

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `description`, `created_at`, `updated_at`) VALUES
(1, 'admin', 'Quản trị viên', '2025-12-01 10:36:20', '2025-12-01 10:36:20'),
(2, 'nhân viên', 'Nhân viên', '2025-12-01 10:36:20', '2025-12-01 10:36:20'),
(3, 'khách hàng', 'Khách hàng', '2025-12-01 10:36:20', '2025-12-01 10:36:20');

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

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` bigint UNSIGNED NOT NULL,
  `service_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category_id` bigint UNSIGNED DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `base_price` decimal(10,2) DEFAULT NULL,
  `base_duration` int UNSIGNED DEFAULT NULL,
  `status` enum('Hoạt động','Vô hiệu hóa') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sort_order` int UNSIGNED NOT NULL DEFAULT '0',
  `is_featured` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`id`, `service_code`, `category_id`, `name`, `slug`, `description`, `image`, `base_price`, `base_duration`, `status`, `sort_order`, `is_featured`, `created_at`, `updated_at`, `deleted_at`) VALUES
(9, 'DV000001', 5, 'Cắt tóc trẻ em', NULL, NULL, '1764688396_cat-toc-tre-em.jpg', '30000.00', 30, 'Hoạt động', 0, 0, '2025-12-02 08:03:47', '2025-12-04 15:47:27', NULL),
(10, 'DV000010', 5, 'Cắt tóc nam', NULL, NULL, '1764688047_cat-toc.jpg', '80000.00', 30, 'Hoạt động', 0, 0, '2025-12-02 08:07:27', '2025-12-04 15:10:06', NULL),
(11, 'DV000011', 5, 'Cắt tóc nữ', NULL, NULL, '1764691499_cat-toc-2.jpg', NULL, NULL, 'Hoạt động', 0, 0, '2025-12-02 08:28:38', '2025-12-02 09:04:59', NULL),
(12, 'DV000012', 5, 'Gội thư giãn cổ vai gáy', NULL, NULL, '1764785417_z3770073394122_f33e0adea63fab1e68934c9c7dc32018-1.jpg', '139000.00', 30, 'Hoạt động', 0, 0, '2025-12-02 08:45:49', '2025-12-04 15:10:45', NULL),
(13, 'DV000013', 8, 'Chăm sóc da Ultrawhite', NULL, NULL, '1764691299_csd1.PNG', '55000.00', 40, 'Hoạt động', 0, 0, '2025-12-02 08:56:41', '2025-12-04 15:47:07', NULL),
(14, 'DV000014', 8, 'Tẩy da chết sủi bọt Hàn Quốc', NULL, NULL, '1764691398_csd2.PNG', '35000.00', 20, 'Hoạt động', 0, 0, '2025-12-02 08:58:27', '2025-12-04 15:46:54', NULL),
(15, 'DV000015', 8, 'Đánh bay mụn cám lột mụn full face', NULL, NULL, '1764691642_csd3.PNG', '49000.00', 30, 'Hoạt động', 0, 0, '2025-12-02 09:07:22', '2025-12-04 15:46:38', NULL),
(16, 'DV000016', 9, 'Uốn tóc nam', NULL, NULL, '1764834132_cac-kieu-uon-toc-nam-26.jpg', NULL, NULL, 'Hoạt động', 0, 0, '2025-12-02 09:33:24', '2025-12-04 00:42:12', NULL),
(17, 'DV000017', 9, 'Uốn tóc nữ cơ bản', NULL, NULL, '1764786034_uon-toc-nu.jpg', NULL, NULL, 'Hoạt động', 0, 0, '2025-12-03 11:20:34', '2025-12-03 11:20:34', NULL),
(18, 'DV000018', 9, 'Uốn tóc nữ Hàn Quốc', NULL, NULL, '1764824424_toc-xoan-mai-thua-hq.jpg', NULL, NULL, 'Hoạt động', 0, 0, '2025-12-03 22:00:24', '2025-12-03 22:00:24', NULL),
(19, 'DV000019', 9, 'Uốn tóc nữ cá tính', NULL, NULL, '1764824538_toc-mullet-layer-xoan.jpg', NULL, NULL, 'Hoạt động', 0, 0, '2025-12-03 22:02:18', '2025-12-03 22:02:18', NULL),
(20, 'DV000020', 10, 'Nhuộm tóc nam', NULL, NULL, '1764834666_bang-mau-nhuom-toc-nam-8.jpg', NULL, NULL, 'Hoạt động', 0, 0, '2025-12-03 22:05:21', '2025-12-04 00:51:06', NULL),
(21, 'DV000021', 5, 'Gội đầu', NULL, NULL, '1764855082_young-woman-having-hair-washed-in-salon-e1576678689352.jpg', '40000.00', 10, 'Hoạt động', 0, 0, '2025-12-04 06:31:22', '2025-12-04 15:45:17', NULL);

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

--
-- Table structure for table `service_categories`
--

CREATE TABLE `service_categories` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `sort_order` int UNSIGNED NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `service_categories`
--

INSERT INTO `service_categories` (`id`, `name`, `slug`, `description`, `sort_order`, `is_active`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Cắt tóc', 'cat-toc', 'Dịch vụ cắt tóc chuyên nghiệp', 0, 1, '2025-12-01 10:44:14', '2025-12-02 07:57:40', '2025-12-02 07:57:40'),
(2, 'Nhuộm tóc', NULL, 'Dịch vụ nhuộm tóc đa dạng màu sắc', 0, 1, '2025-12-01 10:44:14', '2025-12-02 07:57:46', '2025-12-02 07:57:46'),
(3, 'Uốn tóc', NULL, 'Dịch vụ uốn tóc tạo kiểu', 0, 1, '2025-12-01 10:44:14', '2025-12-02 07:57:49', '2025-12-02 07:57:49'),
(4, 'Chăm sóc tóc', 'cham-soc-toc', 'Dịch vụ chăm sóc và phục hồi tóc', 0, 1, '2025-12-01 10:44:14', '2025-12-02 07:57:43', '2025-12-02 07:57:43'),
(5, 'Cắt - Gội - Xả thư giãn', 'cat-goi-xa-thu-gian', NULL, 0, 1, '2025-12-02 08:00:42', '2025-12-02 08:00:42', NULL),
(6, 'Gội dưỡng sinh thư giãn - Relax', 'goi-duong-sinh-thu-gian-relax', NULL, 0, 1, '2025-12-02 08:01:32', '2025-12-02 08:01:32', NULL),
(7, 'Dịch vụ khác', 'dich-vu-khac', NULL, 0, 1, '2025-12-02 08:02:16', '2025-12-02 08:02:16', NULL),
(8, 'Chăm sóc da cơ bản', 'cham-soc-da-co-ban', NULL, 0, 1, '2025-12-02 08:02:34', '2025-12-02 08:02:34', NULL),
(9, 'Uốn định hình nếp tóc', 'uon-dinh-hinh-nep-toc', NULL, 0, 1, '2025-12-02 08:02:51', '2025-12-02 08:02:51', NULL),
(10, 'Nhuộm tóc - Dưỡng tóc', 'nhuom-toc-duong-toc', NULL, 0, 1, '2025-12-02 08:03:21', '2025-12-02 08:03:21', NULL);

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

--
-- Table structure for table `service_variants`
--

CREATE TABLE `service_variants` (
  `id` bigint UNSIGNED NOT NULL,
  `service_id` bigint UNSIGNED DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sku` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `duration` int DEFAULT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `sort_order` int UNSIGNED NOT NULL DEFAULT '0',
  `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `service_variants`
--

INSERT INTO `service_variants` (`id`, `service_id`, `name`, `sku`, `price`, `duration`, `is_default`, `is_active`, `sort_order`, `notes`, `created_at`, `updated_at`, `deleted_at`) VALUES
(17, 11, 'Cắt tóc nữ cơ bản', NULL, '100000.00', 30, 0, 1, 0, NULL, '2025-12-02 08:28:38', '2025-12-02 08:28:38', NULL),
(18, 11, 'Cắt tóc nữ tạo kiểu', NULL, '150000.00', 60, 0, 1, 0, NULL, '2025-12-02 08:28:38', '2025-12-02 08:28:38', NULL),
(19, 11, 'Cắt tóc nữ tạo kiểu', NULL, '120000.00', 45, 0, 1, 0, NULL, '2025-12-02 08:28:38', '2025-12-02 08:28:38', NULL),
(20, 16, 'Uốn cơ bản', NULL, '250000.00', 50, 0, 1, 0, NULL, '2025-12-02 09:33:24', '2025-12-02 09:33:24', NULL),
(21, 16, 'Uốn tóc con sâu', NULL, '300000.00', 60, 0, 1, 0, NULL, '2025-12-02 09:33:24', '2025-12-02 09:33:24', NULL),
(22, 17, 'Uốn tóc nữ xoăn sóng', NULL, '499000.00', 60, 0, 1, 0, NULL, '2025-12-03 11:20:34', '2025-12-03 11:20:34', NULL),
(23, 17, 'Uốn tóc nữ sóng lơi', NULL, '399000.00', 50, 0, 1, 0, NULL, '2025-12-03 11:20:34', '2025-12-03 11:20:34', NULL),
(24, 18, 'Uốn tóc xoăn mái thưa Hàn Quốc', NULL, '599000.00', 90, 0, 1, 0, NULL, '2025-12-03 22:00:24', '2025-12-03 22:00:24', NULL),
(25, 18, 'Uốn tóc xoăn Hippie cá tính', NULL, '449000.00', 90, 0, 1, 0, NULL, '2025-12-03 22:00:24', '2025-12-03 22:00:24', NULL),
(26, 18, 'Tóc xoăn sóng ngang vai', NULL, '499000.00', 60, 0, 1, 0, NULL, '2025-12-03 22:00:24', '2025-12-03 22:00:24', NULL),
(27, 19, 'Tóc Layer Mullet Xoăn', NULL, '549000.00', 90, 0, 1, 0, NULL, '2025-12-03 22:02:18', '2025-12-03 22:02:18', NULL),
(28, 20, 'Nhuộm nâu trà sữa', NULL, '499000.00', 90, 0, 1, 0, NULL, '2025-12-03 22:05:21', '2025-12-03 22:05:21', NULL),
(29, 20, 'Nhuộm xám khói', NULL, '449000.00', 120, 0, 1, 0, NULL, '2025-12-03 22:05:21', '2025-12-03 22:05:21', NULL),
(30, 20, 'Nhuộm bạch kim', NULL, '549000.00', 180, 0, 1, 0, NULL, '2025-12-03 22:05:21', '2025-12-03 22:05:21', NULL);

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

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

CREATE TABLE `sessions` (
  `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `payload` longtext CHARACTER SET utf8mb4 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
('Qxmpn7vQCpUFWZQne9uXiUis4dmTIhvtuMUn9D00', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTo3OntzOjY6Il90b2tlbiI7czo0MDoiT3Z2U2o2d1BFRkp6TnJ2MWZieDlLMGtFbGZmZ1AyVjFVQThHVjVSWSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6ODg6Imh0dHBzOi8vcG9seWhhaXIudm4vYWRtaW4vYXBwb2ludG1lbnRzL2NoZWNrb3V0P2FwcG9pbnRtZW50X2lkPTE5NyZwcm9tb3Rpb25fc2NvcGU9b3JkZXIiO3M6NToicm91dGUiO3M6Mjc6ImFkbWluLmFwcG9pbnRtZW50cy5jaGVja291dCI7fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjE7czo0OiJjYXJ0IjthOjE6e3M6MTU6ImFwcG9pbnRtZW50XzE5NyI7YTozOntzOjQ6InR5cGUiO3M6MTE6ImFwcG9pbnRtZW50IjtzOjI6ImlkIjtpOjE5NztzOjg6InF1YW50aXR5IjtpOjE7fX1zOjExOiJjb3Vwb25fY29kZSI7czo4OiJURVNUR0lBTSI7czoyMDoiYXBwbGllZF9wcm9tb3Rpb25faWQiO2k6MzU7fQ==', 1766269686),
('rCDcewU5K3850Yg9OM93e5Z4VlzPXd772rDCpQfB', 5, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36', 'YTo3OntzOjY6Il90b2tlbiI7czo0MDoiUkJUU3haSkMyaW9DZ0pYamlqWFdkS1M4dzJ0MXNDbTFPUlgzaTZOZSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NzU6Imh0dHBzOi8vcG9seWhhaXIudm4vYWRtaW4vZW1wbG95ZWUvYXBwb2ludG1lbnRzL2NoZWNrb3V0P2FwcG9pbnRtZW50X2lkPTE5NyI7czo1OiJyb3V0ZSI7czozMDoiZW1wbG95ZWUuYXBwb2ludG1lbnRzLmNoZWNrb3V0Ijt9czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6NTtzOjQ6ImNhcnQiO2E6MTp7czoxNToiYXBwb2ludG1lbnRfMTk3IjthOjM6e3M6NDoidHlwZSI7czoxMToiYXBwb2ludG1lbnQiO3M6MjoiaWQiO2k6MTk3O3M6ODoicXVhbnRpdHkiO2k6MTt9fXM6MTE6ImNvdXBvbl9jb2RlIjtzOjg6IlRFU1RHSUFNIjtzOjIwOiJhcHBsaWVkX3Byb21vdGlvbl9pZCI7aTozNTt9', 1766269658);

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint UNSIGNED NOT NULL,
  `logo` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_ico` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `introduce` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `slogan` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `types`
--

CREATE TABLE `types` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `images` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `variant_attributes`
--

CREATE TABLE `variant_attributes` (
  `id` bigint UNSIGNED NOT NULL,
  `service_variant_id` bigint UNSIGNED DEFAULT NULL,
  `attribute_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attribute_value` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `variant_attributes`
--

INSERT INTO `variant_attributes` (`id`, `service_variant_id`, `attribute_name`, `attribute_value`, `created_at`, `updated_at`) VALUES
(13, 18, 'Tóc', 'Dài', '2025-12-03 11:03:49', '2025-12-03 11:03:49'),
(14, 18, 'Tóc', 'Trung bình', '2025-12-03 11:03:49', '2025-12-03 11:03:49'),
(15, 19, 'Tóc', 'Ngắn', '2025-12-03 11:03:49', '2025-12-03 11:03:49'),
(16, 22, 'Tóc', 'Dài', '2025-12-03 11:20:34', '2025-12-03 11:20:34'),
(17, 22, 'Tóc', 'Trung bình', '2025-12-03 11:20:34', '2025-12-03 11:20:34'),
(18, 23, 'Tóc', 'Dài', '2025-12-03 11:20:34', '2025-12-03 11:20:34'),
(19, 24, 'Tóc', 'Dài', '2025-12-03 22:00:24', '2025-12-03 22:00:24'),
(20, 25, 'Tóc', 'Dài', '2025-12-03 22:00:24', '2025-12-03 22:00:24'),
(23, 20, 'Tóc', 'Trung bình', '2025-12-04 00:42:12', '2025-12-04 00:42:12'),
(24, 20, 'Tóc', 'Dài', '2025-12-04 00:42:12', '2025-12-04 00:42:12'),
(25, 21, 'Tóc', 'Ngắn', '2025-12-04 00:42:12', '2025-12-04 00:42:12'),
(26, 21, 'Tóc', 'Trung bình', '2025-12-04 00:42:12', '2025-12-04 00:42:12'),
(29, 28, 'Tóc', 'Ngắn', '2025-12-04 00:51:06', '2025-12-04 00:51:06'),
(30, 28, 'Tóc', 'Trung bình', '2025-12-04 00:51:06', '2025-12-04 00:51:06');

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

--
-- Table structure for table `word_time`
--

CREATE TABLE `word_time` (
  `id` bigint UNSIGNED NOT NULL,
  `time` time NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `word_time`
--

INSERT INTO `word_time` (`id`, `time`, `created_at`, `updated_at`) VALUES
(1, '07:00:00', '2025-12-04 07:23:02', '2025-12-04 07:23:02'),
(2, '07:30:00', '2025-12-04 07:23:02', '2025-12-04 07:23:02'),
(3, '08:00:00', '2025-12-04 07:23:02', '2025-12-04 07:23:02'),
(4, '08:30:00', '2025-12-04 07:23:02', '2025-12-04 07:23:02'),
(5, '09:00:00', '2025-12-04 07:23:02', '2025-12-04 07:23:02'),
(6, '09:30:00', '2025-12-04 07:23:02', '2025-12-04 07:23:02'),
(7, '10:00:00', '2025-12-04 07:23:02', '2025-12-04 07:23:02'),
(8, '10:30:00', '2025-12-04 07:23:02', '2025-12-04 07:23:02'),
(9, '11:00:00', '2025-12-04 07:23:02', '2025-12-04 07:23:02'),
(10, '11:30:00', '2025-12-04 07:23:02', '2025-12-04 07:23:02'),
(11, '12:00:00', '2025-12-04 07:23:02', '2025-12-04 07:23:02'),
(12, '12:30:00', '2025-12-04 07:23:02', '2025-12-04 07:23:02'),
(13, '13:00:00', '2025-12-04 07:23:02', '2025-12-04 07:23:02'),
(14, '13:30:00', '2025-12-04 07:23:02', '2025-12-04 07:23:02'),
(15, '14:00:00', '2025-12-04 07:23:02', '2025-12-04 07:23:02'),
(16, '14:30:00', '2025-12-04 07:23:02', '2025-12-04 07:23:02'),
(17, '15:00:00', '2025-12-04 07:23:02', '2025-12-04 07:23:02'),
(18, '15:30:00', '2025-12-04 07:23:02', '2025-12-04 07:23:02'),
(19, '16:00:00', '2025-12-04 07:23:02', '2025-12-04 07:23:02'),
(20, '16:30:00', '2025-12-04 07:23:02', '2025-12-04 07:23:02'),
(21, '17:00:00', '2025-12-04 07:23:02', '2025-12-04 07:23:02'),
(22, '17:30:00', '2025-12-04 07:23:02', '2025-12-04 07:23:02'),
(23, '18:00:00', '2025-12-04 07:23:02', '2025-12-04 07:23:02'),
(24, '18:30:00', '2025-12-04 07:23:02', '2025-12-04 07:23:02'),
(25, '19:00:00', '2025-12-04 07:23:02', '2025-12-04 07:23:02'),
(26, '19:30:00', '2025-12-04 07:23:02', '2025-12-04 07:23:02'),
(27, '20:00:00', '2025-12-04 07:23:02', '2025-12-04 07:23:02'),
(28, '20:30:00', '2025-12-04 07:23:02', '2025-12-04 07:23:02'),
(29, '21:00:00', '2025-12-04 07:23:02', '2025-12-04 07:23:02'),
(30, '21:30:00', '2025-12-04 07:23:02', '2025-12-04 07:23:02'),
(31, '22:00:00', '2025-12-04 07:23:02', '2025-12-04 07:23:02'),
(32, '22:30:00', '2025-12-04 15:37:33', '2025-12-04 15:37:33'),
(33, '23:00:00', '2025-12-04 15:37:33', '2025-12-04 15:37:33'),
(34, '23:30:00', '2025-12-04 15:37:33', '2025-12-04 15:37:33'),
(35, '00:00:00', '2025-12-04 15:37:33', '2025-12-04 15:37:33'),
(36, '00:30:00', '2025-12-09 17:39:18', '2025-12-09 17:39:18'),
(37, '01:00:00', '2025-12-09 17:39:18', '2025-12-09 17:39:18'),
(38, '01:30:00', '2025-12-09 17:39:18', '2025-12-09 17:39:18'),
(39, '02:00:00', '2025-12-09 17:39:18', '2025-12-09 17:39:18'),
(40, '02:30:00', '2025-12-09 17:39:18', '2025-12-09 17:39:18'),
(41, '03:00:00', '2025-12-09 17:39:18', '2025-12-09 17:39:18'),
(42, '03:30:00', '2025-12-09 17:39:18', '2025-12-09 17:39:18'),
(43, '04:00:00', '2025-12-15 19:58:41', '2025-12-15 19:58:41'),
(44, '04:30:00', '2025-12-15 19:58:41', '2025-12-15 19:58:41'),
(45, '05:00:00', '2025-12-15 19:58:41', '2025-12-15 19:58:41'),
(46, '05:30:00', '2025-12-15 19:58:41', '2025-12-15 19:58:41'),
(47, '06:00:00', '2025-12-15 19:58:41', '2025-12-15 19:58:41'),
(48, '06:30:00', '2025-12-15 19:58:41', '2025-12-15 19:58:41');

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

--
-- Table structure for table `working_schedule`
--

CREATE TABLE `working_schedule` (
  `id` bigint UNSIGNED NOT NULL,
  `employee_id` bigint UNSIGNED DEFAULT NULL,
  `work_date` date DEFAULT NULL,
  `shift_id` bigint UNSIGNED DEFAULT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_handover` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `working_schedule`
--

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

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

--
-- Table structure for table `working_shifts`
--

CREATE TABLE `working_shifts` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `duration` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `working_shifts`
--

INSERT INTO `working_shifts` (`id`, `name`, `start_time`, `end_time`, `duration`, `created_at`, `updated_at`) VALUES
(1, 'Ca sáng', '07:00:00', '12:00:00', 300, '2025-12-01 10:36:47', '2025-12-01 10:36:47'),
(2, 'Ca chiều', '12:00:00', '17:00:00', 300, '2025-12-01 10:36:47', '2025-12-01 10:36:47'),
(3, 'Ca tối', '17:00:00', '22:00:00', 300, '2025-12-01 10:36:47', '2025-12-01 10:36:47'),
(6, 'Ca cả ngày', '07:00:00', '22:00:00', 900, '2025-12-20 18:18:18', '2025-12-20 18:18:18');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `appointments`
--
ALTER TABLE `appointments`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `appointments_booking_code_unique` (`booking_code`),
  ADD KEY `appointments_user_id_foreign` (`user_id`),
  ADD KEY `appointments_employee_id_foreign` (`employee_id`),
  ADD KEY `appointments_promotion_id_foreign` (`promotion_id`);

--
-- Indexes for table `appointment_details`
--
ALTER TABLE `appointment_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `appointment_details_appointment_id_foreign` (`appointment_id`),
  ADD KEY `appointment_details_service_variant_id_foreign` (`service_variant_id`),
  ADD KEY `appointment_details_employee_id_foreign` (`employee_id`),
  ADD KEY `appointment_details_combo_id_foreign` (`combo_id`),
  ADD KEY `appointment_details_combo_item_id_foreign` (`combo_item_id`),
  ADD KEY `appointment_details_promotion_id_foreign` (`promotion_id`);

--
-- Indexes for table `appointment_logs`
--
ALTER TABLE `appointment_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `appointment_logs_appointment_id_foreign` (`appointment_id`),
  ADD KEY `appointment_logs_modified_by_foreign` (`modified_by`);

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

--
-- Indexes for table `combos`
--
ALTER TABLE `combos`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `combos_slug_unique` (`slug`),
  ADD KEY `combos_category_id_foreign` (`category_id`),
  ADD KEY `combos_owner_service_id_foreign` (`owner_service_id`);

--
-- Indexes for table `combo_items`
--
ALTER TABLE `combo_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `combo_items_combo_id_foreign` (`combo_id`),
  ADD KEY `combo_items_service_id_foreign` (`service_id`),
  ADD KEY `combo_items_service_variant_id_foreign` (`service_variant_id`);

--
-- Indexes for table `comments`
--
ALTER TABLE `comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `comments_id_product_foreign` (`id_product`),
  ADD KEY `comments_id_user_foreign` (`id_user`);

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

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

--
-- Indexes for table `employee_skills`
--
ALTER TABLE `employee_skills`
  ADD PRIMARY KEY (`id`),
  ADD KEY `employee_skills_employee_id_foreign` (`employee_id`),
  ADD KEY `employee_skills_service_id_foreign` (`service_id`);

--
-- Indexes for table `evaluates`
--
ALTER TABLE `evaluates`
  ADD PRIMARY KEY (`id`),
  ADD KEY `evaluates_id_user_foreign` (`id_user`),
  ADD KEY `evaluates_id_appointment_foreign` (`id_appointment`),
  ADD KEY `evaluates_id_service_foreign` (`id_service`);

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

--
-- 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 `news`
--
ALTER TABLE `news`
  ADD PRIMARY KEY (`id`),
  ADD KEY `news_id_user_foreign` (`id_user`);

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

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `orders_id_user_foreign` (`id_user`);

--
-- Indexes for table `order_details`
--
ALTER TABLE `order_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_details_id_order_foreign` (`id_order`),
  ADD KEY `order_details_id_product_foreign` (`id_product`);

--
-- Indexes for table `payments`
--
ALTER TABLE `payments`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `payments_invoice_code_unique` (`invoice_code`),
  ADD KEY `payments_user_id_foreign` (`user_id`),
  ADD KEY `payments_appointment_id_foreign` (`appointment_id`),
  ADD KEY `payments_order_id_foreign` (`order_id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `products_id_category_foreign` (`id_category`);

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

--
-- Indexes for table `promotion_service`
--
ALTER TABLE `promotion_service`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `promotion_service_promotion_id_service_id_unique` (`promotion_id`,`service_id`),
  ADD UNIQUE KEY `promotion_service_promotion_id_combo_id_unique` (`promotion_id`,`combo_id`),
  ADD UNIQUE KEY `promotion_service_promotion_id_service_variant_id_unique` (`promotion_id`,`service_variant_id`),
  ADD KEY `promotion_service_service_id_foreign` (`service_id`),
  ADD KEY `promotion_service_combo_id_foreign` (`combo_id`),
  ADD KEY `promotion_service_service_variant_id_foreign` (`service_variant_id`);

--
-- Indexes for table `promotion_usages`
--
ALTER TABLE `promotion_usages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `promotion_usages_promotion_id_foreign` (`promotion_id`),
  ADD KEY `promotion_usages_user_id_foreign` (`user_id`),
  ADD KEY `promotion_usages_appointment_id_foreign` (`appointment_id`);

--
-- Indexes for table `reviews`
--
ALTER TABLE `reviews`
  ADD PRIMARY KEY (`id`),
  ADD KEY `reviews_appointment_id_foreign` (`appointment_id`),
  ADD KEY `reviews_service_id_foreign` (`service_id`),
  ADD KEY `reviews_employee_id_foreign` (`employee_id`),
  ADD KEY `reviews_user_id_foreign` (`user_id`);

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

--
-- Indexes for table `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `services_slug_unique` (`slug`),
  ADD UNIQUE KEY `services_service_code_unique` (`service_code`),
  ADD KEY `services_category_id_foreign` (`category_id`);

--
-- Indexes for table `service_categories`
--
ALTER TABLE `service_categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `service_categories_slug_unique` (`slug`);

--
-- Indexes for table `service_variants`
--
ALTER TABLE `service_variants`
  ADD PRIMARY KEY (`id`),
  ADD KEY `service_variants_service_id_foreign` (`service_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 `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`);

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

--
-- Indexes for table `variant_attributes`
--
ALTER TABLE `variant_attributes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `variant_attributes_service_variant_id_foreign` (`service_variant_id`);

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

--
-- Indexes for table `working_schedule`
--
ALTER TABLE `working_schedule`
  ADD PRIMARY KEY (`id`),
  ADD KEY `working_schedule_employee_id_foreign` (`employee_id`),
  ADD KEY `working_schedule_shift_id_foreign` (`shift_id`);

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `appointments`
--
ALTER TABLE `appointments`
  ADD CONSTRAINT `appointments_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `appointments_promotion_id_foreign` FOREIGN KEY (`promotion_id`) REFERENCES `promotions` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `appointments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `appointment_details`
--
ALTER TABLE `appointment_details`
  ADD CONSTRAINT `appointment_details_appointment_id_foreign` FOREIGN KEY (`appointment_id`) REFERENCES `appointments` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `appointment_details_combo_id_foreign` FOREIGN KEY (`combo_id`) REFERENCES `combos` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `appointment_details_combo_item_id_foreign` FOREIGN KEY (`combo_item_id`) REFERENCES `combo_items` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `appointment_details_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `appointment_details_promotion_id_foreign` FOREIGN KEY (`promotion_id`) REFERENCES `promotions` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `appointment_details_service_variant_id_foreign` FOREIGN KEY (`service_variant_id`) REFERENCES `service_variants` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `appointment_logs`
--
ALTER TABLE `appointment_logs`
  ADD CONSTRAINT `appointment_logs_appointment_id_foreign` FOREIGN KEY (`appointment_id`) REFERENCES `appointments` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `appointment_logs_modified_by_foreign` FOREIGN KEY (`modified_by`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `combos`
--
ALTER TABLE `combos`
  ADD CONSTRAINT `combos_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `service_categories` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `combos_owner_service_id_foreign` FOREIGN KEY (`owner_service_id`) REFERENCES `services` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `combo_items`
--
ALTER TABLE `combo_items`
  ADD CONSTRAINT `combo_items_combo_id_foreign` FOREIGN KEY (`combo_id`) REFERENCES `combos` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `combo_items_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `combo_items_service_variant_id_foreign` FOREIGN KEY (`service_variant_id`) REFERENCES `service_variants` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `comments`
--
ALTER TABLE `comments`
  ADD CONSTRAINT `comments_id_product_foreign` FOREIGN KEY (`id_product`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `comments_id_user_foreign` FOREIGN KEY (`id_user`) REFERENCES `users` (`id`) ON DELETE CASCADE;

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

--
-- Constraints for table `employee_skills`
--
ALTER TABLE `employee_skills`
  ADD CONSTRAINT `employee_skills_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `employee_skills_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `evaluates`
--
ALTER TABLE `evaluates`
  ADD CONSTRAINT `evaluates_id_appointment_foreign` FOREIGN KEY (`id_appointment`) REFERENCES `appointments` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `evaluates_id_service_foreign` FOREIGN KEY (`id_service`) REFERENCES `services` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `evaluates_id_user_foreign` FOREIGN KEY (`id_user`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `news`
--
ALTER TABLE `news`
  ADD CONSTRAINT `news_id_user_foreign` FOREIGN KEY (`id_user`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `notifications`
--
ALTER TABLE `notifications`
  ADD CONSTRAINT `notifications_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_id_user_foreign` FOREIGN KEY (`id_user`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `order_details`
--
ALTER TABLE `order_details`
  ADD CONSTRAINT `order_details_id_order_foreign` FOREIGN KEY (`id_order`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `order_details_id_product_foreign` FOREIGN KEY (`id_product`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `payments`
--
ALTER TABLE `payments`
  ADD CONSTRAINT `payments_appointment_id_foreign` FOREIGN KEY (`appointment_id`) REFERENCES `appointments` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `payments_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `payments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_id_category_foreign` FOREIGN KEY (`id_category`) REFERENCES `categories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `promotion_service`
--
ALTER TABLE `promotion_service`
  ADD CONSTRAINT `promotion_service_combo_id_foreign` FOREIGN KEY (`combo_id`) REFERENCES `combos` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `promotion_service_promotion_id_foreign` FOREIGN KEY (`promotion_id`) REFERENCES `promotions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `promotion_service_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `promotion_service_service_variant_id_foreign` FOREIGN KEY (`service_variant_id`) REFERENCES `service_variants` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `promotion_usages`
--
ALTER TABLE `promotion_usages`
  ADD CONSTRAINT `promotion_usages_appointment_id_foreign` FOREIGN KEY (`appointment_id`) REFERENCES `appointments` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `promotion_usages_promotion_id_foreign` FOREIGN KEY (`promotion_id`) REFERENCES `promotions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `promotion_usages_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `reviews`
--
ALTER TABLE `reviews`
  ADD CONSTRAINT `reviews_appointment_id_foreign` FOREIGN KEY (`appointment_id`) REFERENCES `appointments` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `reviews_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `reviews_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `reviews_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `services`
--
ALTER TABLE `services`
  ADD CONSTRAINT `services_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `service_categories` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `service_variants`
--
ALTER TABLE `service_variants`
  ADD CONSTRAINT `service_variants_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `variant_attributes`
--
ALTER TABLE `variant_attributes`
  ADD CONSTRAINT `variant_attributes_service_variant_id_foreign` FOREIGN KEY (`service_variant_id`) REFERENCES `service_variants` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `working_schedule`
--
ALTER TABLE `working_schedule`
  ADD CONSTRAINT `working_schedule_employee_id_foreign` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `working_schedule_shift_id_foreign` FOREIGN KEY (`shift_id`) REFERENCES `working_shifts` (`id`) ON DELETE SET NULL;
COMMIT;

