Doesn't CakePHP 1.2 support additional fields in a HABTM table?
David
On Jan 21, 6:15 pm, Ponderosa - Lists
[EMAIL PROTECTED] wrote:
Your colors_shirts_sizes table should be a new table/model inventory.
Inventory
- id
- shirt_id
- size_id
- color_id
- inventory_qty
... any other
On Jan 22, 6:25 am, david_setwise [EMAIL PROTECTED] wrote:
Doesn't CakePHP 1.2 support additional fields in a HABTM table?
David
Yes, but I doubt that is going to make your life very easy if you try
to administer/user your Colors_Shirts_Sizes table based on that.
Wouldn't your
It does, but you still need a model for the link. If I remember
correctly anyway.
I think Danielle is correct here though. Your database structure is
overcomplicated a little - you could achieve the same goal by having:
Size:-
id
size
shortCode
Colour:-
id
colour
Style:-
id
style
description
Doesn't CakePHP 1.2 support additional fields in a HABTM table?
David
On Jan 21, 6:15 pm, Ponderosa - Lists
[EMAIL PROTECTED] wrote:
Your colors_shirts_sizes table should be a new table/model inventory.
Inventory
- id
- shirt_id
- size_id
- color_id
- inventory_qty
... any other
I see you point about making the database structure more simple, and I
like it, but does that make the programming logic a lot more
complicated? If I add a Style with 20 colors and 4 sizes, do I have
to manually loop through all the potential options to save all the
corresponding Stock records,
On Jan 22, 6:37 pm, david_setwise [EMAIL PROTECTED] wrote:
I see you point about making the database structure more simple, and I
like it, but does that make the programming logic a lot more
complicated? If I add a Style with 20 colors and 4 sizes, do I have
to manually loop through all