Views and data export
The following tables describe information on Views in MVE and fields included in each view.
DATA_EXPORT_TEMPLATE
This table contains information on Views in MVE.
|
Field Name |
Data Type |
Description |
|---|---|---|
|
DATA_EXPORT_ID |
BIGINT |
The primary key. |
|
NAME |
VARCHAR(255) |
The name of the view. |
|
DEFAULT_TEMPLATE |
SMALLINT/ TINYINT* |
Whether the template is the default template to be shown when initially logged in, only one view can have this value set to True. |
|
LANGUAGE_CODE |
VARCHAR(255) |
Deprecated. |
|
INCLUDE_HEADER |
SMALLINT/ TINYINT* |
Deprecated. |
|
WRAP_FIELDS |
SMALLINT/ TINYINT* |
Deprecated. |
|
DESCRIPTION |
VARCHAR(4000) |
The description of the view. |
|
IS_SYSTEM |
SMALLINT/ TINYINT* |
This field indicates whether the template is in system view, which cannot be edited or deleted. |
|
IDENTIFIER_FIELD |
VARCHAR(255) |
The identifier field chosen for this view. |
*This data type is required for Microsoft SQL Server.
DATA_EXPORT_FIELDS
This table contains the fields included in each view.
|
Field Name |
Data Type |
Description |
|---|---|---|
|
FIELD_INDEX |
Integer |
The primary key. |
|
FIELD |
VARCHAR(255) |
The name of the field to be included in the view. |
|
DATA_EXPORT_ID |
BIGINT |
The foreign key to DATA_EXPORT_TEMPLATE.DATA_EXP ORT_ID. |