s_link_customer table

s_link_customer Table (337)

A connection between a customer and a link. Registered customers are identified when clicking on a link

Name	Description	Type	Nullable
id	Primary key	PK	No
customer_id	Connection to a customer that clicked on a link	FK person	No
link_id	Connection to a link that the customer clicked on	FK s_link	No
shipment_id	Which shipment the customer received.	FK s_shipment	No
pressed	When the link was clicked.	DateTime	Yes
link_type	If this is a link to a link or an image (gif/jpeg). See SpmLink::LinkType	Enum ShipmentLinkType	Yes
page	Indicates the page number for this gif link	Int	No
http_user_agent	The HTTP_USER_AGENT reported when the customer opened this link	String(1024)	Yes

Table	Description
person	Persons
s_link	Links in messages to measure success rate of a campaign.
s_shipment	Contains info about one shipment. The addresses are stored in s_shipment_addr