invantive documentation
Invantive Support ForumsLog In / Sign Up

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_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 clob Specification The OpenAPI specification as JSON text, generated from the type by this process.
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.
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

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: