> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# s_link_customer_statical table

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

## s\_link\_customer\_statical Table (338)

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

## Fields

| 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](./s-link.mdx)                            |    No    |
| shipment\_id      | Which shipment the customer received.                                     | FK [s\_shipment](./s-shipment.mdx)                    |    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](./enums/shipmentlinktype.mdx) |    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   |

<img src="https://mintcdn.com/superofficeas/8-OIGQQJR0VGDXy_/media/loc/en/database/tables/s_link_customer_statical.png?fit=max&auto=format&n=8-OIGQQJR0VGDXy_&q=85&s=e9382e395eda3e34b70a8bf5080332b3" alt="s_link_customer_statical table relationship diagram" width="734" height="59" data-path="media/loc/en/database/tables/s_link_customer_statical.png" />

## Indexes

| Fields                   | Types           | Description |
| ------------------------ | --------------- | ----------- |
| email                    | String(255)     | Index       |
| link\_id                 | FK              | Index       |
| shipment\_id             | FK              | Index       |
| link\_type               | Enum            | Index       |
| shipment\_id, email      | FK, String(255) | Index       |
| link\_type, shipment\_id | Enum, FK        | Index       |

## Relationships

| Table                       | Description                                                                     |
| --------------------------- | ------------------------------------------------------------------------------- |
| [s\_link](./s-link)         | Links in messages to measure success rate of a campaign.                        |
| [s\_shipment](./s-shipment) | Contains info about one shipment. The addresses are stored in s\_shipment\_addr |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [Released database changes in version 9.8.7717.1401](/release-notes/database/changes-9.2.md)
- [s_link table](/en/database/tables/s-link.md)
- [What's new in version 10.1.2.686](/release-notes/database/changes-10.1.2.md)
- [What's new in version 10.1.5](/release-notes/database/changes-10.1.5.md)
- [What's new in version 10.2.1.1517](/release-notes/database/changes-10.2.1.md)
- [Enum values for ShipmentLinkType](/en/database/tables/enums/shipmentlinktype.md)