Miscellaneous
The following tables provide useful storage but do not fit into any of the previous table categories.
APPLICATION_SETTINGS
This table currently holds all the MVE system settings. The values are encrypted and not available outside of MVE.
|
Field name |
Data type |
Description |
|---|---|---|
|
ID |
BIGINT |
The primary key. |
|
SETTING_KEY |
VARCHAR(255) |
The preference name. |
|
SETTING_VALUE |
VARCHAR(8190) |
The preference value. |
BOOKMARK
This table contains all saved searches of MVE. They are currently stored as BLOB, so they cannot be edited outside of MVE.
|
Field name |
Data type |
Description |
|---|---|---|
|
ID |
BIGINT |
The primary key. |
|
DEFAULT_SEARCH |
SMALLINT/ TINYINT* |
The flag indicating whether this bookmark is one of the defaults that come with MVE. |
|
NAME |
VARCHAR(255) |
The user-supplied name of the bookmark. |
|
SEARCH_CRITERIA |
BLOB SUB_TYPE 0 |
The binary representation of the bookmark. |
|
DESERIALIZABLE |
SMALLINT/ TINYINT* |
Indicates whether the saved search is deserializable. |
|
DESCRIPTION |
VARCHAR(4000) |
An optional user‑entered description of the saved search. |
*This data type is required for Microsoft SQL Server.
Liquibase and Hibernate Tables
Liquibase and Hibernate are third‑party libraries that MVE uses to help maintain the database. The following tables are used by these libraries. These tables do not contain any significant printer data so their contents are not detailed here.
-
DATABASECHANGELOG
-
DATABASECHANGELOGLOCK
-
All tables whose names begin with HT_.
-
HIBERNATESEQUENCE
SMTP_CONFIGURATION
This table contains configuration for the Simple Mail Transfer Protocol (SMTP), which allows MVE users to send emails.
|
Field name |
Data type |
Description |
|---|---|---|
|
ID |
BIGINT |
The primary key. |
|
FROM_ADDRESS |
VARCHAR(255) |
The email address of the sender. |
|
LOGIN_ID |
VARCHAR(255) |
The user ID for the SMTP server. |
|
LOGIN_PASSWORD |
VARCHAR(255) |
The password associated with the user ID for the SMTP server. |
|
LOGIN_REQ |
SMALLINT/ TINYINT* |
The flag indicating whether the SMTP server requires a login. |
|
SMTP_PORT |
BIGINT |
The port of the SMTP server. |
|
SMTP_SERVER |
VARCHAR(255) |
The host name or IP address of the SMTP server. |
|
SMTP_ENABLE |
SMALLINT/ TINYINT* |
The flag indicating whether SMTP is enabled. |
|
EMAIL_ENCRYPTION |
VARCHAR(64) |
Refers to the supported encryption types., default is null. |
*This data type is required for Microsoft SQL Server.
SYSTEM_LOG
This table contains all of the system log messages that are produced as MVE carries out its tasks. This table can get very large.
|
Field name |
Data type |
Description |
|---|---|---|
|
LOG_ID |
BIGINT |
The primary key. |
|
TIMESTAMP_ |
TIMESTAMP |
The time when the message was logged. |
|
TASKID |
BIGINT |
The task instance that generated the message. |
|
TASKNAME |
VARCHAR(50) |
The task that generated the message. |
|
LEVEL_ |
INTEGER |
The options are DEBUG, INFO, etc. |
|
MESSAGE_ |
VARCHAR(8000) |
The actual log message. |
|
USER_NAME |
VARCHAR(255) |
The username of the user who performed the action. |
|
IP_ADDRESS |
VARCHAR(50) |
The client IP address. |