| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMBER(10) | Yes | Record ID that uniquely identifies a mail message. |
| DATESENT | No | DATE | No | Date and time the email was sent from the project. |
| SENDERADDR | No | VARCHAR2(252) | No | Email address of the sender. |
| SENDERNAME | No | VARCHAR2(252) | No | Name of the sender. |
| SUBJECT | No | VARCHAR2(1020) | No | Subject line for the email. |
| BODYTEXT | No | CLOB | No | Body of the email. |
| MSGPERRECP | No | NUMBER(1) | No | Flag indicating if a separate email should be sent to each recipient. |
| DATELSTTRY | No | DATE | No | The date and time the last time the server tried to send the email. |
| NUMOFTRIES | No | NUMBER(5) | No | The number of time the server has tried to send the email. |
| MSGHTML | No | NUMBER(1) | No | If the message is to be sent as HTML this field contains the HTML version of the email body. |
| SENDERROR | No | VARCHAR2(1020) | No | Contains the error message of the last attempt to send the email. |
| MSGTYPE | No | NUMBER(5) | No | Contains the message type:
0 - Normal message text
1 - Raw message being forwarded |
| ADDLHEADER | No | CLOB | No | If the message is a raw message being forwarded this field contains the message header. |
| PROJUUID | No | VARCHAR2(152) | No | Contains the universally unique project identifier of the project the email was sent from. |
| PRNTMSGID | No | VARCHAR2(1020) | No | The message id of the parent message in an email thread. |
| ISTRACKED | No | NUMBER(1) | No | Flag indicating if the email is being tracked. |
| CREATEMTHD | No | NUMBER(5) | No | Contains the creation method:
0 - New email
1 - Reply to existing email
2 - Reply to tracked email being forwarded |
| ENTITYTYPE | No | NUMBER(10) | No | Contains the entity type a tracked email was sent in relation to. |
| PRNTMAILID | No | NUMBER(10) | No | Parent tracked email record id. |
| COREITEMID | No | NUMBER(10) | No | Record id of the parent entity. |
| SENDERID | No | NUMBER(10) | No | Record id of the user sending the email. |
| Column name | Primary key | Data type | Not NULL | Note |
| IDRECORD | Yes | NUMBER(10) | Yes | Record ID that uniquely identifies each project within this table. |
| DBDESC | No | VARCHAR2(128) | No | Project description. |
| DBPATH | No | VARCHAR2(1020) | No | Physical path on the server that contains the folders and files for the project. |
| LISTORDER | No | NUMBER(5) | No | Position of the project within the server's project list. |
| ACTIVE | No | NUMBER(1) | No | Flag indicating if project is active on the server. |
| WEBUSER | No | NUMBER(1) | No | Flag indicating if the project should be included in the web client login list. |
| NATIVEUSER | No | NUMBER(1) | No | Flag indicating if the project should be included in the client login list. |
| COMPALW | No | NUMBER(1) | No | Flag indicating if the project should be compacted every time the server is started. |
| COMPONCE | No | NUMBER(1) | No | Flag indicating if the project should be compacted the next time the server is started. |
| PROJTYPE | No | NUMBER(5) | No | Indicated the project type of native or RDBMS. |
| RDBMSCONN | No | NUMBER(10) | No | If the project type is RDBMS this indicates which RDBMS connection to use. |
| TTPROJNAME | No | VARCHAR2(128) | No | Contains the project name. |
| TTPROJUUID | No | VARCHAR2(38) | No | Contains the universally unique project identifier. |
| TTPROJVERS | No | VARCHAR2(10) | No | Contains the project version number. |
| NOTES | No | CLOB | No | Contains the project notes. |