SMS_MESSAGES

Owned by Daniel Hostrup Eriksen
Last updated: 10.11.2014 by Søren Duusgaard (Deactivated)

Groups

SMS_MESSAGES

Column NameData TypeField 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_IDNUMBER   With v 9.8
OBJECT_CLASSVARCHAR2100  With v 9.8

Contains all SMS messages sent by the system