invantive documentation
Invantive SupportforenAnmelden / Eintragen

SYSTEMTABLES: Data Dictionary Tables

read only

  • Katalog: DataDictionary
  • Schema: Invantive
  • Label: Tables

Tables, function tables and views per active data container.

Es können nur Daten abgerufen werden.

Tabellenspalten

Die Spalten der Tabelle SYSTEMTABLES sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp Label Required Marks Documentation
CACHE_RESULT char Cache-Ergebnis Whether the result of the execution can be cached for the lifetime of the statement.
CALL_SAFE_NAME varchar2 Anruf Sicherer Name Name for use within SQL with special characters escaped.
CAN_DELETE char Kann löschen Indicator whether you can delete data in this table.
CAN_INSERT char Kann einfügen Indicator whether you can insert data in this table.
CAN_SELECT char Kann auswählen Indicator whether you can select data in this table.
CAN_UPDATE char Kann aktualisieren Indicator whether you can update data in this table.
CATALOG varchar2 Catalog Catalog where the tables are contained in.
CLIENT_SIDE_CACHEABLE char Clientseitig cachebar Are the contents eligible for caching on the client?
CREATION_DATE_UTC datetime Datum erstellen 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-Klassenname EDI: master class name.
EDI_PATH_FROM_MASTER varchar2(240) EDI-Pfad vom Master EDI: path from the master instance.
ESTIMATED_NUMBER_OF_ROWS int64 Geschätzte Reihenanzahl Estimated number of rows in this table per partition.
ESTIMATED_SIZE_BYTES int64 Geschätzte Größe in Byte Estimated size in bytes of this table per partition.
EXAMPLE varchar2 Example Example of the contents.
FULL_QUALIFIED_NAME varchar2 Vollständiger qualifizierter Name Fully qualified name.
FULL_SCANS_ELAPSED_TIME_MS double Vollständige Scans Verstrichene Zeit (ms) Time elapsed during full scans (ms).
FULL_SCANS_EXECUTED int32 Vollständige Scans ausgeführt Number of full scans executed.
FULL_SCAN_ROWS int64 Vollständiger Scan (Zeilen) Number of full scans row processed.
ID int32 ID Unique ID of the table.
IS_PARTITION_SPECIFIC char Ist Partitionsspezifisch Indicator whether the contents of this table typically differ per partition.
LABEL_LIST varchar2 Beschreibung für Liste Label of the table for use in lists.
LABEL_LIST_I18N varchar2 Liste der übersetzten Etiketten Translated label of the table for use in lists.
LABEL_PLURAL varchar2 Bezeichnung Mehrzahl Label of the table contents in plural form.
LABEL_PLURAL_I18N varchar2 Übersetzte Bezeichnung Mehrzahl Label of the table contents in plural form.
LABEL_SINGULAR varchar2 Bezeichnung Singular Label of the table contents in singular form.
LABEL_SINGULAR_I18N varchar2 Übersetzte Bezeichnung (Einzelform) Translated label of the table contents in singular form.
LAST_UPDATE_DATE_UTC datetime Letztes Aktualisierungsdatum Date at which the table's structure was last modified (UTC).
MEASURED_AVERAGE_ACCESS_LATENCY_MS double Gemessene durchschnittliche Zugriffsverzögerung (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 Gemessene durchschnittliche Anzahl der Zeilen pro Minute bei vollständigem Scan Measured average number of rows that fetched per minute on a full table scan.
MEASURED_AVERAGE_POINT_QUERY_ROWS_PER_MINUTE int32 Gemessene durchschnittliche Anzahl von Query-Zeilen pro Minute Measured average number of rows processed per minute on point queries.
MEASURED_AVERAGE_WRITE_ROWS_PER_MINUTE int32 Gemessene durchschnittliche Anzahl der pro Minute geschriebenen Zeilen Measured average number of rows written per minute.
NAME varchar2 Name Name of the table or view.
ODATA_BASE_PATH varchar2(240) OData-Basispfad OData: base path.
ODATA_FIELD_SELECTION_METHOD varchar2(240) Methode zur Auswahl von OData-Feldern OData: field selection method.
ODATA_METADATA_URL varchar2(4000) OData-Metadaten-URL OData: URL for retrieving metadata.
ODATA_SERVER_SIDE_FILTERS varchar2 OData-Filter auf Serverseite OData: text representation of server-side filters.
ODATA_SERVICE_URL_FOR_DELETE varchar2(4000) OData-Dienst-URL für „Löschen“ OData: service URL for deleting data.
ODATA_SERVICE_URL_FOR_INSERT varchar2(4000) OData-Dienst-URL für „Einfügen“ OData: service URL for inserting data.
ODATA_SERVICE_URL_FOR_SELECT varchar2(4000) OData-Dienst-URL für „Select“ OData: service URL for retrieving data.
ODATA_SERVICE_URL_FOR_UPDATE varchar2(4000) OData-Dienst-URL für die Aktualisierung OData: service URL for updating data.
POINT_QUERIES_ELAPSED_TIME_MS double Zeitaufwand für Punkt-Queries (ms) Time elapsed during point queries (ms).
POINT_QUERIES_EXECUTED int32 Zeilenabfragen nach Punkten Number of point queries executed.
PRIMARY_KEY_FIELD varchar2(4000) Primärschlüsselspalten Primary key column(s) of the table.
PROVIDER_DATA_CONTAINER_ALIAS varchar2(4000) Datencontaineralias Data container alias.
PROVIDER_DATA_CONTAINER_ID varchar2(4000) Datenkontainer ID Data container ID.
PROVIDER_DESCRIPTION varchar2(16000) Treiberbeschreibung Provider description.
PROVIDER_INSTANCE_UID guid Treiber Instanz-UID Unique ID of the provider instance.
PROVIDER_NAME varchar2(240) Anbietername Name of the provider.
PROVIDER_SHORT_NAME varchar2(240) Treiber Kurzname Provider short name.
SCHEMA varchar2 Schema Schema within the catalog where the table is contained in.
SHORT_NAME varchar2 Kurzname Typical alias for the table.
SOAP_ACTION varchar2(240) SOAP-Aktion SOAP: action.
STATIC_AVERAGE_ACCESS_LATENCY_MS double Statische durchschnittliche Zugriffsverzögerung (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 Statischer Durchschnittswert der Zeilen pro Minute bei einem vollständigen Scan Average number of rows that fetched per minute on a full table scan, statically configured.
STATIC_AVERAGE_POINT_QUERY_ROWS_PER_MINUTE int32 Statischer Durchschnittswert der Zeilen pro Minute bei einer Punkt-Query Average number of rows processed per minute on point queries, statically configured.
STATIC_AVERAGE_WRITE_ROWS_PER_MINUTE int32 Statischer Durchschnitt der pro Minute geschriebenen Zeilen Average number of rows written per minute, statically configured.
SWAGGER_CONTENT_TYPE varchar2(240) Swagger-Inhaltstyp SWAGGER: content type.
SWAGGER_DELETE_OPERATION varchar2(240) Swagger Löschoperation SWAGGER: delete operation.
SWAGGER_INSERT_OPERATION varchar2(240) Swagger Anlegeoperation SWAGGER: insert operation.
SWAGGER_PRE_MAPPING_TABLE_NAME varchar2(240) Swagger Pre-Mapping Tabelle Name SWAGGER: pre-mapping table name.
SWAGGER_RESPONSE_SCHEMA varchar2(240) Swagger-Antwortschema SWAGGER: response schema.
SWAGGER_SELECT_OPERATION varchar2(240) Swagger Abrufoperation SWAGGER: select operation.
SWAGGER_UPDATE_OPERATION varchar2(240) Swagger Aktualisierungsoperation SWAGGER: update operation.
TABLE_PARAMETERS varchar2(4000) Parameters Parameters defined on the table.
TECHNICAL_DOCUMENTATION varchar2 Technische Dokumentation 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 Schlüsselspalte Key column on webhook messages.
WEBHOOK_TOPIC varchar2(4000) Topic Webhook topic.
WRITES_EXECUTED int32 Ausgeführte Schreibvorgänge Number of writes executed.
WRITE_ELAPSED_TIME_MS double Verstrichene Schreibzeit (ms) Time elapsed during point queries (ms).
WRITTEN_ROWS int64 Zeilen geschrieben Number of rows written.
XML_BASE_XPATH varchar2(240) Basis-XPath XML: XPath expression which forms the root containing all rows.
XML_DEFAULT_NAMESPACE_PREFIX varchar2(240) Standard-Namespace Präfix XML: default namespace prefix.
XML_NAMED_COMPLEX_TYPE varchar2(240) Benannter komplexer Typ XML: name of the complex type.
XML_SERVER_SIDE_FILTERS varchar2 Serverseitige Filter XML: text representation of server-side filters.
XML_SERVICE_URL varchar2(240) Dienst-URI 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.

Tasten

Key Column Bezieht sich auf 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

Verwiesen von

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: