=== DATABASE DEBUG ===

Total Users: 6
Total Employees: 26
Total Attendance Records: 26

=== USERS ===
ID: 1, Name: Karim bin Mustafa, Email: admin@gmail.com, Role: admin
ID: 2, Name: Muhammad Aziz bin Ahmad, Email: staff@gmail.com, Role: staff
ID: 3, Name: Boon Keat Lim, Email: manager@gmail.com, Role: manager
ID: 4, Name: Raj Kumar Subramaniam, Email: staff1@gmail.com, Role: staff
ID: 5, Name: Nurul Izzah binti Karim, Email: nurul.izzah.binti.karim@restaurant.com, Role: staff
ID: 7, Name: Kasim bin Karim, Email: manager1@gmail.com, Role: manager

=== EMPLOYEES ===
ID: 1, Employee_No: EMP0001, Full_Name: Muhammad Aziz bin Ahmad, User_ID: 2
ID: 2, Employee_No: EMP0002, Full_Name: Siti Nurhaliza binti Hassan, User_ID: 
ID: 3, Employee_No: EMP0003, Full_Name: Raj Kumar Subramaniam, User_ID: 4
ID: 4, Employee_No: EMP0004, Full_Name: Lim Wei Chen, User_ID: 
ID: 5, Employee_No: EMP0005, Full_Name: Fatimah binti Mohd Yusof, User_ID: 
ID: 6, Employee_No: EMP0006, Full_Name: Ahmad Firdaus bin Ibrahim, User_ID: 
ID: 7, Employee_No: EMP0007, Full_Name: Nurul Izzah binti Karim, User_ID: 5
ID: 8, Employee_No: EMP0008, Full_Name: Chong Ming Hao, User_ID: 
ID: 9, Employee_No: EMP0009, Full_Name: Zainab binti Abdullah, User_ID: 
ID: 10, Employee_No: EMP0010, Full_Name: Ravi Shankar Pillai, User_ID: 
ID: 11, Employee_No: EMP0011, Full_Name: Nur Aida binti Roslan, User_ID: 
ID: 12, Employee_No: EMP0012, Full_Name: Tan Jia Hao, User_ID: 
ID: 13, Employee_No: EMP0013, Full_Name: Mohd Hafiz bin Sulaiman, User_ID: 
ID: 14, Employee_No: EMP0014, Full_Name: Ling Mei Ling, User_ID: 
ID: 15, Employee_No: EMP0015, Full_Name: Karim bin Mustafa, User_ID: 1
ID: 16, Employee_No: EMP0016, Full_Name: Siti Zainab binti Ismail, User_ID: 
ID: 17, Employee_No: EMP0017, Full_Name: Boon Keat Lim, User_ID: 3
ID: 18, Employee_No: EMP0018, Full_Name: Amirah binti Azman, User_ID: 
ID: 19, Employee_No: EMP0019, Full_Name: Vikram Singh, User_ID: 
ID: 20, Employee_No: EMP0020, Full_Name: Noraini binti Ramli, User_ID: 
ID: 21, Employee_No: EMP0021, Full_Name: Chew Seng Huat, User_ID: 
ID: 22, Employee_No: EMP0022, Full_Name: Yasmin binti Yusof, User_ID: 
ID: 23, Employee_No: EMP0023, Full_Name: Suresh Kumar, User_ID: 
ID: 24, Employee_No: EMP0024, Full_Name: Nur Farah binti Hamid, User_ID: 
ID: 25, Employee_No: EMP0025, Full_Name: Teo Boon Seng, User_ID: 
ID: 26, Employee_No: EMP0026, Full_Name: try test, User_ID: 

=== ATTENDANCE RECORDS ===
ID: 1, User_ID: 2, Date: 2025-10-14 00:00:00, Employee_No: EMP0001
ID: 2, User_ID: 2, Date: 2025-11-10 00:00:00, Employee_No: EMP0001
ID: 3, User_ID: 2, Date: 2025-11-17 00:00:00, Employee_No: EMP0001
ID: 4, User_ID: 2, Date: 2025-12-01 00:00:00, Employee_No: EMP0001
ID: 5, User_ID: 4, Date: 2025-12-01 00:00:00, Employee_No: EMP0003
ID: 6, User_ID: 2, Date: 2025-12-01 00:00:00, Employee_No: EMP0001
ID: 7, User_ID: 4, Date: 2025-12-01 00:00:00, Employee_No: EMP0003
ID: 8, User_ID: 2, Date: 2025-12-01 00:00:00, Employee_No: EMP0001
ID: 9, User_ID: 4, Date: 2025-12-01 00:00:00, Employee_No: EMP0003
ID: 10, User_ID: 2, Date: 2025-12-01 00:00:00, Employee_No: EMP0001
ID: 11, User_ID: 4, Date: 2025-11-30 00:00:00, Employee_No: EMP0003
ID: 12, User_ID: 2, Date: 2025-11-30 00:00:00, Employee_No: EMP0001
ID: 13, User_ID: 4, Date: 2025-11-30 00:00:00, Employee_No: EMP0003
ID: 14, User_ID: 2, Date: 2025-11-30 00:00:00, Employee_No: EMP0001
ID: 15, User_ID: 4, Date: 2025-11-30 00:00:00, Employee_No: EMP0003
ID: 16, User_ID: 2, Date: 2025-11-29 00:00:00, Employee_No: EMP0001
ID: 17, User_ID: 4, Date: 2025-11-29 00:00:00, Employee_No: EMP0003
ID: 18, User_ID: 2, Date: 2025-11-29 00:00:00, Employee_No: EMP0001
ID: 19, User_ID: 4, Date: 2025-11-29 00:00:00, Employee_No: EMP0003
ID: 20, User_ID: 2, Date: 2025-11-29 00:00:00, Employee_No: EMP0001
ID: 21, User_ID: 2, Date: 2025-12-02 00:00:00, Employee_No: EMP0001
ID: 22, User_ID: 2, Date: 2025-12-15 00:00:00, Employee_No: EMP0001
ID: 23, User_ID: 2, Date: 2025-12-16 00:00:00, Employee_No: EMP0001
ID: 24, User_ID: 2, Date: 2025-12-17 00:00:00, Employee_No: EMP0001
ID: 25, User_ID: 2, Date: 2025-12-17 00:00:00, Employee_No: EMP0001
ID: 26, User_ID: 2, Date: 2025-12-19 00:00:00, Employee_No: EMP0001

=== CHECKING RELATIONSHIPS ===
First Attendance:
  - ID: 1
  - User_ID: 2
  - User Name: Muhammad Aziz bin Ahmad
  - Employee by user_id: EMP0001

Done!