[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
comments on database format
I am looking at the database format and have a few comments:
1. In the article table, should there be a version number?
Such a verison could be MM.mm.ff or 6 digits???
MM -- major, mm -- minor, ff -- minor edits
This would be useful HOWTO's, etc.
2. Should there be an article history (even if not visible
to the end user)? For example, a link in the article table
to a previous version of the article in a "prior article"
table. When updating an article, one would copy the existing
to the prior table then update the article table entry?
This could be an update option (keep prior article or
don't keep it)?
3. Should the article-user cross-reference contain a
field with values like "author", "contributor",
"maintainer", "referenced", etc?
4. Should the database contain a new table for comments
or followup on articles? If so, should the role table
contain a permission bit to allow the posting of
comments or followup info? For example, someone could
write an article and another could provide comments
or system-specific suggestions for it????
These are just my 2 cents and some food for thought....
Cheers,
--
W. Wade, Hampton <whampton@staffnet.com>
Linux is new, it's come out of nowhere, it's free. Hard to beat that
price. And it's taking marketshare left and right.
--Microsoft's lawyer, in closing argument, Bristol v. Microsoft,
http://www.microsoft.com/presspass/bti/07-15closing.htm