Is the AGILEOBJECTIDSEQUENCE revision specific
AGILEOBJECTIDSEQUENCE has nothing to do with revisions. It is a defined sequence in the database to give EVERY record a unique ID, across the tables it is used for. So it is not reset for every revision, as ALL records in the REV table will have a unique ID, across all parts/documents. It is used for most (but not all) tables in the database.
And no, there is no published documentation for the Agile schema. Never has been, and since they are no longer selling the software, I doubt there ever will be.