glory82
Tables (7)
AdminUser
- AdminID — SERIAL — Primary key — NOT NULL
- Username — VARCHAR(50)
- Password — VARCHAR(100)
- Role — VARCHAR(20)
- LastLogin — TIMESTAMP
AuditLog (CopyOfAdminUser)
- AuditID — SERIAL — Primary key — NOT NULL
- AdminID — SERIAL — Foreign key → AdminUser.AdminID — NOT NULL
- Action — VARCHAR(20)
- TableName — VARCHAR(20)
- RecordID — INT
- ActionDate — DATE
Customer
- CustomerID — SERIAL — Primary key — NOT NULL
- Name — VARCHAR(100)
- Email — VARCHAR(100)
- PhoneNumber — VARCHAR(20)
- Address — TEXT
- RegistrationDate — DATE
Item
- ItemID — SERIAL — Primary key — NOT NULL
- ItemName — VARCHAR(100)
- Category — VARCHAR(50)
- Description — TEXT
- UnitPrice — DECIMAL(10, 2)
- SellPrice — DECIMAL(10, 2)
- StockQuantity — INT
Order
- OrderID — SERIAL — Primary key — NOT NULL
- CustomerID — SERIAL — Foreign key → Customer.CustomerID — NOT NULL
- OrderDate — DATE
- TotalAmount — DECIMAL(10, 2)
- Status — VARCHAR(20)
- IsPrepaid — BOOLEAN
- PrepaidAmount — DECIMAL(10,2)
- OutstandingAmount — DECIMAL(10,20)
OrderDetails
- OrderDetailID — SERIAL — Primary key — NOT NULL
- OrderID — SERIAL — Foreign key → Order.OrderID — NOT NULL
- ItemID — SERIAL — Foreign key → Item.ItemID — NOT NULL
- Quantity — INT
- UnitPrice — DECIMAL(10, 2)
- TotalPrice — DECIMAL(10, 2)
Payment
- PaymentID — SERIAL — Primary key — NOT NULL
- OrderID — SERIAL — Foreign key → Order.OrderID — NOT NULL
- PaymentDate — DATE
- PaymentAmount — DECIMAL(10, 2)
- PaymentMethod — VARCHAR(50)
- PaymentType — VARCHAR(10)
- IsFinalPayment — BOOLEAN