Skip to content
Sapporta

Table and column metadata

View as Markdown

Identity

Section titled “Identity”

SapportaMeta, SapportaTableInputMeta, ColumnMeta, and ChildMeta from @sapporta/server.

Contract

Section titled “Contract”
  • Table metadata includes label, required rowLabelColumns, rowScope, immutable, references, defaultSort, children, columns, and search.
  • Child metadata includes table, foreignKey, label, columns, defaultSort, and width.
  • Column metadata includes semantic kind, formatting, label, visibility, width bounds, additive behavior, color/zero/strong hints, notes, and apiWritable.
  • Select options belong to the Drizzle column. Use Sapporta select() or raw Drizzle text(name, { enum: options }); schema extraction serializes the same option list for browser controls.
  • Application validation belongs to the top-level validate() callback on sapportaTable(). It composes with structural column validation.
  • apiWritable: false removes a column from generated write schemas and forms, and generated table APIs reject callers that submit it. Reference-level apiSettable: false applies the same policy to a server-authored foreign key.
  • Visual metadata does not replace server authorization.
Section titled “Related documentation”