I was going to suggest jsonb and some database check constraints at the DB level as the first step, but you’re using sqlite which has poor Json support (it’s basically text).
Ash provides the ability to add any validations you like, a custom validator can enforce your rules.






















