Because some content systems are designed to allow the addition of content and allow a different date than that of the current date, eg you may have an article published on a site you want to copy and as a date reference you keep that date and the content date is the current date, you can run in to some problems with pushing dates out of sequence if your CMS has a limited date function.
Alternatively you may not want content to appear until a certain date, therefore you would get items published before they were due if same date referencing is limited.
So you would need a database that has something like:-
PUBLISH.ID --> the ID that would form part of the query string
PUBLISH.CREATED --> loaded on to system
PUBLISH.DATE --> publish on or published on this date
PUBLISH.EXPIRE --> expire / don't show after a certain date
PUBLISH.AUTHOR_ID --> the ID ref of the Author
PUBLISH.CONTENT_ID --> the ID of the content
PUBLISH.SOURCE_ID --> The Source Link information
CONTENT.ID --> the article ID
CONTENT.TYPE --> the type of content, it could be a NEWS item or a PAGE
CONTENT.KEYWORDS --> any tags or keywords associated with the article, useful for an internal search engine
CONTENT.SUMMARY --> a summary of the article, a short version like an extended grabline
CONTENT.BODY --> the article itself
CONTENT.DELETED --> flag set if you want content marked as deleted, this could be a date reference and can also act as a flag
SOURCE.ID --> the ID
SOURCE.URL --> where it is, eg http://somewhere.com/index.php?article=12345&...
SOURCE.URL_DISPLAY --> what you want to display somewhere.com
SOURCE.TITLE --> the title tag of the link what will display, eg "go to site blah blah"
The scheme above would give you scope to have more than one author on your CMS system and also allow log in via that information
Your various tables / groups form a lose type of normalized database where you have tables for authors, content and a simple table to bring those elements together, so you could incorporate a search feature for or pull all articles by a certain author that were containing certain keywords that were published on or between certain dates...