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