MAILEXPRESS

Basic Index   Expanded Index

Table Name: medatabase.EftConfigLog
Description: Auditing table for changes to corresponding with table EftConfig.
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.
autoSyncEnabled tinyint None Yes Flag indicating whether or not the system will automatically synchornize configuration with EFT.
encPassword nvarchar (4000) None Yes The EFT user encrypted password.
eventAgeTimeNumber int None Yes The numerical component of the max age of an event before EFT will not process event.
eventAgeTimeUnit nvarchar (255) None Yes The time unit component of the max age of an event; values: MINUTES, HOURS, DAYS, WEEKS, MONTHS, YEARS.
serverHost nvarchar (256) None Yes The EFT server host.
serverPort int None Yes The EFT server port.
serviceEnabled tinyint None Yes Whether or not the EFT functionality is enabled.
site nvarchar (256) None Yes The EFT site to connect through.
username nvarchar (256) None Yes The EFT user credentials.

Index Clustered? Unique? Fields
PK__EftConfi__B55535B70D717793 Yes Yes

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

No primary keys as foreign key constraints
No triggers