Delete a schema by the given id.

Delete a schema by schema_id, the schema can only be deleted when the status is draft.

Key Features:

• Delete the custom schema specified by the schema ID, and all versions of the schema will be deleted.

Authorization Logic:

1. User must have a valid tenant-level JWT token
2. Token must have managing scope for custom schema

Usage Example:
Delete the custom schema and all its versions.

Permissions Required:
Requires: seismic.custom_schema.manage