온라인 스토어

테이블 (11)

Untitled (user)

  • Key (id) — 기본 키 — NOT NULL
  • Field (loginId)
  • Field2 (password)
  • Field (name)
  • Field (phoneNumber)
  • Field (email)
  • Field (createdAt)
  • Field (updatedAt)

Untitled (address)

  • Key (id) — 기본 키 — NOT NULL
  • Key (userId) — 외래 키 → Untitled.Key — NOT NULL
  • Field (recipient)
  • Field (shippingAddress)
  • Field (zipcode)
  • Field (adadress1)
  • Field (address2)
  • Field (phoneNumber)
  • Field (createdAt)
  • Field (updatedAt)

Untitled (product)

  • Key (id) — 기본 키 — NOT NULL
  • Field (productName)
  • Field (price)
  • Field (category)
  • Field (content)
  • Field (imagePath)
  • Field (exposure)
  • Field (createdAt)
  • Field (updatedAt)

Untitled (stock)

  • Key (id) — 기본 키 — NOT NULL
  • Key (productId) — 외래 키 → Untitled.Key — NOT NULL
  • Field (size)
  • Field (quantity)
  • Field (createdAt)
  • Field (updatedAt)

Untitled (product_image)

  • Key (id) — 기본 키 — NOT NULL
  • Key (productId) — 외래 키 → Untitled.Key — NOT NULL
  • Field (imagePath)
  • Field (createdAt)

Untitled (order)

  • Key (id) — 기본 키 — NOT NULL
  • Key (userId) — 외래 키 → Untitled.Key — NOT NULL
  • Field (orderNumber)
  • Field (recipient)
  • Field (zipcode)
  • Field (address1)
  • Field (address2)
  • Field (phoneNumber)
  • Field (createdAt)
  • Field (updatedAt)

Untitled (order_item)

  • Key (id) — 기본 키 — NOT NULL
  • Key (orderId) — 외래 키 → Untitled.Key — NOT NULL
  • Key (stockId) — 외래 키 → Untitled.Key — NOT NULL
  • Field (productId)
  • Field (count)
  • Field (totalPrice)
  • Field (state)
  • Field (createdAt)
  • Field (updatedAt)

Untitled (cart)

  • Key (id) — 기본 키 — NOT NULL
  • Key (userId) — 외래 키 → Untitled.Key — NOT NULL
  • Key (stockId) — 외래 키 → Untitled.Key — NOT NULL
  • Field (productId)
  • Field (count)
  • Field (createdAt)
  • Field (updatedAt)

Untitled (review)

  • Key (orderItemId) — 외래 키 → Untitled.Key — NOT NULL
  • Key (userId) — 외래 키 → Untitled.Key — NOT NULL
  • Field (userName)
  • Field (productId)
  • Field (point)
  • Field (content)
  • Field (createdAt)
  • Field (updatedAt)

Untitled (qna)

  • Key (id) — 기본 키 — NOT NULL
  • Key (userId) — 외래 키 → Untitled.Key — NOT NULL
  • Field (userName)
  • Field (subject)
  • Field (content)
  • Field (secret)
  • Field (createdAt)
  • Field (updatedAt)
  • Field (reply)

Untitled (notice)

  • Key (id) — 기본 키 — NOT NULL
  • Field (subject)
  • Field (content)
  • Field (createdAt)
  • Field (updatedAt)