Log
The Log table is used to track modifications in the database. It can be useful in multi-user environments. The table is called LOG.
LDATE
Date and time when the database has been modified.
LUSER
User name that has modified the database.
LTYPE
Operation type:
0: Add an event in animal file
1: Edit an event in animal file
2: Delete an event from animal file
LSUBTYPE
When LTYPE is 0, 1 or 2, LSUBTYPE is an event code. Each event has an internal code, for example 51 for Lambing, 54 for artificial inseminations, ....
IDKEY
It is an internal reference to recover the event record in the database. It is for internal purposes.
DESCRIPTION
Brief description of the modification. It is usually the animal code or internal code, and the event date.