Re: design question: one to many relationship

2001-12-31 Thread Gordon Reynolds
ent: Sunday, December 30, 2001 5:51 AM Subject: design question: one to many relationship > i have a design question for the list: > > i have a situation where i have some persons that each owns a number of > games... each game has only one owner. > > using orions OR mapping

Re: design question: one to many relationship

2001-12-30 Thread Scott Farquhar
Morten, Putting a collection of games attached to each person suggests a many-to-many relationship. Why don't you have each game have an owner? Game (Id, Owner, Name) Owner (Id, Name) Then you have a one-many relationship. Cheers, Scott -- Scott Farquhar :: [EMAIL PROTECTED] Atlassian :: h

Fw: design question: one to many relationship

2001-12-30 Thread Morten Wilken
- Original Message - From: "Morten Wilken" <[EMAIL PROTECTED]> To: "Orion-Interest" <[EMAIL PROTECTED]> Sent: Sunday, December 30, 2001 2:51 PM Subject: design question: one to many relationship > i have a design question for the list: > > i h

design question: one to many relationship

2001-12-30 Thread Morten Wilken
i have a design question for the list: i have a situation where i have some persons that each owns a number of games... each game has only one owner. using orions OR mapping features i have put a collection of games in each personbean. This creates a many-to-many table with a personid and a game