종합설계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