@softdelete

Soft-delete namespace plugin -- generates deleted_at columns, active views, and cascade triggers. Postgres: ALTER TABLE + CREATE VIEW + PL/pgSQL cascade function + trigger. MySQL: ALTER TABLE + CREATE VIEW + per-event AFTER UPDATE cascade trigger. SQLite: ALTER TABLE + CREATE VIEW + per-event AFTER UPDATE cascade trigger.

Postgres Mysql (beta) Sqlite (beta)

Tags

@softdelete

Enable soft-delete on this table (adds deleted_at column and active view)

Targets: table

Arguments:

Name	Type	Required	Values
column	string	No	—
view	string	No	—

@softdelete.cascade

Cascade soft-delete to this FK column when the parent is soft-deleted

Targets: column

Arguments: No arguments.

Lint Rules

softdelete.require-softdelete

Tables should have a @softdelete tag

Default severity: warn