Horeko Data Model
Stel dit platform in Invantive Cloud in: https://cloud.invantive.com/horeko
Bij tekstvergelijkingen op dit platform wordt onderscheid gemaakt tussen hoofdletters en kleine letters.
Platform
- Te gebruiken vanuit: Invantive Cloud en de Invantive-producten op uw eigen computer of server.
- Type: een applicatie die via de API toegankelijk is.
- De gegevens zijn onderverdeeld, bijvoorbeeld per bedrijf of per overheidsinstantie.
- Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
Cijfers
| Figure | Count |
|---|---|
| Tables | 206 |
| Columns | 3,425 |
Poster met datamodel
In dit datamodel zijn nog geen sleutels gedefinieerd; de met punten gescheiden relaties worden afgeleid uit de namen van de kolommen.
Op een tabel op de poster: in- en uitzoomen, verplaatsen met de pijltjestoetsen, 0 past.
De poster als tekst: tabellen per onderwerp en hun onderlinge verbanden
Overige
MyClockingStateBreaks, Departments, Meals, TodaysShifts
Account (zonder relaties)
AccountCheckOeiUserPopupOptions, AccountGetOeiUserInfo
Analytic (zonder relaties)
Bought (zonder relaties)
Bedrijf (zonder relaties)
Contract (zonder relaties)
Aangepast (zonder relaties)
Afdeling (zonder relaties)
Dish (zonder relaties)
DishAllergans, DishFinancialCalculations, DishFinancialStates, DishNutrientMarkQualityMarks
Medewerker (zonder relaties)
EmployeeDepartments, EmployeeOptions
Gezondheid (zonder relaties)
Ingredient (zonder relaties)
IngredientAllergans, IngredientNutrients, IngredientQualityMarkMutrients
Manager (zonder relaties)
ManagerDishTypes, ManagerIngredientMutations, ManagerSuppliers
Menubuffet (zonder relaties)
MenubuffetTemplateComponents, MenubuffetTemplates
Mobiel (zonder relaties)
Mobilesetting (zonder relaties)
MobilesettingsGetMobileAppVersions
My (zonder relaties)
MyActiveContractToday, MyClockingState, MyPlusMinuses, MyShifts, MyUndeterminedShiftRequests, MyVacations
NATIVEPLATFORMSCALARREQUESTS (zonder relaties)
Toestemming (zonder relaties)
Personal (zonder relaties)
Predefined (zonder relaties)
Recept (zonder relaties)
Verzoek (zonder relaties)
Roster (zonder relaties)
RosterDepartments, RosterFeeds, Roster_DataSelectionFeeds
Dienst (zonder relaties)
Shifttrade (zonder relaties)
ShifttradesManagerOverview, ShifttradesManager_AcceptedEmployeesAcceptedEmployeesImagesOverview
Userlocation (zonder relaties)
Relaties
- MyClockingStateBreaks → Meals (kandidaat): Derived from the column Meal_Id.
- TodaysShifts → Departments (kandidaat): Derived from the column DepartmentId.
Tabellen
Horeko.Account
- AccountCheckOeiUserPopupOptions: itgen_horeko_accountcheckoeiuserpopupoptions_plural
- AccountCheckOeiUserStatus: itgen_horeko_accountcheckoeiuserstatus_plural
- AccountGetOeiUserInfo: itgen_horeko_accountgetoeiuserinfo_plural
Horeko.Analytics
- Analytics: Analytics
Horeko.Availability
- AvailabilitiesBlockavailability: itgen_horeko_availabilitiesblockavailability_plural
- AvailabilitiesMyavailabilities_RecurrenceDetailsWeeklyRecurrenceDaysOfWeekById: itgen_horeko_availabilitiesmyavailabilities_recurrencedetailsweeklyrecurrencedaysofweekbyid_plural
- MyAvailabilitiesByID: My Availabilities by ID
- MyAvalabilities: My Avalabilities
Horeko.Clocking
- ClockingStateByHourID: Clocking State by Hour ID
- MyClockingState: My Clocking State
- MyClockingStateBreaks: My Clocking State Breaks
- MyClockingStateBreaksByHourID: My Clocking State Breaks by Hour ID
- MyHours: My Hours
- MyShifts: My Shifts
- TodaysShiftsByStatus: Todays Shifts by Status
Horeko.Contracts
- ContractRates: Contract Rates
- ContractRatesBasic: Contract Rates (basic)
- ContractTypes: Contract Types
- ContractWeekDays: Contract Weekdays
- Contracts: Contracts
- MyActiveContractToday: My Active Contract Today
Horeko.Department
- DepartmentByID: Department by ID
- Departments: Departments
- DepartmentsBasic: Departments (basic)
Horeko.Dish
- DishAllergensByDishID: Dish Allergens by Dish ID
- DishByID: itgen_horeko_dishbyid_plural
- DishFinancialStateByID: Dish Financial State by ID
- DishNutrientQualityMarksByDishID: Dish Nutrient Quality Marks by Dish ID
- DishNutrientsByDishID: Dish Nutrients by Dish ID
- DishRecipeFinancialCalculationsByDishID: Dish Recipe Financial Calculations by Dish ID
- DishRecipeIngredients: Dish Recipe Ingredients
- DishRecipeIngredientsByDishID: Dish Recipe Ingredients by Dish ID
- Dishes: Dishes
- DishesBasics: Dishes (basics)
- Dishes_MediaImagesById: itgen_horeko_dishes_mediaimagesbyid_plural
- Dishes_MediaVideosById: itgen_horeko_dishes_mediavideosbyid_plural
- _RecordsMediaImagesDishes: itgen_horeko__recordsmediaimagesdishes_plural
- _RecordsMediaVideosDishes: itgen_horeko__recordsmediavideosdishes_plural
Horeko.DocumentManagement
- CompanyEntriesByEntryTypeID: Company Entries by Entry Type ID
- CompanyEntryTypes: Company Entry Types
- EntryAttachmentDetailsByEntryID: Entry Attachment Details by Entry ID
- EntryDetailsByEntryID: Entry Details by Entry ID
- EntryHistoryByEntryID: Entry History by Entry ID
- PersonalEntriesByEntryTypeID: Personal Entries by Entry Type ID
- PersonalEntryTypes: Personal Entry Types
Horeko.Documents
- DownloadByUrl: Download by URL
Horeko.Employee
- EmployeeByID: Employee by ID
- EmployeeDepartmentsByEmployeeID: Employee Departments by Employee ID
- EmployeeDetailsByID: Employee Details by ID
- EmployeeOptions: Employee Options
- EmployeeSkills: Employee Skills
- EmployeeSkillsByEmployeeID: Employee Skills by Employee ID
- EmployeeSkillsByEmployeeID2: Employee Skills by Employee ID
- EmployeeTeams: Employee Teams
- EmployeeTeamsByEmployeeID: Employee Teams by Employee ID
- EmployeeTeamsByEmployeeID2: Employee Teams by Employee ID
- Employees: Employees
Horeko.Export
- ArticleAllergensByPluNumber: Article Allergens by PLU Number
- ArticleIngredientsByPluNumber: Article Ingredients by PLU Number
- ArticleMediaByPluNumber: Article Media by PLU Number
- ArticleProductsByPluNumber: Article Products by PLU Number
- ArticlesByPluNumber: Articles by PLU Number
- DishAllergensByDishID: Dish Allergens by Dish ID
- DishByID: itgen_horeko_dishbyid_plural
- DishIngredientsByDishID: Dish Ingredients by Dish ID
- DishMediaByDishID: Dish Media by Dish ID
- DishProductsByDishID: Dish Products by Dish ID
Horeko.File
- FileById: File by ID
Horeko.HealthController
- Health: itgen_horeko_health_plural
Horeko.Hours
- BreakHours: Breakhours
- Hours: Hours
Horeko.Ingredient
- IngredientAllergensByIngredientID: Ingredient Allergens by Ingredient ID
- IngredientByID: Ingredient by ID
- IngredientByIDAlt: Ingredient by ID (alt.)
- IngredientHistoryByIngredientID: Ingredient History by Ingredient ID
- IngredientHistorySummaryByIngredient: Ingredient History Summary by Ingredient
- IngredientNutrientsByIngredientID: Ingredient Nutrients by Ingredient ID
- IngredientOptions: Ingredient Options
- IngredientQualityMarkNutrientsByIngredientID: Ingredient Quality Mark Nutrients by Ingredient ID
- IngredientSynonyms: Ingredient Synonyms
- IngredientSynonymsByIngredientID: Ingredient Synonyms by Ingredient ID
- IngredientSynonymsByIngredientIDAlt: Ingredient Synonyms by Ingredient ID (alt.)
- Ingredients: Ingredients
Horeko.Location
- Locations: Locations
- Userlocations: User Locations
Horeko.Meal
- Meals: Meals
Horeko.Menubuffet
- MenubuffetTemplateComponents: Menubuffet Template Components
- MenubuffetTemplates: Menubuffet Templates
Horeko.MobileSettings
- MobileSettings: Mobile Settings
- MobilesettingsGetMobileAppVersions: itgen_horeko_mobilesettingsgetmobileappversions_plural
Horeko.Native
- NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar Requests
Horeko.Newsletter
- NewsletterAttachmentsByNewsletterID: Newsletter Attachments by Newsletter ID
- NewsletterByID: itgen_horeko_newsletterbyid_plural
- NewsletterCommentsByNewsletterID: itgen_horeko_newslettercommentsbynewsletterid_plural
- NewslettersByDate: Newsletters by Date
Horeko.Permissions
- BoughtProductPermissions: Bought Product Permissions
- Permissions: Permissions
Horeko.Recipefolders
- RecipeFoldersByFolderType: Recipe Folders by Folder Type
Horeko.Request
- RequestsByDate: Requests by Date
- RequestsManagerOverview: itgen_horeko_requestsmanageroverview_plural
- RequestsOverview: Requests Overview
- UndecidedAndFutureRequestTeamsByRosterType: Undecided and Future Request Teams by Roster Type
- UndecidedAndFutureRequestsByRosterType: Undecided and Future Requests by Roster Type
Horeko.Roster
- AvailabilityEvents: Availability Events
- CalendarEvents: Calendar Events
- RosterDepartmentByDepartmentIdTeamTeamIdEmployees: itgen_horeko_rosterdepartmentbydepartmentidteamteamidemployees_plural
- RosterDepartmentByDepartmentIdTeams: itgen_horeko_rosterdepartmentbydepartmentidteams_plural
- RosterDepartments: itgen_horeko_rosterdepartments_plural
- RosterEventswithshiftrecipients: itgen_horeko_rostereventswithshiftrecipients_plural
- RosterFeeds: itgen_horeko_rosterfeeds_plural
- RosterOverview: Roster Overview
- RosterTeamByTeamIdSkills: itgen_horeko_rosterteambyteamidskills_plural
- Roster_AvailabilitiesEventswithshiftrecipients: itgen_horeko_roster_availabilitieseventswithshiftrecipients_plural
- Roster_CalendarEventsEventswithshiftrecipients: itgen_horeko_roster_calendareventseventswithshiftrecipients_plural
- Roster_DataSelectionFeeds: itgen_horeko_roster_dataselectionfeeds_plural
- Roster_ShiftsEventswithshiftrecipients: itgen_horeko_roster_shiftseventswithshiftrecipients_plural
- Roster_ShiftsUndeterminedShiftEmployeesStatusAcceptedEmployeesImagesEventswithshiftrecipients: itgen_horeko_roster_shiftsundeterminedshiftemployeesstatusacceptedemployeesimageseventswithshiftrecipients_plural
- Roster_ShiftsUndeterminedShiftEmployeesStatusRejectedEmployeesImagesEventswithshiftrecipients: itgen_horeko_roster_shiftsundeterminedshiftemployeesstatusrejectedemployeesimageseventswithshiftrecipients_plural
- Roster_UnavailabilitiesEventswithshiftrecipients: itgen_horeko_roster_unavailabilitieseventswithshiftrecipients_plural
- ShiftEvents: Shift Events
- UnavailabilityEvents: Unavailability Events
Horeko.Sale
- Sales: Sales
- SalesBrancheStores: Sales Branche Stores
- SalesBranches: Sales Branches
- SalesStores: Sales Stores
Horeko.ShiftLocation
- ShiftLocationByID: Shift Location by ID
- ShiftLocations: Shift Locations
Horeko.ShiftTrade
- ShiftTradeRecipientsByShiftID: Shift Trade Recipients by Shift ID
- ShiftTradesByDepartmentID: Shift Trades by Department ID
- ShiftTradesByShiftID: Shift Trades by Shift ID
- ShiftTradesByShiftTradeRecipientID: Shift Trades by Shift Trade Recipient ID
- ShifttradesManagerDetailsByShiftId: itgen_horeko_shifttradesmanagerdetailsbyshiftid_plural
- ShifttradesManagerDetailsByShiftTradeIdRecipients: itgen_horeko_shifttradesmanagerdetailsbyshifttradeidrecipients_plural
- ShifttradesManagerOverview: itgen_horeko_shifttradesmanageroverview_plural
- ShifttradesManager_AcceptedEmployeesAcceptedEmployeesImagesOverview: itgen_horeko_shifttradesmanager_acceptedemployeesacceptedemployeesimagesoverview_plural
Horeko.Shifts
- DailyShiftByID: Daily Shift by ID
- MyShifts: My Shifts
- ShiftsByShiftId: itgen_horeko_shiftsbyshiftid_plural
- ShiftsTemplates: itgen_horeko_shiftstemplates_plural
- Shifts_k__BackingFieldByShiftId: {res:itgen_horeko_shifts_k__backingfieldbyshiftid_plural}
Horeko.Statistics
- ManagerDishTypes: Dish Types (Manager)
- ManagerIngredientMutationsBySupplierID: Ingredient Mutations by Supplier ID (Manager)
- ManagerMarginProblemsByDishTypeID: Margin Problems by Dish Type ID (Manager)
- ManagerProfitableDishes: Profitable Dishes (Manager)
- ManagerSuppliers: Suppliers (Manager)
- ManagerTodaysOverdueTasksByDateRange: Todays Overdue Tasks by Date Range (Manager)
- ManagerTurnoverAndLaborStatisticsByDate: itgen_horeko_managerturnoverandlaborstatisticsbydate_plural
- ManagerTurnoverAndLaborStatisticsByDayAlt: itgen_horeko_managerturnoverandlaborstatisticsbydayalt_plural
- ManagerWasteByLocationID: itgen_horeko_managerwastebylocationid_plural
- MyPlusMinuses: My Plus/Minuses
- MyVacations: My Vacations
Horeko.Stock
- StockByID: Stock by ID
- StockLevel1ItemsByStockID: Stock Level 1 Items by Stock ID
- StockLevel2ItemsByStockID: Stock Level 2 Items by Stock ID
- StockLevel3ItemsByStockID: Stock Level 3 Items by Stock ID
- StockLevel4ItemsByStockID: Stock Level 4 Items by Stock ID
- StockLevel5ItemsByStockID: Stock Level 5 Items by Stock ID
- Stocks: Stocks
Horeko.Subrecipe
- SubrecipeAllergensBySubrecipeID: Subrecipe Allergens by Subrecipe ID
- SubrecipeByID: Subrecipe by ID
- SubrecipeFinancialStateByID: Subrecipe Financial State by ID
- SubrecipeIngredientCostFinancialStateBySubrecipeID: Subrecipe Ingredient Cost Financial State by Subrecipe ID
- SubrecipeIngredientQualityMarkNutrientsBySubrecipeID: Subrecipe Ingredient Quality Mark Nutrients by Subrecipe ID
- SubrecipeIngredients: Subrecipe Ingredients
- SubrecipeIngredientsBySubrecipeID: Subrecipe Ingredients by Subrecipe ID
- SubrecipeNutrientsBySubrecipeID: Subrecipe Nutrients by Subrecipe ID
- SubrecipeOptions: Subrecipe Options
- SubrecipeOptionsAlt: Subrecipe Options (alt.)
- SubrecipeSynonyms: Subrecipe Synonyms
- SubrecipeSynonymsBySubrecipeID: Subrecipe Synonyms by Subrecipe ID
- Subrecipes_MediaImagesById: itgen_horeko_subrecipes_mediaimagesbyid_plural
- Subrecipes_MediaVideosById: itgen_horeko_subrecipes_mediavideosbyid_plural
- _RecordsMediaImagesSubrecipes: itgen_horeko__recordsmediaimagessubrecipes_plural
- _RecordsMediaVideosSubrecipes: itgen_horeko__recordsmediavideossubrecipes_plural
Horeko.Team
Horeko.Unavailability
- CustomUnavailabilities: Custom Unavailabilities
- MyUnavailabilities: My Unavailabilities
- MyUnavailabilitiesAlt: My Unavailabilities (alt.)
- PredefinedUnavailabilities: Predefined Unavailabilities
- UnavailabilitiesByID: itgen_horeko_unavailabilitiesbyid_plural
- UnavailabilitiesById_RecurrenceDetailsWeeklyRecurrenceDaysOfWeekDetails: itgen_horeko_unavailabilitiesbyid_recurrencedetailsweeklyrecurrencedaysofweekdetails_plural
- UnavailabilitiesDaily: Unavailabilities Daily
- UnavailabilitiesManagerOverview: itgen_horeko_unavailabilitiesmanageroverview_plural
- UnavailabilitiesManager_TeamsIdsOverview: itgen_horeko_unavailabilitiesmanager_teamsidsoverview_plural
Horeko.UndeterminedShift
- MyUndeterminedShiftRequestByID: My Undetermined Shift Request by ID
- MyUndeterminedShiftRequests: My Undetermined Shift Requests
- UndeterminedshiftrequestsDetailsByShiftId: itgen_horeko_undeterminedshiftrequestsdetailsbyshiftid_plural
- UndeterminedshiftrequestsDetailsByShiftIdRecipients: itgen_horeko_undeterminedshiftrequestsdetailsbyshiftidrecipients_plural
- UndeterminedshiftrequestsDetailsByShiftId_ShiftRecipientsRecipients: itgen_horeko_undeterminedshiftrequestsdetailsbyshiftid_shiftrecipientsrecipients_plural
- UndeterminedshiftrequestsManagerOverview: itgen_horeko_undeterminedshiftrequestsmanageroverview_plural
- UndeterminedshiftrequestsManager_EmployeesStatusAcceptedEmployeesImagesOverview: itgen_horeko_undeterminedshiftrequestsmanager_employeesstatusacceptedemployeesimagesoverview_plural
- UndeterminedshiftrequestsManager_EmployeesStatusRejectedEmployeesImagesOverview: itgen_horeko_undeterminedshiftrequestsmanager_employeesstatusrejectedemployeesimagesoverview_plural
Horeko.Views
- DishAllergans: Dish Allergens
- DishFinancialCalculations: Dish Financial Calculations
- DishFinancialStates: Dish Financial States
- DishNutrientMarkQualityMarks: Dish Nutrient Quality Marks
- EmployeeDepartments: Employee Departments
- IngredientAllergans: Ingredient Allergans
- IngredientNutrients: Ingredient Nutrients
- IngredientQualityMarkMutrients: Ingredient Quality Mark Nutrients
- ManagerIngredientMutations: Manager Ingredient Mutations
- RecipeFolders: Recipe Folders
- TodaysShifts: Todays Shifts
Horeko.Waste
- WasteItems: Waste Items
- WasteStatisticsByDateRange: Waste Statistics by Date Range
Attributen
The attributes of this platform are on the page Attributes.
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: