As far as outer joins and foreign key references go, "NULL" is
allowed unless "not null" is specified.
Thanks Don! I didn't know about that. Fortunately most of the
instances in photodb are outer joins on foreign key references to
'not null' columns.