Re: What is a Bridge Table

Gil Wright <abuse_at_home.com> wrote in message news:<3BD3AF8D.E86D3330_at_home.com>...
> Can someone tell me what a bridge table is? Thanks - Gil

In relational concept we're using term bridge table for tables which map two tables together when cardinality is m..n. For example we can have table of users (operators) and table of accounts. Each client can have more than one account, but also each account can be handled by more than one user (typical for corporate accounts). So we should create another table which can store mapping between these two tables. The simplest one should look like this:

USER_KEY ACC_KEY
00023345 2246462
00023164 3494998
00023164 2246462

To select account to operators and vice versa we can join this table with USER table and ACCOUNT table.

I do not know if this is what you meant, but maybe this can be helpful to you.

--
_________________________________________

Dusan Bolek, Ing.
Oracle team leader

Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
can call it an overture to bankruptcy) on that server. I'm still using
this email to prevent SPAM. Maybe one day I will change it and have a
proper mail even for news, but right now I can be reached by this
email.