Isn't this obvious that this is impossible and makes no sense?
Please see this explanations of the foreign key:
http://en.wikipedia.org/wiki/Foreign_key[
^].
In particular, pay attention for the code samples. Look: for a table named
TABLE_NAME
, a foreign key is always defined in association with some other table named
other_table
. Think a bit: why is that so? Otherwise, you would not have information on what a value of a foreign key is referring to. The keys (primary) can be only made unique in the scope of a single table. If you have a value of some foreign key, you would not be able to determine the table without the name of a foreign key which is unique in the scope of the table using this key. This information presents in the database schema. This is how it's possible to establish one-to-one, one-to-many and many-to-many relations
between tables: through the
multitude of
one-to-one relations between primary and foreign keys.
In practical terms, in a simplest case, you need to create three foreign keys in
Table1
to establish relations with three other tables.
—SA