invantive documentation
Invantive Support ForumsLog In / Sign Up

SYSTEMTABLES: Data Dictionary Tables

read only

  • Catalog: DataDictionary
  • Schema: Invantive
  • Label: Tables

Tables, function tables and views per active data container.

Can only retrieve data.

Table Columns

The columns of the table SYSTEMTABLES are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
CACHE_RESULT char Cache Result Whether the result of the execution can be cached for the lifetime of the statement.
CALL_SAFE_NAME varchar2 Call Safe Name Name for use within SQL with special characters escaped.
CAN_DELETE char Can Delete Indicator whether you can delete data in this table.
CAN_INSERT char Can Insert Indicator whether you can insert data in this table.
CAN_SELECT char Can Select Indicator whether you can select data in this table.
CAN_UPDATE char Can Update Indicator whether you can update data in this table.
CATALOG varchar2 Catalog Catalog where the tables are contained in.
CLIENT_SIDE_CACHEABLE char 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 varchar2 Description Description of the contents.
DOCUMENTATION varchar2 Documentation Documentation.
EDI_CLASS_NAME varchar2(240) EDI Class Name EDI: master class name.
EDI_PATH_FROM_MASTER varchar2(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 varchar2 Example Example of the contents.
FULL_QUALIFIED_NAME varchar2 Full Qualified Name Fully qualified name.
FULL_SCANS_ELAPSED_TIME_MS double Full Scans Elapsed Time (ms) Time elapsed during full scans (ms).
FULL_SCANS_EXECUTED int32 Full Scans Executed Number of full scans executed.
FULL_SCAN_ROWS int64 Full Scan (rows) Number of full scans row processed.
ID int32 ID Unique ID of the table.
IS_PARTITION_SPECIFIC char Is Partition Specific Indicator whether the contents of this table typically differ per partition.
LABEL_LIST varchar2 Label for List Label of the table for use in lists.
LABEL_LIST_I18N varchar2 Translated Label List Translated label of the table for use in lists.
LABEL_PLURAL varchar2 Label Plural Label of the table contents in plural form.
LABEL_PLURAL_I18N varchar2 Translated Label Plural Label of the table contents in plural form.
LABEL_SINGULAR varchar2 Label Singular Label of the table contents in singular form.
LABEL_SINGULAR_I18N varchar2 Translated Label Singular Translated 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 double 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 varchar2 Name Name of the table or view.
ODATA_BASE_PATH varchar2(240) OData Base Path OData: base path.
ODATA_FIELD_SELECTION_METHOD varchar2(240) OData Field Selection Method OData: field selection method.
ODATA_METADATA_URL varchar2(4000) OData Metadata URL OData: URL for retrieving metadata.
ODATA_SERVER_SIDE_FILTERS varchar2 OData Server-side Filters OData: text representation of server-side filters.
ODATA_SERVICE_URL_FOR_DELETE varchar2(4000) OData Service URL for Delete OData: service URL for deleting data.
ODATA_SERVICE_URL_FOR_INSERT varchar2(4000) OData Service URL for Insert OData: service URL for inserting data.
ODATA_SERVICE_URL_FOR_SELECT varchar2(4000) OData Service URL for Select OData: service URL for retrieving data.
ODATA_SERVICE_URL_FOR_UPDATE varchar2(4000) OData Service URL for Update OData: service URL for updating data.
POINT_QUERIES_ELAPSED_TIME_MS double 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 varchar2(4000) Primary Key Columns Primary key column(s) of the table.
PROVIDER_DATA_CONTAINER_ALIAS varchar2(4000) Data Container Alias Data container alias.
PROVIDER_DATA_CONTAINER_ID varchar2(4000) Data Container ID Data container ID.
PROVIDER_DESCRIPTION varchar2(16000) Provider Description Provider description.
PROVIDER_INSTANCE_UID guid Provider Instance UID Unique ID of the provider instance.
PROVIDER_NAME varchar2(240) Provider Name Name of the provider.
PROVIDER_SHORT_NAME varchar2(240) Provider Short Name Provider short name.
SCHEMA varchar2 Schema Schema within the catalog where the table is contained in.
SHORT_NAME varchar2 Short Name Typical alias for the table.
SOAP_ACTION varchar2(240) SOAP Action SOAP: action.
STATIC_AVERAGE_ACCESS_LATENCY_MS double 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_CONTENT_TYPE varchar2(240) Swagger Content Type SWAGGER: content type.
SWAGGER_DELETE_OPERATION varchar2(240) Swagger Delete Operation SWAGGER: delete operation.
SWAGGER_INSERT_OPERATION varchar2(240) Swagger Insert Operation SWAGGER: insert operation.
SWAGGER_PRE_MAPPING_TABLE_NAME varchar2(240) Swagger Pre Mapping Table Name SWAGGER: pre-mapping table name.
SWAGGER_RESPONSE_SCHEMA varchar2(240) Swagger Response Schema SWAGGER: response schema.
SWAGGER_SELECT_OPERATION varchar2(240) Swagger Select Operation SWAGGER: select operation.
SWAGGER_UPDATE_OPERATION varchar2(240) Swagger Update Operation SWAGGER: update operation.
TABLE_PARAMETERS varchar2(4000) Parameters Parameters defined on the table.
TECHNICAL_DOCUMENTATION varchar2 Technical Documentation Technical documentation.
TYPE varchar2 Type Type, can be either 'view' or 'table'.
VALID char Valid Whether the structure of the table is valid.
WEBHOOK_KEY_FIELD varchar2(4000) Webhook Key Column Key column on webhook messages.
WEBHOOK_TOPIC varchar2(4000) Topic Webhook topic.
WRITES_EXECUTED int32 Writes Executed Number of writes executed.
WRITE_ELAPSED_TIME_MS double Elapsed Write Time (ms) Time elapsed during point queries (ms).
WRITTEN_ROWS int64 Rows Written Number of rows written.
XML_BASE_XPATH varchar2(240) Base XPath XML: XPath expression which forms the root containing all rows.
XML_DEFAULT_NAMESPACE_PREFIX varchar2(240) Default Namespace Prefix XML: default namespace prefix.
XML_NAMED_COMPLEX_TYPE varchar2(240) Named Complex Type XML: name of the complex type.
XML_SERVER_SIDE_FILTERS varchar2 Server-side Filters XML: text representation of server-side filters.
XML_SERVICE_URL varchar2(240) Service URL XML: Service URL.
XML_TOPIC varchar2(240) Topic XML: topic or action as known on the remote server. Defaults to Name when not set.
XML_XPATH varchar2(240) XPath XML: XPath expression for the data when specified or the root otherwise. The XPath typically does NOT include the base XPath.

Keys

Key Column Refers to Kind Description
SYSTEMTABLES_PROVIDER_INSTANCE_UID_SYSTEMDATACONTAINERS_fk PROVIDER_INSTANCE_UID SYSTEMDATACONTAINERS.PROVIDER_INSTANCE_UID Key
SYSTEMTABLES_PROVIDER_INSTANCE_UID_SYSTEMSCHEMAS_fk PROVIDER_INSTANCE_UID SYSTEMSCHEMAS.PROVIDER_INSTANCE_UID Key
SYSTEMTABLES_PROVIDER_INSTANCE_UID_SYSTEMSCHEMAS_fk CATALOG SYSTEMSCHEMAS.CATALOG Key
SYSTEMTABLES_PROVIDER_INSTANCE_UID_SYSTEMSCHEMAS_fk SCHEMA SYSTEMSCHEMAS.NAME Key
SYSTEMTABLES_PROVIDER_NAME_SYSTEMPROVIDERS_fk PROVIDER_NAME SYSTEMPROVIDERS.NAME Key

Referenced By

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: