formypet
Tables (6)
Board (Untitled4)
- (Key) — Primary key — NOT NULL
- Field
- Field2
- Field3
- Field4
- Field5
- Field6
Cart (장바구니)
- cartPk (id) — long — Primary key — NOT NULL — auto increament
- userPk (id2) — long — Foreign key → User.userPk — NOT NULL — auto increament
- cartPk (id22) — long — Foreign key → User.cartPk — NOT NULL — auto increament
- 상품총가격 (cartTotlePrice) — string — NOT NULL
- 상품총수량 (cartTotalQty) — string — NOT NULL
CartItem (상품장바구니연결)
- cartItemPk (id) — long — Primary key — NOT NULL — auto increament
- productPk (id2) — long — Foreign key → Product.productPk — NOT NULL — auto increament
- cartPk (id3) — long — Foreign key → Cart.cartPk — NOT NULL — auto increament
- cartPk (id22) — long — Foreign key → Cart.cartPk — NOT NULL — auto increament
- 상품개수 (cartItemQty) — string — NOT NULL
Product (상품)
- productPk (id) — long — Primary key — NOT NULL — auto increament
- 상품이름 (productName) — string — NOT NULL
- 상품설명 (productContents) — string — NOT NULL
- 동물타입 (productAnimalType) — string — NOT NULL
- 상품카테고리 (productCategory) — string — NOT NULL
- 상품가격 (productPrice) — string — NOT NULL
- 상품이미지 (productImage) — stirng — NOT NULL — /productimg/....
- 상품조회수 (productReadCount) — int — NOT NULL — auto increament
ProductReply (상품댓글)
- productReplyPk (Key) — Primary key — NOT NULL — auto increament
- userPk (id) — long — Foreign key → User.userPk — NOT NULL — auto increament
- productPk (id3) — long — Foreign key → Product.productPk — NOT NULL — auto increament
- cartPk (id2) — long — Foreign key → User.cartPk — NOT NULL — auto increament
- 상품댓글제목 (productRepplyTitle) — string — NOT NULL
- 상품댓글내용 (productReplycontent) — string — NOT NULL
- 상품댓글작성시간 (createDateTime) — date — NOT NULL — date
User (유저)
- userPk (id) — long — Primary key — NOT NULL — auto increament
- cartPk (id2) — long — Foreign key → Cart.cartPk — NOT NULL — auto increament
- 아이디 (userId) — string — NOT NULL
- 비밀번호 (userPassword) — string — NOT NULL
- 이름 (userName) — string — NOT NULL
- 주소 (userAddress) — string — NOT NULL
- 상세주소 (userDetail) — string — NOT NULL
- 생년월일 (userBirthDate) — date — NOT NULL — 8letter