Datamodell/databasestructure


#1

Hi.

I am trying to develop a small utility to manage inventories for
outdoor-journeys

At the moment I have the following tables to show a many_to_many-
relationship between items(like tents/sleepingbags) and users:

items <-> holdings(join) <-> users


id user_id id
name item_id name
… number password
id …

Now i want to expand my model with journeys .

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 table with a journey_id-column     OR
* should i create a new table journeys_holdings with journey_id and

holding_id as column?

Thanks in advance,
Tobias