winwin
Tables (3)
products (Untitled2)
- 상품ID (productId) — bigint(20) — Primary key — NOT NULL
- 상품명 (name) — vachar(30) — NOT NULL
- 가격 (price) — int(11) — NOT NULL
- 상품설명 (content) — vachar(255)
trades (Untitled3)
- 거래ID (tradeId) — bigint(20) — Primary key — NOT NULL
- 회원ID (userId) — bigint(20) — Foreign key → users.회원ID — NOT NULL
- 상품ID (productId) — bigint(20) — Foreign key → products.상품ID — NOT NULL
users (Untitled)
- 회원ID (userId) — bigint(20) — Primary key — NOT NULL
- 이메일 (email) — varchar(100) — NOT NULL
- 비밀번호 (password) — varchar(30) — NOT NULL
- 별명 (nickname) — varchar(20) — NOT NULL