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