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

SYSTEMTABLECOLUMNS: Data Dictionary Table Columns

read only

  • Catálogo: DataDictionary
  • Esquema: Invantive
  • Label: Table Columns

Columns per table.

Solo puede recuperar datos.

Columnas de la Tabla

A continuación se muestran las columnas de la tabla SYSTEMTABLECOLUMNS. 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
CAN_FILTER_SERVER_SIDE char Puede filtrar desde el lado del servidor Whether the column can be filtered on server-side.
CAN_FILTER_SERVER_SIDE_ADJACENT_TERMS char Permite filtrar términos adyacentes en el lado del servidor Whether the column can be filtered on server-side using adjacent search terms.
CAN_FILTER_SERVER_SIDE_ALL_TERMS char Puede filtrar todos los términos del lado del servidor Whether the column can be filtered on server-side using all search terms.
CAN_FILTER_SERVER_SIDE_ANY_TERM char Permite filtrar cualquier término del lado del servidor Whether the column can be filtered on server-side using any search term.
CAN_FILTER_SERVER_SIDE_CONTAINS char Puede filtrar por «contiene» en el lado del servidor Whether the column can be filtered on server-side using contains text.
CAN_FILTER_SERVER_SIDE_EQUALS char Permite filtrar por igualdad en el lado del servidor Whether the column can be filtered on server-side using equals.
CAN_FILTER_SERVER_SIDE_GREATER_THAN char ¿Se puede filtrar «mayor que» del lado del servidor? Whether the column can be filtered on server-side using greater than.
CAN_FILTER_SERVER_SIDE_GREATER_THAN_OR_EQUAL char ¿Se puede filtrar del lado del servidor por «mayor o igual que»? Whether the column can be filtered on server-side using greater than or equal.
CAN_FILTER_SERVER_SIDE_LESS_THAN char ¿Se puede filtrar del lado del servidor menos que? Whether the column can be filtered on server-side using less than.
CAN_FILTER_SERVER_SIDE_LESS_THAN_OR_EQUAL char ¿Se puede filtrar «menor o igual que» en el lado del servidor? Whether the column can be filtered on server-side using less than or equal.
CAN_FILTER_SERVER_SIDE_NOT_EQUALS char ¿Se puede filtrar por «no es igual a» en el lado del servidor? Whether the column can be filtered on server-side using not equals.
CAN_SCAN_SERVER_SIDE char Permite escanear desde el servidor Whether the column can be scanned on server-side for search terms.
CAN_SORTER_SERVER_SIDE char Se puede ordenar en el lado del servidor Whether the column can be sorted on server-side.
CHECK_SPELLING char Revisar la Ortografía Whether the column's value should preferably be checked for spelling and grammar errors in a user interface.
CLIENT_SIDE_CACHEABLE char Table Client-Side Cacheable Are the contents eligible for caching on the client?
DATABASE_DATA_TYPE varchar2(240) Tipo de Datos de la Base de Datos Data type in the database.
DERIVED_VALUE char Valor derivado Whether the column contains a derived value (calculated using an expression).
DISPLAY_CONTROL varchar2(240) Control de pantalla Display control for displaying the column's contents.
DISPLAY_IN_FILTER char Mostrar en Filtro Whether the column should be included in a search window.
DISPLAY_IN_LOV char Mostrar en LOV Whether the column should be included in a pick list.
DISPLAY_IN_RECORD char Mostrar en Registro Whether the column should be included in a single record view.
DISPLAY_IN_RESULTS char Mostrar en los resultados Whether the column should be included in a multiple records view.
DISPLAY_LENGTH_AVERAGE int32 Visualizar la Longitud (Media) Average length in characters of the contents of the column.
DISPLAY_LENGTH_SD int32 Visualizar la Longitud (SD) Standard deviation in characters of the contents of the column.
DISPLAY_ORDER int32 Mostrar Orden Relative position in which the column should be displayed compared to other columns.
DOCUMENTATION varchar2(4000) Documentation Documentation.
DOTNET_DATA_TYPE varchar2(240) Tipo de Datos .NET Data type for .NET.
EXAMPLE varchar2(4000) Example Example.
FETCH_BY_DEFAULT char Obtener de forma predeterminada Whether this field is fetched by default.True if the column is fetched by default, or false if it is being fetched when accessed.
ID int32 ID Unique ID of the column.
INFLUENCES_INSERT char Influye en la Inserción Whether the column's value has an impact on the database's contents.
LABEL_HEADING varchar2(240) Etiquetar Título Optional heading label to be shown before the column's normal label.
LABEL_PLURAL varchar2(4000) Etiquetas Plurales Translatable label in plural.
LABEL_PLURAL_COMPOSED varchar2(4000) Etiqueta: Plural Composed Translatable label composed of the prefix and the plural label.
LABEL_PLURAL_POSTFIX varchar2(240) Etiqueta: Plural Postfix Translatable label postfix in plural.
LABEL_PLURAL_PREFIX varchar2(240) Prefijo de Etiquetas Plurales Translatable label prefix in plural.
LABEL_SINGULAR varchar2(4000) Etiquetas Singulares Human-readable label in singular form.
LABEL_SINGULAR_COMPOSED varchar2(4000) Etiqueta: Singular Composed Translatable label composed of the prefix and the singular label.
LABEL_SINGULAR_I18N varchar2(4000) Etiqueta traducida en singular Translated human-readable label in singular form.
LABEL_SINGULAR_POSTFIX varchar2(240) Etiqueta: Singular Postfix Translatable label postfix in singular.
LABEL_SINGULAR_PREFIX varchar2(240) Prefijo de Etiquetas Singulares Translatable label prefix in singular.
MAX_LENGTH int32 Longitud Máxima Maximum length.
MINIMUM_LENGTH int32 Longitud mínima Minimum required length for a text field.
MINIMUM_LENGTH_PADDING varchar2(240) Acolchado de longitud mínima Which side padding has to be applied if the minimum length is not met.
MOST_UNQUALIFIED_NAME varchar2(240) Nombre menos calificado The most unique name ('users' for 'exactonline.crm.users')
NAME varchar2(240) Name Name of the column.
NULLABLE char Nullable Whether the value is optional.
POSITION int32 Position Numeric ID of the column.
PRECISION int16 Precision Precision.
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.
SCALE int16 Scale Scale.
SOURCE_ADDITIONAL_INFO_1 varchar2(4000) Fuente de Información Adicional 1 Additional information, no predefined structure.
SOURCE_ADDITIONAL_INFO_2 varchar2(4000) Fuente de Información Adicional 2 Additional information, no predefined structure.
SOURCE_ADDITIONAL_INFO_3 varchar2(4000) Fuente de Información Adicional 3 Additional information, no predefined structure.
SOURCE_PATH varchar2(4000) Ruta de Origen Path of the source of the value.
TABLE_CALL_SAFE_NAME varchar2(240) Table Call Safe Name Name for use within SQL with special characters escaped.
TABLE_CAN_DELETE char Table Can Delete Indicator whether you can delete data in this table.
TABLE_CAN_INSERT char Table Can Insert Indicator whether you can insert data in this table.
TABLE_CAN_SELECT char Table Can Select Indicator whether you can select data in this table.
TABLE_CAN_UPDATE char Table Can Update Indicator whether you can update data in this table.
TABLE_CATALOG_NAME varchar2(240) Table Catalog Catalog where the tables are contained in.
TABLE_CREATION_DATE_UTC datetime Table Creation Date Date at which the table was originally created (UTC).
TABLE_DESCRIPTION varchar2(4000) DEscripción de la Tabla Description of the contents.
TABLE_DOCUMENTATION varchar2(4000) Table Documentation Documentation of the table or view.
TABLE_ESTIMATED_NUMBER_OF_ROWS int64 Table Estimated Number of Rows Estimated number of rows in this table per partition
TABLE_ESTIMATED_SIZE_BYTES int64 Table Estimated Size in Bytes Estimated size in bytes of this table per partition.
TABLE_EXAMPLE varchar2(4000) Table Example Example of the contents.
TABLE_FULL_QUALIFIED_NAME varchar2(240) Tabla: Nombre completo y completo Full qualified name.
TABLE_FULL_TABLE_SCANS_EXECUTED int32 Table Number of Full Table Scans Executed Total number of full table scans executed.
TABLE_FULL_TABLE_SCAN_ROWS_RETRIEVED int64 Table Rows Retrieved during Full Table Scans Total number of rows retrieved using full table scans.
TABLE_FULL_TABLE_SCAN_ROW_RETRIEVAL_TOTAL_CLOCK_TIME_MS double Table Full Table Scan Row Retrieval Total Clock Time (ms) Total clock time spent retrieving data using full table scans.
TABLE_IS_PARTITION_SPECIFIC char Table Is Partition Specific Indicator whether the contents of this table typically differ per partition.
TABLE_LABEL_LIST varchar2(4000) Table Label for List Label of the table for use in lists.
TABLE_LABEL_PLURAL varchar2(4000) Table Label Plural Label of the table contents in plural form.
TABLE_LABEL_SINGULAR varchar2(4000) Table Label Singular Label of the table contents in singular form.
TABLE_LAST_UPDATE_DATE_UTC datetime Table Last Update Date Date at which the table's structure was last modified (UTC).
TABLE_MEASURED_AVERAGE_ACCESS_LATENCY_MS double Table Measured Average Access Latency (ms) Measured Average Access Latency in milliseconds.
TABLE_NAME varchar2(240) Nombre de la Tabla Name of the table or view.
TABLE_PARAMETERS varchar2(4000) Parameters Parameters defined on the table.
TABLE_POINT_QUERIES_EXECUTED int32 Table Number of Point Queries Executed Number of point queries executed.
TABLE_POINT_QUERIES_EXECUTED_TOTAL_CLOCK_TIME_MS double Table Total Clock Time Spent Executing Point Queries (ms) Total clock time spent retrieving data using point queries.
TABLE_PRIMARY_KEY_FIELD varchar2(4000) Columnas de clave principal Primary key column(s) of the table.
TABLE_ROWS_WRITE_TOTAL_CLOCK_TIME_MS double Table Total Time Spent Writing Rows (ms) Total clock time spent writing rows in milliseconds.
TABLE_ROWS_WRITTEN int64 Table Number of Rows Written Number of rows written.
TABLE_SCHEMA_NAME varchar2(240) Table Schema Schema within the catalog where the table is contained in.
TABLE_SHORT_NAME varchar2(240) Table Short Name Typical alias for the table.
TABLE_STATIC_AVERAGE_ACCESS_LATENCY_MS double Table Static Average Access Latency (ms) Statically determined average access latency in milliseconds.
TABLE_STATIC_AVERAGE_FULL_SCAN_ROWS_PER_MINUTE int32 Table Static Average Rows per Minute on Full Scan Statically determined average number of rows accessible per minute.
TABLE_STATIC_AVERAGE_POINT_QUERY_ROWS_PER_MINUTE int32 Table Static Average Rows per Minute on Point Query Statically determined average of points queries throughput per minute.
TABLE_STATIC_AVERAGE_WRITE_ROWS_PER_MINUTE int32 Table Static Average Rows per Minute Written Statically determined throughput of written rows per minute.
TABLE_TYPE varchar2(30) Tipo de tabla Type, can be either 'view' or 'table'.
TABLE_VALID char Table Valid Whether the structure of the table is valid.
TABLE_WRITES_EXECUTED int32 Table Number of Writes Total number of writes executed.
USER_CHANGEABLE char Cambiable por el usuario Whether the column's value can be changed ever by a human user with sufficient access rights.

Teclas

Key Column Se refiere a Kind Description
SYSTEMTABLECOLUMNS_PROVIDER_INSTANCE_UID_SYSTEMDATACONTAINERS_fk PROVIDER_INSTANCE_UID SYSTEMDATACONTAINERS.PROVIDER_INSTANCE_UID Key
SYSTEMTABLECOLUMNS_PROVIDER_INSTANCE_UID_SYSTEMTABLES_fk PROVIDER_INSTANCE_UID SYSTEMTABLES.PROVIDER_INSTANCE_UID Key
SYSTEMTABLECOLUMNS_PROVIDER_INSTANCE_UID_SYSTEMTABLES_fk TABLE_CATALOG_NAME SYSTEMTABLES.CATALOG Key
SYSTEMTABLECOLUMNS_PROVIDER_INSTANCE_UID_SYSTEMTABLES_fk TABLE_SCHEMA_NAME SYSTEMTABLES.SCHEMA Key
SYSTEMTABLECOLUMNS_PROVIDER_INSTANCE_UID_SYSTEMTABLES_fk TABLE_NAME SYSTEMTABLES.NAME Key

Notas de la Versión

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