MAILEXPRESS

Basic Index   Expanded Index

Table Name: medatabase.ReplyConfigLog
Description: Auditing table for changes to corresponding with table ReplyConfig.
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.
requireVerifiedUser tinyint None Yes Whether or not users must log in to use the portal.

Index Clustered? Unique? Fields
PK__ReplyCon__B55535B7241FD2C1 Yes Yes

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

No primary keys as foreign key constraints
No triggers