twins market

Tables (6)

Untitled (category)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — text

Untitled (product)

  • Key (id) — text — Primary key — NOT NULL
  • Key (category_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — text
  • Field2 (price) — int
  • Field (image) — text
  • Field (description) — text
  • Field (is_discount) — bool
  • Field (discount) — int
  • Field (available) — bool
  • Field (is_recommend) — bool

Untitled (option_group)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — text

Untitled (option)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — text
  • Field (price) — int

Untitled (order)

  • Key (id) — text — Primary key — NOT NULL
  • Field (name) — text
  • Field (phone) — text
  • Field (address) — text
  • Field (address_detail) — text
  • Field (zip_code) — text
  • Field (content) — json
  • Field (ship_type) — int
  • Field (message) — text
  • Field (status) — int
  • Field (coupon_use) — bool
  • Field (discount) — int
  • Field (ship_fee) — int
  • Field

store

  • Field (welcome) — text
  • Field (wallpaper) — text