I'm curious as to how the Custom Schema works - what should I be reading?

In particular, I'm interested to know if it could, or should, form the basis of a document management system that includes workflow, authorisations and more general dynamic management of documents. Is this the wrong place to be doing this?