talkmarket

Tables (3)

Product (Untitled)

  • 제품 ID (id) — INT — Primary key — NOT NULL
  • 제품명 (name) — INT — NOT NULL
  • 가격 (price) — INT — NOT NULL
  • 설명 (destription) — TEXT — NOT NULL

chat_message (Untitled3)

  • 메시지 ID (message_id) — INT — Primary key — NOT NULL
  • 채팅방 ID (room_id) — INT — Foreign key → chat_room.채팅방 ID — NOT NULL
  • 제품 ID (id2) — INT — Foreign key → chat_room.제품 ID — NOT NULL
  • 보낸 사람 (sender) — INT — NOT NULL
  • 메시지 내용 (content) — TEXT — NOT NULL
  • 메시지 타입 (type) — VARCHAR — NOT NULL
  • 선택 옵션 (selected_option) — VARCHAR — NOT NULL
  • 보낸시간 (timestamp) — DATETIME

chat_room (Untitled2)

  • 채팅방 ID (room_id) — INT — Primary key — NOT NULL
  • 제품 ID (id2) — INT — Foreign key → Product.제품 ID — NOT NULL