I think this reflects more on you than on SQL. This is fairly trivial to express as a table-level constraint. I've done very similar things in Postgres. I have

I think this reflects more on you than on SQL. This is fairly trivial to express as a table-level constraint. I've done very similar things in Postgres. I have no idea if you can do this in MySQL, but it's quite crippled.