Development of a database for a rating system

The application processes users and objects, users evaluate objects with three functions (one speed for each function).

EDIT : the last sentence is unclear: by character I mean criteria shared by all objects

How to effectively create a database for such a system? What are the best database design methods related to the rating system?

what i was thinking about:

Tables:

  • of users
  • objects
  • feat1rates
  • feat2rates
  • feat3rates

and relationships: the object has a lot

  • feat1rates
  • feat2rates
  • feat3rates

The user has a lot

  • feat1rates
  • feat2rates
  • feat3rates
+3
source share
3 answers

, , , , ( ).

, " ", "" "", ObjectID , .

+8

, , , . ( - ).

:

- : , , , , .

- : / .

- , , - / . , / . , .

ObjectFeature - . , "--" .

UserRating - , ObjectFeature . , .

, , , . , , (, , ) .

+7

, . :

Object: ID, ...

// Provided features cannot be shared between objects
ObjectFeature: ID, ObjectID, ... 

User: ID, ...

UserObjectFeatureRating: UserID, ObjectFeatureID, Rating
+4

Source: https://habr.com/ru/post/1706178/


All Articles