CollectionMetadata

Optional collection configuration metadata

CloudDatabaseEnterpriseOracleREST APISQL

Properties

Name	Type	Description
keyColumn	object
contentColumn	object
versionColumn	object
lastModifiedColumn	object
readOnly	boolean

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "#/components/schemas/CollectionMetadata",
  "title": "CollectionMetadata",
  "type": "object",
  "description": "Optional collection configuration metadata",
  "properties": {
    "keyColumn": {
      "type": "object",
      "properties": {
        "name": {
          "type": "string"
        },
        "sqlType": {
          "type": "string"
        },
        "maxLength": {
          "type": "integer"
        },
        "assignmentMethod": {
          "type": "string",
          "enum": [
            "UUID",
            "GUID",
            "SEQUENCE",
            "CLIENT"
          ]
        }
      }
    },
    "contentColumn": {
      "type": "object",
      "properties": {
        "name": {
          "type": "string"
        },
        "sqlType": {
          "type": "string"
        },
        "compress": {
          "type": "string"
        },
        "cache": {
          "type": "boolean"
        },
        "encrypt": {
          "type": "string"
        },
        "validation": {
          "type": "string"
        }
      }
    },
    "versionColumn": {
      "type": "object",
      "properties": {
        "name": {
          "type": "string"
        },
        "method": {
          "type": "string",
          "enum": [
            "UUID",
            "TIMESTAMP",
            "SHA256",
            "MD5",
            "NONE"
          ]
        }
      }
    },
    "lastModifiedColumn": {
      "type": "object",
      "properties": {
        "name": {
          "type": "string"
        }
      }
    },
    "readOnly": {
      "type": "boolean"
    }
  }
}

Work with this as data

Every JSON Schema here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for schemas

4 MCP tools reach this

find_json_schemasBrowse and filter every JSON Schema in the catalog.
apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
resolveTurn a domain, URL or GitHub org into the provider it belongs to.
find_cohortsEvery scored population of providers in the catalog.

All 92 tools

Call it yourself

curl for this page

This JSON Schema

curl "https://apis.io/api/v1/json-schemas/oracle-database-collectionmetadata"

All schemas

curl "https://apis.io/api/v1/json-schemas?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no email required.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.