ForeignKey-Constraint with more than 1 tables

From: Andreas Mosmann <>
Date: Fri, 28 Mar 2008 10:04:52 +0100
Message-ID: <>

Hi ng,


I talk about a database concerning real Trees. There is a table TTrees.

A single Tree belongs either to a forrest or to a street or to a park or whatelse.

So there exist f.e. a table TStreets and a table TForrests. in the table TTrees actually exist a field for each Table, f.e.

CIDSTREET Exactly 1 of them is not NULL, all the others are definitely NULL.

Now my Questions:
Is there a way to substitute this by only 1 Field, f.e. CID_BELONGS_TO _AND_ to build a FK-constraint like

TStreets.CID=TTrees.CID_BELONGS_TO ...

Is there a possibility to build a constraint, that observes that _exact_ 1 of the fields (CIDFORREST, CIDSTREET ..) is not null? (I know, I could use triggers for it)?

Is there a better way to build this database? (The Columns of TTrees are 95% equal, no matter if it stands on a street or in a forrest, so there is only 1 table)

Many thanks
Andreas Mosmann

wenn email, dann AndreasMosmann <bei> web <punkt> de
Received on Fri Mar 28 2008 - 04:04:52 CDT

Original text of this message