9365b45903233199f024797cc0a41b43a4e7dfe8
[tpg/opendispense2.git] / notes / Database Structure.txt
1
2 User
3         INTEGER UserID
4         STRING  Username
5         
6         STRING  PasswordHash    ; < Hmm... needed?
7         INTEGER PinCode
8         
9         INTEGER Balance
10         DATETIME        LastSeen
11         BOOL    bEnabled
12         BOOL    bCokeMember
13         BOOL    bWheelMember
14         BOOL    bInternal
15         
16         
17 Card -> User
18         STRING  CardID
19         INTEGER UserID

UCC git Repository :: git.ucc.asn.au