Design database tables with clear relationships.
Recent revisions are kept. Restoring one creates a new revision.
