having trouble understanding associations

Looking here:
http://book.cakephp.org/view/78/Associations-Linking-Models-Together

I'm certain my issue is due to a personal lack of understanding.

I'm trying to homebrew a simple app to keep track of my guitar
practice.

I have the following models:
PracticeItem: a specific exercise to be practiced any number of times
PracticeInstance: an instance of having practiced one specific
PracticeItem
PracticeSession: a collection of PracticeInstance

My immediate instinct is to say PracticeInstance "hasOne"
PracticeItem.

According to the Book: X hasOne Y => table Y having an X_id field.

In my case PracticeInstance "hasOne" PracticeItem would mean:
PracticeItems has a field practice_instance_id

This makes no sense because if I were to create a PracticeItem called
"Major Scales 2", I would plan to practice it multiple times.

If the field for this PracticeItem looks like
id = 123
title = "Major Scales 2"
practice_instance_id = 23

then I would have to duplicate the PracticeItem every time I practiced
it.

To me it would make more sense if PracticeInstance looked like:
id = primaryKey, autoincrement
datetime = ...
comment = ...
timeSpent = ...
practice_item_id = 123

Can anyone explain where I might have mixed things up?

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.

You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en

To unsubscribe from this group, send email to cake-php+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.