[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