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)