ATEAM ERD 2
Tables (15)
Cart
- CartID — INT
- CustomerID — INT
- ProductID — INT
- Quantity — INT
Category
- CategoryID — INT
- Name — VARCHAR(255)
- Description — TEXT
Coupon
- CouponID — INT
- MallID — INT
- CustomerID — INT
- Code — VARCHAR(255)
- Description — TEXT
- Discount — DECIMAL(5, 2)
- StartDate — DATE
- EndDate — DATE
Customer
- MallID — INT — Foreign key → Mall.MallID
- CustomerID — INT
- Name — VARCHAR(255)
- Email — VARCHAR(255)
- Phone — VARCHAR(20)
- Address — VARCHAR(255)
- City — VARCHAR(255)
- State — VARCHAR(255)
- Country — VARCHAR(255)
- PostalCode — VARCHAR(20)
Employee
- MallID — INT — Foreign key → Mall.MallID
- EmployeeID — INT
- Name — VARCHAR(255)
- Position — VARCHAR(255)
- Salary — DECIMAL(10, 2)
- HireDate — DATE
Event
- EventID — INT
- MallID — INT
- Name — VARCHAR(255)
- Description — TEXT
- EventDate — DATE
Mall
- MallID — INT — Primary key
- Name — VARCHAR(255)
- Address — VARCHAR(255)
- City — VARCHAR(255)
- State — VARCHAR(255)
- Country — VARCHAR(255)
- PostalCode — VARCHAR(20)
OrderItem
- OrderItemID — INT
- OrderID — INT
- ProductID — INT
- Quantity — INT
- Price — DECIMAL(10, 2)
OrderTable
- OrderID — INT
- CustomerID — INT
- OrderDate — DATE
- TotalAmount — DECIMAL(10, 2)
Payment
- PaymentID — INT
- OrderID — INT
- Amount — DECIMAL(10, 2)
- PaymentDate — DATE
- PaymentMethod — VARCHAR(255)
Product
- ProductID — INT
- MallID — INT
- CategoryID — INT
- Name — VARCHAR(255)
- Description — TEXT
- Price — DECIMAL(10, 2)
Purchase
- PurchaseID — INT
- MallID — INT
- ProductID — INT
- Quantity — INT
- PurchaseDate — DATE
Review
- ReviewID — INT
- CustomerID — INT
- ProductID — INT
- Rating — INT
- Comment — TEXT — EX
- ReviewDate — DATE
Shipping
- ShippingID — INT
- OrderID — INT
- ShippingDate — DATE
- ShippingAddress — VARCHAR(255)
- City — VARCHAR(255)
- State — VARCHAR(255)
- Country — VARCHAR(255)
- PostalCode — VARCHAR(20)
Wishlist
- WishlistID — INT
- CustomerID — INT
- ProductID — INT