message_customers table

message_customers Table (260)

This table contains all cutomers who are involved in a message

Name	Description	Type	Nullable
id	The primary key (auto-incremented)	PK	No
message_id	The id of the message the customer is involved in	FK ej_message	No
customer_id	The id of the customer who has received this message, or another message in this ticket	FK person	No
email	The email-adresse used in this message	String(255)	Yes

Fields	Types	Description
message_id	FK	Index
customer_id	FK	Index

Table	Description
ej_message	This table contains the messages listed under tickets.
person	Persons