How to implement a data schema for commenting and rating users?

M

malvern2018-06-29 12:44:26

SQL

malvern, 2018-06-29 12:44:26

How to implement a data schema for commenting and rating users?
How to link data, or link is not needed?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

Y

Yan-s, 2018-06-29
@malvern

You need user tables, ratings table and comments table.
Links will be needed in any case (and ratings and comments are linked to the author and recipient). Further, there are options, since the problem statement is imprecise. Can there be multiple ratings from one user? Can there be multiple comments? Are ratings and comments related? If an assessment cannot be without a comment, and a comment without an assessment, then you can combine the table of assessments and comments into one.