a simple set of tables I'm working with now are:
Tickets
-TicketID
-UserID
-CategoryID
-StatusID
TicketMessages
-TicketMessageID
-TicketID
-Message
TicketCategories
-TicketCategoryID
-TicketCategoryParentID (links back to this table on TicketCategoryID)
-Name
[Example Rows]
TicketCategory.Name=Registration (ID=1)
TicketCategory.Name=Purchase (ID=2)
TicketCategory.Name=Purchase . Refund (ID = 3 or 2.3)
TicketCategory.Name=Purchase . Duplicate Charge (ID = 4 or 2.4)
TicketStatus
-TicketStatusID
-Name
_
[Example Rows]
TicketStatus.Name=Unread
TicketStatus.Name=Resolved
TicketStatus.Name=PendingSupervisor
TicketStatus.Name=PendingCustomer_
I can see some use in setting up sub-types for TicketCategories and TicketStatus. But my understanding of sub-types is just beginning.
Should I even worry about sub-types with these tables? Could it help with TicketCategories which is self referencing?