Thread: Inherit or Foreign Keys
Hi All I want to make a site that's contain articles in multi language. ( The same article can be seen for example in English, French .... ) I thought of two ways. 1. using Foreign keys. main tables containing the fields which are not seen like id, settings ..... second table with foreign key to the main ID & field saying the language name and all the others fields are the translations. 2. using inherit main tables containing the fields which are not seen like id, settings ..... Second table called as the language name that will inherit the main one with all the translated fields as title, author .... Which method looks better for the list ? Speed is important too :) -------------------------- Canaan Surfing Ltd. Internet Service Providers Ben-Nes Michael - Manager Tel: 972-4-6991122 http://sites.canaan.co.il --------------------------
On Sun, 2002-04-07 at 18:03, Ben-Nes Michael wrote: > 1. using Foreign keys. > main tables containing the fields which are not seen like id, settings ..... > second table with foreign key to the main ID & field saying the language > name and all the others fields are the translations. Please go for this solution. > > 2. using inherit > main tables containing the fields which are not seen like id, settings ..... > Second table called as the language name that will inherit the main one with > all the translated fields as title, author .... The OO model i PG is not ready for real use, yet, So, please don't use it for production. /BL