invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

Data Dictionary Data Model

De Invantive UniversalSQL data dictionary bevat de metadata van uw huidige omgeving.

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.

Bij tekstvergelijkingen op dit platform wordt onderscheid gemaakt tussen hoofdletters en kleine letters.

Platform

  • Te gebruiken vanuit: Invantive Cloud en de Invantive-producten op uw eigen computer of server.
  • Type: een applicatie die via de API toegankelijk is.
  • De gegevens zijn onderverdeeld, bijvoorbeeld per bedrijf of per overheidsinstantie.
  • Met één Query kunnen meerdere bedrijven tegelijk worden opgehaald.
  • Invantive Cloud plans: Free for public data, Free, Office for Entrepreneurs, Office for Accountants, Premium Finance.

Cijfers

Figure Count
Tables 94
Columns 2,195
Tabeller med invoegsel 2
Tabeller med update 1
Tabellen met de functie 'verwijderen' 1
Tabeller gedocumenteerd 5

Poster met datamodel

PDF, 1 A0-vel

Op een tabel op de poster: in- en uitzoomen, verplaatsen met de pijltjestoetsen, 0 past.

Data Dictionary Datamodel, Pagina 1 van 1Data Dictionary Datamodelvoor gebruik met Invantive UniversalSQLPersbericht 27.1.3-BETA+6294 · 01-11-2026Invantive · SYSTEMDATACONTAINERS · Invantive · SYSTEMSQLAREA · Invantive · SYSTEMPROVIDERS · Invantive · SYSTEMTABLES · Invantive · SYSTEMSCHEMAS · Inva…Pagina 1 van 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 DictionaryElke tabel en kolom van dit datamodel wordt beschreven in de bijbehorende documentatie opdocumentation.invantive.eu, waar de poster ook in andere talen beschikbaar is.NotitiesDe boxen zijn gegroepeerd per onderwerp en gekleurd per categorie. In het onderwerp van detabel waarin de sleutel staat, wordt een relatie aangegeven; in een ander onderwerp wordt eenlichtgrijs box gedefinieerd.OnderwerpenInvantive · SYSTEMDATACONTAINERS1Invantive · SYSTEMPREEMPTIVELOADCA…1Invantive · SYSTEMPROVIDERS1Invantive · SYSTEMSCHEMAS1Invantive · SYSTEMSQLAREA1Invantive · SYSTEMTABLES1Tabeller uden relationen1LegendaTransactioneelInrichtingTechnischVastgelegde waardenUitgelegd in een ander onderwerpVerklaarde sleutelDe relatie in woorden beschrevenKandidaat afgeleid van kolomnamenVetgedrukt: een populaire tabel+Bulk, +Lezen: de tabel bestaat ook in deze varianten\u00D7n: n toetsen tussen dezelfde tabellenBrieven: verwijst naar een tabel die bij de meeste onderwerpen wordt gebruikt: S =SYSTEMDATACONTAINERSGegenereerd op basis van de metagegevens van Invantive UniversalSQL 27.1.3-BETA+6294 op 01-11-2026. Elketabel bevat een link naar de bijbehorende pagina met kolommen, sleutels en voorbeeldquery's.documentation.invantive.eu/nl/datamodels/datadictionary
De poster als tekst: tabellen per onderwerp en hun onderlinge verbanden

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 (zonder relaties)

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 (zonder relaties)

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

Relaties

Tabellen

DataDictionary.Invantive

DataDictionary.Views

Attributen

The attributes of this platform are on the page Attributes.

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: