# JSONRECORDTYPECOLUMNS: Data Dictionary 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. - Catalog: `DataDictionary` - Schema: `Invantive` - Alias: `jrc` - Label: JSON Record Type Columns This is a read-only view. The Data Dictionary API may not support changing the data or the Invantive UniversalSQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API. ## View Columns The columns of the view `JSONRECORDTYPECOLUMNS` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | 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 Values | | 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 Type | ☑ | 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)` | Record Type | ☑ | Full name of the .NET type whose instances are the records. | | `TABLE_NAME` | `varchar2(240)` | Table Name | ☑ | Name of the table the files are read as by the Big Data JSON driver. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `RECORD_TYPE` | [[Invantive-JSONRECORDTYPES\|Invantive.JSONRECORDTYPES]] | `RECORD_TYPE` | Declared by the connector, not enforced by the platform |