Jump to content

biochar

New Members
  • Content Count

    4
  • Joined

  • Last visited

Posts posted by biochar


  1. 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?

     

     

     

×
×
  • Create New...

Important Information

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.