How to properly design a database structure (MYSQL, PHP)?

J

justdance2014-01-08 13:35:05

PHP

justdance, 2014-01-08 13:35:05

There is user data about how users rated it. There are 3 ratings ("1-10", "Hot or Not", "Battle") and an overall score. What is the best way to store such data? There will be a TOP page where you can filter by ratings, by overall rating, so structure and speed are important!

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

I

Ivan Kryak, 2014-01-08
@justdance

Make separate tables for ratings, and store aggregated values in the user table

P

Petr Volkhanov, 2014-01-08
@eprivalov

Have you tried designing a database in MySQL Workbench?