Horeko Data Model
Configura esta plataforma en Invantive Cloud: https://cloud.invantive.com/horeko
Las comparaciones de texto en esta plataforma distinguen entre mayúsculas y minúsculas.
Plataforma
- Se utiliza desde: Invantive Cloud y los productos de Invantive instalados en tu propio ordenador o servidor.
- Tipo: una aplicación a la que se accede a través de su API.
- Los datos se agrupan por categorías, como por empresa o por administración.
- Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
Cifras
| Figure | Count |
|---|---|
| Tables | 206 |
| Columns | 3,425 |
Póster del Modelo de Datos
Este modelo de datos aún no declara ninguna clave; las relaciones con puntos se derivan de los nombres de las columnas.
En una tabla del póster: Zoom para ampliar y reducir; las teclas de flecha sirven para desplazarse; el 0 ajusta la imagen.
El póster en forma de texto: tablas por tema y sus relaciones
Otro
MyClockingStateBreaks, Departments, Meals, TodaysShifts
Cuenta (sin relaciones)
AccountCheckOeiUserPopupOptions, AccountGetOeiUserInfo
Analytic (sin relaciones)
Bought (sin relaciones)
Compañía (sin relaciones)
Contrato (sin relaciones)
Personalizar (sin relaciones)
Departamento (sin relaciones)
Dish (sin relaciones)
DishAllergans, DishFinancialCalculations, DishFinancialStates, DishNutrientMarkQualityMarks
Empleado (sin relaciones)
EmployeeDepartments, EmployeeOptions
Salud (sin relaciones)
Ingredient (sin relaciones)
IngredientAllergans, IngredientNutrients, IngredientQualityMarkMutrients
Administrador (sin relaciones)
ManagerDishTypes, ManagerIngredientMutations, ManagerSuppliers
Menubuffet (sin relaciones)
MenubuffetTemplateComponents, MenubuffetTemplates
Móvil (sin relaciones)
Mobilesetting (sin relaciones)
MobilesettingsGetMobileAppVersions
My (sin relaciones)
MyActiveContractToday, MyClockingState, MyPlusMinuses, MyShifts, MyUndeterminedShiftRequests, MyVacations
NATIVEPLATFORMSCALARREQUESTS (sin relaciones)
Autorización (sin relaciones)
Personal (sin relaciones)
Predefined (sin relaciones)
Receta (sin relaciones)
Solicitud (sin relaciones)
Roster (sin relaciones)
RosterDepartments, RosterFeeds, Roster_DataSelectionFeeds
Turno (sin relaciones)
Shifttrade (sin relaciones)
ShifttradesManagerOverview, ShifttradesManager_AcceptedEmployeesAcceptedEmployeesImagesOverview
Userlocation (sin relaciones)
Relaciones
- MyClockingStateBreaks → Meals (candidato): Derived from the column Meal_Id.
- TodaysShifts → Departments (candidato): Derived from the column DepartmentId.
Tablas
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
Atributos
The attributes of this platform are on the page Attributes.
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: