Well, I think you have the right plan. You'd definitely want to retain and display each document's complete revision history, not just the most recent revision.
Here’s a basic outline of a minimal set of tables. I don't recommend this narrow approach for a serious PLM system, but it'll be fine...