relationship data in Sugar 5.1

[Nisbet]

Hi,


does anyone know where the relationship data is stored in a sugar 5.1 system? By data I mean if I associate customA with customB , where is the association customA.id, customB.id stored? I don't see anything in the database,and haven't found anything looking through the source.

Thanks

Andrew

[catherinema]

There are three relationships in Sugar, one-to-one, one-to-many and many-to-many.
one-to one and one-to-many is defined in the vardefs.php of the module.
many-to-many is defined under {sugar}/metadata directory.
By the way, if you create a new relationship, it is saved under ./custom/metadadta directory.

[Nisbet]

catherinema,

Thanks for the response. I need to provide a better explanation of my problem. I am trying to figure out where the actual data the represents a one-many relationship is stored. So for example if I associate entryX(the many) with entryY(the one), where is the data regarding that relationship stored. If it were a many to many relationship an entry in a table called something like typex_typey would be created, but for one-to-many that seems to not be that case.

[Nisbet]

Looks like I need to pay attention, there actually are tables created for one-to-many relationships.

Sorry everyone.