Member Avatar for Zhakes

Hello everyone!
I am trying create some table for ticket escalations.Escalation have more than 5 levels.. There is two table example:

  table_escalation
 id serviceId ownerId

  table_level
  id escalationId levelId currentUserId userLevelId

I need advice: if this good structure.

  • 2 Contributors
  • 1 Reply
  • 74 Views
  • 11 Hours Discussion Span
  • Latest Post Latest Post by adam_k
Member Avatar for adam_k

I'd like to have more info on the tables involved (how these 2 join to each other and how they join to the tickets table).
It would also be nice to give us a brief explanation on what each field means to you (don't assume we all understand the same by ownerId or whatever).
Also wouldn't you want to keep a datetime on the escalation history and the user assigned ?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.