> ## 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.

## Purpose

Contains information about users and user groups.

[Diagram of relationships between lock tables](/flexi-capture/reports/database/locks)

[Diagram of relationships between access control tables](/flexi-capture/reports/database/users-reports-database)

## List of columns

<table width="100%"><tbody><tr><td><p><strong>Key</strong></p></td><td><p><strong>Name</strong></p></td><td><p><strong>Type</strong></p></td><td><p><strong>Required</strong></p></td><td><p><strong>Description</strong></p></td></tr><tr><td><p>PK</p></td><td><p>Id</p></td><td><p>int</p></td><td><p>yes</p></td><td><p>Entry identifier.</p></td></tr><tr><td rowspan="9"> </td><td><p>Email</p></td><td><p>nvarchar</p></td><td><p>no</p></td><td><p>User's email address.</p></td></tr><tr><td><p>FullName</p></td><td><p>nvarchar</p></td><td><p>no</p></td><td><p>User's full name.</p></td></tr><tr><td><p>IsSystemAdministrator</p></td><td><p>tinyint</p></td><td><p>yes</p></td><td><p>Indicates that a user is a System Administrator. This role is given to a user who created a database.</p></td></tr><tr><td><p>Name</p></td><td><p>nvarchar</p></td><td><p>yes</p></td><td><p>Name of user or user group.</p></td></tr><tr><td><p>PasswordHash</p></td><td><p>varchar</p></td><td><p>no</p></td><td><p>The hash sum of the user's password.</p></td></tr><tr><td><p>PasswordReset</p></td><td><p>tinyint</p></td><td><p>no</p></td><td><p>Indicates that the password was reset.</p></td></tr><tr><td><p>SID</p></td><td><p>nvarchar</p></td><td><p>no</p></td><td><p>Security identifier of the imported users and groups</p></td></tr><tr><td><p>TenantId</p></td><td><p>int</p></td><td><p>no</p></td><td><p>Identifier of the Document Definition. Corresponds to the entry identifier in the <a href="/flexi-capture/reports/database/tenant">Tenant</a> table.</p></td></tr><tr><td><p>Type</p></td><td><p>int</p></td><td><p>yes</p></td><td><p>Entry type. Possible values:</p><ul><li><strong>0</strong> – user</li><li><strong>1</strong> – user group</li></ul></td></tr></tbody></table>