1 Reply Latest reply: May 24, 2013 8:56 AM by dhalek RSS

    surgery team - foreign keys

      Hi, I created table (team), where one of columns store id_emp and surgery team mey consist of several doctors and nurses.
      Doctor and nurse heve been described in separate tables.
      How can I constraint id_emp as foreing key to id_dosctor and id_nurse simultaneously?
        • 1. Re: surgery team - foreign keys
          First, you are posting into the wrong forum as this one is for the SQL*Developer tool from Oracle and not for general SQL questions.
          Second, you cannot create a referential integrity with two parent tables. Maybe you should introduce a thrid table emp which stores the common part of doctors and nurses. Then you can ref your team to this table.
          Or you store your doctors and nurses in one table setting some kind of emp_type column.

          Hope that helps,