MAILEXPRESS

Basic Index   Expanded Index

Table Name: medatabase.DropoffConfigLog
Description: Auditing table for changes to corresponding with table DropoffConfig.
Primary Keys: identifier
logNumber
Field Type Defaults Nulls? Comments
identifier numeric (19) None No Unique ID for an entry.
logNumber numeric (19) None No Audit log identifier.
accountExpirationTimeNumber int None Yes The numerical component of the period at which account will expire.
accountExpirationTimeUnit nvarchar (255) None Yes The time unit component of the period at which account will expire. Values values: MINUTES, HOURS, DAYS, WEEKS, MONTHS, YEARS.
accountExpirationEnabled tinyint None Yes Whether or not Dropoff accounts can expire.
accountExpirationType nvarchar (255) None Yes Determines how accounts expire.
enableCaptcha tinyint None Yes Whether or not the captcha is enabled.
internalUsersAreVerified tinyint None Yes If true, automatically created internal users (e.g. LDAP-backed users) default to having drop-off portal access.
limitExtensions tinyint None Yes Whether or not to limit the allowed file extensions for attachments.
limitMaxSize tinyint None Yes Whether or not to place a limit on the attachments.
limitNumberOfRecipients tinyint None Yes Whether or not to place a limit on the number of recipients.
linkExpirationTimeNumber int None Yes The numerical component of the period at which package pickup will expire.
linkExpirationTimeUnit nvarchar (255) None Yes The time unit component of the period at which package pickup will expire. Values values: MINUTES, HOURS, DAYS, WEEKS, MONTHS, YEARS.
linkExpirationEnabled tinyint None Yes Whether or not package pickup link expiration is enabled.
maxNumberOfRecipients int None Yes The maximum number of recipients.
maxSize numeric (19) None Yes The maximum size of an attachment.
requireVerifiedUser tinyint None Yes Whether or not users must log in to use the drop-off portal.
restrictRecipientDomains tinyint None Yes Whether or not the recipients are restricted to a set of domains.
serviceEnabled tinyint None Yes Whether or not the drop-off portal is enabled.

Index Clustered? Unique? Fields
PK__DropoffC__B55535B7315906F7 Yes Yes identifier
logNumber

No check constraints
Internal Foreign Key Constraint Affected Field Source Table
FK7CD96C82D247948F identifier AbstractSingletonLog
FK7CD96C82D247948F logNumber AbstractSingletonLog

No primary keys as foreign key constraints
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