Check for uniqueness on names and foreign keys in advance early in the contract phase

[developertogo]

Validate early in the input validation contract phase rather than in the database phase done by DB.

See attempted work on uniqueness-enum-validation branch