Hi all
I'm going to build a very basic news database, it will be one news item per page and has the following required fields
id|title|desc|keywords|headline|subhead|text|date
It seems clear to create two tables
id|title|desc|keywords
and
id|headline|subhead|text
but where should the date go? and does it mattter?
I'm tempted to put it in the first table as it will help if I want to search through the DB for keywords and dates but I'm looking for a second opinion.
Many thanks
Nick
I'm going to build a very basic news database, it will be one news item per page and has the following required fields
id|title|desc|keywords|headline|subhead|text|date
It seems clear to create two tables
id|title|desc|keywords
and
id|headline|subhead|text
but where should the date go? and does it mattter?
I'm tempted to put it in the first table as it will help if I want to search through the DB for keywords and dates but I'm looking for a second opinion.
Many thanks
Nick