CREATE TABLE IF NOT EXISTS `employee_details` (
  `user_id` int(11) NOT NULL,
  `full_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `birth_date` date DEFAULT NULL,
  `contact_number` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `join_date` date DEFAULT NULL,
  `contract_type` varchar(50) COLLATE utf8mb4_general_ci DEFAULT 'regular',
  `weekly_holiday` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `work_hours_per_week` float DEFAULT NULL,
  `salary_type` varchar(50) COLLATE utf8mb4_general_ci DEFAULT 'monthly',
  `salary_amount` int(11) DEFAULT NULL,
  `bank_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `account_number` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `insurance_national_pension` tinyint(1) DEFAULT 0,
  `insurance_health` tinyint(1) DEFAULT 0,
  `insurance_employment` tinyint(1) DEFAULT 0,
  `insurance_industrial_accident` tinyint(1) DEFAULT 0,
  `health_cert_issue_date` date DEFAULT NULL,
  `health_cert_renewal_date` date DEFAULT NULL,
  PRIMARY KEY (`user_id`),
  CONSTRAINT `fk_employee_details_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;