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. |