Looking for some Feedback on a DB Design
- by zSysop
I'm currently working on a ticketing system which allows our users to submit tickets based on their own needs. i.e. if Department "A" is submitting a ticket they can have certain types of problem categories (such as "Supplies" or "Printer") along with details pertaining to the chosen category.
I have laid out a partial db design and i was looking for some feedback on it. I've never built a system from the ground up by myself so i'm a little bit nervous.
here's my a draft version of my db design
Issues Table
Id | CreatedBy | CreateDate | Status | Owner | AssignedTo | AssignmentDate |
-----------------------------------------------------------------------------
EquipmentIssueDetails Table
Id | IssueId | Serial # | Make | Model | ....
---------------------------------------------
SupplyIssueDetails Table
Id | IssueId | SupplyId | ItemId | QTY | UnitOfMeasurement
-------------------------------------------------------------
NetworkIssueDetails Table
Id | IssueId | Supervisor | Details |
-------------------------------------------------------------
Notes Table
Id | IssueId | Note | CreatedBy | CreateDate
-------------------------------------------------------------
Thanks in advance