-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               8.0.30 - MySQL Community Server - GPL
-- Server OS:                    Win64
-- HeidiSQL Version:             12.1.0.6537
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


-- Dumping database structure for demigrou_attendpro_tamin
CREATE DATABASE IF NOT EXISTS `demigrou_attendpro_tamin` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `demigrou_attendpro_tamin`;

-- Dumping structure for table demigrou_attendpro_tamin.checkinreason
CREATE TABLE IF NOT EXISTS `checkinreason` (
  `reason_id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `availability` varchar(50) NOT NULL DEFAULT '',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`reason_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- Dumping data for table demigrou_attendpro_tamin.checkinreason: ~7 rows (approximately)
INSERT INTO `checkinreason` (`reason_id`, `name`, `availability`, `created_at`, `updated_at`) VALUES
	(1, 'CyberJayaaaaa', 'Yes', '2024-12-18 01:48:33', '2024-12-18 03:46:51'),
	(2, 'Puchong', 'Yes', '2024-12-18 01:49:02', '2024-12-18 01:49:02'),
	(3, 'Meeting', 'Yes', '2024-12-19 02:48:09', '2024-12-19 02:48:09'),
	(4, 'Site', 'Yes', '2024-12-19 02:48:17', '2024-12-19 02:48:17'),
	(5, 'Training', 'Yes', '2024-12-19 02:48:34', '2024-12-19 02:48:34'),
	(6, 'DemiCoffee', 'Yes', '2024-12-19 02:49:17', '2024-12-19 02:49:17'),
	(7, 'Other', 'Yes', '2024-12-19 02:49:26', '2024-12-19 02:49:26');

-- Dumping structure for table demigrou_attendpro_tamin.designation
CREATE TABLE IF NOT EXISTS `designation` (
  `designation_id` int NOT NULL AUTO_INCREMENT,
  `designation_name` varchar(100) NOT NULL,
  `description` text,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`designation_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- Dumping data for table demigrou_attendpro_tamin.designation: ~1 rows (approximately)
INSERT INTO `designation` (`designation_id`, `designation_name`, `description`, `created_at`, `updated_at`) VALUES
	(1, 'HR MANAGERTEST', 'Manager Designation Test', '2024-12-06 08:06:56', '2024-12-06 08:25:03');

-- Dumping structure for table demigrou_attendpro_tamin.leave_apply
CREATE TABLE IF NOT EXISTS `leave_apply` (
  `leave_apply_id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `leave_type_id` int NOT NULL,
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `return_date` datetime DEFAULT NULL,
  `apply_to` int DEFAULT NULL,
  `total_days` float DEFAULT NULL,
  `days_type` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `halfday_on_enddate` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `halfday_on_startdate` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reason` text COLLATE utf8mb4_general_ci,
  `attachment` varchar(1000) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `applicant_phone_number` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `deviser_phone_number` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `supervisor_approve_status` int DEFAULT NULL,
  `hou_approve_status` int DEFAULT NULL,
  `hod_approve_status` int DEFAULT NULL,
  `hr_approve_status` int DEFAULT NULL,
  `all_status` int DEFAULT NULL,
  `leave_apply_status` int DEFAULT '0',
  `rejectmessage` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `change_reason` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `change_status` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`leave_apply_id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table demigrou_attendpro_tamin.leave_apply: ~22 rows (approximately)
INSERT INTO `leave_apply` (`leave_apply_id`, `user_id`, `leave_type_id`, `created_date`, `start_date`, `end_date`, `return_date`, `apply_to`, `total_days`, `days_type`, `halfday_on_enddate`, `halfday_on_startdate`, `reason`, `attachment`, `applicant_phone_number`, `deviser_phone_number`, `supervisor_approve_status`, `hou_approve_status`, `hod_approve_status`, `hr_approve_status`, `all_status`, `leave_apply_status`, `rejectmessage`, `change_reason`, `change_status`) VALUES
	(1, 18, 2, '2024-03-11 07:04:46', '2024-03-14 00:00:00', '2024-03-15 00:00:00', '2024-03-16 00:00:00', 2, 1, NULL, NULL, NULL, 'personal', '', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, 'test', '1'),
	(2, 4, 4, '2024-03-11 07:31:46', '2024-03-13 00:00:00', '2024-03-13 00:00:00', '2024-03-14 00:00:00', 2, 1, NULL, NULL, NULL, 'Anak msk sekolah', '', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, NULL),
	(4, 6, 4, '2024-03-14 07:59:59', '2024-03-18 00:00:00', '2024-03-18 00:00:00', '2024-03-19 00:00:00', 2, 1, NULL, NULL, NULL, 'Daftar anak masuk tvet', '', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, NULL),
	(5, 4, 4, '2024-03-26 08:25:09', '2024-03-28 00:00:00', '2024-03-28 00:00:00', '2024-03-29 00:00:00', 2, 1, NULL, NULL, NULL, 'Tiada orang jaga anak', '', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, NULL),
	(6, 9, 3, '2024-04-03 02:01:45', '2024-04-03 00:00:00', '2024-04-03 00:00:00', '2024-04-04 00:00:00', 2, 1, NULL, NULL, NULL, 'Medical leave', '20240404101420_IMG_20240404_101300.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, NULL),
	(7, 4, 1, '2024-04-03 08:00:05', '2024-04-11 00:00:00', '2024-04-12 00:00:00', '2024-04-15 00:00:00', 2, 2, NULL, NULL, NULL, 'cuti raya', '', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, NULL),
	(8, 6, 1, '2024-04-03 08:01:35', '2024-04-12 00:00:00', '2024-04-13 00:00:00', '2024-04-15 00:00:00', 2, 2, NULL, NULL, NULL, 'Cuti raya', '', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, NULL),
	(9, 23, 1, '2024-04-03 08:01:36', '2024-04-09 00:00:00', '2024-04-09 00:00:00', '2024-04-15 00:00:00', 4, 1, NULL, NULL, NULL, 'Cuti raya aidilfitri ', '', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, NULL),
	(10, 6, 4, '2024-04-03 08:02:26', '2024-04-08 00:00:00', '2024-04-09 00:00:00', '2024-04-15 00:00:00', 2, 2, NULL, NULL, NULL, 'Cuti raya', '', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, NULL),
	(11, 23, 4, '2024-04-03 08:04:05', '2024-04-12 00:00:00', '2024-04-13 00:00:00', '2024-04-15 00:00:00', 4, 2, NULL, NULL, NULL, 'Cuti raya aidilfitri ', '', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, NULL),
	(12, 6, 4, '2024-04-03 08:04:11', '2024-04-08 00:00:00', '2024-04-09 00:00:00', '2024-04-15 00:00:00', 2, 2, NULL, NULL, NULL, 'Cuti raya', '', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, NULL),
	(13, 4, 4, '2024-04-03 08:08:10', '2024-04-15 00:00:00', '2024-04-15 00:00:00', '2024-04-15 00:00:00', 2, 0.5, NULL, NULL, NULL, 'Hantar anak pergi hospital ½ day', '', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, NULL),
	(14, 4, 4, '2024-04-03 08:09:03', '2024-04-22 00:00:00', '2024-04-22 00:00:00', '2024-04-23 00:00:00', 2, 1, NULL, NULL, NULL, 'Appoitment anak di hospital', '', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, NULL),
	(15, 20, 1, '2024-04-03 08:11:10', '2024-04-08 00:00:00', '2024-04-13 00:00:00', '2024-04-15 00:00:00', 1, 4, NULL, NULL, NULL, 'Cuti Hari Raya Aidil Fitri\r\n', '', NULL, NULL, NULL, NULL, NULL, NULL, 2, 2, 'dsa', NULL, NULL),
	(16, 26, 1, '2024-04-04 01:00:03', '2024-04-12 00:00:00', '2024-04-13 00:00:00', '2024-04-16 00:00:00', 2, 2, NULL, NULL, NULL, 'Cuti raya', '', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, NULL),
	(17, 26, 4, '2024-04-04 01:00:42', '2024-04-15 00:00:00', '2024-04-15 00:00:00', '2024-04-16 00:00:00', 2, 1, NULL, NULL, NULL, 'Cuti raya', '', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, NULL),
	(18, 4, 3, '2024-05-27 03:14:33', '2024-05-27 00:00:00', '2024-05-27 00:00:00', '2024-05-28 00:00:00', 2, 1, NULL, NULL, NULL, 'Tidak sihat', '20240527111433_17167796358768521574610613627890.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, NULL),
	(19, 4, 4, '2024-06-01 00:35:47', '2024-06-01 00:00:00', '2024-06-01 00:00:00', '2024-06-04 00:00:00', 2, 1, NULL, NULL, NULL, 'Jaga Anak', '', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, NULL),
	(20, 10, 1, '2024-06-01 02:32:57', '2024-08-07 00:00:00', '2024-08-17 00:00:00', '2024-08-19 00:00:00', 2, 10, NULL, NULL, NULL, 'Go to Taiwan ', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
	(21, 4, 1, '2024-06-11 01:31:38', '2024-06-18 00:00:00', '2024-06-18 00:00:00', '2024-06-19 00:00:00', 2, 1, NULL, NULL, NULL, 'Anak tdk sihat..muntah2 dan cirit birit..', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL),
	(22, 41, 1, '2024-12-26 00:56:33', '2024-12-26 00:00:00', '2024-12-26 00:00:00', '2024-12-27 00:00:00', 42, 1, NULL, 'FULL', 'FULL', 'TEST', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, 0, NULL, NULL, NULL),
	(23, 42, 1, '2024-12-30 02:23:37', '2024-12-30 00:00:00', '2024-12-31 00:00:00', '2025-01-01 00:00:00', 41, 2, NULL, 'FULL', 'FULL', 'test', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, 0, NULL, NULL, NULL);

-- Dumping structure for table demigrou_attendpro_tamin.leave_entitled
CREATE TABLE IF NOT EXISTS `leave_entitled` (
  `leave_entitled_id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `year_entitled` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `supervisor_employee_id` int DEFAULT NULL,
  `hou_employee_id` int DEFAULT NULL,
  `hod_employee_id` int DEFAULT NULL,
  `hr_employee_id` int DEFAULT NULL,
  `AL` float DEFAULT NULL,
  `balance_last_year` float DEFAULT NULL,
  `carry_forward` int DEFAULT NULL,
  `total_AL` int DEFAULT NULL,
  `EL` float DEFAULT NULL,
  `ML` float DEFAULT NULL,
  `HOSP` float DEFAULT NULL,
  `RL` float DEFAULT NULL,
  `MTL` float DEFAULT NULL,
  `PTL` float DEFAULT NULL,
  `CL` float DEFAULT NULL,
  `CML` float DEFAULT NULL,
  `MGL` float DEFAULT NULL,
  `PI` float DEFAULT NULL,
  `UL` float DEFAULT NULL,
  `TS` float DEFAULT NULL,
  `modified_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`leave_entitled_id`)
) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table demigrou_attendpro_tamin.leave_entitled: ~46 rows (approximately)
INSERT INTO `leave_entitled` (`leave_entitled_id`, `user_id`, `year_entitled`, `supervisor_employee_id`, `hou_employee_id`, `hod_employee_id`, `hr_employee_id`, `AL`, `balance_last_year`, `carry_forward`, `total_AL`, `EL`, `ML`, `HOSP`, `RL`, `MTL`, `PTL`, `CL`, `CML`, `MGL`, `PI`, `UL`, `TS`, `modified_date`) VALUES
	(1, 2, '2024', NULL, NULL, NULL, NULL, 5, 0, 0, 0, 4, 1, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-12-08 08:49:41'),
	(2, 3, '2024', NULL, NULL, NULL, NULL, 6, 0, 0, 0, 6, 6, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-10-30 07:23:54'),
	(3, 4, '2024', NULL, NULL, NULL, NULL, 10, 0, 0, 0, 0, 18, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-04-04 08:50:40'),
	(4, 5, '2024', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-10-22 01:56:33'),
	(5, 6, '2024', NULL, NULL, NULL, NULL, 10, 0, 0, 0, 0, 14, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-04-04 08:50:40'),
	(6, 7, '2024', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-04-04 08:50:40'),
	(7, 8, '2024', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-04-04 08:50:40'),
	(8, 9, '2024', NULL, NULL, NULL, NULL, 2.5, 0, 0, 0, 0, 4, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-04-04 08:50:40'),
	(9, 10, '2024', NULL, NULL, NULL, NULL, 16, 0, 0, 0, 0, 14, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-04-04 08:50:40'),
	(10, 11, '2024', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-04-04 08:50:40'),
	(11, 12, '2024', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-04-04 08:50:40'),
	(12, 13, '2024', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-04-04 08:50:40'),
	(14, 15, '2024', NULL, NULL, NULL, NULL, 14, 0, 0, 0, 0, 22, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-04-04 08:50:40'),
	(15, 16, '2024', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-04-04 08:50:40'),
	(16, 17, '2024', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-04-04 08:50:40'),
	(17, 18, '2024', NULL, NULL, NULL, NULL, 16, 0, 0, 0, 0, 22, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-04-04 08:50:40'),
	(18, 19, '2024', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-04-04 08:50:40'),
	(19, 20, '2024', NULL, NULL, NULL, NULL, 5, 0, 0, 0, 0, 21, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-12-26 17:07:25'),
	(20, 21, '2024', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-04-04 08:50:40'),
	(21, 22, '2024', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-04-04 08:50:40'),
	(22, 23, '2024', NULL, NULL, NULL, NULL, 6, 0, 0, 0, 0, 14, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-04-04 08:50:40'),
	(23, 24, '2024', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-04-04 08:50:40'),
	(24, 25, '2024', NULL, NULL, NULL, NULL, 9, 0, 0, 0, 0, 18, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-04-04 08:50:40'),
	(25, 26, '2024', NULL, NULL, NULL, NULL, 14, 0, 0, 0, 0, 22, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-04-04 08:50:40'),
	(26, 27, '2024', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-04-04 08:50:40'),
	(27, 28, '2024', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-04-04 08:50:40'),
	(28, 29, '2024', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-04-04 08:50:40'),
	(29, 30, '2024', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-04-04 08:50:40'),
	(30, 31, '2024', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-04-04 08:50:40'),
	(31, 32, '2024', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-04-04 08:50:40'),
	(32, 33, '2024', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-04-04 08:50:40'),
	(33, 34, '2024', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-04-04 08:50:40'),
	(34, 35, '2024', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-04-04 08:50:40'),
	(35, 36, '2024', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, '2024-04-04 08:50:40'),
	(36, 37, '2024', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-05-16 01:42:22'),
	(37, 38, '2024', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-06-05 07:33:41'),
	(38, 39, '2024', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-06-05 07:48:36'),
	(39, 40, '2024', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-06-05 07:55:59'),
	(40, 41, '2024', NULL, NULL, NULL, NULL, 0, 0, 0, 0, 10, 5, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, '2024-12-26 01:06:33'),
	(41, 42, '2024', NULL, NULL, NULL, NULL, 1, 1, 3, 2, 1, 1, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-12-30 02:36:25'),
	(42, 43, '2024', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-11-28 08:26:29'),
	(43, 44, '2024', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-11-28 08:26:30'),
	(44, 45, '2024', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-12-04 03:12:36'),
	(45, 46, '2024', NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-12-06 01:58:53'),
	(46, 54, '2024', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-12-30 01:40:26'),
	(47, 55, '2024', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-12-30 01:42:55');

-- Dumping structure for table demigrou_attendpro_tamin.overtime
CREATE TABLE IF NOT EXISTS `overtime` (
  `overtime_id` int NOT NULL AUTO_INCREMENT,
  `employee_id` int NOT NULL,
  `date` date NOT NULL,
  `start_hours` time NOT NULL,
  `end_hours` time NOT NULL,
  `total_hours` time NOT NULL DEFAULT '00:00:00',
  `overtime_for` varchar(255) NOT NULL,
  `reason` varchar(255) DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `rejectmessage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `applyto` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`overtime_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- Dumping data for table demigrou_attendpro_tamin.overtime: ~6 rows (approximately)
INSERT INTO `overtime` (`overtime_id`, `employee_id`, `date`, `start_hours`, `end_hours`, `total_hours`, `overtime_for`, `reason`, `status`, `rejectmessage`, `applyto`, `created_at`, `updated_at`) VALUES
	(1, 41, '2024-12-19', '17:30:00', '20:30:00', '03:00:00', 'ND', 'OT test', '2', '', 42, '2024-12-19 07:31:06', '2024-12-23 07:06:40'),
	(2, 41, '2024-12-19', '18:30:00', '21:01:00', '02:31:00', 'ND', 'TEST', '2', '', 42, '2024-12-19 09:04:11', '2024-12-23 07:19:02'),
	(3, 41, '2024-12-23', '18:00:00', '19:00:00', '01:00:00', 'ND', 'TEST', '3', 'test', 42, '2024-12-23 03:24:07', '2024-12-24 00:45:24'),
	(4, 41, '2024-12-24', '18:00:00', '19:46:00', '01:46:00', 'ND', 'TEST', '2', NULL, 42, '2024-12-24 03:46:07', '2024-12-24 04:07:33'),
	(5, 41, '2024-12-26', '18:00:00', '19:38:00', '01:38:00', 'ND', 'Overtime', NULL, NULL, 43, '2024-12-26 02:38:55', '2024-12-26 02:38:55'),
	(6, 41, '2024-12-27', '18:00:00', '19:51:00', '01:51:00', 'ND', 'Overtime', NULL, NULL, 43, '2024-12-26 02:51:16', '2024-12-26 02:51:16');

-- Dumping structure for table demigrou_attendpro_tamin.slot_timeshift
CREATE TABLE IF NOT EXISTS `slot_timeshift` (
  `slot_id` int NOT NULL AUTO_INCREMENT,
  `start_time` time NOT NULL,
  `end_time` time NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`slot_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- Dumping data for table demigrou_attendpro_tamin.slot_timeshift: ~7 rows (approximately)
INSERT INTO `slot_timeshift` (`slot_id`, `start_time`, `end_time`, `created_at`, `updated_at`) VALUES
	(1, '08:00:00', '10:00:00', '2024-12-13 02:18:50', '2024-12-13 06:42:16'),
	(2, '10:00:00', '13:00:00', '2024-12-13 02:18:50', '2024-12-13 06:42:52'),
	(3, '13:00:00', '15:00:00', '2024-12-13 02:18:50', '2024-12-13 06:44:34'),
	(4, '15:00:00', '17:00:00', '2024-12-13 02:18:50', '2024-12-13 06:45:03'),
	(5, '17:00:00', '19:00:00', '2024-12-13 02:18:50', '2024-12-13 06:45:42'),
	(6, '19:00:00', '21:00:00', '2024-12-13 02:18:50', '2024-12-13 06:46:08'),
	(7, '21:00:00', '22:00:00', '2024-12-13 02:18:50', '2024-12-13 06:46:29');

-- Dumping structure for table demigrou_attendpro_tamin.timetable
CREATE TABLE IF NOT EXISTS `timetable` (
  `time_shift_id` int NOT NULL AUTO_INCREMENT,
  `staff_id` int DEFAULT NULL,
  `day` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `slot_use_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`time_shift_id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- Dumping data for table demigrou_attendpro_tamin.timetable: ~13 rows (approximately)
INSERT INTO `timetable` (`time_shift_id`, `staff_id`, `day`, `slot_use_id`, `created_at`, `updated_at`) VALUES
	(1, 42, 'Wednesday', 4, '2024-12-13 01:30:52', '2024-12-13 07:30:34'),
	(2, 42, 'Tuesday', 1, '2024-12-13 01:36:58', '2024-12-13 07:30:19'),
	(3, 43, 'Tuesday', 2, '2024-12-13 02:18:05', '2024-12-13 09:05:36'),
	(4, 43, 'Monday', 1, '2024-12-13 03:18:11', '2024-12-13 07:29:52'),
	(5, 44, 'Monday', 7, '2024-12-13 03:59:08', '2024-12-13 07:55:22'),
	(6, 44, 'Tuesday', 4, '2024-12-13 04:00:47', '2024-12-13 07:29:40'),
	(7, 3, 'Wednesday', 5, '2024-12-13 04:15:32', '2024-12-13 04:15:32'),
	(9, 2, 'Monday', 2, '2024-12-26 03:21:33', '2024-12-26 03:21:33'),
	(10, 2, 'Monday', 3, '2024-12-26 03:21:33', '2024-12-26 03:21:33'),
	(11, 2, 'Monday', 4, '2024-12-26 03:21:33', '2024-12-26 03:21:33'),
	(12, 2, 'Monday', 5, '2024-12-26 03:21:33', '2024-12-26 03:21:33'),
	(13, 2, 'Monday', 6, '2024-12-26 03:21:33', '2024-12-26 03:21:33'),
	(14, 2, 'Monday', 7, '2024-12-26 03:21:33', '2024-12-26 03:21:33');

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
