|
 | Email Confirm | ENUM('Y','N') | NotNull | Indicates that a confirmation email should be sent to the sender's email. |
| From Email Address | VARCHAR(50) | Null | The email address used as the from email on the email that is sent out. This email is not necessarily sent a copy of the email but will be used if the receiver wishes to reply to the email. |
| From Name | VARCHAR(40) | Null | The name of the relevant user e.g jtench. |
| Message Id | INTEGER | NotNull | A generated number to identify a message. |
| Message Text | VARCHAR(2000) | NotNull | A message logged on the IRMAC web site |
| Message Timestamp | TIMESTAMP | Null | The time that the message was entered. |
| To Email Address | VARCHAR(50) | Null | The email address to which this message was sent. |
| To Person Id | INTEGER | NotNull | A generated number to identify the person to which the message was sent. |
| To Position Id | INTEGER | NotNull | A generated number to identify the position to which the message was sent. |