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)