invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

SYSTEMTABLECOLUMNS: Data Dictionary Table Columns

read only

  • Catalogus: DataDictionary
  • Schema: Invantive
  • Label: Table Columns

Columns per table.

Kan alleen gegevens ophalen.

Tabelkolommen

De kolommen van de tabel SYSTEMTABLECOLUMNS worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
CAN_FILTER_SERVER_SIDE char Kan Server-zijde Filteren Whether the column can be filtered on server-side.
CAN_FILTER_SERVER_SIDE_ADJACENT_TERMS char Kan Server-side Filteren op Aangrenzende Termen Whether the column can be filtered on server-side using adjacent search terms.
CAN_FILTER_SERVER_SIDE_ALL_TERMS char Kan Server-side Filteren op Alle Termen Whether the column can be filtered on server-side using all search terms.
CAN_FILTER_SERVER_SIDE_ANY_TERM char Kan Server-side Filteren op Elke Term Whether the column can be filtered on server-side using any search term.
CAN_FILTER_SERVER_SIDE_CONTAINS char Kan Server-side Filteren op Bevat Whether the column can be filtered on server-side using contains text.
CAN_FILTER_SERVER_SIDE_EQUALS char Kan Server-side Filteren op Gelijkheid Whether the column can be filtered on server-side using equals.
CAN_FILTER_SERVER_SIDE_GREATER_THAN char Kan Server-side Filteren op Groter dan Whether the column can be filtered on server-side using greater than.
CAN_FILTER_SERVER_SIDE_GREATER_THAN_OR_EQUAL char Kan Server-side Filteren op Groter dan of Gelijk aan Whether the column can be filtered on server-side using greater than or equal.
CAN_FILTER_SERVER_SIDE_LESS_THAN char Kan Server-side Filteren op Kleiner dan Whether the column can be filtered on server-side using less than.
CAN_FILTER_SERVER_SIDE_LESS_THAN_OR_EQUAL char Kan Server-side Filteren op Kleiner dan of Gelijk aan Whether the column can be filtered on server-side using less than or equal.
CAN_FILTER_SERVER_SIDE_NOT_EQUALS char Kan Server-side Filteren op Ongelijk Whether the column can be filtered on server-side using not equals.
CAN_SCAN_SERVER_SIDE char Kan Server-side Scannen Whether the column can be scanned on server-side for search terms.
CAN_SORTER_SERVER_SIDE char Kan Server-side Sorteren Whether the column can be sorted on server-side.
CHECK_SPELLING char Controleer Spelling 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) Database Datatype Data type in the database.
DERIVED_VALUE char Afgeleide Waarde Whether the column contains a derived value (calculated using an expression).
DISPLAY_CONTROL varchar2(240) Weergavecontrol Display control for displaying the column's contents.
DISPLAY_IN_FILTER char Weergeven in Zoekfilter Whether the column should be included in a search window.
DISPLAY_IN_LOV char Weergeven in Waardenlijst Whether the column should be included in a pick list.
DISPLAY_IN_RECORD char Weergeven in Record Whether the column should be included in a single record view.
DISPLAY_IN_RESULTS char Weergeven in Resultaten Whether the column should be included in a multiple records view.
DISPLAY_LENGTH_AVERAGE int32 Weergavelengte (Gemiddeld) Average length in characters of the contents of the column.
DISPLAY_LENGTH_SD int32 Weergavelengte (SD) Standard deviation in characters of the contents of the column.
DISPLAY_ORDER int32 Weergave Volgorde Relative position in which the column should be displayed compared to other columns.
DOCUMENTATION varchar2(4000) Documentation Documentation.
DOTNET_DATA_TYPE varchar2(240) .NET Datatype Data type for .NET.
EXAMPLE varchar2(4000) Example Example.
FETCH_BY_DEFAULT char Standaard Ophalen 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 Beïnvloedt Toevoegen Whether the column's value has an impact on the database's contents.
LABEL_HEADING varchar2(240) Label Kop Optional heading label to be shown before the column's normal label.
LABEL_PLURAL varchar2(4000) Label Meervoud Translatable label in plural.
LABEL_PLURAL_COMPOSED varchar2(4000) Label Meervoud Samengesteld Translatable label composed of the prefix and the plural label.
LABEL_PLURAL_POSTFIX varchar2(240) Label Meervoud Achtervoegsel Translatable label postfix in plural.
LABEL_PLURAL_PREFIX varchar2(240) Label Meervoud Voorvoegsel Translatable label prefix in plural.
LABEL_SINGULAR varchar2(4000) Label Enkelvoud Human-readable label in singular form.
LABEL_SINGULAR_COMPOSED varchar2(4000) Label Enkelvoud Samengesteld Translatable label composed of the prefix and the singular label.
LABEL_SINGULAR_I18N varchar2(4000) Vertaald Label Enkelvoud Translated human-readable label in singular form.
LABEL_SINGULAR_POSTFIX varchar2(240) Label Enkelvoud Achtervoegsel Translatable label postfix in singular.
LABEL_SINGULAR_PREFIX varchar2(240) Label Enkelvoud Voorvoegsel Translatable label prefix in singular.
MAX_LENGTH int32 Maximum Lengte Maximum length.
MINIMUM_LENGTH int32 Minimum Lengte Minimum required length for a text field.
MINIMUM_LENGTH_PADDING varchar2(240) Minimale Lengte Opvulling Which side padding has to be applied if the minimum length is not met.
MOST_UNQUALIFIED_NAME varchar2(240) Meest Ongekwalificeerde Naam 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) Datacontainer Alias Data container alias.
PROVIDER_DATA_CONTAINER_ID varchar2(4000) Datacontainer ID Data container ID.
PROVIDER_DESCRIPTION varchar2(16000) Provideromschrijving Provider description.
PROVIDER_INSTANCE_UID guid Providerinstantie UID Unique ID of the provider instance.
PROVIDER_NAME varchar2(240) Providernaam Name of the provider.
PROVIDER_SHORT_NAME varchar2(240) Provider Korte Naam Provider short name.
SCALE int16 Scale Scale.
SOURCE_ADDITIONAL_INFO_1 varchar2(4000) Bron Aanvullende Informatie 1 Additional information, no predefined structure.
SOURCE_ADDITIONAL_INFO_2 varchar2(4000) Bron Aanvullende Informatie 2 Additional information, no predefined structure.
SOURCE_ADDITIONAL_INFO_3 varchar2(4000) Bron Aanvullende Informatie 3 Additional information, no predefined structure.
SOURCE_PATH varchar2(4000) Bronpad 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) Tabel Omschrijving 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) Tabel Volledig Gekwalificeerde Naam 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) Tabelnaam 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) Primaire Sleutelkolommen 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) Tabelsoort 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 Wijzigbaar door Gebruiker Whether the column's value can be changed ever by a human user with sufficient access rights.

Toetsen

Key Column Verwijst naar 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

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: