Treen

Tables (7)

Categories (Untitled6)

  • 카테고리ID (id) — Long — Primary key — NOT NULL
  • 카테고리명 (Field) — varchar

ChatContent (Untitled7)

  • msgId — LONG — Primary key — NOT NULL
  • 채팅룸ID (room_id) — Long — Foreign key → ChatRoom.채팅룸ID — NOT NULL
  • createAt — DATETIME
  • updateAt — DATETIME
  • message — varchar

ChatRoom (Untitled5)

  • 채팅룸ID (room_id) — Long — Primary key — NOT NULL
  • 유저1ID (user1_id) — Long — Foreign key → Users.유저ID — NOT NULL
  • 상품ID (id2) — Long — Foreign key → Products.상품ID — NOT NULL
  • 카테고리ID (id22) — Long — Foreign key → Products.카테고리ID — NOT NULL
  • 유저2ID (user2_id) — Long
  • createAt (creatAt) — DATETIME
  • updateAt — DATETIME

Products (Untitled2)

  • 상품ID (id) — Long — Primary key — NOT NULL
  • 카테고리ID (category_id) — Long — Foreign key → Categories.카테고리ID — NOT NULL
  • 상품명 (name) — varchar
  • 사용기간 (used_term) — int
  • 상세 설명 (detail) — TEXT
  • 구매가 (price) — int
  • 사이즈 (size) — int
  • 교환 희망 장소 (trade_spot) — varchar

Trades (Untitled4)

  • 거래ID (id) — Long — Primary key — NOT NULL
  • 상품ID (id2) — Long — Foreign key → Products.상품ID — NOT NULL
  • 카테고리ID (category_id) — Long — Foreign key → Products.카테고리ID — NOT NULL
  • 상태 (status) — enum
  • createAt — DATETIME

Users (Untitled)

  • 유저ID (id) — Long — Primary key — NOT NULL
  • 이메일 (email) — varchar
  • 유저 이름 (user_name) — varchar
  • 상태 (user_status) — enum

Wish_Category (Untitled8)

  • 상품ID (id) — Long — Foreign key → Products.상품ID — NOT NULL
  • 카테고리ID (category_id) — Long — Foreign key → Categories.카테고리ID — NOT NULL