k4pil

Hi there ppl!

I am designing a table in a database and am wandering if any1 has any suggestions to my (very simple) design.

The scenario: I already have customer and product tables working fine. Now, want i need to implement next is a table for case, where case is an instance where a customer needs support.
So everytime a cusotmer needs support i want to create a case which will have a different priority, type, description and unique caseID.
This case needs to be registered to a user.

My table:

case(caseID,priority,type,description)
caseRegistered(regID,caseID,custID) - both caseID and custID are foreign keys.

Sorz about the amount of text.

Thanks in advance as always