I don't see any fixes there. If a field needs to be optional, then it needs to be optional. Remove the NOT NULL and change your validation code. How else can

I don't see any fixes there. If a field needs to be optional, then it needs to be optional. Remove the NOT NULL and change your validation code. How else can you plan for this? 'Get it right the first time' is just wishful thinking.