pur

Tables (6)

basic_info_chunk (CopyOfUntitled)

  • ingredient_ko (성분명_한글) — VARCHAR — Primary key
  • ingredient_ko (성분명_한글2) — VARCHAR — Foreign key → ewg_chunk.ingredient_ko
  • ingredient_en (성분명_영문) — VARCHAR
  • pc_effect (폴라초이스 효과별) — VARCHAR
  • pc_category (폴라초이스 분류) — VARCHAR
  • coos_function (coos기능) — VARCHAR
  • coos_type (coos종류) — VARCHAR
  • hw_purpose (화해_용도) — VARCHAR
  • hw_limitation (화해_사용제한) — VARCHAR
  • hw_forbidden (화해_사용금지) — VARCHAR

ewg_chunk (Untitled)

  • ingredient_ko (성분명_한글) — VARCHAR — Primary key
  • ingredient_en (성분명_영문) — VARCHAR
  • hw_ewg (EWG등급) — VARCHAR
  • hw_ewg_data_availability_text (EWG데이터가용성) — VARCHAR
  • coos_score (coos점수) — FLOAT
  • coos_data_grade (coos데이터등급) — VARCHAR
  • pc_grade (폴라초이스 등급) — VARCHAR

expert_chunk (Untitled2)

  • ingredient_ko (성분명_한글) — VARCHAR — Primary key
  • ingredient_ko (성분명_한글2) — VARCHAR — Foreign key → ewg_chunk.ingredient_ko
  • ingredient_en (성분명_영문) — VARCHAR
  • pc_description (폴라초이스 성분설명) — VARCHAR
  • coos_ai_desc (coos_AI설명) — VARCHAR
  • coos_KR (coos_국내허용) — VARCHAR
  • coos_CN (coos_중국허용) — VARCHAR
  • coos_TW (coos_대만허용) — VARCHAR
  • coos_JP (coos_일본허용) — VARCHAR
  • coos_DE (coos_독일허용) — VARCHAR
  • coos_VN (coos_베트남허용) — VARCHAR
  • hw_category (화해_카테고리) — VARCHAR

product_Review_topic (Untitled4)

  • hw_product_id (화해_제품ID2) — INT — Foreign key → product_info.hw_product_id — NOT NULL
  • hw_product_id (화해_제품ID) — INT
  • hw_topics_positive (긍정리뷰토픽) — TEXT
  • hw_topics_negative (부정리뷰토픽) — TEXT

product_info (Untitled3)

  • hw_product_id (화해_제품ID) — INT — Primary key — NOT NULL
  • hw_product_name (화해_제품명) — VARCHAR
  • hw_brand_name (화해_브랜드명) — VARCHAR
  • hw_ingredient_count (성분수) — INT
  • hw_primary_attr (주요속성) — VARCHAR

product_price (Untitled5)

  • hw_product_id (화해_제품ID2) — INT — Foreign key → product_info.hw_product_id — NOT NULL
  • hw_product_id (화해_제품ID) — INT
  • hw_price (판매가) — INT
  • hw_consumer_price (소비자가) — INT
  • hw_avg_ratings (평균평점) — FLOAT
  • hw_review_count (리뷰수) — INT