-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL Version:             11.2.0.6213
-- --------------------------------------------------------



-- Dumping database structure for crud-two
CREATE DATABASE IF NOT EXISTS `crud-two` /*!40100 DEFAULT CHARACTER SET latin1 */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `crud-two`;

-- Dumping structure for table crud-two.attendances
CREATE TABLE IF NOT EXISTS `attendances` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `uid` int unsigned NOT NULL DEFAULT '0',
  `emp_id` int unsigned NOT NULL,
  `state` tinyint(1) NOT NULL DEFAULT '0',
  `attendance_time` time NOT NULL DEFAULT '06:57:39',
  `attendance_date` date NOT NULL DEFAULT '2024-02-26',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `type` tinyint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `attendances_emp_id_foreign` (`emp_id`),
  CONSTRAINT `attendances_emp_id_foreign` FOREIGN KEY (`emp_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crud-two.attendances: ~0 rows (approximately)

-- Dumping structure for table crud-two.attendance_info
CREATE TABLE IF NOT EXISTS `attendance_info` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `id_number` int NOT NULL,
  `attendance_number` int NOT NULL,
  `state` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `attendance_date_time` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `device_serial_number` varchar(255) 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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=53574 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crud-two.attendance_info: ~0 rows (approximately)
INSERT INTO `attendance_info` (`id`, `id_number`, `attendance_number`, `state`, `attendance_date_time`, `type`, `device_serial_number`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(1, 101192697, 443, '15', '2024-02-26 17:01:50', '1', 'CJKT212060009\0', '2024-02-26 13:33:28', '2024-02-26 13:33:28', NULL),
	(2, 101192697, 444, '15', '2024-02-27 08:01:40', '1', 'CJKT212060009\0', '2024-02-27 04:41:09', '2024-02-27 04:41:09', NULL),
	(3, 101192697, 445, '15', '2024-02-27 08:04:08', '0', 'CJKT212060009\0', '2024-02-27 04:41:09', '2024-02-27 04:41:09', NULL),
	(4, 101192697, 446, '15', '2024-02-27 08:04:14', '1', 'CJKT212060009\0', '2024-02-27 04:41:09', '2024-02-27 04:41:09', NULL),
	(5, 101192697, 447, '15', '2024-02-27 08:04:22', '2', 'CJKT212060009\0', '2024-02-27 04:41:09', '2024-02-27 04:41:09', NULL),
	(6, 101192697, 448, '15', '2024-02-27 08:04:29', '3', 'CJKT212060009\0', '2024-02-27 04:41:09', '2024-02-27 04:41:09', NULL),
	(7, 101192697, 449, '15', '2024-02-27 08:05:22', '6', 'CJKT212060009\0', '2024-02-27 04:41:09', '2024-02-27 04:41:09', NULL),
	(8, 104181252, 450, '15', '2024-02-27 08:15:37', '6', 'CJKT212060009\0', '2024-02-27 05:30:10', '2024-02-27 05:30:10', NULL),
	(9, 101192697, 451, '15', '2024-02-27 08:15:40', '6', 'CJKT212060009\0', '2024-02-27 05:30:10', '2024-02-27 05:30:10', NULL),
	(10, 104181252, 452, '15', '2024-02-27 08:21:33', '6', 'CJKT212060009\0', '2024-02-27 05:30:10', '2024-02-27 05:30:10', NULL),
	(11, 104181252, 453, '15', '2024-02-27 08:21:40', '6', 'CJKT212060009\0', '2024-02-27 05:30:10', '2024-02-27 05:30:10', NULL),
	(12, 101192697, 454, '15', '2024-02-27 08:28:18', '6', 'CJKT212060009\0', '2024-02-27 05:30:10', '2024-02-27 05:30:10', NULL),
	(13, 101192697, 455, '15', '2024-02-27 10:26:43', '6', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL),
	(14, 101192697, 456, '15', '2024-02-27 10:26:54', '6', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL),
	(15, 101192697, 457, '15', '2024-02-27 10:33:21', '6', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL),
	(16, 101192697, 458, '15', '2024-02-27 10:38:15', '6', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL),
	(17, 101192697, 459, '15', '2024-02-27 10:38:43', '6', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL),
	(18, 101192697, 460, '15', '2024-02-27 11:39:42', '6', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL),
	(19, 101192697, 461, '15', '2024-02-27 11:40:24', '6', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL),
	(20, 101192697, 462, '15', '2024-02-27 11:40:33', '6', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL),
	(21, 101192697, 463, '15', '2024-02-27 11:40:41', '6', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL),
	(22, 101192697, 464, '15', '2024-02-27 12:27:32', '2', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL),
	(23, 101192697, 465, '15', '2024-02-27 13:00:46', '3', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL),
	(24, 101192697, 466, '15', '2024-02-27 13:07:12', '7', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL),
	(25, 101192697, 467, '15', '2024-02-27 13:07:23', '7', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL),
	(26, 104181252, 468, '15', '2024-02-27 13:10:23', '7', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL),
	(27, 104181252, 469, '15', '2024-02-27 13:10:37', '7', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL),
	(28, 104181252, 470, '15', '2024-02-27 13:34:12', '7', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL),
	(29, 104181252, 471, '15', '2024-02-27 13:49:33', '7', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL),
	(30, 104181252, 472, '15', '2024-02-27 13:54:34', '7', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL),
	(31, 104181252, 473, '15', '2024-02-27 13:54:47', '7', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL),
	(32, 104181252, 474, '15', '2024-02-27 14:13:43', '7', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL),
	(33, 101192697, 475, '15', '2024-02-27 14:19:20', '7', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL),
	(34, 101192697, 476, '15', '2024-02-27 14:20:02', '7', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL),
	(35, 104181252, 477, '15', '2024-02-27 14:21:27', '7', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL),
	(36, 101192697, 478, '15', '2024-02-27 14:53:06', '7', 'CJKT212060009\0', '2024-02-27 11:25:56', '2024-02-27 11:25:56', NULL),
	(37, 101192697, 479, '15', '2024-02-27 15:49:02', '7', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL),
	(38, 101192697, 480, '15', '2024-02-27 16:48:10', '7', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL),
	(39, 104181252, 481, '15', '2024-02-27 16:50:54', '7', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL),
	(40, 104181252, 482, '15', '2024-02-27 16:51:11', '7', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL),
	(41, 104181252, 483, '15', '2024-02-27 16:54:15', '7', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL),
	(42, 104181252, 484, '15', '2024-02-27 16:58:23', '7', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL),
	(43, 104181252, 485, '15', '2024-02-27 16:59:17', '7', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL),
	(44, 104181252, 486, '15', '2024-02-27 16:59:24', '7', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL),
	(45, 101192697, 487, '15', '2024-02-28 09:09:32', '1', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL),
	(46, 101192697, 488, '15', '2024-02-28 09:15:16', '6', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL),
	(47, 101192697, 489, '15', '2024-02-28 09:26:39', '6', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL),
	(48, 101192697, 490, '15', '2024-02-28 09:26:45', '6', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL),
	(49, 101192697, 491, '15', '2024-02-28 09:30:26', '6', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL),
	(50, 101192697, 492, '15', '2024-02-28 09:30:31', '6', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL),
	(51, 101192697, 493, '15', '2024-02-28 09:44:20', '6', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL),
	(52, 101192697, 494, '15', '2024-02-28 09:44:42', '6', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL),
	(53, 101192697, 495, '15', '2024-02-28 09:44:50', '6', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL),
	(54, 101192697, 496, '15', '2024-02-28 09:45:07', '6', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL),
	(55, 101192697, 497, '15', '2024-03-04 11:10:49', '6', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL),
	(56, 101192697, 498, '15', '2024-03-11 09:27:07', '6', 'CJKT212060009\0', '2024-03-11 06:13:06', '2024-03-11 06:13:06', NULL),
	(57, 101192697, 499, '15', '2024-03-11 10:47:50', '6', 'CJKT212060009\0', '2024-03-11 11:41:39', '2024-03-11 11:41:39', NULL),
	(58, 101192697, 500, '15', '2024-03-11 10:47:55', '6', 'CJKT212060009\0', '2024-03-11 11:41:39', '2024-03-11 11:41:39', NULL),
	(59, 101192697, 501, '15', '2024-03-11 11:16:07', '6', 'CJKT212060009\0', '2024-03-11 11:41:39', '2024-03-11 11:41:39', NULL),
	(60, 101192697, 502, '15', '2024-03-11 12:59:39', '6', 'CJKT212060009\0', '2024-03-11 11:41:39', '2024-03-11 11:41:39', NULL),
	(61, 101192697, 503, '15', '2024-03-11 13:06:48', '7', 'CJKT212060009\0', '2024-03-11 11:41:39', '2024-03-11 11:41:39', NULL),
	(62, 104181252, 504, '15', '2024-03-11 13:06:57', '7', 'CJKT212060009\0', '2024-03-11 11:41:39', '2024-03-11 11:41:39', NULL),
	(63, 101192697, 505, '15', '2024-03-11 13:07:00', '7', 'CJKT212060009\0', '2024-03-11 11:41:39', '2024-03-11 11:41:39', NULL),
	(64, 101192697, 506, '15', '2024-03-11 13:29:21', '7', 'CJKT212060009\0', '2024-03-11 11:41:39', '2024-03-11 11:41:39', NULL),
	(65, 101192697, 507, '15', '2024-03-11 14:49:00', '7', 'CJKT212060009\0', '2024-03-11 11:41:39', '2024-03-11 11:41:39', NULL),
	(66, 101192697, 508, '15', '2024-03-11 15:04:50', '7', 'CJKT212060009\0', '2024-03-11 11:41:39', '2024-03-11 11:41:39', NULL),
	(67, 101192697, 509, '15', '2024-03-11 15:04:57', '7', 'CJKT212060009\0', '2024-03-11 11:41:39', '2024-03-11 11:41:39', NULL),
	(68, 101192697, 510, '15', '2024-03-11 15:05:04', '7', 'CJKT212060009\0', '2024-03-11 11:41:39', '2024-03-11 11:41:39', NULL),
	(69, 101192697, 511, '15', '2024-03-11 15:05:13', '7', 'CJKT212060009\0', '2024-03-11 11:41:39', '2024-03-11 11:41:39', NULL),
	(70, 101192697, 512, '15', '2024-03-11 15:35:35', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(71, 101192697, 513, '15', '2024-03-11 15:44:33', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(72, 101192697, 514, '15', '2024-03-11 15:44:45', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(73, 101192697, 515, '15', '2024-03-11 15:56:44', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(74, 101192697, 516, '15', '2024-03-11 16:00:50', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(75, 101192697, 517, '15', '2024-03-11 16:32:32', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(76, 101192697, 518, '15', '2024-03-11 16:43:08', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(77, 101192697, 519, '15', '2024-03-11 16:43:13', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(78, 101192697, 520, '15', '2024-03-12 09:52:58', '1', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(79, 101192697, 521, '15', '2024-03-12 09:53:17', '6', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(80, 101192697, 522, '15', '2024-03-12 09:53:30', '6', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(81, 101192697, 523, '15', '2024-03-12 09:53:48', '6', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(82, 101192697, 524, '15', '2024-03-12 10:06:24', '6', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(83, 101192697, 525, '15', '2024-03-12 10:06:29', '6', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(84, 101192697, 526, '15', '2024-03-12 10:11:50', '6', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(85, 101192697, 527, '15', '2024-03-12 10:11:57', '6', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(86, 101192697, 528, '15', '2024-03-12 10:48:39', '6', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(87, 101192697, 529, '15', '2024-03-12 10:49:33', '6', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(88, 101192697, 530, '15', '2024-03-12 11:02:03', '6', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(89, 101192697, 531, '15', '2024-03-12 11:22:43', '6', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(90, 101192697, 532, '15', '2024-03-12 11:57:48', '6', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(91, 101192697, 533, '15', '2024-03-12 12:04:41', '6', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(92, 101192697, 534, '15', '2024-03-12 12:04:46', '6', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(93, 101192697, 535, '15', '2024-03-12 13:02:19', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(94, 101192697, 536, '15', '2024-03-12 13:04:12', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(95, 109132354, 537, '15', '2024-03-12 13:05:32', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(96, 109132354, 538, '15', '2024-03-12 13:05:45', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(97, 101192697, 539, '15', '2024-03-12 13:06:26', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(98, 101192697, 540, '15', '2024-03-12 13:06:35', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(99, 101192697, 541, '15', '2024-03-12 13:07:57', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(100, 101192697, 542, '15', '2024-03-12 13:30:05', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(101, 101192697, 543, '15', '2024-03-12 13:36:40', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(102, 101192697, 544, '15', '2024-03-12 14:37:27', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(103, 101192697, 545, '15', '2024-03-12 14:46:34', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(104, 101192697, 546, '15', '2024-03-12 15:54:16', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(105, 101192697, 547, '15', '2024-03-12 16:13:11', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(106, 109132354, 548, '15', '2024-03-12 16:36:18', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(107, 101192697, 549, '15', '2024-03-12 16:41:30', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(108, 101192697, 550, '15', '2024-03-12 16:41:36', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(109, 109132354, 551, '15', '2024-03-12 16:48:13', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(110, 109132354, 552, '15', '2024-03-12 16:48:22', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(111, 109132354, 553, '15', '2024-03-12 16:48:30', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(112, 109132354, 554, '15', '2024-03-12 16:48:35', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(113, 109132354, 555, '15', '2024-03-12 16:48:41', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(114, 109132354, 556, '15', '2024-03-12 16:48:46', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(115, 109132354, 557, '15', '2024-03-12 16:48:59', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(116, 101192697, 558, '15', '2024-03-12 16:58:51', '7', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(117, 101192697, 559, '15', '2024-03-12 17:03:55', '1', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(118, 101192697, 560, '15', '2024-03-12 17:09:21', '1', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(119, 101192697, 561, '15', '2024-03-12 17:09:57', '1', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(120, 109132354, 562, '15', '2024-03-12 17:09:59', '1', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(121, 101192697, 563, '15', '2024-03-14 11:41:44', '6', 'CJKT212060009\0', '2024-03-14 08:20:26', '2024-03-14 08:20:26', NULL),
	(53570, 101192697, 564, '15', '2024-03-14 12:31:14', '6', 'CJKT212060009\0', '2024-03-14 12:54:35', '2024-03-14 12:54:35', NULL),
	(53571, 101192697, 565, '15', '2024-03-14 13:40:25', '7', 'CJKT212060009\0', '2024-03-14 12:54:35', '2024-03-14 12:54:35', NULL),
	(53572, 101192697, 566, '15', '2024-03-14 15:10:00', '7', 'CJKT212060009\0', '2024-03-14 12:54:35', '2024-03-14 12:54:35', NULL),
	(53573, 101192697, 567, '15', '2024-03-15 10:36:07', '6', 'CJKT212060009\0', '2024-03-15 07:24:26', '2024-03-15 07:24:26', NULL);

-- Dumping structure for table crud-two.checks
CREATE TABLE IF NOT EXISTS `checks` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `emp_id` int unsigned NOT NULL,
  `attendance_time` datetime NOT NULL,
  `leave_time` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `checks_emp_id_foreign` (`emp_id`),
  CONSTRAINT `checks_emp_id_foreign` FOREIGN KEY (`emp_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crud-two.checks: ~0 rows (approximately)

-- Dumping structure for table crud-two.failed_jobs
CREATE TABLE IF NOT EXISTS `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crud-two.failed_jobs: ~0 rows (approximately)

-- Dumping structure for table crud-two.finger_devices
CREATE TABLE IF NOT EXISTS `finger_devices` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ip` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `serialNumber` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `finger_devices_serialnumber_unique` (`serialNumber`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crud-two.finger_devices: ~0 rows (approximately)
INSERT INTO `finger_devices` (`id`, `name`, `ip`, `serialNumber`, `created_at`, `updated_at`, `deleted_at`) VALUES
	(2, 'Room E', '192.168.0.17', 'AF39211260005\0', '2024-02-26 08:15:36', '2024-03-14 11:44:44', '2024-03-14 11:44:44'),
	(3, 'bio test', '192.168.0.63', '3394171100244\0', '2024-03-15 09:46:43', '2024-03-15 09:46:43', NULL);

-- Dumping structure for table crud-two.latetimes
CREATE TABLE IF NOT EXISTS `latetimes` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `emp_id` int unsigned NOT NULL,
  `duration` time NOT NULL,
  `latetime_date` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `latetimes_emp_id_foreign` (`emp_id`),
  CONSTRAINT `latetimes_emp_id_foreign` FOREIGN KEY (`emp_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crud-two.latetimes: ~0 rows (approximately)

-- Dumping structure for table crud-two.leaves
CREATE TABLE IF NOT EXISTS `leaves` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `uid` int unsigned NOT NULL DEFAULT '0',
  `emp_id` int unsigned NOT NULL,
  `state` tinyint(1) NOT NULL DEFAULT '0',
  `leave_time` time NOT NULL DEFAULT '06:57:39',
  `leave_date` date NOT NULL DEFAULT '2024-02-26',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `type` tinyint unsigned NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `leaves_emp_id_foreign` (`emp_id`),
  CONSTRAINT `leaves_emp_id_foreign` FOREIGN KEY (`emp_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crud-two.leaves: ~0 rows (approximately)

-- Dumping structure for table crud-two.migrations
CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crud-two.migrations: ~15 rows (approximately)
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
	(17, '2014_10_12_000000_create_users_table', 1),
	(18, '2014_10_12_100000_create_password_resets_table', 1),
	(19, '2019_08_19_000000_create_failed_jobs_table', 1),
	(20, '2019_11_25_113026_create_employees_table', 1),
	(21, '2019_12_02_141403_create_roles_table', 1),
	(22, '2019_12_03_044741_create_schedules_table', 1),
	(23, '2019_12_03_045452_create_attendances_table', 1),
	(24, '2019_12_03_045912_create_latetimes_table', 1),
	(25, '2019_12_03_045930_create_overtimes_table', 1),
	(26, '2019_12_03_050030_create_leaves_table', 1),
	(27, '2019_12_14_000001_create_personal_access_tokens_table', 1),
	(28, '2019_12_22_183558_create_checks_table', 1),
	(29, '2021_06_05_110414_create_finger_devices_table', 1),
	(30, '2023_09_14_112323_create_employee_infos_table', 1),
	(31, '2024_02_23_051750_attendance_info', 1);

-- Dumping structure for table crud-two.overtimes
CREATE TABLE IF NOT EXISTS `overtimes` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `emp_id` int unsigned NOT NULL,
  `duration` time NOT NULL,
  `overtime_date` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `overtimes_emp_id_foreign` (`emp_id`),
  CONSTRAINT `overtimes_emp_id_foreign` FOREIGN KEY (`emp_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crud-two.overtimes: ~0 rows (approximately)

-- Dumping structure for table crud-two.roles
CREATE TABLE IF NOT EXISTS `roles` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `permissions` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crud-two.roles: ~0 rows (approximately)
INSERT INTO `roles` (`id`, `slug`, `name`, `permissions`, `created_at`, `updated_at`) VALUES
	(1, 'admin', 'Adminstrator', NULL, '2024-02-26 06:58:47', '2024-02-26 06:58:47');

-- Dumping structure for table crud-two.role_users
CREATE TABLE IF NOT EXISTS `role_users` (
  `user_id` int unsigned NOT NULL,
  `role_id` int unsigned NOT NULL,
  PRIMARY KEY (`user_id`,`role_id`),
  KEY `role_users_role_id_foreign` (`role_id`),
  CONSTRAINT `role_users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crud-two.role_users: ~0 rows (approximately)
INSERT INTO `role_users` (`user_id`, `role_id`) VALUES
	(1, 1);

-- Dumping structure for table crud-two.schedules
CREATE TABLE IF NOT EXISTS `schedules` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `time_in` time NOT NULL,
  `time_out` time NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `schedules_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crud-two.schedules: ~0 rows (approximately)

-- Dumping structure for table crud-two.schedule_employees
CREATE TABLE IF NOT EXISTS `schedule_employees` (
  `emp_id` int unsigned NOT NULL,
  `schedule_id` int unsigned NOT NULL,
  KEY `schedule_employees_emp_id_foreign` (`emp_id`),
  KEY `schedule_employees_schedule_id_foreign` (`schedule_id`),
  CONSTRAINT `schedule_employees_emp_id_foreign` FOREIGN KEY (`emp_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE,
  CONSTRAINT `schedule_employees_schedule_id_foreign` FOREIGN KEY (`schedule_id`) REFERENCES `schedules` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table crud-two.schedule_employees: ~0 rows (approximately)

