-
Notifications
You must be signed in to change notification settings - Fork 1
/
tables
30 lines (28 loc) · 875 Bytes
/
tables
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
ideas
id PK
user_id IDX
topic_id IDX Discussion topic in the forum
title Some summary title
description Text describing the idea
description_uid BBCode UID
description_bitfield BBCode bitfield
description_options BBCode options
cost Cost of proposing the idea
vote_cost Cost per vote
vote_closed Is voting closed?
rejected Is the idea rejected? Useful to keep ideas rejected by the moderators for people to see
ctime Creation time
mtime Modification time
score IDX Auto updated from votes table
votes
id PK
idea_id (UNIQ
user_id UNIQ)
count Number of votes made
value 1 := +ve, -1 := -ve, 0 := deleted
cost Cost of the vote (count * value * ideas.vote_cost)
ctime Creation time
mtime Modification time
voters
id PK
base_points How many points has the user got to start with