Project

Tables (12)

File (productFile)

  • productNum — int — Foreign key → product.productNum — NOT NULL
  • fileSave_dir (productFIleName) — varchar(100) — NOT NULL
  • fileName (productFileSIze) — varchar(100) — NOT NULL
  • fileType (productFilePath) — varchar(100) — NOT NULL
  • Key (productFileThName) — varchar(100) — NOT NULL

Untitled (styleFile)

  • styleNum — int — Foreign key → style.styleNum — NOT NULL
  • Key (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
  • productNum — int — Foreign key → product.productNum — NOT NULL
  • userEmail — varchar(100) — Foreign key → user.userEmail — NOT NULL

Untitled (styleComment)

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

Untitled (buyList)

  • Key (buyListNum) — int — Primary key — NOT NULL
  • Field (buyListRegDate) — varchar(100) — NOT NULL
  • userEmail — varchar(100) — Foreign key → user.userEmail — NOT NULL
  • productNum — int — Foreign key → product.productNum — NOT NULL
  • Field

Untitled (buyListDetail)

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

comment (productComment)

  • commentNum (productCommentNum) — int — Primary key — NOT NULL
  • Key (productCommentTitle) — varchar(1000) — NOT NULL
  • commentContent (productCommentContent) — varchar(100) — NOT NULL
  • commentReg_date (productCommentRegDate) — varchar(100) — NOT NULL
  • commentProductNum (productNum) — varchar(100) — Foreign key → product.productNum — NOT NULL
  • userEmail — varchar(100) — Foreign key → user.userEmail — NOT NULL

product

  • productNum — int — Primary key — NOT NULL
  • productName — varchar(100) — NOT NULL
  • productPrice — int — NOT NULL
  • productBrand — varchar(100) — NOT NULL
  • Key (productSize) — int — NOT NULL

productInterest (wishList)

  • Key (wishListNum) — int — Primary key — NOT NULL
  • productNum — int — Foreign key → product.productNum — NOT NULL
  • userEmail — varchar(100) — Foreign key → user.userEmail — NOT NULL
  • commentNum (productCommentNum) — int — Foreign key → comment.commentNum — NOT NULL

profile

  • userEmail — varchar(100) — Foreign key → user.userEmail — NOT NULL
  • profileName — varchar(100) — NOT NULL
  • proflieSize (profileSize) — varchar(100) — NOT NULL
  • profilePath — varchar(100) — NOT NULL

style

  • styleNum — int — Primary key — NOT NULL
  • productNum — int — Foreign key → product.productNum — NOT NULL
  • userEmail — varchar(100) — Foreign key → user.userEmail — NOT NULL
  • styleTitle (styleContent) — varchar(100) — NOT NULL
  • styleReg_date (styleRegDate) — varchar(100) — NOT NULL
  • styleCount — int — NOT NULL

user

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