Fiddling with potential database schema

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

diff --git a/notes/Database Structure.txt b/notes/Database Structure.txt
index 9365b45..ba5ac38 100644 (file)
--- a/notes/Database Structure.txt
+++ b/notes/Database Structure.txt
@@ -1,9 +1,11 @@
 
 User
-       INTEGER UserID
-       STRING  Username
+       INTEGER UserID  PRIMARY_KEY
+       
+       STRING  Username        UNIQUE
        
        STRING  PasswordHash    ; < Hmm... needed?
+       INTEGER UnixUID UNIQUE
        INTEGER PinCode
        
        INTEGER Balance
@@ -15,5 +17,5 @@ User
        
        
 Card -> User
-       STRING  CardID
+       STRING  CardID  UNIQUE
        INTEGER UserID