JSONRECORDTYPECOLUMNS: Data Dictionary JSON Record Type Columns
read only
- Catalogo:
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.
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella JSONRECORDTYPECOLUMNS. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
CLR_ |
varchar2 |
Property | Name of the .NET property, when it differs from the JSON name. | ||
CLR_ |
varchar2 |
Type | Full name of the .NET type of the property. | ||
DESCRIPTION |
clob |
Description | What the value holds, as written in the specification. | ||
ENUM_ |
varchar2 |
Valori dell'enumerazione | The members of an enumeration as written, separated by commas; empty for other values. | ||
EXAMPLE |
varchar2 |
Example | An example value, as text. | ||
ID |
number |
ID | Sequence number of the column over all record types. | ||
JSON_ |
varchar2 |
Formato JSON | OpenAPI format of the value, such as date-time, uuid or int64, when the type alone does not say it. | ||
JSON_ |
varchar2 |
Tipo JSON | OpenAPI type of the value: string, integer, number, boolean, array or object. | ||
LABEL |
varchar2 |
Label | Label of the column, as a user interface shows it. | ||
NAME |
varchar2 |
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_ |
varchar2 |
Tipo di record | Full name of the .NET type whose instances are the records. | ||
TABLE_ |
varchar2 |
Nome della tabella | Name of the table the files are read as by the Big Data JSON driver. |
Chiavi
| Key | Column | Si riferisce a | Kind | Description |
|---|---|---|---|---|
JSONRECORDTYPECOLUMNS_ |
RECORD_ |
JSONRECORDTYPES. |
Key |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: