Database Design: Did you like the table?

Question

Interestingly,
many sites have the ability to love / dislike the message.
even here, of course, on stackoverflow.

so technically this is a big table with sympathy?

user_id    post_id

user_id - who voted
post_id - which post is this

is it all about?
big table? Is there something more efficient / complex?

+5

socksocket Aug 4 '12 at 12:28

2 answers

, . COUNT() , .

, , , COUNT(), COUNT().

, , .

, , .. , , , .

+1

Gustavo pinsard Aug 4 '12 at 13:21

Brian Hoover · Accepted Answer · 2012-08-04T12:35:47+0000

He has the most basic level, yes, that all this is.

But then it begins to expand, trying to answer questions such as:

.