INCIDENT
 

Each time an artifact enters the system an incident record is created. This is the lead record for tracking the services performed. Each incident relates to an artifact.

 
INCIDENT  
incident n 10 0 incident ID - 1 for each incident, relates incidents and their pieces to an artifacts history.
datestart d     date incident started
dateend d     date incident ends
loginid c
10
  tech id that opened or is responsible for this incident
memo m     memo about this incident
artifact c 20   Artifact name - which artifact this incident for