👤 UTILISATEURS
id_utilisateurPKINT AUTO
nomVARCHAR(50)
prenomVARCHAR(50)
classeVARCHAR(20)
rfid_uidVARCHAR(20) UNQ
fingerprint_idINT
in_lyceeTINYINT(1)
needs_temp_cardTINYINT(1)
📋 SG_ACCESS_LOGS
id_logPKINT AUTO
id_utilisateurFKINT
timestampDATETIME
access_methodENUM(RFID,FP)
access_statusENUM(AUTH,DENIED)
zoneVARCHAR(10)
🪪 SG_TEMPORARY_CARDS
id_tempPKINT AUTO
id_utilisateurFKINT
rfid_uid_tempVARCHAR(20)
expiration_timeDATETIME
created_byFKINT
👑 SG_ACCOUNTS
id_accountPKINT AUTO
usernameVARCHAR(50) UNQ
password_hashVARCHAR(255)
roleENUM(admin,user)
display_nameVARCHAR(100)
📸 SG_PHOTOS
id_photoPKINT AUTO
id_utilisateurFKINT
photo_pathVARCHAR(255)
captured_atDATETIME
event_typeENUM(ENTRY,TEMP,FAIL)
🔔 SG_EVENTS
id_eventPKINT AUTO
event_typeVARCHAR(30)
payloadJSON
created_atDATETIME
read_atDATETIME NULL