invantive documentation
Invantive Support ForumsLog In / Sign Up

Sample Data Model

In-memory database with fixed data set for regression testing and demos.

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.
  • Data can be written as well as read.
  • Invantive Cloud plans: Free for public data, Office for Entrepreneurs, Office for Accountants, Premium Finance.

Figures

Figure Count
Tables 36
Columns 5,293
Tables with insert 2
Tables with update 1
Tables with delete 1
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.

Sample data model, Sheet 1 of 1Sample data modelfor use with Invantive UniversalSQLRelease 27.1.3-BETA+6294 · 01-11-2026DemoSheet 1 of 1 · documentation.invantive.euDemoDummy.Demo.activitysectors: Activity sectors (Dummy.Demo.activitysectors_dml)activitysectors+_dmlDummy.Demo.documentpaths: Documents PathsdocumentpathsDummy.Demo.documents: DocumentsdocumentsDemoDummy.Demo.BanksBanksDummy.Demo.BudgetMovementsBudgetMovementsDummy.Demo.BudgetsBudgetsDummy.Demo.CashflowProjectionDailyLinesCashflowProjectionDailyLinesDummy.Demo.CashflowProjectionLinesCashflowProjectionLinesDummy.Demo.CashflowProjectionsCashflowProjectionsDummy.Demo.ConceptInvoiceLinesConceptInvoiceLinesDummy.Demo.ContractBudgetsContractBudgetsDummy.Demo.DmsDocumentsDmsDocumentsDummy.Demo.InvoiceLinesInvoiceLinesDummy.Demo.InvoicesInvoicesDummy.Demo.OrganisationsOrganisationsDummy.Demo.PersonsPersonsDummy.Demo.PhoneCallsPhoneCallsDummy.Demo.PriceListLinesPriceListLinesDummy.Demo.PriceListsPriceListsDummy.Demo.ProjectAllocationsProjectAllocationsDummy.Demo.ProjectAutorisationsProjectAutorisationsDummy.Demo.ProjectParticipationsProjectParticipationsDummy.Demo.ProjectPhasesProjectPhasesDummy.Demo.ProjectsProjectsDummy.Demo.PurchaseOrdersPurchaseOrdersDummy.Demo.RevenuesRevenuesDummy.Demo.TasksTasksDummy.Demo.TimeSheetsTimeSheetsDummy.Demo.UnitsUnitsNativeDummy.Native.NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar RequestsNATIVEPLATFORMSCALARREQUESTSSystemDummy.System.binarytesttable: Binary test tablebinarytesttableDummy.System.[empty with"space$#]: Empty table with complex nameempty with"space$#Dummy.System.identifiertest: Identifiers table with one single rowidentifiertestDummy.System.rls_test: RLS test tablerls_testSampleData 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.TopicsDemo1Tables 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 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/dummy
The poster as text: tables per topic and their relations

Demo

activitysectors, documentpaths, documents

Demo (without relations)

Banks, BudgetMovements, Budgets, CashflowProjectionDailyLines, CashflowProjectionLines, CashflowProjections, ConceptInvoiceLines, ContractBudgets, DmsDocuments, InvoiceLines, Invoices, Organisations, Persons, PhoneCalls, PriceListLines, PriceLists, ProjectAllocations, ProjectAutorisations, ProjectParticipations, ProjectPhases, Projects, PurchaseOrders, Revenues, Tasks, TimeSheets, Units

Native (without relations)

NATIVEPLATFORMSCALARREQUESTS

System (without relations)

binarytesttable, [empty with"space$#], identifiertest, rls_test

Relations

Tables

Dummy.Demo

Dummy.Native

Dummy.System

  • binarytesttable: Binary test table
  • [empty with"space$#](Dummy.System.[empty with"space$#]): Empty table with complex name
  • func
  • identifiertest: Identifiers table with one single row
  • rls_test: RLS test table

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: