Previous Topic: Wgn3EventQueueNext Topic: Wgn3JobHistory

Database Schema and Views Reference Guide › Database Tables › Wgn3IssueParticipant

Wgn3IssueParticipant

This table forms the intersection between Wgn3EventIssue and Wgn3EventParticipant, allowing a Wgn3EventIssue record to be associated with multiple records in Wgn3EventParticipants.

Column

Primary Key

Datatype

Length

Notes

IssueUID

Key used to identify the Issue to which this participant issue is associated.

Yes

IDENTITYREF

13

Foreign Key to Wgn3EventIssue

EventUID

Key used to uniquely identify a captured or imported event.

Yes

IDENTITYREF

13

Foreign Key to Wgn3EventParticipant

EventTimestamp

The time at which the event occurred.

Yes

TIMESTAMP

 

Foreign Key to Wgn3EventParticipant

ParticipantIndex

Key used to identify the participant to which this participant issue is associated.

Yes

INTEGER

4

Foreign Key to Wgn3EventParticipant

Wgn3IssueTrigger

This table forms the intersection between Wgn3EventIssue and Wgn3Trigger, allowing a Wgn3EventIssue record to be associated with multiple records in Wgn3Trigger.

Column

Primary Key

Datatype

Length

Notes

IssueUID

Key used to identify the Issue to which this participant issue is associated.

Yes

IDENTITYREF

13

Foreign Key to Wgn3EventIssue

EventUID

Key used to uniquely identify a captured or imported event.

Yes

IDENTITYREF

13

Foreign Key to Wgn3Trigger

EventTimestamp

The time at which the event occurred.

Yes

TIMESTAMP

 

Foreign Key to Wgn3trigger

TriggerIndex

Key used to identify the Trigger to which this issue Trigger is associated.

Yes

INTEGER

4

Foreign Key to Wgn3EventParticipant