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