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