The tables created during installation are listed below. Because all of EFT Server's modules and features are available during the trial, all of the tables below are created, even if you do not activate that module/feature. The attached PDF provides a view of the relationships between tables.
tbl_Actions - Logs Actions performed when Event Rules are processed
ActionID numeric(18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_Actions PRIMARY KEY CLUSTERED,
Time_stamp datetime NOT NULL ,
SiteName varchar(50) NULL ,
EventName varchar(50) NULL ,
ActionType varchar(50) NULL ,
Parameters varchar(1000) NULL ,
IsFailedAction bit NULL ,
ResultID numeric(18, 0) NOT NULL ,
EventID numeric(18, 0) NOT NULL ,
TransactionID numeric(18, 0) NOT NULL REFERENCES tbl_Transactions(TransactionID) ON DELETE CASCADE,
Details varchar(1000)
tbl_AdminActions - Logs Actions performed by administrators in EFT Server
ID numeric(18, 0) IDENTITY(1,1) NOT NULL,
Timestamp datetime NULL,
FunctionName varchar(200) NULL,
Action varchar(200) NULL,
AffectedArea varchar(200) NULL,
AffectedName varchar(200) NULL,
ChangeOriginator varchar(200) NULL,
TransactionID numeric(18, 0) NULL,
SiteName varchar(300) NULL
tbl_AS2Actions - Contains information about separate Actions for each AS2 transaction:
ActionID numeric(18, 0) identity
TransactionID numeric(18, 0)
ActionStatus numeric(18, 0)
ActionType numeric(18, 0)
ErrorCode varchar(1000)
TimeStamp datetime
FileID numeric(18, 0)
tbl_AS2Files - Contains information about files transferred via AS2:
FIleID numeric(18, 0) identity
TransactionID numeric(18, 0)
FileName varchar(300)
ContentType varchar(50)
LocalPath varchar(300)
RemotePath varchar(300)
tbl_AS2Transactions - Contains details of AS2 Transactions:
TransactionID numeric(18, 0) identity
MIC varchar(100) (EFT Server calculates the AS2 MIC using SHA-1. You can ignore the words "MD5" that appear in the MIC column of the AS2-related reports.)
StartTime datetime
CompleteTime datetime
Direction numeric(18, 0)
MDN text
MDNSignatureType varchar(50)
MDNType numeric(18,0)
LocalHost varchar(300)
RemoteHost varchar(300)
TransactionStatus numeric(18,0)
SiteName varchar(300)
FromAS2ID varchar(300)
ToAS2ID varchar(300)
ErrorCode varchar(1000)
PayloadSignatureType varchar(50)
PayloadEncryptionType varchar(50)
PayloadHeaders text
MDNAS2MessageID varchar(300)
PayloadAS2MessageID varchar(300)
MDNHTTPResponse text
tbl_Authentications - Logs authentication attempts for administrators and users per site>
AuthenticationID numeric(18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_Authentications PRIMARY KEY CLUSTERED,
Time_stamp datetime NOT NULL ,
RemoteIP varchar(15) NOT NULL ,
RemotePort numeric(18, 0) NULL ,
LocalIP varchar(15) NOT NULL ,
LocalPort numeric(18, 0) NULL ,
Protocol varchar(50) NULL ,
SiteName varchar(50) NULL ,
UserName varchar(50) NULL ,
PasswordHash varchar(500) NULL ,
SettingsLevels varchar(500) NULL ,
ResultID numeric(18, 0) NOT NULL ,
TransactionID numeric(18, 0) NOT NULL References tbl_Transactions(TransactionID) ON DELETE CASCADE
tbl_ClientOperations - Logs upload/download/create/etc Actions performed by clients (FTP, HTTP, etc)
ClientOperationID numeric (18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_ClientOperations PRIMARY KEY CLUSTERED ,
Time_stamp datetime NOT NULL ,
Protocol varchar(50) NULL ,
RemoteAddress varchar(50) NULL ,
RemotePort numeric (18, 0) NULL ,
Username varchar(50) NULL ,
RemotePath varchar(500) NULL ,
LocalPath varchar(500) NULL ,
Operation varchar(50) NULL ,
BytesTransferred numeric (18, 0) NULL ,
TransferTime numeric (18, 0) NULL ,
ResultID numeric (18, 0) NOT NULL ,
TransactionID numeric (18, 0) NOT NULL REFERENCES tbl_Transactions(TransactionID) ON DELETE CASCADE
LogFileName
tbl_CustomCommands - Logs details of custom commands being executed. These are typically launched by Event Rules
CustomCommandID numeric(18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_CustomCommands PRIMARY KEY CLUSTERED,
Time_stamp datetime NOT NULL ,
SiteName varchar(50) NULL ,
Command varchar(50) NULL ,
CommandParameters varchar(1000) NULL ,
ExecutionTime numeric(18, 0) NULL ,
ResultID numeric(18, 0) NOT NULL ,
TransactionID numeric(18, 0) NOT NULL REFERENCES tbl_Transactions(TransactionID) ON DELETE CASCADE
tbl_EventRules - Logs details of Event Rules that have been processed
EventID numeric(18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_EventRules PRIMARY KEY CLUSTERED,
Time_stamp datetime NOT NULL ,
SiteName varchar(50) NULL ,
EventName varchar(50) NULL ,
EventType varchar(50) NULL ,
ConditionValues varchar(1000) NULL ,
TransactionID numeric(18, 0) NOT NULL REFERENCES tbl_Transactions(TransactionID) ON DELETE CASCADE
EventGUID numeric(18, 0) NOT NULL
tbl_Groups - Provides plain text group name for reporting (part of db normalization)
GroupID numeric(18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_Groups PRIMARY KEY CLUSTERED,
GroupName varchar(50) NULL ,
AuthenticationID numeric(18, 0) NOT NULL REFERENCES tbl_Authentications(AuthenticationID) ON DELETE CASCADE
tbl_PCIViolations - Logs PCI violations for PCI DSS compliance testing reports
PCIViolationID numeric(18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_PCIViolations PRIMARY KEY CLUSTERED,
Time_Stamp datetime NULL ,
ViolationID int NULL ,
SiteName varchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
SettingsLevel varchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
UserName varchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
Admin varchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
Reason varchar(500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
tbl_ProtocolCommands - Logs detailed client commands sent for various protocols (ftp, http, etc)
ProtocolCommandID numeric(18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_ProtocolCommands PRIMARY KEY CLUSTERED,
Time_stamp datetime NOT NULL ,
RemoteIP varchar(15) NULL ,
RemotePort numeric (18,0) NULL ,
LocalIP varchar(15) NULL ,
LocalPort numeric (18,0) NULL ,
Protocol varchar(50) NULL ,
SiteName varchar(50) NULL ,
Command varchar(10) NULL ,
CommandParameters varchar(1000) NULL ,
FileName varchar(500) NULL ,
VirtualFolderName varchar(500) NULL ,
PhysicalFolderName varchar(500) NULL ,
IsInternal
FileSize numeric(18, 0) NULL ,
TransferTime numeric(18, 0) NULL,
BytesTransferred numeric(18, 0) NULL ,
ResultID numeric(18, 0) NOT NULL ,
TransactionID numeric(18, 0) NOT NULL REFERENCES tbl_Transactions(TransactionID) ON DELETE CASCADE
tbl_ResultCodes
ResultID numeric(18, 0) NOT NULL CONSTRAINT PK_tbl_ResultCodes PRIMARY KEY CLUSTERED,
Description varchar(100) NULL ,
Category varchar(10) NULL
tbl_SAT_Emails - Logs the notification e-mails sent by the SAT module
ID numeric(18, 0) IDENTITY (1, 1) NOT NULL ,
txid int NOT NULL ,
email varchar (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
emailType int NULL
"emailType" is a "0" for TO:, "1" for CC:, "2" for BCC:
tbl_SAT_Files - Logs the files uploaded by the SAT module
id numeric(18, 0) IDENTITY (1, 1) NOT NULL ,
txid int NOT NULL ,
filename varchar (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
filesize bigint NULL
tbl_SAT_Transactions - Audits transactions managed by the Secure Ad Hoc Transfer (SAT) module.
ID numeric(18, 0) IDENTITY (1, 1) NOT NULL ,
time_stamp datetime NULL ,
fromEmail varchar(80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
subject varchar(255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
body varchar(5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
tempUserName varchar(40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
siteName varchar(80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
expiryDays int NULL ,
tempPassword varchar(80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
transactionGUID uniqueidentifier NULL,
reserved1 varchar(2000) NULL,
reserved2 varchar(2000) NULL
ServerInternalEventID numeric(18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_ServerInternalEvents PRIMARY KEY CLUSTERED,
Time_Stamp datetime NULL ,
SiteName varchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
SettingsLevel varchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
UserName varchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
EventName varchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
Parameters varchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
tbl_SocketConnections - Logs details (ip addresses, port numbers, etc) of individual socket connections for various protocols (ftp, http, etc).
SocketID numeric(18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_SocketConnections PRIMARY KEY CLUSTERED,
Time_stamp datetime NOT NULL ,
RemoteIP varchar(15) NULL ,
RemotePort numeric (18,0) NULL ,
LocalIP varchar(15) NULL ,
LocalPort numeric(18, 0) NULL ,
SiteName varchar(50) NULL ,
ResultID numeric(18, 0) NOT NULL ,
TransactionID numeric(18, 0) NOT NULL REFERENCES tbl_Transactions(TransactionID) ON DELETE CASCADE
tbl_Transactions - Provides transaction references to correlate data from various ARM tables
ParentTransactionID numeric(18, 0) NULL REFERENCES tbl_Transactions(TransactionID),
TransactionObject varchar(50) NOT NULL
TransactionGUID numeric(18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_Transactions PRIMARY KEY CLUSTERED ,