Re: [web2py] Database design question regarding the usage of supertypes for a web2py project

2014-09-16 Thread Richard Vézina
You are welcome! Richard On Mon, Sep 15, 2014 at 3:45 PM, Jan Beilicke jan.beili...@gmail.com wrote: I chose approach B and it works fine. Thanks for mentioning drop downs. Kind regards, Jan Am Donnerstag, 11. September 2014 17:24:40 UTC+2 schrieb Richard: B will help you filter your

Re: [web2py] Database design question regarding the usage of supertypes for a web2py project

2014-09-15 Thread Jan Beilicke
I chose approach B and it works fine. Thanks for mentioning drop downs. Kind regards, Jan Am Donnerstag, 11. September 2014 17:24:40 UTC+2 schrieb Richard: B will help you filter your drop down of component package if you can only have in a package the same supertype component. Difficults

[web2py] Database design question regarding the usage of supertypes for a web2py project

2014-09-11 Thread Jan Beilicke
Hi everyone, I'm working on a web2py project which requires a complex relationship model. I want to use a model that works well with web2py's DAL and I would be glad if somebody could point me into the right direction. I created a small sample ER diagram to illustrate my problem, only the

Re: [web2py] Database design question regarding the usage of supertypes for a web2py project

2014-09-11 Thread Richard Vézina
Why component_a, _b, _c... You will end up create new table all the time... Richard On Thu, Sep 11, 2014 at 7:04 AM, Jan Beilicke jan.beili...@gmail.com wrote: Hi everyone, I'm working on a web2py project which requires a complex relationship model. I want to use a model that works well

Re: [web2py] Database design question regarding the usage of supertypes for a web2py project

2014-09-11 Thread Jan Beilicke
These are just sample names. In reality they are separate business/use case entities sharing only the same supertype, they are not enumerated. Am Donnerstag, 11. September 2014 15:42:47 UTC+2 schrieb Richard: Why component_a, _b, _c... You will end up create new table all the time... Richard

Re: [web2py] Database design question regarding the usage of supertypes for a web2py project

2014-09-11 Thread Richard Vézina
B will help you filter your drop down of component package if you can only have in a package the same supertype component. Difficults to say without concrete example. Richard On Thu, Sep 11, 2014 at 9:58 AM, Jan Beilicke jan.beili...@gmail.com wrote: These are just sample names. In reality