Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002
    Posts
    53

    Question Design feedback needed

    Greetings!

    I am currently working on a web project where the business users wanted to have multiple kinds of content (news stories, general articles, emails, letters (memo type), ect...). They then wanted to seperate these articles by a specific "category" that is classified within a department. Finally due to this client having multiple locations, they wanted it to be specific to a particular locale or available to all of the locations if published by the headquarters. Needless to say, I have been beating my head against the wall for a while and wanted to bounce a simple design off of you all.

    Locale
    -- LocId
    -- Blah

    Loc_Dept
    -- LocId
    -- DeptId

    Department
    -- DeptId
    -- Blah

    Dept_Cat
    -- DeptId
    -- CatId

    Category
    -- CatId
    -- ParentId
    -- Blah

    Cat_Content
    -- CatId
    -- ContentId

    Content
    -- ContentId
    -- ContentTypeId
    -- All required fields for all the content types, unless needed by every type then they would be nullable

    ContentType
    -- ContentTypeId
    -- Blah

    Thoughts, Suggestions, Concerns -- All welcome! Thanks in Advance!

    KrustyDeKlown
    KDK

  2. #2
    Join Date
    Sep 2002
    Posts
    53
    Greetings Again!

    I forgot to mention in the last one that they wanted the ability to be able to link one or more images to the content. This eliminated the possibility of an image field in the content table. I then came up with this.

    Content_Img
    -- ContentId
    -- ImgId

    Image
    -- ImgId
    -- Blah

    If you have any suggestions please note that this was supposed to be part of the original message. Thanks!

    Krusty
    KDK

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    the table layouts, in both of your posts, are fine

    at least, they look okay to me


    rudy
    http://rudy.ca/

Posting Permissions

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