Lexicon Garden

page.corvus.database

A database block

Repository @corvus.page did:plc:3qc4cbzcriye72qqqodeda26 namespace authority
Details · object
Kindobject
Authoritycorvus.page
Indexed
Compare Edit in builder → Fork →

Object

object

Properties

blockId

requiredstring · at-uri

The AT-URI of this block record

columns

ref

The columns of the database, sequence of column block ids

Reference

rows

ref

The rows of the database

Reference

title

ref

The name of the database

Reference

#cell

object

Properties

columnId

string · at-uri

The id of the column this cell belongs to

valueBlockId

string · at-uri

The id of the value block

#column

object

A database column

Properties

blockId

requiredstring · at-uri

The AT-URI of this block record

cellType

string · nsid

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

The default properties for the column

Reference

name

ref

The title of the column

Reference

#columnReferenceFacet

object

Properties

columnId

string · at-uri

The id of the column this reference belongs to

#counter

object

Properties

blockId

requiredstring · at-uri

The AT-URI of this block record

count

ref

The counter value

Reference

#databaseReferenceFacet

object

Properties

databaseId

string · at-uri

The id of the database this reference belongs to

#row

object

A database row

Properties

blockId

requiredstring · at-uri

The AT-URI of this block record

cells

ref

The cells of the row, one per column with a value

Reference

#sql

object

Properties

blockId

requiredstring · at-uri

The AT-URI of this block record

facets

ref

The facets applied to the SQL query

Reference

text

ref

The SQL query text

Reference

#sqlReferenceFacet

object

Properties

sqlId

string · at-uri

The id of the SQL query this reference belongs to

#string

object

Properties

blockId

requiredstring · at-uri

The AT-URI of this block record

text

ref
Reference

Similar lexicons

semantic match

Lexicons whose schemas describe something close to this one. Check them before publishing a new one that overlaps.

  • page.corvus.view

    View block variants — visualizations rendered over a database or SQL query (`page.corvus.database`). Each sub-def is a view shape selected by `page.corvus.block.blockType`.