Ashar Voultoiz wrote:
Hello !
Sometime ago there was a lot of discussion about a database shema change. I am wondering if that's a dead-end horse or if we can eventually start discussion again and eventually got the changes in for version 1.4 ?
I have some ideas of new fields that can help, and probably a friend who is a database designer who is willing to help review our shema (although he is writing a book actually).
Or maybe we just add new tables and new fields whenever we want new features, but I am not sure it is the best solution.
When there is room for some new database tables, I am working on some idea's for wiktionary. These tables would be relational.
I am thinking about these tables and relations
Word table Language table Meaning table WordType table Translation table Idiom table Synonym / Antonym etc table
A Wiktionary page has one or more Words A Word has a Language A Word has one or more Meanings A Meaning has a WordType A Word has one or more Translations A Translation may have a Word in another Language, and a defenition in the same Language. Synonym etc has another Word in the same Language and an indication what kind of relation exists.
These are the initial ideas that I have, I am still toying with them. I think they will allow one database to contain all words in all languages. It will result in a more integrated wiktionary whereby efforts will be a benefit within the whole wiktionary environment.
NB At this stage I am thinking about structure; user interface I have not yet considered the user interface. The user interface has to be intuitive and has to accomodate several languages.
Thanks, GerardM