> ## Documentation Index
> Fetch the complete documentation index at: https://docs.abbyy.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Principal

> Reference for the Principal table in the ABBYY FlexiCapture reports database: columns holding users and user groups, their names, email, roles, and tenant.

Contains information about users and user groups.

For diagrams of the relationships, see [Locks](/flexi-capture/reports/database/locks) and [Access control](/flexi-capture/reports/database/users-reports-database).

## List of columns

| Key | Name                    | Type       | Required | Description                                                                                                                               |
| --- | ----------------------- | ---------- | -------- | ----------------------------------------------------------------------------------------------------------------------------------------- |
| PK  | `Id`                    | `int`      | Yes      | Entry identifier.                                                                                                                         |
|     | `Email`                 | `nvarchar` | No       | User's email address.                                                                                                                     |
|     | `FullName`              | `nvarchar` | No       | User's full name.                                                                                                                         |
|     | `IsSystemAdministrator` | `tinyint`  | Yes      | Indicates that a user is a System Administrator. This role is given to a user who created a database.                                     |
|     | `Name`                  | `nvarchar` | Yes      | Name of user or user group.                                                                                                               |
|     | `PasswordHash`          | `varchar`  | No       | The hash sum of the user's password.                                                                                                      |
|     | `PasswordReset`         | `tinyint`  | No       | Indicates that the password was reset.                                                                                                    |
|     | `SID`                   | `nvarchar` | No       | Security identifier of the imported users and groups.                                                                                     |
|     | `TenantId`              | `int`      | No       | Identifier of the Document Definition. Corresponds to the entry identifier in the [Tenant](/flexi-capture/reports/database/tenant) table. |
|     | `Type`                  | `int`      | Yes      | Entry type. Possible values: 0 – user; 1 – user group.                                                                                    |