log_table

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
add_dttm timestamp 29,6 null

Timestamp of when the log entry was created.
Stored as: UTC
Logic: Indicates the exact moment the activity occurred or was logged.
Format: YYYY-MM-DD HH:MI:SS.ms

table_name varchar 128 null

The name of the table or database object affected by the activity.
Format: Varchar/Text
Example: tbl_userlogin, tbl_employee, candidate_offer_document_history.

activity bpchar 6 null

A brief description or category of the action that was performed.
Format: Varchar/Text
Example: INSERT, UPDATE, DELETE, LOGIN, ERROR, REPORT GENERATION.

query varchar 2147483647 null

The full SQL query or command executed that resulted in this log entry.
Format: Text
Logic: Stores the executable code for detailed auditing and debugging.

Relationships