ESF
ESF_APPLICATION
This table contains all the eSF applications in all deployable eSF packages. There may be many eSF applications in each deployable package.
|
Field name |
Data type |
Description |
|---|---|---|
|
ESF_APP_ID |
BIGINT |
The primary key. |
|
ESF_DP_ID |
BIGINT |
The foreign key back to ESF_DEPLOYABLE_PACKAGE.ESF_DP_ID. |
|
APP_ID |
VARCHAR(255) |
The application ID of the eSF applications. |
|
VERSION |
VARCHAR(255) |
The eSF application version. |
|
DESCRIPTION_URI |
VARCHAR(255) |
The URI description to the ESF application. |
|
FLS_URI |
VARCHAR(255) |
The URI to the flash file. |
ESF_APPLICATION_LOCALE
This table contains the name and description of each eSF application in all languages supported by MVE.
|
Field Name |
Data Type |
Description |
|---|---|---|
|
ESF_APP_LOCALE_ID |
BIGINT |
The primary key. |
|
ESF_APP_ID |
BIGINT |
The foreign key to ESF_APPLICATION.ESF_APP_ID. |
|
LOCALE |
VARCHAR(255) |
The two‑character language code. |
|
NAME |
VARCHAR(255) |
The name of the eSF application in the language indicated by LOCALE. |
|
DESCRIPTION |
VARCHAR(510) |
The description of the eSF application in the language indicated by LOCALE. |
ESF_COMP_DEPLOYABLE_PACKAGE
This table contains one row for each deployable package in use by an MVE configuration.
|
Field Name |
Data Type |
Description |
|---|---|---|
|
ESF_COMPONENT_ID |
BIGINT |
The foreign key to CONFIGURATION_COMPONENT.CONFIGURATION_COMPONENT_ID. |
|
ESF_DP_ID |
VARCHAR(255) |
The foreign key to ESF_DEPLOYABLE_PACKAGE.ESF_DP_ID. |
ESF_DEPLOYABLE_PACKAGE
This table represents all the deployable packages uploaded to the MVE library.
|
Field Name |
Data Type |
Description |
|---|---|---|
|
ESF_DP_ID |
BIGINT |
The primary key. |
|
NAME |
VARCHAR(255) |
The name of the deployable package. |
|
PART_NUMBER |
VARCHAR(255) |
The part number of the deployable package. |
|
PART_REVISION |
VARCHAR(255) |
The part revision of the deployable package. |
|
LICENSE_REQUIRED |
SMALLINT/ TINYINT* |
The flag indicating whether a license is required for the deployable package. |
|
URI |
VARCHAR(255) |
The URI of the deployable package. |
|
DATE_IMPORTED |
TIMESTAMP |
The date when the deployable package was imported. |
|
VERSION |
VARCHAR(255) |
The version of the deployable package. |
|
DESCRIPTION |
VARCHAR(255) |
The description of the deployable package. |
*This data type is required for Microsoft SQL Server.
ESF_DEPLOYABLE_PACKAGE_LOCALE
This table contains the name and description for each deployable package in all languages supported by MVE.
|
Field Name |
Data Type |
Description |
|---|---|---|
|
ESF_DP_LOCALE_ID |
BIGINT |
The primary key. |
|
ESF_DP_ID |
BIGINT |
The foreign key to ESF_DEPLOYABLE_PACKAGE.ESF_ DP_ID. |
|
LOCALE |
VARCHAR(255) |
The two‑character language code. |
|
NAME |
VARCHAR(255) |
The name of the deployable package in the language indicated by LOCALE. |
|
DESCRIPTION |
VARCHAR(2048) |
The increased description length, from 510 to 2048 characters. |
ESF_DP_SUPPORTED MODELS
This table contains one row for each model supported by a deployable package in the MVE library.
|
Field Name |
Data Type |
Description |
|---|---|---|
|
ESF_DP_ID |
BIGINT |
The foreign key back to ESF_DEPLOYABLE_PACKA GE.ESF_DP_ID. |
|
SUPPORTED_MODEL |
VARCHAR(255) |
The model name of printer supported by the deployable package. |
ESF_LICENSE
This table represents the licenses for eSF applications available in the MVE library.
|
Field Name |
Data Type |
Description |
|---|---|---|
|
ESF_LICENSE_ID |
BIGINT |
The primary key. |
|
PRINTER_SERIAL |
VARCHAR(255) |
The serial number of the printer to which the license is tied. |
|
PART_NUMBER |
VARCHAR(255) |
The part number of the package to which the license is tied. |
|
PART_REVISION |
VARCHAR(255) |
The part revision of the package to which the license is tied. |
|
LICENSE_TYPE |
VARCHAR(255) |
The options are TRIAL and PRODUCTION. |
|
FILE_NAME |
VARCHAR(255) |
The file name of the license binary. |
|
DEPLOYED |
SMALLINT/ TINYINT* |
The flag indicating whether the license has been deployed. |
*This data type is required for Microsoft SQL Server.
RAWESFAPPFILE
This table represents the raw eSF application file details available in the MVE library.
|
Field Name |
Data Type |
Description |
|---|---|---|
|
ID |
BIGINT |
The primary key. |
|
FILENAME |
VARCHAR(255) |
The name of the package file. |
|
DISPLAY_NAME |
VARCHAR(255) |
The display name of the package file. |
|
DATE_IMPORTED |
TIMESTAMP |
The time stamp of the import of the package. |
|
SHA1 |
VARCHAR(255) |
The SHA1 hash of the package. |
|
DESCRIPTION |
VARCHAR(255) |
The description of the package. |
|
APP_ID |
VARCHAR(255) |
The application ID of the package. |
|
VERSION |
VARCHAR(255) |
The version of the package. |
APP_FLS_RESOURCE_FILES
This table represents the association of eSF applications file available in the MVE library with configuration.
|
Field Name |
Data Type |
Description |
|---|---|---|
|
RESOURCE_ID |
BIGINT |
The primary key. |
|
SHA1 |
VARCHAR(255) |
The SHA1 hash of the package. |
|
RESOURCE_TYPE |
VARCHAR(255) |
The type of the Resource File. The options are UCF_FILE, VCC_FILE, and APP_FLS. |
|
CONFIGURATION_COMPONENT_ID |
BIGINT |
The foreign key with the ID column of CONFIGURATION_COMPONENT. |