Hmmm, that's an interesting method. I was hoping for some way to add attributes though. Does anyone else have any ideas? -Nate
On 8/23/07, Thomas Guettler <[EMAIL PROTECTED]> wrote: > > > Am Freitag, 24. August 2007 00:50 schrieb Nathaniel Martin: > > I'm hoping that some of the django experts on this list can help me with > a > > problem I'm working on designing the architecture of a site I'm working > on. > > I want to have many objects that each belong to a category. Each > category > > has a bunch of attributes. Each object would set values for each of > those > > attributes. > > ... > [cut] > > B) Have an 'Objects' table, a 'Categories' table, and multiple > 'Attributes' > > tables, one for each datatype I think will be used. The 'Objects' table > has > > a column tying it to a certain category. The 'Categories' table has a > > column for each attribute table, and lists which attributes are used for > > which table. Each 'Attribute' table stores all the attributes of that > > datatype, with a column pointing to which category and object it's for. > > > > Downsides: Really complicated. I can see this getting very messy very > > quickly. Lots of tables. > > I have started an application that uses this approach. It is far from > being > finished. I do something like inheritance at database level: > > One Category can have an other Category as parent. A subcategory has > all the attributes of its parent and grandparents. > > The user can: > - change the hierarchie of categories > - add categories > - add existing attributes to categories > > Up to now he can't: > - add new attributes. ( > This would need a python file and something like syncdb. > That should be done by a developer) > > > Thomas > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
