Re: What is a Bridge Table

Gil Wright <abuse_at_home.com> wrote:
>Can someone tell me what a bridge table is? Thanks... Gil
>
I think you mean the following:

f.e. you have

   emloyees - primary key: empID
and

   projects - primary key: projID.

now:

   one employee can work in one or more projects and

   one project can employ one ore more employees

tables:
create table employee (

   empid number,
   ename varchar2(100)
);

create table project (

   projid number,
   pname varchar2(100)
);

the bridge-table:
create table emp_proj (

   empid number,
   projid number
);

I would interpret bridge-table as a link-table...

Rüdiger J. Schulz
eMail: rjs_at_berlin.de

-- 
__________________________________________________________
News suchen, lesen, schreiben mit http://newsgroups.web.de