i have simple cms trying build myself stuck @ designing structure of database.
i have 3 tables in database : content, images, seo (and have blog laterly)
my question seo table. trying use seo table both pages , images (for alt tags)
however need seo title , seo description pages , seo title images. better separate 2 tables images_seo , page_seo ? have 10 pages (x3 languages) more 200 pictures. proper way it?
my content table looks like:
---------------------------------------------------- id | content_id | page_id | lang_code | content_text
images table :
------------------------- id | page_id | image_name
my seo tables looks @ moment
------------------------------------------------------------------------------------- id | page_id | image_id | lang_code | type | page_title | seo_title | seo_desc ------------------------------------------------------------------------------------- 1 | 1 | 1 | en | image | | test image | 2 | 1 | | fr | page | homepage | test page | page seo desc
i solve problem way on seo content module. each content page have files pictures , text content in language. when content edit in wysiwyg editor link images inserted in text. it's because same image can used in different languages different alt tags or image must translated if contain text. structure is: content->({content in language},{pictures})
Comments
Post a Comment