Ozeki Database Table layout
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 nameThe name of the database is ozekisms.
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.
|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, ...|
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.
|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|
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.)
|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|
NoteYou can add other tables to these tables.
- ASP.NET and MS SQL Server
- SQL SMS API
- Set MS SQL Server authentication mode
- Create database and user
- Data field change
- IP SMS Gateway
- Supported phones and GSM devices
- Message statuses in database
- Database table layout
- Run the SQL SMS example
- Feature list of the Ozeki NG SMS Gateway
- FAQ of the Ozeki NG SMS Gateway