버즈니

테이블 (3)

goods

  • idx — int — 기본 키 — NOT NULL
  • mall — int — 외래 키 → shopping_site.idx
  • title — varchar(100)
  • url — varchar(200)
  • price — varchar(50)
  • image — varchar(200)
  • created — timestamp(3)
  • updated — timestamp(3)

shopping_site

  • idx — int — 기본 키 — NOT NULL
  • name — text

xpath_sample

  • mall_idx — int — 외래 키 → shopping_site.idx — NOT NULL
  • title — text
  • price — text
  • image — text
  • created — timestamp(3)
  • updated — timestamp(3)