sms Table (388)

•
Environment: onsite, online
• 2 minutes to read
 • 2 minutes to read

This table will hold outgoing sms messages when transmitted with WebServices

Fields

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

sms table relationship diagram

Indexes

Fields Types Description
id PK Clustered, Unique
outbox_id FK Index
reference_key String(255) Index
session_key String(255) Index
shipment_id FK Index
customer_id FK Index
message_id FK Index
outgoing_message_id FK Index

Relationships

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

Replication Flags

  • None

Security Flags

  • No access control via user's Role.