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)