# JSONRECORDTYPES: Data Dictionary JSON Record Types The JSON record types of the products - the types whose files describe themselves through an OpenAPI specification derived at run time - with the specification and the documentation page of each. - Catalog: `DataDictionary` - Schema: `Invantive` - Alias: `jrt` - Label: JSON Record Types 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 `JSONRECORDTYPES` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ASSEMBLY_NAME` | `varchar2(240)` | Assembly Name | ☑ | Name of the assembly which declares the type. | | `ASSEMBLY_VERSION` | `varchar2(60)` | Assembly Version | ☑ | Version of the assembly, as major.minor.build.revision. | | `CONNECTION_STRING_EXAMPLE` | `varchar2(1024)` | String Example | | Connection string of the Big Data JSON driver which reads the files, with placeholders for the specification and the directory. | | `DESCRIPTION` | `clob` | Description | | Description of the records and their files, as written in the specification. | | `FILE_NAME_MASK` | `varchar2(1024)` | Name Mask | | Mask of the names of the files, as documented by the process which writes them; empty here, since the views describe the types. | | `ID` | `number` | ID | ☑ | Sequence number of the record type. | | `LABEL_PLURAL` | `varchar2(240)` | Label Plural | ☑ | Label of the records, as a user interface names the table. | | `MARKDOWN_FILE_NAME` | `varchar2(240)` | Markdown File Name | ☑ | Name of the documentation page of the type, one page per type. | | `MARKDOWN_PAGE` | `clob` | Markdown Page | ☑ | The documentation page of the type as Markdown for the product documentation, rendered from the specification. | | `RECORD_TYPE` | `varchar2(240)` | Record Type | ☑ | Full name of the .NET type whose instances are the records. | | `SCHEMA_NAME` | `varchar2(240)` | Schema | ☑ | Schema of the table the files are read as by the Big Data JSON driver. | | `SPECIFICATION_FILE_NAME` | `varchar2(240)` | Specification File Name | ☑ | Name of the specification file as the products write it beside their files, without the version. | | `SPECIFICATION_VERSION` | `varchar2(60)` | Specification Version | ☑ | Version of the specification, as major.minor of the assembly. | | `SPECIFICATION` | `clob` | Specification | ☑ | The OpenAPI specification as JSON text, generated from the type by this process. | | `TABLE_NAME` | `varchar2(240)` | Table Name | ☑ | Name of the table the files are read as by the Big Data JSON driver. | | `TITLE` | `varchar2(240)` | Title | ☑ | Title of the specification. | ## Referenced By The columns of these tables refer to a row of this table. | Table | Columns | Guarantee | |---|---|---| | [[Invantive-JSONRECORDTYPECOLUMNS\|Invantive.JSONRECORDTYPECOLUMNS]] | `RECORD_TYPE` | Declared by the connector, not enforced by the platform |