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__D112ED494AAF8FFD Yes Yes
UQ__Client__1A733BF94D8BFCA8 No Yes

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