Horeko Data Model
Configurez cette plateforme dans Invantive Cloud : https://cloud.invantive.com/horeko
Les comparaisons de texte sur cette plateforme tiennent compte de la casse.
Plate-forme
- Utilisable depuis : Invantive Cloud et les produits Invantive installés sur votre ordinateur ou votre serveur.
- Type : une application accessible via son API.
- Les données sont regroupées par catégorie, par exemple par entreprise ou par administration.
- Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
Chiffres
| Figure | Count |
|---|---|
| Tables | 206 |
| Columns | 3,425 |
Affiche sur le modèle de données
Ce modèle de données ne déclare pour l'instant aucune clé ; les relations indiquées par des points sont dérivées des noms de colonnes.
Sur une table de l'affiche : Zoom avant et arrière, les touches fléchées permettent de se déplacer, la touche 0 permet de revenir à la taille normale.
L'affiche sous forme de texte : tableaux par thème et leurs relations
Autre
MyClockingStateBreaks, Departments, Meals, TodaysShifts
Compte (sans relations)
AccountCheckOeiUserPopupOptions, AccountGetOeiUserInfo
Analytic (sans relations)
Bought (sans relations)
Société (sans relations)
Contrat (sans relations)
Personnalisé (sans relations)
Service (sans relations)
Dish (sans relations)
DishAllergans, DishFinancialCalculations, DishFinancialStates, DishNutrientMarkQualityMarks
L’employé (sans relations)
EmployeeDepartments, EmployeeOptions
Santé (sans relations)
Ingredient (sans relations)
IngredientAllergans, IngredientNutrients, IngredientQualityMarkMutrients
Gestionnaire (sans relations)
ManagerDishTypes, ManagerIngredientMutations, ManagerSuppliers
Menubuffet (sans relations)
MenubuffetTemplateComponents, MenubuffetTemplates
Mobile (sans relations)
Mobilesetting (sans relations)
MobilesettingsGetMobileAppVersions
My (sans relations)
MyActiveContractToday, MyClockingState, MyPlusMinuses, MyShifts, MyUndeterminedShiftRequests, MyVacations
NATIVEPLATFORMSCALARREQUESTS (sans relations)
Autorisation (sans relations)
Personal (sans relations)
Predefined (sans relations)
Recette (sans relations)
Demande (sans relations)
Roster (sans relations)
RosterDepartments, RosterFeeds, Roster_DataSelectionFeeds
Changement de vitesse (sans relations)
Shifttrade (sans relations)
ShifttradesManagerOverview, ShifttradesManager_AcceptedEmployeesAcceptedEmployeesImagesOverview
Userlocation (sans relations)
Relations
- MyClockingStateBreaks → Meals (candidat): Derived from the column Meal_Id.
- TodaysShifts → Departments (candidat): Derived from the column DepartmentId.
Tableaux
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
Attributs
The attributes of this platform are on the page Attributes.
Notes de Version
Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :