Authorities 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 Authorities. An Authority is a Party that makes Claims about other Parties in their various Roles and relationships.
Fields
The following table lists the fields in the Authorities table.
| Column | Type | Required | Description |
|---|---|---|---|
Folder |
int |
yes |
The Modeling Services Folder associated with the Authority. References the [Repository.Item].[FoldersTable] view. |
Id |
bigint |
yes |
The unique identifier of the Authority. |
KindId |
bigint |
The unique identifier of a Kind that describes additional information about the Authority. References the [System.Identity].[Kinds] view. |
|
StartDate |
datetime2(7) |
The start date for the Authority. |
|
EndDate |
datetime2(7) |
The end date for the Authority. |
|
PartyId |
bigint |
yes |
The unique identifier of the Party that is acting as the Authority. References the [System.Identity].[Parties] view. |
TenantId |
bigint |
yes |
References the [System.Identity].[Parties] view. |
DefaultForRole |
bit |
yes |
A bit flag that specifies the Role is a Default Role for the Party. |
ContextId |
bigint |
The unique identifier of the Party for whom the Authority is acting. References the [System.Identity].[Parties] view. |
|
ParentAuthorityId |
bigint |
The unique identifier of the parent Authority. This field helps to implement Authority hierarchies. References the [System.Identity].[Authorities] view. |