sms Table (388)
Some tooltip text!
• 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 | ● |
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 in a company or an organizations. All associates have a corresponding person record |
| 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.