Re: Circular relations?
I have a Spell-table, a Campaign-table, a PlayerCharacter-table, a CampaignSpell-table (many-to-many relation between Campaign and Spell), and a Spellbook-table (many-to-many relation between PlayerCharacter and CampaignSpell). There is also a one-to-many-relation between Campaign and PlayerCharacter.
The problem is, the Spellbook-table holds four foreign primary keys (or four primary foreign keys, whicever is the correct), PlayerCharacter_idPlayerCharacter, CampaignSpell_idSpell, CampaignSpell_idCampaign, and PlayerCharacter_idCampaign. This seems somewhat excessive. Is there a way to reduce this number?
Subject
Written By
Posted
Re: Circular relations?
May 10, 2005 12:20AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.