Columns on join table

[Mike Whiting]

I understand it's possible to create many-to-many relationships using
the "shared" keyword and there's even trees when creating a many-many
relationship on the same table.

However what I want to know is can I store data on top of this
relationship, i.e. in the join the table itself?

Suppose I have a table for components that may have one or many
dependencies on the same components table. How do I add a quantity
field? So say a "table" component had a child component of "table
leg" and the quantity is 4?

Many thanks,

[Ben Major]

It sounds like you’re looking for Qualified Link Beans. See the section in the docs below about qualified links:

https://redbeanphp.com/index.php?p=/link_beans

--
You received this message because you are subscribed to the Google Groups "redbeanphp" group.
To unsubscribe from this group and stop receiving emails from it, send an email to redbeanorm+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/redbeanorm/CA%2BWiPnK%2B3hYLBUjrQmYYhQCHux53tP1LdNBrM8BJBm0o%2BZmYZA%40mail.gmail.com.

[Mike Whiting]

Awesome, thanks!

Sent from my iPhone

On 31 Aug 2022, at 20:34, Ben Major <ben.m...@gmail.com> wrote:



To view this discussion on the web visit https://groups.google.com/d/msgid/redbeanorm/CAHrgLKhY5o9yjx7MX_%3DWVCJKpwy0wFmf_9vt5jwNfG6O2qPjnQ%40mail.gmail.com.

[Ben Major]

No problem!

To view this discussion on the web visit https://groups.google.com/d/msgid/redbeanorm/9E7DF265-019D-4F30-B875-FD416F5B74D8%40mikejw.co.uk.