Seems likely that the enforced schema would then break things when someone updates the "live" schema without updating all of the checks littered through downstr

Seems likely that the enforced schema would then break things when someone updates the "live" schema without updating all of the checks littered through downstream tables...