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)