X-Git-Url: https://git.ucc.asn.au/?a=blobdiff_plain;f=notes%2FDatabase%20Structure.txt;fp=notes%2FDatabase%20Structure.txt;h=9365b45903233199f024797cc0a41b43a4e7dfe8;hb=6b194d420f1554ace61a251f2c416712d68ab633;hp=0000000000000000000000000000000000000000;hpb=0a4c98ea7934d4fb61121fb8cf8c4d94f973b950;p=tpg%2Fopendispense2.git

diff --git a/notes/Database Structure.txt b/notes/Database Structure.txt
new file mode 100644
index 0000000..9365b45
--- /dev/null
+++ b/notes/Database Structure.txt	
@@ -0,0 +1,19 @@
+
+User
+	INTEGER	UserID
+	STRING	Username
+	
+	STRING	PasswordHash	; < Hmm... needed?
+	INTEGER	PinCode
+	
+	INTEGER	Balance
+	DATETIME	LastSeen
+	BOOL	bEnabled
+	BOOL	bCokeMember
+	BOOL	bWheelMember
+	BOOL	bInternal
+	
+	
+Card -> User
+	STRING	CardID
+	INTEGER	UserID