s_link_customer_statical table

s_link_customer_statical Table (338)

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
email	The email address of the bounced email	String(255)	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	No
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
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