notes/Database Structure.txt

   1
   2 User
   3         INTEGER UserID  PRIMARY_KEY
   4
   5         STRING  Username        UNIQUE
   6
   7         STRING  PasswordHash    ; < Hmm... needed?
   8         INTEGER UnixUID UNIQUE
   9         INTEGER PinCode
  10
  11         INTEGER Balance
  12         DATETIME        LastSeen
  13         BOOL    bEnabled
  14         BOOL    bCokeMember
  15         BOOL    bWheelMember
  16         BOOL    bInternal
  17
  18
  19 Card -> User
  20         STRING  CardID  UNIQUE
  21         INTEGER UserID