S4L V2 Database ERD
Tables (11)
Account
- AccountID — INT
- Name — VARCHAR(255) — NOT NULL
- Address — TEXT
Customer
- CustomerID — INT
- AccountID — INT — NOT NULL
- Name — VARCHAR(255) — NOT NULL
- Contact — VARCHAR(100)
- Address — TEXT
Order
- OrderID — INT
- AccountID — INT — NOT NULL
- OrderDate — DATE — NOT NULL
- Status — VARCHAR(50) — NOT NULL
- TotalAmount — DECIMAL(10, 2) — NOT NULL
- CustomerID — INT
OrderItem
- OrderItemID — INT
- OrderID — INT
- ProductID — INT
- Quantity — INT — NOT NULL
Payment
- PaymentID — INT
- AccountID — INT — NOT NULL
- OrderID — INT
- Amount — DECIMAL(10, 2) — NOT NULL
- PaymentDate — DATE — NOT NULL
Product
- ProductID — INT
- AccountID — INT — NOT NULL
- Name — VARCHAR(255) — NOT NULL
- Description — TEXT
- Price — DECIMAL(10, 2) — NOT NULL
ProductWarehouse
- ProductID — INT
- WarehouseID — INT
- Quantity — INT — NOT NULL
Shipping
- ShippingID — INT
- AccountID — INT — NOT NULL
- OrderID — INT
- ShippingDate — DATE — NOT NULL
- Address — TEXT — NOT NULL
Supplier
- SupplierID — INT
- AccountID — INT — NOT NULL
- Name — VARCHAR(255) — NOT NULL
- Contact — VARCHAR(100)
- Address — TEXT
User
- UserID — INT
- AccountID — INT — NOT NULL
- Username — VARCHAR(50) — NOT NULL
- Password — VARCHAR(255) — NOT NULL
- Email — VARCHAR(100) — NOT NULL
Warehouse
- WarehouseID — INT
- AccountID — INT — NOT NULL
- Name — VARCHAR(255) — NOT NULL
- Location — TEXT