Skip to content

schema-std

The cross-cutting patterns every app re-implements — audit columns, soft delete, timestamps, a field-level audit log — packaged once, parameterized, and imported by reference. No copy-paste. No domain coupling.

Imported, not copied

Consumed by reference via schema-flow imports. Upgrade the package, every app gets the fix — no copy-pasted SQL to chase down.

Parameterized

Each app supplies its own identity table and actor GUC. The package carries no dependency on any app’s data model.

Audit built in

Stamp columns, no-op skip, and a field-level audit_log trail — created/archived/restored/hard-deleted, one row per changed column.

Composable

audit, timestamps, soft_delete, audit_log — mix the ones a table needs. Trigger ordering is handled for you.