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