invantive documentation
Invantive Support ForumsLog In / Sign Up

Wikipedia Data Model

Wikipedia information.

Set up this platform in Invantive Cloud: https://cloud.invantive.com/wikipedia

Text comparisons on this platform are case sensitive.

Platform

  • Used from: Invantive Cloud and the Invantive products on your own computer or server.
  • Kind: an application reached over its API.
  • The data is partitioned, such as per company or administration.
  • Invantive Cloud plans: Free for public data, Office for Entrepreneurs, Office for Accountants, Premium Finance.
  • Status of the platform: https://www.wikimediastatus.net/.

Figures

Figure Count
Tables 18
Columns 201
Tables with insert 1
Tables with update 0
Tables with delete 0
Tables documented 1

Data Model Poster

PDF, 1 A0 sheet

On a table of the poster: plus and minus zoom, the arrow keys move, 0 fits.

Wikipedia data model, Sheet 1 of 1Wikipedia data modelfor use with Invantive UniversalSQLRelease 27.1.3-BETA+6294 · 01-11-2026WikipediaSheet 1 of 1 · documentation.invantive.euWikipedia×4×3×2Wikipedia.Wikipedia.file: FilefileWikipedia.Wikipedia.page: Page (Wikipedia.Wikipedia.page_history, Wikipedia.Wikipedia.page_html, Wikipedia.Wikipedia.page_media, Wikipedia.Wikipedia.page_source)page+_history +_html +_media +_sourceWikipedia.Wikipedia.revision: Revision (Wikipedia.Wikipedia.revision_html, Wikipedia.Wikipedia.revision_source)revision+_html +_sourceWikipedia.Wikipedia.search: Wikipedia Search (Wikipedia.Wikipedia.search_title)search+_titleNativeWikipedia.Native.NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar RequestsNATIVEPLATFORMSCALARREQUESTSWikipediaData dictionaryEvery table and column of this data model is described with its documentation ondocumentation.invantive.eu, where the poster is also available in other languages.NotesThe boxes are grouped by topic and coloured by category. A relation is drawn in the topic of thetable holding the key; a box in pale grey is defined in another topic.TopicsWikipedia1Tables without relations1LegendTransactionalSetupTechnicalHard-coded valuesDefined in another topicDeclared keyRelation described in wordsCandidate derived from column namesBold: a popular table+Bulk, +Read: the table also exists as these variants×n: n relations between the same tablesGenerated from the metadata of Invantive UniversalSQL 27.1.3-BETA+6294 on 01-11-2026. Every table links to itspage with columns, keys and sample queries.documentation.invantive.eu/en/datamodels/wikipedia
The poster as text: tables per topic and their relations

Wikipedia

file, page, revision, search

Native (without relations)

NATIVEPLATFORMSCALARREQUESTS

Relations

  • page → file (candidate): Follows from the name of the column and held in the sampled rows of 2026-10-31; the specification does not state this relation.
  • page → revision (key, 4 keys)
  • revision → page (key, 3 keys)
  • search → page (key, 2 keys)

Tables

Wikipedia.Native

Wikipedia.Wikipedia

Attributes

The attributes of this platform are on the page Attributes.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: