Inconsistent data after deleting entries from database

We go live in two days so I wanted a clean state in my database.

Because I couldn’t find a way to drop the whole db I delete all entries ‘by hand’ aka select all in a table and then delete them.

I also delete all but 4 users.

Now all of the objects I create in a backend workflow show (deleted thing) as the creator.
This is unfortunate because it breaks my app.

Is suspect this is because the new user by whom the backend workflow was triggered had the same email as one of the users I deleted.

Does anyone know why that is?

On a side note: How can I cleanly wipe my database?

Would be happy if someone can help!

The db records were deleted roundabout 10 hours before the affected entries were generated.

FWIW but after a few more hours it seemed that the old/deleted data was actually deleted.

I can see this as I have a “hand-made” ID field in some tables and in the beginning, e.g. for the mentioned entries with the “deleted thing” creator, the IDs were still counting up from the original count but at a later point they started to count only the newly added entries.

Maybe some kind of cron job, maybe something with the backup feature, whatever it is/was, would be good if the “wrong creator bug” could be solved (if not done yet).