MAILEXPRESS

Basic Index   Expanded Index

Table Name: medatabase.EftConfig
Description: The configuration for EFT integration.
Primary Keys: identifier
Field Type Defaults Nulls? Comments
autoSyncEnabled tinyint None No 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 No 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.
identifier numeric (19) None No Unique ID for an entry.

Index Clustered? Unique? Fields
PK__EftConfi__D112ED4909A0E6AF Yes Yes

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

Primary Key as Foreign Key Constraint Affected Table Affected Field
FK_EftConfig_syncConfig EftConfig_syncConfig EftConfig_identifier

No triggers