search for: journey_id

...neys . A journey should have many users and many users should have many journeys. That will result in the following tables: journeys <-> journeys_users <-> users ------------------------------------------------------------------------ -------------------------------------- id journey_id id name item_id name ... password ...... Here is my problem: I now want to relate inventory(holdings) to journeys, so that i can show how many tents/sleepingbacks are carried in one journey. Whats the most effective way doing this? * should i expand the holdings...