Re: [Mailman-Developers] [HyperKitty] Rating of posts
On Wed, 2012-06-06 at 00:43 -0400, Aamir Khan wrote:
*Database Schema: *Table structure is very straightforward and simple.
Table name : ratings
table structure emailid int| userid int| value (+1/-1)
where, emailid - references to unique entry storing the actual emails. userid - references to unique entry in user table. value - +1 for upvote and -1 for downvote.
In this case each upvote/downvote will be saved as a separate row in database. Your suggestions?
I actually would like to ask you to think at a broader level. Could you provide us a database schema on how it would look ? You would have a user table, I assume, the tables for the archives and I would like you to consider in your design ratings but also the category and tags assigned to the emails.
You can use Dia, inkscape or http://dbdsgnr.appspot.com/app (from which you can export to an image) to draw the database schema.
I have given it some thoughts but I have not found yet a solution that satisfies me, so I would like you to think about it and come up with your design.
Thanks, Pierre
On 2012-06-06 3:24 PM, Pierre-Yves Chibon <pingou@pingoured.fr> wrote:
On Wed, 2012-06-06 at 00:43 -0400, Aamir Khan wrote:
In this case each upvote/downvote will be saved as a separate row in database. Your suggestions?
I actually would like to ask you to think at a broader level. Could you provide us a database schema on how it would look ? You would have a user table, I assume, the tables for the archives and I would like you to consider in your design ratings but also the category and tags assigned to the emails.
I would also like to see a way for each user to be able to rate other *users*, not just their individual posts...
An example with this list: I would rate Mark Sapiro as '5' (or whatever was designated as 'highest value'), so whenever I sort answers to any particular questions, Marks answers should appear at the top of the results before anyone else's (even if someone else's post had a higher rating than Marks for a particular thread) - then would come the individual posts from other users (who I hadn't yet rated)...
Hope that made sense...
participants (2)
-
Pierre-Yves Chibon -
Tanstaafl