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