IdentityKeys 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 key values that Parties use as sources of identification. For example, an Identity Key could be an email address, a phone number, or a network name.
Fields
The following table lists the fields in the IdentityKeys table.
| Column | Type | Required | Description |
|---|---|---|---|
Folder |
int |
yes |
The Modeling Services Folder associated with the Identity Key. References the [Repository.Item].[FoldersTable] view. |
Id |
bigint |
yes |
The unique identifier of the Identity Key. |
PartyId |
bigint |
yes |
The unique identifier of the Party that claims the Identity Key. References the [System.Identity].[Parties] view. |
PartyRoleId |
bigint |
The unique identifier of the Role for the Party that claims the Identity Key. |
|
PartyRoleKindId |
bigint |
The unique identifier of a Kind that describes additional information about the Role for the Party that claims the Identity Key. References the [System.Identity].[Kinds] view. |
|
KindId |
bigint |
The unique identifier of a Kind that describes additional information about the Identity Key. For example, the Kind could indicate that the Identity Key is an email address. References the [System.Identity].[Kinds] view. |
|
StartDate |
datetime2(7) |
The start date for the Identity Key. |
|
EndDate |
datetime2(7) |
The end date for the Identity Key. |
|
TenantId |
bigint |
yes |
References the [System.Identity].[Parties] view. |
Value |
nvarchar(256) |
yes |
The value of the Identity Key. For example, if the Identity Key were an email address, the Value field would contain the address, such as danpark@adatum.com. |
DisplayName |
nvarchar(128) |
The display name for the Identity Key. |
|
IssuedById |
bigint |
The unique identifier of the Authority who issued the Identity Key. References the [System.Identity].[Authorities] view. |
|
DescriptiveInformation |
nvarchar(1024) |
Additional information about the Identity Key. |
|
IsDefault |
bit |
yes |
|
NullDisambiguator |
bigint |