shop

Tables (6)

Customer

  • CustomerID — INT
  • Name — VARCHAR(255)
  • Contact — VARCHAR(20)
  • RegistrationDate — DATE

Mileage

  • MileageID — INT
  • CustomerID — INT
  • UsedMileage — INT
  • UnusedMileage — INT
  • Month — DATE

PlatformAdmin

  • AdminID — INT
  • Name — VARCHAR(255)
  • RegistrationDate — DATE

Product

  • ProductID — INT
  • Name — VARCHAR(255)
  • Price — DECIMAL(10, 2)
  • EntryDate — DATE
  • ShopID — INT

Purchase

  • PurchaseID — INT
  • PurchaseDate — DATE
  • ProductID — INT
  • CustomerID — INT
  • Quantity — INT

Shop

  • ShopID — INT
  • Name — VARCHAR(255)
  • EntryDate — DATE
  • Contact — VARCHAR(20)
  • 2) — DEFAULT
  • PlatformFee — DECIMAL(15, 2)