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.
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.
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.
maxAttachmentCount int None Yes The maximum number of attachments for the Mail Express Internal portal.
maxAttachmentCountEnabled tinyint None Yes Whether or not the maximum attachment count is enabled for the Mail Express Internal Portal.
maxSize numeric (38, 2) None Yes The maximum size of an attachment.
serviceEnabled tinyint None Yes Whether or not this portal is enabled.
enableCaptcha tinyint None Yes Whether or not the captcha is enabled.
restrictRecipientDomains tinyint None Yes Whether or not the recipients are restricted to a set of domains.
internalUsersAreVerified tinyint None Yes If true, automatically created internal users (e.g. LDAP-backed users) default to having drop-off portal access.
limitNumberOfRecipients tinyint None Yes Whether or not to place a limit on the number of recipients.
maxNumberOfRecipients int None Yes The maximum number of recipients.
requireVerifiedUser tinyint None Yes Whether or not users must log in to use the portal.

Index Clustered? Unique? Fields
PK__DropoffC__B55535B77C46EB91 Yes Yes

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