MAILEXPRESS

Basic Index   Expanded Index

Table Name: medatabase.FileConfigLog
Description: Auditing table for changes to corresponding with table FileConfig.
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.
enableFullStorageNotification tinyint None Yes Enables system notification when the attachment store has reached its size quota.
enablePurge tinyint None Yes Whether or not purging of files sent is enabled.
extPurgeDelayTimeNumber int None Yes The numerical component of the threshold at which files sent by external senders will be purged.
extPurgeDelayTimeUnit nvarchar (255) None Yes The time unit component of the threshold at which files sent by external senders will be purged. Values values: MINUTES, HOURS, DAYS, WEEKS, MONTHS, YEARS.
fullStorNotifyDelayTimeNumber int None Yes The numerical component of the period at which notifications will be sent.
fullStorNotifyDelayTimeUnit nvarchar (255) None Yes The time unit component of the period at which notifications will be sent. Values values: MINUTES, HOURS, DAYS, WEEKS, MONTHS, YEARS.
fullStorageThreshold int None Yes The percentage of the file store size quota at which to send a notification.
intPurgeDelayTimeNumber int None Yes The numerical component of the threshold at which files sent by internal senders will be purged.
intPurgeDelayTimeUnit nvarchar (255) None Yes The time unit component of the threshold at which files sent by internal senders will be purged. Values values: MINUTES, HOURS, DAYS, WEEKS, MONTHS, YEARS.
storageQuota numeric (38, 2) None Yes The maximum size, in bytes, allotted for the file store.

Index Clustered? Unique? Fields
PK__FileConf__B55535B72CEA22EC Yes Yes

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

No primary keys as foreign key constraints
No triggers