assignment
Tables (10)
Category
- CategoryID — INT — Primary key
- Name — VARCHAR(255)
- ParentCategoryID — INT
Customer
- CustomerID — INT — Primary key
- Name — VARCHAR(255)
- Email — VARCHAR(255)
- Address — VARCHAR(255)
OrderDetail
- DetailID — INT
- OrderID — INT
- OptionID — INT
- Quantity — INT
Payment
- PaymentID — INT
- OrderID — INT
- PaymentDate — DATE
- Amount — DECIMAL(10, 2)
- Status — VARCHAR(50)
Product
- ProductID — INT — Primary key
- Name — VARCHAR(255)
- Description — TEXT
- Price — DECIMAL(10, 2)
ProductListing
- ListingID — INT — Primary key
- SellerID — INT
- ProductID — INT
- ListingDate — DATE
ProductOption
- OptionID — INT — Primary key
- ProductID — INT
- OptionName — VARCHAR(255)
- PriceAdjustment — DECIMAL(10, 2)
ProductReview
- ReviewID — INT
- CustomerID — INT
- ProductID — INT
- Rating — INT
- ReviewText — TEXT
Seller
- SellerID — INT
- BusinessName — VARCHAR(255)
- Email — VARCHAR(255)
- Address — VARCHAR(255)
Shipping
- ShippingID — INT
- OrderID — INT
- ShippingDate — DATE
- ShippingAddress — VARCHAR(255)
- Status — VARCHAR(50)