Material movement and genealogy

The movement of material and registration of tracking material and genealogy in the database illustrated by an example. The figure below illustrates the situation where two materials exist in one TPU. An extract of the current content of the TrackingMaterial table and the Genealogy table is shown to the right in the figure.

At a point in time (11:37), the material represented by TraMaID 1 starts to move from the first TPU to the second TPU. This is illustrated in the next figure. A new TraMaID 3 is registered in the TrackingMaterial table. This TraMaID represents the part of material that has entered the second TPU.

At time 11:38 all of the first material has left the first TPU and this is indicated by the registration of ExitTime in the TrackingMaterial table. This situation is illustrated in the figure below. Notice that nothing happens in the Genealogy table since the make event has not yet occurred in the second TPU.

At time 11:39, the last part of the second material leaves the first TPU. The situation is illustrated in the last figure. This triggers the make event in the second TPU (by configuration). The ExitTime of TraMaID 2 and the MakeTime of TraMaID 3 are registered. Simultaneously the Genealogy relations are registered, TraMaID 1 and TraMaID 2 are parents of TraMaID 3.