MAILEXPRESS

Basic Index   Expanded Index

Table Name: medatabase.DatabasePurgeConfigLog
Description: Auditing table for changes to corresponding with table DatabasePurgeConfig.
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.
auditLogHistThreshTimeNumber int None Yes The numerical component of the threshold at which the audit log data will be purged.
auditLogHistThreshTimeUnit nvarchar (255) None Yes The time unit component of the threshold at which the audit log data will be purged. Values values: MINUTES, HOURS, DAYS, WEEKS, MONTHS, YEARS.
enableAuditLogPurge tinyint None Yes Enables purging of audit and transaction logs.
enableFullStorageNotification tinyint None Yes Enables system notification when the database has reached its size quota.
sizeNotifPeriodTimeNumber int None Yes The numerical component of the period at which notifications will be sent.
sizeNotifPeriodTimeUnit 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 database size quota at which to send a notification.
storageQuota numeric (38, 2) None Yes The maximum size, in bytes, allotted for the database.

Index Clustered? Unique? Fields
PK__Database__B55535B75CCE4038 Yes Yes

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

No primary keys as foreign key constraints
No triggers