Please enable JavaScript to view this site.

Data Dictionary Data Model

Navigation: » No topics above this level «

SYSTEMTABLES: Data Dictionary Tables

Contents Previous Home Next More

Tables, function tables and views per active data container.

Catalog: DataDictionary

Schema: Invantive

Alias: tbe

Label: Tables

This is a read-only view. The Data Dictionary API may not support changing the data or the Invantive SQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API.

View Columns

The columns of the view SYSTEMTABLES are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

CACHE_RESULT

boolean

Cache Result

Whether the result of the execution can be cached for the lifetime of the statement.

CALL_SAFE_NAME

string

Call Safe Name

 

Name for use within SQL with special characters escaped.

CAN_DELETE

boolean

Can Delete

 

Indicator whether you can delete data in this table.

CAN_INSERT

boolean

Can Insert

 

Indicator whether you can insert data in this table.

CAN_SELECT

boolean

Can Select

 

Indicator whether you can select data in this table.

CAN_UPDATE

boolean

Can Update

 

Indicator whether you can update data in this table.

CATALOG

string

Catalog

 

Catalog where the tables are contained in.

CLIENT_SIDE_CACHEABLE

boolean

Client-Side Cacheable

 

Are the contents eligible for caching on the client?

CREATION_DATE_UTC

datetime

Creation Date

 

Date at which the table was originally created (UTC).

DESCRIPTION

string

Description

 

Description of the contents.

DOCUMENTATION

string

Documentation

 

Documentation.

EDI_CLASS_NAME

string(240)

EDI Class Name

EDI: master class name.

EDI_PATH_FROM_MASTER

string(240)

EDI Path from Master

EDI: path from the master instance.

ESTIMATED_NUMBER_OF_ROWS

int64

Estimated Number of Rows

 

Estimated number of rows in this table per partition.

ESTIMATED_SIZE_BYTES

int64

Estimated Size in Bytes

 

Estimated size in bytes of this table per partition.

EXAMPLE

string

Example

 

Example of the contents.

FULL_QUALIFIED_NAME

string

Full Qualified Name

 

Fully qualified name.

FULL_SCAN_ROWS

int32

Full Scan (rows)

 

Number of full scans row processed.

FULL_SCANS_ELAPSED_TIME_MS

int32

Full Scans Elapsed Time (ms)

 

Time elapsed during full scans (ms).

FULL_SCANS_EXECUTED

int32

Full Scans Executed

 

Number of full scans executed.

ID

int32

ID

 

Unique ID of the table.

IS_PARTITION_SPECIFIC

boolean

Is Partition Specific

 

Indicator whether the contents of this table typically differ per partition.

LABEL_LIST_I18N

string

Translated Label List

 

Translated label of the table for use in lists.

LABEL_LIST

string

Label for List

 

Label of the table for use in lists.

LABEL_PLURAL_I18N

string

Translated Label Plural

 

Label of the table contents in plural form.

LABEL_PLURAL

string

Label Plural

 

Label of the table contents in plural form.

LABEL_SINGULAR_I18N

string

Translated Label Singular

 

Translated label of the table contents in singular form.

LABEL_SINGULAR

string

Label Singular

 

Label of the table contents in singular form.

LAST_UPDATE_DATE_UTC

datetime

Last Update Date

 

Date at which the table's structure was last modified (UTC).

MEASURED_AVERAGE_ACCESS_LATENCY_MS

int32

Measured Average Access Latency (ms)

 

Measured average round-trip latency in milliseconds (across cloud: network latency + disks + reception, on SCSI: disks) statically configured.

MEASURED_AVERAGE_FULL_SCAN_ROWS_PER_MINUTE

int32

Measured Average Number Full Scan Row per Minute

 

Measured average number of rows that fetched per minute on a full table scan.

MEASURED_AVERAGE_POINT_QUERY_ROWS_PER_MINUTE

int32

Measured Average Number Point Query Rows per Minute

 

Measured average number of rows processed per minute on point queries.

MEASURED_AVERAGE_WRITE_ROWS_PER_MINUTE

int32

Measured Average Number Rows Written per Minute

 

Measured average number of rows written per minute.

NAME

string

Name

 

Name of the table or view.

ODATA_BASE_PATH

string(240)

OData Base Path

OData: base path.

ODATA_FIELD_SELECTION_METHOD

string(240)

OData Field Selection Method

OData: field selection method.

ODATA_METADATA_URL

string(4000)

OData Metadata URL

OData: URL for retrieving metadata.

ODATA_SERVER_SIDE_FILTERS

string

OData Server-side Filters

OData: text representation of server-side filters.

ODATA_SERVICE_URL_FOR_DELETE

string(4000)

OData Service URL for Delete

OData: service URL for deleting data.

ODATA_SERVICE_URL_FOR_INSERT

string(4000)

OData Service URL for Insert

OData: service URL for inserting data.

ODATA_SERVICE_URL_FOR_SELECT

string(4000)

OData Service URL for Select

OData: service URL for retrieving data.

ODATA_SERVICE_URL_FOR_UPDATE

string(4000)

OData Service URL for Update

OData: service URL for updating data.

POINT_QUERIES_ELAPSED_TIME_MS

int32

Time Spent in Point Queries (ms)

 

Time elapsed during point queries (ms).

POINT_QUERIES_EXECUTED

int32

Rows through Point Queries

 

Number of point queries executed.

PRIMARY_KEY_FIELD

string(4000)

Primary Key Columns

 

Primary key column(s) of the table.

PROVIDER_DATA_CONTAINER_ALIAS

string(4000)

Data Container Alias

Data container alias.

PROVIDER_DATA_CONTAINER_ID

string(4000)

Data Container ID

Data container ID.

PROVIDER_DESCRIPTION

string(16000)

Provider Description

Provider description.

PROVIDER_NAME

string(240)

Provider Name

Name of the provider.

PROVIDER_SHORT_NAME

string(240)

Provider Short Name

Provider short name.

SCHEMA

string

Schema

 

Schema within the catalog where the table is contained in.

SHORT_NAME

string

Short Name

 

Typical alias for the table.

SOAP_ACTION

string(240)

SOAP Action

SOAP: action.

STATIC_AVERAGE_ACCESS_LATENCY_MS

int32

Static Average Access Latency (ms)

 

Technical average round-trip latency in milliseconds (across cloud: network latency + disks + reception, on SCSI: disks) statically configured.

STATIC_AVERAGE_FULL_SCAN_ROWS_PER_MINUTE

int32

Static Average Rows per Minute on Full Scan

 

Average number of rows that fetched per minute on a full table scan, statically configured.

STATIC_AVERAGE_POINT_QUERY_ROWS_PER_MINUTE

int32

Static Average Rows per Minute on Point Query

 

Average number of rows processed per minute on point queries, statically configured.

STATIC_AVERAGE_WRITE_ROWS_PER_MINUTE

int32

Static Average Rows per Minute Written

 

Average number of rows written per minute, statically configured.

SWAGGER_DELETE_OPERATION

string(240)

Swagger Delete Operation

SWAGGER: delete operation.

SWAGGER_INSERT_OPERATION

string(240)

Swagger Insert Operation

SWAGGER: insert operation.

SWAGGER_SELECT_OPERATION

string(240)

Swagger Select Operation

SWAGGER: select operation.

SWAGGER_UPDATE_OPERATION

string(240)

Swagger Update Operation

SWAGGER: update operation.

TABLE_PARAMETERS

string(4000)

Parameters

 

Parameters defined on the table.

TYPE

string

Type

 

Type, can be either 'view' or 'table'.

VALID

boolean

Valid

 

Whether the structure of the table is valid.

WEBHOOK_KEY_FIELD

string(4000)

Webhook Key Column

Key column on webhook messages.

WEBHOOK_TOPIC

string(4000)

Topic

Webhook topic.

WRITE_ELAPSED_TIME_MS

int32

Elapsed Write Time (ms)

 

Time elapsed during point queries (ms).

WRITES_EXECUTED

int32

Writes Executed

 

Number of writes executed.

WRITTEN_ROWS

int32

Rows Written

 

Number of rows written.

XML_BASE_XPATH

string(240)

Base XPath

XML: XPath expression which forms the root containing all rows.

XML_DEFAULT_NAMESPACE_PREFIX

string(240)

Default Namespace Prefix

XML: default namespace prefix.

XML_NAMED_COMPLEX_TYPE

string(240)

Named Complex Type

XML: name of the complex type.

XML_SERVER_SIDE_FILTERS

string

Server-side Filters

XML: text representation of server-side filters.

XML_SERVICE_URL

string(240)

Service URL

XML: Service URL.

XML_TOPIC

string(240)

Topic

XML: topic or action as known on the remote server. Defaults to Name when not set.

XML_XPATH

string(240)

XPath

XML: XPath expression for the data when specified or the root otherwise. The XPath typically does NOT include the base XPath.

 

17-05-2021 11:57 Version 20.1.419-BETA+3191