We're a community of 1.1M IT Pros here for help, advice, solutions, professional growth and fun. Join us!
1,080,449 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Start New Discussion Reply to this Discussion

Escalation

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
11 Hours
Discussion Span
1 Year Ago
Last Updated
2
Views
Zhakes
Newbie Poster
1 post since Mar 2012
Reputation Points: 0
Solved Threads: 0
Skill Endorsements: 0

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 ?

adam_k
Veteran Poster
1,057 posts since Jun 2011
Reputation Points: 274
Solved Threads: 205
Skill Endorsements: 11

This article has been dead for over three months: Start a new discussion instead

Post: Markdown Syntax: Formatting Help
 
You
 
© 2013 DaniWeb® LLC
Page generated in 0.0402 seconds using 2.45MB