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