Oracle optional relationship
Just allow the column to be nullable (don't make it NOT NULL
) and create your foreign key as normal. The database will enforce the foreign key for any rows that contain a value in that row, but nothing will be enforced if the row is null.