MAILEXPRESS

Basic Index   Expanded Index

Table Name: medatabase.Client
Description: The list of clients sessions presently and recently accessing the system via web services.
Primary Keys: identifier
Field Type Defaults Nulls? Comments
identifier numeric - Identity None No Unique ID for an entry.
createdDate datetime None No The original creation data/time for the entry.
modifiedDate datetime None No The last modified date/time for the entry.
version numeric (19) None No The version number for the entry.
ipAddress nvarchar (256) None No The IP Address of the client.
leaseExpiration datetime None No The date/time that the client access license lease will expire for the session.
logonDate datetime None No The original logon date/time for the client session.
actor_identifier numeric (19) None No The unique ID of the user account associated with the client session. Maps to Actor.identifier.

Index Clustered? Unique? Fields
PK__Client__D112ED497FC1AB63 Yes Yes identifier
UQ__Client__1A733BF9029E180E No Yes ipAddress
actor_identifier

No check constraints
Internal Foreign Key Constraint Affected Field Source Table
FK_Client_actor actor_identifier Actor

Primary Key as Foreign Key Constraint Affected Table Affected Field
FK_Package_client Package client_identifier

No triggers

For more information, review the topics in the Contents to the left. If the Contents pane is hidden, click <--Show.

You can also search the Knowledgebase for help, or pose your question in the Globalscape User Forum. Visit the Mail Express Support Center for the most up-to-date information, to view version history, updates, and activation instructions, or to download a PDF of this user guide. For information about Globalscape, visit www.globalscape.com or follow us on Twitter.

Last modified: 07 October 2013 at 9:14:19