Groups
SMS_MESSAGES
| Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|
ID | NUMBER | 22 | N | Primary key | |
STATUS_ID | NUMBER | 22 | N | Message status, i.e. 0-pending, 1-sent, 2-cancelled, 3-error, 9-ignored | |
MOBILENUMBER | VARCHAR2 | 20 | N | Destination number | |
PRIORITY | NUMBER | 22 | Y | Message priority | |
MESSAGE | VARCHAR2 | 160 | N | Message content | |
DATECREATE | DATE | 7 | Y | Date of creation | |
DATEMODIFIED | DATE | 7 | Y | Date of modifying message | |
MSGTYPES | NUMBER | 22 | Y | Message type | |
SEND_DATE | DATE | 7 | Y | Date of sending | |
TYPE_ID | NUMBER | 22 | Y | ||
MESSAGE_TYPE | NUMBER | 22 | Y | ||
CC_USER | VARCHAR2 | 50 | Y | User to receive a copy of message | |
RESPONSE | VARCHAR2 | 3000 | Y | Response received | |
LOCKED_BY_PROCESS | VARCHAR2 | 200 | Y | ||
LOCKED_BY_PROCESS_DATE | DATE | 7 | Y | ||
MAILTEMPLATE_ID | NUMBER | 22 | Y | Foreign key referencing MAILTEMPLATE-table | |
SMS_GATEWAY_KEY | VARCHAR2 | 200 | Y | Foreign key referencing SMS_GATEWAY_CONFIG-table | |
RETRIES | NUMBER | 22 | Y | Number of retries | |
MESSAGE_FROM_NAME | VARCHAR2 | 200 | Y | Sender's name | |
SENDER | VARCHAR2 | 80 | Y | Sender's number | |
REFERENCE | VARCHAR2 | 200 | Y | ||
REQUEST | VARCHAR2 | 4000 | Y | Request log | |
| OBJECT_ID | NUMBER | With v 9.8 | |||
| OBJECT_CLASS | VARCHAR2 | 100 | With v 9.8 |