ARM Schema

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.

 

tbl_Actions

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

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

tbl_Authentications

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

tbl_ClientOperations

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

tbl_CustomCommands

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

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

tbl_Groups

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

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

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

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

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

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

tbl_ServerInternalEvents

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

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

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