notes/Database Structure.txt

   1
   2 User
   3         INTEGER UserID  PRIMARY_KEY
   4
   5         STRING  Username        NULL, UNIQUE
   6
   7         STRING  PasswordHash    NULL    ; < Hmm... needed? (Nah, PAM only)
   8         INTEGER UnixUID         NULL, UNIQUE
   9         INTEGER PinCode         NULL
  10
  11         INTEGER Balance
  12         DATETIME LastSeen
  13         BOOL    bEnabled
  14         BOOL    bCokeMember
  15         BOOL    bDoorMember
  16         BOOL    bAdministrator  ; Database admin (create/delete/lock accounts)
  17         BOOL    bInternal
  18
  19
  20 Card -> User
  21         STRING  CardID  UNIQUE
  22         INTEGER UserID