Reply To: User voting system problem

[__]

What would be the easiest way to share my DB schema?

I would actually suggest using show create table your_table_name_here;, which will include all relevant information. The column types, for example, are important.

user_votes
vote_id (PK)
user_id (FK)
voted_by_id (FK)
votes

Didn’t you say earlier that each user gets only one vote? If that is the case, then you don’t need a vote_id: you can use the vote_by_id to identify the vote.

What is the votes column for?