ustora

Tables (7)

address (Untitled)

  • id (Key) — Primary key — NOT NULL
  • isDefault (Field)
  • shippingAddress1 (Field2)
  • shippingAddress2 (Field3)
  • shippingCity (Field4)
  • shippingCompany (Field5)
  • shippingCountry (Field6)
  • shippingFirstName (Field7)
  • shippingLastName (Field8)
  • shippingState (Field9)
  • email (Key2) — Foreign key → users.email — NOT NULL

cart (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • id (Key2) — Foreign key → address.id — NOT NULL
  • pid (Key3) — Foreign key → product.pid — NOT NULL
  • quantity (Field)
  • totalprice (Field2)

comment (Untitled7)

  • id (Key) — Primary key — NOT NULL
  • content (Field)
  • createAt (Field2)
  • nickname (Field3)
  • pid (Key2) — Foreign key → product.pid — NOT NULL
  • email (Key3) — Foreign key → users.email — NOT NULL

orderDetail (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • priceAtOrder (Field)
  • quantity (Field2)
  • id (Key2) — Foreign key → orders.id — NOT NULL
  • pid (Key3) — Foreign key → product.pid — NOT NULL

orders (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • currencyCode (Field)
  • orderDate (Field2)
  • id (Key2) — Foreign key → address.id — NOT NULL

product (Untitled3)

  • pid (Key) — Primary key — NOT NULL
  • author (Field)
  • brand (Field2)
  • pname (Field3)
  • price (Field4)
  • category1 (Field5)
  • category2 (Field6)

users (Untitled2)

  • email (Key) — Primary key — NOT NULL
  • name (Field)
  • password (Field2)