> ## 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 table

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

## s\_link\_customer Table (337)

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    |
| customer\_id      | Connection to a customer that clicked on a link                           | FK [person](./person.mdx)                             |    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) |    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   |

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

## Indexes

| Fields                     | Types    | Description |
| -------------------------- | -------- | ----------- |
| customer\_id               | FK       | Index       |
| link\_id                   | FK       | Index       |
| shipment\_id               | FK       | Index       |
| shipment\_id, customer\_id | FK, FK   | Index       |
| link\_type, shipment\_id   | Enum, FK | Index       |

## Relationships

| Table                       | Description                                                                     |
| --------------------------- | ------------------------------------------------------------------------------- |
| [person](./person)          | Persons                                                                         |
| [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

- [s_link_customer_statical table](/en/database/tables/s-link-customer-statical.md)
- [s_link table](/en/database/tables/s-link.md)
- [s_shipment table](/en/database/tables/s-shipment.md)
- [Released database changes in version 9.8.7717.1401](/release-notes/database/changes-9.2.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)