Menü
Database workflow — Conventions and sqlite tools
Mit Codex oder Claude installieren Kopieren Sie diesen Prompt, fügen Sie ihn in Codex, Claude oder einen anderen Assistant ein und lassen Sie die Skill-Seite prüfen und installieren.
Basierend auf der SOC-Berufsklassifikation
How to use browser tool against this app's session auth. Use when taking screenshots, testing UI, or interacting with authenticated pages via the browser tool.
Git and GitHub workflow — auth via GitHub App, branch management for feature work, opening pull requests, and syncing with main.
UX workflow — Design standards, ASCII wireframes, and tempui / templui-pro tools
| name | db |
| description | Database workflow — Conventions and sqlite tools |
For SQL migrations and queries sort tables and columns lexigraphically when possible.
For IDs use INTEGER PRIMARY KEY.
For timestamps use TIMESTAMP and NOT NULL and DEFAULT CURRENT_TIMESTAMP where applicable. Track created_at, updated_at, archived_at, trashed_at.
We strongly favor soft archive and trash over hard delete. Use foreign keys and ON DELETE RESTRICT to further prefer hard deletes.
Use as simple names for objects and fields as possible.
Consider using web standards. For example we use W3C Activity Streams 2.0 to model our "activities" table with "actor", "object", "target" "id" and "type" fields.
