SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Hybrid View

  1. #1
    ALT.NET - because we need it silver trophybronze trophy dhtmlgod's Avatar
    Join Date
    Jul 2001
    Location
    Scotland
    Posts
    4,836
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Database Schema for my new site

    I've just finished a logical database schema for a new site I'm working on (avatars2go.com).

    People can join the site and upload avatars and let other people comment on them, download them, etc. etc. standard stuff right now really. Anyway, I'm trying to make the db as robust a possible, so I can easily add stuf without having to worry about th db much.

    Anyway, here it is,:

    http://e4ums.oreosnbeer.com/aspnet/avatar2go_d1.gif

    And remember, it's only the first draft, so feel free to rip it apart and show me how your actually supposed to design a db.


  2. #2
    Database Jedi MattR's Avatar
    Join Date
    Jan 2001
    Location
    buried in the database shell (Washington, DC)
    Posts
    1,107
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    What is 'status' used for? Why is it tied to users and comments? Is it really many-to-many (can a user have many statuses assigned to them?)?

    Comments, if I am reading your description correctly, are not many-to-many. You won't have a single comment being paired up with many images and vice versa, so the image2comment table seems redundant (store an imageID in the comment table?).

    numofimages is denormalized -- is that necessary? Same thing with numberrated in image table.

    Looks good.

  3. #3
    ALT.NET - because we need it silver trophybronze trophy dhtmlgod's Avatar
    Join Date
    Jul 2001
    Location
    Scotland
    Posts
    4,836
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Good point about the numofimages and numberrated, I'll take them out. The userID waqs automatically carried over by Visio, and I didn't notice it, so it's not supposed to be there.

    And the tblImages2Comments is redundent, I'll take that out.

    Thanks.



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
  •