-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathPlanning.txt
97 lines (85 loc) · 1.47 KB
/
Planning.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
Specification:
User Registration
Name, Email, Password
User Authentication
Email, Password (store it with a salt and a sha1)
Adding Bills
Name, Ammount
Splitting Bills Between Relevant Persons
Settling Payment Between Persons
Displaying Bill Status
Pending/Paid, Balances
Notifications
New Bills, Money Owed, Bill Completion
Site Layout
+index.php
+header.php
+footer.php
+register.php
+registerProcess.php
+login.php
+loginProcess.php
+security.php
+bills.php
+newBill.php
+viewBill.php
+groups.php
newGroup.php
viewGroup.php
notifications.php
+profile.php
Database Structure - coop.db
users
userID PK AI NN UN
username
name
pass
salt
email
createTS
lastlogTS
groups
groupID PK AI NN UN
name
createTS
editTS
groupUserRel
userID PK FK NN
groupID PK FK NN
perm (0=owner, 1=member) Owner can add/remove members and dissolve group
enabled
bills
billID PK AI NN UN
name
total
typeID
createTS
editTS
dueTS
billTypes
typeID
name
icon (filepath)
billContributors
billID PK FK
userID PK FK
groupID FK (Only added if a group is added to contribute to a bill)
perm (0=owner, 1=member) Owner adds/removes members and sets contributions
ammount Money
paid Boolean
recieved Boolean
notification
notiID PK
userID PK FK
checked Boolean
addTS
notiTypeID FK
notiTypes
notiTypeID PK
filler
notiBill
notiID PK FK
billID PK FK
notiGroup
notiID PK FK
groupID PK FK