Need help with database design

[ewokz]

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

[l3vi501]

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

[fossil]

Probably want to add a column on the status of complaint (new, assigned, closed)...