CakePHP - zero-to-many relationship

In CakePHP, how do you setup a zero-to-many relationship?

For example, I have three models: Player, Pitch开发者_开发百科erStats, and FielderStats. A Player is either a Pitcher or a Fielder. Accordingly, the Player will have (zero or many) Pitcher stats or (zero or many) Fielder stats. The PitcherStats will have a belongsTo relationship to Player. And so will the FielderStats. How does the Player model relate to the other two?

---

you should have one table for stats with foreign keys to the concrete stats. so you should build 3 tables for stats, one which will hold all stats (foreign key and type) and two will hold the concrete values.

---

zero to x relation ship is a subgroup of 1/n to x relationships

there are in fact only 2:

• 1:n
• n:m

in different combinations and with different choices of foreign keys

e.g. 1:1 is nothing but 1:n where you can decide where to put the key (left or right table).

0:x is a simple case of 1:n or n:m where there is no record yet.