s_attachment table

s_attachment Table (349)

A connector between a message and attachments. One message can contain many attachments.

Name	Description	Type	Nullable
id	Primary key	PK	No
attachment_id	The id of the attachment	FK attachment	No
message_id	The id of the message	FK s_message	No

Fields	Types	Description
attachment_id	FK	Index
message_id	FK	Index

Table	Description
attachment	This table contains metadata for attachments. The actual attachments are stored directly on disk, with filenames based on the the primary key for this table.
s_message	A message used in a shipment. Can be html and/or plain text