Defines an email or IM address for a user. A user can have multiple addresses; the actual address is stored separately in the Wgn3Address table, allowing multiple addresses to be referenced by the same user. Note from schema version 3.50 it is possible for this table to contain associations with system generated addresses derived from the user details. These type of associated address can be distinguished by using the address type value.
|
Column |
Primary Key |
Datatype |
Length |
Notes |
|
|---|---|---|---|---|---|
|
UserIDM Part-key that uniquely identifies a CA DataMinder user. |
Yes |
INTEGER |
4 |
None Foreign key: Wgn3User |
|
|
UserID Part-key that uniquely identifies a CA DataMinder user. |
Yes |
INTEGER |
4 |
Foreign key: Wgn3User |
|
|
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 |
|
|
Defines the 'type' of address |
|
INTEGER |
4 |
Follow the hyperlink. |
|
|
Copyright © 2014 CA.
All rights reserved.
|
|