[symfony-users] Re: Concept Issue

2010-07-27 Thread Tom Ptacnik
Ok, then I think that with only 3 tables the schema would be too complex. Because then it looks to me like M:N relation(r1) between Design and Type Then this relation r1 is M:N related to the size. And also quantity is somehow related to the all of that? ..phew.. :) Then maybe another way would be

[symfony-users] Re: Concept Issue

2010-07-26 Thread Micoto
Thanks for replying Tom, It is 2), but with combinations of 1c) they will be connected to combinations of type, size and quantity. e.g. Person selects Design 1.. they get a drop down list of available media types (not all may be available, flyers and posters may be available, but banners not al

[symfony-users] Re: Concept Issue

2010-07-26 Thread Tom Ptacnik
Hi, there are some questions which you have to answer if you want to design this app. 1) sizes are connected to the type or to the design, or to the combinatioin of design&type? a) all posters have size A5 and A6 (no matter which design), all banners has size A6, A7 (no matter which design) b