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