SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Wizard Pedro Monteiro's Avatar
    Join Date
    Sep 2002
    Location
    Lisbon
    Posts
    1,393
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    When to use a separate table

    So I am designing a rather large database but more often then not am confronted with the doubt weather I should place a specific field in its own table or not.

    Please bare with me, and imagine your building a database for a review site.

    There is a table that holds the review records that users have given for a particular product, however the reviews that each user provides will also be subject to review from other uses. In reality we are talking about a review of a review, my question is should this field be placed in its a separate table? After-all, i it has nothing to do with the review of the movie itself.

    Now lets take the statistics tables for example. The database will collect statistics regarding reviews, posts, user registrations, etc... Keeping all the stats records in the same table just doesn't feel right, even-tough all of the fields related to statistics. Right now I am placing user stats on one table, reviews stats on another, etc...

    Very interested to hear your opinions.

  2. #2
    From Italy with love silver trophybronze trophy
    guido2004's Avatar
    Join Date
    Sep 2004
    Posts
    9,401
    Mentioned
    147 Post(s)
    Tagged
    4 Thread(s)
    How about giving some table layouts, so we can get an idea of what you're doing?

  3. #3
    SitePoint Wizard Pedro Monteiro's Avatar
    Join Date
    Sep 2002
    Location
    Lisbon
    Posts
    1,393
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hello there guido,
    Should have given the advance warning that I'm no data architect, this is being built in an excel sheet to be handed to a professional after its done, but I would like to deliver it as close as possible to the final conception.

  4. #4
    Non-Member
    Join Date
    Dec 2010
    Location
    /home/pc
    Posts
    186
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Off Topic:


    Quote Originally Posted by Pedro Monteiro View Post
    Please bare with me, and imagine your building a database for a review site.
    Please bare with me == let's get naked

    bare should be bear


  5. #5
    SitePoint Wizard Pedro Monteiro's Avatar
    Join Date
    Sep 2002
    Location
    Lisbon
    Posts
    1,393
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You can imagine a naked database if you want!


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •