더마렌즈

테이블 (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