GLOBAL
Tables (4)
brand (Untitled2)
- brand_id (Key) — int(11) — Primary key — NOT NULL
- kor_name (Field) — varchar(100)
- en_name (Field2) — varchar(100)
- website (Field3) — varchar(300)
- brand_info (Field4) — text
- register_date (Field5) — time_stamp
category (Untitled4)
- category_id (Key) — int(11)) — Primary key — NOT NULL
- parent_id (Field) — int(11)
- en (Field2) — varchar(50)
- es (Field3) — varchar(30)
- register_date (Field4) — timestamp
- sort (Field5) — int(11)
item (Untitled)
- item_id (Key) — int(11) — Primary key — NOT NULL
- sku (Field) — varchar(20)
- brand_id (Field2) — int(11)
- item_name_kor (Field3) — varchar(100)
- item_name_en (Field4) — varchar(100)
- item_volume (Field5) — varchar(30)
- retail_price (Field6) — decimal(5,2)
- stock (Field7) — int(4
- item_status (Field8) — tinyint(1)
- ingredient (Field9) — text
- cover_url (Field10) — varchar(1000)
- detail_url1 (Field11) — varchar(1000)
- detail_url2 (Field12) — varchar(1000)
- detail_url3 (Field13) — varchar(1000)
- detail_url4 (Field14) — varchar(1000)
- register_date (Field15) — timestamp
- option_status (Field16) — tinyint(3)
item_category (Untitled3)
- item_category_id (Key) — int(11) — Primary key — NOT NULL
- category_id (Field) — int(11)
- item_id (Field2) — int(11)