s_message Table (335)

• 3 minutes to read

A message used in a shipment. Can be html and/or plain text

Fields

Name	Description	Type	Null
id	Primary key	PK
plain_message	Plain message text of this message	Clob	●
html_message	HTML formatted text of this message	Clob	●
sms_message	SMS version of this message	Clob	●
description	Describes this message	String(255)	●
subject	The mail subject field of the message	String(255)	●
header_field	Extra header fields added to mail. Must be formatted correctly	Clob	●
flags	Identifies if HTML or plain message is included in message.	Enum ShipmentMessageType
folder_id	The folder which this message belongs to. -1 indicates that the message is on the root	Int
inline_images	Should images be included inline?	Bool	●
register_views	Register message views?	Bool	●
access_key	Key used for access verification	String(255)	●
registered	Registered when	UtcDateTime	●
registered_associate_id	Registered by whom	FK associate	●
updated	Last updated when	UtcDateTime	●
updated_associate_id	Last updated by whom	FK associate	●
updatedCount	Number of updates made to this record	UShort	●
document_message	The SM document used as template for this mailing	FK document	●
long_description	A field for a long description of this template	String(4000)	●
design	Will contain the design part of a message. The format will vary based on the type of designer used to create the message	Clob	●
designtype	Enum containing the type of the design	Enum DesignType

s_message table relationship diagram

Fields	Types	Description
id	PK	Clustered, Unique

Table	Description
associate	Employees, resources and other users - except for External persons
document	Documents, this table is an extension of the Appointment table. There is always a corresponding appointment record; the relation between appointment and document is navigable in both directions. A document-type appointment record always has a corresponding document record and a record in VisibleFor specifying who may see this.
external_document	This table stores documents which can be viewed externaly, through the customer module
s_attachment	A connector between a message and attachments. One message can contain many attachments.
s_sent_message	Emarketeer message control
s_shipment	Contains info about one shipment. The addresses are stored in s_shipment_addr