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