--
-- Host: localhost    Database: absence
-- ------------------------------------------------------


--
-- Table structure for table `dat_trainee_notify`
--

CREATE TABLE `dat_trainee_notify` (
  `id` varchar(5) NOT NULL,
  `date` varchar(8) NOT NULL,
  `notify` tinyint(4) NOT NULL,
  `memo` varchar(64) DEFAULT NULL,
  `unit` tinyint(3) unsigned NOT NULL,
  `periods` text DEFAULT NULL,
  `insdatetime` datetime NOT NULL,
  PRIMARY KEY (`id`,`date`,`notify`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `dat_trainee_notify`
--

INSERT INTO `dat_trainee_notify` VALUES ('es101','0402',2,'体調不良',4,NULL,'2025-07-15 12:46:39'),('es101','0404',3,'私用',1,NULL,'2025-07-15 12:47:11'),('es101','0407',1,'交通遅延',1,NULL,'2025-07-15 12:47:59'),('es101','0409',0,'youtube鑑賞',6,NULL,'2025-07-15 12:33:50'),('es101','0410',1,'交通遅延',3,NULL,'2025-07-15 12:48:50'),('es101','0411',3,'私用',2,NULL,'2025-07-15 12:49:05'),('es101','0415',1,'交通遅延',1,NULL,'2025-07-15 12:50:35'),('es101','0501',1,'交通遅延',2,NULL,'2025-07-15 12:52:59'),('es101','0505',2,'体調不良',1,NULL,'2025-07-15 12:54:05'),('es101','0507',1,'就職活動',3,NULL,'2025-07-15 12:54:29'),('es101','0515',3,'私用',3,NULL,'2025-07-15 11:01:58'),('es101','0527',0,'体調不良',6,NULL,'2025-07-15 12:54:49'),('es101','0528',0,'体調不良',6,NULL,'2025-07-15 12:55:01'),('es101','0529',3,'私用',1,NULL,'2025-07-15 12:55:14'),('es101','0604',1,'就職活動',2,NULL,'2025-07-15 12:58:33'),('es101','0606',0,'体調不良',6,NULL,'2025-07-15 11:02:11'),('es101','0609',1,'交通遅延',1,NULL,'2025-07-15 12:57:06'),('es101','0612',3,'就職活動',2,NULL,'2025-07-15 12:57:29'),('es101','0616',1,'交通遅延',4,NULL,'2025-07-15 12:57:46'),('es101','0626',0,'就職活動',6,NULL,'2025-07-15 12:58:06'),('es101','0627',0,'就職活動',6,NULL,'2025-07-15 12:59:24'),('es101','0630',0,'体調不良',6,NULL,'2025-07-15 12:59:32'),('es101','0701',2,'体調不良',1,NULL,'2025-07-15 13:00:55'),('es101','0702',1,'交通遅延',1,NULL,'2025-07-15 13:01:44'),('es101','0703',0,'体調不良',6,NULL,'2025-07-15 13:02:34'),('es101','0707',1,'体調不良',1,NULL,'2025-07-15 13:02:44'),('es101','0709',0,'就職活動',6,NULL,'2025-07-15 13:02:54'),('es101','0801',3,'就職活動',2,NULL,'2025-07-16 13:01:07'),('es101','0807',0,'',6,NULL,'2025-07-15 13:07:34'),('es101','0902',1,'交通遅延',1,NULL,'2025-07-15 13:08:22'),('es101','0904',0,'体調不良',6,NULL,'2025-07-15 11:02:28'),('es101','0905',2,'体調不良',3,NULL,'2025-07-15 13:08:34'),('es119','0113',0,'就職活動',6,NULL,'2025-07-16 02:34:58'),('es119','0618',2,'私用',2,NULL,'2025-07-16 13:13:45'),('es119','0630',0,'体調不良',6,NULL,'2025-07-16 12:56:50'),('es119','0704',0,'体調不良',6,NULL,'2025-07-04 14:34:36'),('es119','0705',0,'就職活動',6,NULL,'2025-07-04 14:37:43'),('es119','0715',0,'私用',6,NULL,'2025-07-16 02:40:16'),('es119','0716',2,'私用',3,NULL,'2025-07-15 21:14:20'),('es119','0716',3,'就職活動',3,NULL,'2025-07-16 11:17:25'),('es119','0717',1,'体調不良',1,NULL,'2025-07-16 10:12:16'),('es119','0717',3,'就職活動',2,NULL,'2025-07-16 11:22:52'),('es119','0718',0,'就職活動',6,NULL,'2025-07-18 17:15:39'),('es119','0719',1,'体調不良',1,NULL,'2025-07-19 22:42:42'),('es119','0721',0,'',6,NULL,'2025-07-21 08:10:13'),('es119','0722',3,'肥満',4,'[2,3,4,5]','2025-07-20 23:52:40'),('es119','0723',0,'忌引き',6,NULL,'2025-07-18 17:17:27'),('es119','0723',1,'交通遅延',1,NULL,'2025-07-18 17:17:41'),('es119','0724',2,'ももちゃんとごはんたべます',6,'[1,2,3,4,5,6]','2025-07-21 00:22:55'),('es119','0804',1,'体調不良',1,NULL,'2025-07-15 14:35:41'),('es119','0804',2,'就職活動',3,NULL,'2025-07-20 23:14:44'),('es119','0804',3,'',1,NULL,'2025-07-15 14:37:10'),('es119','0818',0,'体調不良',6,NULL,'2025-08-18 06:06:54'),('es119','1226',1,'体調不良',1,'[1]','2025-12-26 02:51:57'),('es120','0718',0,'体調不良',6,NULL,'2025-07-19 03:25:59'),('es120','0719',0,'就職活動',6,NULL,'2025-07-19 07:29:29'),('es120','0723',0,'',6,NULL,'2025-07-19 07:16:59'),('es120','0724',1,'交通遅延',1,NULL,'2025-07-19 07:30:28'),('es120','0724',2,'体調不良',1,NULL,'2025-07-19 07:30:43');


