OwnerContactLink Table (167)
•
Environment: onsite, online
Some tooltip text!
• 1 minute to read
• 1 minute to read
Table specifying which contacts can own associates. All contacts that have rows in this table (i.e. rows with contact_id pointing to them) will be offered as associate owners in the maintenance client and as candidate Satellite owners. Such contacts have restrictions on editing and deletion to protect database consistency.
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| OwnerContactLink_id | Primary key | PK | |
| contact_id | Contact reference | FK contact | |
| remark | Comment text | String(254) | ● |
| 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 |
|---|---|---|
| OwnerContactLink_id | PK | Clustered, Unique |
| contact_id | FK | Index |
Relationships
| Table | Description |
|---|---|
| associate | Employees, resources and other users - except for External persons |
| contact | Companies and Organizations. |
Replication Flags
- Replicate changes DOWN from central to satellites and travellers.
- Replicate changes UP from satellites and travellers back to central.
- Copy to satellite and travel prototypes.
Security Flags
- No access control via user's Role.