personinterest Table (15)
Some tooltip text!
• 2 minutes to read
• 2 minutes to read
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 | Null |
|---|---|---|---|
| personinterest_id | Primary key | PK | |
| person_id | Owning person | FK person | |
| pinterest_idx | Person interest link | FK PersInt | |
| startDate | Start date for this interest - no GUI | DateTime | ● |
| endDate | End date for this interest - no GUI | DateTime | ● |
| flags | Spare flag field | UInt | ● |
| registered | Registered when | UtcDateTime | |
| registered_associate_id | Registered by whom | FK associate | |
| updated | Last updated when | UtcDateTime | |
| updated_associate_id | Last updated by whom | FK associate | |
| updatedCount | Number of updates made to this record | UShort |
Indexes
| Fields | Types | Description |
|---|---|---|
| personinterest_id | PK | Unique |
| 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 | Employees, resources and other users - except for External persons |
| PersInt | PersInt list table. List of Person interests. |
| person | Persons in a company or an organizations. All associates have a corresponding person record |
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.