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