Hello,
I have a question which haunts me for some time now, since I'm testing
ORM tools in fact.
Let's take and example:
I have "Objects" which have a name which could be in multiples
languages. I usually do a third party table like the following:
- a table "Objects"
- a table "Languages"
- a table "ObjectNames" with a foreign key to "Objects", a foreign key
to "Languages" _and_ the translated name.
The problem I have with that kind of structure and ORM tools is the need
to create an additional object for the third-party table.
It seems to me that ORM tool prefer the following structure :
- a table "Objects"
- a table "Languages"
- a table "NamesLanguages" with a "name" and a foreign key to "Languages"
- a table "ObjectNames" with a foreign key to "Objects" and a foreign
key to "NamesLanguages"
So my question(s) are:
what's the better way to do ? 3 tables of 4 tables ? Is the 4 tables
solution better / more normalized ?
In advance thanks for your answers !
Julien
-------------------------------------------------------
All the advantages of Linux Managed Hosting--Without the Cost and Risk!
Fully trained technicians. The highest number of Red Hat certifications in
the hosting industry. Fanatical Support. Click to learn more
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users