Owneat Technical Guide main Help

Ordering Database Structure

TableId
OrderId
OrderLineItemId
CustomerId
OrderLinePersonalizationOrderLineItemId, OrderLinePersonalizationId, Id
Customers
boolean HasToPay
boolean IsPaymentFirst
boolean IsFinished
uuid TableId
uuid OneSignalId
timestamp with time zone CreatedAt
timestamp with time zone UpdatedAt
uuid RestaurantId
boolean NeedAnExpenseReport
uuid Id
varchar(50) : Identifier
varchar(200) : EmailForExpenseReport
OrderLineItems
uuid ProductId
uuid OrderId
integer Quantity
double precision UnitPrice
text ExternalPaymentId
uuid PayingCustomerId
boolean IsPaid
timestamp with time zone CreatedAt
timestamp with time zone UpdatedAt
boolean IsCanceled
boolean IsAcknowledged
boolean IsServed
integer CategoryProductData_ServingPeriod
integer VatRate
uuid Id
varchar(50) : Name
varchar(200) : Instructions
varchar(50) : CategoryProductData_CategoryName
OrderLinePersonalization
uuid OrderLineItemId
integer Id
varchar(200) : Name
Orders
uuid CustomerId
uuid TableId
integer State
timestamp with time zone CreatedAt
timestamp with time zone UpdatedAt
boolean NeedsToBePaid
uuid RestaurantId
uuid Id
SelectedChoice
double precision Price
uuid OrderLinePersonalizationOrderLineItemId
integer OrderLinePersonalizationId
integer Id
varchar(200) : Name
Tables
uuid RestaurantId
integer TableNumber
integer SeatsCount
bigint Color
integer State
integer WaiterCalledIndicator
uuid RowVersion
integer SortingIndex
boolean IsManualRelease
integer SittingCustomersLimit
timestamp with time zone CreatedAt
timestamp with time zone UpdatedAt
uuid Id
Last modified: 21 May 2024
OrderingOrdering Technical Documentation