talkmarket - 2025-05-26 14:07:27
Tables (3)
Product (Untitled)
- 제품 ID (id) — INT — Primary key — NOT NULL
- 제품명 (name) — INT — NOT NULL
- 가격 (price) — INT — NOT NULL
- 설명 (description) — TEXT — NOT NULL
chat_message (Untitled3)
- 메시지 ID (id) — INT — Primary key — NOT NULL
- 채팅방 ID (id2) — INT — Foreign key — NOT NULL
- 제품 ID (id22) — INT — Foreign key — NOT NULL
- 채팅방 ID (room_id) — INT — NOT NULL
- 보낸사람 (sender) — INT — NOT NULL
- 메시지 내용 (content) — TEXT
- 메시지 타입 (type) — VARCHAR — NOT NULL
- 상품 ID (product_id) — INT
- 선택 옵션 (selectd_option) — VARCHAR
- timestamp (DATETIME) — NOT NULL
chat_room (Untitled2)
- 채팅방 ID (id) — INT — Primary key — NOT NULL
- 제품 ID (id2) — INT — Foreign key — NOT NULL
- 상품 ID (product_id) — INT