biochar
-
Posts
4 -
Joined
-
Last visited
Posts posted by biochar
-
-
wouldn't the transaction go into the review table?
-
the other person. it's for people swapping items.
IE
i'd review my transaction with you and vice versa -
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?
need help understanding how to setup the tables
in MySQL Help
Posted
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.