Callcenter developers
If you are working on telephone solutions, please check
out the Ozeki VoIP SIP SDK.
It can be used to create: |
Webphone solutions:
- Adobe Flash video phone
- Silverlight video phone
- Web to web calls
- Web to VoIP calls
Custom SIP clients:
- Silverlight SIP VoIP client
- Flash SIP VoIP client
- C# .net SIP VoIP client
- ASP .net SIP VoIP client
- Web based SIP VoIP client
Custom VoIP solutions:
- VoIP SIP softphones
- VoIP call center clients
- VoIP IVR systems
- VoIP predictive dialer systems
- VoIP auto dialer systems
- VoIP call assistant
- VoIP call recording systems
- VoIP intercom solutions
|
Ozeki Database Table layout
Introduction
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.
|
2007-04-23 10:02:13
|
|
receivedtime
|
This is the time of receiving the message.
|
2007-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.
|
2007-04-23 10:02:13
|
|
receivedtime
|
Optional
|
This is the time of receiving the message.
|
2007-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.
Dig deeper!
People who read this also read...
What do status values mean?
Dig deeper!
People who read this also read...
Next page:
State values
|
