Pro exercise

Soft-deleted rows are not live data

The accounts table keeps deleted accounts and marks them with a deleted_at value. Every downstream query must leave them out — as out of scope, not as errors — and validate only live accounts.

scope
soft deletes
validation