invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

SYSTEMTABLES: Data Dictionary Tables

read only

  • Catalogus: DataDictionary
  • Schema: Invantive
  • Label: Tables

Tables, function tables and views per active data container.

Kan alleen gegevens ophalen.

Tabelkolommen

De kolommen van de tabel SYSTEMTABLES worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
CACHE_RESULT char Cacheresultaat Whether the result of the execution can be cached for the lifetime of the statement.
CALL_SAFE_NAME varchar2 Veilig Naam voor Aanroep Name for use within SQL with special characters escaped.
CAN_DELETE char Kan Verwijderen Indicator whether you can delete data in this table.
CAN_INSERT char Kan Invoegen Indicator whether you can insert data in this table.
CAN_SELECT char Kan Selecteren Indicator whether you can select data in this table.
CAN_UPDATE char Kan Bijwerken Indicator whether you can update data in this table.
CATALOG varchar2 Catalog Catalog where the tables are contained in.
CLIENT_SIDE_CACHEABLE char Clientzijde Cachebaar Are the contents eligible for caching on the client?
CREATION_DATE_UTC datetime Aanmaakdatum 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-klassenaam EDI: master class name.
EDI_PATH_FROM_MASTER varchar2(240) EDI pad van Master EDI: path from the master instance.
ESTIMATED_NUMBER_OF_ROWS int64 Geschat Aantal Rijen Estimated number of rows in this table per partition.
ESTIMATED_SIZE_BYTES int64 Geschatte Omvang in Bytes Estimated size in bytes of this table per partition.
EXAMPLE varchar2 Example Example of the contents.
FULL_QUALIFIED_NAME varchar2 Volledig Gekwalificeerde Naam Fully qualified name.
FULL_SCANS_ELAPSED_TIME_MS double Volledige Scans Verstreken Tijd (ms) Time elapsed during full scans (ms).
FULL_SCANS_EXECUTED int32 Volledige Scans Uitgevoerd Number of full scans executed.
FULL_SCAN_ROWS int64 Volledige Scan (rijen) Number of full scans row processed.
ID int32 ID Unique ID of the table.
IS_PARTITION_SPECIFIC char Is Partitie Specifiek Indicator whether the contents of this table typically differ per partition.
LABEL_LIST varchar2 Label voor Lijst Label of the table for use in lists.
LABEL_LIST_I18N varchar2 Vertaalde Labellijst Translated label of the table for use in lists.
LABEL_PLURAL varchar2 Label Meervoud Label of the table contents in plural form.
LABEL_PLURAL_I18N varchar2 Vertaald Label Meervoud Label of the table contents in plural form.
LABEL_SINGULAR varchar2 Label Enkelvoud Label of the table contents in singular form.
LABEL_SINGULAR_I18N varchar2 Vertaald Label Enkelvoud Translated label of the table contents in singular form.
LAST_UPDATE_DATE_UTC datetime Laatst Bijgewerkt Datum Date at which the table's structure was last modified (UTC).
MEASURED_AVERAGE_ACCESS_LATENCY_MS double Gemeten Gemiddelde Toegangsvertraging (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 Gewogen Gemiddeld Nummer Volledige Scan Rijen per Minuut Measured average number of rows that fetched per minute on a full table scan.
MEASURED_AVERAGE_POINT_QUERY_ROWS_PER_MINUTE int32 Gewogen Gemiddeld Nummer Punt Query Rijen per Minuut Measured average number of rows processed per minute on point queries.
MEASURED_AVERAGE_WRITE_ROWS_PER_MINUTE int32 Gemeten Gemiddeld Nummer Rijen Geschreven per Minuut Measured average number of rows written per minute.
NAME varchar2 Name Name of the table or view.
ODATA_BASE_PATH varchar2(240) OData Basispad OData: base path.
ODATA_FIELD_SELECTION_METHOD varchar2(240) OData Veldselectiemethode OData: field selection method.
ODATA_METADATA_URL varchar2(4000) OData Metadata URL OData: URL for retrieving metadata.
ODATA_SERVER_SIDE_FILTERS varchar2 OData Filters aan Serverzijde OData: text representation of server-side filters.
ODATA_SERVICE_URL_FOR_DELETE varchar2(4000) OData Service URL voor Verwijderen OData: service URL for deleting data.
ODATA_SERVICE_URL_FOR_INSERT varchar2(4000) OData Service URL voor Toevoegen OData: service URL for inserting data.
ODATA_SERVICE_URL_FOR_SELECT varchar2(4000) OData Service URL voor Ophalen OData: service URL for retrieving data.
ODATA_SERVICE_URL_FOR_UPDATE varchar2(4000) OData Service URL voor Bijwerken OData: service URL for updating data.
POINT_QUERIES_ELAPSED_TIME_MS double Tijd besteed aan Puntqueries (ms) Time elapsed during point queries (ms).
POINT_QUERIES_EXECUTED int32 Rijen via Puntqueries Number of point queries executed.
PRIMARY_KEY_FIELD varchar2(4000) Primaire Sleutelkolommen Primary key column(s) of the table.
PROVIDER_DATA_CONTAINER_ALIAS varchar2(4000) Datacontainer Alias Data container alias.
PROVIDER_DATA_CONTAINER_ID varchar2(4000) Datacontainer ID Data container ID.
PROVIDER_DESCRIPTION varchar2(16000) Provideromschrijving Provider description.
PROVIDER_INSTANCE_UID guid Providerinstantie UID Unique ID of the provider instance.
PROVIDER_NAME varchar2(240) Providernaam Name of the provider.
PROVIDER_SHORT_NAME varchar2(240) Provider Korte Naam Provider short name.
SCHEMA varchar2 Schema Schema within the catalog where the table is contained in.
SHORT_NAME varchar2 Korte Naam Typical alias for the table.
SOAP_ACTION varchar2(240) SOAP Actie SOAP: action.
STATIC_AVERAGE_ACCESS_LATENCY_MS double Statisch Gemiddelde Toegangswachttijd (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 Statisch Gemiddelde Aantal Rijen per Minuut bij Volledig Scannen Average number of rows that fetched per minute on a full table scan, statically configured.
STATIC_AVERAGE_POINT_QUERY_ROWS_PER_MINUTE int32 Statisch Gemiddelde Aantal Rijen per Minuut op Puntquery Average number of rows processed per minute on point queries, statically configured.
STATIC_AVERAGE_WRITE_ROWS_PER_MINUTE int32 Statisch Gemiddeld Aantal Rijen Schrijven per Minuut Average number of rows written per minute, statically configured.
SWAGGER_CONTENT_TYPE varchar2(240) Swagger Inhoudssoort SWAGGER: content type.
SWAGGER_DELETE_OPERATION varchar2(240) Swagger Verwijderoperatie SWAGGER: delete operation.
SWAGGER_INSERT_OPERATION varchar2(240) Swagger Toevoegoperatie SWAGGER: insert operation.
SWAGGER_PRE_MAPPING_TABLE_NAME varchar2(240) Swagger Pre-mapping Tabelnaam SWAGGER: pre-mapping table name.
SWAGGER_RESPONSE_SCHEMA varchar2(240) Swagger Antwoordschema SWAGGER: response schema.
SWAGGER_SELECT_OPERATION varchar2(240) Swagger Selecteeroperatie SWAGGER: select operation.
SWAGGER_UPDATE_OPERATION varchar2(240) Swagger Bijwerkoperatie SWAGGER: update operation.
TABLE_PARAMETERS varchar2(4000) Parameters Parameters defined on the table.
TECHNICAL_DOCUMENTATION varchar2 Technische Documentatie 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 Sleutelkolom Key column on webhook messages.
WEBHOOK_TOPIC varchar2(4000) Topic Webhook topic.
WRITES_EXECUTED int32 Schrijfacties Uitgevoerd Number of writes executed.
WRITE_ELAPSED_TIME_MS double Verstreken Schrijftijd (ms) Time elapsed during point queries (ms).
WRITTEN_ROWS int64 Rijen Geschreven 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) Standaard Naamruimte Voorvoegsel XML: default namespace prefix.
XML_NAMED_COMPLEX_TYPE varchar2(240) Benoemd Complex Type XML: name of the complex type.
XML_SERVER_SIDE_FILTERS varchar2 Serverzijde 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.

Toetsen

Key Column Verwijst naar 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

Geciteerd door

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: