|
|
|
This table defines the relationship between an event and any users associated with the event. The user association may be via the Wgn3Address table and/or the WgnUserLogin table. Note that a user association via the WgnUserLogin table is true only for 'client-captured' events. Note from schema version 3.50 the columns addressuid1 and addressuid2 are mandatory, therefore it can be assumed that all wgn3eventparticipant rows have a corresponding wgn3address row irrespective of the type of event. Events that would not naturally have an associated address such as, a web event will have an address generated based on the user information.
|
Column |
Primary Key |
Datatype |
Length |
Notes |
|---|---|---|---|---|
|
EventUID Key used to uniquely identify a captured or imported event. |
Yes |
IDENTITYDEF |
13 |
Foreign key: Wgn3Event |
|
ParticipantIndex Part-key used to identify an event participant. |
Yes |
INTEGER |
4 |
|
|
EventTimestamp The time at which the event occurred. |
Yes |
TIMESTAMP |
8 |
Foreign key: Wgn3Event |
|
AddressUID1 Part-key used to uniquely identify an email address or the address of an IM participant. |
|
DECIMAL |
13 |
Foreign key: Wgn3Address |
|
AddressUID2 Part-key used to uniquely identify an email address or the address of an IM participant. |
|
DECIMAL |
13 |
Foreign key: Wgn3Address |
|
ParticipantNodeUID The classification of the participant. |
|
INTEGER |
4 |
Foreign key: Wgn3ClassificationNode |
|
InterventionNodeUID The classification that CA DLP assigns to the participant. |
|
INTEGER |
4 |
Foreign key: Wgn3ClassificationNode |
|
LoginIDM Part-key that indicates the participant who generated the event. |
|
INTEGER |
4 |
Foreign key: WgnUserLogin |
|
LoginID Part-key that indicates the participant who generated the event. |
|
INTEGER |
4 |
Foreign key: WgnUserLogin |
| Copyright © 2011 CA. All rights reserved. | Email CA Technologies about this topic |