page.corvus.database

{
  "$type": "com.atproto.lexicon.schema",
  "defs": {
    "atLink": {
      "description": "A link to an ATProtocol resource",
      "properties": {
        "blockId": {
          "description": "The AT-URI of this block record",
          "format": "at-uri",
          "type": "string"
        },
        "uri": {
          "description": "The AT-URI of the linked resource",
          "format": "at-uri",
          "type": "string"
        }
      },
      "required": [
        "blockId",
        "uri"
      ],
      "type": "object"
    },
    "cell": {
      "properties": {
        "columnId": {
          "description": "The id of the column this cell belongs to",
          "format": "at-uri",
          "type": "string"
        },
        "valueBlockId": {
          "description": "The id of the value block",
          "format": "at-uri",
          "type": "string"
        }
      },
      "type": "object"
    },
    "column": {
      "description": "A database column",
      "properties": {
        "blockId": {
          "description": "The AT-URI of this block record",
          "format": "at-uri",
          "type": "string"
        },
        "cellType": {
          "description": "The type of the column",
          "format": "nsid",
          "knownValues": [
            "page.corvus.document#prose",
            "page.corvus.contentBlocks#checkbox",
            "page.corvus.contentBlocks#code",
            "page.corvus.contentBlocks#image",
            "page.corvus.contentBlocks#atLink",
            "page.corvus.contentBlocks#blockLink"
          ],
          "type": "string"
        },
        "defaults": {
          "description": "The default properties for the column",
          "ref": "page.corvus.core#set",
          "type": "ref"
        },
        "name": {
          "description": "The title of the column",
          "ref": "page.corvus.core#register",
          "type": "ref"
        }
      },
      "required": [
        "blockId"
      ],
      "type": "object"
    },
    "columnReferenceFacet": {
      "properties": {
        "columnId": {
          "description": "The id of the column this reference belongs to",
          "format": "at-uri",
          "type": "string"
        }
      },
      "type": "object"
    },
    "counter": {
      "properties": {
        "blockId": {
          "description": "The AT-URI of this block record",
          "format": "at-uri",
          "type": "string"
        },
        "count": {
          "description": "The counter value",
          "ref": "page.corvus.core#counter",
          "type": "ref"
        }
      },
      "required": [
        "blockId"
      ],
      "type": "object"
    },
    "databaseReferenceFacet": {
      "properties": {
        "databaseId": {
          "description": "The id of the database this reference belongs to",
          "format": "at-uri",
          "type": "string"
        }
      },
      "type": "object"
    },
    "main": {
      "description": "A database block",
      "properties": {
        "blockId": {
          "description": "The AT-URI of this block record",
          "format": "at-uri",
          "type": "string"
        },
        "columns": {
          "description": "The columns of the database, sequence of column block ids",
          "ref": "page.corvus.core#sequence",
          "type": "ref"
        },
        "rows": {
          "description": "The rows of the database",
          "ref": "page.corvus.core#set",
          "type": "ref"
        },
        "title": {
          "description": "The name of the database",
          "ref": "page.corvus.core#sequence",
          "type": "ref"
        }
      },
      "required": [
        "blockId"
      ],
      "type": "object"
    },
    "row": {
      "description": "A database row",
      "properties": {
        "blockId": {
          "description": "The AT-URI of this block record",
          "format": "at-uri",
          "type": "string"
        },
        "cells": {
          "description": "The cells of the row, one per column with a value",
          "ref": "page.corvus.core#set",
          "type": "ref"
        }
      },
      "required": [
        "blockId"
      ],
      "type": "object"
    },
    "sql": {
      "properties": {
        "blockId": {
          "description": "The AT-URI of this block record",
          "format": "at-uri",
          "type": "string"
        },
        "facets": {
          "description": "The facets applied to the SQL query",
          "ref": "page.corvus.core#set",
          "type": "ref"
        },
        "text": {
          "description": "The SQL query text",
          "ref": "page.corvus.core#sequence",
          "type": "ref"
        }
      },
      "required": [
        "blockId"
      ],
      "type": "object"
    },
    "sqlReferenceFacet": {
      "properties": {
        "sqlId": {
          "description": "The id of the SQL query this reference belongs to",
          "format": "at-uri",
          "type": "string"
        }
      },
      "type": "object"
    },
    "string": {
      "properties": {
        "blockId": {
          "description": "The AT-URI of this block record",
          "format": "at-uri",
          "type": "string"
        },
        "text": {
          "ref": "page.corvus.core#register",
          "type": "ref"
        }
      },
      "required": [
        "blockId"
      ],
      "type": "object"
    }
  },
  "description": "A database block",
  "id": "page.corvus.database",
  "lexicon": 1
}