PartyToPartyRelationships Table (System.Identity Schema)
[This content is no longer valid. For the latest information on "M", "Quadrant", SQL Server Modeling Services, and the Repository, see the Model Citizen blog.]
Stores information about Party-to-Party Relationships.
Fields
The following table lists the fields in the PartyToPartyRelationships table.
| Column | Type | Required | Description |
|---|---|---|---|
Folder |
int |
yes |
The Modeling Services Folder associated with the Party-to-Party Relationship. References the [Repository.Item].[FoldersTable] view. |
Id |
bigint |
yes |
The unique identifier of the Party-to-Party Relationship. |
StartDate |
datetime2(7) |
The start date for the Party-to-Party Relationship. |
|
EndDate |
datetime2(7) |
The end date for the Party-to-Party Relationship. |
|
KindId |
bigint |
The unique identifier of a Kind that describes additional information about the Party-To-Party Relationships. References the [System.Identity].[Kinds] view. |
|
TenantId |
bigint |
yes |
References the [System.Identity].[Parties] view. |
ContextPartyId |
bigint |
yes |
The unique identifier of the Party to which ReferencedParty is related. References the [System.Identity].[Parties] view. |
ContextPartyIdentityKeyId |
bigint |
A unique identifier of the Identity Key associated with the Context Party. References the [System.Identity].[IdentityKeys] view. |
|
ReferencedPartyId |
bigint |
yes |
The unique identifier of the Party that has a relationship with ContextParty. References the [System.Identity].[Parties] view. |
ReferencedPartyIdentityKeyId |
bigint |
A unique identifier of the Identity Key associated with the Referenced Party. References the [System.Identity].[IdentityKeys] view. |
|
RelationshipStrength |
int |
An integer value that indicates the strength of the relationship between the Context Party and the Referenced Party. |