> ## 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. # personinterest table > Note; If you add or remove rows in this table, you will need to update the interestCount field in the person table accordingly. This field should always reflect the number of interest records a person has, to enable the correct setting of the interest indicator on the tab in the person dialog. Replication note; The combination of person_id and pinterest_idx is unique. If a duplicate is made on a replicated database, the system will replace the record in the target database with the one derived from the source database during replication. Therefore, do not assume that a record in this table will retain its ID indefinitely, even if the person keeps the interest. ## personinterest Table (15) Note; If you add or remove rows in this table, you will need to update the interestCount field in the person table accordingly. This field should always reflect the number of interest records a person has, to enable the correct setting of the interest indicator on the tab in the person dialog. Replication note; The combination of person\_id and pinterest\_idx is unique. If a duplicate is made on a replicated database, the system will replace the record in the target database with the one derived from the source database during replication. Therefore, do not assume that a record in this table will retain its ID indefinitely, even if the person keeps the interest. ## Fields | Name | Description | Type | Nullable | | ------------------------- | ------------------------------------- | ------------------------------- | :------: | | personinterest\_id | Primary key | PK | No | | person\_id | Owning person | FK [person](./person.mdx) | No | | pinterest\_idx | Person interest link | FK [PersInt](./persint.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 | personinterest table relationship diagram ## Indexes | Fields | Types | Description | | -------------------------- | -------- | ----------- | | pinterest\_idx | FK | Index | | startDate | DateTime | Index | | endDate | DateTime | Index | | person\_id, pinterest\_idx | FK, FK | Unique | | person\_id | FK | Clustered | ## Relationships | Table | Description | | ------------------------ | ------------------------------------------------------------------ | | [associate](./associate) | Employees, resources and other users - except for External persons | | [PersInt](./persint) | PersInt list table. List of Person interests. | | [person](./person) | Persons | ## 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 - [Interests](/en/automation/crmscript/howto/interests/index.md) - [PersInt table](/en/database/tables/persint.md) - [person table](/en/database/tables/person.md) - [BulkUpdateSystem FieldValueInfo](/en/api/bulk-operations/bulk-update/field-value-info.md) - [associate table](/en/database/tables/associate.md) - [extra_tables table](/en/database/tables/extra-tables.md)