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. Click a table name in the image to view more information about the table.
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)
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_AdminCommands - (Not used in EFT Server version 6)
AdminCommandID numeric(18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_AdminCommands PRIMARY KEY CLUSTERED,
Time_Stamp datetime NULL ,
TransactionID numeric(18, 0) ,
Login varchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
Data varchar(7800) COLLATE SQL_Latin1_General_CP1_CI_AS 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
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 ,
EventID numeric(18, 0) NOT NULL REFERENCES tbl_EventRules(EventID),
TransactionID numeric(18, 0) NOT NULL References tbl_Transactions(TransactionID) ON DELETE CASCADE
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
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
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 ,
ResultID numeric(18, 0) NOT NULL ,
TransactionID numeric(18, 0) NOT NULL REFERENCES tbl_Transactions(TransactionID) ON DELETE CASCADE
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
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
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 ,
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
ResultID numeric(18, 0) NOT NULL CONSTRAINT PK_tbl_ResultCodes PRIMARY KEY CLUSTERED,
Description varchar(100) NULL ,
Category varchar(10) NULL
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:
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
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
TransactionID numeric(18, 0) IDENTITY (1, 1) NOT NULL CONSTRAINT PK_tbl_Transactions PRIMARY KEY CLUSTERED ,
ParentTransactionID numeric(18, 0) NULL REFERENCES tbl_Transactions(TransactionID),
TransactionObject varchar(50) NOT NULL