For removing referenced objects it would be nice to define the action for the dependent objects (like in SQL)
"on_delete_hint": ["RESTRICT", "CASCADE", "DELETE"].
"foreign_keys": [
{
"schema_id": "Reference",
"members": [ "." ],
"on_delete_hint": {
"type": "string",
"enum": ["RESTRICT", "CASCADE", "DELETE"],
"default": "RESTRICT"
}
}
]
Where RESTRICS - forbid referred object removal, CASCADE - remove referral object and DELETE set the FK (string) null.