더마렌즈
테이블 (40)
AllergyMaster
- allergy_id — INT
- allergy_name_kr — VARCHAR(100) — NOT NULL
- allergy_name_en — VARCHAR(100)
- description — TEXT
- is_active — TINYINT(1) — NOT NULL
AnalysisResult
- analysis_id — INT
- user_id — INT — 외래 키 → User.user_id — NOT NULL
- product_id — INT — 외래 키 → Product.product_id
- ocr_image_id — INT — 외래 키 → OCRImage.ocr_image_id
- analysis_type — VARCHAR(100)
- risk_score — DOUBLE
- summary — TEXT
- product_name — VARCHAR(300)
- capacity — VARCHAR(100)
- usage — JSON
- cautions — JSON
- effects — JSON
- created_at — DATETIME — NOT NULL
Brand
- brand_id — INT
- brand_name_kr — VARCHAR(255) — NOT NULL
- brand_name_en — VARCHAR(255)
- country — VARCHAR(100)
- is_active — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
Category
- category_id — INT
- category_name — VARCHAR(100) — NOT NULL
- depth — INT
- parent_id — INT — 외래 키 → Category.category_id
ChatMessage
- message_id — INT
- session_id — INT — 외래 키 → ChatSession.session_id — NOT NULL
- user_id — INT — 외래 키 → User.user_id — NOT NULL
- message_type — VARCHAR(20) — NOT NULL
- content — TEXT — NOT NULL
- intent — VARCHAR(50)
- related_product_id — INT — 외래 키 → Product.product_id
- related_ingredient_id — INT — 외래 키 → Ingredient.ingredient_id
- created_at — DATETIME — NOT NULL
ChatSession
- session_id — INT
- user_id — INT — 외래 키 → User.user_id — NOT NULL
- created_at — DATETIME — NOT NULL
- ended_at — DATETIME
DataSyncHistory
- sync_id — INT
- source_id — INT — 외래 키 → ExternalSource.source_id — NOT NULL
- inserted_count — INT
- updated_count — INT
ExternalSource
- source_id — INT
- source_name — VARCHAR(255) — NOT NULL
- api_url — TEXT — NOT NULL
Feedback
- feedback_id — INT
- user_id — INT — 외래 키 → User.user_id — NOT NULL
- product_id — INT — 외래 키 → Product.product_id
- feedback_type — VARCHAR(50) — NOT NULL
- satisfaction_score — INT
- side_effect_text — TEXT
- created_at — DATETIME — NOT NULL
FunctionMaster
- function_id — INT
- function_name_kr — VARCHAR(100) — NOT NULL
- function_name_en — VARCHAR(100)
- description — TEXT
- is_active — TINYINT(1) — NOT NULL
Ingredient
- ingredient_id — INT
- ingredient_name_kr — VARCHAR(255) — NOT NULL
- ingredient_name_en — VARCHAR(255)
- risk_level — INT
- allergy_flag — TINYINT(1)
- irritant_flag — TINYINT(1)
- acne_caution_flag — TINYINT(1)
- moisturizing_flag — TINYINT(1)
- soothing_flag — TINYINT(1)
- description — TEXT
- updated_at — DATETIME
IngredientAlias
- alias_id — INT
- ingredient_id — INT — 외래 키 → Ingredient.ingredient_id — NOT NULL
- alias_name — VARCHAR(255) — NOT NULL
- alias_type — VARCHAR(50)
- is_active — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
IngredientFunction
- id — BIGINT
- ingredient_id — INT — 외래 키 → Ingredient.ingredient_id — NOT NULL
- function_id — INT — 외래 키 → FunctionMaster.function_id — NOT NULL
OCRImage
- ocr_image_id — INT
- user_id — INT — 외래 키 → User.user_id — NOT NULL
- product_id — INT — 외래 키 → Product.product_id
- image_url — TEXT — NOT NULL
- image_type — VARCHAR(50)
- uploaded_at — DATETIME — NOT NULL
OCRRawText
- raw_text_id — INT
- ocr_image_id — INT — 외래 키 → OCRImage.ocr_image_id — NOT NULL
- raw_text — TEXT — NOT NULL
- ocr_engine — VARCHAR(100)
- ocr_confidence — DOUBLE
- extracted_at — DATETIME — NOT NULL
OCR_AnalysisDetail
- analysis_detail_id — INT
- analysis_id — INT — 외래 키 → AnalysisResult.analysis_id — NOT NULL
- ingredient_id — INT — 외래 키 → Ingredient.ingredient_id — NOT NULL
- detected_text — TEXT
- risk_contribution — DOUBLE
- caution_reason — TEXT
- match_status — VARCHAR(50)
PointHistory
- history_id — INT
- user_id — INT — 외래 키 → User.user_id — NOT NULL
- points — INT — NOT NULL
- reason — VARCHAR(100) — NOT NULL
- related_product_id — INT
- created_at — DATETIME — NOT NULL
Product
- product_id — INT
- product_name — VARCHAR(255) — NOT NULL
- brand_id — INT — 외래 키 → Brand.brand_id — NOT NULL
- category_id — INT — 외래 키 → Category.category_id — NOT NULL
- texture_id — INT — 외래 키 → TextureMaster.texture_id
- image_url — TEXT
- product_url — TEXT
- volume — VARCHAR(50)
- price — INT
- description — TEXT
- official_ingredient_text — TEXT
- updated_at — DATETIME
ProductIngredient
- id — BIGINT
- product_id — INT — 외래 키 → Product.product_id — NOT NULL
- ingredient_id — INT — 외래 키 → Ingredient.ingredient_id — NOT NULL
ProductIngredientCandidate
- candidate_id — INT
- product_id — INT — 외래 키 → Product.product_id — NOT NULL
- ingredient_id — INT — 외래 키 → Ingredient.ingredient_id — NOT NULL
- detection_count — INT — NOT NULL
- confirmed — TINYINT(1) — NOT NULL
- updated_at — DATETIME — NOT NULL
ProductLike
- id — BIGINT
- user_id — INT — 외래 키 → User.user_id — NOT NULL
- product_id — INT — 외래 키 → Product.product_id — NOT NULL
- created_at — DATETIME — NOT NULL
ProductScanContribution
- contribution_id — INT
- user_id — INT — 외래 키 → User.user_id — NOT NULL
- product_id — INT — 외래 키 → Product.product_id — NOT NULL
- image_url — TEXT
- detected_count — INT — NOT NULL
- reward_points — INT — NOT NULL
- is_first — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
ProductView
- view_id — INT
- user_id — INT — 외래 키 → User.user_id — NOT NULL
- product_id — INT — 외래 키 → Product.product_id — NOT NULL
- viewed_at — DATETIME — NOT NULL
Recommendation
- recommendation_id — INT
- user_id — INT — 외래 키 → User.user_id — NOT NULL
- product_id — INT — 외래 키 → Product.product_id — NOT NULL
- score — DOUBLE — NOT NULL
- reason — TEXT
- rank_order — INT
- created_at — DATETIME — NOT NULL
Review
- review_id — INT
- user_id — INT — 외래 키 → User.user_id — NOT NULL
- product_id — INT — 외래 키 → Product.product_id — NOT NULL
- rating — INT — NOT NULL
- review_text — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
ReviewImage
- image_id — INT
- review_id — INT — 외래 키 → Review.review_id — NOT NULL
- image_url — TEXT — NOT NULL
- order — INT — NOT NULL
- created_at — DATETIME — NOT NULL
SearchLog
- search_id — INT
- user_id — INT — 외래 키 → User.user_id — NOT NULL
- keyword — VARCHAR(255) — NOT NULL
- clicked_product_id — INT — 외래 키 → Product.product_id
- created_at — DATETIME — NOT NULL
SkinConcernMaster
- concern_id — INT
- concern_name_kr — VARCHAR(100) — NOT NULL
- concern_name_en — VARCHAR(100)
- description — TEXT
- is_active — TINYINT(1) — NOT NULL
SkinTypeMaster
- skin_type_id — INT
- skin_type_code — VARCHAR(10) — NOT NULL
- skin_type_name_kr — VARCHAR(100) — NOT NULL
- skin_type_name_en — VARCHAR(100)
- description — TEXT
- is_active — TINYINT(1) — NOT NULL
SurveyOption
- option_id — INT
- question_id — INT — 외래 키 → SurveyQuestion.question_id — NOT NULL
- option_text — VARCHAR(100) — NOT NULL
- score_value — INT — NOT NULL
- score_field — VARCHAR(50) — NOT NULL
SurveyQuestion
- question_id — INT
- survey_type — VARCHAR(50) — NOT NULL
- question_text — VARCHAR(255) — NOT NULL
- save_table — VARCHAR(100)
- linked_master — VARCHAR(100)
- score_field — VARCHAR(100)
SurveyResponse
- response_id — INT
- user_id — INT — 외래 키 → User.user_id — NOT NULL
- answers_json — JSON — NOT NULL
- created_at — DATETIME — NOT NULL
TextureMaster
- texture_id — INT
- texture_name_kr — VARCHAR(100) — NOT NULL
- texture_name_en — VARCHAR(100)
- description — TEXT
- is_active — TINYINT(1) — NOT NULL
User
- user_id — INT
- email — VARCHAR(254) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(100) — NOT NULL
- kakao_id — VARCHAR(100)
- is_active — TINYINT(1) — NOT NULL
- is_staff — TINYINT(1) — NOT NULL
- points — INT — NOT NULL
- created_at — DATETIME — NOT NULL
UserAllergy
- id — BIGINT
- user_id — INT — 외래 키 → User.user_id — NOT NULL
- allergy_id — INT — 외래 키 → AllergyMaster.allergy_id — NOT NULL
UserNotification
- notification_id — INT
- user_id — INT — 외래 키 → User.user_id — NOT NULL
- type — VARCHAR(50) — NOT NULL
- message — VARCHAR(255) — NOT NULL
- is_read — TINYINT(1) — NOT NULL
- related_id — INT
- created_at — DATETIME — NOT NULL
UserRoutine
- routine_id — INT
- user_id — INT — 외래 키 → User.user_id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- is_public — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
UserRoutineStep
- step_id — INT
- routine_id — INT — 외래 키 → UserRoutine.routine_id — NOT NULL
- product_id — INT — 외래 키 → Product.product_id
- product_name_custom — VARCHAR(200)
- step_order — INT — NOT NULL
- memo — TEXT
UserSkinConcern
- id — BIGINT
- user_id — INT — 외래 키 → User.user_id — NOT NULL
- concern_id — INT — 외래 키 → SkinConcernMaster.concern_id — NOT NULL
UserSkinProfile
- profile_id — INT
- user_id — INT — 외래 키 → User.user_id — NOT NULL
- skin_type_id — INT — 외래 키 → SkinTypeMaster.skin_type_id
- preferred_texture_id — INT — 외래 키 → TextureMaster.texture_id
- sensitivity_level — INT
- acne_prone_flag — TINYINT(1)
- updated_at — DATETIME