Results 1 to 2 of 2

Thread: Forum Design

  1. #1
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778

    Forum Design

    Hi,

    I would like to know how the following points are generally addressed with forums, for example this forum.

    1. Primary Key / Unique for message titles and forum titles.
    Is it ideal to have the forum title as key or ID with forum title being UNIQUE. Also wouldn't each message have the same constraint.

    2. I have seen this done in this and other forums the concept of user's rating's changing depending on their post title. Would this be handled on the DBMS or app.If DBMS i dont think a trigger would be used due to being very inefficent for every message posted etc.

    Comments appreciated.
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  2. #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    additon to previous post.

    "user's rating changed depending on their number of posts"
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

Posting Permissions

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