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