Owneat Technical Guide main Help

Restaurant Database Structure

AllergensId
ProductsId
MenuId
FoodLabelsId
ProductsId
FormulaSectionsId
ContainedProductsId
FormulaId
ProductId
RestaurantId
RestaurantId
PersonalizationId
ProductId
CategoryId
RestaurantId
OpeningHoursId
AllergenProduct
uuid AllergensId
uuid ProductsId
Allergens
timestamp with time zone CreatedAt
timestamp with time zone UpdatedAt
uuid Id
varchar(200) : Name
Categories
uuid MenuId
integer SortingIndex
timestamp with time zone CreatedAt
timestamp with time zone UpdatedAt
uuid RestaurantId
integer Period
boolean IsFormulaSpecific
uuid Id
varchar(50) : Name
FoodLabelProduct
uuid FoodLabelsId
uuid ProductsId
FoodLabels
timestamp with time zone CreatedAt
timestamp with time zone UpdatedAt
uuid Id
varchar(200) : Name
FormulaSectionProduct
uuid ContainedProductsId
uuid FormulaSectionsId
FormulaSections
uuid FormulaId
timestamp with time zone CreatedAt
timestamp with time zone UpdatedAt
uuid Id
varchar(50) : Name
Ingredients
uuid ProductId
timestamp with time zone CreatedAt
timestamp with time zone UpdatedAt
uuid Id
varchar(50) : Name
numeric(18, 4) : Quantity
varchar(10) : Unit
Menus
uuid RestaurantId
integer States
integer SortingIndex
timestamp with time zone CreatedAt
timestamp with time zone UpdatedAt
uuid Id
varchar(100) : Name
OpeningHours
integer DayOfWeek
uuid RestaurantId
timestamp with time zone CreatedAt
timestamp with time zone UpdatedAt
uuid Id
PersonalizationChoice
double precision Price
uuid PersonalizationId
integer Id
varchar(200) : Name
Personalizations
integer Mode
integer MinChoices
integer MaxChoices
uuid ProductId
timestamp with time zone CreatedAt
timestamp with time zone UpdatedAt
uuid Id
varchar(50) : Name
ProductBases
integer SortingIndex
boolean IsAvailable
uuid CategoryId
uuid RestaurantId
bigint Stock
timestamp with time zone CreatedAt
timestamp with time zone UpdatedAt
integer CategoryProductData_ServingPeriod
integer VatRate
uuid Id
varchar(50) : Name
varchar(200) : Description
varchar(500) : DisplayImageUrl
numeric(6, 2) : UnitPrice
varchar(50) : ExternalPaymentId
varchar(13) : TypeDiscriminator
varchar(50) : CategoryProductData_CategoryName
RestaurantEvents
boolean IsActive
bigint TitleColor
integer SortingIndex
uuid RestaurantId
timestamp with time zone CreatedAt
timestamp with time zone UpdatedAt
uuid Id
varchar(50) : Title
varchar(500) : Description
varchar(500) : DisplayImageUrl
Restaurants
boolean IsPaymentModuleEnabled
boolean IsChargesEnabled
boolean IsInPrePaymentMode
timestamp with time zone CreatedAt
timestamp with time zone UpdatedAt
uuid Id
varchar(50) : Name
varchar(500) : Description
varchar(500) : DisplayImageUrl
varchar(200) : PaymentPlatformId
varchar(200) : Address_Street
varchar(100) : Address_City
varchar(100) : Address_State
varchar(100) : Address_Country
varchar(20) : Address_ZipCode
TimeRange
interval OpenTime
interval CloseTime
uuid OpeningHoursId
timestamp with time zone CreatedAt
timestamp with time zone UpdatedAt
uuid Id
Last modified: 21 May 2024
RestaurantRestaurant Technical Documentation