Re: What is a Bridge Table

Thanks - very much!

Gil

Dusan Bolek wrote:

> 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.
Received on Mon Oct 22 2001 - 05:48:56 CDT