Database Structure

You can download DDL scripts for supported databases:

Auditing

The DDL files contain an audit_log table definition. The table differs slightly per database.

Only one audit_log table is required per PowerAuth stack in case the same schema is used for all deployed applications.

For more information about auditing library, see the Wultra auditing library documentation.

Table Documentation

This chapter explains individual tables and their columns. The column types are used from PostgreSQL dialect, other databases use types that are equivalent (mapping is usually straight-forward).

es_operation_template Operation Template Table

Stores operation templates to be shown by the mobile application. For more information, see Operation Extensions and Customizing Operation Form Data.

Name Type Info Note
id BIGINT NOT NULL PRIMARY KEY Autogenerated record identifier.
placeholder VARCHAR(255) NOT NULL Operation type at PowerAuth server.
language VARCHAR(8) NOT NULL Language of the template.
title VARCHAR(255) NOT NULL Title of the operation.
message TEXT NOT NULL Message for the user related to the operation.
attributes TEXT   Structured custom form data attributes as JSON.
ui TEXT   JSON configuration which may affect behavior or visual aspect of the mobile application.
Last updated on Aug 02, 2023 (10:56) Edit on Github Send Feedback
Search

1.5.x

Enrollment Server