updated schema to include named constraints