Added database structure, moved planning to notes/

[tpg/opendispense2.git] / notes / Database Structure.txt

diff --git a/notes/Database Structure.txt b/notes/Database Structure.txt
new file mode 100644 (file)
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