git.ucc.asn.au
/
tpg
/
opendispense2.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
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
User
- INTEGER UserID
- STRING Username
+ INTEGER UserID PRIMARY_KEY
+
+ STRING Username UNIQUE
STRING PasswordHash ; < Hmm... needed?
STRING PasswordHash ; < Hmm... needed?
+ INTEGER UnixUID UNIQUE
INTEGER PinCode
INTEGER Balance
INTEGER PinCode
INTEGER Balance
@@
-15,5
+17,5
@@
User
Card -> User
Card -> User
- STRING CardID
+ STRING CardID
UNIQUE
INTEGER UserID
INTEGER UserID
UCC
git Repository :: git.ucc.asn.au