Policies 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 policies for how Parties can act on Resources.
Fields
The following table lists the fields in the Policies table.
| Column | Type | Required | Description |
|---|---|---|---|
Folder |
int |
yes |
The Modeling Services Folder associated with the Policy. References the [Repository.Item].[FoldersTable] view. |
Id |
bigint |
yes |
The unique identifier of the Policies. |
KindId |
bigint |
The unique identifier of a Kind that describes additional information about the Policy. References the [System.Identity].[Kinds] view. |
|
TenantId |
bigint |
yes |
References the [System.Identity].[Parties] view. |
FederationInfoId |
bigint |
The unique identifier of the Federation associated with the Policy. References the [System.Identity].[FederationInfo] view. |
|
LastMasteringIdentifier |
bigint |
||
Content |
nvarchar(max) |
The body of the policy expressed in text. |
|
URL |
nvarchar(max) |
yes |
|
DescriptiveInformation |
nvarchar(1024) |
The body of the policy expressed in text. |
|
OwnerId |
bigint |
yes |
The unique identifier of the Party that owns the Policy. References the [System.Identity].[Parties] view. |
ContactId |
bigint |
References the [System.Identity].[Parties] view. |