Versions Compared

Old Version 3

changes.mady.by.user Søren Duusgaard

Saved on

compared with

New Version Current

changes.mady.by.user Søren Duusgaard

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column
width33%

Groups

Wiki Markup
{float:left|width=200px|background=lightgrey|border=solid blue 2px|margin=1px|padding=0px}
{children:page=Rator DB ER Diagram Navigator|depth=1|excerpt=trueindent=1px}
{float}
Column
width33%

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
Column
width33%

Contains all SMS messages sent by the system