robot

Tables (21)

CancelledOrderItems

  • Id — uuid — Primary key — NOT NULL
  • Reason — varchar(200) — NOT NULL
  • Note — varchar(500)
  • ItemPrice — numeric(18, 2) — NOT NULL
  • OrderTotalBefore — numeric(18, 2) — NOT NULL
  • OrderTotalAfter — numeric(18, 2) — NOT NULL
  • OrderItemId — uuid — NOT NULL
  • CancelledByUserId — uuid — NOT NULL
  • CreatedBy — text
  • LastUpdatedBy — text
  • DeletedBy — text
  • CreatedTime — timestamptz — NOT NULL
  • LastUpdatedTime — timestamptz — NOT NULL
  • DeletedTime — timestamptz

Categories

  • Id — uuid — Primary key — NOT NULL
  • Key — Primary key — NOT NULL
  • Name — text — NOT NULL
  • CreatedBy — text
  • LastUpdatedBy — text
  • DeletedBy — text
  • CreatedTime — timestamptz — NOT NULL
  • LastUpdatedTime — timestamptz — NOT NULL
  • DeletedTime — timestamptz
  • Field

Complain

  • Id — uuid — Primary key — NOT NULL
  • TableId — uuid — NOT NULL
  • OrderItemId — uuid
  • Title — text — NOT NULL
  • Description — text — NOT NULL
  • isPending — bool — NOT NULL
  • HandledBy — uuid
  • ResolvedAt — timestamptz
  • ResolutionNote — text
  • CreatedBy — text
  • LastUpdatedBy — text
  • DeletedBy — text
  • CreatedTime — timestamptz — NOT NULL
  • LastUpdatedTime — timestamptz — NOT NULL
  • DeletedTime — timestamptz

Feedback

  • Id — uuid — Primary key — NOT NULL
  • TableId — uuid — NOT NULL
  • OrderItemId — uuid — NOT NULL
  • Rating — int4 — NOT NULL
  • Comment — text
  • Type — int4 — NOT NULL
  • CreatedBy — uuid
  • CustomerId — uuid
  • LastUpdatedBy — text
  • DeletedBy — text
  • CreatedTime — timestamptz — NOT NULL
  • LastUpdatedTime — timestamptz — NOT NULL
  • DeletedTime — timestamptz

InvoiceDetail

  • Id — uuid — Primary key — NOT NULL
  • OrderItemId — uuid — NOT NULL
  • TotalMoney — numeric — NOT NULL
  • Status — int4 — NOT NULL
  • InvoiceId — uuid — NOT NULL
  • CreatedBy — text
  • LastUpdatedBy — text
  • DeletedBy — text
  • CreatedTime — timestamptz — NOT NULL
  • LastUpdatedTime — timestamptz — NOT NULL
  • DeletedTime — timestamptz

Invoices

  • Id — uuid — Primary key — NOT NULL
  • TableId — uuid — NOT NULL
  • TotalMoney — numeric — NOT NULL
  • Status — int4 — NOT NULL
  • PaymentMethod — int4 — NOT NULL
  • CreatedBy — text
  • LastUpdatedBy — text
  • DeletedBy — text
  • CreatedTime — timestamptz — NOT NULL
  • LastUpdatedTime — timestamptz — NOT NULL
  • DeletedTime — timestamptz

OrderItemToppings

  • Id — uuid — Primary key — NOT NULL
  • OrderItemId — uuid — NOT NULL
  • ToppingId — uuid — NOT NULL
  • Price — numeric — NOT NULL
  • CreatedBy — text
  • LastUpdatedBy — text
  • DeletedBy — text
  • CreatedTime — timestamptz — NOT NULL
  • LastUpdatedTime — timestamptz — NOT NULL
  • DeletedTime — timestamptz

OrderItems

  • Id — uuid — Primary key — NOT NULL
  • OrderId — uuid — NOT NULL
  • ProductId — uuid — NOT NULL
  • ProductSizeId — uuid — NOT NULL
  • Status — int4 — NOT NULL
  • Note — text
  • RemakeNote — text
  • IsUrgent — bool — NOT NULL
  • CreatedBy — text
  • LastUpdatedBy — text
  • DeletedBy — text
  • CreatedTime — timestamptz — NOT NULL
  • LastUpdatedTime — timestamptz — NOT NULL
  • DeletedTime — timestamptz

Orders

  • Id — uuid — Primary key — NOT NULL
  • TableId — uuid
  • Status — int4 — NOT NULL
  • TotalPrice — numeric — NOT NULL
  • paymentMethod — int4 — NOT NULL
  • PaymentStatus — int4 — NOT NULL
  • CreatedBy — text
  • LastUpdatedBy — text
  • DeletedBy — text
  • CreatedTime — timestamptz — NOT NULL
  • LastUpdatedTime — timestamptz — NOT NULL
  • DeletedTime — timestamptz

Payments

  • Id — uuid — Primary key — NOT NULL
  • PaymentTime — timestamptz — NOT NULL
  • PaymentMethod — int4 — NOT NULL
  • PaymentStatus — int4 — NOT NULL
  • OrderId — uuid — NOT NULL
  • PayOSOrderCode — int4
  • CreatedBy — text
  • LastUpdatedBy — text
  • DeletedBy — text
  • CreatedTime — timestamptz — NOT NULL
  • LastUpdatedTime — timestamptz — NOT NULL
  • DeletedTime — timestamptz

ProductCategories

  • Id — uuid — Primary key — NOT NULL
  • ProductId — uuid — NOT NULL
  • CategoryId — uuid — NOT NULL
  • CreatedBy — text
  • LastUpdatedBy — text
  • DeletedBy — text
  • CreatedTime — timestamptz — NOT NULL
  • LastUpdatedTime — timestamptz — NOT NULL
  • DeletedTime — timestamptz

ProductSizes

  • Id — uuid — Primary key — NOT NULL
  • SizeName — int4 — NOT NULL
  • Price — numeric — NOT NULL
  • ProductId — uuid — NOT NULL
  • CreatedBy — text
  • LastUpdatedBy — text
  • DeletedBy — text
  • CreatedTime — timestamptz — NOT NULL
  • LastUpdatedTime — timestamptz — NOT NULL
  • DeletedTime — timestamptz

ProductToppings

  • Id — uuid — Primary key — NOT NULL
  • ProductId — uuid — NOT NULL
  • ToppingId — uuid — NOT NULL
  • CreatedBy — text
  • LastUpdatedBy — text
  • DeletedBy — text
  • CreatedTime — timestamptz — NOT NULL
  • LastUpdatedTime — timestamptz — NOT NULL
  • DeletedTime — timestamptz

Products

  • Id — uuid — Primary key — NOT NULL
  • Name — text — NOT NULL
  • Description — text — NOT NULL
  • DurationTime — int4 — NOT NULL
  • ImageUrl — text — NOT NULL
  • CreatedBy — text
  • LastUpdatedBy — text
  • DeletedBy — text
  • CreatedTime — timestamptz — NOT NULL
  • LastUpdatedTime — timestamptz — NOT NULL
  • DeletedTime — timestamptz

RemakeOrderItems

  • Id — uuid — Primary key — NOT NULL
  • OrderItemId — uuid — NOT NULL
  • RemakeNote — varchar(300) — NOT NULL
  • PreviousStatus — int4 — NOT NULL
  • AfterStatus — int4 — NOT NULL
  • RemakedByUserId — uuid — NOT NULL
  • IsUrgent — bool — NOT NULL
  • CreatedBy — text
  • LastUpdatedBy — text
  • DeletedBy — text
  • CreatedTime — timestamptz — NOT NULL
  • LastUpdatedTime — timestamptz — NOT NULL
  • DeletedTime — timestamptz

Roles

  • Id — uuid — Primary key — NOT NULL
  • Name — varchar(50) — NOT NULL
  • Description — varchar(300) — NOT NULL
  • CreatedBy — text
  • LastUpdatedBy — text
  • DeletedBy — text
  • CreatedTime — timestamptz — NOT NULL
  • LastUpdatedTime — timestamptz — NOT NULL
  • DeletedTime — timestamptz

SystemSettings

  • Id — uuid — Primary key — NOT NULL
  • Key — varchar(100) — NOT NULL
  • Value — text — NOT NULL
  • Type — int4 — NOT NULL
  • CreatedBy — text
  • LastUpdatedBy — text
  • DeletedBy — text
  • CreatedTime — timestamptz — NOT NULL
  • LastUpdatedTime — timestamptz — NOT NULL
  • DeletedTime — timestamptz

Tables

  • Id — uuid — Primary key — NOT NULL
  • Name — text — NOT NULL
  • Status — int4 — NOT NULL
  • IsQrLocked — bool — NOT NULL
  • LockedAt — timestamptz
  • DeviceId — text
  • LastAccessedAt — timestamptz
  • ShareToken — text
  • isShared — bool — NOT NULL
  • CreatedBy — text
  • LastUpdatedBy — text
  • DeletedBy — text
  • CreatedTime — timestamptz — NOT NULL
  • LastUpdatedTime — timestamptz — NOT NULL
  • DeletedTime — timestamptz

Toppings

  • Id — uuid — Primary key — NOT NULL
  • Name — text — NOT NULL
  • Price — numeric — NOT NULL
  • ImageUrl — text — NOT NULL
  • CreatedBy — text
  • LastUpdatedBy — text
  • DeletedBy — text
  • CreatedTime — timestamptz — NOT NULL
  • LastUpdatedTime — timestamptz — NOT NULL
  • DeletedTime — timestamptz

Users

  • Id — uuid — Primary key — NOT NULL
  • EmploymentCode — text — NOT NULL
  • UserName — varchar(100) — NOT NULL
  • Password — varchar(200) — NOT NULL
  • FullName — varchar(200) — NOT NULL
  • Avartar — varchar(500) — NOT NULL
  • Email — varchar(200) — NOT NULL
  • PhoneNumber — varchar(20) — NOT NULL
  • IsActive — bool — NOT NULL
  • RoleId — uuid — NOT NULL
  • CreatedBy — text
  • LastUpdatedBy — text
  • DeletedBy — text
  • CreatedTime — timestamptz — NOT NULL
  • LastUpdatedTime — timestamptz — NOT NULL
  • DeletedTime — timestamptz

__EFMigrationsHistory

  • MigrationId — varchar(150) — Primary key — NOT NULL
  • ProductVersion — varchar(32) — NOT NULL