See Manual:Database layout and Manual:Database layout/diagram for MediaWiki core schema documentation.
Is there an updated database schema because in this schemahttps://upload.wikimedia.org/wikipedia/commons/thumb/4/42/MediaWiki_1.20_%2844edaa2%29_database_schema.svg/2500px-MediaWiki_1.20_%2844edaa2%29_database_schema.svg.png
the revision table in enwikisource changed. At least one field no longer exists.
There is some information on the Actor migration changes and how they affected the views exposed on the Wiki Replica servers at wikitech:News/Actor storage changes on the Wiki Replicas. There are likely quite a number of other changes which have happened since the MediaWiki 1.20 schema that is documented in that diagram. A similarly major one would be Manual:Comment table.
Thanks for the info. It's much appreciated. My interest is limited to the English Wikisource. I am flying blind trying to extract data. Perhaps there is current list of the table structures used by Wikisource?
The most up to date information is generally the schema documentation in the MediaWiki source tree: maintenance/tables.sql. Manual:Database layout and Manual:Database layout/diagram are generally updated soon after major changes are introduced.
Thanks again. The Manual:Database layout/diagram is excellent. That is what I was looking for
