page.corvus.database

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