shop

Tables (7)

order (Untitled5)

  • orderId (Key) — Primary key — NOT NULL
  • name (Field)
  • userId (Key2) — Foreign key → user.userId — NOT NULL
  • sellerId (Key3) — Foreign key → seller.sellerId — NOT NULL
  • sellerProductId (Key4) — Foreign key → sellerProduct.sellerProductId — NOT NULL
  • payments (Field2)

product (Untitled3)

  • productId (Key) — Primary key — NOT NULL
  • name (Field)
  • description (Field2)
  • price (Field3)
  • count (Field4)

productContents (Untitled7)

  • productContentsId (Key) — Primary key — NOT NULL
  • image (Field)
  • productId (Key2) — Foreign key → product.productId — NOT NULL

productItem (Untitled4)

  • productItemId (Key) — Primary key — NOT NULL
  • name (Field)
  • price (Field2)
  • count (Field3)

seller (Untitled2)

  • sellerId (Key) — Primary key — NOT NULL
  • username (Field)
  • password (Field2)
  • fee (Field3)
  • companynumber (Field4)

sellerProduct (Untitled6)

  • sellerProductId (Key) — Primary key — NOT NULL
  • name (Field)
  • contents (Field2)
  • productId (Key2) — Foreign key → product.productId — NOT NULL
  • link (Field3)
  • publishedAt (Field4)
  • sellerId (Key3) — Foreign key → seller.sellerId — NOT NULL
  • count (Field5)

user (Untitled)

  • userId (Key) — Primary key — NOT NULL
  • username (Field)
  • password (Field2)
  • name (Field3)
  • phone (Field4)