SKN 최종
테이블 (9)
chat_message
- chat_message_id — BIGINT — 기본 키 — NOT NULL
- chat_session_id — BIGINT — 외래 키 → chat_session.chat_session_id — NOT NULL
- sender — ENUM('user','assistant') — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
chat_session
- chat_session_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — NOT NULL
- title — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- user_id2 — BIGINT — NOT NULL
mbti
- mbti_id — CHAR(4) — 기본 키 — NOT NULL
- description — TEXT
mood_tag
- mood_tag_id — INT — 기본 키 — NOT NULL
- mood_name — VARCHAR(64) — NOT NULL
- created_at — DATETIME — NOT NULL
- product_id — BIGINT — NOT NULL
- category_id2 — INT — NOT NULL
- user_id — BIGINT — NOT NULL
product
- product_id — BIGINT — 기본 키 — NOT NULL
- category_id (category_id2) — INT — 외래 키 → product_category.category_id — NOT NULL
- category_id — INT — NOT NULL
- brand_name — VARCHAR(64) — NOT NULL
- product_name — VARCHAR(255) — NOT NULL
- link_url — VARCHAR(1024) — NOT NULL
- image_url — VARCHAR(1024)
- description — TEXT
- price — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- recommendation_id — BIGINT — NOT NULL
product_category
- category_id — INT — 기본 키 — NOT NULL
- category_name — VARCHAR(64) — NOT NULL
recommendation
- recommendation_id — BIGINT — 기본 키 — NOT NULL
- chat_message_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
- note — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- chat_message_id2 — BIGINT — NOT NULL
- chat_session_id — BIGINT — NOT NULL
- chat_message_id (chat_message_id3) — BIGINT — 외래 키 → chat_message.chat_message_id — NOT NULL
- chat_session_id (chat_session_id2) — BIGINT — 외래 키 → chat_message.chat_session_id — NOT NULL
user
- user_id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- birth — DATE — NOT NULL
- gender — ENUM('M','F','U') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- mbti_id — CHAR(4)
wishlist_item
- user_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
- recommendation_id — BIGINT
- created_at — DATETIME — NOT NULL
- recommendation_id2 — BIGINT — NOT NULL
- user_id2 — BIGINT — NOT NULL