SQL-Datenmodell (Auditlog)

Overview

Table Details

All timestamps are stored as BIGINT as milliseconds since Unix epoch, are mapped to Java java.time.Instant.

Table dds_result_entry

codeName is prefixed with dds because the name would otherwise conflict with the healthcheck dtos

Column	Database Type	Java Type	Remarks
id	BIGINT NOT NULL PRIMARY KEY	Long
result_id	BIGINT NOT NULL REFERENCES dds_result(id)	Long
status	VARCHAR(255) NOT NULL	String
message	VARCHAR(255)	String
exception	VARCHAR(255)	String
sequence_number	INTEGER NOT NULL	Integer

Table dds_result

Column	Database Type	Java Type	Remarks
id	BIGINT NOT NULL PRIMARY KEY	Long
name	VARCHAR(255) NOT NULL	String
status	VARCHAR(255) NOT NULL	String
timestamp	BIGINT NOT NULL	Instant

Table dds_job_result_entry

Column	Database Type	Java Type	Remarks
id	BIGINT NOT NULL PRIMARY KEY	Long
result_id	BIGINT NOT NULL REFERENCES dds_job_result(id)	Long
status	VARCHAR(255) NOT NULL	String
message	VARCHAR(255)	String
exception	VARCHAR(255)	String
sequence_number	INTEGER NOT NULL	Integer

Table dds_job_result

Column	Database Type	Java Type	Remarks
id	BIGINT NOT NULL PRIMARY KEY	Long
name	VARCHAR(255) NOT NULL	String
status	VARCHAR(255) NOT NULL	String
start_timestamp	BIGINT NOT NULL	Instant
end_timestamp	BIGINT NOT NULL	Instant

Table dds_invocation

Column	Database Type	Java Type	Remarks
id	BIGINT NOT NULL PRIMARY KEY	Long
operation	VARCHAR(255) NOT NULL	String
parameters	JSONB NOT NULL	java.util.Map<String, Object>
started	BIGINT NOT NULL	Instant
finished	BIGINT	Instant
result	VARCHAR(32)	String	success or error.
exception	VARCHAR(255)	String	if error, exception name
user_domain	VARCHAR(255)	String	null if the operations was attempted without a logged in user.
user_id	VARCHAR(255)	String