--
-- Host: hanyu-db.mysql.database.azure.com    Database: nsysu_salary
-- ------------------------------------------------------


--
-- Table structure for table `class_schedules`
--

CREATE TABLE `class_schedules` (
  `class_id` int NOT NULL AUTO_INCREMENT,
  `employee_id` int NOT NULL,
  `class_name` varchar(100) NOT NULL,
  `class_hours` decimal(5,2) DEFAULT NULL,
  `class_day` date DEFAULT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `hourly_fee` int DEFAULT NULL,
  `overtime_rate` decimal(10,2) DEFAULT NULL,
  `overtime_rate_167` decimal(10,2) DEFAULT NULL,
  `is_recurring` tinyint(1) DEFAULT '0' COMMENT '是否為周期性會議',
  `recurrence_type` varchar(30) DEFAULT NULL COMMENT '周期類型ENUM(daily,weekly,monthly,custom)',
  `recurrence_pattern` varchar(100) DEFAULT NULL COMMENT '周期模式(例如: 每週一三五/每月1號/每月第一個星期一)',
  `recurrence_end_date` date DEFAULT NULL COMMENT '週期結束日期',
  `slot_name` varchar(100) DEFAULT NULL COMMENT '時段名稱',
  `class_remark` varchar(255) DEFAULT NULL COMMENT '備註',
  `root_id` int DEFAULT '0' COMMENT 'class_id-表頭',
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '建檔日期',
  `update_date` datetime DEFAULT NULL COMMENT '更新日期',
  `updated_by` varchar(100) DEFAULT NULL COMMENT '更新人員',
  PRIMARY KEY (`class_id`)
) ENGINE=InnoDB AUTO_INCREMENT=295 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `class_schedules`
--

INSERT INTO `class_schedules` VALUES (39,3,'課程1',14.00,'2025-02-17','00:00:00','14:00:00',600,NULL,NULL,1,'weekly','每週2,4','2025-06-06','','',39,'2025-04-28 21:20:48','2025-04-28 21:20:48','e0001'),(40,3,'課程1',14.00,'2025-02-18','00:00:00','14:00:00',600,NULL,NULL,1,'weekly','每週2,4','2025-06-06','','',39,'2025-04-28 21:20:48','2025-04-28 21:20:48','e0001'),(41,3,'課程1',14.00,'2025-02-20','00:00:00','14:00:00',600,NULL,NULL,1,'weekly','每週2,4','2025-06-06','','',39,'2025-04-28 21:20:48','2025-04-28 21:20:48','e0001'),(42,3,'課程1',14.00,'2025-02-25','00:00:00','14:00:00',600,NULL,NULL,1,'weekly','每週2,4','2025-06-06','','',39,'2025-04-28 21:20:48','2025-04-28 21:20:48','e0001'),(43,3,'課程1',14.00,'2025-02-27','00:00:00','14:00:00',600,NULL,NULL,1,'weekly','每週2,4','2025-06-06','','',39,'2025-04-28 21:20:48','2025-04-28 21:20:48','e0001'),(44,3,'課程1',14.00,'2025-03-04','00:00:00','14:00:00',600,NULL,NULL,1,'weekly','每週2,4','2025-06-06','','',39,'2025-04-28 21:20:48','2025-04-28 21:20:48','e0001'),(45,3,'課程1',14.00,'2025-03-06','00:00:00','14:00:00',600,NULL,NULL,1,'weekly','每週2,4','2025-06-06','','',39,'2025-04-28 21:20:48','2025-04-28 21:20:48','e0001'),(46,3,'課程1',14.00,'2025-03-11','00:00:00','14:00:00',600,NULL,NULL,1,'weekly','每週2,4','2025-06-06','','',39,'2025-04-28 21:20:48','2025-04-28 21:20:48','e0001'),(47,3,'課程1',14.00,'2025-03-13','00:00:00','14:00:00',600,NULL,NULL,1,'weekly','每週2,4','2025-06-06','','',39,'2025-04-28 21:20:48','2025-04-28 21:20:48','e0001'),(48,3,'課程1',14.00,'2025-03-18','00:00:00','14:00:00',600,NULL,NULL,1,'weekly','每週2,4','2025-06-06','','',39,'2025-04-28 21:20:48','2025-04-28 21:20:48','e0001'),(49,3,'課程1',14.00,'2025-03-20','00:00:00','14:00:00',600,NULL,NULL,1,'weekly','每週2,4','2025-06-06','','',39,'2025-04-28 21:20:48','2025-04-28 21:20:48','e0001'),(50,3,'課程1',14.00,'2025-03-25','00:00:00','14:00:00',600,NULL,NULL,1,'weekly','每週2,4','2025-06-06','','',39,'2025-04-28 21:20:48','2025-04-28 21:20:48','e0001'),(51,3,'課程1',14.00,'2025-03-27','00:00:00','14:00:00',600,NULL,NULL,1,'weekly','每週2,4','2025-06-06','','',39,'2025-04-28 21:20:48','2025-04-28 21:20:48','e0001'),(54,3,'課程1',2.50,'2025-04-08','12:00:00','14:00:00',600,NULL,NULL,1,'weekly','每週2,4','2025-06-06','','',39,'2025-04-28 21:20:48','2025-04-29 09:58:02','e0001'),(55,3,'課程1',2.00,'2025-04-10','12:00:00','14:00:00',600,NULL,NULL,1,'weekly','每週2,4','2025-06-06','','',39,'2025-04-28 21:20:48','2025-04-28 21:26:20','e0001'),(56,3,'課程1',2.00,'2025-04-15','12:00:00','14:00:00',600,NULL,NULL,1,'weekly','每週2,4','2025-06-06','','',39,'2025-04-28 21:20:48','2025-04-28 21:26:27','e0001'),(57,3,'課程1',2.00,'2025-04-17','12:00:00','14:00:00',600,NULL,NULL,1,'weekly','每週2,4','2025-06-06','','',39,'2025-04-28 21:20:48','2025-04-28 21:26:37','e0001'),(58,3,'課程1',2.00,'2025-04-22','12:00:00','14:00:00',600,NULL,NULL,1,'weekly','每週2,4','2025-06-06','','',39,'2025-04-28 21:20:48','2025-04-28 21:26:48','e0001'),(59,3,'課程1',2.00,'2025-04-24','12:00:00','14:00:00',600,NULL,NULL,1,'weekly','每週2,4','2025-06-06','','',39,'2025-04-28 21:20:48','2025-04-28 21:26:59','e0001'),(60,3,'課程1',2.00,'2025-04-29','12:00:00','14:00:00',600,NULL,NULL,1,'weekly','每週2,4','2025-06-06','','',39,'2025-04-28 21:20:48','2025-04-28 21:27:10','e0001'),(61,3,'課程1',14.00,'2025-05-01','00:00:00','14:00:00',600,NULL,NULL,1,'weekly','每週2,4','2025-06-06','','',39,'2025-04-28 21:20:48','2025-04-28 21:20:48','e0001'),(62,3,'課程1',14.00,'2025-05-06','00:00:00','14:00:00',600,NULL,NULL,1,'weekly','每週2,4','2025-06-06','','',39,'2025-04-28 21:20:48','2025-04-28 21:20:48','e0001'),(63,3,'課程1',14.00,'2025-05-08','00:00:00','14:00:00',600,NULL,NULL,1,'weekly','每週2,4','2025-06-06','','',39,'2025-04-28 21:20:48','2025-04-28 21:20:48','e0001'),(64,3,'課程1',14.00,'2025-05-13','00:00:00','14:00:00',600,NULL,NULL,1,'weekly','每週2,4','2025-06-06','','',39,'2025-04-28 21:20:48','2025-04-28 21:20:48','e0001'),(65,3,'課程1',14.00,'2025-05-15','00:00:00','14:00:00',600,NULL,NULL,1,'weekly','每週2,4','2025-06-06','','',39,'2025-04-28 21:20:48','2025-04-28 21:20:48','e0001'),(66,3,'課程1',14.00,'2025-05-20','00:00:00','14:00:00',600,NULL,NULL,1,'weekly','每週2,4','2025-06-06','','',39,'2025-04-28 21:20:48','2025-04-28 21:20:48','e0001'),(67,3,'課程1',14.00,'2025-05-22','00:00:00','14:00:00',600,NULL,NULL,1,'weekly','每週2,4','2025-06-06','','',39,'2025-04-28 21:20:48','2025-04-28 21:20:48','e0001'),(68,3,'課程1',14.00,'2025-05-27','00:00:00','14:00:00',600,NULL,NULL,1,'weekly','每週2,4','2025-06-06','','',39,'2025-04-28 21:20:48','2025-04-28 21:20:48','e0001'),(69,3,'課程1',14.00,'2025-05-29','00:00:00','14:00:00',600,NULL,NULL,1,'weekly','每週2,4','2025-06-06','','',39,'2025-04-28 21:20:48','2025-04-28 21:20:48','e0001'),(70,3,'課程1',14.00,'2025-06-03','00:00:00','14:00:00',600,NULL,NULL,1,'weekly','每週2,4','2025-06-06','','',39,'2025-04-28 21:20:48','2025-04-28 21:20:48','e0001'),(71,3,'課程1',14.00,'2025-06-05','00:00:00','14:00:00',600,NULL,NULL,1,'weekly','每週2,4','2025-06-06','','',39,'2025-04-28 21:20:48','2025-04-28 21:20:48','e0001'),(72,3,'請程2',1.00,'2025-03-01','08:10:00','09:04:00',600,NULL,NULL,1,'weekly','每週1,3','2025-04-01','第1節','',72,'2025-04-29 13:18:15','2025-04-29 13:18:15','u01'),(73,3,'請程2',1.00,'2025-03-03','08:10:00','09:04:00',600,NULL,NULL,1,'weekly','每週1,3','2025-04-01','第1節','',72,'2025-04-29 13:18:15','2025-04-29 13:18:15','u01'),(74,3,'請程2',1.00,'2025-03-05','08:10:00','09:04:00',600,NULL,NULL,1,'weekly','每週1,3','2025-04-01','第1節','',72,'2025-04-29 13:18:15','2025-04-29 13:18:15','u01'),(75,3,'請程2',1.00,'2025-03-10','08:10:00','09:04:00',600,NULL,NULL,1,'weekly','每週1,3','2025-04-01','第1節','',72,'2025-04-29 13:18:15','2025-04-29 13:18:15','u01'),(76,3,'請程2',1.00,'2025-03-12','08:10:00','09:04:00',600,NULL,NULL,1,'weekly','每週1,3','2025-04-01','第1節','',72,'2025-04-29 13:18:15','2025-04-29 13:18:15','u01'),(77,3,'請程2',1.00,'2025-03-17','08:10:00','09:04:00',600,NULL,NULL,1,'weekly','每週1,3','2025-04-01','第1節','',72,'2025-04-29 13:18:15','2025-04-29 13:18:15','u01'),(78,3,'請程2',1.00,'2025-03-19','08:10:00','09:04:00',600,NULL,NULL,1,'weekly','每週1,3','2025-04-01','第1節','',72,'2025-04-29 13:18:15','2025-04-29 13:18:15','u01'),(79,3,'請程2',1.00,'2025-03-24','08:10:00','09:04:00',600,NULL,NULL,1,'weekly','每週1,3','2025-04-01','第1節','',72,'2025-04-29 13:18:16','2025-04-29 13:18:16','u01'),(80,3,'請程2',1.00,'2025-03-26','08:10:00','09:04:00',600,NULL,NULL,1,'weekly','每週1,3','2025-04-01','第1節','',72,'2025-04-29 13:18:16','2025-04-29 13:18:16','u01'),(81,3,'請程2',1.00,'2025-03-31','08:10:00','09:04:00',600,NULL,NULL,1,'weekly','每週1,3','2025-04-01','第1節','',72,'2025-04-29 13:18:16','2025-04-29 13:18:16','u01'),(82,3,'基礎',3.00,'2025-04-07','09:10:00','12:00:00',450,NULL,NULL,1,'weekly','每週1,3','2025-06-04','第2節','',82,'2025-05-16 17:04:55','2025-05-16 17:04:55','u01'),(83,3,'基礎',3.00,'2025-04-09','09:10:00','12:00:00',450,NULL,NULL,1,'weekly','每週1,3','2025-06-04','第2節','',82,'2025-05-16 17:04:55','2025-05-16 17:04:55','u01'),(84,3,'基礎',3.00,'2025-04-14','09:10:00','12:00:00',450,NULL,NULL,1,'weekly','每週1,3','2025-06-04','第2節','',82,'2025-05-16 17:04:56','2025-05-16 17:04:56','u01'),(85,3,'基礎',3.00,'2025-04-16','09:10:00','12:00:00',450,NULL,NULL,1,'weekly','每週1,3','2025-06-04','第2節','',82,'2025-05-16 17:04:56','2025-05-16 17:04:56','u01'),(86,3,'基礎',3.00,'2025-04-21','09:10:00','12:00:00',450,NULL,NULL,1,'weekly','每週1,3','2025-06-04','第2節','',82,'2025-05-16 17:04:56','2025-05-16 17:04:56','u01'),(87,3,'基礎',3.00,'2025-04-23','09:10:00','12:00:00',450,NULL,NULL,1,'weekly','每週1,3','2025-06-04','第2節','',82,'2025-05-16 17:04:56','2025-05-16 17:04:56','u01'),(88,3,'基礎',3.00,'2025-04-28','09:10:00','12:00:00',450,NULL,NULL,1,'weekly','每週1,3','2025-06-04','第2節','',82,'2025-05-16 17:04:56','2025-05-16 17:04:56','u01'),(89,3,'基礎',3.00,'2025-04-30','09:10:00','12:00:00',450,NULL,NULL,1,'weekly','每週1,3','2025-06-04','第2節','',82,'2025-05-16 17:04:56','2025-05-16 17:04:56','u01'),(90,3,'基礎',3.00,'2025-05-05','09:10:00','12:00:00',450,NULL,NULL,1,'weekly','每週1,3','2025-06-04','第2節','',82,'2025-05-16 17:04:56','2025-05-16 17:04:56','u01'),(91,3,'基礎',3.00,'2025-05-07','09:10:00','12:00:00',450,NULL,NULL,1,'weekly','每週1,3','2025-06-04','第2節','',82,'2025-05-16 17:04:56','2025-05-16 17:04:56','u01'),(92,3,'基礎',3.00,'2025-05-12','09:10:00','12:00:00',450,NULL,NULL,1,'weekly','每週1,3','2025-06-04','第2節','',82,'2025-05-16 17:04:56','2025-05-16 17:04:56','u01'),(93,3,'基礎',3.00,'2025-05-14','09:10:00','12:00:00',450,NULL,NULL,1,'weekly','每週1,3','2025-06-04','第2節','',82,'2025-05-16 17:04:56','2025-05-16 17:04:56','u01'),(94,3,'基礎',3.00,'2025-05-19','09:10:00','12:00:00',450,NULL,NULL,1,'weekly','每週1,3','2025-06-04','第2節','',82,'2025-05-16 17:04:56','2025-05-16 17:04:56','u01'),(95,3,'基礎',3.00,'2025-05-21','09:10:00','12:00:00',450,NULL,NULL,1,'weekly','每週1,3','2025-06-04','第2節','',82,'2025-05-16 17:04:56','2025-05-16 17:04:56','u01'),(96,3,'基礎',3.00,'2025-05-26','09:10:00','12:00:00',450,NULL,NULL,1,'weekly','每週1,3','2025-06-04','第2節','',82,'2025-05-16 17:04:56','2025-05-16 17:04:56','u01'),(97,3,'基礎',3.00,'2025-05-28','09:10:00','12:00:00',450,NULL,NULL,1,'weekly','每週1,3','2025-06-04','第2節','',82,'2025-05-16 17:04:56','2025-05-16 17:04:56','u01'),(98,3,'基礎',3.00,'2025-06-02','09:10:00','12:00:00',450,NULL,NULL,1,'weekly','每週1,3','2025-06-04','第2節','',82,'2025-05-16 17:04:56','2025-05-16 17:04:56','u01'),(99,3,'基礎',3.00,'2025-06-04','09:10:00','12:00:00',450,NULL,NULL,1,'weekly','每週1,3','2025-06-04','第2節','',82,'2025-05-16 17:04:56','2025-05-16 17:04:56','u01'),(100,3,'入門華語二五',2.00,'2025-04-01','13:10:00','15:00:00',520,NULL,NULL,1,'weekly','每週2,5','2025-06-20','第5節','',100,'2025-05-16 17:07:31','2025-05-16 17:07:31','u01'),(101,3,'入門華語二五',2.00,'2025-04-04','13:10:00','15:00:00',520,NULL,NULL,1,'weekly','每週2,5','2025-06-20','第5節','',100,'2025-05-16 17:07:31','2025-05-16 17:07:31','u01'),(102,3,'入門華語二五',2.00,'2025-04-08','13:10:00','15:00:00',520,NULL,NULL,1,'weekly','每週2,5','2025-06-20','第5節','',100,'2025-05-16 17:07:31','2025-05-16 17:07:31','u01'),(103,3,'入門華語二五',2.00,'2025-04-11','13:10:00','15:00:00',520,NULL,NULL,1,'weekly','每週2,5','2025-06-20','第5節','',100,'2025-05-16 17:07:31','2025-05-16 17:07:31','u01'),(104,3,'入門華語二五',2.00,'2025-04-15','13:10:00','15:00:00',520,NULL,NULL,1,'weekly','每週2,5','2025-06-20','第5節','',100,'2025-05-16 17:07:31','2025-05-16 17:07:31','u01'),(105,3,'入門華語二五',2.00,'2025-04-18','13:10:00','15:00:00',520,NULL,NULL,1,'weekly','每週2,5','2025-06-20','第5節','',100,'2025-05-16 17:07:31','2025-05-16 17:07:31','u01'),(106,3,'入門華語二五',2.00,'2025-04-22','13:10:00','15:00:00',520,NULL,NULL,1,'weekly','每週2,5','2025-06-20','第5節','',100,'2025-05-16 17:07:31','2025-05-16 17:07:31','u01'),(107,3,'入門華語二五',2.00,'2025-04-25','13:10:00','15:00:00',520,NULL,NULL,1,'weekly','每週2,5','2025-06-20','第5節','',100,'2025-05-16 17:07:31','2025-05-16 17:07:31','u01'),(108,3,'入門華語二五',2.00,'2025-04-29','13:10:00','15:00:00',520,NULL,NULL,1,'weekly','每週2,5','2025-06-20','第5節','',100,'2025-05-16 17:07:31','2025-05-16 17:07:31','u01'),(109,3,'入門華語二五',2.00,'2025-05-02','13:10:00','15:00:00',520,NULL,NULL,1,'weekly','每週2,5','2025-06-20','第5節','',100,'2025-05-16 17:07:31','2025-05-16 17:07:31','u01'),(110,3,'入門華語二五',2.00,'2025-05-06','13:10:00','15:00:00',520,NULL,NULL,1,'weekly','每週2,5','2025-06-20','第5節','',100,'2025-05-16 17:07:31','2025-05-16 17:07:31','u01'),(111,3,'入門華語二五',2.00,'2025-05-09','13:10:00','15:00:00',520,NULL,NULL,1,'weekly','每週2,5','2025-06-20','第5節','',100,'2025-05-16 17:07:31','2025-05-16 17:07:31','u01'),(112,3,'入門華語二五',2.00,'2025-05-13','13:10:00','15:00:00',520,NULL,NULL,1,'weekly','每週2,5','2025-06-20','第5節','',100,'2025-05-16 17:07:31','2025-05-16 17:07:31','u01'),(113,3,'入門華語二五',2.00,'2025-05-16','13:10:00','15:00:00',520,NULL,NULL,1,'weekly','每週2,5','2025-06-20','第5節','',100,'2025-05-16 17:07:31','2025-05-16 17:07:31','u01'),(114,3,'入門華語二五',2.00,'2025-05-20','13:10:00','15:00:00',520,NULL,NULL,1,'weekly','每週2,5','2025-06-20','第5節','',100,'2025-05-16 17:07:31','2025-05-16 17:07:31','u01'),(115,3,'入門華語二五',2.00,'2025-05-23','13:10:00','15:00:00',520,NULL,NULL,1,'weekly','每週2,5','2025-06-20','第5節','',100,'2025-05-16 17:07:32','2025-05-16 17:07:32','u01'),(116,3,'入門華語二五',2.00,'2025-05-27','13:10:00','15:00:00',520,NULL,NULL,1,'weekly','每週2,5','2025-06-20','第5節','',100,'2025-05-16 17:07:32','2025-05-16 17:07:32','u01'),(117,3,'入門華語二五',2.00,'2025-05-30','13:10:00','15:00:00',520,NULL,NULL,1,'weekly','每週2,5','2025-06-20','第5節','',100,'2025-05-16 17:07:32','2025-05-16 17:07:32','u01'),(118,3,'入門華語二五',2.00,'2025-06-03','13:10:00','15:00:00',520,NULL,NULL,1,'weekly','每週2,5','2025-06-20','第5節','',100,'2025-05-16 17:07:32','2025-05-16 17:07:32','u01'),(119,3,'入門華語二五',2.00,'2025-06-06','13:10:00','15:00:00',520,NULL,NULL,1,'weekly','每週2,5','2025-06-20','第5節','',100,'2025-05-16 17:07:32','2025-05-16 17:07:32','u01'),(120,3,'入門華語二五',2.00,'2025-06-10','13:10:00','15:00:00',520,NULL,NULL,1,'weekly','每週2,5','2025-06-20','第5節','',100,'2025-05-16 17:07:32','2025-05-16 17:07:32','u01'),(121,3,'入門華語二五',2.00,'2025-06-13','13:10:00','15:00:00',520,NULL,NULL,1,'weekly','每週2,5','2025-06-20','第5節','',100,'2025-05-16 17:07:32','2025-05-16 17:07:32','u01'),(122,3,'入門華語二五',2.00,'2025-06-17','13:10:00','15:00:00',520,NULL,NULL,1,'weekly','每週2,5','2025-06-20','第5節','',100,'2025-05-16 17:07:32','2025-05-16 17:07:32','u01'),(123,3,'入門華語二五',2.00,'2025-06-20','13:10:00','15:00:00',520,NULL,NULL,1,'weekly','每週2,5','2025-06-20','第5節','',100,'2025-05-16 17:07:32','2025-05-16 17:07:32','u01'),(124,3,'入門華語一四',2.00,'2025-04-07','15:10:00','16:00:00',490,NULL,NULL,1,'weekly','每週1,4','2025-06-19','第7節','',124,'2025-05-16 17:09:10','2025-05-16 17:09:10','u01'),(125,3,'入門華語一四',2.00,'2025-04-10','15:10:00','16:00:00',490,NULL,NULL,1,'weekly','每週1,4','2025-06-19','第7節','',124,'2025-05-16 17:09:10','2025-05-16 17:09:10','u01'),(126,3,'入門華語一四',2.00,'2025-04-14','15:10:00','16:00:00',490,NULL,NULL,1,'weekly','每週1,4','2025-06-19','第7節','',124,'2025-05-16 17:09:11','2025-05-16 17:09:11','u01'),(127,3,'入門華語一四',2.00,'2025-04-17','15:10:00','16:00:00',490,NULL,NULL,1,'weekly','每週1,4','2025-06-19','第7節','',124,'2025-05-16 17:09:11','2025-05-16 17:09:11','u01'),(128,3,'入門華語一四',2.00,'2025-04-21','15:10:00','16:00:00',490,NULL,NULL,1,'weekly','每週1,4','2025-06-19','第7節','',124,'2025-05-16 17:09:11','2025-05-16 17:09:11','u01'),(129,3,'入門華語一四',2.00,'2025-04-24','15:10:00','16:00:00',490,NULL,NULL,1,'weekly','每週1,4','2025-06-19','第7節','',124,'2025-05-16 17:09:11','2025-05-16 17:09:11','u01'),(130,3,'入門華語一四',2.00,'2025-04-28','15:10:00','16:00:00',490,NULL,NULL,1,'weekly','每週1,4','2025-06-19','第7節','',124,'2025-05-16 17:09:11','2025-05-16 17:09:11','u01'),(131,3,'入門華語一四',2.00,'2025-05-01','15:10:00','16:00:00',490,NULL,NULL,1,'weekly','每週1,4','2025-06-19','第7節','',124,'2025-05-16 17:09:11','2025-05-16 17:09:11','u01'),(132,3,'入門華語一四',2.00,'2025-05-05','15:10:00','16:00:00',490,NULL,NULL,1,'weekly','每週1,4','2025-06-19','第7節','',124,'2025-05-16 17:09:11','2025-05-16 17:09:11','u01'),(133,3,'入門華語一四',2.00,'2025-05-08','15:10:00','16:00:00',490,NULL,NULL,1,'weekly','每週1,4','2025-06-19','第7節','',124,'2025-05-16 17:09:11','2025-05-16 17:09:11','u01'),(134,3,'入門華語一四',2.00,'2025-05-12','15:10:00','16:00:00',490,NULL,NULL,1,'weekly','每週1,4','2025-06-19','第7節','',124,'2025-05-16 17:09:11','2025-05-16 17:09:11','u01'),(135,3,'入門華語一四',2.00,'2025-05-15','15:10:00','16:00:00',490,NULL,NULL,1,'weekly','每週1,4','2025-06-19','第7節','',124,'2025-05-16 17:09:11','2025-05-16 17:09:11','u01'),(136,3,'入門華語一四',2.00,'2025-05-19','15:10:00','16:00:00',490,NULL,NULL,1,'weekly','每週1,4','2025-06-19','第7節','',124,'2025-05-16 17:09:11','2025-05-16 17:09:11','u01'),(137,3,'入門華語一四',2.00,'2025-05-22','15:10:00','16:00:00',490,NULL,NULL,1,'weekly','每週1,4','2025-06-19','第7節','',124,'2025-05-16 17:09:11','2025-05-16 17:09:11','u01'),(138,3,'入門華語一四',2.00,'2025-05-26','15:10:00','16:00:00',490,NULL,NULL,1,'weekly','每週1,4','2025-06-19','第7節','',124,'2025-05-16 17:09:11','2025-05-16 17:09:11','u01'),(139,3,'入門華語一四',2.00,'2025-05-29','15:10:00','16:00:00',490,NULL,NULL,1,'weekly','每週1,4','2025-06-19','第7節','',124,'2025-05-16 17:09:11','2025-05-16 17:09:11','u01'),(140,3,'入門華語一四',2.00,'2025-06-02','15:10:00','16:00:00',490,NULL,NULL,1,'weekly','每週1,4','2025-06-19','第7節','',124,'2025-05-16 17:09:11','2025-05-16 17:09:11','u01'),(141,3,'入門華語一四',2.00,'2025-06-05','15:10:00','16:00:00',490,NULL,NULL,1,'weekly','每週1,4','2025-06-19','第7節','',124,'2025-05-16 17:09:11','2025-05-16 17:09:11','u01'),(142,3,'入門華語一四',2.00,'2025-06-09','15:10:00','16:00:00',490,NULL,NULL,1,'weekly','每週1,4','2025-06-19','第7節','',124,'2025-05-16 17:09:11','2025-05-16 17:09:11','u01'),(143,3,'入門華語一四',2.00,'2025-06-12','15:10:00','16:00:00',490,NULL,NULL,1,'weekly','每週1,4','2025-06-19','第7節','',124,'2025-05-16 17:09:11','2025-05-16 17:09:11','u01'),(144,3,'入門華語一四',2.00,'2025-06-16','15:10:00','16:00:00',490,NULL,NULL,1,'weekly','每週1,4','2025-06-19','第7節','',124,'2025-05-16 17:09:11','2025-05-16 17:09:11','u01'),(145,3,'入門華語一四',2.00,'2025-06-19','15:10:00','16:00:00',490,NULL,NULL,1,'weekly','每週1,4','2025-06-19','第7節','',124,'2025-05-16 17:09:11','2025-05-16 17:09:11','u01'),(146,1,'初級一',3.00,'2025-04-01',NULL,NULL,450,NULL,NULL,1,'weekly','每週2,5','2025-06-20','','',146,'2025-05-16 17:15:58','2025-05-16 17:15:58','u01'),(147,1,'初級一',3.00,'2025-04-04',NULL,NULL,450,NULL,NULL,1,'weekly','每週2,5','2025-06-20','','',146,'2025-05-16 17:15:58','2025-05-16 17:15:58','u01'),(148,1,'初級一',3.00,'2025-04-08',NULL,NULL,450,NULL,NULL,1,'weekly','每週2,5','2025-06-20','','',146,'2025-05-16 17:15:58','2025-05-16 17:15:58','u01'),(149,1,'初級一',3.00,'2025-04-11',NULL,NULL,450,NULL,NULL,1,'weekly','每週2,5','2025-06-20','','',146,'2025-05-16 17:15:58','2025-05-16 17:15:58','u01'),(150,1,'初級一',3.00,'2025-04-15',NULL,NULL,450,NULL,NULL,1,'weekly','每週2,5','2025-06-20','','',146,'2025-05-16 17:15:58','2025-05-16 17:15:58','u01'),(151,1,'初級一',3.00,'2025-04-18',NULL,NULL,450,NULL,NULL,1,'weekly','每週2,5','2025-06-20','','',146,'2025-05-16 17:15:58','2025-05-16 17:15:58','u01'),(152,1,'初級一',3.00,'2025-04-22',NULL,NULL,450,NULL,NULL,1,'weekly','每週2,5','2025-06-20','','',146,'2025-05-16 17:15:59','2025-05-16 17:15:59','u01'),(153,1,'初級一',3.00,'2025-04-25',NULL,NULL,450,NULL,NULL,1,'weekly','每週2,5','2025-06-20','','',146,'2025-05-16 17:15:59','2025-05-16 17:15:59','u01'),(154,1,'初級一',3.00,'2025-04-29',NULL,NULL,450,NULL,NULL,1,'weekly','每週2,5','2025-06-20','','',146,'2025-05-16 17:15:59','2025-05-16 17:15:59','u01'),(155,1,'初級一',3.00,'2025-05-02',NULL,NULL,450,NULL,NULL,1,'weekly','每週2,5','2025-06-20','','',146,'2025-05-16 17:15:59','2025-05-16 17:15:59','u01'),(156,1,'初級一',3.00,'2025-05-06',NULL,NULL,450,NULL,NULL,1,'weekly','每週2,5','2025-06-20','','',146,'2025-05-16 17:15:59','2025-05-16 17:15:59','u01'),(157,1,'初級一',3.00,'2025-05-09',NULL,NULL,450,NULL,NULL,1,'weekly','每週2,5','2025-06-20','','',146,'2025-05-16 17:15:59','2025-05-16 17:15:59','u01'),(158,1,'初級一',3.00,'2025-05-13',NULL,NULL,450,NULL,NULL,1,'weekly','每週2,5','2025-06-20','','',146,'2025-05-16 17:15:59','2025-05-16 17:15:59','u01'),(159,1,'初級一',3.00,'2025-05-16',NULL,NULL,450,NULL,NULL,1,'weekly','每週2,5','2025-06-20','','',146,'2025-05-16 17:15:59','2025-05-16 17:15:59','u01'),(160,1,'初級一',3.00,'2025-05-20',NULL,NULL,450,NULL,NULL,1,'weekly','每週2,5','2025-06-20','','',146,'2025-05-16 17:15:59','2025-05-16 17:15:59','u01'),(161,1,'初級一',3.00,'2025-05-23',NULL,NULL,450,NULL,NULL,1,'weekly','每週2,5','2025-06-20','','',146,'2025-05-16 17:15:59','2025-05-16 17:15:59','u01'),(162,1,'初級一',3.00,'2025-05-27',NULL,NULL,450,NULL,NULL,1,'weekly','每週2,5','2025-06-20','','',146,'2025-05-16 17:15:59','2025-05-16 17:15:59','u01'),(163,1,'初級一',3.00,'2025-05-30',NULL,NULL,450,NULL,NULL,1,'weekly','每週2,5','2025-06-20','','',146,'2025-05-16 17:15:59','2025-05-16 17:15:59','u01'),(164,1,'初級一',3.00,'2025-06-03',NULL,NULL,450,NULL,NULL,1,'weekly','每週2,5','2025-06-20','','',146,'2025-05-16 17:15:59','2025-05-16 17:15:59','u01'),(165,1,'初級一',3.00,'2025-06-06',NULL,NULL,450,NULL,NULL,1,'weekly','每週2,5','2025-06-20','','',146,'2025-05-16 17:15:59','2025-05-16 17:15:59','u01'),(166,1,'初級一',3.00,'2025-06-10',NULL,NULL,450,NULL,NULL,1,'weekly','每週2,5','2025-06-20','','',146,'2025-05-16 17:15:59','2025-05-16 17:15:59','u01'),(167,1,'初級一',3.00,'2025-06-13',NULL,NULL,450,NULL,NULL,1,'weekly','每週2,5','2025-06-20','','',146,'2025-05-16 17:15:59','2025-05-16 17:15:59','u01'),(168,1,'初級一',3.00,'2025-06-17',NULL,NULL,450,NULL,NULL,1,'weekly','每週2,5','2025-06-20','','',146,'2025-05-16 17:15:59','2025-05-16 17:15:59','u01'),(169,1,'初級一',3.00,'2025-06-20',NULL,NULL,450,NULL,NULL,1,'weekly','每週2,5','2025-06-20','','',146,'2025-05-16 17:15:59','2025-05-16 17:15:59','u01'),(170,1,'初級會話',3.00,'2025-04-09',NULL,NULL,480,NULL,NULL,1,'weekly','每週3,5','2025-06-27','','',170,'2025-05-16 17:17:39','2025-05-16 17:17:39','u01'),(171,1,'初級會話',3.00,'2025-04-11',NULL,NULL,480,NULL,NULL,1,'weekly','每週3,5','2025-06-27','','',170,'2025-05-16 17:17:39','2025-05-16 17:17:39','u01'),(172,1,'初級會話',3.00,'2025-04-16',NULL,NULL,480,NULL,NULL,1,'weekly','每週3,5','2025-06-27','','',170,'2025-05-16 17:17:39','2025-05-16 17:17:39','u01'),(173,1,'初級會話',3.00,'2025-04-18',NULL,NULL,480,NULL,NULL,1,'weekly','每週3,5','2025-06-27','','',170,'2025-05-16 17:17:39','2025-05-16 17:17:39','u01'),(174,1,'初級會話',3.00,'2025-04-23',NULL,NULL,480,NULL,NULL,1,'weekly','每週3,5','2025-06-27','','',170,'2025-05-16 17:17:39','2025-05-16 17:17:39','u01'),(175,1,'初級會話',3.00,'2025-04-25',NULL,NULL,480,NULL,NULL,1,'weekly','每週3,5','2025-06-27','','',170,'2025-05-16 17:17:39','2025-05-16 17:17:39','u01'),(176,1,'初級會話',3.00,'2025-04-30',NULL,NULL,480,NULL,NULL,1,'weekly','每週3,5','2025-06-27','','',170,'2025-05-16 17:17:39','2025-05-16 17:17:39','u01'),(177,1,'初級會話',3.00,'2025-05-02',NULL,NULL,480,NULL,NULL,1,'weekly','每週3,5','2025-06-27','','',170,'2025-05-16 17:17:39','2025-05-16 17:17:39','u01'),(178,1,'初級會話',3.00,'2025-05-07',NULL,NULL,480,NULL,NULL,1,'weekly','每週3,5','2025-06-27','','',170,'2025-05-16 17:17:39','2025-05-16 17:17:39','u01'),(179,1,'初級會話',3.00,'2025-05-09',NULL,NULL,480,NULL,NULL,1,'weekly','每週3,5','2025-06-27','','',170,'2025-05-16 17:17:40','2025-05-16 17:17:40','u01'),(180,1,'初級會話',3.00,'2025-05-14',NULL,NULL,480,NULL,NULL,1,'weekly','每週3,5','2025-06-27','','',170,'2025-05-16 17:17:40','2025-05-16 17:17:40','u01'),(181,1,'初級會話',3.00,'2025-05-16',NULL,NULL,480,NULL,NULL,1,'weekly','每週3,5','2025-06-27','','',170,'2025-05-16 17:17:40','2025-05-16 17:17:40','u01'),(182,1,'初級會話',3.00,'2025-05-21',NULL,NULL,480,NULL,NULL,1,'weekly','每週3,5','2025-06-27','','',170,'2025-05-16 17:17:40','2025-05-16 17:17:40','u01'),(183,1,'初級會話',3.00,'2025-05-23',NULL,NULL,480,NULL,NULL,1,'weekly','每週3,5','2025-06-27','','',170,'2025-05-16 17:17:40','2025-05-16 17:17:40','u01'),(184,1,'初級會話',3.00,'2025-05-28',NULL,NULL,480,NULL,NULL,1,'weekly','每週3,5','2025-06-27','','',170,'2025-05-16 17:17:40','2025-05-16 17:17:40','u01'),(185,1,'初級會話',3.00,'2025-05-30',NULL,NULL,480,NULL,NULL,1,'weekly','每週3,5','2025-06-27','','',170,'2025-05-16 17:17:40','2025-05-16 17:17:40','u01'),(186,1,'初級會話',3.00,'2025-06-04',NULL,NULL,480,NULL,NULL,1,'weekly','每週3,5','2025-06-27','','',170,'2025-05-16 17:17:40','2025-05-16 17:17:40','u01'),(187,1,'初級會話',3.00,'2025-06-06',NULL,NULL,480,NULL,NULL,1,'weekly','每週3,5','2025-06-27','','',170,'2025-05-16 17:17:40','2025-05-16 17:17:40','u01'),(188,1,'初級會話',3.00,'2025-06-11',NULL,NULL,480,NULL,NULL,1,'weekly','每週3,5','2025-06-27','','',170,'2025-05-16 17:17:40','2025-05-16 17:17:40','u01'),(189,1,'初級會話',3.00,'2025-06-13',NULL,NULL,480,NULL,NULL,1,'weekly','每週3,5','2025-06-27','','',170,'2025-05-16 17:17:40','2025-05-16 17:17:40','u01'),(190,1,'初級會話',3.00,'2025-06-18',NULL,NULL,480,NULL,NULL,1,'weekly','每週3,5','2025-06-27','','',170,'2025-05-16 17:17:40','2025-05-16 17:17:40','u01'),(191,1,'初級會話',3.00,'2025-06-20',NULL,NULL,480,NULL,NULL,1,'weekly','每週3,5','2025-06-27','','',170,'2025-05-16 17:17:40','2025-05-16 17:17:40','u01'),(192,1,'初級會話',3.00,'2025-06-25',NULL,NULL,480,NULL,NULL,1,'weekly','每週3,5','2025-06-27','','',170,'2025-05-16 17:17:40','2025-05-16 17:17:40','u01'),(193,1,'初級會話',3.00,'2025-06-27',NULL,NULL,480,NULL,NULL,1,'weekly','每週3,5','2025-06-27','','',170,'2025-05-16 17:17:40','2025-05-16 17:17:40','u01'),(194,1,'初級華語一四',2.00,'2025-04-07',NULL,NULL,490,NULL,NULL,1,'weekly','每週1,4','2025-06-26','','',194,'2025-05-16 17:18:26','2025-05-16 17:18:26','u01'),(195,1,'初級華語一四',2.00,'2025-04-10',NULL,NULL,490,NULL,NULL,1,'weekly','每週1,4','2025-06-26','','',194,'2025-05-16 17:18:26','2025-05-16 17:18:26','u01'),(196,1,'初級華語一四',2.00,'2025-04-14',NULL,NULL,490,NULL,NULL,1,'weekly','每週1,4','2025-06-26','','',194,'2025-05-16 17:18:26','2025-05-16 17:18:26','u01'),(197,1,'初級華語一四',2.00,'2025-04-17',NULL,NULL,490,NULL,NULL,1,'weekly','每週1,4','2025-06-26','','',194,'2025-05-16 17:18:26','2025-05-16 17:18:26','u01'),(198,1,'初級華語一四',2.00,'2025-04-21',NULL,NULL,490,NULL,NULL,1,'weekly','每週1,4','2025-06-26','','',194,'2025-05-16 17:18:26','2025-05-16 17:18:26','u01'),(199,1,'初級華語一四',2.00,'2025-04-24',NULL,NULL,490,NULL,NULL,1,'weekly','每週1,4','2025-06-26','','',194,'2025-05-16 17:18:26','2025-05-16 17:18:26','u01'),(200,1,'初級華語一四',2.00,'2025-04-28',NULL,NULL,490,NULL,NULL,1,'weekly','每週1,4','2025-06-26','','',194,'2025-05-16 17:18:26','2025-05-16 17:18:26','u01'),(201,1,'初級華語一四',2.00,'2025-05-01',NULL,NULL,490,NULL,NULL,1,'weekly','每週1,4','2025-06-26','','',194,'2025-05-16 17:18:26','2025-05-16 17:18:26','u01'),(202,1,'初級華語一四',2.00,'2025-05-05',NULL,NULL,490,NULL,NULL,1,'weekly','每週1,4','2025-06-26','','',194,'2025-05-16 17:18:26','2025-05-16 17:18:26','u01'),(203,1,'初級華語一四',2.00,'2025-05-08',NULL,NULL,490,NULL,NULL,1,'weekly','每週1,4','2025-06-26','','',194,'2025-05-16 17:18:26','2025-05-16 17:18:26','u01'),(204,1,'初級華語一四',2.00,'2025-05-12',NULL,NULL,490,NULL,NULL,1,'weekly','每週1,4','2025-06-26','','',194,'2025-05-16 17:18:26','2025-05-16 17:18:26','u01'),(205,1,'初級華語一四',2.00,'2025-05-15',NULL,NULL,490,NULL,NULL,1,'weekly','每週1,4','2025-06-26','','',194,'2025-05-16 17:18:26','2025-05-16 17:18:26','u01'),(206,1,'初級華語一四',2.00,'2025-05-19',NULL,NULL,490,NULL,NULL,1,'weekly','每週1,4','2025-06-26','','',194,'2025-05-16 17:18:26','2025-05-16 17:18:26','u01'),(207,1,'初級華語一四',2.00,'2025-05-22',NULL,NULL,490,NULL,NULL,1,'weekly','每週1,4','2025-06-26','','',194,'2025-05-16 17:18:26','2025-05-16 17:18:26','u01'),(208,1,'初級華語一四',2.00,'2025-05-26',NULL,NULL,490,NULL,NULL,1,'weekly','每週1,4','2025-06-26','','',194,'2025-05-16 17:18:26','2025-05-16 17:18:26','u01'),(209,1,'初級華語一四',2.00,'2025-05-29',NULL,NULL,490,NULL,NULL,1,'weekly','每週1,4','2025-06-26','','',194,'2025-05-16 17:18:26','2025-05-16 17:18:26','u01'),(210,1,'初級華語一四',2.00,'2025-06-02',NULL,NULL,490,NULL,NULL,1,'weekly','每週1,4','2025-06-26','','',194,'2025-05-16 17:18:26','2025-05-16 17:18:26','u01'),(211,1,'初級華語一四',2.00,'2025-06-05',NULL,NULL,490,NULL,NULL,1,'weekly','每週1,4','2025-06-26','','',194,'2025-05-16 17:18:26','2025-05-16 17:18:26','u01'),(212,1,'初級華語一四',2.00,'2025-06-09',NULL,NULL,490,NULL,NULL,1,'weekly','每週1,4','2025-06-26','','',194,'2025-05-16 17:18:27','2025-05-16 17:18:27','u01'),(213,1,'初級華語一四',2.00,'2025-06-12',NULL,NULL,490,NULL,NULL,1,'weekly','每週1,4','2025-06-26','','',194,'2025-05-16 17:18:27','2025-05-16 17:18:27','u01'),(214,1,'初級華語一四',2.00,'2025-06-16',NULL,NULL,490,NULL,NULL,1,'weekly','每週1,4','2025-06-26','','',194,'2025-05-16 17:18:27','2025-05-16 17:18:27','u01'),(215,1,'初級華語一四',2.00,'2025-06-19',NULL,NULL,490,NULL,NULL,1,'weekly','每週1,4','2025-06-26','','',194,'2025-05-16 17:18:27','2025-05-16 17:18:27','u01'),(216,1,'初級華語一四',2.00,'2025-06-23',NULL,NULL,490,NULL,NULL,1,'weekly','每週1,4','2025-06-26','','',194,'2025-05-16 17:18:27','2025-05-16 17:18:27','u01'),(217,1,'初級華語一四',2.00,'2025-06-26',NULL,NULL,490,NULL,NULL,1,'weekly','每週1,4','2025-06-26','','',194,'2025-05-16 17:18:27','2025-05-16 17:18:27','u01'),(218,1,'初級華語二五',2.00,'2025-04-08',NULL,NULL,520,NULL,NULL,1,'weekly','每週2,5','2025-06-27','','',218,'2025-05-16 17:19:14','2025-05-16 17:19:14','u01'),(219,1,'初級華語二五',2.00,'2025-04-11',NULL,NULL,520,NULL,NULL,1,'weekly','每週2,5','2025-06-27','','',218,'2025-05-16 17:19:14','2025-05-16 17:19:14','u01'),(220,1,'初級華語二五',2.00,'2025-04-15',NULL,NULL,520,NULL,NULL,1,'weekly','每週2,5','2025-06-27','','',218,'2025-05-16 17:19:14','2025-05-16 17:19:14','u01'),(221,1,'初級華語二五',2.00,'2025-04-18',NULL,NULL,520,NULL,NULL,1,'weekly','每週2,5','2025-06-27','','',218,'2025-05-16 17:19:14','2025-05-16 17:19:14','u01'),(222,1,'初級華語二五',2.00,'2025-04-22',NULL,NULL,520,NULL,NULL,1,'weekly','每週2,5','2025-06-27','','',218,'2025-05-16 17:19:14','2025-05-16 17:19:14','u01'),(223,1,'初級華語二五',2.00,'2025-04-25',NULL,NULL,520,NULL,NULL,1,'weekly','每週2,5','2025-06-27','','',218,'2025-05-16 17:19:14','2025-05-16 17:19:14','u01'),(224,1,'初級華語二五',2.00,'2025-04-29',NULL,NULL,520,NULL,NULL,1,'weekly','每週2,5','2025-06-27','','',218,'2025-05-16 17:19:14','2025-05-16 17:19:14','u01'),(225,1,'初級華語二五',2.00,'2025-05-02',NULL,NULL,520,NULL,NULL,1,'weekly','每週2,5','2025-06-27','','',218,'2025-05-16 17:19:14','2025-05-16 17:19:14','u01'),(226,1,'初級華語二五',2.00,'2025-05-06',NULL,NULL,520,NULL,NULL,1,'weekly','每週2,5','2025-06-27','','',218,'2025-05-16 17:19:14','2025-05-16 17:19:14','u01'),(227,1,'初級華語二五',2.00,'2025-05-09',NULL,NULL,520,NULL,NULL,1,'weekly','每週2,5','2025-06-27','','',218,'2025-05-16 17:19:14','2025-05-16 17:19:14','u01'),(228,1,'初級華語二五',2.00,'2025-05-13',NULL,NULL,520,NULL,NULL,1,'weekly','每週2,5','2025-06-27','','',218,'2025-05-16 17:19:14','2025-05-16 17:19:14','u01'),(229,1,'初級華語二五',2.00,'2025-05-16',NULL,NULL,520,NULL,NULL,1,'weekly','每週2,5','2025-06-27','','',218,'2025-05-16 17:19:14','2025-05-16 17:19:14','u01'),(230,1,'初級華語二五',2.00,'2025-05-20',NULL,NULL,520,NULL,NULL,1,'weekly','每週2,5','2025-06-27','','',218,'2025-05-16 17:19:14','2025-05-16 17:19:14','u01'),(231,1,'初級華語二五',2.00,'2025-05-23',NULL,NULL,520,NULL,NULL,1,'weekly','每週2,5','2025-06-27','','',218,'2025-05-16 17:19:14','2025-05-16 17:19:14','u01'),(232,1,'初級華語二五',2.00,'2025-05-27',NULL,NULL,520,NULL,NULL,1,'weekly','每週2,5','2025-06-27','','',218,'2025-05-16 17:19:14','2025-05-16 17:19:14','u01'),(233,1,'初級華語二五',2.00,'2025-05-30',NULL,NULL,520,NULL,NULL,1,'weekly','每週2,5','2025-06-27','','',218,'2025-05-16 17:19:14','2025-05-16 17:19:14','u01'),(234,1,'初級華語二五',2.00,'2025-06-03',NULL,NULL,520,NULL,NULL,1,'weekly','每週2,5','2025-06-27','','',218,'2025-05-16 17:19:14','2025-05-16 17:19:14','u01'),(235,1,'初級華語二五',2.00,'2025-06-06',NULL,NULL,520,NULL,NULL,1,'weekly','每週2,5','2025-06-27','','',218,'2025-05-16 17:19:15','2025-05-16 17:19:15','u01'),(236,1,'初級華語二五',2.00,'2025-06-10',NULL,NULL,520,NULL,NULL,1,'weekly','每週2,5','2025-06-27','','',218,'2025-05-16 17:19:15','2025-05-16 17:19:15','u01'),(237,1,'初級華語二五',2.00,'2025-06-13',NULL,NULL,520,NULL,NULL,1,'weekly','每週2,5','2025-06-27','','',218,'2025-05-16 17:19:15','2025-05-16 17:19:15','u01'),(238,1,'初級華語二五',2.00,'2025-06-17',NULL,NULL,520,NULL,NULL,1,'weekly','每週2,5','2025-06-27','','',218,'2025-05-16 17:19:15','2025-05-16 17:19:15','u01'),(239,1,'初級華語二五',2.00,'2025-06-20',NULL,NULL,520,NULL,NULL,1,'weekly','每週2,5','2025-06-27','','',218,'2025-05-16 17:19:15','2025-05-16 17:19:15','u01'),(240,1,'初級華語二五',2.00,'2025-06-24',NULL,NULL,520,NULL,NULL,1,'weekly','每週2,5','2025-06-27','','',218,'2025-05-16 17:19:15','2025-05-16 17:19:15','u01'),(241,1,'初級華語二五',2.00,'2025-06-27',NULL,NULL,520,NULL,NULL,1,'weekly','每週2,5','2025-06-27','','',218,'2025-05-16 17:19:15','2025-05-16 17:19:15','u01'),(242,1,'初級華語二四',2.00,'2025-04-08',NULL,NULL,490,NULL,NULL,1,'weekly','每週2,4','2025-06-26','','',242,'2025-05-16 17:19:58','2025-05-16 17:19:58','u01'),(243,1,'初級華語二四',2.00,'2025-04-10',NULL,NULL,490,NULL,NULL,1,'weekly','每週2,4','2025-06-26','','',242,'2025-05-16 17:19:58','2025-05-16 17:19:58','u01'),(244,1,'初級華語二四',2.00,'2025-04-15',NULL,NULL,490,NULL,NULL,1,'weekly','每週2,4','2025-06-26','','',242,'2025-05-16 17:19:58','2025-05-16 17:19:58','u01'),(245,1,'初級華語二四',2.00,'2025-04-17',NULL,NULL,490,NULL,NULL,1,'weekly','每週2,4','2025-06-26','','',242,'2025-05-16 17:19:58','2025-05-16 17:19:58','u01'),(246,1,'初級華語二四',2.00,'2025-04-22',NULL,NULL,490,NULL,NULL,1,'weekly','每週2,4','2025-06-26','','',242,'2025-05-16 17:19:58','2025-05-16 17:19:58','u01'),(247,1,'初級華語二四',2.00,'2025-04-24',NULL,NULL,490,NULL,NULL,1,'weekly','每週2,4','2025-06-26','','',242,'2025-05-16 17:19:58','2025-05-16 17:19:58','u01'),(248,1,'初級華語二四',2.00,'2025-04-29',NULL,NULL,490,NULL,NULL,1,'weekly','每週2,4','2025-06-26','','',242,'2025-05-16 17:19:58','2025-05-16 17:19:58','u01'),(249,1,'初級華語二四',2.00,'2025-05-01',NULL,NULL,490,NULL,NULL,1,'weekly','每週2,4','2025-06-26','','',242,'2025-05-16 17:19:59','2025-05-16 17:19:59','u01'),(250,1,'初級華語二四',2.00,'2025-05-06',NULL,NULL,490,NULL,NULL,1,'weekly','每週2,4','2025-06-26','','',242,'2025-05-16 17:19:59','2025-05-16 17:19:59','u01'),(251,1,'初級華語二四',2.00,'2025-05-08',NULL,NULL,490,NULL,NULL,1,'weekly','每週2,4','2025-06-26','','',242,'2025-05-16 17:19:59','2025-05-16 17:19:59','u01'),(252,1,'初級華語二四',2.00,'2025-05-13',NULL,NULL,490,NULL,NULL,1,'weekly','每週2,4','2025-06-26','','',242,'2025-05-16 17:19:59','2025-05-16 17:19:59','u01'),(253,1,'初級華語二四',2.00,'2025-05-15',NULL,NULL,490,NULL,NULL,1,'weekly','每週2,4','2025-06-26','','',242,'2025-05-16 17:19:59','2025-05-16 17:19:59','u01'),(254,1,'初級華語二四',2.00,'2025-05-20',NULL,NULL,490,NULL,NULL,1,'weekly','每週2,4','2025-06-26','','',242,'2025-05-16 17:19:59','2025-05-16 17:19:59','u01'),(255,1,'初級華語二四',2.00,'2025-05-22',NULL,NULL,490,NULL,NULL,1,'weekly','每週2,4','2025-06-26','','',242,'2025-05-16 17:19:59','2025-05-16 17:19:59','u01'),(256,1,'初級華語二四',2.00,'2025-05-27',NULL,NULL,490,NULL,NULL,1,'weekly','每週2,4','2025-06-26','','',242,'2025-05-16 17:19:59','2025-05-16 17:19:59','u01'),(257,1,'初級華語二四',2.00,'2025-05-29',NULL,NULL,490,NULL,NULL,1,'weekly','每週2,4','2025-06-26','','',242,'2025-05-16 17:19:59','2025-05-16 17:19:59','u01'),(258,1,'初級華語二四',2.00,'2025-06-03',NULL,NULL,490,NULL,NULL,1,'weekly','每週2,4','2025-06-26','','',242,'2025-05-16 17:19:59','2025-05-16 17:19:59','u01'),(259,1,'初級華語二四',2.00,'2025-06-05',NULL,NULL,490,NULL,NULL,1,'weekly','每週2,4','2025-06-26','','',242,'2025-05-16 17:19:59','2025-05-16 17:19:59','u01'),(260,1,'初級華語二四',2.00,'2025-06-10',NULL,NULL,490,NULL,NULL,1,'weekly','每週2,4','2025-06-26','','',242,'2025-05-16 17:19:59','2025-05-16 17:19:59','u01'),(261,1,'初級華語二四',2.00,'2025-06-12',NULL,NULL,490,NULL,NULL,1,'weekly','每週2,4','2025-06-26','','',242,'2025-05-16 17:19:59','2025-05-16 17:19:59','u01'),(262,1,'初級華語二四',2.00,'2025-06-17',NULL,NULL,490,NULL,NULL,1,'weekly','每週2,4','2025-06-26','','',242,'2025-05-16 17:19:59','2025-05-16 17:19:59','u01'),(263,1,'初級華語二四',2.00,'2025-06-19',NULL,NULL,490,NULL,NULL,1,'weekly','每週2,4','2025-06-26','','',242,'2025-05-16 17:19:59','2025-05-16 17:19:59','u01'),(264,1,'初級華語二四',2.00,'2025-06-24',NULL,NULL,490,NULL,NULL,1,'weekly','每週2,4','2025-06-26','','',242,'2025-05-16 17:19:59','2025-05-16 17:19:59','u01'),(265,1,'初級華語二四',2.00,'2025-06-26',NULL,NULL,490,NULL,NULL,1,'weekly','每週2,4','2025-06-26','','',242,'2025-05-16 17:19:59','2025-05-16 17:19:59','u01'),(266,1,'初級一',2.00,'2024-09-09','09:10:00','11:00:00',520,NULL,NULL,1,'weekly','每週1','2024-12-30','第2節','',266,'2025-05-26 15:58:20','2025-05-26 15:58:20','u01'),(267,1,'初級一',2.00,'2024-09-16','09:10:00','11:00:00',520,NULL,NULL,1,'weekly','每週1','2024-12-30','第2節','',266,'2025-05-26 15:58:20','2025-05-26 15:58:20','u01'),(268,1,'初級一',2.00,'2024-09-23','09:10:00','11:00:00',520,NULL,NULL,1,'weekly','每週1','2024-12-30','第2節','',266,'2025-05-26 15:58:20','2025-05-26 15:58:20','u01'),(269,1,'初級一',2.00,'2024-09-30','09:10:00','11:00:00',520,NULL,NULL,1,'weekly','每週1','2024-12-30','第2節','',266,'2025-05-26 15:58:20','2025-05-26 15:58:20','u01'),(270,1,'初級一',2.00,'2024-10-07','09:10:00','11:00:00',520,NULL,NULL,1,'weekly','每週1','2024-12-30','第2節','',266,'2025-05-26 15:58:20','2025-05-26 15:58:20','u01'),(271,1,'初級一',2.00,'2024-10-14','09:10:00','11:00:00',520,NULL,NULL,1,'weekly','每週1','2024-12-30','第2節','',266,'2025-05-26 15:58:20','2025-05-26 15:58:20','u01'),(272,1,'初級一',2.00,'2024-10-21','09:10:00','11:00:00',520,NULL,NULL,1,'weekly','每週1','2024-12-30','第2節','',266,'2025-05-26 15:58:20','2025-05-26 15:58:20','u01'),(273,1,'初級一',2.00,'2024-10-28','09:10:00','11:00:00',520,NULL,NULL,1,'weekly','每週1','2024-12-30','第2節','',266,'2025-05-26 15:58:20','2025-05-26 15:58:20','u01'),(274,1,'初級一',2.00,'2024-11-04','09:10:00','11:00:00',520,NULL,NULL,1,'weekly','每週1','2024-12-30','第2節','',266,'2025-05-26 15:58:20','2025-05-26 15:58:20','u01'),(275,1,'初級一',2.00,'2024-11-11','09:10:00','11:00:00',520,NULL,NULL,1,'weekly','每週1','2024-12-30','第2節','',266,'2025-05-26 15:58:20','2025-05-26 15:58:20','u01'),(276,1,'初級一',2.00,'2024-11-18','09:10:00','11:00:00',520,NULL,NULL,1,'weekly','每週1','2024-12-30','第2節','',266,'2025-05-26 15:58:21','2025-05-26 15:58:21','u01'),(277,1,'初級一',2.00,'2024-11-25','09:10:00','11:00:00',520,NULL,NULL,1,'weekly','每週1','2024-12-30','第2節','',266,'2025-05-26 15:58:21','2025-05-26 15:58:21','u01'),(278,1,'初級一',2.00,'2024-12-02','09:10:00','11:00:00',520,NULL,NULL,1,'weekly','每週1','2024-12-30','第2節','',266,'2025-05-26 15:58:21','2025-05-26 15:58:21','u01'),(279,1,'初級一',2.00,'2024-12-09','09:10:00','11:00:00',520,NULL,NULL,1,'weekly','每週1','2024-12-30','第2節','',266,'2025-05-26 15:58:21','2025-05-26 15:58:21','u01'),(280,1,'初級一',2.00,'2024-12-16','09:10:00','11:00:00',520,NULL,NULL,1,'weekly','每週1','2024-12-30','第2節','',266,'2025-05-26 15:58:21','2025-05-26 15:58:21','u01'),(281,1,'初級一',2.00,'2024-12-23','09:10:00','11:00:00',520,NULL,NULL,1,'weekly','每週1','2024-12-30','第2節','',266,'2025-05-26 15:58:21','2025-05-26 15:58:21','u01'),(282,1,'初級一',2.00,'2024-12-30','09:10:00','11:00:00',520,NULL,NULL,1,'weekly','每週1','2024-12-30','第2節','',266,'2025-05-26 15:58:21','2025-05-26 15:58:21','u01'),(283,1,'初級一',3.00,'2025-10-14','08:10:00','11:04:00',535,NULL,NULL,1,'weekly','每週2','2025-12-30','第1節','',283,'2025-05-26 16:33:37','2025-05-26 16:33:37','u01'),(284,1,'初級一',3.00,'2025-10-21','08:10:00','11:04:00',535,NULL,NULL,1,'weekly','每週2','2025-12-30','第1節','',283,'2025-05-26 16:33:37','2025-05-26 16:33:37','u01'),(285,1,'初級一',3.00,'2025-10-28','08:10:00','11:04:00',535,NULL,NULL,1,'weekly','每週2','2025-12-30','第1節','',283,'2025-05-26 16:33:37','2025-05-26 16:33:37','u01'),(286,1,'初級一',3.00,'2025-11-04','08:10:00','11:04:00',535,NULL,NULL,1,'weekly','每週2','2025-12-30','第1節','',283,'2025-05-26 16:33:37','2025-05-26 16:33:37','u01'),(287,1,'初級一',3.00,'2025-11-11','08:10:00','11:04:00',535,NULL,NULL,1,'weekly','每週2','2025-12-30','第1節','',283,'2025-05-26 16:33:37','2025-05-26 16:33:37','u01'),(288,1,'初級一',3.00,'2025-11-18','08:10:00','11:04:00',535,NULL,NULL,1,'weekly','每週2','2025-12-30','第1節','',283,'2025-05-26 16:33:37','2025-05-26 16:33:37','u01'),(289,1,'初級一',3.00,'2025-11-25','08:10:00','11:04:00',535,NULL,NULL,1,'weekly','每週2','2025-12-30','第1節','',283,'2025-05-26 16:33:37','2025-05-26 16:33:37','u01'),(290,1,'初級一',3.00,'2025-12-02','08:10:00','11:04:00',535,NULL,NULL,1,'weekly','每週2','2025-12-30','第1節','',283,'2025-05-26 16:33:37','2025-05-26 16:33:37','u01'),(291,1,'初級一',3.00,'2025-12-09','08:10:00','11:04:00',535,NULL,NULL,1,'weekly','每週2','2025-12-30','第1節','',283,'2025-05-26 16:33:37','2025-05-26 16:33:37','u01'),(292,1,'初級一',3.00,'2025-12-16','08:10:00','11:04:00',535,NULL,NULL,1,'weekly','每週2','2025-12-30','第1節','',283,'2025-05-26 16:33:37','2025-05-26 16:33:37','u01'),(293,1,'初級一',3.00,'2025-12-23','08:10:00','11:04:00',535,NULL,NULL,1,'weekly','每週2','2025-12-30','第1節','',283,'2025-05-26 16:33:37','2025-05-26 16:33:37','u01'),(294,1,'初級一',3.00,'2025-12-30','08:10:00','11:04:00',535,NULL,NULL,1,'weekly','每週2','2025-12-30','第1節','',283,'2025-05-26 16:33:37','2025-05-26 16:33:37','u01');

--
-- Table structure for table `insurance`
--

CREATE TABLE `insurance` (
  `insurance_id` int NOT NULL AUTO_INCREMENT,
  `employee_id` int NOT NULL,
  `insurance_date` date NOT NULL,
  `salary` int DEFAULT '0',
  `health_insurance_employer` int DEFAULT '0',
  `labor_insurance_employer` int DEFAULT '0',
  `health_insurance_employee` int DEFAULT '0',
  `health_insurance_dependent` int DEFAULT '0' COMMENT '眷屬健保費',
  `labor_insurance_employee` int DEFAULT '0',
  `retirement_fund` int DEFAULT '0',
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '建檔日期',
  `update_date` datetime DEFAULT NULL COMMENT '更新日期',
  `updated_by` varchar(100) DEFAULT NULL COMMENT '更新人員',
  PRIMARY KEY (`insurance_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `insurance`
--

INSERT INTO `insurance` VALUES (1,2,'2020-01-01',35000,1300,1200,485,0,540,2101,'2025-04-09 10:05:21','2025-04-17 11:19:52','system'),(2,1,'2023-01-01',35000,1300,1200,180,0,540,3000,'2025-04-09 13:35:48','2025-04-10 16:49:01','system'),(3,1,'2024-01-01',38000,1400,1300,680,0,580,2280,'2025-04-09 14:16:16','2025-04-10 18:05:54','system'),(5,2,'2022-01-01',38000,1600,1500,600,0,500,2280,'2025-04-10 16:15:25','2025-04-11 14:34:55','system'),(6,3,'2025-02-17',30000,1000,1200,450,450,500,1800,'2025-04-28 21:30:41','2025-04-29 15:39:46','system');

--
-- Table structure for table `insurance_comprehensive_levels`
--

CREATE TABLE `insurance_comprehensive_levels` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主鍵ID',
  `year` int NOT NULL COMMENT '適用年度',
  `level_no` int NOT NULL COMMENT '級距等級',
  `salary_range_min` decimal(10,2) DEFAULT '0.00' COMMENT '薪資範圍最小值',
  `salary_range_max` decimal(10,2) DEFAULT '999999.00' COMMENT '薪資範圍最大值',
  `salary_range_text` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '薪資範圍文字描述',
  `labor_insured_salary` decimal(10,2) DEFAULT '0.00' COMMENT '勞保月投保薪資',
  `health_insured_salary` decimal(10,2) DEFAULT '0.00' COMMENT '健保月投保薪資',
  `pension_monthly_wage` decimal(10,2) DEFAULT '0.00' COMMENT '勞退月提繳工資',
  `employee_labor_premium` decimal(8,2) DEFAULT '0.00' COMMENT '員工勞保費',
  `employee_health_premium` decimal(8,2) DEFAULT '0.00' COMMENT '員工健保費',
  `employer_labor_premium` decimal(8,2) DEFAULT '0.00' COMMENT '雇主勞保費',
  `employer_health_premium` decimal(8,2) DEFAULT '0.00' COMMENT '雇主健保費',
  `employer_pension_contribution` decimal(8,2) DEFAULT '0.00' COMMENT '雇主勞退提繳',
  `work_injury_premium` decimal(8,2) DEFAULT '0.00' COMMENT '職災保險費',
  `category` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT 'regular' COMMENT '類別:regular正職,part_time部分工時',
  `note` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '備註',
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '建立日期',
  `update_date` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新日期',
  `updated_by` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT 'SYSTEM' COMMENT '更新人員',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_year_level_category` (`year`,`level_no`,`category`),
  KEY `idx_year` (`year`),
  KEY `idx_salary_range` (`salary_range_min`,`salary_range_max`),
  KEY `idx_category` (`category`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='勞健保勞退綜合級距表';

--
-- Dumping data for table `insurance_comprehensive_levels`
--


--
-- Table structure for table `labor_insurance_levels`
--

CREATE TABLE `labor_insurance_levels` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主鍵ID',
  `year` int NOT NULL COMMENT '適用年度',
  `level_no` int NOT NULL COMMENT '級距等級',
  `salary_range_min` decimal(10,2) DEFAULT '0.00' COMMENT '薪資範圍最小值',
  `salary_range_max` decimal(10,2) DEFAULT '999999.00' COMMENT '薪資範圍最大值',
  `salary_range_text` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '薪資範圍文字描述',
  `insured_salary` decimal(10,2) NOT NULL COMMENT '月投保薪資',
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '建立日期',
  `update_date` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新日期',
  `updated_by` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT 'SYSTEM' COMMENT '更新人員',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_year_level` (`year`,`level_no`),
  KEY `idx_year` (`year`),
  KEY `idx_salary_range` (`salary_range_min`,`salary_range_max`),
  KEY `idx_insured_salary` (`insured_salary`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='勞保投保薪資級距表';

--
-- Dumping data for table `labor_insurance_levels`
--


--
-- Table structure for table `log_use`
--

CREATE TABLE `log_use` (
  `rid` int NOT NULL AUTO_INCREMENT,
  `codeNo` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '程式代碼',
  `remark` varchar(500) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '備註',
  `user_ip` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '連線ip',
  `user_id` int DEFAULT NULL COMMENT '使用者ID',
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '建檔日期',
  PRIMARY KEY (`rid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='使用記錄表';

--
-- Dumping data for table `log_use`
--


--
-- Table structure for table `monthly_settlement`
--

CREATE TABLE `monthly_settlement` (
  `monthly_id` int NOT NULL AUTO_INCREMENT COMMENT '主鍵ID',
  `settlement_date` date NOT NULL COMMENT '結算日期',
  `employee_id` int NOT NULL COMMENT '員工ID',
  `employeeNo` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '員工編號',
  `employeeName` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '員工姓名',
  `tot_salary` int DEFAULT '0' COMMENT '總薪資',
  `tot_hour` decimal(10,2) DEFAULT '0.00' COMMENT '總時數',
  `last_salary` int DEFAULT '0' COMMENT '基本薪資',
  `labor_insurance_employer` int DEFAULT '0' COMMENT '雇主勞保負擔',
  `health_insurance_employer` int DEFAULT '0' COMMENT '雇主健保負擔',
  `labor_insurance_employee` int DEFAULT '0' COMMENT '員工勞保負擔',
  `health_insurance_employee` int DEFAULT '0' COMMENT '員工健保負擔',
  `health_insurance_dependent` int DEFAULT '0' COMMENT '眷屬健保費',
  `retirement_fund` int DEFAULT '0' COMMENT '退休金提撥',
  `net_salary` int DEFAULT '0' COMMENT '淨薪資',
  `update_date` datetime DEFAULT NULL COMMENT '更新日期',
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '建檔日期',
  `updated_by` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新人員',
  PRIMARY KEY (`monthly_id`),
  UNIQUE KEY `settlement_date_2` (`settlement_date`,`employee_id`) COMMENT '結算日期與員工ID的唯一約束',
  KEY `settlement_date` (`settlement_date`) COMMENT '結算日期索引',
  KEY `employee_id` (`employee_id`) COMMENT '員工ID索引'
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='員工資月結檔';

--
-- Dumping data for table `monthly_settlement`
--

INSERT INTO `monthly_settlement` VALUES (25,'2025-03-31',2,'e0002','林森',1200,2.00,35000,1200,1300,540,485,0,2101,175,'2025-04-24 11:51:18','2025-04-24 11:51:17',NULL),(28,'2025-02-28',2,'e0002','林森',4800,8.00,35000,1200,1300,540,485,0,2101,3775,'2025-04-24 14:06:21','2025-04-24 14:06:20',NULL),(54,'2024-11-30',1,'e0001','王子',4160,8.00,38000,1300,1400,580,680,0,2280,2900,'2025-05-26 16:25:50','2025-05-26 16:25:50',NULL),(55,'2024-12-31',1,'e0001','王子',5200,10.00,38000,1300,1400,580,680,0,2280,3940,'2025-05-26 16:25:56','2025-05-26 16:25:56',NULL),(56,'2025-11-30',1,'e0001','王子',6420,12.00,38000,1300,1400,580,680,0,2280,5160,'2025-05-26 16:34:08','2025-05-26 16:34:08',NULL),(57,'2025-12-31',1,'e0001','王子',8025,15.00,38000,1300,1400,580,680,0,2280,6765,'2025-05-26 16:34:13','2025-05-26 16:34:13',NULL),(67,'2025-06-30',1,'e0001','王子',43620,90.00,38000,1300,1400,580,680,0,2280,42360,'2025-06-12 15:43:02','2025-06-12 15:43:02',NULL),(68,'2025-06-30',3,'e0003','教師A',31620,58.00,30000,1200,1000,500,900,0,1800,30220,'2025-06-12 15:43:02','2025-06-12 15:43:02',NULL),(69,'2025-05-31',1,'e0001','王子',52110,108.00,38000,1300,1400,580,680,0,2280,50850,'2025-06-12 15:43:11','2025-06-12 15:43:11',NULL),(70,'2025-05-31',3,'e0003','教師A',104580,186.00,30000,1200,1000,500,900,0,1800,103180,'2025-06-12 15:43:11','2025-06-12 15:43:11',NULL),(71,'2025-04-30',1,'e0001','王子',43230,90.00,38000,1300,1400,580,680,0,2280,41970,'2025-06-12 15:43:23','2025-06-12 15:43:23',NULL),(72,'2025-04-30',3,'e0003','教師A',35720,70.50,30000,1200,1000,500,900,0,1800,34320,'2025-06-12 15:43:23','2025-06-12 15:43:23',NULL);

--
-- Table structure for table `salary_grades`
--

CREATE TABLE `salary_grades` (
  `id` int NOT NULL AUTO_INCREMENT,
  `year` int NOT NULL COMMENT '年度',
  `grade_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '級距名稱',
  `salary_amount` int NOT NULL COMMENT '薪資金額',
  `company_labor_insurance` int NOT NULL COMMENT '公司負擔勞保',
  `company_health_insurance` int NOT NULL COMMENT '公司負擔健保',
  `company_employment_insurance` int NOT NULL COMMENT '公司負擔職保',
  `company_labor_pension` int NOT NULL COMMENT '公司負擔勞退6%',
  `company_total` int NOT NULL COMMENT '公司負擔合計',
  `employee_salary_base` int NOT NULL COMMENT '員工負擔薪資基數',
  `employee_labor_insurance` int NOT NULL COMMENT '員工負擔勞保',
  `employee_health_insurance` int NOT NULL COMMENT '員工負擔健保',
  `employee_total` int NOT NULL COMMENT '員工負擔合計',
  `remarks` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '備註',
  `update_date` datetime DEFAULT NULL COMMENT '更新日期',
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '建檔日期',
  `updated_by` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '更新人員',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_year_salary` (`year`,`salary_amount`),
  KEY `idx_year` (`year`),
  KEY `idx_salary_amount` (`salary_amount`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `salary_grades`
--


--
-- Table structure for table `sql_err`
--

CREATE TABLE `sql_err` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主鍵，自動遞增',
  `sql_msg` text NOT NULL COMMENT 'SQL 錯誤發生時的 SQL 語句',
  `sql_err` int NOT NULL COMMENT 'SQL 錯誤代碼',
  `sql_errmsg` text NOT NULL COMMENT 'SQL 錯誤訊息',
  `PHP_SELF` varchar(255) NOT NULL COMMENT '執行發生錯誤的 PHP 檔案',
  `REQUEST_URI` varchar(255) NOT NULL COMMENT '發送請求的 URI',
  `REQUEST` text NOT NULL COMMENT '完整的請求參數 ($_REQUEST)',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '記錄錯誤發生時間',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='SQL 錯誤日誌記錄表';

--
-- Dumping data for table `sql_err`
--


--
-- Table structure for table `system_logs`
--

CREATE TABLE `system_logs` (
  `log_id` int NOT NULL AUTO_INCREMENT COMMENT '紀錄ID',
  `user_id` int DEFAULT NULL COMMENT '操作人員ID',
  `action` varchar(100) NOT NULL COMMENT '操作動作',
  `target_table` varchar(100) DEFAULT NULL COMMENT '目標資料表',
  `target_id` int DEFAULT NULL COMMENT '目標記錄ID',
  `action_detail` text COMMENT '操作詳情',
  `ip_address` varchar(50) DEFAULT NULL COMMENT 'IP位址',
  `action_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '操作時間',
  PRIMARY KEY (`log_id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `system_logs_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系統操作紀錄';

--
-- Dumping data for table `system_logs`
--


--
-- Table structure for table `system_news`
--

CREATE TABLE `system_news` (
  `news_id` int NOT NULL AUTO_INCREMENT COMMENT '公告編號',
  `news_title` varchar(255) NOT NULL COMMENT '公告標題',
  `news_content` text NOT NULL COMMENT '公告內容',
  `publish_date` datetime DEFAULT NULL COMMENT '發佈日期',
  `publish_unit` varchar(255) DEFAULT NULL COMMENT '發佈單位',
  `attachment_url` varchar(999) DEFAULT NULL COMMENT '附件下載URL',
  `remove_date` datetime DEFAULT NULL COMMENT '下架日期',
  `update_date` datetime DEFAULT NULL COMMENT '更新日期',
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '建檔日期',
  `updated_by` varchar(100) DEFAULT NULL COMMENT '更新人員',
  PRIMARY KEY (`news_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系統公告表';

--
-- Dumping data for table `system_news`
--

INSERT INTO `system_news` VALUES (1,'test','test123','2025-04-24 09:47:00','','01.png，02.png','2026-04-24 00:00:00','2025-04-24 09:49:23','2025-04-24 09:48:14',NULL);

--
-- Table structure for table `time_slots`
--

CREATE TABLE `time_slots` (
  `slot_id` int NOT NULL AUTO_INCREMENT COMMENT '時段ID',
  `slot_name` varchar(100) NOT NULL COMMENT '時段名稱',
  `start_time` time NOT NULL COMMENT '開始時間',
  `end_time` time NOT NULL COMMENT '結束時間',
  `update_date` datetime DEFAULT NULL COMMENT '更新日期',
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '建檔日期',
  `updated_by` varchar(100) DEFAULT NULL COMMENT '更新人員',
  PRIMARY KEY (`slot_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='標準預約時段定義';

--
-- Dumping data for table `time_slots`
--

INSERT INTO `time_slots` VALUES (1,'第1節','08:10:00','09:04:00','2025-04-24 09:52:10','2025-03-06 14:30:47',''),(2,'第2節','09:10:00','10:00:00','2025-03-06 17:34:50','2025-03-06 17:34:37',NULL),(3,'第3節','10:10:00','11:00:00','2025-03-06 17:37:18','2025-03-06 17:37:18',NULL),(5,'第4節','11:10:00','12:00:00','2025-03-06 14:31:30','2025-03-06 14:30:47',NULL),(6,'午休','12:10:00','13:00:00','2025-03-06 17:34:50','2025-03-06 17:34:37',NULL),(7,'第5節','13:10:00','14:00:00','2025-03-06 17:37:18','2025-03-06 17:37:18',NULL),(8,'第6節','14:10:00','15:00:00','2025-03-06 14:31:30','2025-03-06 14:30:47',NULL),(9,'第7節','15:10:00','16:00:00','2025-03-06 17:34:50','2025-03-06 17:34:37',NULL),(10,'第8節','16:10:00','17:00:00','2025-03-06 14:31:30','2025-03-06 14:30:47',NULL),(11,'第9節','17:10:00','18:00:00','2025-03-06 17:34:50','2025-03-06 17:34:37',NULL),(12,'第C節','18:10:00','19:00:00','2025-03-06 14:31:30','2025-03-06 14:30:47',NULL),(13,'第D節','19:10:00','20:00:00','2025-03-06 17:34:50','2025-03-06 17:34:37',NULL),(14,'第E節','20:10:00','21:00:00','2025-03-06 14:31:30','2025-03-06 14:30:47',NULL),(15,'第F節','21:10:00','22:00:00','2025-03-06 17:37:18','2025-03-06 17:37:18',NULL);

--
-- Table structure for table `vacation_payments`
--

CREATE TABLE `vacation_payments` (
  `vacation_id` int NOT NULL AUTO_INCREMENT,
  `employee_id` int NOT NULL,
  `year_start` date NOT NULL,
  `year_end` date NOT NULL,
  `total_hours` decimal(10,2) NOT NULL,
  `vacation_days` decimal(10,2) NOT NULL COMMENT '特休日數',
  `monthly_salary` decimal(10,2) NOT NULL,
  `seniority_years` decimal(10,2) NOT NULL COMMENT '年資',
  `jan_hour` decimal(10,2) DEFAULT '0.00' COMMENT '1月上課時數',
  `feb_hour` decimal(10,2) DEFAULT '0.00' COMMENT '2月上課時數',
  `mar_hour` decimal(10,2) DEFAULT '0.00' COMMENT '3月上課時數',
  `apr_hour` decimal(10,2) DEFAULT '0.00' COMMENT '4月上課時數',
  `may_hour` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '5月上課時數',
  `jun_hour` decimal(10,2) DEFAULT '0.00' COMMENT '6月上課時數',
  `jul_hour` decimal(10,2) DEFAULT '0.00' COMMENT '7月上課時數',
  `aug_hour` decimal(10,2) DEFAULT '0.00' COMMENT '8月上課時數',
  `sep_hour` decimal(10,2) DEFAULT '0.00' COMMENT '9月上課時數',
  `oct_hour` decimal(10,2) DEFAULT '0.00' COMMENT '10月上課時數',
  `nov_hour` decimal(10,2) DEFAULT '0.00' COMMENT '11月上課時數',
  `dec_hour` decimal(10,2) DEFAULT '0.00' COMMENT '12月上課時數',
  `nov_salary` int DEFAULT '0' COMMENT '11月薪資',
  `vacation_hours` decimal(10,2) NOT NULL,
  `hourly_rate` decimal(10,2) NOT NULL,
  `vacation_payment` decimal(10,2) NOT NULL,
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '建檔日期',
  `update_date` datetime DEFAULT NULL COMMENT '更新日期',
  `updated_by` varchar(100) DEFAULT NULL COMMENT '更新人員',
  PRIMARY KEY (`vacation_id`,`may_hour`)
) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `vacation_payments`
--

INSERT INTO `vacation_payments` VALUES (82,1,'2024-12-01','2025-11-30',54.00,10.00,0.00,2.60,0.00,0.00,0.00,14.00,18.00,0.00,0.00,0.00,0.00,0.00,12.00,10.00,6420,80.00,535.00,1107.00,'2025-05-28 17:28:37','2025-05-28 17:34:58','u01'),(83,2,'2024-12-01','2025-11-30',10.00,15.00,0.00,6.00,0.00,8.00,2.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,120.00,0.00,0.00,'2025-05-28 17:28:37','2025-05-28 17:28:37','May'),(84,3,'2024-12-01','2025-11-30',32.00,7.00,0.00,1.00,0.00,0.00,0.00,14.00,18.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,56.00,0.00,0.00,'2025-05-28 17:28:37','2025-05-28 17:28:37','May');


