SMS_MESSAGES

Unknown macro: {float}

Col #	Column Name	Data Type	Field Length	Not Null?	Comments
1	ID	NUMBER	22	N	Primary key
2	STATUS_ID	NUMBER	22	N	Message status, i.e. 0-pending, 1-sent, 2-cancelled, 3-error, 9-ignored
3	MOBILENUMBER	VARCHAR2	20	N	Destination number
4	PRIORITY	NUMBER	22	Y	Message priority
5	MESSAGE	VARCHAR2	160	N	Message content
6	DATECREATE	DATE	7	Y	Date of creation
7	DATEMODIFIED	DATE	7	Y	Date of modifying message
8	MSGTYPES	NUMBER	22	Y	Message type
9	SEND_DATE	DATE	7	Y	Date of sending
10	TYPE_ID	NUMBER	22	Y
11	MESSAGE_TYPE	NUMBER	22	Y
12	CC_USER	VARCHAR2	50	Y	User to receive a copy of message
13	RESPONSE	VARCHAR2	3000	Y	Response received
14	LOCKED_BY_PROCESS	VARCHAR2	200	Y
15	LOCKED_BY_PROCESS_DATE	DATE	7	Y
16	MAILTEMPLATE_ID	NUMBER	22	Y	Foreign key referencing MAILTEMPLATE-table
17	SMS_GATEWAY_KEY	VARCHAR2	200	Y	Foreign key referencing SMS_GATEWAY_CONFIG-table
18	RETRIES	NUMBER	22	Y	Number of retries
19	MESSAGE_FROM_NAME	VARCHAR2	200	Y	Sender's name
20	SENDER	VARCHAR2	80	Y	Sender's number
21	REFERENCE	VARCHAR2	200	Y
22	REQUEST	VARCHAR2	4000	Y	Request log

Contains all SMS messages sent by the system