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