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

# contactinterest table

> Link-table between contact and interests in ContInt

## contactinterest Table (14)

Link-table between contact and interests in ContInt

## Fields

| Name                      | Description                           | Type                            | Nullable |
| ------------------------- | ------------------------------------- | ------------------------------- | :------: |
| contactinterest\_id       | Primary key                           | PK                              |    No    |
| contact\_id               | Owning contact                        | FK [contact](./contact.mdx)     |    No    |
| cinterest\_idx            | Contact interest link                 | FK [ContInt](./contint.mdx)     |    No    |
| startDate                 | Start date for this interest - no GUI | DateTime                        |    Yes   |
| endDate                   | End date for this interest - no GUI   | DateTime                        |    Yes   |
| flags                     | Spare flag field                      | UInt                            |    Yes   |
| registered                | Registered when                       | UtcDateTime                     |    No    |
| registered\_associate\_id | Registered by whom                    | FK [associate](./associate.mdx) |    No    |
| updated                   | Last updated when                     | UtcDateTime                     |    No    |
| updated\_associate\_id    | Last updated by whom                  | FK [associate](./associate.mdx) |    No    |
| updatedCount              | Number of updates made to this record | UShort                          |    No    |

<img src="https://mintcdn.com/superofficeas/i6M2qZmvMNH7UTeu/media/loc/en/database/tables/contactinterest.png?fit=max&auto=format&n=i6M2qZmvMNH7UTeu&q=85&s=6f52444ef009726b349ba1eb6c04c3e0" alt="contactinterest table relationship diagram" width="627" height="620" data-path="media/loc/en/database/tables/contactinterest.png" />

## Indexes

| Fields                      | Types    | Description |
| --------------------------- | -------- | ----------- |
| cinterest\_idx              | FK       | Index       |
| startDate                   | DateTime | Index       |
| endDate                     | DateTime | Index       |
| contact\_id, cinterest\_idx | FK, FK   | Unique      |
| contact\_id                 | FK       | Clustered   |

## Relationships

| Table                    | Description                                                        |
| ------------------------ | ------------------------------------------------------------------ |
| [associate](./associate) | Employees, resources and other users - except for External persons |
| [contact](./contact)     | Companies and Organizations.                                       |
| [ContInt](./contint)     | ContInt list table. List-text of all valid contact interest types. |

## Replication Flags

* Area Management controlled table. Contents replicated to satellites and traveller databases.
* Replicate changes UP from satellites and travellers back to central.
* Copy to satellite and travel prototypes.

## Security Flags

* Sentry controls access to items in this table using user's Role and data rights matrix on the table's parent.


## Related topics

- [Working with companies in API](/en/company/dev/index.md)
- [Interests](/en/automation/crmscript/howto/interests/index.md)
- [ContInt table](/en/database/tables/contint.md)
- [Analyze Biz Card Image](/en/api/reference/restful/agent/ai_agent/analyze-biz-card-image.md)
- [Analyze Biz Card Text](/en/api/reference/restful/agent/ai_agent/analyze-biz-card-text.md)
- [contact table](/en/database/tables/contact.md)