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