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_ |
char |
Puede filtrar desde el lado del servidor | Whether the column can be filtered on server-side. | ||
CAN_ |
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_ |
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_ |
char |
Permite filtrar cualquier término del lado del servidor | Whether the column can be filtered on server-side using any search term. | ||
CAN_ |
char |
Puede filtrar por «contiene» en el lado del servidor | Whether the column can be filtered on server-side using contains text. | ||
CAN_ |
char |
Permite filtrar por igualdad en el lado del servidor | Whether the column can be filtered on server-side using equals. | ||
CAN_ |
char |
¿Se puede filtrar «mayor que» del lado del servidor? | Whether the column can be filtered on server-side using greater than. | ||
CAN_ |
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_ |
char |
¿Se puede filtrar del lado del servidor menos que? | Whether the column can be filtered on server-side using less than. | ||
CAN_ |
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_ |
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_ |
char |
Permite escanear desde el servidor | Whether the column can be scanned on server-side for search terms. | ||
CAN_ |
char |
Se puede ordenar en el lado del servidor | Whether the column can be sorted on server-side. | ||
CHECK_ |
char |
Revisar la Ortografía | Whether the column's value should preferably be checked for spelling and grammar errors in a user interface. | ||
CLIENT_ |
char |
Table Client-Side Cacheable | Are the contents eligible for caching on the client? | ||
DATABASE_ |
varchar2 |
Tipo de Datos de la Base de Datos | Data type in the database. | ||
DERIVED_ |
char |
Valor derivado | Whether the column contains a derived value (calculated using an expression). | ||
DISPLAY_ |
varchar2 |
Control de pantalla | Display control for displaying the column's contents. | ||
DISPLAY_ |
char |
Mostrar en Filtro | Whether the column should be included in a search window. | ||
DISPLAY_ |
char |
Mostrar en LOV | Whether the column should be included in a pick list. | ||
DISPLAY_ |
char |
Mostrar en Registro | Whether the column should be included in a single record view. | ||
DISPLAY_ |
char |
Mostrar en los resultados | Whether the column should be included in a multiple records view. | ||
DISPLAY_ |
int32 |
Visualizar la Longitud (Media) | Average length in characters of the contents of the column. | ||
DISPLAY_ |
int32 |
Visualizar la Longitud (SD) | Standard deviation in characters of the contents of the column. | ||
DISPLAY_ |
int32 |
Mostrar Orden | Relative position in which the column should be displayed compared to other columns. | ||
DOCUMENTATION |
varchar2 |
Documentation | Documentation. | ||
DOTNET_ |
varchar2 |
Tipo de Datos .NET | Data type for .NET. | ||
EXAMPLE |
varchar2 |
Example | Example. | ||
FETCH_ |
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_ |
char |
Influye en la Inserción | Whether the column's value has an impact on the database's contents. | ||
LABEL_ |
varchar2 |
Etiquetar Título | Optional heading label to be shown before the column's normal label. | ||
LABEL_ |
varchar2 |
Etiquetas Plurales | Translatable label in plural. | ||
LABEL_ |
varchar2 |
Etiqueta: Plural Composed | Translatable label composed of the prefix and the plural label. | ||
LABEL_ |
varchar2 |
Etiqueta: Plural Postfix | Translatable label postfix in plural. | ||
LABEL_ |
varchar2 |
Prefijo de Etiquetas Plurales | Translatable label prefix in plural. | ||
LABEL_ |
varchar2 |
Etiquetas Singulares | Human-readable label in singular form. | ||
LABEL_ |
varchar2 |
Etiqueta: Singular Composed | Translatable label composed of the prefix and the singular label. | ||
LABEL_ |
varchar2 |
Etiqueta traducida en singular | Translated human-readable label in singular form. | ||
LABEL_ |
varchar2 |
Etiqueta: Singular Postfix | Translatable label postfix in singular. | ||
LABEL_ |
varchar2 |
Prefijo de Etiquetas Singulares | Translatable label prefix in singular. | ||
MAX_ |
int32 |
Longitud Máxima | Maximum length. | ||
MINIMUM_ |
int32 |
Longitud mínima | Minimum required length for a text field. | ||
MINIMUM_ |
varchar2 |
Acolchado de longitud mínima | Which side padding has to be applied if the minimum length is not met. | ||
MOST_ |
varchar2 |
Nombre menos calificado | The most unique name ('users' for 'exactonline.crm.users') | ||
NAME |
varchar2 |
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_ |
varchar2 |
Alias del Contenedor de Datos | Data container alias. | ||
PROVIDER_ |
varchar2 |
ID del Contenedor de Datos | Data container ID. | ||
PROVIDER_ |
varchar2 |
Descripción del proveedor | Provider description. | ||
PROVIDER_ |
guid |
UID de instancia de proveedor | Unique ID of the provider instance. | ||
PROVIDER_ |
varchar2 |
Nombre del Proveedor | Name of the provider. | ||
PROVIDER_ |
varchar2 |
Nombre abreviado del proveedor | Provider short name. | ||
SCALE |
int16 |
Scale | Scale. | ||
SOURCE_ |
varchar2 |
Fuente de Información Adicional 1 | Additional information, no predefined structure. | ||
SOURCE_ |
varchar2 |
Fuente de Información Adicional 2 | Additional information, no predefined structure. | ||
SOURCE_ |
varchar2 |
Fuente de Información Adicional 3 | Additional information, no predefined structure. | ||
SOURCE_ |
varchar2 |
Ruta de Origen | Path of the source of the value. | ||
TABLE_ |
varchar2 |
Table Call Safe Name | Name for use within SQL with special characters escaped. | ||
TABLE_ |
char |
Table Can Delete | Indicator whether you can delete data in this table. | ||
TABLE_ |
char |
Table Can Insert | Indicator whether you can insert data in this table. | ||
TABLE_ |
char |
Table Can Select | Indicator whether you can select data in this table. | ||
TABLE_ |
char |
Table Can Update | Indicator whether you can update data in this table. | ||
TABLE_ |
varchar2 |
Table Catalog | Catalog where the tables are contained in. | ||
TABLE_ |
datetime |
Table Creation Date | Date at which the table was originally created (UTC). | ||
TABLE_ |
varchar2 |
DEscripción de la Tabla | Description of the contents. | ||
TABLE_ |
varchar2 |
Table Documentation | Documentation of the table or view. | ||
TABLE_ |
int64 |
Table Estimated Number of Rows | Estimated number of rows in this table per partition | ||
TABLE_ |
int64 |
Table Estimated Size in Bytes | Estimated size in bytes of this table per partition. | ||
TABLE_ |
varchar2 |
Table Example | Example of the contents. | ||
TABLE_ |
varchar2 |
Tabla: Nombre completo y completo | Full qualified name. | ||
TABLE_ |
int32 |
Table Number of Full Table Scans Executed | Total number of full table scans executed. | ||
TABLE_ |
int64 |
Table Rows Retrieved during Full Table Scans | Total number of rows retrieved using full table scans. | ||
TABLE_ |
double |
Table Full Table Scan Row Retrieval Total Clock Time (ms) | Total clock time spent retrieving data using full table scans. | ||
TABLE_ |
char |
Table Is Partition Specific | Indicator whether the contents of this table typically differ per partition. | ||
TABLE_ |
varchar2 |
Table Label for List | Label of the table for use in lists. | ||
TABLE_ |
varchar2 |
Table Label Plural | Label of the table contents in plural form. | ||
TABLE_ |
varchar2 |
Table Label Singular | Label of the table contents in singular form. | ||
TABLE_ |
datetime |
Table Last Update Date | Date at which the table's structure was last modified (UTC). | ||
TABLE_ |
double |
Table Measured Average Access Latency (ms) | Measured Average Access Latency in milliseconds. | ||
TABLE_ |
varchar2 |
Nombre de la Tabla | Name of the table or view. | ||
TABLE_ |
varchar2 |
Parameters | Parameters defined on the table. | ||
TABLE_ |
int32 |
Table Number of Point Queries Executed | Number of point queries executed. | ||
TABLE_ |
double |
Table Total Clock Time Spent Executing Point Queries (ms) | Total clock time spent retrieving data using point queries. | ||
TABLE_ |
varchar2 |
Columnas de clave principal | Primary key column(s) of the table. | ||
TABLE_ |
double |
Table Total Time Spent Writing Rows (ms) | Total clock time spent writing rows in milliseconds. | ||
TABLE_ |
int64 |
Table Number of Rows Written | Number of rows written. | ||
TABLE_ |
varchar2 |
Table Schema | Schema within the catalog where the table is contained in. | ||
TABLE_ |
varchar2 |
Table Short Name | Typical alias for the table. | ||
TABLE_ |
double |
Table Static Average Access Latency (ms) | Statically determined average access latency in milliseconds. | ||
TABLE_ |
int32 |
Table Static Average Rows per Minute on Full Scan | Statically determined average number of rows accessible per minute. | ||
TABLE_ |
int32 |
Table Static Average Rows per Minute on Point Query | Statically determined average of points queries throughput per minute. | ||
TABLE_ |
int32 |
Table Static Average Rows per Minute Written | Statically determined throughput of written rows per minute. | ||
TABLE_ |
varchar2 |
Tipo de tabla | Type, can be either 'view' or 'table'. | ||
TABLE_ |
char |
Table Valid | Whether the structure of the table is valid. | ||
TABLE_ |
int32 |
Table Number of Writes | Total number of writes executed. | ||
USER_ |
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_ |
SYSTEMDATACONTAINERS. |
Key | |
SYSTEMTABLECOLUMNS_ |
PROVIDER_ |
SYSTEMTABLES. |
Key | |
SYSTEMTABLECOLUMNS_ |
TABLE_ |
SYSTEMTABLES. |
Key | |
SYSTEMTABLECOLUMNS_ |
TABLE_ |
SYSTEMTABLES. |
Key | |
SYSTEMTABLECOLUMNS_ |
TABLE_ |
SYSTEMTABLES.NAME |
Key |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: