Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Foreign key pointing to multiple tables

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@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 - 16:17:50 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US