Guest User

Untitled

a guest
Jan 21st, 2018
168
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.73 KB | None | 0 0
  1.  
  2. InterventionRequest(327) (sent on 1/10/2011) by client(89)
  3. Faults:
  4. 1)bikeframe(7): frame is broken
  5. 2)ights(13): frontlight broken
  6.  
  7. //-----------------------------------------------------------------
  8.  
  9. Admin(91) plans: tech(93) for InterventionRequest(327) on 2/10/2011
  10.  
  11. //-----------------------------------------------------------------
  12. InterventionRequest(327)
  13. 1)bikeframe(7)
  14. a)frame is broken (1/10/2011 by client(89) )
  15. b)fixed frame (2/10/2011 by tech(93))
  16. c)frame still broken (3/10/2011 by client(89) )
  17. d)will send better tech (4/10/2011 by admin(91)) (Admin plans: tech2 for InterventionRequest(327) on 5/10/2011)
  18. e)fixed frame again (5/10/2011 by tech(94))
  19. f)frame is ok now (5/10/2011 by client(89) )
  20.  
  21. 2)lights(13)
  22. a)frontlight broken (1/10/2011 by client(89) )
  23. b)replaced bulb (2/10/2011 by tech(93))
  24. c)light is ok now (3/10/2011 by client(89) )
  25.  
  26. //-----------------------------------------------------------------
  27.  
  28. Admin(91) marks InterventionRequest(327) as finished on 5/10/2011 because all problems are solved.
  29.  
  30. //-----------------------------------------------------------------
  31.  
  32. InterventionsHistory (maybe better call this Comments/Operations?)
  33.  
  34. Table Comments/Operations:
  35.  
  36. ID faultID interventionID Comment User Date Status
  37. 1 7 327 frame is broken 89 1/10/2011 0
  38. 2 7 327 fixed frame 94 2/10/2011 1
  39. 3 7 327 frame still broken 89 3/10/2011 0
  40. 4 7 327 will send better tech 91 4/10/2011 0
  41. 5 7 327 fixed frame again 94 5/10/2011 1
  42. 6 7 327 frame is ok now 89 5/10/2011 1
  43. 7 13 327 frontlight broken 89 1/10/2011 0
  44. 8 13 327 replaced bulb 93 2/10/2011 1
  45. 9 13 327 light is ok now 89 3/10/2011 1
Add Comment
Please, Sign In to add comment