tables and binary links

[Ruslan Zasukhin]

On 9/2/07 7:53 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

>> So cells is MANY to MANY link table, right?
> No, in my postgres design this would have been
> 
> organisations 1:M cells (= departments of organisations, but more
> flexible, ie projectgroups, special sales teams,....)

Look. 

Exists T1 and T2.

And exists T12 which has only TWO fields.

 
--------------------------------------
    T1                  T2

            T12
        id1     id2

--------------------------------------


T1 to T12 is 1 : M
T2 to T12 is 1 : M

But you can think that T1 to T2 is M : M
Table T12 can be named as MM-link-table between T1 and T2.

This is simplest MM case. And this can be replaced by BinaryLink.

In your case that T12 have additional fields.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]