pos_database

Tables (13)

aspnetusers

  • Id — VARCHAR(255) — Primary key — NOT NULL
  • FirstName — TEXT — NOT NULL
  • MiddleName — TEXT — NOT NULL
  • LastName — TEXT — NOT NULL
  • BranchId — INT — Foreign key → branches.Id
  • CashierId — VARCHAR(255) — Foreign key → aspnetusers.Id
  • RefreshTokenHash — TEXT
  • RefreshTokenExpiryTime — DATETIME
  • UserName — VARCHAR(256)
  • NormalizedUserName — VARCHAR(256)
  • Email — VARCHAR(256)
  • NormalizedEmail — VARCHAR(256)
  • EmailConfirmed — BOOLEAN — NOT NULL
  • PasswordHash — TEXT
  • SecurityStamp — TEXT
  • ConcurrencyStamp — TEXT
  • PhoneNumber — TEXT
  • PhoneNumberConfirmed — BOOLEAN — NOT NULL
  • TwoFactorEnabled — BOOLEAN — NOT NULL
  • LockoutEnd — DATETIME
  • LockoutEnabled — BOOLEAN — NOT NULL
  • AccessFailedCount — INT — NOT NULL
  • INDEX — (NormalizedEmail)
  • INDEX — (BranchId)
  • INDEX — (CashierId)

auditlog

  • Id — INT — Primary key — NOT NULL
  • Username — TEXT — NOT NULL
  • Role — TEXT — NOT NULL
  • Category — TEXT — NOT NULL
  • Action — TEXT — NOT NULL
  • AffectedEntity — TEXT — NOT NULL
  • Description — TEXT
  • Date — DATETIME — NOT NULL

branches

  • Id — INT — Primary key — NOT NULL
  • BranchName — TEXT — NOT NULL
  • Location — TEXT — NOT NULL

discount

  • Id — INT — Primary key — NOT NULL
  • TaxRate — TEXT — NOT NULL
  • Value — DECIMAL(65,30) — NOT NULL
  • Description — TEXT — NOT NULL

menuitemproducts

  • MenuItemId — INT — Foreign key → menuitems.Id — NOT NULL
  • ProductOfSupplierId — INT — Foreign key → products.Id — NOT NULL
  • QuantityUsed — INT — NOT NULL
  • ProductOfSupplierId1 — INT — Foreign key → products.Id
  • INDEX — (ProductOfSupplierId)
  • INDEX — (ProductOfSupplierId1)

menuitems

  • Id — INT — Primary key — NOT NULL
  • ItemName — TEXT — NOT NULL
  • Price — DECIMAL(65,30) — NOT NULL
  • Description — TEXT — NOT NULL
  • IsAvailable — TEXT — NOT NULL
  • Image — BLOB — NOT NULL
  • CashierId — TEXT — NOT NULL
  • BranchId — INT

pendinguseraccount

  • Id — INT — Primary key — NOT NULL
  • FirstName — TEXT — NOT NULL
  • MiddleName — TEXT — NOT NULL
  • LastName — TEXT — NOT NULL
  • Email — TEXT — NOT NULL
  • Password — TEXT — NOT NULL
  • Role — TEXT — NOT NULL
  • Status — TEXT — NOT NULL
  • CreatedAt — DATETIME — NOT NULL
  • BranchId — INT — Foreign key → branches.Id
  • CashierId — TEXT
  • INDEX — (BranchId)

products

  • Id — INT — Primary key — NOT NULL
  • ProductName — TEXT — NOT NULL
  • Stocks — INT — NOT NULL
  • Units — TEXT — NOT NULL
  • CostPrice — DECIMAL(65,30) — NOT NULL
  • TransactionDate — DATETIME — NOT NULL
  • SupplierId — INT — Foreign key → suppliers.Id — NOT NULL
  • CashierId — TEXT — NOT NULL
  • BranchId — INT
  • INDEX — (SupplierId)

salesitems

  • Id — INT — Primary key — NOT NULL
  • SalesTransactionId — INT — Foreign key → salestransaction.Id — NOT NULL
  • MenuItemId — INT — Foreign key → menuitems.Id — NOT NULL
  • Quantity — INT — NOT NULL
  • UnitPrice — DECIMAL(65,30) — NOT NULL
  • INDEX — (MenuItemId)
  • INDEX — (SalesTransactionId)

salestransaction

  • Id — INT — Primary key — NOT NULL
  • ReceiptNumber — TEXT — NOT NULL
  • DateTime — DATETIME — NOT NULL
  • CashierId — VARCHAR(255) — Foreign key → aspnetusers.Id — NOT NULL
  • BranchId — INT — Foreign key → branches.Id
  • Subtotal — DECIMAL(65,30) — NOT NULL
  • Tax — DECIMAL(65,30) — NOT NULL
  • Discount — DECIMAL(65,30) — NOT NULL
  • Total — DECIMAL(65,30) — NOT NULL
  • PaymentMethod — TEXT — NOT NULL
  • Status — TEXT — NOT NULL
  • INDEX — (BranchId)
  • INDEX — (CashierId)

suppliers

  • Id — INT — Primary key — NOT NULL
  • SupplierName — TEXT — NOT NULL
  • ContactPerson — TEXT — NOT NULL
  • PhoneNumber — TEXT — NOT NULL
  • Email — TEXT — NOT NULL
  • Address — TEXT — NOT NULL
  • TransactionDate — DATETIME — NOT NULL

suppliertransactionhistories

  • Id — INT — Primary key — NOT NULL
  • SupplierId — INT — Foreign key → suppliers.Id — NOT NULL
  • User — TEXT — NOT NULL
  • ProductName — TEXT — NOT NULL
  • Price — TEXT — NOT NULL
  • QuantityDelivered — INT — NOT NULL
  • TotalCost — DECIMAL(65,30) — NOT NULL
  • Action — TEXT — NOT NULL
  • TransactionDate — DATETIME — NOT NULL
  • INDEX — (SupplierId)

tax

  • Id — INT — Primary key — NOT NULL
  • TaxRate — TEXT — NOT NULL
  • Value — DECIMAL(65,30) — NOT NULL
  • Description — TEXT — NOT NULL