Personas 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 Personas associated with Parties in the [System.Identity].[Parties] view.
Fields
The following table lists the fields in the Personas table.
| Column | Type | Required | Description |
|---|---|---|---|
Folder |
int |
yes |
The Modeling Services Folder associated with the Persona. References the [Repository.Item].[FoldersTable] view. |
Id |
bigint |
yes |
The unique identifier of the Persona. |
KindId |
bigint |
The unique identifier of a Kind that describes additional information about the Persona. References the [System.Identity].[Kinds] view. |
|
StartDate |
datetime2(7) |
The start date for the Persona. |
|
EndDate |
datetime2(7) |
The end date for the Persona. |
|
TenantId |
bigint |
yes |
References the [System.Identity].[Parties] view. |
PartyId |
bigint |
yes |
The unique identifier of the Party associated with the Persona. The Party must have a PrimaryKind value of -8605069736128747942 (Persons). 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 Persona is acting. References the [System.Identity].[Parties] view. |
|
LocaleId |
bigint |
yes |
The unique identifier of a Location associated with the Persona. References the [System.Identity].[Kinds] view. |
GenderId |
bigint |
The unique identifier of the Kind that idicates the gender of the Persona. References the [System.Identity].[Kinds] view. |
|
Initials |
nvarchar(32) |
The initials of the Persona. |
|
GivenName |
nvarchar(64) |
The legal name of the Persona. |
|
MiddleName |
nvarchar(64) |
The middle name of the Persona. |
|
Surname |
nvarchar(64) |
The surname for the Persona. |
|
MaidenName |
nvarchar(64) |
The maiden name for the Persona. |
|
Title |
nvarchar(64) |
The title of the Persona. |
|
Suffix |
nvarchar(32) |
The suffix for the Persona. |
|
Nickname |
nvarchar(128) |
The nickname for the Persona. |