SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast
    Join Date
    May 2005
    Posts
    35
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Red face Need help with database design

    Hi guys,
    I am making a simple complaint management system for my final year project. However I am a little bit weak when it comes to database design. I have already came up with the design which is attached to this post. Just need some feedback . Thank you
    Attached Images Attached Images

  2. #2
    SitePoint Member
    Join Date
    Jan 2009
    Posts
    16
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Its not bad for a one entry complaint system... Personally I would do it like this.

    ComplaintThreads
    --ThreadID
    --StartDate
    --LastUpdate
    --Title
    --Location
    --Status
    --UserID
    --AssignedStaff

    ComplaintDetails
    --ComplaintID
    --ComplaintThread
    --Complaint

    That way I can respond to a customer and keep a chat log going if there is any other information needed along the way. Keeps everything in a thread, etc. Otherwise if your going to keep your format, you need to record the creation date so you can remove expired complaints from the database over time.

    My 2 cent

  3. #3
    SitePoint Enthusiast
    Join Date
    May 2005
    Posts
    50
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Probably want to add a column on the status of complaint (new, assigned, closed)...


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
  •