invantive documentation
Invantive Support ForumsLog In / Sign Up

Data Dictionary Data Model

The Invantive UniversalSQL data dictionary contains the metadata of your current environment.

For example, the view SystemTables@DataDictionary contains every available table and view in the current database. Besides object definitions also actual execution information is available in views. For example, the view SystemSqlArea@DataDictionary contains all executed and cached Invantive SQL statements. The data in the data dictionary views is generated dynamically by Invantive SQL from the runtime environment. Changing data in the data dictionary views is not possible.

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 94
Columns 2,195
Tables with insert 2
Tables with update 1
Tables with delete 1
Tables documented 5

Data Model Poster

PDF, 1 A0 sheet

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

Data Dictionary data model, Sheet 1 of 1Data Dictionary data modelfor use with Invantive UniversalSQLRelease 27.1.3-BETA+6294 · 01-11-2026Invantive · SYSTEMDATACONTAINERS · Invantive · SYSTEMSQLAREA · Invantive · SYSTEMPROVIDERS · Invantive · SYSTEMTABLES · Invantive · SYSTEMSCHEMAS · Invantive · S…Sheet 1 of 1 · documentation.invantive.euInvantive · SYSTEMDATACONTAINERSDataDictionary.Invantive.SESSIONROWSCHANGED: Rows Changed in SessionSESSIONROWSCHANGEDDataDictionary.Invantive.SYSTEMDATACONTAINERATTRIBUTES: Data Container Attributes and Their ValuesSYSTEMDATACONTAINERATTRIBUTESDataDictionary.Invantive.SYSTEMDATACONTAINERHTTPCACHECONTENTS: System Data Container HTTP Cache ContentsSYSTEMDATACONTAINERHTTPCACHE…DataDictionary.Invantive.SYSTEMDATACONTAINERMESSAGES: Data Container MessagesSYSTEMDATACONTAINERMESSAGESDataDictionary.Invantive.SYSTEMDATACONTAINERPROPERTIES: Data Container PropertiesSYSTEMDATACONTAINERPROPERTIESDataDictionary.Invantive.SYSTEMDATACONTAINERRESERVEDWORDS: Provider Reserved WordsSYSTEMDATACONTAINERRESERVEDW…DataDictionary.Invantive.SYSTEMDATACONTAINERS: DatacontainerSYSTEMDATACONTAINERSDataDictionary.Invantive.SYSTEMDATACONTAINERSLOTBASEDRATELIMITERS: Provider Slot-based Rate LimitersSYSTEMDATACONTAINERSLOTBASED…DataDictionary.Invantive.SYSTEMDATACONTAINERSLOTBASEDRATELIMITERSLOTS: Provider Slot-based Rate Limiter SlotsSYSTEMDATACONTAINERSLOTBASED…DataDictionary.Invantive.SYSTEMDOMAINCODES: Code/value DomainsSYSTEMDOMAINCODESDataDictionary.Invantive.SYSTEMDOMAINCODEVALUES: Domain ValuesSYSTEMDOMAINCODEVALUESDataDictionary.Invantive.SYSTEMFILTERTOTABLEFUNCTIONPARAMETERS: Filter to Table Function ParametersSYSTEMFILTERTOTABLEFUNCTIONP…DataDictionary.Invantive.SYSTEMLICENSES: LicensesSYSTEMLICENSESDataDictionary.Invantive.SYSTEMOAUTHFLOWEVENTS: OAuth Flow EventsSYSTEMOAUTHFLOWEVENTSDataDictionary.Invantive.SYSTEMPARTITIONS: PartitionsSYSTEMPARTITIONSDataDictionary.Invantive.SYSTEMPARTITIONSTATISTICS: System Partition StatisticsSYSTEMPARTITIONSTATISTICSDataDictionary.Invantive.SYSTEMPARTITIONTAGS: System Partition TagsSYSTEMPARTITIONTAGSDataDictionary.Invantive.SYSTEMPROVIDERS: ProvidersSYSTEMPROVIDERSInvantive · SYSTEMPROVIDERSInvantive · SYSTEMSQLAREA×2DataDictionary.Invantive.JSONRECORDTYPECOLUMNS: JSON Record Type ColumnsJSONRECORDTYPECOLUMNSDataDictionary.Invantive.JSONRECORDTYPES: JSON Record TypesJSONRECORDTYPESDataDictionary.Invantive.SESSIONIOS: Session I/OsSESSIONIOSDataDictionary.Invantive.SYSTEMDATACONTAINERSSDataDictionary.Invantive.SYSTEMANONYMIZATIONMAPS: Anonymization MapsSYSTEMANONYMIZATIONMAPSDataDictionary.Invantive.SYSTEMANONYMIZATIONMAPVALUES: Anonymization Map ValuesSYSTEMANONYMIZATIONMAPVALUESDataDictionary.Invantive.SYSTEMCOUNTRIES: CountriesSYSTEMCOUNTRIESDataDictionary.Invantive.SYSTEMSQLAREA: SQL Statements ExecutedSYSTEMSQLAREADataDictionary.Invantive.SYSTEMSQLEXECUTIONS: SQL ExecutionsSYSTEMSQLEXECUTIONSDataDictionary.Invantive.SYSTEMSQLEXECUTIONSLEEPS: SQL Execution SleepsSYSTEMSQLEXECUTIONSLEEPSDataDictionary.Invantive.SYSTEMSQLEXECUTIONSTEPS: SQL Execution StepsSYSTEMSQLEXECUTIONSTEPSDataDictionary.Invantive.SYSTEMTIMEZONES: Time ZonesSYSTEMTIMEZONESInvantive · SYSTEMPROVIDERSDataDictionary.Invantive.SYSTEMPACKAGEFUNCTIONARGUMENTS: Package Function ArgumentsSYSTEMPACKAGEFUNCTIONARGUME…DataDictionary.Invantive.SYSTEMDATACONTAINERSSDataDictionary.Invantive.SYSTEMPACKAGEFUNCTIONS: Package FunctionsSYSTEMPACKAGEFUNCTIONSDataDictionary.Invantive.SYSTEMDATACONTAINERSSDataDictionary.Invantive.SYSTEMPACKAGES: PackagesSYSTEMPACKAGESDataDictionary.Invantive.SYSTEMDATACONTAINERSSDataDictionary.Invantive.SYSTEMPROVIDERATTRIBUTES: System Provider AttributesSYSTEMPROVIDERATTRIBUTESDataDictionary.Invantive.SYSTEMPROVIDERS: ProvidersSYSTEMPROVIDERSDataDictionary.Invantive.SYSTEMPROVIDERSACTIVE: Active System ProvidersSYSTEMPROVIDERSACTIVEDataDictionary.Invantive.SYSTEMDATACONTAINERSSDataDictionary.Invantive.SYSTEMPROVIDERSAMPLEQUERIES: Provider Sample QueriesSYSTEMPROVIDERSAMPLEQUERIESInvantive · SYSTEMTABLESDataDictionary.Invantive.SYSTEMTABLECOLUMNS: Table ColumnsSYSTEMTABLECOLUMNSDataDictionary.Invantive.SYSTEMDATACONTAINERSSDataDictionary.Invantive.SYSTEMTABLEFOREIGNKEYS: Foreign KeysSYSTEMTABLEFOREIGNKEYSDataDictionary.Invantive.SYSTEMDATACONTAINERSSDataDictionary.Invantive.SYSTEMTABLEFUNCTIONPARAMETERS: Table Function ParametersSYSTEMTABLEFUNCTIONPARAMETERSDataDictionary.Invantive.SYSTEMDATACONTAINERSSDataDictionary.Invantive.SYSTEMTABLEKEYS: Table KeysSYSTEMTABLEKEYSDataDictionary.Invantive.SYSTEMDATACONTAINERSSDataDictionary.Invantive.SYSTEMTABLES: TablesSYSTEMTABLESDataDictionary.Invantive.SYSTEMDATACONTAINERSSDataDictionary.Invantive.SYSTEMPROVIDERS: ProvidersSYSTEMPROVIDERSInvantive · SYSTEMPROVIDERSDataDictionary.Invantive.SYSTEMSCHEMAS: SchemasSYSTEMSCHEMASInvantive · SYSTEMSCHEMASDataDictionary.Invantive.SYSTEMDATACONTAINERSSInvantive · SYSTEMSCHEMASDataDictionary.Invantive.SYSTEMCATALOGS: CatalogsSYSTEMCATALOGSDataDictionary.Invantive.SYSTEMDATACONTAINERSSDataDictionary.Invantive.SYSTEMSCHEMAS: SchemasSYSTEMSCHEMASDataDictionary.Invantive.SYSTEMDATACONTAINERSSDataDictionary.Invantive.SYSTEMVIEWS: Database ViewsSYSTEMVIEWSDataDictionary.Invantive.SYSTEMDATACONTAINERSSDataDictionary.Invantive.SYSTEMTABLES: TablesSYSTEMTABLESInvantive · SYSTEMTABLESDataDictionary.Invantive.SYSTEMDATACONTAINERSSInvantive · SYSTEMPREEMPTIVELOAD…DataDictionary.Invantive.SYSTEMPREEMPTIVELOADCANDIDATES: Pre-emptive Load CandidatesSYSTEMPREEMPTIVELOADCANDIDAT…DataDictionary.Invantive.SYSTEMPREEMPTIVELOADHINTS: Pre-emptive Load HintsSYSTEMPREEMPTIVELOADHINTSDataDictionary.Invantive.SYSTEMPREEMPTIVELOADINGPARTITIONS: Pre-emptive Loading PartitionsSYSTEMPREEMPTIVELOADINGPARTIT…InvantiveDataDictionary.Invantive.AUDITEVENTS: Audit EventsAUDITEVENTSDataDictionary.Invantive.CALENDAR: CalendarCALENDARDataDictionary.Invantive.DOUBLE: Single RowDOUBLEDataDictionary.Invantive.DUAL: Single RowDUALDataDictionary.Invantive.EMPTY: Empty TableEMPTYDataDictionary.Invantive.HTTPDOWNLOADCOOKIESHISTORY: Download Cookies HistoryHTTPDOWNLOADCOOKIESHISTORYDataDictionary.Invantive.HTTPDOWNLOADHISTORY: HTTP Download HistoryHTTPDOWNLOADHISTORYDataDictionary.Invantive.SYSTEMANONYMIZATIONPREDEFINEDMAPS: Anonymization Predefined MapsSYSTEMANONYMIZATIONPREDEFINEDMAPSDataDictionary.Invantive.SYSTEMDATABASES: DatabasesSYSTEMDATABASESDataDictionary.Invantive.SYSTEMFUNCTIONS: System FunctionsSYSTEMFUNCTIONSDataDictionary.Invantive.SYSTEMGLOSSARIES: GlossariesSYSTEMGLOSSARIESDataDictionary.Invantive.SYSTEMGLOSSARYTERMS: Glossary TermsSYSTEMGLOSSARYTERMSDataDictionary.Invantive.SYSTEMGLOSSARYTERMTRANSLATIONS: Glossary Term TranslationsSYSTEMGLOSSARYTERMTRANSLATIONSDataDictionary.Invantive.SYSTEMLANGUAGES: LanguagesSYSTEMLANGUAGESDataDictionary.Invantive.SYSTEMLICENSEMODULES: Licence ModulesSYSTEMLICENSEMODULESDataDictionary.Invantive.SYSTEMLOCKS: LocksSYSTEMLOCKSDataDictionary.Invantive.SYSTEMLOGGINGMESSAGECOUNTERSTATISTICS: Logging Message Counter StatisticsSYSTEMLOGGINGMESSAGECOUNTERSTATISTICSDataDictionary.Invantive.SYSTEMMANAGEDFILEACTIONS: Managed File ActionsSYSTEMMANAGEDFILEACTIONSDataDictionary.Invantive.SYSTEMMANAGEDFILES: Managed FilesSYSTEMMANAGEDFILESDataDictionary.Invantive.SYSTEMPROPERTIES: System Properties and Their ValuesSYSTEMPROPERTIESDataDictionary.Invantive.SYSTEMPSQLATOMICS: PSQL Atomic ValuesSYSTEMPSQLATOMICSDataDictionary.Invantive.SYSTEMPSQLLOCKS: PSQL LocksSYSTEMPSQLLOCKSDataDictionary.Invantive.SYSTEMRECENTLOGGINGMESSAGES: Logging MessagesSYSTEMRECENTLOGGINGMESSAGESDataDictionary.Invantive.SYSTEMRELATIONANALYSISRELATIONS: Relation Analysis RelationsSYSTEMRELATIONANALYSISRELATIONSDataDictionary.Invantive.SYSTEMRELATIONANALYSISTABLES: Relation Analysis TablesSYSTEMRELATIONANALYSISTABLESDataDictionary.Invantive.SYSTEMSQLPRECOMPILEDEXPRESSIONS: SQL Pre-compiled ExpressionsSYSTEMSQLPRECOMPILEDEXPRESSIONSDataDictionary.Invantive.SYSTEMTABLECOLUMNSLIVE: Live Retrieved Table ColumnsSYSTEMTABLECOLUMNSLIVEDataDictionary.Invantive.SYSTEMTABLEFUNCTIONPARAMETERSLIVE: Live Retrieve Table Function ParametersSYSTEMTABLEFUNCTIONPARAMETERSLIVEDataDictionary.Invantive.SYSTEMTRANSLATIONS: TranslationsSYSTEMTRANSLATIONSDataDictionary.Invantive.SYSTEMUSERS: System UsersSYSTEMUSERSDataDictionary.Invantive.SYSTEMUTCOFFSETS: UTC OffsetsSYSTEMUTCOFFSETSDataDictionary.Invantive.USERMESSAGES: User MessagesUSERMESSAGESDataDictionary.Invantive.USERSETTINGS: System User SettingsUSERSETTINGSDataDictionary.Invantive.WEEKDAYS: Days of the WeekWEEKDAYSViewsDataDictionary.Views.Test0Rows10000SecTest0Rows10000SecDataDictionary.Views.Test0Rows1000SecTest0Rows1000SecDataDictionary.Views.Test0Rows100SecTest0Rows100SecDataDictionary.Views.Test1000000Rows1000Mb10000SecTest1000000Rows1000Mb10000SecDataDictionary.Views.Test1000000Rows1000Mb1000SecTest1000000Rows1000Mb1000SecDataDictionary.Views.Test1000000Rows1000Mb1SecTest1000000Rows1000Mb1SecDataDictionary.Views.Test10000Rows100Mb100SecTest10000Rows100Mb100SecDataDictionary.Views.Test1000Rows1Mb1000SecTest1000Rows1Mb1000SecDataDictionary.Views.Test100Rows1Mb100SecTest100Rows1Mb100SecDataDictionary.Views.Test10Rows1000Mb1SecTest10Rows1000Mb1SecData DictionaryFor example, the view SystemTables@DataDictionary containsevery available table and view in the current database. Besidesobject definitions also actual execution information is availablein views. For example, the viewSystemSqlArea@DataDictionary contains all executed andcached Invantive SQL statements. The data in the dataData 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.TopicsInvantive · SYSTEMDATACONTAINERS1Invantive · SYSTEMPREEMPTIVELOADCA…1Invantive · SYSTEMPROVIDERS1Invantive · SYSTEMSCHEMAS1Invantive · SYSTEMSQLAREA1Invantive · SYSTEMTABLES1Tables 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 tablesLetters: refers to a table used by most topics: S = SYSTEMDATACONTAINERSGenerated 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/datadictionary
The poster as text: tables per topic and their relations

Invantive · SYSTEMDATACONTAINERS

SESSIONROWSCHANGED, SYSTEMDATACONTAINERATTRIBUTES, SYSTEMDATACONTAINERHTTPCACHECONTENTS, SYSTEMDATACONTAINERMESSAGES, SYSTEMDATACONTAINERPROPERTIES, SYSTEMDATACONTAINERRESERVEDWORDS, SYSTEMDATACONTAINERS, SYSTEMDATACONTAINERSLOTBASEDRATELIMITERS, SYSTEMDATACONTAINERSLOTBASEDRATELIMITERSLOTS, SYSTEMDOMAINCODES, SYSTEMDOMAINCODEVALUES, SYSTEMFILTERTOTABLEFUNCTIONPARAMETERS, SYSTEMLICENSES, SYSTEMOAUTHFLOWEVENTS, SYSTEMPARTITIONS, SYSTEMPARTITIONSTATISTICS, SYSTEMPARTITIONTAGS

Invantive · SYSTEMSQLAREA

JSONRECORDTYPECOLUMNS, JSONRECORDTYPES, SESSIONIOS, SYSTEMANONYMIZATIONMAPS, SYSTEMANONYMIZATIONMAPVALUES, SYSTEMCOUNTRIES, SYSTEMSQLAREA, SYSTEMSQLEXECUTIONS, SYSTEMSQLEXECUTIONSLEEPS, SYSTEMSQLEXECUTIONSTEPS, SYSTEMTIMEZONES

Invantive · SYSTEMPROVIDERS

SYSTEMPACKAGEFUNCTIONARGUMENTS, SYSTEMPACKAGEFUNCTIONS, SYSTEMPACKAGES, SYSTEMPROVIDERATTRIBUTES, SYSTEMPROVIDERS, SYSTEMPROVIDERSACTIVE, SYSTEMPROVIDERSAMPLEQUERIES

Invantive · SYSTEMTABLES

SYSTEMTABLECOLUMNS, SYSTEMTABLEFOREIGNKEYS, SYSTEMTABLEFUNCTIONPARAMETERS, SYSTEMTABLEKEYS, SYSTEMTABLES

Invantive · SYSTEMPREEMPTIVELOADCANDIDATES

SYSTEMPREEMPTIVELOADCANDIDATES, SYSTEMPREEMPTIVELOADHINTS, SYSTEMPREEMPTIVELOADINGPARTITIONS

Invantive · SYSTEMSCHEMAS

SYSTEMCATALOGS, SYSTEMSCHEMAS, SYSTEMVIEWS

Invantive (without relations)

AUDITEVENTS, CALENDAR, DOUBLE, DUAL, EMPTY, HTTPDOWNLOADCOOKIESHISTORY, HTTPDOWNLOADHISTORY, SYSTEMANONYMIZATIONPREDEFINEDMAPS, SYSTEMDATABASES, SYSTEMFUNCTIONS, SYSTEMGLOSSARIES, SYSTEMGLOSSARYTERMS, SYSTEMGLOSSARYTERMTRANSLATIONS, SYSTEMLANGUAGES, SYSTEMLICENSEMODULES, SYSTEMLOCKS, SYSTEMLOGGINGMESSAGECOUNTERSTATISTICS, SYSTEMMANAGEDFILEACTIONS, SYSTEMMANAGEDFILES, SYSTEMPROPERTIES, SYSTEMPSQLATOMICS, SYSTEMPSQLLOCKS, SYSTEMRECENTLOGGINGMESSAGES, SYSTEMRELATIONANALYSISRELATIONS, SYSTEMRELATIONANALYSISTABLES, SYSTEMSQLPRECOMPILEDEXPRESSIONS, SYSTEMTABLECOLUMNSLIVE, SYSTEMTABLEFUNCTIONPARAMETERSLIVE, SYSTEMTRANSLATIONS, SYSTEMUSERS, SYSTEMUTCOFFSETS, USERMESSAGES, USERSETTINGS, WEEKDAYS

Views (without relations)

Test0Rows10000Sec, Test0Rows1000Sec, Test0Rows100Sec, Test1000000Rows1000Mb10000Sec, Test1000000Rows1000Mb1000Sec, Test1000000Rows1000Mb1Sec, Test10000Rows100Mb100Sec, Test1000Rows1Mb1000Sec, Test100Rows1Mb100Sec, Test10Rows1000Mb1Sec

Relations

Tables

DataDictionary.Invantive

DataDictionary.Views

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: