invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

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_FILTER_SERVER_SIDE char Possibilité de filtrer côté serveur Whether the column can be filtered on server-side.
CAN_FILTER_SERVER_SIDE_ADJACENT_TERMS char Permet de filtrer les termes adjacents côté serveur Whether the column can be filtered on server-side using adjacent search terms.
CAN_FILTER_SERVER_SIDE_ALL_TERMS char Permet de filtrer tous les termes côté serveur Whether the column can be filtered on server-side using all search terms.
CAN_FILTER_SERVER_SIDE_ANY_TERM 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_FILTER_SERVER_SIDE_CONTAINS char Permet de filtrer les occurrences de « contient » côté serveur Whether the column can be filtered on server-side using contains text.
CAN_FILTER_SERVER_SIDE_EQUALS char Permet de filtrer les égalités côté serveur Whether the column can be filtered on server-side using equals.
CAN_FILTER_SERVER_SIDE_GREATER_THAN char Permet de filtrer côté serveur les valeurs supérieures à Whether the column can be filtered on server-side using greater than.
CAN_FILTER_SERVER_SIDE_GREATER_THAN_OR_EQUAL 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_FILTER_SERVER_SIDE_LESS_THAN char Peut-il filtrer côté serveur les valeurs inférieures à Whether the column can be filtered on server-side using less than.
CAN_FILTER_SERVER_SIDE_LESS_THAN_OR_EQUAL 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_FILTER_SERVER_SIDE_NOT_EQUALS 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_SCAN_SERVER_SIDE char Possibilité de numérisation côté serveur Whether the column can be scanned on server-side for search terms.
CAN_SORTER_SERVER_SIDE char Tri possible côté serveur Whether the column can be sorted on server-side.
CHECK_SPELLING char Vérifier l'orthographe 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) Type de données de la base de données Data type in the database.
DERIVED_VALUE char Valeur dérivée Whether the column contains a derived value (calculated using an expression).
DISPLAY_CONTROL varchar2(240) Contrôle de l'affichage Display control for displaying the column's contents.
DISPLAY_IN_FILTER char Afficher dans le filtre Whether the column should be included in a search window.
DISPLAY_IN_LOV char Afficher dans la liste des valeurs Whether the column should be included in a pick list.
DISPLAY_IN_RECORD char Afficher dans l'enregistrement Whether the column should be included in a single record view.
DISPLAY_IN_RESULTS char Affichage dans les résultats Whether the column should be included in a multiple records view.
DISPLAY_LENGTH_AVERAGE int32 Longueur d'affichage (en moyenne) Average length in characters of the contents of the column.
DISPLAY_LENGTH_SD int32 Affichage de longueur (écart type) Standard deviation in characters of the contents of the column.
DISPLAY_ORDER int32 Afficher la commande Relative position in which the column should be displayed compared to other columns.
DOCUMENTATION varchar2(4000) Documentation Documentation.
DOTNET_DATA_TYPE varchar2(240) Type de données .NET Data type for .NET.
EXAMPLE varchar2(4000) Example Example.
FETCH_BY_DEFAULT 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_INSERT char Insérer des Influences Whether the column's value has an impact on the database's contents.
LABEL_HEADING varchar2(240) Titre de l'étiquette Optional heading label to be shown before the column's normal label.
LABEL_PLURAL varchar2(4000) Étiquette pluriel Translatable label in plural.
LABEL_PLURAL_COMPOSED varchar2(4000) Étiquette « Pluriel composé » Translatable label composed of the prefix and the plural label.
LABEL_PLURAL_POSTFIX varchar2(240) Étiquette « Plural » en suffixe Translatable label postfix in plural.
LABEL_PLURAL_PREFIX varchar2(240) Préfixe d'étiquette plurielle Translatable label prefix in plural.
LABEL_SINGULAR varchar2(4000) Étiquette singulier Human-readable label in singular form.
LABEL_SINGULAR_COMPOSED varchar2(4000) Étiquette « Singulier composé » Translatable label composed of the prefix and the singular label.
LABEL_SINGULAR_I18N varchar2(4000) Étiquette traduite (au singulier) Translated human-readable label in singular form.
LABEL_SINGULAR_POSTFIX varchar2(240) Étiquette au singulier avec suffixe Translatable label postfix in singular.
LABEL_SINGULAR_PREFIX varchar2(240) Préfixe d'étiquette singulière Translatable label prefix in singular.
MAX_LENGTH int32 Maximum Length Maximum length.
MINIMUM_LENGTH int32 Longueur minimale Minimum required length for a text field.
MINIMUM_LENGTH_PADDING varchar2(240) Remplissage de longueur minimale Which side padding has to be applied if the minimum length is not met.
MOST_UNQUALIFIED_NAME varchar2(240) Le nom le plus inapproprié 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 du conteneur de données Data container alias.
PROVIDER_DATA_CONTAINER_ID varchar2(4000) ID du conteneur de données Data container ID.
PROVIDER_DESCRIPTION varchar2(16000) Description du fournisseur Provider description.
PROVIDER_INSTANCE_UID guid UID de l'instance du fournisseur Unique ID of the provider instance.
PROVIDER_NAME varchar2(240) Nom du fournisseur Name of the provider.
PROVIDER_SHORT_NAME varchar2(240) Nom abrégé du fournisseur Provider short name.
SCALE int16 Scale Scale.
SOURCE_ADDITIONAL_INFO_1 varchar2(4000) Source Informations supplémentaires 1 Additional information, no predefined structure.
SOURCE_ADDITIONAL_INFO_2 varchar2(4000) Source Informations supplémentaires 2 Additional information, no predefined structure.
SOURCE_ADDITIONAL_INFO_3 varchar2(4000) Source Informations supplémentaires 3 Additional information, no predefined structure.
SOURCE_PATH varchar2(4000) Chemin source 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) Description de la table 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) Nom complet de la table 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) Nom de la table 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) Colonnes de clé primaire 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) Type de table 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 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_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

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 :