tables

Each entry has db, col and an optional admin block. Tables are auto-migrated at startup.

col keydescription
nameSQL identifier: letters, digits, underscore
typeid | int | text | real | bool | blob; at most one id column per table
indextrue — SQL index; required for columns used in views.filter_by
ftstrue — FTS5 full-text index for the column

The admin block puts the table into the CMS:

keydescription
titlesection heading in the admin UI
list_columnscolumns shown in the list view
form_fieldscreate/edit form: name, widget (text | textarea | number | checkbox), required, max_length
permissionsroles allowed in; the admin role is always allowed; empty list — admin only (this site's Feedback section is an example)

← All articles in this group