invantive documentation
Invantive SupportforenAnmelden / Eintragen

JSONRECORDTYPECOLUMNS: Data Dictionary JSON Record Type Columns

read only

  • Katalog: DataDictionary
  • Schema: Invantive
  • Label: JSON Record Type Columns

The columns of the JSON record types of the products, one row per property of every type as its specification describes it.

Es können nur Daten abgerufen werden.

Tabellenspalten

Die Spalten der Tabelle JSONRECORDTYPECOLUMNS 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
CLR_PROPERTY varchar2(240) Property Name of the .NET property, when it differs from the JSON name.
CLR_TYPE varchar2(240) Type Full name of the .NET type of the property.
DESCRIPTION clob Description What the value holds, as written in the specification.
ENUM_VALUES varchar2(4000) Enum-Werte The members of an enumeration as written, separated by commas; empty for other values.
EXAMPLE varchar2(1024) Example An example value, as text.
ID number ID Sequence number of the column over all record types.
JSON_FORMAT varchar2(60) JSON-Format OpenAPI format of the value, such as date-time, uuid or int64, when the type alone does not say it.
JSON_TYPE varchar2(60) JSON-Typ OpenAPI type of the value: string, integer, number, boolean, array or object.
LABEL varchar2(240) Label Label of the column, as a user interface shows it.
NAME varchar2(240) Name Name of the column, which is the JSON name of the property.
NULLABLE boolean Nullable Whether the value may be absent or null.
POSITION number Position Position of the column, counted from 1 in the order the serializer writes the properties.
RECORD_TYPE varchar2(240) Datensatztyp Full name of the .NET type whose instances are the records.
TABLE_NAME varchar2(240) Tabelle Name Name of the table the files are read as by the Big Data JSON driver.

Tasten

Key Column Bezieht sich auf Kind Description
JSONRECORDTYPECOLUMNS_RECORD_TYPE_JSONRECORDTYPES_fk RECORD_TYPE JSONRECORDTYPES.RECORD_TYPE Key

Anmerkungen zu dieser Version

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