Re: Foreign key pointing to multiple tables
From: Lennart Jonsson <lennart_at_kommunicera.umea.se>
Date: 21 Sep 2003 14:17:50 -0700
Message-ID: <6dae7e65.0309211317.6a48475f_at_posting.google.com>
Date: 21 Sep 2003 14:17:50 -0700
Message-ID: <6dae7e65.0309211317.6a48475f_at_posting.google.com>
joe.celko_at_northface.edu (--CELKO--) wrote in message news:<a264e7ea.0309201154.69d8aa12_at_posting.google.com>...
> >> Each Job has some details in its table, it also has a type. These
[...]
Shouldnt that be
CREATE TABLE A_jobs
(job_ticket INTEGER NOT NULL PRIMARY KEY,
...
Since there is a foreign key (job_ticket, job_type), is it necessary to have the foreign key (job_ticket)?
[...]
Kind regards
/Lennart
Received on Sun Sep 21 2003 - 23:17:50 CEST