invantive documentation
Invantive Support ForumsLog In / Sign Up

Data Cache Data Model

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.
  • One query can read several companies at once.
  • Invantive Cloud plans: Free for public data, Free, Office for Entrepreneurs, Office for Accountants, Premium Finance.

Figures

Figure Count
Tables 18
Columns 430

Data Model Poster

This data model declares no keys yet; the dotted relations are derived from column names.

PDF, 1 A0 sheet

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

Data Cache data model, Sheet 1 of 1Data Cache data modelfor use with Invantive UniversalSQLRelease 22.1.262-BETA+4120 · 17-08-2023Tables without relationsSheet 1 of 1 · documentation.invantive.euInvantiveCache.Invantive.dc_data_containers: Datacontainersdc_data_containersCache.Invantive.dc_event_log: Eventsdc_event_logCache.Invantive.dc_fact_size_statistics: Fact Size Statisticsdc_fact_size_statisticsCache.Invantive.dc_ime_statistics: Incoming Message Statisticsdc_ime_statisticsCache.Invantive.dc_incoming_messages: Incoming Messagesdc_incoming_messagesCache.Invantive.dc_my_incoming_messages: My Incoming Messagesdc_my_incoming_messagesCache.Invantive.dc_partitions: Partitionsdc_partitionsCache.Invantive.dc_physical_statistics: Physical Statisticsdc_physical_statisticsCache.Invantive.dc_repository_contents: Repository Contentsdc_repository_contentsCache.Invantive.dc_sessions: Sessionsdc_sessionsCache.Invantive.dc_settings: Settingsdc_settingsCache.Invantive.dc_table_partition_versions: Table Partition Versionsdc_table_partition_versionsCache.Invantive.dc_table_partitions: Table Partitionsdc_table_partitionsCache.Invantive.dc_tables: Tablesdc_tablesCache.Invantive.dc_tpn_states: Table Version Statesdc_tpn_statesCache.Invantive.dc_versions: Installation Historydc_versionsCache.Invantive.dc_warning_statistics: Warning Statisticsdc_warning_statisticsCache.Invantive.dc_warnings: Warningsdc_warningsData CacheNotesThis data model declares no keys yet; the dotted relations are derived from column names.Data 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.TopicsTables 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 keys between the same tablesGenerated from the metadata of Invantive UniversalSQL 22.1.262-BETA+4120 on 17-08-2023. Every table links toits page with columns, keys and sample queries.documentation.invantive.eu/en/datamodels/invantivedatareplicator
The poster as text: tables per topic and their relations

Invantive (without relations)

dc_data_containers, dc_event_log, dc_fact_size_statistics, dc_ime_statistics, dc_incoming_messages, dc_my_incoming_messages, dc_partitions, dc_physical_statistics, dc_repository_contents, dc_sessions, dc_settings, dc_table_partition_versions, dc_table_partitions, dc_tables, dc_tpn_states, dc_versions, dc_warning_statistics, dc_warnings

Tables

Cache.Invantive

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: