ato

Tables (12)

Copy Of Copy Of Copy Of Untitled (CopyOfProductSmallCategory)

  • Key (id) — INT(11) — Primary key — NOT NULL
  • Field (type) — VARCHAR(10) — NOT NULL
  • Field2 (desc) — INT(11) — NOT NULL

Copy Of Copy Of Untitled (ProductSmallCategory)

  • Key (id) — INT(11) — Primary key — NOT NULL
  • Key (medium_id) — INT(11) — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Field (type) — VARCHAR(10) — NOT NULL
  • Field2 (desc) — INT(11) — NOT NULL

Copy Of Copy Of Untitled2 (CopyOfProductMediumCategory)

  • Key (id) — INT(11) — Primary key — NOT NULL
  • Field (type) — VARCHAR(10) — NOT NULL
  • Field2 (desc) — INT(11) — NOT NULL

Copy Of Untitled (ProductMediumCategory)

  • Key (id) — INT(11) — Primary key — NOT NULL
  • Key (large_id) — INT(11) — Foreign key → Untitled.Key — NOT NULL
  • Field (type) — VARCHAR(10) — NOT NULL
  • Field2 (desc) — INT(11) — NOT NULL

Copy Of Untitled2 (CopyOfProductLargeCategory)

  • Key (id) — INT(11) — Primary key — NOT NULL
  • Field (type) — VARCHAR(10) — NOT NULL
  • Field2 (desc) — INT(11) — NOT NULL

Copy Of Untitled3 (allergy)

  • Key (id) — INT(11) — Primary key — NOT NULL
  • Field (name) — VARCHAR(100) — NOT NULL
  • Field (desc) — VARCHAR(255) — NOT NULL

Copy Of Untitled4 (CopyOfrelation)

  • Key (id) — INT(11) — Primary key — NOT NULL
  • Key (id5) — INT(11) — Foreign key → Untitled.Key — NOT NULL
  • Key (id3) — INT(11) — Foreign key → Copy Of Copy Of Untitled2.Key — NOT NULL
  • Key (id4) — INT(11) — Foreign key → Copy Of Copy Of Copy Of Untitled.Key — NOT NULL
  • Key (id2) — INT(11) — Foreign key → Copy Of Untitled2.Key — NOT NULL

Untitled (ProductLargeCategory)

  • Key (id) — INT(11) — Primary key — NOT NULL
  • Field (type) — VARCHAR(10) — NOT NULL
  • Field2 (desc) — INT(11) — NOT NULL

Untitled (Product)

  • Key (id) — INT(11) — Primary key — NOT NULL
  • Key (small_id) — INT(11) — Foreign key → Copy Of Copy Of Untitled.Key — NOT NULL
  • Field (brand) — VARCHAR(255) — NOT NULL
  • Field (name) — VARCHAR(255) — NOT NULL
  • Field2 (barcode) — VARCHAR(13)

Untitled (Ingredients)

  • Key (id) — INT(11) — Primary key — NOT NULL
  • Field (korean) — VARCHAR(3024) — NOT NULL
  • Field2 (oldKorean) — VARCHAR(3024)
  • Field3 (english) — VARCHAR(3024)
  • Field (oldEnglish) — VARCHAR(3024)
  • Field (hazardScoreMin) — VARCHAR(2)
  • Field2 (hazardScoreMax) — VARCHAR(2)
  • Field3 (dataAvailability) — VARCHAR(20)
  • Field4 (allergy) — VARCHAR(1)
  • Field5 (twenty) — VARCHAR(255)
  • Field (twentyDetail) — VARCHAR(255)
  • Field6 (goodForOily) — TINYINT(1) — NOT NULL
  • Field7 (goodForSensitive) — TINYINT(1) — NOT NULL
  • Field8 (goodForDry) — TINYINT(1) — NOT NULL
  • Field9 (badForOily) — TINYINT(1) — NOT NULL
  • Field10 (badForSensitive) — TINYINT(1) — NOT NULL
  • Field11 (badForDry) — TINYINT(1) — NOT NULL
  • Field12 (skinRemarkG) — VARCHAR(50)
  • Field13 (skinRemarkB) — VARCHAR(50)
  • Field (cosmedical) — VARCHAR(50)
  • Field14 (purpose) — VARCHAR(512)
  • Field15 (limitation) — VARCHAR(512)
  • Field16 (forbidden) — VARCHAR(512)

Untitled (twenty)

  • Key (id) — INT(11) — Primary key — NOT NULL
  • Field (name) — VARCHAR(100) — NOT NULL
  • Field (desc) — VARCHAR(255) — NOT NULL

Untitled (relation)

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