Unique key with NULLs
A fundamental property of a unique key is that it must be unique. Making part of that key Nullable destroys this property. There are two possible solutions to your problem: One way, the wrong way, would be to use some magic date to represent unknown. This just gets you past the DBMS “problem” but does … Read more