Subject Re: [firebird-support] Nullable foreign keys
Author Christian Gütter
Hi Martijn,

> Sure it does. If you define it as NULLable :-)

> eg:

> PERSON
> --
> Name
> Last_Name
> CarID

> Where "car" is a FK to table CARS. CarID should be nullable.

> CARS
> --
> CarID
> Name
> Brand
> etc...

> (obviously, this design is... well, sub-optimal, but it works)

for me it is not only sub-optimal, but also unsatisfying, because
all of my FKs are linked to the PKs of other tables which must never
be NULL.

Any other idea how I can do this?


Christian