Hi!

Ok, I'm designing a database to a website, where you first select your country and then your language.

For example user chooses "Finland" as country and then selects language version "english" or "finnish" (there can be more options..).

There will be a management system where administrator can easily add countries and languages. (and update the data of course).

This is what I have now:

tblCountry:
id | countryname

tblLang:
id | langname

tblData:
id | countryid | langid | pageid | data

(pageid is link1,link2,link3,link4... because the main menu is static)

The main problem is the image gallery (kind of) with description text for every image and the gallery should also be multi country/language but I haven't figured out how to do it. I don't want to upload those pictures more than one time.

tblPicturecollection:
id | title | type

tblPictures:
id | collectionid | imgsrc | imgdescription

And there's even more, but I'll stop here.

Please help or give some advices if you have done this kind of systems before or you are others ways experienced.

This is my largest project so far, so I'm little lost here.

Thanks!

tblCollection(CollectionID, Title, Type)

tblPicture(PictureID, CollectionID, Imgsrc)

tblCaption(CountryID, LangID, PictureID, Caption)