중고거래 최신

테이블 (8)

ChatMessage

  • message_num — INT — 기본 키 — NOT NULL
  • chat_room_num — INT — 외래 키 → ChatRoom.chat_room_num — NOT NULL
  • sender_num — INT — NOT NULL
  • message — TEXT — NOT NULL
  • timestamp — DATETIME — NOT NULL

ChatRoom

  • chat_room_num — INT — 기본 키 — NOT NULL
  • seller_num — INT — 외래 키 → Member.member_num — NOT NULL
  • buyer_num — INT — 외래 키 → Member.member_num — NOT NULL

Main_Category

  • main_category_num — INT — 기본 키 — NOT NULL
  • main_category_name — VARCHAR(255) — NOT NULL

Member

  • member_num — INT — 기본 키 — NOT NULL
  • member_name — VARCHAR(255) — NOT NULL
  • member_email — VARCHAR(255) — NOT NULL
  • member_id — VARCHAR(255) — NOT NULL
  • member_password — VARCHAR(255) — NOT NULL
  • member_tel — VARCHAR(255) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • state — INT

Product

  • product_num — INT — 기본 키 — NOT NULL
  • member_num — INT — 외래 키 → Member.member_num — NOT NULL
  • main_category_num — INT — 외래 키 → Main_Category.main_category_num — NOT NULL
  • product_name — VARCHAR(255) — NOT NULL
  • price — INT — NOT NULL
  • product_description — VARCHAR(255) — NOT NULL
  • product_condition — VARCHAR(255) — NOT NULL
  • product_status — VARCHAR(255) — NOT NULL — 판매중, 예약중, 판매완료 등

ProductImage

  • image_num — INT — 기본 키 — NOT NULL
  • product_num — INT — 외래 키 → Product.product_num — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • image_sequence — INT — NOT NULL — 상품 이미지 순서

Rating

  • rating_num — INT — 기본 키 — NOT NULL
  • rated_member_num — INT — 외래 키 → Member.member_num — NOT NULL
  • rating_member_num — INT — 외래 키 → Member.member_num — NOT NULL
  • rating — INT — NOT NULL
  • rating_comment — VARCHAR(255)
  • rating_date — DATETIME — NOT NULL

Transaction

  • transaction_num — INT — 기본 키 — NOT NULL
  • seller_num — INT — 외래 키 → Member.member_num — NOT NULL
  • buyer_num — INT — 외래 키 → Member.member_num — NOT NULL
  • product_num — INT — 외래 키 → Product.product_num — NOT NULL
  • transaction_date — DATETIME — NOT NULL
  • transaction_status — VARCHAR(255) — NOT NULL — 진행중, 완료, 취소 등