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

# ticket_customers table

> This table allows several customers to be connected to several tickets (many-to-many)

## ticket\_customers Table (264)

This table allows several customers to be connected to several tickets (many-to-many)

## Fields

| Name         | Description                        | Type                      | Nullable |
| ------------ | ---------------------------------- | ------------------------- | :------: |
| id           | The primary key (auto-incremented) | PK                        |    No    |
| ticket\_id   | Reference to a ticket              | FK [ticket](./ticket.mdx) |    No    |
| customer\_id | Reference to a customer            | FK [person](./person.mdx) |    No    |

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

## Indexes

| Fields                   | Types  | Description |
| ------------------------ | ------ | ----------- |
| ticket\_id               | FK     | Index       |
| customer\_id             | FK     | Index       |
| ticket\_id, customer\_id | FK, FK | Index       |

## Relationships

| Table              | Description                                                                              |
| ------------------ | ---------------------------------------------------------------------------------------- |
| [person](./person) | Persons                                                                                  |
| [ticket](./ticket) | This table contains the tickets (requests) of the system. Its purpose should be evident. |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [Dot-syntax](/en/automation/crmscript/searchengine/dot-syntax.md)
- [ticket table](/en/database/tables/ticket.md)
- [message_customers table](/en/database/tables/message-customers.md)
- [ticket_alert table](/en/database/tables/ticket-alert.md)
- [ticket_log_action table](/en/database/tables/ticket-log-action.md)
- [Ticket table](/en/api/bulk-operations/bulk-update/reference/ticket-table.md)