Previous Topic: View StacksNext Topic: WGN_V_GROUP_1

Database Schema and Views Reference Guide › Database Views › Primary Views Definitions › WGN_V_RELATEDEVENT_1

WGN_V_RELATEDEVENT_1

This view provides an interface to the new table Wgn3RelatedEvent. RLS is not applied to this view.

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