Hi,
assume we have three table
News
Articles
Menu
and we have two field
1.Description
2.Keywords
I want to know which is better?
* add this two fields to all three tables
* make another table (tbl_meta) with these fields : metaId,description,keywords
and three Interface table
1.(a table that NewsId and metaId are forionkey of it)
2.(a table that ArticleId and metaId are forionkey of it)
3.(a table that MenuId and metaId are forionkey of it)
and make relation between tbl_meta and previous tables Separately.
tbl_meta and News table
tbl_meta and Article table
tbl_meta and Menu table
thanks a lot