s_sent_message table

s_sent_message Table (405)

Emarketeer message control

Name	Description	Type	Nullable
id	The primary key (auto-incremented)	PK	No
shipment_id	Which shipment the customer received.	FK s_shipment	No
message_id	The id of the message that is sent in this shipment	FK s_message	No
customer_id	The id of the customer that received the message	FK person	No
email	The email-adresse the received the message	String(255)	Yes
when_sent	When the email was sent.	DateTime	Yes
when_read	When the email was read or link was clicked.	DateTime	Yes

Table	Description
person	Persons
s_message	A message used in a shipment. Can be html and/or plain text
s_shipment	Contains info about one shipment. The addresses are stored in s_shipment_addr