The forums ran from 2008-2020 and are now closed and viewable here as an archive.

Home Forums Back End User voting system problem 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.

vote_id (PK)
user_id (FK)
voted_by_id (FK)

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?