invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

Data Dictionary Data Model

El diccionario de datos Invantive UniversalSQL contiene los metadatos de su entorno actual.

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.

Las comparaciones de texto en esta plataforma distinguen entre mayúsculas y minúsculas.

Plataforma

  • Se utiliza desde: Invantive Cloud y los productos de Invantive instalados en tu propio ordenador o servidor.
  • Tipo: una aplicación a la que se accede a través de su API.
  • Los datos se agrupan por categorías, como por empresa o por administración.
  • Una Query puede leer varios datos de empresas a la vez.
  • Invantive Cloud plans: Free for public data, Free, Office for Entrepreneurs, Office for Accountants, Premium Finance.

Cifras

Figure Count
Tables 94
Columns 2,195
Tablas con inserciones 2
Tablas con actualización 1
Tablas con la instrucción «DELETE» 1
Tablas documentadas 5

Póster del Modelo de Datos

PDF, hoja A0 1

En una tabla del póster: Zoom para ampliar y reducir; las teclas de flecha sirven para desplazarse; el 0 ajusta la imagen.

Data Dictionary Modelo de Datos, Hoja 1 de 1Data Dictionary Modelo de Datospara su uso con Invantive UniversalSQLComunicado 27.1.3-BETA+6294 · 01-11-2026Invantive · SYSTEMDATACONTAINERS · Invantive · SYSTEMSQLAREA · Invantive · SYSTEMPROVIDERS · Invantive · SYSTEMTABLES · Invantive · SYSTEMS…Hoja 1 de 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 WeekWEEKDAYSVistasDataDictionary.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 dataDiccionario de datosCada tabla y columna de este Modelo de Datos se describe en su documentación, disponible endocumentation.invantive.eu, donde el documento también está disponible en otros idiomas.NotasLas cajas están agrupadas por tema y se distinguen por colores según la categoría. Se estableceuna relación en el tema de la tabla que contiene la clave; en otro tema se define un Box de colorgris pálido.TemasInvantive · SYSTEMDATACONTAINERS1Invantive · SYSTEMPREEMPTIVELOADCA…1Invantive · SYSTEMPROVIDERS1Invantive · SYSTEMSCHEMAS1Invantive · SYSTEMSQLAREA1Invantive · SYSTEMTABLES1Tablas sin relaciones1LeyendaTransaccionalConfiguraciónTécnicoValores fijosSe explica en otro temaClave declaradaRelación descrita con palabrasCandidato derivado de los nombres de las columnasNegrita: una tabla muy popular+Bulk, +Read: la tabla también existe en estas variantes\u00D7n: n claves entre las mismas tablasLetras: se refiere a una tabla que se utiliza en la mayoría de los temas: S = SYSTEMDATACONTAINERSGenerado a partir de los metadatos de Invantive UniversalSQL 27.1.3-BETA+6294 el 01-11-2026. Cada tablaincluye un enlace a su página, donde se muestran las columnas, las claves y ejemplos de queries.documentation.invantive.eu/es/datamodels/datadictionary
El póster en forma de texto: tablas por tema y sus relaciones

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 (sin relaciones)

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

Vistas (sin relaciones)

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

Relaciones

Tablas

DataDictionary.Invantive

DataDictionary.Views

Atributos

The attributes of this platform are on the page Attributes.

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: