Subject | Re: [firebird-support] Nullable foreign keys |
---|---|
Author | Christian Gütter |
Post date | 2004-04-29T09:05:58Z |
Hi Martijn,
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
> Sure it does. If you define it as NULLable :-)for me it is not only sub-optimal, but also unsatisfying, because
> 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)
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