invantive documentation
Invantive Support ForumsLog In / Sign Up

Horeko Data Model

Set up this platform in Invantive Cloud: https://cloud.invantive.com/horeko

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.
  • Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.

Figures

Figure Count
Tables 206
Columns 3,425

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.

Horeko data model, Sheet 1 of 1Horeko data modelfor use with Invantive UniversalSQLRelease 24.0.729-PROD+5447 · 11-06-2025OtherSheet 1 of 1 · documentation.invantive.euOtherHoreko.Clocking.MyClockingStateBreaks: My Clocking State BreaksMyClockingStateBreaksHoreko.Department.Departments: DepartmentsDepartmentsHoreko.Meal.Meals: MealsMealsHoreko.Views.TodaysShifts: Todays ShiftsTodaysShiftsAccountHoreko.Account.AccountCheckOeiUserPopupOptions: itgen_horeko_accountcheckoeiuserpopupoptions_pluralAccountCheckOeiUserPopupOptionsHoreko.Account.AccountGetOeiUserInfo: itgen_horeko_accountgetoeiuserinfo_pluralAccountGetOeiUserInfoAnalyticHoreko.Analytics.Analytics: AnalyticsAnalyticsBoughtHoreko.Permissions.BoughtProductPermissions: Bought Product PermissionsBoughtProductPermissionsCompanyHoreko.DocumentManagement.CompanyEntryTypes: Company Entry TypesCompanyEntryTypesContractHoreko.Contracts.ContractTypes: Contract TypesContractTypesCustomHoreko.Unavailability.CustomUnavailabilities: Custom UnavailabilitiesCustomUnavailabilitiesDepartmentHoreko.Department.DepartmentsBasic: Departments (basic)DepartmentsBasicDishHoreko.Views.DishAllergans: Dish AllergensDishAllergansHoreko.Views.DishFinancialCalculations: Dish Financial CalculationsDishFinancialCalculationsHoreko.Views.DishFinancialStates: Dish Financial StatesDishFinancialStatesHoreko.Views.DishNutrientMarkQualityMarks: Dish Nutrient Quality MarksDishNutrientMarkQualityMarksEmployeeHoreko.Views.EmployeeDepartments: Employee DepartmentsEmployeeDepartmentsHoreko.Employee.EmployeeOptions: Employee OptionsEmployeeOptionsHealthHoreko.HealthController.Health: itgen_horeko_health_pluralHealthIngredientHoreko.Views.IngredientAllergans: Ingredient AllergansIngredientAllergansHoreko.Views.IngredientNutrients: Ingredient NutrientsIngredientNutrientsHoreko.Views.IngredientQualityMarkMutrients: Ingredient Quality Mark NutrientsIngredientQualityMarkMutrientsManagerHoreko.Statistics.ManagerDishTypes: Dish Types (Manager)ManagerDishTypesHoreko.Views.ManagerIngredientMutations: Manager Ingredient MutationsManagerIngredientMutationsHoreko.Statistics.ManagerSuppliers: Suppliers (Manager)ManagerSuppliersMenubuffetHoreko.Menubuffet.MenubuffetTemplateComponents: Menubuffet Template ComponentsMenubuffetTemplateComponentsHoreko.Menubuffet.MenubuffetTemplates: Menubuffet TemplatesMenubuffetTemplatesMobileHoreko.MobileSettings.MobileSettings: Mobile SettingsMobileSettingsMobilesettingHoreko.MobileSettings.MobilesettingsGetMobileAppVersions: itgen_horeko_mobilesettingsgetmobileappversions_pluralMobilesettingsGetMobileAppVersionsMyHoreko.Contracts.MyActiveContractToday: My Active Contract TodayMyActiveContractTodayHoreko.Clocking.MyClockingState: My Clocking StateMyClockingStateHoreko.Statistics.MyPlusMinuses: My Plus/MinusesMyPlusMinusesHoreko.Clocking.MyShifts: My ShiftsMyShiftsHoreko.UndeterminedShift.MyUndeterminedShiftRequests: My Undetermined Shift RequestsMyUndeterminedShiftRequestsHoreko.Statistics.MyVacations: My VacationsMyVacationsNATIVEPLATFORMSCALARREQUESTSHoreko.Native.NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar RequestsNATIVEPLATFORMSCALARREQUESTSPermissionHoreko.Permissions.Permissions: PermissionsPermissionsPersonalHoreko.DocumentManagement.PersonalEntryTypes: Personal Entry TypesPersonalEntryTypesPredefinedHoreko.Unavailability.PredefinedUnavailabilities: Predefined UnavailabilitiesPredefinedUnavailabilitiesRecipeHoreko.Views.RecipeFolders: Recipe FoldersRecipeFoldersRequestHoreko.Request.RequestsOverview: Requests OverviewRequestsOverviewRosterHoreko.Roster.RosterDepartments: itgen_horeko_rosterdepartments_pluralRosterDepartmentsHoreko.Roster.RosterFeeds: itgen_horeko_rosterfeeds_pluralRosterFeedsHoreko.Roster.Roster_DataSelectionFeeds: itgen_horeko_roster_dataselectionfeeds_pluralRoster_DataSelectionFeedsShiftHoreko.ShiftLocation.ShiftLocations: Shift LocationsShiftLocationsShifttradeHoreko.ShiftTrade.ShifttradesManagerOverview: itgen_horeko_shifttradesmanageroverview_pluralShifttradesManagerOverviewHoreko.ShiftTrade.ShifttradesManager_AcceptedEmployeesAcceptedEmployeesImagesOverview: itgen_horeko_shifttradesmanager_acceptedemployeesacceptedemployeesimagesoverview_pluralShifttradesManager_AcceptedEmployeesAcceptedE…UserlocationHoreko.Location.Userlocations: User LocationsUserlocationsHorekoNotesThis 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.TopicsOther1Tables 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 24.0.729-PROD+5447 on 11-06-2025. Every table links toits page with columns, keys and sample queries.documentation.invantive.eu/en/datamodels/horeko
The poster as text: tables per topic and their relations

Other

MyClockingStateBreaks, Departments, Meals, TodaysShifts

Account (without relations)

AccountCheckOeiUserPopupOptions, AccountGetOeiUserInfo

Analytic (without relations)

Analytics

Bought (without relations)

BoughtProductPermissions

Company (without relations)

CompanyEntryTypes

Contract (without relations)

ContractTypes

Custom (without relations)

CustomUnavailabilities

Department (without relations)

DepartmentsBasic

Dish (without relations)

DishAllergans, DishFinancialCalculations, DishFinancialStates, DishNutrientMarkQualityMarks

Employee (without relations)

EmployeeDepartments, EmployeeOptions

Health (without relations)

Health

Ingredient (without relations)

IngredientAllergans, IngredientNutrients, IngredientQualityMarkMutrients

Manager (without relations)

ManagerDishTypes, ManagerIngredientMutations, ManagerSuppliers

Menubuffet (without relations)

MenubuffetTemplateComponents, MenubuffetTemplates

Mobile (without relations)

MobileSettings

Mobilesetting (without relations)

MobilesettingsGetMobileAppVersions

My (without relations)

MyActiveContractToday, MyClockingState, MyPlusMinuses, MyShifts, MyUndeterminedShiftRequests, MyVacations

NATIVEPLATFORMSCALARREQUESTS (without relations)

NATIVEPLATFORMSCALARREQUESTS

Permission (without relations)

Permissions

Personal (without relations)

PersonalEntryTypes

Predefined (without relations)

PredefinedUnavailabilities

Recipe (without relations)

RecipeFolders

Request (without relations)

RequestsOverview

Roster (without relations)

RosterDepartments, RosterFeeds, Roster_DataSelectionFeeds

Shift (without relations)

ShiftLocations

Shifttrade (without relations)

ShifttradesManagerOverview, ShifttradesManager_AcceptedEmployeesAcceptedEmployeesImagesOverview

Userlocation (without relations)

Userlocations

Relations

Tables

Horeko.Account

Horeko.Analytics

Horeko.Availability

Horeko.Clocking

Horeko.Contracts

Horeko.Department

Horeko.Dish

Horeko.DocumentManagement

Horeko.Documents

Horeko.Employee

Horeko.Export

Horeko.File

Horeko.HealthController

  • Health: itgen_horeko_health_plural

Horeko.Hours

Horeko.Ingredient

Horeko.Location

Horeko.Meal

Horeko.Menubuffet

Horeko.MobileSettings

Horeko.Native

Horeko.Newsletter

Horeko.Permissions

Horeko.Recipefolders

Horeko.Request

Horeko.Roster

Horeko.Sale

Horeko.ShiftLocation

Horeko.ShiftTrade

Horeko.Shifts

Horeko.Statistics

Horeko.Stock

Horeko.Subrecipe

Horeko.Team

Horeko.Unavailability

Horeko.UndeterminedShift

Horeko.Views

Horeko.Waste

Attributes

The attributes of this platform are on the page Attributes.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: