shoe_title

Tables (12)

Untitled (user)

  • Key (userEmail) — varchar(100) — Primary key — NOT NULL
  • Field (userPw) — varchar(100) — NOT NULL
  • Field (userName) — varchar(100)
  • Field (userPhone) — varchar(100)
  • Field (userPoint) — int
  • Field (userAddr) — varchar(100)
  • Field (userId) — varchar(100)
  • Field (userPayment) — varchar(100)
  • Field (userIntroduct) — varchar(100)

Untitled (profile)

  • Key (userEmail) — varchar(100) — Foreign key → Untitled.Key — NOT NULL
  • Field (profileName) — varchar(100) — NOT NULL
  • Field (profileSize) — varchar(100) — NOT NULL
  • Field (profilePath) — varchar(100) — NOT NULL

Untitled (style)

  • Key (styleNum) — int — Primary key — NOT NULL
  • Key (productNum) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (userEmail) — varchar(100) — Foreign key → Untitled.Key — NOT NULL
  • Field (styleContent) — varchar(100) — NOT NULL
  • Field (styleReg_date) — varchar(100) — NOT NULL
  • Field (styleCount) — int — NOT NULL

Untitled (styleComment)

  • Key (styleCommentNum) — int — Primary key — NOT NULL
  • Key (styleNum) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (styleCommentRegDate) — varchar(100) — NOT NULL
  • Field (styleCommentContent) — varchar(100) — NOT NULL

Untitled (styleFile)

  • Key (styleNum) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (styleFileName) — varchar(100) — NOT NULL
  • Field (styleFileSize) — varchar(100) — NOT NULL
  • Field (styleFilePath) — varchar(100) — NOT NULL

Untitled (shoppingCart)

  • Key (shoppingCartNum) — int — Primary key — NOT NULL
  • Key (userEmail) — varchar(100) — Foreign key → Untitled.Key — NOT NULL
  • Key (productNum) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (product)

  • Key (productNum) — int — Primary key — NOT NULL
  • Field (proudctName) — varchar(100) — NOT NULL
  • Field (proudctPrice) — int — NOT NULL
  • Field (productBrand) — varchar(100) — NOT NULL
  • Field (productSize) — int — NOT NULL

Untitled (productComment)

  • Key (productCommentNum) — int — Primary key — NOT NULL
  • Key (productNum) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (userEmail) — varchar(100) — Foreign key → Untitled.Key — NOT NULL
  • Field (productCommentTitle) — varchar(100) — NOT NULL
  • Field (productCommentContent) — varchar(100) — NOT NULL
  • Field (productCommentRegdate) — varchar(100) — NOT NULL

Untitled (File)

  • Key (productNum) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (productFileThName) — varchar(100) — NOT NULL
  • Field (productFileName) — varchar(100) — NOT NULL
  • Field (productFileSize) — varchar(100) — NOT NULL
  • Field (productFilePath) — varchar(100) — NOT NULL

Untitled (productInterest)

  • Key (wishListNum) — int — Primary key — NOT NULL
  • Key (productNum) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (userEmail) — varchar(100) — Foreign key → Untitled.Key — NOT NULL

Untitled (buyList)

  • Key (buyListNum) — int — Primary key — NOT NULL
  • Key (userEmail) — varchar(100) — Foreign key → Untitled.Key — NOT NULL
  • Field (buyListRegDate) — varchar(100) — NOT NULL
  • Field (buyListAddr) — varchar(100) — NOT NULL
  • Field

Untitled (buyListDetail)

  • Key (buyListNum) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (productNum) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (buyListStatus) — varchar(100) — NOT NULL