ato3

Tables (10)

Copy Of categoryRelation (SPCRelation)

  • id — INT(11) — Primary key — NOT NULL
  • Key (subproduct_id) — INT(11) — Foreign key → Untitled.Key — NOT NULL
  • id (large_id) — INT(11) — Foreign key → ProductLargeCategory.id — NOT NULL
  • medium_id — INT(11) — Foreign key → ProductMediumCategory.id — NOT NULL
  • small_id — INT(11) — Foreign key → ProductSmallCategory.id — NOT NULL

Copy Of pIRelation (SPIRelation)

  • id — INT(11) — Primary key — NOT NULL
  • Key (subproduct_id) — INT(11) — Foreign key → Untitled.Key — NOT NULL
  • ingredients_id — INT(11) — Foreign key → Ingredients.id — NOT NULL

Ingredients

  • id — INT(11) — Primary key — NOT NULL
  • korean — VARCHAR(3024) — NOT NULL
  • oldKorean — VARCHAR(3024)
  • english — VARCHAR(3024)
  • oldEnglish — VARCHAR(3024)
  • hazardScoreMin — VARCHAR(2)
  • hazardScoreMax — VARCHAR(2)
  • dataAvailability — VARCHAR(20)
  • allergy — VARCHAR(1)
  • twenty — VARCHAR(255)
  • twentyDetail — VARCHAR(255)
  • goodForOily — TINYINT(1) — NOT NULL
  • goodForSensitive — TINYINT(1) — NOT NULL
  • goodForDry — TINYINT(1) — NOT NULL
  • badForOily — TINYINT(1) — NOT NULL
  • badForSensitive — TINYINT(1) — NOT NULL
  • badForDry — TINYINT(1) — NOT NULL
  • skinRemarkG — VARCHAR(50)
  • skinRemarkB — VARCHAR(50)
  • cosmedical — VARCHAR(50)
  • purpose — VARCHAR(512)
  • limitation — VARCHAR(512)
  • forbidden — VARCHAR(512)

Product

  • id — INT(11) — Primary key — NOT NULL
  • brand — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • Field (subName) — VARCHAR(255)
  • barcode — VARCHAR(13)

ProductLargeCategory

  • id — INT(11) — Primary key — NOT NULL
  • type — VARCHAR(10) — NOT NULL

ProductMediumCategory

  • id — INT(11) — Primary key — NOT NULL
  • type — VARCHAR(10) — NOT NULL

ProductSmallCategory

  • id — INT(11) — Primary key — NOT NULL
  • type — VARCHAR(10) — NOT NULL

Untitled (SubProduct)

  • Key (id) — INT(11) — Primary key — NOT NULL
  • id (product_id) — INT(11) — Foreign key → Product.id — NOT NULL
  • Field (subName) — VARCHAR(255) — NOT NULL
  • Field (barcode) — VARCHAR(13)

categoryRelation (PCRelation)

  • id — INT(11) — Primary key — NOT NULL
  • id (product_id) — INT(11) — Foreign key → Product.id — NOT NULL
  • large_id — INT(11) — Foreign key → ProductLargeCategory.id — NOT NULL
  • medium_id — INT(11) — Foreign key → ProductMediumCategory.id — NOT NULL
  • small_id — INT(11) — Foreign key → ProductSmallCategory.id — NOT NULL

pIRelation (PIRelation)

  • id — INT(11) — Primary key — NOT NULL
  • product_id — INT(11) — Foreign key → Product.id — NOT NULL
  • ingredients_id — INT(11) — Foreign key → Ingredients.id — NOT NULL