Hi everyone,
Could you give me an idea about the principle of creation a tracking db. The idea is in the framework of 'total quality control' to create a db including recording the presence, username and datatime of a given procedure.
For example, three procedures are to be executed. Two transfer points between them have to be monitored (presence/absence, executor (user), data/time, maybe the place).
From the simple point of view, the object (a sample, for example) is recorded in the mastertable. Each transfer point between procedures is considered as a detail table with the use of user name, now(), etc.
However, may somebody have an experience in such a db to find more complete or more elegant solution?
