User
- INTEGER UserID
- STRING Username
+ INTEGER UserID PRIMARY_KEY
+
+ STRING Username NULL, UNIQUE
- STRING PasswordHash ; < Hmm... needed?
- INTEGER PinCode
+ STRING PasswordHash NULL ; < Hmm... needed? (Nah, PAM only)
+ INTEGER UnixUID NULL, UNIQUE
+ INTEGER PinCode NULL
INTEGER Balance
- DATETIME LastSeen
+ DATETIME LastSeen
BOOL bEnabled
BOOL bCokeMember
- BOOL bWheelMember
+ BOOL bDoorMember
+ BOOL bAdministrator ; Database admin (create/delete/lock accounts)
BOOL bInternal
Card -> User
- STRING CardID
+ STRING CardID UNIQUE
INTEGER UserID