Consider an Employees table with fields:
EmployeeID <-- primary keyEmailAddress <-- unique, NULLs allowedOffice <-- unique, NULLs allowed
> allowing nulls in a unique key and then using it in a foreign key is just weird. The child insert succeeds but you effectively orphan your child rows
Not sure what you mean.