Previous Topic: Wgn3MgmtGroupNext Topic: Wgn3Transaction (Deprecated)

Database Schema and Views Reference Guide › Database Tables › Wgn3RelatedEvent

Wgn3RelatedEvent

This table contains custom information that "relates" or groups events together. This table contains custom information that "relates" or groups events together. It is used by the standard search when the “Pre-defined” rollup key is selected.

Column

Primary Key

Datatype

Length

Notes

EventUID

Yes

IDENTITYREF

13

Foreign Key to Wgn3Event

EventTimestamp

Yes

TIMESTAMP

 

The time at which the event occurred.

RelationType

Yes

INTEGER

4

Type of relationship. Arbitrary Integer to allow multiple rows of the same "type" of relationship to exist

RelationIndex

Yes

INTEGER

4

Relationship increment.

RelatedEventUID

 

IDENTITYREF

13

Related Wgn3Event.EventUID record (Not constrained).

RelatedEventTimeStamp

 

TIMESTAMP

 

Related Wgn3Event.EventTimeStamp record (Not constrained).

ApplicationID

 

INTEGER

4

Identifier of the application that created the record