Soft delete records SQL

readme.md

How to

Soft delete records SQL

• Use table RecycleBin with columns id, model, data
• Move deleted records to RecycleBin
• Serialize all rows to json and save to data

model Customer {
  customerId String @id @default(cuid())
  name       String
}

model RecycleBin {
  id    String
  model String
  data  Json
  @@id([id, model])
}