Data schema

Quotations

QuotationFooter

Represents a Quotation overview (e.g., the total price), without detailing each item.

Quotation Group

Represents a group of items within a Quotation.

Quotation

Represents a quotation.

QuotationDiscountLine

Represents a discount line included in a Quotation or QuotationGroup.

Quotation Files

Represents an uploaded file related to a Quotation.

QuotationLine

Represents a single line item in a QuotationGroup.

QuotationPropertyValue

Holds the custom property value for a Quotation.

Configuration models

FeatureModelEditorModel

Represents the feature model used on the configuration model editor page.

FeatureModel

Represents a complete feature model.

FeatureModelNode

Represents a node within a feature model.

FeatureModelRelationship

Represents the relationships between different feature model nodes. Used for structural relationships (mandatory, optional, etc.),cross tree (requires, excludes) and calculated values.

FeatureModelRelationshipCondition

Represents a condition or filter relationship on a feature model node.

LinkedFeatureModel

Represents a connection between a parent and child feature model.

TextExpresssion

An expression used to calculate a text value for a FeatureModelNode.

Expression

Represents a formula within a FeatureModel.

FeatureModelDynamicGroup

Represents a dynamic group within a FeatureModel.

General

AuditTrail

Used by the system to track all changes for every entity in Elfsquad.

FileEntity

Represents a file stored within Elfsquad.

Notification

Represents a system notification.

Features

Category

Represents a category that can be assigned to features.

CategoryText

Holds the translated names for a category.

Feature

Represents a feature.

FeatureText

Stores translated descriptions, extended descriptions, more info's, and Quotation texts for a Feature.

UnitOfMeasurement

Represents a unit of measurement for Features.

UnitOfMeasurementText

Holds the translated names for the UnitOfMeasurement entity.

VAT

Represents a VAT entry for calculating tax on a Quotation.

Configuring

Configuration

Represents a configuration.

Step editor

ConfiguratorImage

Represents an image used in a 2D visualization step.

FeatureModelAttachmentNode

Represents an attachment node within a 3D step in a feature model.

CameraPosition

Specifies the camera position for a 3D step.

Hotspot

Step

Represents a step within a configuration model.

StepText

Holds the translated texts for a Step.

Localization

Country

Represents a country.

Currency

Represents a currency.

ExchangeRate

Stores the exchange rate between different currencies.

Language

Represents a language.

Translations

Used to define custom translations shown in EMS or the showroom.

CRM accounts

CrmAccount

Represents a CRM account

CrmContact

Represents a CRM contact associated with a CrmAccount.

CrmDiscountLine

Represents a default discount line in CRM, automatically added to a Quotation.

CrmShare

Defines which organizations share CRM data among themselves.

CrmAccountPropertyValue

Holds the custom property value for a specific CrmAccount.

Feature properties

FeatureProperty

Defines a custom property for features.

AssociatedFeatureProperty

Specifies which features are linked to a particular feature property of type 'Associated feature'

FeatureHasFeatureProperty

Stores the value of a custom FeatureProperty for a particular Feature.

Home

NewsItem

Represents a news item displayed on the EMS home page.

Organization

Organization

Represents an organization.

OrganizationSellsFeature

Defines whether an Organization can configure a specific Feature.

OrganizationSellsFeatureModel

Defines whether an Organization can configure a particular FeatureModel.

Custom properties

Quotation Property

Defines a custom property specifically for a Quotation.

CrmAccountProperty

Defines a custom property for a CrmAccount.

EntityPropertyText

This entity stores translated names for both QuotationProperty and CrmAccountProperty.

Quotation workflow

QuotationStatus

Represents a custom QuotationStatus.

Quotation templates

QuotationTemplate

Represents a template used to generate Quotation documents.

QuotationTemplateOrganization

Defines whether an Organization can use a specific QuotationTemplate.

Integrations

Script

Represents a custom script that can be triggered by a custom button.

IntegrationApplication

Represents a third-party integration application.

CustomButtonTrigger

Represents a custom button within the system.

Settings

Settings

Represents EMS tenant or organization-wide settings.

Showrooms

ShowroomSettings

Represents the settings for a specific showroom.

Users

Role

Represents a user role.

User

UserHasAccessToSuborganization

Specifies which sub-organizations a (non-admin) user can access.