yogiyo-clone

Tables (6)

Shop

  • Key (id) — long — Primary key — NOT NULL
  • Key (owner_id) — long — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — String
  • Key3 (latitude) — double — NOT NULL
  • Key2 (longitude) — double — NOT NULL
  • Field (order_num) — int
  • Field (review_num) — int
  • Field (total_score) — double
  • Field (min_order_price) — int
  • Field2 (min_delivery_price) — int

Untitled (Owner)

  • Key (id) — long — Primary key — NOT NULL
  • Field (name) — String

Untitled (category_shop)

  • Key (id) — long — Primary key — NOT NULL
  • Key (category_id) — long — Foreign key → Untitled.Key — NOT NULL
  • Key (shop_id) — long — Foreign key → Shop.Key — NOT NULL

Untitled (category)

  • Key (id) — long — Primary key — NOT NULL
  • Field (name) — String

Untitled (order)

  • Key (id) — long — Primary key — NOT NULL
  • Key (owner_id) — long — Foreign key → Shop.Key — NOT NULL
  • Field (created_at) — date
  • Field (address) — String
  • Field (status) — String

Untitled (review)

  • Key (id) — long — Primary key — NOT NULL
  • Key (owner_id) — long — Foreign key → Shop.Key — NOT NULL
  • Field (created_at) — date
  • Field (contents) — String