brief

Data Model

Entry Categories

Categories are a fixed enum:

• note
• lesson
• decision
• preference
• workflow
• snippet

Unknown categories on post or put are usage errors.

Entry Shape

Entries are exposed through brief get --json as objects with this shape:

[
  {
    "id": 494,
    "title": "...",
    "content": "...",
    "category": "note",
    "language": null,
    "tags": ["hooks", "go"],
    "created_at": "2026-03-12T00:00:00Z",
    "updated_at": "2026-03-12T00:00:00Z",
    "deprecated_at": null
  }
]

Schema

entries

• id integer primary key
• title required text
• content required text
• category required text
• language nullable text
• created_at datetime
• updated_at datetime
• deprecated_at nullable datetime

tags

• id integer primary key
• entry_id foreign key to entries.id
• tag text
• unique on (entry_id, tag)

config

• key primary key
• value text

Valid config keys:

• default_limit
• default_category

Search

Full-text search uses SQLite FTS5 over title and content.

User query tokens are sanitized before reaching FTS5. Raw FTS syntax is not part of the v1 interface.

Lifecycle

• deprecate is the standard lifecycle path
• deprecated entries are excluded from normal get results by default
• brief get --include-deprecated opts them back in
• delete is irreversible hard delete