beauty_analytics_erd

Tables (5)

item (상품 정보)

  • id (PK) — int — Primary key — NOT NULL
  • id (FK) — int — Foreign key → item_category.id — NOT NULL
  • name (Field2)
  • brand (Field3)
  • description (Field9) — text
  • ingredients (Field5)
  • is_on_ad (Field6) — bool
  • thumbnail_url (Field10)
  • detail_image_url (Field)
  • created_at (Field4) — timestamp
  • updated_at (Field7) — timestamp

item_category (상품 카테고리)

  • id (PK) — int — Primary key — NOT NULL
  • category_no (Field1)
  • parent_category_no (Field2)
  • name (Field3)
  • description (Field7) — text
  • is_active (Field6) — bool
  • created_at (Field4) — timestamp
  • updated_at (Field5) — timestamp

item_ingredient (화장품 전성분)

  • id (PK) — int — Primary key — NOT NULL
  • cas_no (Field) — int
  • name (Field2)
  • e_name (Field3)
  • description (Field4)
  • sate_grade (Field5)

item_review (상품 리뷰)

  • id (PK) — int — Primary key — NOT NULL
  • id (FK2) — int — Foreign key → item.id — NOT NULL
  • member_id (FK3) — int
  • title (Field2) — text
  • comment (Field) — text
  • rating (Field3) — int
  • created_at (Field4) — timestamp
  • updated_at (Field5) — timestamp

mapped_item_and_ingredient (상품 별 전성분 매핑)

  • id (PK) — int — Primary key — NOT NULL
  • item_id (FK) — int — Foreign key → item.id — NOT NULL
  • ingredient_id (FK2) — int — Foreign key → item_ingredient.id — NOT NULL
  • created_at (Field) — timestamp
  • updated_at (Field2) — timestamp
  • Field3