Versions Compared

Old Version 1

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

Col #

Column NameData TypeField Length
Not Null?Data Def.Comments
1

ID

NUMBER

22

N

 Primary key2

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 priority5

MESSAGE

VARCHAR2

160

N

 Message content6

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 message13

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 number21

REFERENCE

VARCHAR2

200

Y

  
22

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