Session Table

When a message is sent out and recieved on the remote side this message transaction is stored on both ends in this table. Thus creating an open channel for furter commuications between these systems. This saves the over head of creating the new commuication channel.

QareApplications

AppDir

ChangePassword

Count

CreateAccount

Delegation

DelegationDisplay

DeleteRemote

HelloWorld

Inbox

Logout

Pending

Ping

RemoteAccount

UserGroups

FIELD	TYPE	DESCRIPTION
sessionId	bignit(20) unsigned (PRI)	The session identifier
sessionNo	varchar(79) (UNIQUE)	The unique number associated in identifying an open channel( -(minus) indicates the sending end and +(plus) indicates the recieving end.
inboxId	int(11)	The inbox identifier. May be null.
openingDate	datetime	The session opening date.
userId	int(10) unsigned	The user identifier (The user associated with this session, links to the user table)
applicationId	int(10) unsigned	The application identifier (The application associated with this session)
remotesystemId	int(10) unsigned	The system identifier of the remote system associated with the session.
properties	text	Properties created during messaging