Database Structure
You can download DDL scripts for supported databases:
See the overall database schema:
Database Tables
mus_mobile_app Mobile Applications
Contains information related to various mobile apps.
| Column | Type | Description |
|---|---|---|
id |
INTEGER |
Primary key for the table, automatically incremented value. |
name |
VARCHAR(255) |
Name of the application, a machine readable value, such as wlt-demo-app. |
display_name |
VARCHAR(255) |
Display name of the application, a human readable value, such as Wultra Demo App. |
sign_private_key |
VARCHAR(255) |
Base64-encoded private key associated with the application. It is used for signing the data on the server side. |
sign_public_key |
VARCHAR(255) |
Base64-encoded public key associated with the application. It is used by the client applications when verifying data signed on the server side. |
mus_mobile_domain Mobile App Domains
Contains information related to pinned domains.
| Column | Type | Description |
|---|---|---|
id |
INTEGER |
Primary key for the table, automatically incremented value. |
app_id |
INTEGER |
Reference to related mobile app entity. |
domain |
VARCHAR(255) |
Host name of the domain, such as mobile.wultra.com. |
mus_certificate SSL Certificate
Table with TLS/SSL certificate and fingerprints that should be pinned in the mobile app.
| Column | Type | Description |
|---|---|---|
id |
INTEGER |
Primary key for the table, automatically incremented value. |
pem |
TEXT |
Original certificate value in PEM format. |
fingerprint |
VARCHAR(255) |
Value of the certificate fingerprint. |
expires |
INTEGER |
Unix timestamp (seconds since Jan 1, 1970) of the certificate expiration. |
mobile_domain_id |
INTEGER |
Reference to related application domain in the mus_mobile_domain table. |
mus_user Administrative User
Table with users for basic HTTP authentication.
| Column | Type | Description |
|---|---|---|
id |
INTEGER |
Primary key for the table, automatically incremented value. |
username |
VARCHAR(255) |
Username of the user. |
password |
VARCHAR(255) |
Password of the user (bcrypt by default, or {SHA-256} prefix for SHA-256). |
enabled |
BOOLEAN |
Indication if the user is enabled or not. |
mus_user_authority Administrative User Authorities
Table with users authorities.
mus_mobile_app_version Mobile Application Version
Table to force or suggest update of mobile application version.
| Column | Type | Description |
|---|---|---|
id |
INTEGER |
Primary key for the table, automatically incremented value. |
app_id |
INTEGER |
Reference to related mobile app entity. |
platform |
VARCHAR(10) |
ANDROID, IOS |
major_os_version |
INTEGER |
For iOS e.g. 12.4.2 it is 12. For Android, it is API level e.g. 29. When null, the rule is applied for all versions. |
suggested_version |
VARCHAR(24) |
If the application version is lower, update is suggested. |
required_version |
VARCHAR(24) |
If the application version is lower, update is required. |
message_key |
VARCHAR(255) |
Together with language identifies row in mus_localized_text |
mus_localized_text Localized Text
Table with localized texts.
| Column | Type | Description |
|---|---|---|
message_key |
VARCHAR(255) |
Primary composite key for the table. |
language |
VARCHAR(2) |
Primary composite key for the table. ISO 639-1 two-letter language code. |
text |
TEXT |
Localized text. |
Sequences
Mobile App Sequence
Sequence responsible for mobile app autoincrements.
Mobile App Domain Sequence
Sequence responsible for mobile domain autoincrements.
SSL Certificate Sequence
Sequence responsible for SSL certificates and fingerprints autoincrements.
Mobile Application Version Sequence
Sequence responsible for mobile application version autoincrements.
Foreign Indexes
The tables are relatively small and as a result, do not require indexes. To marginally improve the lookup performance, you can create the following foreign indexes.
Foreign Index for SSL Fingerprint Lookup
Foreign index for mapping the fingerprint to domain.
Foreign Index for Domain Lookup
Foreign index to map the domain to mobile app.
Foreign Index for User Authority Lookup
Foreign index to map the user authority to the user.