imho Nulls can be avoided at all times, and should be, except in the case of an empty foreign key. For example, in a tree the rootnode has no parent_id.

Robbert