if i click on a profile to leave a feedback it would leave a feedback into that person's user_id, amount of stars and text.. do i need to add another column for reviewer_id? thats the part that is confusing me.
hello all,
this is probably a dumb question .. hope someone can help me understand how to do a user to user rating database where people can rate their transactions between them.
so far... i have 2 tables
user
-id (INT)
-name (VARCHAR)
-review_count (INT)
review
-user_id (INT)
-stars (INT)
-text (VARCHAR)
how do i distinguish who left the review for the person and vice versa since there is 1 user table. would i need to put a reviewer_id into the review table?
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.