Database Schema and Views Reference Guide › Database Tables › Wgn3Address

Wgn3Address

This table contains all the strings that CA DataMinder has identified as addresses. Each address is assigned a unique ID, which is used by other tables that need to hold a reference to an address. The contents of this table are typically email addresses, although other types of address (including IM participant data) can also be stored in here. It is mandatory that all addresses are stored using lower case letters, although this is not enforced in the schema.

Note from schema version 3.50 events that are captured that do not have a natural address such as Web page will have an address automatically created that can be used to define the relationship between the user and the event. These addresses have an address name value of a specific format which is:-

/user_auto_addr=<x,y> where x and y are the unique identifier of the user.

These addresses are purely internally generated and can be recognized by having a value of 1 for address type in the WGN3UserAddressEx table.