MAILEXPRESS

Basic Index   Expanded Index

Table Name: medatabase.FileConfig
Description: The configuration for the attachment file store purging functionality.
Primary Keys: identifier
Field Type Defaults Nulls? Comments
enableFullStorageNotification tinyint None No Enables system notification when the attachment store has reached its size quota.
enablePurge tinyint None No 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 No 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) None No The maximum size, in bytes, allotted for the file store.
identifier numeric (19) None No Unique ID for an entry.

Index Clustered? Unique? Fields
PK__FileConf__D112ED4929199208 Yes Yes

No check constraints
Internal Foreign Key Constraint Affected Field Source Table
FKC69F33FE32C87F94 identifier AbstractSingleton

No primary keys as foreign key constraints
No triggers