Horeko Data Model
Configura questa piattaforma su Invantive Cloud: https://cloud.invantive.com/horeko
I confronti tra testi su questa piattaforma tengono conto delle maiuscole e delle minuscole.
Piattaforma
- Utilizzabile da: Invantive Cloud e dai prodotti Invantive installati sul proprio computer o server.
- Tipo: un'applicazione accessibile tramite la propria API.
- I dati sono suddivisi, ad esempio per azienda o per amministrazione.
- Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
Figure
| Figure | Count |
|---|---|
| Tables | 206 |
| Columns | 3,425 |
Poster sul modello di dati
Questo modello di dati non dichiara ancora alcuna chiave; le relazioni indicate da punti derivano dai nomi delle colonne.
Su una tabella del poster: Zoom avanti e indietro, i tasti freccia per spostarsi, 0 per adattare.
Il poster come testo: tabelle per argomento e le loro relazioni
Altro
MyClockingStateBreaks, Departments, Meals, TodaysShifts
Conto (senza relazioni)
AccountCheckOeiUserPopupOptions, AccountGetOeiUserInfo
Analytic (senza relazioni)
Bought (senza relazioni)
Impresa (senza relazioni)
Contratto (senza relazioni)
Personalizzato (senza relazioni)
Dipartimento (senza relazioni)
Dish (senza relazioni)
DishAllergans, DishFinancialCalculations, DishFinancialStates, DishNutrientMarkQualityMarks
Dipendente (senza relazioni)
EmployeeDepartments, EmployeeOptions
Salute (senza relazioni)
Ingredient (senza relazioni)
IngredientAllergans, IngredientNutrients, IngredientQualityMarkMutrients
Manager (senza relazioni)
ManagerDishTypes, ManagerIngredientMutations, ManagerSuppliers
Menubuffet (senza relazioni)
MenubuffetTemplateComponents, MenubuffetTemplates
Cellulare (senza relazioni)
Mobilesetting (senza relazioni)
MobilesettingsGetMobileAppVersions
My (senza relazioni)
MyActiveContractToday, MyClockingState, MyPlusMinuses, MyShifts, MyUndeterminedShiftRequests, MyVacations
NATIVEPLATFORMSCALARREQUESTS (senza relazioni)
Autorizzazione (senza relazioni)
Personal (senza relazioni)
Predefined (senza relazioni)
Ricetta (senza relazioni)
Richiesta (senza relazioni)
Roster (senza relazioni)
RosterDepartments, RosterFeeds, Roster_DataSelectionFeeds
Turno (senza relazioni)
Shifttrade (senza relazioni)
ShifttradesManagerOverview, ShifttradesManager_AcceptedEmployeesAcceptedEmployeesImagesOverview
Userlocation (senza relazioni)
Relazioni
- MyClockingStateBreaks → Meals (candidato): Derived from the column Meal_Id.
- TodaysShifts → Departments (candidato): Derived from the column DepartmentId.
Tabelle
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
Attributi
The attributes of this platform are on the page Attributes.
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: