ResourceRelationships 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 relationships between Resources.
Fields
The following table lists the fields in the ResourceRelationships table.
| Column | Type | Required | Description |
|---|---|---|---|
Folder |
int |
yes |
The Modeling Services Folder associated with the Resource relationship. References the [Repository.Item].[FoldersTable] view. |
Id |
bigint |
yes |
The unique identifier of the Resource relationship. |
StartDate |
datetime2(7) |
The start date of the Resource relationship. |
|
EndDate |
datetime2(7) |
The end date of the Resource relationship. |
|
TenantId |
bigint |
yes |
References the [System.Identity].[Parties] view. |
KindId |
bigint |
The unique identifier of a Kind that describes additional information about the Resource relationship. References the [System.Identity].[Kinds] view. |
|
SourceResourceId |
bigint |
yes |
The unique identifier of the source Resource for the Resource relationship. References the [System.Identity].[Resources] view. |
TargetResourceId |
bigint |
yes |
The unique identifier of the target Resource for the Resource relationship. References the [System.Identity].[Resources] view. |