Database Structure
View product
develop
The following documentation contains description of database table structure.
Open-Source Component Tables
Since the PowerAuth Cloud is a component consisting of several individual applications, you can learn about the database structure in the documentation of the components:
- PowerAuth Server Database Structure - tables prefixed by
pa_(except forpa_cloud_). - PowerAuth Push Server Database Structure - tables prefixed by
push_. - Enrollment Server Database Structure - tables prefixed by
es_.
Tables
pa_cloud_user API User Credentials
Stores credentials for the integration API users (systems calling the services to initiate a mobile token application).
| Name | Type | Default | Not Null | Key | Description |
|---|---|---|---|---|---|
id |
bigint |
Y | Primary | Primary ID of the record | |
username |
varchar(255) |
Y | API user username | ||
userpassword |
varchar(255) |
Y | API user password (SHA-256, or bcrypt) | ||
enabled |
boolean |
Y | Boolean indicating if the particular API user is enabled. |
| Name | Primary | References | Description |
|---|---|---|---|
pa_cloud_user_pkey |
Y | id |
Primary key for table records |
pa_cloud_user_authority API User Authority
Stores the authority (role) of the integration API users.
pa_cloud_user_application API User To Application Assignment
Table for relation between the integration API users and mobile application (PowerAuth application IDs).
| Name | Type | Default | Not Null | Key | Description |
|---|---|---|---|---|---|
id |
bigint |
Y | Primary | Primary ID of the record | |
user_id |
biging |
Y | User ID of the API user | ||
app_id |
bigint |
Y | ID of mobile app |
| Name | Primary | References | Description |
|---|---|---|---|
pa_cloud_user_application_pkey |
Y | id |
Primary key for table records |
pa_cloud_localization Operation Localization
Stores localization strings for the operation summary.
| Name | Type | Default | Not Null | Key | Description |
|---|---|---|---|---|---|
id |
bigint |
Y | Primary | Primary ID of the record | |
placeholder |
varchar(255) |
Y | ID of mobile app | ||
language |
varchar(8) |
Y | Language (ISO 639-1) | ||
title |
varchar(255) |
Y | Operation title | ||
summary |
text |
Y | Operation summary |
| Name | Primary | References | Description |
|---|---|---|---|
pa_cloud_localization_pkey |
Y | id |
Primary key for table records |
pa_cloud_property Configuration Properties
Stores various configuration properties of the system.
| Name | Type | Default | Not Null | Key | Description |
|---|---|---|---|---|---|
name |
varchar(255) |
Y | Primary | Property key | |
value |
text |
Y | Property value |
| Name | Primary | References | Description |
|---|---|---|---|
pa_cloud_property_pkey |
Y | id |
Primary key for table records |
Last updated on Oct 23, 2024 (11:15)
View product