shaun-sample

Tables (15)

chat_message

  • id — BIGINT
  • user_id — VARCHAR(255) — NOT NULL
  • role — VARCHAR(255) — NOT NULL
  • prompt_type — VARCHAR(255)
  • content — TEXT
  • timestamp — TIMESTAMP(6)

checklists

  • id — INTEGER
  • user_id — VARCHAR(255) — NOT NULL
  • moisture — INTEGER — NOT NULL
  • oil — INTEGER — NOT NULL
  • sensitivity — INTEGER — NOT NULL
  • tension — INTEGER — NOT NULL
  • troubles — VARCHAR(255)
  • created_at — TIMESTAMP(6)

deep_recommend

  • deep_id — INTEGER
  • action — VARCHAR(255)
  • kind — VARCHAR(255)
  • existing_product_id — VARCHAR(255)
  • suggest_product — VARCHAR(255)
  • reason — VARCHAR(255)
  • routine_group_id — BIGINT

formulations

  • id — SMALLINT
  • english_name — VARCHAR(255) — NOT NULL
  • korean_name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMP(6)
  • updated_at — TIMESTAMP(6)
  • deleted_at — TIMESTAMP(6)

ingredients

  • id — INTEGER
  • korean_name — VARCHAR(255) — NOT NULL — 한국어
  • created_at — TIMESTAMP

product_user_link

  • product_id — VARCHAR(255) — Primary key — NOT NULL
  • user_id — VARCHAR(255) — Primary key — NOT NULL

products

  • id — VARCHAR(255)
  • formulation_id — SMALLINT — NOT NULL — 제형
  • ingredient_id_1 — INTEGER — 주요
  • ingredient_id_2 — INTEGER — 주요
  • ingredient_id_3 — INTEGER — 주요
  • ingredient_id_4 — INTEGER — 주요
  • ingredient_id_5 — INTEGER — 주요
  • recommended_type — SMALLINT — NOT NULL — 추천
  • product_name — VARCHAR(255) — NOT NULL
  • image_url — TEXT
  • concern_id_1 — SMALLINT
  • concern_id_2 — SMALLINT
  • concern_id_3 — SMALLINT
  • created_at — TIMESTAMP(6)
  • updated_at — TIMESTAMP(6)
  • deleted_at — TIMESTAMP(6)

routine

  • id — BIGINT
  • name — VARCHAR(255)
  • kind — VARCHAR(255)
  • time — VARCHAR(255)
  • orders — INTEGER
  • method — VARCHAR(255)
  • routine_group_id — BIGINT
  • user_id — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP(6)

routine_change

  • routine_change_id — BIGINT
  • routine_name — VARCHAR(255)
  • routine_kind — VARCHAR(255)
  • routine_time — VARCHAR(255)
  • routine_orders — INTEGER
  • change_method — VARCHAR(255)
  • user_id — VARCHAR(255) — NOT NULL
  • routine_group_id — BIGINT
  • created_at — TIMESTAMP(6)

routine_group

  • id — BIGINT
  • user_id — VARCHAR(255)

skin_concerns

  • id — SMALLINT
  • label — VARCHAR(255) — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMP(6)
  • updated_at — TIMESTAMP(6)
  • deleted_at — TIMESTAMP(6)

skin_mbtis

  • id — SMALLINT
  • mbti_code — VARCHAR(10) — NOT NULL
  • skin_type_id — SMALLINT — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMP(6)
  • updated_at — TIMESTAMP(6)
  • deleted_at — TIMESTAMP(6)

skin_types

  • id — SMALLINT
  • english_name — VARCHAR(255) — NOT NULL
  • korean_name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMP(6)
  • updated_at — TIMESTAMP(6)
  • deleted_at — TIMESTAMP(6)

user_skins

  • id — BIGINT
  • user_id — VARCHAR(255) — NOT NULL
  • skin_type_id — SMALLINT — NOT NULL
  • concern_id_1 — SMALLINT
  • concern_id_2 — SMALLINT
  • concern_id_3 — SMALLINT
  • analysis_date — TIMESTAMP(6)
  • is_active — BOOLEAN
  • created_at — TIMESTAMP(6)
  • updated_at — TIMESTAMP(6)
  • deleted_at — TIMESTAMP(6)

users

  • id — VARCHAR(255)
  • username — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255)
  • password — VARCHAR(255) — NOT NULL
  • roles — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP(6)
  • updated_at — TIMESTAMP(6)
  • deleted_at — TIMESTAMP(6)