Skip to Content Information Center
Markvision Enterprise

Markvision Enterprise

Niet uw product?

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 nameData typeDescription

    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 nameData typeDescription

    *This data type is required for Microsoft SQL Server.

    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.

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 nameData typeDescription

    *This data type is required for Microsoft SQL Server.

    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.

    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 nameData typeDescription

    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.
Was dit artikel nuttig?
Top