sms table

sms Table (388)

This table will hold outgoing sms messages when transmitted with WebServices

Name	Description	Type	Nullable
id	Primary key	PK	No
sms_text	The actual text to be sent	Clob	Yes
outbox_id	The outbox entry which holds the information about the sms to be sent	FK outbox	No
reference_key	The reference used for delivery report	String(255)	No
session_key	The reference used for identifying a session, like in-reply-to and message-id	String(255)	Yes
delivery_status	Indicates a delivery status for the sms	String(255)	Yes
delivery_status_desc	Indicates a delivery status description for the sms	String(255)	Yes
delivery_ext_status	Indicates extended delivery status for the sms	String(255)	Yes
delivery_ext_status_desc	Indicates extended delivery status description for the sms	String(255)	Yes
delivered_at	The date and time when the sms was delivered	DateTime	Yes
shipment_id	Reference to the shipment id, used for eMarketeer	FK s_shipment	No
customer_id	Reference to the customer id, used for eMarketeer	FK person	No
message_id	Reference to the message id this SMS was sent from	FK ej_message	No
outgoing_message_id	Reference to the outgoing message entry created by netserver for sending and status update	FK outgoing_message	Yes

Table	Description
ej_message	This table contains the messages listed under tickets.
outbox	Outgoing emails with sending status and other info
outgoing_message	Delivery of outgoing messages to messageplugins, updated with status asynchroneously
person	Persons
s_shipment	Contains info about one shipment. The addresses are stored in s_shipment_addr