Ozeki Database Table layout

Introduction

This document presents the characteristics of database tables used by Ozeki SMS Gateway. You can learn what each table and its columns can be used for.

Database name

The name of the database is ozekidb.

Incoming messages

The table of incoming messages is filled with data by Ozeki SMS Gateway, using SQL insert statements. The application can freely delete records from it. You can add new columns to the table.

SQL statements are available on their SQL SMS guide pages. (MS SQL Express SMS in and out tables, MySQL SMS tables, Oracle database SMS tables statements, PostgreSQL, SQL Anywhere)



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. 2024-04-23 10:02:13
receivedtime This is the time of receiving the message. 2024-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 SMS Gateway, 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. 2024-04-23 10:02:13
receivedtime Optional This is the time of receiving the message. 2024-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 SMS:TEXT, SMS:WAPPUSH, ...
status Mandatory This denotes the status of the message. send, sending, sent, notsent, delivered, undelivered

Note

You can add other tables to these tables.

More information