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