|
FIELD
|
TYPE
|
DESCRIPTION
|
|
inboxId
|
int(10) unsigned
|
The row identifier.
|
|
userId
|
int(10) unsigned
|
The user idetifier,the user for whom the message has arrived.
|
|
openingDate
|
datetime
|
The request sending date and time.
|
|
dateReceived
|
datetime
|
The response recieving date and time.
|
|
description
|
tinytext
|
The brief description of the message
|
|
applicationId
|
int(10) unsigned
|
The application identifier,The application responsible for this message.
|
|
action
|
tinytext
|
The action to be held on message.
|
|
fromSystemId
|
int(10) unsigned
|
The message orginator
|
|
message
|
text
|
The message text.
|
|
properties
|
text
|
The message properties needed by many applications.
|
|
gkey
|
varchar(79)
|
The generated key needed by some applications like ping
|