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