Add soft delete to schema, related to orchestral/foundation#20

Signed-off-by: crynobone <crynobone@gmail.com>