invantive documentation
Invantive Support ForumsLog In / Sign Up

SQL Server Data Model

Microsoft SQL Server is a traditional database platform. SQL Server supports ANSI SQL. It is available both as a cloud database on Microsoft Azure as a traditional database running on-premise or hosted.

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

Figures

Figure Count
Tables 54
Columns 616
Tables with insert 29
Tables with update 28
Tables with delete 28
Tables documented 1

Data Model Poster

This data model declares no keys yet; the dotted relations are derived from column names.

PDF, 1 A0 sheet

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

SQL Server data model, Sheet 1 of 1SQL Server data modelfor use with Invantive UniversalSQLRelease - · 01-11-2026Tables without relationsSheet 1 of 1 · documentation.invantive.euInvantiveDatabase.Invantive.Collections: Metadata CollectionsCollectionsDatabase.Invantive.DataSourceInformation: Data Source InformationDataSourceInformationDatabase.Invantive.DataTypes: Data TypesDataTypesDatabase.Invantive.PooledConnections: Pooled ConnectionsPooledConnectionsDatabase.Invantive.Restrictions: RestrictionsRestrictionsNativeDatabase.Native.NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar RequestsNATIVEPLATFORMSCALARREQUESTSmaster dbomaster.dbo.spt_fallback_dbspt_fallback_dbmaster.dbo.spt_fallback_devspt_fallback_devmaster.dbo.spt_fallback_usgspt_fallback_usgmaster.dbo.spt_monitorspt_monitormaster.dbo.spt_valuesspt_valuesmsdb dbomsdb.dbo.autoadmin_backup_configuration_summaryautoadmin_backup_configuration_summarymsdb.dbo.backupfilebackupfilemsdb.dbo.backupmediafamilybackupmediafamilymsdb.dbo.backupmediasetbackupmediasetmsdb.dbo.backupsetbackupsetmsdb.dbo.dm_hadr_automatic_seeding_historydm_hadr_automatic_seeding_historymsdb.dbo.logmarkhistorylogmarkhistorymsdb.dbo.restorefilerestorefilemsdb.dbo.restorefilegrouprestorefilegroupmsdb.dbo.restorehistoryrestorehistorymsdb.dbo.suspect_pagessuspect_pagesmsdb.dbo.sysdac_instancessysdac_instancesmsdb.dbo.syspolicy_conditionssyspolicy_conditionsmsdb.dbo.syspolicy_configurationsyspolicy_configurationmsdb.dbo.syspolicy_object_setssyspolicy_object_setsmsdb.dbo.syspolicy_policiessyspolicy_policiesmsdb.dbo.syspolicy_policy_categoriessyspolicy_policy_categoriesmsdb.dbo.syspolicy_policy_category_subscriptionssyspolicy_policy_category_subscriptionsmsdb.dbo.syspolicy_policy_execution_historysyspolicy_policy_execution_historymsdb.dbo.syspolicy_policy_execution_history_detailssyspolicy_policy_execution_history_detailsmsdb.dbo.syspolicy_system_health_statesyspolicy_system_health_statemsdb.dbo.syspolicy_target_set_levelssyspolicy_target_set_levelsmsdb.dbo.syspolicy_target_setssyspolicy_target_setsSQL ServerNotesThis data model declares no keys yet; the dotted relations are derived from column names.Data 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.Notes20 objects of technical metadata are left out.TopicsTables 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 relations between the same tablesGenerated from the metadata of Invantive UniversalSQL - on 01-11-2026. Every table links to its page withcolumns, keys and sample queries.documentation.invantive.eu/en/datamodels/sqlserver
The poster as text: tables per topic and their relations

Invantive (without relations)

Collections, DataSourceInformation, DataTypes, PooledConnections, Restrictions

Native (without relations)

NATIVEPLATFORMSCALARREQUESTS

master dbo (without relations)

spt_fallback_db, spt_fallback_dev, spt_fallback_usg, spt_monitor, spt_values

msdb dbo (without relations)

autoadmin_backup_configuration_summary, backupfile, backupmediafamily, backupmediaset, backupset, dm_hadr_automatic_seeding_history, logmarkhistory, restorefile, restorefilegroup, restorehistory, suspect_pages, sysdac_instances, syspolicy_conditions, syspolicy_configuration, syspolicy_object_sets, syspolicy_policies, syspolicy_policy_categories, syspolicy_policy_category_subscriptions, syspolicy_policy_execution_history, syspolicy_policy_execution_history_details, syspolicy_system_health_state, syspolicy_target_set_levels, syspolicy_target_sets

Tables

Database.Invantive

Database.Metadata

Database.Native

master.dbo

msdb.dbo

Attributes

The attributes of this platform are on the page Attributes.