Previous Topic: DiagValueTypeNext Topic: AttrType


Wgn3EA

This table defines additional attributes of an event. Note that most event types do not require any definitions in this table.

Column

Primary Key

Datatype

Length

Notes

EventUID

Key used to uniquely identify a captured or imported event.

Yes

IDENTITYREF

13

Foreign key: Wgn3Event

AttrIndex

Part-key used to identify this event attribute.

Yes

INTEGER

4

Possible values:

0 upwards: Normal event attribute

-1 Primary event ID

-2 Transaction event

-10000 downwards: Site attributes

See AttrType for more details

EventTimeStamp

The time at which the event occurred.

Yes

TIMESTAMP

8

Foreign key: Wgn3Event

AttrType

The type of the attribute.

 

VARCHAR

255

Follow the hyperlink for details.

AttrValue

The attribute value.

 

VARCHAR

255