종합설계1

테이블 (12)

brand

  • brand_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(255)

product

  • product_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(255)
  • brand_id — BIGINT — 외래 키 → brand.brand_id
  • category — VARCHAR(255)
  • image_url — VARCHAR(255)
  • created_at — DATETIME

product_embedding

  • product_id — BIGINT — 외래 키 → product.product_id — NOT NULL
  • embedding_vector — VARCHAR(255)
  • updated_at — DATETIME

product_feature

  • feature_id — BIGINT — 기본 키 — NOT NULL
  • product_id — BIGINT — 외래 키 → product.product_id
  • skin_type — VARCHAR(255)
  • skin_concern — VARCHAR(255)
  • coverage — VARCHAR(255)
  • finish — VARCHAR(255)
  • ingredient — VARCHAR(255)
  • feature_json — JSON

product_insight

  • insight_id — BIGINT — 기본 키 — NOT NULL
  • product_id — BIGINT — 외래 키 → product.product_id
  • price — INT
  • rating — FLOAT
  • review_count — INT
  • review_summary — TEXT
  • last_updated — DATETIME

review

  • review_id — BIGINT — 기본 키 — NOT NULL
  • product_id — BIGINT — 외래 키 → product.product_id
  • content — TEXT
  • rating — FLOAT
  • source — VARCHAR(255)
  • created_at — DATETIME

review_embedding

  • review_id — BIGINT — 외래 키 → review.review_id — NOT NULL
  • embedding_vector — VARCHAR(255)

user_brand_preference

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.user_id
  • brand_id — BIGINT — 외래 키 → brand.brand_id

user_context_rag

  • rag_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.user_id
  • content — TEXT
  • embedding_vector — VARCHAR(255)
  • created_at — DATETIME

user_product

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.user_id
  • product_id — BIGINT — 외래 키 → product.product_id
  • usage_type — VARCHAR(255)
  • rating — FLOAT
  • created_at — DATETIME

user_profile

  • user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • personal_color — VARCHAR(255)
  • skin_type — VARCHAR(255)
  • skin_concern — VARCHAR(255)
  • updated_at — DATETIME

users

  • user_id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(255)
  • name — VARCHAR(255)
  • nickname — VARCHAR(255)
  • created_at — DATETIME