4.6.4 Table Audit vs RDA audit DB tables

Abbreviations, used in manual:

FW - Form Wizard

RDAD - Reference Data Admin Designer

RDAE - Reference Data Admin Editor

This manual explains the difference between the Audit Table option in FW Step 1 and the "rda_audit_..." tables that are created automatically in the quilliup's DB repository as part of quilliup's installation and work process.

For detailed explanation of the Audit Table option in FW Step 1, please refer detailed manual: Form Wizard, Step 1

Note: it's strictly prohibited to perform any change on any of the "rda_audit_..." tables!

There are 3 "rda_audit_..." tables:

 rda_audit_trail - in this table quilliup automatically saves general information about actions that a user performs in the FW's UI in Step 4 / RDAE.
For example, under the "action" column, can be found several action types, such as updating a row from UI , adding a row from UI , deleting a row from UI, bulk upload from excel, deleting all rows from UI , updating all rows from UI.

Note: when uploading data to a FW from an excel file (not Bulk upload), "rda_audit_trail" isn't updated.

Note: when uploading data to a FW from an excel file using Bulk upload), "rda_audit_trail" table is updated and column "duration" contains value in seconds.

rda_audit_changes - in this table automatically are saved all the changes implemented in a specific FW's structure.

rda_audit_keys - in this table automatically are saved all the changes related to the key columns defined on FW level, Step 1.