System Tables

You are looking at an older version of the documentation. The latest version is found here.

System tables provide information on different resources in the system: virtual databases, schemas, views, permissions, and so on. This page describes all available tables grouped by the resources they contain data on.

Please note that the data source, tables, and other information are only visible to the user if one of the user's roles has permission to access this resource. Only data for data sources covered by their access permissions will be displayed.

VDB, Schema, and Properties

SYSADMIN.VDBResources

This table provides the current VDB contents.

Column Name	Type	Description
`resourcePath`	string	Path to the contents
`contents`	blob	Contents as a blob

SYS.VirtualDatabases

This table supplies information about the currently connected virtual database, of which there is always precisely one (in the context of a connection).

Column Name	Type	Description
`Name`	string	Name of the VDB
`Version`	string	Version of the VDB

SYS.Schemas

This table supplies information about all the schemas in the virtual database, including the system schema itself (System).

Column Name	Type	Description
`VDBName`	string	VDB name
`Name`	string	Schema name
`IsPhysical`	boolean	`TRUE` if represents a source
`UID`	string	Unique ID
`Description`	string	Description
`PrimaryMetamodelURI`	string	URI for the primary meta-model describing the model used for this schema
`OID`	integer	Unique ID

SYS.Properties

This table supplies user-defined properties of all objects based on meta-model extensions. Typically, this table is empty if no meta-model extensions are used.

Column Name	Type	Description
`Name`	string	Extension property name
`Value`	string	Extension property value
`UID`	string	Key unique ID
`OID`	integer	Unique ID
`ClobValue`	clob	Clob representation of value, if not `NULL`

SYSADMIN.SystemProperties

This table supplies user-defined properties. Stored per VDB, not available from other VDBs.

Column Name	Type	Description
`ID`	biginteger	System property unique ID
`propType`	string	System property type
`propKey`	string	System property unique key
`properties`	string	Property string
`creationDate`	timestamp	System property creation time
`lastModifiedDate`	timestamp	System property edit date, if applicable
`creator`	string	Creator's username
`modifier`	string	Modifier's username, if applicable

SYSADMIN_VDB.SSHTunnel

The SYSADMIN_VDB.SSHTunnel table holds and controls all existing SSH tunnels.

Field name	Field type	Mandatory	Description
`id`	biginteger	`NOT NULL`	Unique identifier
`name`	string(255)	`NOT NULL`	Unique name of an SSH tunnel
`localHost`	string(255)	`NOT NULL`	Host of a client's machine (default: `localhost`)
`localPort`	integer	`NOT NULL`	Port of a client's machine
`remoteHost`	string(255)	`NOT NULL`	Host of a remote machine
`remotePort`	integer	`NOT NULL`	Port of a remote machine
`host`	string(255)	`NOT NULL`	Username and host used for connecting to a remote machine via SSH protocol (format: `username@host`)
`portForwardingType`	string(1)	`NOT NULL`	Type of SSH port forwarding (default: `L`). As the Data Virtuality Server supports only local port forwarding at the moment, the field can have only `L` value
`sshPort`	integer	`NOT NULL`	Port used by the SSH server on a remote machine (default: 22)
`sshProperties`	string	`NULL`	SSH comma-separated properties in CSV-like form: `property1=<value1>,property2=<value2>`. Used to provide a timeout, cypher parameters, key parameters like used algorithms, a possibility to provide classes for custom algorithms, and so on
`password`	string(255)	`NULL`	Password used for simple authentication on the SSH server (encrypted)
`passPhrase`	string(255)	`NULL`	Password phrase used in case of a secured private key and key authentication on the SSH server (encrypted)
`privateKey`	string(4096)	`NULL`	Private key used for key authentication on the SSH server
`proxy`	string(255)	`NULL`	Proxy type
`proxyHost`	string(255)	`Null`	Proxy host
`proxyPort`	integer	`NULL`	Proxy port
`proxyUser`	string(255)	`NULL`	Proxy user name.
`proxyPassword`	string(255)	`NULL`	Proxy user password (encrypted).
`state`	string(128)	`NOT NULL`	State of a particular SSH tunnel (possible values: `SUCCESS` or `FAILED`). A special refresh daemon controls all SSH tunnels by a timeout (60 secs) to re-create an SSH tunnel in case it failed
`failureReason`	string(4096)	`NULL`	Failure reason in case a particular SSH tunnel failed
`creationDate`	timestamp	`NOT NULL`	Date of creation of the SSH tunnel
`lastModifiedDate`	timestamp	`NOT NULL`	Date of latest modification of an SSH tunnel
`creator`	string(255)	`NOT NULL`	Username of the person who created the SSH tunnel
`modifier`	string(255)	`NOT NULL`	Username of the person who modified the SSH tunnel
`keyPairId`	integer	`NULL`	ID of a key-pair in the `SYSADMIN_VDB.SSHCredentials` table

keyPairId column is available since v2.4.2.3

SYSADMIN_VDB.SSHCredentials

This table holds and controls all key pairs generated by the Data Virtuality Server and used by SSH tunnels:

Field name	Field type	Mandatory	Description
`id`	biginteger	`NOT NULL`	Unique identifier
`name`	string	`NULL`	Name of the key pair. Must be unique
`privateKey`	string	`NOT NULL`	Private key
`publicKey`	string	`NOT NULL`	Public key
`createionDate`	timestamp	`NOT NULL`	Date of creation of the key pair
`creator`	string	`NOT NULL`	Username of the person who created the key pair
`lastModifiedDate`	timestamp	`NOT NULL`	Date of the latest modification of the key pair
`modifier`	string	`NOT NULL`	Username of the person who modified the key pair

Table Metadata

SYS.Tables

This table supplies information about all the groups (tables, views, documents, etc.) in the virtual database.

Column Name	Type	Description
`VDBName`	string	VDB name
`SchemaName`	string	Schema name
`Name`	string	Short group name
`Type`	string	Table type (Table, View, Document, etc.)
`NameInSource`	string	Name of this group in the source
`IsPhysical`	boolean	`TRUE` if this is a source table
`SupportsUpdates`	boolean	`TRUE` if the group can be updated
`UID`	string	Group unique ID
`Cardinality`	integer	Approximate number of rows in the group
`Description`	string	Description
`IsSystem`	boolean	`TRUE` if in the system table
`IsMaterialized`	boolean	Defines whether the corresponding table/view is materialized or cached in Teiid
`OID`	integer	Unique ID

SYSADMIN.MatViews

This table supplies information about all the materialized views in the virtual database.

Column Name	Type	Description
`VDBName`	string	VDB name
`SchemaName`	string	Schema name
`Name`	string	Short group name
`TargetSchemaName`	string	Name of the materialized table schema
`TargetName`	string	Name of the materialized table
`Valid`	boolean	`TRUE` if the materialized table is currently valid
`LoadState`	boolean	Load state, can be one of `NEEDS_LOADING`, `LOADING`, `LOADED`, `FAILED_LOAD`
`Updated`	timestamp	Timestamp of the last full refresh
`Cardinality`	integer	Number of rows in the materialized view table

SYS.Columns

This table supplies information about the virtual database's elements (columns, tags, attributes, etc.).

Column Name	Type	Description
VDBName	string	VDB name
`SchemaName`	string	Schema name
`TableName`	string	Table name
`Name`	string	Element name (not qualified)
`Position`	integer	Position in the group (1-based)
`NameInSource`	string	Name of the element in the source
`DataType`	string	Data Virtuality Server runtime data type name
`Scale`	integer	Number of digits after the decimal point
`Length`	integer	Element length (mostly used for strings)
`isLengthFixed`	boolean	Whether the length is fixed or variable
`SupportsSelect`	boolean	Element can be used in `SELECT`
`SupportsUpdates`	boolean	Values can be inserted or updated in the element
`IsCaseSensitive`	boolean	Element is case-sensitive
`IsSigned`	boolean	Element is a signed numeric value
`IsCurrency`	boolean	Element represents monetary value
`IsAutoIncremented`	boolean	Element is auto-incremented in the source
`NullType`	string	Nullability: "`Nullable`", "`No Nulls`", "`Unknown`"
`MinRange`	string	Minimum value
`MaxRange`	string	Maximum value
`DistinctCount`	integer	Distinct value count, `-1` can indicate unknown
`NullCount`	integer	Null value count, `-1` can indicate unknown
`SearchType`	string	Searchability: "`Searchable`", "`All Except Like`", "`Like Only`", "`Unsearchable`"
`Format`	string	Format of the string value
`DefaultValue`	string	Default value
`JavaClass`	string	Java class that will be returned
`Precision`	integer	Number of digits as a numeric value
`CharOctetLength`	integer	Measure of return value size
`Radix`	integer	Radix for numeric values
`UID`	string	Element unique ID
`Description`	string	Description
`OID`	integer	Unique ID
`NativeType`	string	Data source native data type
`NativePrecision`	integer	Data source native precision
`NativeScale`	integer	Data source native scale
`NativeLength`	integer	Data source native length
`ColumnSize`	integer	For numeric data types, it is equal to the precision; For the character, it is equal to the length; For date/time, it is the string length of a literal value

Native information for JDBC data sources is presented as provided by their JDBC drivers.

ColumnSize column added in v2.4.3

SYS.Keys

This table supplies information about primary, foreign, and unique keys.

Column Name	Type	Description
`VDBName`	string	VDB name
`SchemaName`	string	Schema name
`Table Name`	string	Table name
`Name`	string	Key name
`Description`	string	Description
`NameInSource`	string	Name of key in source system
`Type`	string	Type of key: "`Primary`", "`Foreign`", "`Unique`", etc
`IsIndexed`	boolean	`TRUE` if the key is indexed
`RefKeyUID`	string	Referenced key UID (if foreign key)
`UID`	string	Key unique ID
`OID`	integer	Unique ID

SYS.KeyColumns

This table supplies information about the columns referenced by a key.

Column Name	Type	Description
`VDBName`	string	VDB name
`SchemaName`	string	Schema name
`TableName`	string	Table name
`Name`	string	Element name
`KeyName`	string	Key name
`KeyType`	string	Key type: "`Primary`", "`Foreign`", "`Unique`", etc
`RefKeyUID`	string	Referenced key UID
`UID`	string	Key UID
`Position`	integer	Position in key
`OID`	integer	Unique ID

SYS.ReferenceKeyColumns

Column Name	Type	Description
`PKTABLE_CAT`	string	Primary key catalogue
`PKTABLE_SCHEM`	string	Primary key schema
`PKTABLE_NAME`	string	Primary key table
`PKCOLUMN_NAME`	string	Primary key column name
`FKTABLE_CAT`	string	Foreign key catalogue
`FKTABLE_SCHEM`	string	Foreign key schema
`FKTABLE_NAME`	string	Foreign key table
`FKCOLUMN_NAME`	string	Foreign key column name
`KEY_SEQ`	short	Key sequence
`UPDATE_RULE`	integer	Update rule
`DELETE_RULE`	integer	Delete rule
`FK_NAME`	string	Foreign key name
`PK_NAME`	string	Primary key name
`DEFERRABILITY`	integer	Deferrability

Procedure Metadata

SYS.Procedures

This table supplies information about the procedures in the virtual database.

Column Name	Type	Description
`VDBName`	string	VDB name
`SchemaName`	string	Schema name
`Name`	string	Procedure name
`NameInSource`	string	Procedure name in source system
`ReturnsResults`	boolean	Returns a result set
`UID`	string	Procedure UID
`Description`	string	Description
`OID`	integer	Unique ID

SYS.ProcedureParams

This supplies information on procedure parameters.

Column Name	Type	Description
`VDBName`	string	VDB name
`SchemaName`	string	Schema name
`ProcedureName`	string	Procedure name
`Name`	string	Parameter name
`DataType`	string	Data Virtuality Server runtime data type name
`Position`	integer	Position in procedure arguments
`Type`	string	Parameter direction: "`In`", "`Out`", "`InOut`", "`ResultSet`", "`ReturnValue`"
`Optional`	boolean	Parameter is optional
`Precision`	integer	Precision of parameter
`TypeLength`	integer	Length of the parameter value
`Scale`	integer	Scale of parameter
`Radix`	integer	Radix of parameter
`NullType`	string	Nullability: "`Nullable`", "`No Nulls`", "`Unknown`"
`UID`	string	Procedure UID
`Description`	string	Procedure description
`OID`	string	Unique ID

Data Type Metadata

SYS.DataTypes

This table supplies information on data types.

Column Name	Type	Description
`Name`	string	Data Virtuality Server design-time type name
`IsStandard`	boolean	Always `FALSE`
`IsPhysical`	boolean	Always `FALSE`
`TypeName`	string	Design-time type name (same as `Name`)
`JavaClass`	string	Java class returned for this type
`Scale`	integer	Maximum scale of this type
`TypeLength`	integer	Maximum length of this type
`NullType`	string	Nullability: "`Nullable`", "`No Nulls`", "`Unknown`"
`IsSigned`	boolean	Whether it Is signed numeric
`IsAutoIncremented`	boolean	Whether it is auto-incremented
`IsCaseSensitive`	boolean	Whether it is case-sensitive
`Precision`	integer	Maximum precision of this type
`Radix`	integer	Radix of this type
`SearchType`	string	Searchability: "`Searchable`", "`All Except Like`", "`Like Only`", "`Unsearchable`"
`UID`	string	Data type unique ID
`RuntimeType`	string	Data Virtuality Server runtime data type name
`BaseType`	string	Base type
`Description`	string	Description of type
`OID`	integer	Unique ID

Connections and Models

SYSADMIN.Connections

This table supplies information on dynamic connections.

Column Name	Type	Description
`fullName`	string	Full connection name
`name`	string	Connection name
`jndiName`	string	JNDI name
`template`	string	Translator name (e.g. `postgresql`, `mysql`, etc.)
`properties`	string	Connection properties in the CSV format (e.g. `host=localhost`, `port=5432`, `db=test_tables`, `user-name=user1`, `password=pass1)`
`failed`	boolean	Flag to signal failed/not failed state of the connection
`connectionUrl`	string	Connection URL (e.g. `jdbc:postgresql://localhost:5432/test_tables`)
`driverName`	string	Name of the driver (e.g. `org.postgresql`)
`driverClass`	string	Name of the driver class (e.g. `org.postgresql.Driver`)
`userName`	string	Username
`archive`	string	Archive file used by the resource adapter
`className`	string	Class name
`configProperties`	string	Additional configuration properties
`creationDate`	timestamp	Timestamp and time when the connection was created
`lastModifiedDate`	timestamp	Timestamp when the connection was last modified
`creator`	string	User who created the connection
`modifier`	string	User who last modified the connection
`encryptedProperties`	string	Encrypted properties

SYSADMIN.DataSources

This table supplies information on dynamic models.

Column Name	Type	Description
`name`	string	Model name
`translator`	string	Translator name (e.g. `postgresql`, `mysql`, etc.)
`modelProperties`	string	Properties for the model (e.g. `importer.useFullSchemaName=false`, `import.schemaPattern=public`)
`translatorProperties`	string	Properties for the translator (e.g. `UseStreamingResults=true`)
`schema_text`	clob	DDL script for creating the schema
`failed`	boolean	Flag to signal failed/not failed state of the data source
`creationDate`	timestamp	Timestamp when the data source was created
`lastModifiedDate`	timestamp	Timestamp when the data source was last modified
`creator`	string	User who created the data source
`modifier`	string	User who modified the data source
`encryptedModelProperties`	string	Encrypted model properties
`encryptedTranslatorProperties`	string	Encrypted translator properties

SYSADMIN.CliTemplates

This table supplies information on JBoss CLI templates.

Column Name	Type	Description
`id`	biginteger	Template ID
`name`	string	Template name
`createScript`	string	CLI script which creates a data source/resource adapter
`dropScript`	string	CLI script which removes a data source/resource adapter
`creationDate`	timestamp	Template creation date
`lastModifiedDate`	timestamp	Template last modification date
`creator`	string	Name of the user who created the template
`modifier`	string	Name of the user who last modified the template
`hiddenProps`	string	Comma-separated list of properties that will be stored encrypted

SYSADMIN.ModularConnectors

This table supplies information about modular connectors available on the server.

Column Name	Type	Description
`name`	string	Name of the modular connector required by the `deployModularConnector` procedure
`deployed`	boolean	Flag indicating if the modular connector is deployed

SYSADMIN.Translators

This table is used by the license generator to validate the data sources provided in the allowedDatasources property.

Column Name	Type	Description
`name`	string	Translator name
`javaClass`	string	Translator java class

SYSADMIN.SmtpConfiguration

This table holds SMTP settings.

Column Name	Type	Description
`host`	string	SMTP server hostname/address
`port`	integer	SMTP server port
`ssl`	boolean	`TRUE` if the SMTP server requires SSL
`starttls`	boolean	`TRUE` if the SMTP server requires TLS
`username`	string	Username to connect to SMTP server if required
`password`	timestamp	Password to connect to SMTP server if required
`fromAddr`	string	Address to be used as 'from' address

Users, Roles and Permissions

SYSADMIN.Roles

This table supplies information on roles.

Column Name	Type	Description
`id`	biginteger	Role ID
`name`	string	Role name
`users`	string	Usernames in this role

SYSADMIN.Users

This table supplies information on users.

Column Name	Type	Description
`id`	biginteger	User ID
`name`	string	Username
`roles`	string	Role names of this user
`creationDate`	timestamp	Timestamp when the user data entry was created
`lastModifiedDate`	timestamp	Timestamp when the user data entry was last modified
`creator`	string	Name of the user who created the user data entry
`modifier`	string	Name of the user who last modified the user data entry

SYSADMIN.Permissions

This table supplies information on permissions.

Column Name	Type	Description
`role`	string	Role name
`resource`	string	Resource name
`permission`	string	Permission string
`creationDate`	timestamp	Timestamp when the permission was created
`lastModifiedDate`	timestamp	Timestamp when the data source was modified the last time
`creator`	string	Name of the user who created the permission
`modifier`	string	Name of the user who last modified the permission

Recommendation System

SYSADMIN.RecommendedOptimizations

This table supplies information on recommended optimizations.

Column Name	Type	Description
`Id`	biginteger	Optimization ID
`Type`	string	Materialization type of this optimization
`MatchDescriptor`	string	Match descriptor
`Freq`	biginteger	Frequency of this optimization
`Enabled`	boolean	Flag to signal if the optimization is enabled or not
`matTablePrefix`	string	Prefix used for the set of materialized tables associated with this optimization
`sourceState`	string	State of the source tables
`sourceStateComment`	string	Reason why the source state is `NOT_AVAILABLE`. If the state is OK, the value of this field should be null
`dwhState`	string	State of the analytical storage schema
`dwhStateComment`	string	Reason why the analytical storage state is `NOT_AVAILABLE`. If the state is OK, the value of this field should be null
`lastReplicationState`	string	State of the last replication task
`lastReplicationStateComment`	string	Reason why the last replication execution failed. If the state is OK, the value of this field should be null
`nextSelectState`	string	Possible state of the next select query execution
`nextReplicationState`	string	Possible state of the next replicator execution
`lastUsed`	timestamp	Timestamp when the corresponding query was last executed
`lastMaterialized`	timestamp	Timestamp when the optimization was last materialized
`allowIndexCreationByType`	string	***
`allowIndexCreationByStatus`	string	***

SYSADMIN.RecOptSymbols

This table supplies information on symbols (group by symbols, aggregate functions, etc.) associated with a MAT_AGGR optimization.

Column Name	Type	Description
`ID`	biginteger	Symbol ID
`recOptID`	biginteger	ID of the associated optimization
`symbol`	string	Actual symbol or expression (e.g. `SUM(views.v1.a)`)
`type`	string	Optimization symbol type (e.g. `AGGR`, `GROUP_BY`)
`aggrFunction`	string	Aggregation function (e.g. `SUM`). Can be null
`alias`	string	Alias of the symbol used in the materialized table (e.g. `sum_views_v1_a_`)

SYSADMIN.RecommendedIndexes

This table supplies information on recommended indexes.

Column Name	Type	Description
`id`	biginteger	Index ID
`columnName`	string	Column name
`type`	string	Index type (e.g. `JOIN`, `WHERE`, etc.)
`kind`	string	***
`freq`	biginteger	***
`status`	string	***
`recOptID`	biginteger	ID of the associated optimization
`parentRecOptID`	biginteger	ID of the parent optimization (in case of `JOIN` type). Can be null

SYSADMIN.MaterializedTable

This table supplies information on materialized tables.

Column Name	Type	Description
`ID`	biginteger	ID of the materialized table
`recOptID`	biginteger	ID of the associated recommended optimization
`name`	string	Materialized table name
`type`	string	Materialization type (e.g. `MAT_TABLE`, `MAT_JOIN`, `MAT_AGGR`)
`accessState`	string	State of the materialized table during the replication process (e.g. `READY`, `UPDATING`, `INCOMPLETE`, etc.)
`creationTime`	timestamp	Timestamp when the materialized table was created
`lastModified`	timestamp	Timestamp when the materialized table was last modified

Schedules and Jobs

SYSADMIN.ScheduleJobExtraProperties

This table supplies information on all additional properties of jobs.

Column Name	Type	Description
`jobId`	biginteger	Job ID
`name`	string	Property name
`val`	string	Property value

SYSADMIN.ScheduleJobs

This table supplies information on jobs.

Column Name	Type	Description
`id`	biginteger	Job ID
`jobName`	string	Unique name
`jobType`	string	Job type (e.g. recommended optimization, cleanup, etc.)
`description`	string	Description of the current job
`script`	clob	Script data (specific for SQL jobs)
`disabled`	boolean	Flag to signal whether the job is enabled or disabled
`deletable`	boolean	Flag to signal whether jobs of a particular type may be deleted
`incremental`	boolean	Flag to signal whether jobs should be executed for an incremental update (specific for optimization jobs)
`newRowCheckExpression`	string	New row check expression (specific for incremental optimization jobs)
`identityExpression`	string	Identity expression (specific for incremental optimization jobs)
`deleteOldData`	boolean	Flag to signal if an incremental job should delete old data or not (specific for incremental optimization jobs)
`allowIndexCreation`	string	Types of indexes allowed for this optimization job (specific for optimization jobs)
`gatherNativeStats`	boolean	Flag to signal if native statistics should be gathered or not when a replication job is completed (specific for optimization jobs)
`indexCreationByStatus`	string	String representing the status that the indexes must have to be created after completing the replication
`groupId`	biginteger	Optimization ID (specific for optimization jobs)
`parallelRunsAllowed`	integer	Number of parallel runs allowed for the job
`retryCounter`	integer	Number of job retry attempts in case the job is failing
`retryDelay`	integer	Delay in seconds between the retry attempts
`runTimeout`	integer	Timeout configured individually for this job if any (in minutes)
`running`	boolean	Indicates if `scheduleJob` is currently running or not
`lastExecutionStatus`	string	Status of last execution of `scheduleJob`
`lastExecutionFailureReason`	string	Reason why the execution of `scheduleJob` failed
`creationDate`	timestamp	Timestamp when `scheduleJob` was created
`lastModifiedDate`	timestamp	Timestamp when `scheduleJob` was last modified
`creator`	string	Account that was used to create `scheduleJob`
`modifier`	string	Account that was used to last modify `scheduleJob`
`lastWarnings`	string	Warnings risen during the last job run if any

lastWarnings column is available since v2.4.3

SYSADMIN.Schedules

This table supplies information on schedules.

Column Name	Type	Description
`id`	biginteger	Schedule ID
`jobID`	biginteger	Job ID
`type`	string	Schedule type
`interval`	biginteger	Interval in minutes
`startDelay`	biginteger	Start delay in minutes
`cronExpression`	string	Cron expression
`enabled`	boolean	Flag to signal if the schedule is enabled or not
`chainString`	string	***
`nextFireTime`	timestamp	Timestamp of next expected execution
`creationDate`	timestamp	Timestamp of schedule creation
`lastModifiedDate`	timestamp	Timestamp of schedule modification
`creator`	string	User who created the schedule
`modifier`	string	User who modified the schedule
`scheduleName`	string	Unique name for the schedule

Virtual Schemas, Views, and Procedures

SYSADMIN.VirtualSchemas

This table supplies information on virtual schemas.

Column Name	Type	Description
`id`	biginteger	Virtual schema ID
`name`	string	Virtual schema name
`deletable`	boolean	Flag to signal whether virtual schema can be deleted or not
`creationDate`	timestamp	Timestamp when the virtual schema was created
`lastModifiedDate`	timestamp	Timestamp when the virtual schema was last modified
`creator`	string	Name of the user who created the schema
`modifier`	string	Name of the user who last modified the schema

SYSADMIN.ViewDefinitions

This table supplies information on view definitions.

Column Name	Type	Description
`name`	string	View name
`definition`	string	SQL script defining how to create the view
`creationDate`	timestamp	Timestamp when the view was created
`lastModifiedDate`	timestamp	Timestamp when the view was last modified
`state`	string	State of the view (e.g. `READY`, `WARNING`, `FAILED`)
`failureReason`	string	Reason why the view has `FAILED` state
`inSyncWithSource`	boolean	Flag to signal whether the view is in sync with the source tables or not
`notInSyncReason`	string	Reason why a view is not in sync with the source
`creator`	string	Name of the user who created the view definition
`modifier`	string	Name of the user who last modified the view definition

SYSADMIN.ProcDefinitions

This table supplies information on procedure definitions.

Column Name	Type	Description
`name`	string	Procedure name
`definition`	string	SQL script defining how to create the procedure
`creationDate`	timestamp	Timestamp when the procedure was created
`lastModifiedDate`	timestamp	Timestamp when the procedure was last modified
`state`	string	State of the procedure (e.g. `READY`, `WARNING`, `FAILED`)
`failureReason`	string	Reason why the procedure has `FAILED` state
`creator`	string	Name of the user who created the procedure
`modifier`	string	Name of the user who last modified the procedure

Logs and History

SYSLOG.CliTemplateHistory

This table supplies the history of CliTemplates modifications.

Column Name	Type	Description
`id`	biginteger	Log record ID
`name`	string	`CliTemplate` name
`createScript`	string	`CliTemplate` create script
`dropScript`	string	`CliTemplate` drop script
`parentId`	biginteger	ID of the respective record in the `SYSADMIN.CliTemplates` table
`oldname`	string	Old name of `CliTemplate` if changed
`operationType`	string	Type of operation performed
`operationTime`	timestamp	Timestamp of operation
`operationUsername`	string	Name of the user who performed the operation

SYSLOG.ConnectionHistory

This table supplies the history of connection modifications.

Column Name	Type	Description
`id`	biginteger	Log record ID
`jndiName`	string	Connection name
`template`	string	Connection template
`properties`	string	Connection properties
`encryptedProperties`	string	Connection encrypted properties
`parentId`	biginteger	ID of the respective record in the `SYSADMIN.Connections` table
`oldname`	string	Not used
`operationType`	string	Type of operation performed
`operationTime`	timestamp	Timestamp of operation
`operationUsername`	string	Name of the user who performed the operation

SYSLOG.DataAttributesHistory

This table supplies the history of data attributes applied to views and tables.

Column Name	Type	Description
`id`	biginteger	Log record ID
`name`	string	Object name
`attributes`	string	Attributes applied to the object
`parentId`	biginteger	ID of the respective record in the `SYSADMIN.DataCatalogAttributes` table
`oldname`	string	Not used
`operationType`	string	Type of operation performed
`operationTime`	timestamp	Timestamp of operation
`operationUsername`	string	Name of the user who performed the operation

SYSLOG.DataSourceHistory

This table supplies the history of data source modifications.

Column Name	Type	Description
`id`	biginteger	Log record ID
`name`	string	Data source name
`translator`	string	Translator used by the data source
`modelProperties`	string	Properties of the data source model
`translatorProperties`	string	Properties of the translator used by the data source
`encryptedModelProperties`	string	Encrypted properties of the data source model
`encryptedTranslatorProperties`	string	Encrypted properties of the translator used by the data source
`parentId`	biginteger	ID of the respective record in the `SYSADMIN.DataSources` table
`oldname`	string	Not used
`operationType`	string	Type of operation performed
`operationTime`	timestamp	Timestamp of the operation
`operationUsername`	string	Name of the user who performed the operation

SYSLOG.JobEmailNotificationHistory

This table supplies the history of email notification job modifications.

Column Name	Type	Description
`id`	biginteger	Log record ID
`jobStatuses`	string	Statuses that initiate email notification job
`subject`	string	Custom email notification subject if applicable
`message`	string	Custom email notification message if applicable
`reciepients`	string	Recipients of email notification
`isglobal`	boolean	Whether or not the email notification is global
`parentId`	biginteger	ID of the respective record in the `SYSADMIN.JobEmailNotifications` table
`oldname`	string	Not used
`operationType`	string	Type of operation performed
`operationTime`	timestamp	Timestamp of operation
`operationUsername`	string	Name of the user who performed the operation

SYSLOG.JobLogs

This table supplies the history of the running or executed jobs.

Column Name	Type	Description
`jobType`	string	Job type (e.g. recommended optimization, cleanup, etc.)
`details`	string	SQL command for SQL jobs Job title for other jobs
`targetSchemaNameOriginal`	string	Original analytical storage name in the DBMS
`targetSchemaNameInTeiid`	string	Analytical storage name visible in the Data Virtuality Server
`datasource`	string	Data source (specific for Statistics jobs)
`gatherTableCardinalities`	boolean	Flag to signal if gathering statistics for tables or not (specific for Statistics jobs)
`gatherColumnCardinalities`	boolean	Flag to signal if gathering statistics for columns or not (specific for Statistics jobs)
`gatherNetworkStats`	boolean	Flag to signal if gathering network statistics or not (specific for Statistics jobs)
`excludeTables`	string	Tables to exclude (specific for Statistics jobs)
`incremental`	boolean	Flag to signal whether jobs should be executed for an incremental update (specific for optimization jobs)
`newRowCheckExpression`	string	New row check expression (specific for incremental optimization jobs)
`identityExpression`	string	Identity expression (specific for incremental optimization jobs)
`deleteOldData`	boolean	Flag to signal if an incremental job should delete old data or not (specific for incremental optimization jobs)
`allowIndexCreation`	string	Types of indexes allowed for this optimization job (specific for optimization jobs)
`gatherNativeStats`	boolean	Flag to signal if native statistics should be gathered or not when a replication job is completed (specific for optimization jobs)
`indexCreationByStatus`	string	String representing the status that the indexes must have to be created after completing the job run
`groupId`	biginteger	Optimization ID (specific for optimization jobs)
`jobId`	biginteger	Job ID
`scheduleid`	biginteger	Schedule ID
`startTime`	timestamp	Start time of the job run
`endTime`	timestamp	End time of the job run
`outTime`	timestamp	End time of the job run if caused by a timeout
`status`	string	Status of the job run (e.g. `running`, `finished`, `failed`)
`failureReason`	string	Reason why the job failed (if the status is `failed`)
`warnings`	string	Warnings risen during the job run if any
`jobdescr`	string	Job description

Since v2.4.2, warnings are in XML format

The Jobdescr column is available since v2.4.3

SYSLOG.OptHistory

This table supplies the history of options modifications.

Column Name	Type	Description
`id`	biginteger	Log record ID
`name`	string	Option name
`value`	string	Option value
`parentId`	biginteger	ID of the respective record in the `SYSADMIN.OptionValues` table
`oldname`	string	Not used
`operationType`	string	Type of operation performed
`operationTime`	timestamp	Timestamp of operation
`operationUsername`	string	Name of the user who performed the operation

SYSLOG.PermissionHistory

This table supplies the history of permissions modifications.

Column Name	Type	Description
`id`	biginteger	Log record ID
`role`	string	Role to which permissions were applied to or removed from
`resource`	string	Rresource to which the permission applies to
`permission`	string	Permission granted or removed
`parentId`	biginteger	ID of the respective record in the `SYSADMIN.Permissions` table
`oldname`	string	Not used
`operationType`	string	Type of operation performed
`operationTime`	timestamp	Timestamp of operation
`operationUsername`	string	Name of the user who performed the operation

SYSLOG.ProcDefinitionHistory

This table supplies the history of procedure modifications.

Column Name	Type	Description
`id`	biginteger	Log record ID
`name`	string	Name of procedure
`definition`	string	Procedure definition
`parentId`	biginteger	ID of the respective record in the `SYSADMIN.ProcDefinitions` table
`oldname`	string	Not used
`operationType`	string	Type of operation performed
`operationTime`	timestamp	Timestamp of operation
`operationUsername`	string	Name of the user who performed the operation

SYSLOG.QueryLogs

This table supplies the history of the running or executed queries

Column Name	Type	Description
`id`	biginteger	Query ID
`vdbid`	biginteger	ID of the virtual database where the query was started
`vdbname`	string	Name of the virtual database where the query was started
`sessionId`	string	Session ID
`requestId`	biginteger	Request ID
`query`	string	Actual query
`startTime`	timestamp	Start time of the query
`startRunningTime`	timestamp	Start time of status `RUNNING`
`startFetchingTime`	timestamp	Start time of status `FETCHING`
`endTime`	timestamp	End time of the query
`state`	string	State of the query (e.g `running`, `finished`, `failed`, etc.)
`failureReason`	string	Reason why the query failed
`issuer`	string	User who executed the query
`warnings`	string	Warnings risen during the query execution if any

Since v2.4.2, warnings are in XML format

vdbid and vdbname columns are available since v2.4.12

SYSLOG.QueryPerformanceLog

This table supplies performance metrics of the running or executed queries.

Field name	Type	Description
`id`	biginteger	Query ID
`type`	string(128)	Request type
`sessionId`	string(32)	Session ID used for query
`requestId`	long	Query request index (index number within one session ID)
`userName`	string	Name of the user who issued the query or "`system`" by default
`query`	string(4096)	Query text
`state`	string(128)	Query state
`startTime`	timestamp	Query start time
`updateTime`	timestamp	Query update time
`totalBuffers`	long	Total buffers used by the query in the Data Virtuality Server
`bufferDiskUsage`	long	Total buffers disk space used by the query (in bytes) in the Data Virtuality Server
`bufferMemoryUsage`	long	Total buffers memory space used by the query (in bytes) in the Data Virtuality Server
`queryHeapAllocated`	long	Total heap memory allocated by a thread for queries (in bytes)
`cpuTimeInMicros`	long	Total CPU time used by all queries' threads (in microseconds). A Java virtual machine implementation may support measuring the CPU time for the current thread. The Data Virtuality Server queries work within separate threads. So we can measure the CPU time between starting and finishing a query (note that an erroneous or cancelled query will also have some finishing point) that is between two points of a working thread
`cpuUsageInPercent`	float	Total CPU time used by all queries' threads (in per cent)

SYSLOG.RoleHistory

This table supplies the history of role modifications.

Column Name	Type	Description
`id`	biginteger	Log record ID
`name`	string	Name of the role
`permanent`	boolean	Flag indicating if the role is static
`allowCreateTempTables`	boolean	Flag indicating if the role is allowed to create templates
`parentId`	biginteger	ID of the respective record in the `SYSADMIN.Roles` table
`oldname`	string	Old name of the role if changed
`operationType`	string	Type of operation performed
`operationTime`	timestamp	Timestamp of operation
`operationUsername`	string	Name of the user who performed the operation

SYSLOG.SSHCredentialsHistory

This table supplies SSH Credentials history.

Column Name	Type	Description
`id`	biginteger	Log record ID
`name`	string	Name of the SSH credentials key-value pair
`oldname`	string	Old name of the SSH credentials key-value pair, if changed
`publicKey`	string	Public key
`privateKey`	string	Private key
`parentId`	biginteger	ID of the respective record in the `SYSADMIN_VDB.SSHCredentials` table
`operationType`	string	Type of operation performed
`operationTime`	timestamp	Timestamp of operation
`operationUsername`	string	Name of the user who performed the operation

SYSLOG.SSHCredentialsHistory is available since v2.4.5

SYSLOG.SSHTunnelHistory

This table supplies an SSH Tunnels history.

Column Name	Type	Description
`id`	biginteger	Log record ID
`name`	string	Name of the SSH Tunnel
`localHost`	string	Host of the client's machine
`localPort`	integer	Port of the client's machine
`remoteHost`	string	Host of the remote machine
`remotePort`	integer	Port of the remote machine
`host`	string	Username and host used for connecting to a remote machine via SSH protocol
`portForwardingType`	string	Type of SSH port forwarding
`sshPort`	integer	Port used by SSH Server on the remote machine
`sshProperties`	string	SSH comma-separated properties in CSV-like form
`password`	string	Password used for simple authentication on the SSH server
`passPhrase`	string	Password phrase used in case of a secured private key and key authentication on the SSH server
`privateKey`	string	Private key used for key authentication on the SSH server
`parentId`	biginteger	ID of the respective record in the `SYSADMIN_VDB.SSHTunnel` table
`operationType`	string	Type of operation performed
`operationTime`	timestamp	Timestamp of operation
`operationUsername`	string	Name of the user who performed the operation

SYSLOG.ScheduleHistory

This table supplies the history of schedule modifications.

Column Name	Type	Description
`id`	biginteger	Log record ID
`type`	string	Schedule type
`intervl`	biginteger	How often to repeat the job in minutes
`startDelay`	biginteger	Initial delay before running the job
`cronExpression`	string	Quartz Cron Expression which specifies the schedule
`enabled`	boolean	Flag indicating whether the schedule is active
`chainString`	string	Logical expression for dependencies on other jobs
`parentId`	biginteger	ID of the respective record in the `SYSADMIN.Schedules` table
`oldname`	string	Not used
`operationType`	string	Type of operation performed
`operationTime`	timestamp	Timestamp of operation
`operationUsername`	string	Name of the user who performed the operation

SYSLOG.ScheduleJobHistory

This table supplies the history of scheduled job modifications.

Column Name	Type	Description
`id`	biginteger	Log record ID
`jobType`	string	Job type
`description`	string	Job description
`script`	string	Job creation script
`deletable`	boolean	Flag indicating whether the job is deletable
`incremental`	boolean	Flag indicating whether the job is incremental
`newRowCheckExpression`	string	String representing the check expression for the `incremental-optimization-schedule-job`
`identityExpression`	string	String representing the identity expression for the `incremental-optimization-schedule-job` expressed in SQL language
`deleteOldData`	boolean	Flag indicating how the data in the materialized table is treated
`allowIndexCreation`	string	String representing the types of indexes that the system must create after completing the replication
`gatherNativeStats`	boolean	Flag indicating whether native statics on the materialized table should be gathered or not when the replication has been completed
`indexCreationByStatus`	string	String representing the status that the indexes must have to be created after completing the replication
`parallelRunsAllowed`	integer	Number indicating how many parallel runs of this job will be started
`parentId`	biginteger	ID of the respective record in the `SYSADMIN.ScheduleJobs` table
`oldname`	string	Not used
`operationType`	string	Type of operation performed
`operationTime`	timestamp	Timestamp of operation
`operationUsername`	string	Name of the user who performed the operation

SYSLOG.SystemPerformanceLog

Total info about used heap memory, GC parameters, teiid system parameters and so on internally from Data Virtuality Server and JVM:

Field name	Type	Description
`id`	biginteger	Log record ID
`updateTime`	timestamp	Time when the data was requested
`committedVirtualMemorySize`	long	Amount of virtual memory that is guaranteed to be available to the running process, or `-1` if this operation is not supported
`freePhysicalMemorySize`	long	Amount of free physical memory
`freeSwapSpaceSize`	long	Amount of free swap memory space
`physicalMemoryUsageInPercent`	float	Amount of physical memory that is used by the JVM, per cent
`processCpuLoadInPercent`	float	Amount of CPU load, as a value between 0.0 and 100.0, used by the JVM. When this value is 0.0, the JVM does not use the CPU. If the recent CPU load is not available, the value will be negative
`processCpuTime`	long	CPU time used by the process on which the JVM is running in nanoseconds. The returned value is of nanoseconds precision but not necessarily nanoseconds accuracy. This method returns -1 if the platform does not support this operation
`systemCpuLoadInPercent`	float	CPU load of the machine running the JVM in per cent of maximal usage. The machine is running on full load when it reaches 100. If the recent CPU load is not available, the value will be negative
`systemLoadAverageInPercent`	float	System load average for the last minute (or a negative value if not available)
`threadCount`	integer	Current number of live threads, including both daemon and non-daemon threads
`daemonThreadCount`	integer	Current number of live daemon threads
`totalPhysicalMemorySize`	long	Total amount of physical memory
`totalJVMMemorySize`	long	Total amount of memory available to the Java virtual machine
`usedJVMMemorySize`	long	Amount of memory that the Java virtual machine is using
`totalSwapSpaceSize`	long	Total amount of swap space memory
`usedPhysicalMemorySize`	long	Amount of memory the system is using
`usedSwapSpaceSize`	long	Amount of memory the system is swapping
`committedHeapMemory`	long	Amount of memory committed to the Java heap
`usedHeapMemory`	long	Amount of used memory on the Java heap
`freeHeapMemory`	long	Amount of free memory on the Java heap
`heapMemoryUsageInPercent`	float	Amount of used Java heap, per cent
`committedNonHeapMemory`	long	Amount of memory committed to the Java non-heap
`usedNonHeapMemory`	long	Amount of used memory on the Java non-heap
`freeNonHeapMemory`	long	Amount of free memory on the Java non-heap
`nonHeapMemoryUsageInPercent`	float	Amount of used Java non-heap, per cent
`committedHeapEdenSpace`	long	Amount of memory committed to the Java heap Eden Space
`usedHeapEdenSpace`	long	Amount of used memory on the Java heap Eden Space
`freeHeapEdenSpace`	long	Amount of free memory on the Java heap Eden Space
`heapEdenSpaceUsageInPercent`	float	Amount of used Java heap Eden Space, per cent
`committedHeapOldGen`	long	Amount of memory committed to the Java heap Old (Tenured) Generation
`usedHeapOldGen`	long	Amount of used memory on the Java heap Old (Tenured) Generation
`freeHeapOldGen`	long	Amount of free memory on the Java heap Old (Tenured) Generation
`heapOldGenUsageInPercent`	float	Amount of used Java heap Old (Tenured) Generation, per cent
`committedHeapSurvivorSpace`	long	Amount of memory committed to the Java heap Survivor Space
`usedHeapSurvivorSpace`	long	Amount of used memory on the Java heap Survivor Space
`freeHeapSurvivorSpace`	long	Amount of free memory on the Java heap Survivor Space
`heapSurvivorSpaceUsageInPercent`	float	Amount of used Java heap Survivor Space, per cent
`committedNonHeapPermGen`	long	Amount of memory committed to the Java non-heap Permanent Generation
`usedNonHeapPermGen`	long	Amount of used memory on the Java non-heap Permanent Generation
`freeNonHeapPermGen`	long	Amount of free memory on the Java non-heap Permanent Generation
`nonHeapPermGenUsageInPercent`	float	Amount of used Java non-heap Permanent Generation, per cent
`committedNonHeapCodeCache`	long	Amount of memory committed to the Java non-heap Code Cache
`usedNonHeapCodeCache`	long	Amount of used memory on the Java non-heap Code Cache
`freeNonHeapCodeCache`	long	Amount of free memory on the Java non-heap Code Cache
`nonHeapCodeCacheUsageInPercent`	float	Amount of used Java non-heap Code Cache, per cent
`collectionTimePSMarkSweepGC`	long	Accumulated collection time spent by PS Mark Sweep Garbage Collector
`collectionCountPSMarkSweepGC`	long	Total number of collections performed by PS Mark Sweep Garbage Collector
`collectionTimePSScavengeGC`	long	Accumulated collection time performed by PS Scavenge Garbage Collector
`collectionCountPSScavengeGC`	long	Total number of collections performed by PS Scavenge Garbage Collector
`collectionTimeG1OldGenGC`	long	Accumulated collection time spent by G1 Old Generation Garbage Collector
`collectionCountG1OldGenGC`	long	Total number of collections performed by G1 Old Generation Garbage Collector
`collectionTimeG1YoungGenGC`	long	Accumulated collection time spent by G1 Young Generation Garbage Collector
`collectionCountG1YoungGenGC`	long	Total number of collections performed by G1 Young Generation Garbage Collector
`sessionCount`	integer	Number of user connections currently active
`queryCount`	integer	Number of queries currently active
`activeQueryPlanCount`	integer	Number of query plans currently being processed
`waitingQueryPlanCount`	integer	Number of query plans currently waiting
`maxWaitingQueryPlanWatermark`	integer	Maximum number of query plans that have been waiting at one time since the last time the server started
`longRunningQueries`	integer	Currently executing queries that have surpassed the query threshold (`query-threshold-in-seconds`)
`bufferDiskWriteCount`	long	Disk write count for the buffer manager
`bufferDiskReadCount`	long	Disk read count for the buffer manager
`bufferCacheWriteCount`	long	Cache write count for the buffer manager
`bufferCacheReadCount`	long	Cache read count for the buffer manager
`bufferDiskSpaceUsedInMb`	long	Amount of storage space currently used by buffer files
`totalBufferMemoryUsageInKb`	long	Estimate of the current memory usage in kilobytes by the buffer manager
`totalBufferMemoryUsageByActivePlansInKb`	long	Estimate of current memory usage by active plans by buffer manager in kilobytes
`preparedPlanCacheTotalEntries`	integer	Current number of entries in the Prepared Plan cache
`preparedPlanCacheRequestCount`	integer	Total number of requests made against Prepared Plan cache
`preparedPlanCacheHitRatioInPercent`	float	Positive Prepared Plan cache hits, per cent
`resultSetCacheTotalEntries`	integer	Current number of entries in the `ResultSet` cache
`resultSetCacheRequestCount`	integer	Total number of requests made against the `ResultSet` cache
`resultSetCacheHitRatioInPercent`	float	Positive `ResultSet` cache hits, per cent

SYSLOG.SystemPropertiesHistory

This table supplies the history of system properties modifications.

Column Name	Type	Description
`id`	biginteger	Log record ID
`propType`	string	Property type
`propKey`	string	Property key
`properties`	string	Properties
`parentId`	biginteger	ID of the respective record in the `SYSADMIN.SystemProperties` table
`operationType`	string	Type of operation performed
`operationTime`	timestamp	Timestamp of operation
`operationUsername`	string	Name of the user who performed the operation

SYSLOG.UserHistory

This table supplies the history of user records modifications.

Column Name	Type	Description
`id`	biginteger	Log record ID
`name`	string	User name
`pwd`	string	Password, encrypted
`parentId`	biginteger	ID of the respective record in the `SYSADMIN.Users` table
`oldname`	string	Old name of the user if changed
`operationType`	string	Type of operation performed
`operationTime`	timestamp	Timestamp of operation
`operationUsername`	string	Name of the user who performed the operation

SYSLOG.UserRoleHistory

This table supplies the history of user roles modifications.

Column Name	Type	Description
`id`	biginteger	Log record ID
`userName`	string	User name
`roleName`	string	Role name
`parentId`	biginteger	ID of the respective record in the `SYSADMIN.UserRoles` table
`oldname`	string	Not used
`operationType`	string	Type of operation performed
`operationTime`	timestamp	Timestamp of operation
`operationUsername`	string	Name of the user who performed the operation

SYSLOG.ViewDefinitionHistory

This table supplies the history of views modifications.

Column Name	Type	Description
`id`	biginteger	Log record ID
`name`	string	View name
`definition`	string	View definition
`parentId`	biginteger	ID of the respective record in the `SYSADMIN.ViewDefinitions` table
`oldname`	string	Not used
`operationType`	string	Type of operation performed
`operationTime`	timestamp	Timestamp of operation
`operationUsername`	string	Name of the user who performed the operation

SYSLOG.VirtualSchemaHistory

This table supplies the history of virtual schemas modifications.

Column Name	Type	Description
`id`	biginteger	Log record ID
`name`	string	Name of the view
`deletable`	boolean	Flag indicating whether the virtual schema is deletable
`parentId`	biginteger	ID of the respective record in the `SYSADMIN.VirtualSchemas` table
`oldname`	string	Old name of the virtual schema, if changed
`operationType`	string	Type of operation performed
`operationTime`	timestamp	Timestamp of operation
`operationUsername`	string	Name of the user who performed the operation

SYSLOG.WebBusinessDataShopPublishedHistory

This table supplies the history of publishing an object to the Web Business Data Shop.

Column Name	Type	Description
`id`	biginteger	Log record ID
`name`	string	Object name
`schemaname`	string	Name of the schema the object belongs to
`parentId`	biginteger	ID of the respective record in the `SYSADMIN.WebBusinessDataShopPublished` table
`oldname`	string	Old name of the virtual schema, if changed
`operationType`	string	Type of operation performed
`operationTime`	timestamp	Timestamp of operation
`operationUsername`	string	Name of the user who performed the operation

Creation Parameter

SYSADMIN.CreationParams

Column Name	Type	Description
`id`	biginteger	***
`paramKey`	string	***
`paramValue`	string	***
`recOptID`	biginteger	***

SYSADMIN.S3SupportedRegions

This table supplies a list of regions supported for the Amazon S3 connector

Column Name	Type	Description
`id`	string	Region alias
`name`	string	Region name

LDAP

SYSADMIN.dv_ldap_role_props

Column Name	Type	Description
`id`	integer
`role_name`	string
`properites`	string

Global Options

SYSADMIN.OptionValues

Provides a complete list of all available options that may be set globally and used to control the Data Virtuality Server behaviour.

Column Name	Type	Description
`name`	string	Option name
`optionType`	string	Data type of the values for this option
`setGloballyOnly`	boolean	States if the option may be set globally only or also in session/statement-context
`optionValue`	string	Current value of the option or the default value, if not changed
`defaultOptionValue`	string	Default value
`possibleValues`	string	All valid values that may be set for this option
`description`	string

Web Business Data Shop

SYSADMIN.DataCatalogAttributes

The list of attributes of a Web Business Data Shop item.

Column Name	Type	Description
`id`	integer	Object ID
`name`	string	Object name
`attributes`	string	Object attributes

SYSADMIN.WebBusinessDataShopPublished

The list of objects published to Web Business Data Shop.

Column Name	Type	Description
`id`	integer	Object ID
`schemaName`	string	Name of the schema the object belongs to
`name`	string	Object name