invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

SYSTEMTABLES: Data Dictionary Tables

read only

  • Catálogo: DataDictionary
  • Esquema: Invantive
  • Label: Tables

Tables, function tables and views per active data container.

Solo puede recuperar datos.

Columnas de la Tabla

A continuación se muestran las columnas de la tabla SYSTEMTABLES. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

Name Tipo de Datos Label Required Marks Documentation
CACHE_RESULT char Resultado de la memoria caché Whether the result of the execution can be cached for the lifetime of the statement.
CALL_SAFE_NAME varchar2 Llamar un Nombre Seguro Name for use within SQL with special characters escaped.
CAN_DELETE char Se puede eliminar Indicator whether you can delete data in this table.
CAN_INSERT char Se puede insertar Indicator whether you can insert data in this table.
CAN_SELECT char Se puede seleccionar Indicator whether you can select data in this table.
CAN_UPDATE char Se puede actualizar Indicator whether you can update data in this table.
CATALOG varchar2 Catalog Catalog where the tables are contained in.
CLIENT_SIDE_CACHEABLE char Se puede almacenar en caché en el lado del cliente Are the contents eligible for caching on the client?
CREATION_DATE_UTC datetime Fecha de Creación 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) Nombre de clase EDI EDI: master class name.
EDI_PATH_FROM_MASTER varchar2(240) Ruta EDI desde el maestro EDI: path from the master instance.
ESTIMATED_NUMBER_OF_ROWS int64 Número Estimado de Filas Estimated number of rows in this table per partition.
ESTIMATED_SIZE_BYTES int64 Tamaño estimado en bytes Estimated size in bytes of this table per partition.
EXAMPLE varchar2 Example Example of the contents.
FULL_QUALIFIED_NAME varchar2 Nombre completo y cualificado Fully qualified name.
FULL_SCANS_ELAPSED_TIME_MS double Tiempo transcurrido de escaneos completos (ms) Time elapsed during full scans (ms).
FULL_SCANS_EXECUTED int32 Análisis completos ejecutados Number of full scans executed.
FULL_SCAN_ROWS int64 Escaneo completo (filas) Number of full scans row processed.
ID int32 ID Unique ID of the table.
IS_PARTITION_SPECIFIC char Es específico de la Partición Indicator whether the contents of this table typically differ per partition.
LABEL_LIST varchar2 Etiqueta por Lista Label of the table for use in lists.
LABEL_LIST_I18N varchar2 Lista de etiquetas traducidas Translated label of the table for use in lists.
LABEL_PLURAL varchar2 Etiquetas Plurales Label of the table contents in plural form.
LABEL_PLURAL_I18N varchar2 Etiqueta traducida en plural Label of the table contents in plural form.
LABEL_SINGULAR varchar2 Etiquetas Singulares Label of the table contents in singular form.
LABEL_SINGULAR_I18N varchar2 Etiqueta traducida en singular Translated label of the table contents in singular form.
LAST_UPDATE_DATE_UTC datetime Fecha de la Última Actualización Date at which the table's structure was last modified (UTC).
MEASURED_AVERAGE_ACCESS_LATENCY_MS double Latencia de acceso promedio medida (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 Número promedio medido (fila de escaneo completa por minuto) Measured average number of rows that fetched per minute on a full table scan.
MEASURED_AVERAGE_POINT_QUERY_ROWS_PER_MINUTE int32 Número medio medido de filas de consulta de puntos por minuto Measured average number of rows processed per minute on point queries.
MEASURED_AVERAGE_WRITE_ROWS_PER_MINUTE int32 Número medio medido de filas escritas por minuto Measured average number of rows written per minute.
NAME varchar2 Name Name of the table or view.
ODATA_BASE_PATH varchar2(240) Ruta de base de OData OData: base path.
ODATA_FIELD_SELECTION_METHOD varchar2(240) Método de selección de campos de OData OData: field selection method.
ODATA_METADATA_URL varchar2(4000) URL de metadatos de OData OData: URL for retrieving metadata.
ODATA_SERVER_SIDE_FILTERS varchar2 Filtros OData del lado del servidor OData: text representation of server-side filters.
ODATA_SERVICE_URL_FOR_DELETE varchar2(4000) URL del servicio OData para eliminar OData: service URL for deleting data.
ODATA_SERVICE_URL_FOR_INSERT varchar2(4000) URL del servicio OData para insertar OData: service URL for inserting data.
ODATA_SERVICE_URL_FOR_SELECT varchar2(4000) URL del servicio OData para Select OData: service URL for retrieving data.
ODATA_SERVICE_URL_FOR_UPDATE varchar2(4000) URL del servicio OData para la actualización OData: service URL for updating data.
POINT_QUERIES_ELAPSED_TIME_MS double Tiempo empleado en consultas puntuales (ms) Time elapsed during point queries (ms).
POINT_QUERIES_EXECUTED int32 Consultas de filas a puntos Number of point queries executed.
PRIMARY_KEY_FIELD varchar2(4000) Columnas de clave principal Primary key column(s) of the table.
PROVIDER_DATA_CONTAINER_ALIAS varchar2(4000) Alias del Contenedor de Datos Data container alias.
PROVIDER_DATA_CONTAINER_ID varchar2(4000) ID del Contenedor de Datos Data container ID.
PROVIDER_DESCRIPTION varchar2(16000) Descripción del proveedor Provider description.
PROVIDER_INSTANCE_UID guid UID de instancia de proveedor Unique ID of the provider instance.
PROVIDER_NAME varchar2(240) Nombre del Proveedor Name of the provider.
PROVIDER_SHORT_NAME varchar2(240) Nombre abreviado del proveedor Provider short name.
SCHEMA varchar2 Schema Schema within the catalog where the table is contained in.
SHORT_NAME varchar2 Nombre Corto Typical alias for the table.
SOAP_ACTION varchar2(240) Acción SOAP SOAP: action.
STATIC_AVERAGE_ACCESS_LATENCY_MS double Latencia de Acceso Media Estática (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 Filas Estáticas Medias por Minuto en Examen Completo. Average number of rows that fetched per minute on a full table scan, statically configured.
STATIC_AVERAGE_POINT_QUERY_ROWS_PER_MINUTE int32 Filas Estáticas Medias por Minuto en Consulta sobre Punto Average number of rows processed per minute on point queries, statically configured.
STATIC_AVERAGE_WRITE_ROWS_PER_MINUTE int32 Filas Estáticas Medias Escritas por Minuto Average number of rows written per minute, statically configured.
SWAGGER_CONTENT_TYPE varchar2(240) Tipo de contenido Swagger SWAGGER: content type.
SWAGGER_DELETE_OPERATION varchar2(240) Operación de eliminación de Swagger SWAGGER: delete operation.
SWAGGER_INSERT_OPERATION varchar2(240) Operación de inserción Swagger SWAGGER: insert operation.
SWAGGER_PRE_MAPPING_TABLE_NAME varchar2(240) Nombre de la tabla de mapeo previo de Swagger SWAGGER: pre-mapping table name.
SWAGGER_RESPONSE_SCHEMA varchar2(240) Esquema de respuesta de Swagger SWAGGER: response schema.
SWAGGER_SELECT_OPERATION varchar2(240) Operación de selección de Swagger SWAGGER: select operation.
SWAGGER_UPDATE_OPERATION varchar2(240) Operación de actualización de Swagger SWAGGER: update operation.
TABLE_PARAMETERS varchar2(4000) Parameters Parameters defined on the table.
TECHNICAL_DOCUMENTATION varchar2 Documentación técnica 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) Columna clave Webhook Key column on webhook messages.
WEBHOOK_TOPIC varchar2(4000) Topic Webhook topic.
WRITES_EXECUTED int32 Escrituras ejecutadas Number of writes executed.
WRITE_ELAPSED_TIME_MS double Tiempo de escritura transcurrido (ms) Time elapsed during point queries (ms).
WRITTEN_ROWS int64 Filas escritas Number of rows written.
XML_BASE_XPATH varchar2(240) XPath básico XML: XPath expression which forms the root containing all rows.
XML_DEFAULT_NAMESPACE_PREFIX varchar2(240) Prefijo de espacio de nombres predeterminado XML: default namespace prefix.
XML_NAMED_COMPLEX_TYPE varchar2(240) Tipo complejo con nombre XML: name of the complex type.
XML_SERVER_SIDE_FILTERS varchar2 Filtros del lado del servidor XML: text representation of server-side filters.
XML_SERVICE_URL varchar2(240) URL del servicio 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.

Teclas

Key Column Se refiere a 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

Referenciado por

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: