shppoing

Tables (4)

Basket (Untitled3)

  • basketId (Key) — Primary key — NOT NULL
  • userId (Key2) — Foreign key → User.userId — NOT NULL
  • productId (Key3) — Foreign key → Product.productId — NOT NULL
  • userId (Field)
  • productId (Field2)
  • productCount (Field3)
  • validity (Field4)

Payment (Untitled4)

  • paymentId (Key) — Primary key — NOT NULL
  • userId (Key2) — Foreign key → User.userId — NOT NULL
  • productId (Key3) — Foreign key → Product.productId — NOT NULL
  • totalCount (Field2)
  • totalPrice (Field3)
  • address (Field4)
  • contact (Field5)
  • ccNumber (Field6)
  • ccExpiration (Field7)
  • ccPassword (Field8)
  • Field9

Product (Untitled2)

  • productId (Key) — Primary key — NOT NULL
  • productType (Field)
  • productName (Field2)
  • description (Field3)
  • price (Field4)
  • inventory (Field5)

User (Untitled)

  • userId (Key) — Primary key — NOT NULL
  • userType (Field)
  • userName (Field2)
  • password (Field3)
  • email (Field4)
  • contact (Field5)
  • address (Field6)