SitePoint Sponsor |
|
User Tag List
Results 1 to 3 of 3
Thread: Need help with database design
-
Jan 12, 2009, 00:14 #1
- Join Date
- May 2005
- Posts
- 35
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
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
-
Jan 12, 2009, 00:26 #2
- 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
-
Jan 22, 2009, 14:18 #3
- 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