invantive documentation
Invantive SupportforenAnmelden / Eintragen

SYSTEMTABLECOLUMNS: Data Dictionary Table Columns

read only

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

Columns per table.

Es können nur Daten abgerufen werden.

Tabellenspalten

Die Spalten der Tabelle SYSTEMTABLECOLUMNS sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp Label Required Marks Documentation
CAN_FILTER_SERVER_SIDE char Kann serverseitig filtern Whether the column can be filtered on server-side.
CAN_FILTER_SERVER_SIDE_ADJACENT_TERMS char Kann serverseitige benachbarte Begriffe filtern Whether the column can be filtered on server-side using adjacent search terms.
CAN_FILTER_SERVER_SIDE_ALL_TERMS char Kann alle Begriffe serverseitig filtern Whether the column can be filtered on server-side using all search terms.
CAN_FILTER_SERVER_SIDE_ANY_TERM char Kann serverseitig nach beliebigen Begriffen filtern Whether the column can be filtered on server-side using any search term.
CAN_FILTER_SERVER_SIDE_CONTAINS char Kann serverseitig nach Enthält filtern Whether the column can be filtered on server-side using contains text.
CAN_FILTER_SERVER_SIDE_EQUALS char Kann serverseitige Gleichheitsvergleiche filtern Whether the column can be filtered on server-side using equals.
CAN_FILTER_SERVER_SIDE_GREATER_THAN char Kann serverseitig nach Größer als filtern Whether the column can be filtered on server-side using greater than.
CAN_FILTER_SERVER_SIDE_GREATER_THAN_OR_EQUAL char Kann serverseitig nach größer als oder gleich filtern Whether the column can be filtered on server-side using greater than or equal.
CAN_FILTER_SERVER_SIDE_LESS_THAN char Kann serverseitig filtern Weniger als Whether the column can be filtered on server-side using less than.
CAN_FILTER_SERVER_SIDE_LESS_THAN_OR_EQUAL char Kann serverseitig nach kleiner oder gleich filtern Whether the column can be filtered on server-side using less than or equal.
CAN_FILTER_SERVER_SIDE_NOT_EQUALS char Kann serverseitig nach Nicht gleich filtern Whether the column can be filtered on server-side using not equals.
CAN_SCAN_SERVER_SIDE char Kann serverseitig scannen Whether the column can be scanned on server-side for search terms.
CAN_SORTER_SERVER_SIDE char Kann serverseitig sortieren Whether the column can be sorted on server-side.
CHECK_SPELLING char Rechtschreibprüfung 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) Datenbank Datentyp Data type in the database.
DERIVED_VALUE char Abgeleiteter Wert Whether the column contains a derived value (calculated using an expression).
DISPLAY_CONTROL varchar2(240) Anzeigecontrol Display control for displaying the column's contents.
DISPLAY_IN_FILTER char Anzeige im Filter Whether the column should be included in a search window.
DISPLAY_IN_LOV char Anzeige in LOV Whether the column should be included in a pick list.
DISPLAY_IN_RECORD char Anzeige in Datensatz Whether the column should be included in a single record view.
DISPLAY_IN_RESULTS char Anzeige in Ergebnissen Whether the column should be included in a multiple records view.
DISPLAY_LENGTH_AVERAGE int32 Anzeigelänge (durchschnittlich) Average length in characters of the contents of the column.
DISPLAY_LENGTH_SD int32 Anzeigelänge (SD) Standard deviation in characters of the contents of the column.
DISPLAY_ORDER int32 Anzeigereihenfolge Relative position in which the column should be displayed compared to other columns.
DOCUMENTATION varchar2(4000) Documentation Documentation.
DOTNET_DATA_TYPE varchar2(240) .NET Datentyp Data type for .NET.
EXAMPLE varchar2(4000) Example Example.
FETCH_BY_DEFAULT char Standardmäßig abrufen 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 Einflüsse einfügen Whether the column's value has an impact on the database's contents.
LABEL_HEADING varchar2(240) Label-Überschrift Optional heading label to be shown before the column's normal label.
LABEL_PLURAL varchar2(4000) Bezeichnung Mehrzahl Translatable label in plural.
LABEL_PLURAL_COMPOSED varchar2(4000) Übersetzte Bezeichnung Zusammengestellt Translatable label composed of the prefix and the plural label.
LABEL_PLURAL_POSTFIX varchar2(240) Bezeichnung Mehrzahl Hinterschrift Translatable label postfix in plural.
LABEL_PLURAL_PREFIX varchar2(240) Bezeichnung Mehrzahl Präfix Translatable label prefix in plural.
LABEL_SINGULAR varchar2(4000) Bezeichnung Singular Human-readable label in singular form.
LABEL_SINGULAR_COMPOSED varchar2(4000) Zusammengestellte Bezeichnung (Einzelform) Translatable label composed of the prefix and the singular label.
LABEL_SINGULAR_I18N varchar2(4000) Übersetzte Bezeichnung (Einzelform) Translated human-readable label in singular form.
LABEL_SINGULAR_POSTFIX varchar2(240) Bezeichnung Einzelform Hinterschrift Translatable label postfix in singular.
LABEL_SINGULAR_PREFIX varchar2(240) Bezeichnung Einzahl Präfix Translatable label prefix in singular.
MAX_LENGTH int32 Maximale Länge Maximum length.
MINIMUM_LENGTH int32 Mindestlänge Minimum required length for a text field.
MINIMUM_LENGTH_PADDING varchar2(240) Mindestlänge der Auffüllung Which side padding has to be applied if the minimum length is not met.
MOST_UNQUALIFIED_NAME varchar2(240) Der unpassendste Name 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) Datencontaineralias Data container alias.
PROVIDER_DATA_CONTAINER_ID varchar2(4000) Datenkontainer ID Data container ID.
PROVIDER_DESCRIPTION varchar2(16000) Treiberbeschreibung Provider description.
PROVIDER_INSTANCE_UID guid Treiber Instanz-UID Unique ID of the provider instance.
PROVIDER_NAME varchar2(240) Anbietername Name of the provider.
PROVIDER_SHORT_NAME varchar2(240) Treiber Kurzname Provider short name.
SCALE int16 Scale Scale.
SOURCE_ADDITIONAL_INFO_1 varchar2(4000) Quelle Zusätzliche Informationen 1 Additional information, no predefined structure.
SOURCE_ADDITIONAL_INFO_2 varchar2(4000) Quelle Zusätzliche Informationen 2 Additional information, no predefined structure.
SOURCE_ADDITIONAL_INFO_3 varchar2(4000) Quelle Zusätzliche Informationen 3 Additional information, no predefined structure.
SOURCE_PATH varchar2(4000) Quellpfad 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) Tabelle Beschreibung 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) Vollständiger Name der Tabelle 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) Tabelle Name 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) Primärschlüsselspalten 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) Tabellentyp 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 Benutzer Änderbar Whether the column's value can be changed ever by a human user with sufficient access rights.

Tasten

Key Column Bezieht sich auf 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

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: