marketkurly

Tables (3)

Cart (장바구니)

  • cid (고유값) — bigint — Primary key — NOT NULL
  • count (주문 수량) — int
  • pid (고유값2) — bigint — Foreign key → Prodcut.pid — NOT NULL
  • uid (고유값3) — bigint — Foreign key → User.uid — NOT NULL

Prodcut (상품)

  • pid (고유값) — bigint — Primary key — NOT NULL
  • title (상품명) — varchar
  • 상품가격 (price) — int
  • 상품설명 (subtext) — varchar
  • img (상품이미지) — varchar

User (회원)

  • uid (고유값) — bigint — Primary key — NOT NULL
  • username (유저아이디) — varchar
  • password (비밀번호) — varchar
  • email (이메일) — varchar