Radicore Forum: How To » which pattern?

Home » RADICORE » How To » which pattern?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

which pattern? [message #340]

Fri, 27 October 2006 06:45

galdiolom
Messages: 3
Registered: October 2006
Location: Padova ITALIA

Junior Member

Hi,
I still have a stupid question, but hope that someone can help me...

How can I implement the RADICORE architecture in a situation like this:

I have to insert (add) one(more) musical instrument(s) to one (more) musician(s) related to a specific track (that, in turn, is corrrelate to a specific musical record)
Which pattern I must use?

The structure is:

- table INSTRUMENTS is related to table LINK_MUSICIAN_TO_TRACK in a MANY-TO-MANY relationship where LINK_INSTRUMENT_TO_MUSICIANxTRACK is the link table;

- table MUSICIANS is related to table TRACKS in a MANY-TO-MANY relationship where LINK_MUSICIAN_TO_TRACK is the link table;

- table TRACKS is related to table RECORDS in a ONE-TO-MANY relationship.

Report message to a moderator

Re: which pattern? [message #341 is a reply to message #340]

Fri, 27 October 2006 09:13

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

When dealing with many-to-many relationships there are several alternatives. If you look in the menu systems maintenance tasks you will see 3 alternatives for dealing for dealing with menu items:
(1) pattern MULTI2
(2) pattern LINK1
(3) pattern LIST2

You need to look at how these operate then pick the one that suits your purposes best.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Previous Topic:	Convert XMI to PHP
Next Topic:	Failure with Rename Task

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Jul 04 15:21:05 EDT 2025

Total time taken to generate the page: 0.09746 seconds