This document presents the characteristics of database tables
used by Ozeki NG - SMS Gateway. You can learn what each table and its columns
can be used for.
Database name
The name of the database is ozekisms.
Incoming messages
The table of incoming messages is filled with data by Ozeki
NG, using SQL insert statements. The application can freely delete records
from it. You can add new columns to the table.
ozekimessagein
Column name
Description
Example
id
This distinguishes incoming messages from each other. Every id has
to be different.
1, 2, 3, ...
sender
This is the phone number of the sender of the message.
+36441234567, 06459876543
receiver
This is the phone number of the recipient of the message.
+36441234567, 06459876543
msg
This is the text of the message.
This is a message text.
senttime
This is the time of sending the message.
2021-04-23 10:02:13
receivedtime
This is the time of receiving the message.
2021-04-23 10:02:13
operator
This denotes which service provider connection was used to receive
the message.
Vodafone1
msgtype
This denotes the type of the message.
SMS:TEXT, SMS:WAPPUSH, ...
Outgoing messages
The table of outgoing messages is read by Ozeki NG,
using SQL select statements. SQL update statements are used
to set the statuses of sent messages. This is the table into
which to insert a new row for a message to be sent.
ozekimessageout
Column name
M/O
Description
Example
id
Optional
This distinguishes outgoing messages from each other. Every id has
to be different.
1, 2, 3, ...
sender
Optional
This is the phone number of the sender of the message.
+36441234567, 06459876543
receiver
Mandatory
This is the phone number of the recipient of the message.
+36441234567, 06459876543
msg
Optional
This is the text of the message.
This is a message text.
senttime
Optional
This is the time of sending the message.
2021-04-23 10:02:13
receivedtime
Optional
This is the time of receiving the message.
2021-04-23 10:02:13
operator
Optional
This denotes which service provider connection is to be used to
send out the message. The default is ANY, which means that any of
them can be used. (Then, the program will send out the message
using the first
service provider connection to have the free capacity to do the job.)
ANY Vodafone1
msgtype
Mandatory
This denotes the type of the message. The default is SMS:TEXT