A while back, I was able to provide some assistance to Garth Jones in documenting the existing SMS/SCCM SQL Server views. Doug Eby, a Senior Technical Writer at Microsoft created some fine documentation, in part based on our work. Doug did an outstanding job putting this together, the schema view, is well, priceless!
Documentation link available here:
http://www.microsoft.com/downloads/details.aspx?FamilyId=87BBE64E-5439-4FC8-BECC-DEB372A40F4A&displaylang=en.
His blog posting is here:
http://blogs.technet.com/wemd_ua_-_sms_writing_team/archive/2008/10/30/announcement-the-creating-custom-reports-by-using-configuration-manager-2007-sql-views-documentation-package-is-now-available-for-download.aspx.
Feedback is welcomed!