assignment ERD
Tables (11)
Category
- CategoryID — INT — Primary key
- Name — VARCHAR(255)
- ParentCategoryID — INT
Customer
- CustomerID — INT — Primary key
- Name — VARCHAR(255)
- Email — VARCHAR(255)
- Address — VARCHAR(255)
Order
- OrderID — INT — Primary key
- CustomerID — INT — Foreign key → Customer.CustomerID
- ListingID — INT — Foreign key → ProductListing.ListingID
- OrderDate — DATE
- OrderStatus — VARCHAR(50)
OrderDetail
- DetailID — INT — Primary key
- OrderID — INT — Foreign key → Order.OrderID
- OptionID — INT — Foreign key → ProductOption.OptionID
- Quantity — INT
- OrderPrice — DECIMAL
Payment
- PaymentID — INT — Primary key
- OrderID — INT — Foreign key → Order.OrderID
- PaymentDate — DATE
- Amount — DECIMAL
- PaymentStatus — VARCHAR(50)
Product
- ProductID — INT — Primary key
- SellerID — INT — Foreign key → Seller.SellerID
- CategoryID — INT — Foreign key → Category.CategoryID
- Name — VARCHAR(255)
- Description — TEXT
- Price — DECIMAL(10, 2)
- Stock — INT
ProductListing
- ListingID — INT — Primary key
- SellerID — INT — Foreign key → Seller.SellerID
- ProductID — INT — Foreign key → Product.ProductID
- ListingDate — DATE
ProductOption
- OptionID — INT — Primary key
- ProductID — INT — Foreign key → Product.ProductID
- OptionName — VARCHAR(255)
- PriceAdjustment — DECIMAL(10, 2)
- Stock — INT
ProductReview
- ReviewID — INT — Primary key
- CustomerID — INT — Foreign key → Customer.CustomerID
- ProductID — INT — Foreign key → Product.ProductID
- Rating — INT
- ReviewText — TEXT
- Date — DATE
Seller
- SellerID — INT — Primary key
- BusinessName — VARCHAR(255)
- Email — VARCHAR(255)
- Address — VARCHAR(255)
Shipping
- ShippingID — INT — Primary key
- OrderID — INT — Foreign key → Order.OrderID
- ShippingDate — DATE
- ShippingAddress — VARCHAR(255)
- ShipmentStatus — VARCHAR(50)
- Company — VARCHAR