invantive documentation
Invantive Support ForumsLog In / Sign Up

EZ-Base Data Model

Product catalog.

Text comparisons on this platform are case sensitive.

Platform

  • Used from: the Invantive products on your own computer or server.
  • Kind: files.
  • Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance.

Figures

Figure Count
Tables 42
Columns 1,897
Tables with insert 0
Tables with update 0
Tables with delete 0
Tables documented 0

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.

EZ-Base data model, Sheet 1 of 1EZ-Base data modelfor use with Invantive UniversalSQLRelease - · 01-11-2026Tables without relationsSheet 1 of 1 · documentation.invantive.euEZBase..WebshopArticleGroupArticleAssets: Webshop Article Group Article AssetsWebshopArticleGroupArticleAssetsEZBase..WebshopArticleGroupArticleEtimFeatureValues: Webshop Article Group Article ETIM Feature ValuesWebshopArticleGroupArticleEtimFeatureValuesEZBase..WebshopArticleGroupArticleEtimFeatures: Webshop Article Group Article ETIM FeaturesWebshopArticleGroupArticleEtimFeaturesEZBase..WebshopArticleGroupArticleNormalizedProperties: Webshop Article Group Article Normalized PropertiesWebshopArticleGroupArticleNormalizedPropertiesEZBase..WebshopArticleGroupArticleNormalizedPropertyValues: Webshop Article Group Article Normalized Property ValuesWebshopArticleGroupArticleNormalizedPropertyVal…EZBase..WebshopArticleGroupArticleOwnFreeFields: Webshop Article Group Article Own Free FieldsWebshopArticleGroupArticleOwnFreeFieldsEZBase..WebshopArticleGroupArticleOwnPersonalProperties: Webshop Article Group Article Own Personal PropertiesWebshopArticleGroupArticleOwnPersonalPropertiesEZBase..WebshopArticleGroupArticleOwnRelatedArticles: Webshop Article Group Article Own Related ArticlesWebshopArticleGroupArticleOwnRelatedArticlesEZBase..WebshopArticleGroupArticleOwnSelections: Webshop Article Group Article Own SelectionsWebshopArticleGroupArticleOwnSelectionsEZBase..WebshopArticleGroupArticleOwnSynonyms: Webshop Article Group Article Own SynonymsWebshopArticleGroupArticleOwnSynonymsEZBase..WebshopArticleGroupArticleProductDetailPrices: Webshop Article Group Article PricesWebshopArticleGroupArticleProductDetailPricesEZBase..WebshopArticleGroupArticleRelatedArticles: Webshop Article Group Article Related ArticlesWebshopArticleGroupArticleRelatedArticlesEZBase..WebshopArticleGroupArticleSupplierPropertyAssets: Webshop Article Group Article Supplier Property AssetsWebshopArticleGroupArticleSupplierPropertyAssetsEZBase..WebshopArticleGroupArticleSupplierPropertyValues: Webshop Article Group Article Supplier Property ValuesWebshopArticleGroupArticleSupplierPropertyValuesEZBase..WebshopArticleGroupArticleTablePropertyAssets: Webshop Article Group Article Table Property AssetsWebshopArticleGroupArticleTablePropertyAssetsEZBase..WebshopArticleGroupArticleTablePropertyValues: Webshop Article Group Article Table Property ValuesWebshopArticleGroupArticleTablePropertyValuesEZBase..WebshopArticleGroupArticles: Webshop Article Group ArticlesWebshopArticleGroupArticlesEZBase..WebshopArticleGroupAssets: Webshop Article Group AssetsWebshopArticleGroupAssetsEZBase..WebshopArticleGroupBluePencilDataTableAssets: Webshop Article Group Edit Data Table AssetsWebshopArticleGroupBluePencilDataTableAssetsEZBase..WebshopArticleGroupBluePencilDataTableGroupHeaders: Webshop Article Group Edit Data Table Grouped HeadersWebshopArticleGroupBluePencilDataTableGroupHe…EZBase..WebshopArticleGroupBluePencilDataTableHeaders: Webshop Article Group Edit Data Table HeadersWebshopArticleGroupBluePencilDataTableHeadersEZBase..WebshopArticleGroupClassifications: Webshop Article Group ClassificationsWebshopArticleGroupClassificationsEZBase..WebshopArticleGroupNormalizedHeaders: Webshop Article Group Normalized HeadersWebshopArticleGroupNormalizedHeadersEZBase..WebshopArticleGroupSpecificationProperties: Webshop Article Group Specification PropertiesWebshopArticleGroupSpecificationPropertiesEZBase..WebshopArticleGroupSpecifications: Webshop Article Group SpecificationsWebshopArticleGroupSpecificationsEZBase..WebshopArticleGroupSubGroups: Webshop Article Group Sub GroupsWebshopArticleGroupSubGroupsEZBase..WebshopArticleGroupSupplierHeaderAssets: Webshop Article Group Supplier Header AssetsWebshopArticleGroupSupplierHeaderAssetsEZBase..WebshopArticleGroupSupplierHeaders: Webshop Article Group Supplier HeadersWebshopArticleGroupSupplierHeadersEZBase..WebshopArticleGroups: Webshop Article GroupsWebshopArticleGroupsEZBase..WebshopAssetCategories: Webshop Asset CategoriesWebshopAssetCategoriesEZBase..WebshopClassificationNodeAssets: Webshop Classification Node AssetsWebshopClassificationNodeAssetsEZBase..WebshopClassificationNodePersonalHeaders: Webshop Classification Node Personal HeadersWebshopClassificationNodePersonalHeadersEZBase..WebshopClassificationNodeSynonyms: Webshop Classification Node SynonymsWebshopClassificationNodeSynonymsEZBase..WebshopClassificationNodes: Webshop Classification NodesWebshopClassificationNodesEZBase..WebshopClassifications: Webshop ClassificationsWebshopClassificationsEZBase..WebshopEtimGroupClassFeatures: Webshop ETIM Group Class FeaturesWebshopEtimGroupClassFeaturesEZBase..WebshopEtimGroupClassSynonyms: Webshop ETIM Group Class SynonymsWebshopEtimGroupClassSynonymsEZBase..WebshopEtimGroupClasses: Webshop ETIM Group ClassesWebshopEtimGroupClassesEZBase..WebshopEtimGroups: Webshop ETIM GroupsWebshopEtimGroupsEZBase..Webshops: WebshopsWebshopsCodeValuesEZBase.CodeValues.Acronyms: Domain AcronymsAcronymsEZBase.CodeValues.EtimFeatureTypes: Domain EtimFeatureTypesEtimFeatureTypesEZ-BaseNotesThis 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.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 keys 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/ezbase
The poster as text: tables per topic and their relations

(without relations)

WebshopArticleGroupArticleAssets, WebshopArticleGroupArticleEtimFeatureValues, WebshopArticleGroupArticleEtimFeatures, WebshopArticleGroupArticleNormalizedProperties, WebshopArticleGroupArticleNormalizedPropertyValues, WebshopArticleGroupArticleOwnFreeFields, WebshopArticleGroupArticleOwnPersonalProperties, WebshopArticleGroupArticleOwnRelatedArticles, WebshopArticleGroupArticleOwnSelections, WebshopArticleGroupArticleOwnSynonyms, WebshopArticleGroupArticleProductDetailPrices, WebshopArticleGroupArticleRelatedArticles, WebshopArticleGroupArticleSupplierPropertyAssets, WebshopArticleGroupArticleSupplierPropertyValues, WebshopArticleGroupArticleTablePropertyAssets, WebshopArticleGroupArticleTablePropertyValues, WebshopArticleGroupArticles, WebshopArticleGroupAssets, WebshopArticleGroupBluePencilDataTableAssets, WebshopArticleGroupBluePencilDataTableGroupHeaders, WebshopArticleGroupBluePencilDataTableHeaders, WebshopArticleGroupClassifications, WebshopArticleGroupNormalizedHeaders, WebshopArticleGroupSpecificationProperties, WebshopArticleGroupSpecifications, WebshopArticleGroupSubGroups, WebshopArticleGroupSupplierHeaderAssets, WebshopArticleGroupSupplierHeaders, WebshopArticleGroups, WebshopAssetCategories, WebshopClassificationNodeAssets, WebshopClassificationNodePersonalHeaders, WebshopClassificationNodeSynonyms, WebshopClassificationNodes, WebshopClassifications, WebshopEtimGroupClassFeatures, WebshopEtimGroupClassSynonyms, WebshopEtimGroupClasses, WebshopEtimGroups, Webshops

CodeValues (without relations)

Acronyms, EtimFeatureTypes

Tables

EZBase.

EZBase.CodeValues

Attributes

The attributes of this platform are on the page Attributes.