Changes within the database will be documented for each dataset with the time and the responsible user in the columns shown in the image below.
All main tables have a corresponding logging
table. If you change or delete a dataset the orignial dataset will be stored in
this logging table together with information about who has done the changes
and when it happend. To inspect the history of a dataset click on the button
(see topic History for further information)
The logging tables (right side in image below) have the same structure as the data tables (left side in image below) and some additional fields (LogState, LogDate, LogUser, LogVersion and LogID) to document the logging as shown in the figure below.
The field LogVersion is only present in tables dependent on a version main table. This main table keeps the version valid for the dataset including data in dependent tables. If a dataset in a dependent table is changed, the version of the main table will be updated and the entries in the logging table for the dependent table will record the version of the main table before the changes took place.