SYSTEMTABLECOLUMNS: Data Dictionary Table Columns
read only
- Catalogue :
DataDictionary - Schéma :
Invantive - Label: Table Columns
Columns per table.
Permet uniquement de récupérer des données.
Colonnes de table
Les colonnes de la table SYSTEMTABLECOLUMNS sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.
| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
CAN_ |
char |
Possibilité de filtrer côté serveur | Whether the column can be filtered on server-side. | ||
CAN_ |
char |
Permet de filtrer les termes adjacents côté serveur | Whether the column can be filtered on server-side using adjacent search terms. | ||
CAN_ |
char |
Permet de filtrer tous les termes côté serveur | Whether the column can be filtered on server-side using all search terms. | ||
CAN_ |
char |
Permet de filtrer n'importe quel terme côté serveur | Whether the column can be filtered on server-side using any search term. | ||
CAN_ |
char |
Permet de filtrer les occurrences de « contient » côté serveur | Whether the column can be filtered on server-side using contains text. | ||
CAN_ |
char |
Permet de filtrer les égalités côté serveur | Whether the column can be filtered on server-side using equals. | ||
CAN_ |
char |
Permet de filtrer côté serveur les valeurs supérieures à | Whether the column can be filtered on server-side using greater than. | ||
CAN_ |
char |
Permet de filtrer côté serveur les valeurs supérieures ou égales à | Whether the column can be filtered on server-side using greater than or equal. | ||
CAN_ |
char |
Peut-il filtrer côté serveur les valeurs inférieures à | Whether the column can be filtered on server-side using less than. | ||
CAN_ |
char |
Permet de filtrer côté serveur les valeurs inférieures ou égales à | Whether the column can be filtered on server-side using less than or equal. | ||
CAN_ |
char |
Possibilité de filtrer côté serveur selon la condition « différent de » | Whether the column can be filtered on server-side using not equals. | ||
CAN_ |
char |
Possibilité de numérisation côté serveur | Whether the column can be scanned on server-side for search terms. | ||
CAN_ |
char |
Tri possible côté serveur | Whether the column can be sorted on server-side. | ||
CHECK_ |
char |
Vérifier l'orthographe | 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 |
Type de données de la base de données | Data type in the database. | ||
DERIVED_ |
char |
Valeur dérivée | Whether the column contains a derived value (calculated using an expression). | ||
DISPLAY_ |
varchar2 |
Contrôle de l'affichage | Display control for displaying the column's contents. | ||
DISPLAY_ |
char |
Afficher dans le filtre | Whether the column should be included in a search window. | ||
DISPLAY_ |
char |
Afficher dans la liste des valeurs | Whether the column should be included in a pick list. | ||
DISPLAY_ |
char |
Afficher dans l'enregistrement | Whether the column should be included in a single record view. | ||
DISPLAY_ |
char |
Affichage dans les résultats | Whether the column should be included in a multiple records view. | ||
DISPLAY_ |
int32 |
Longueur d'affichage (en moyenne) | Average length in characters of the contents of the column. | ||
DISPLAY_ |
int32 |
Affichage de longueur (écart type) | Standard deviation in characters of the contents of the column. | ||
DISPLAY_ |
int32 |
Afficher la commande | Relative position in which the column should be displayed compared to other columns. | ||
DOCUMENTATION |
varchar2 |
Documentation | Documentation. | ||
DOTNET_ |
varchar2 |
Type de données .NET | Data type for .NET. | ||
EXAMPLE |
varchar2 |
Example | Example. | ||
FETCH_ |
char |
Récupération par défaut | 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 |
Insérer des Influences | Whether the column's value has an impact on the database's contents. | ||
LABEL_ |
varchar2 |
Titre de l'étiquette | Optional heading label to be shown before the column's normal label. | ||
LABEL_ |
varchar2 |
Étiquette pluriel | Translatable label in plural. | ||
LABEL_ |
varchar2 |
Étiquette « Pluriel composé » | Translatable label composed of the prefix and the plural label. | ||
LABEL_ |
varchar2 |
Étiquette « Plural » en suffixe | Translatable label postfix in plural. | ||
LABEL_ |
varchar2 |
Préfixe d'étiquette plurielle | Translatable label prefix in plural. | ||
LABEL_ |
varchar2 |
Étiquette singulier | Human-readable label in singular form. | ||
LABEL_ |
varchar2 |
Étiquette « Singulier composé » | Translatable label composed of the prefix and the singular label. | ||
LABEL_ |
varchar2 |
Étiquette traduite (au singulier) | Translated human-readable label in singular form. | ||
LABEL_ |
varchar2 |
Étiquette au singulier avec suffixe | Translatable label postfix in singular. | ||
LABEL_ |
varchar2 |
Préfixe d'étiquette singulière | Translatable label prefix in singular. | ||
MAX_ |
int32 |
Maximum Length | Maximum length. | ||
MINIMUM_ |
int32 |
Longueur minimale | Minimum required length for a text field. | ||
MINIMUM_ |
varchar2 |
Remplissage de longueur minimale | Which side padding has to be applied if the minimum length is not met. | ||
MOST_ |
varchar2 |
Le nom le plus inapproprié | 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 du conteneur de données | Data container alias. | ||
PROVIDER_ |
varchar2 |
ID du conteneur de données | Data container ID. | ||
PROVIDER_ |
varchar2 |
Description du fournisseur | Provider description. | ||
PROVIDER_ |
guid |
UID de l'instance du fournisseur | Unique ID of the provider instance. | ||
PROVIDER_ |
varchar2 |
Nom du fournisseur | Name of the provider. | ||
PROVIDER_ |
varchar2 |
Nom abrégé du fournisseur | Provider short name. | ||
SCALE |
int16 |
Scale | Scale. | ||
SOURCE_ |
varchar2 |
Source Informations supplémentaires 1 | Additional information, no predefined structure. | ||
SOURCE_ |
varchar2 |
Source Informations supplémentaires 2 | Additional information, no predefined structure. | ||
SOURCE_ |
varchar2 |
Source Informations supplémentaires 3 | Additional information, no predefined structure. | ||
SOURCE_ |
varchar2 |
Chemin source | 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 |
Description de la table | 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 |
Nom complet de la table | 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 |
Nom de la table | 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 |
Colonnes de clé primaire | 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 |
Type de table | 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 |
Modifiable par l'utilisateur | Whether the column's value can be changed ever by a human user with sufficient access rights. |
Clés
| Key | Column | Se réfère à | Kind | Description |
|---|---|---|---|---|
SYSTEMTABLECOLUMNS_ |
PROVIDER_ |
SYSTEMDATACONTAINERS. |
Key | |
SYSTEMTABLECOLUMNS_ |
PROVIDER_ |
SYSTEMTABLES. |
Key | |
SYSTEMTABLECOLUMNS_ |
TABLE_ |
SYSTEMTABLES. |
Key | |
SYSTEMTABLECOLUMNS_ |
TABLE_ |
SYSTEMTABLES. |
Key | |
SYSTEMTABLECOLUMNS_ |
TABLE_ |
SYSTEMTABLES.NAME |
Key |
Notes de Version
Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :