JSONRECORDTYPES: Data Dictionary JSON Record Types
read only
- Catalog:
DataDictionary - Schema:
Invantive - Label: 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.
Can only retrieve data.
Table Columns
The columns of the table JSONRECORDTYPES are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ASSEMBLY_ |
varchar2 |
Assembly Name | Name of the assembly which declares the type. | ||
ASSEMBLY_ |
varchar2 |
Assembly Version | Version of the assembly, as major.minor.build.revision. | ||
CONNECTION_ |
varchar2 |
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_ |
varchar2 |
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_ |
varchar2 |
Label Plural | Label of the records, as a user interface names the table. | ||
MARKDOWN_ |
varchar2 |
Markdown File Name | Name of the documentation page of the type, one page per type. | ||
MARKDOWN_ |
clob |
Markdown Page | The documentation page of the type as Markdown for the product documentation, rendered from the specification. | ||
RECORD_ |
varchar2 |
Record Type | Full name of the .NET type whose instances are the records. | ||
SCHEMA_ |
varchar2 |
Schema | Schema of the table the files are read as by the Big Data JSON driver. | ||
SPECIFICATION |
clob |
Specification | The OpenAPI specification as JSON text, generated from the type by this process. | ||
SPECIFICATION_ |
varchar2 |
Specification File Name | Name of the specification file as the products write it beside their files, without the version. | ||
SPECIFICATION_ |
varchar2 |
Specification Version | Version of the specification, as major.minor of the assembly. | ||
TABLE_ |
varchar2 |
Table Name | Name of the table the files are read as by the Big Data JSON driver. | ||
TITLE |
varchar2 |
Title | Title of the specification. |
Referenced By
- JSONRECORDTYPECOLUMNS
RECORD_TYPE(Key)
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: