GreenCloset_ERD

Tables (6)

Chat_Messages

  • messang_id (기본키(채팅메시지번호)) — Primary key — NOT NULL
  • room_id (기본키(채팅방번호)) — BIGINT — Foreign key → Chat_rooms.room_id — NOT NULL
  • sender_id (기본키(회원고유번호)) — BIGINT — Foreign key → Users.user_id — NOT NULL
  • content (메시지내용) — TEXT
  • sent_at (메시지전송일) — DATETIME — NOT NULL

Chat_rooms

  • room_id (기본키(채팅방번호)) — BIGINT — Primary key — NOT NULL
  • buyer_id (기본키(회원고유번호)) — BIGINT — Foreign key → Users.user_id — NOT NULL
  • product_id (기본키(상품번호)) — BIGINT — Foreign key → Products.product_id — NOT NULL
  • created_at (채팅방생성일) — DATETIME — NOT NULL

Product_images

  • image_id (기본키(이미지번호)) — BIGINT — Primary key — NOT NULL
  • product_id (기본키(상품번호)) — BIGINT — Foreign key → Products.product_id — NOT NULL
  • image_url (이미지URL) — VARCHAR(500) — NOT NULL

Products

  • product_id (기본키(상품번호)) — BIGINT — Primary key — NOT NULL
  • user_id (기본키(회원고유번호)) — BIGINT — Foreign key → Users.user_id — NOT NULL
  • title (상품명(제목)) — VARCHAR(255) — NOT NULL
  • content (상세정보(자율입력)) — TEXT
  • created_at (등록일) — DATETIME — NOT NULL
  • updated_at (수정일) — DATETIME — NOT NULL

Trades

  • trade_id (기본키(교환번호)) — BIGINT — Primary key — NOT NULL
  • buyer_id (기본키(회원고유번호)) — BIGINT — Foreign key → Users.user_id — NOT NULL
  • product_id (기본키(상품번호)) — BIGINT — Foreign key → Products.product_id — NOT NULL
  • completed_at (교환완료일) — DATETIME — NOT NULL

Users

  • user_id (기본키(회원고유번호)) — BIGINT — Primary key — NOT NULL
  • email (이메일(자체회원가입시사용)) — VARCHAR(255) — NOT NULL
  • password (비밀번호(암호화하여저장)) — VARCHAR(255) — NOT NULL
  • nickname (닉네임) — VARCHAR(50) — NOT NULL
  • profile_image_url (프로필사진URL) — VARCHAR(500) — NOT NULL
  • introduction (자기소개) — TEXT
  • created_at (가입일) — DATETIME — NOT NULL
  • provider_id (소셜아이디) — BIGINT — NOT NULL
  • provider (소셜로그인제공자) — VARCHAR(20) — NOT NULL