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
On a table of the poster: plus and minus zoom, the arrow keys move, 0 fits.
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)
System (without relations)
binarytesttable, [empty with"space$#], identifiertest, rls_test
Relations
- activitysectors → activitysectors (key)
- documentpaths → documents (key)
Tables
Dummy.Demo
- 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
- activitysectors: Activity sectors
- activitysectors_dml: Activity sectors with insert, update and delete
- documentpaths: Documents Paths
- documents: Documents
Dummy.Native
- NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar Requests
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: