vdsAuditMsgField

The vdsAuditMsgField table contains extra (non-mandatory) audit message fields which may be included in an audit message. It may contain several records for one single audit message (see vdsAuditMsg).

Columns

Table: vdsAuditMsgField table columns
Column name	Data type	Primary key	Nullable	Description
vdsTimeStamp	timestamp	Yes	No	The date and time of the event.
vdsAMID	varchar(32)	Yes	No	32 hex digit AMID (without “0x” prefix).
vdsFieldID	integer	Yes	No	Integer (dataset) ID of optional field.
vdsFieldValue	varchar(1024)	No	Yes	String representation of the optional field value.

Keys

Primary key: (vdsTimeStamp, vdsAMID, vdsFieldID)

Foreign keys: ( vdsTimeStamp, vdsAMID) references vdsAuditMsg (vdsTimeStamp, vdsAMID)

Indexes

Table: vdsAuditMsgField table indexes
Index name	Included fields
Level 0 default)
vdsauditmsgfldidx	vdsTimeStamp vdsAMID vdsFieldID

vdsAuditMsgField

Columns

Keys

Indexes

Resources