CloneCoding

Tables (8)

Untitled (order)

  • Key (id) — INT — Primary key — NOT NULL
  • Key (user_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (menu_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (result_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (amount) — INT
  • Field (option_id) — INT
  • Field (status) — VARCHAR
  • Field (date_order)

Untitled (user)

  • Key (id) — INT — Primary key — NOT NULL
  • Field (name) — VARCHAR(20)
  • Field (phone) — VARCHAR(20)
  • Field (password) — VARCHAR(100)
  • Field (email) — VARCHAR(100)
  • Field (address) — VARCHAR(100)
  • Field (date_create) — DATETIME
  • Field (date_edit) — DATETIME

Untitled (order_result)

  • Key (id) — INT — Primary key — NOT NULL
  • Key (user_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (date_order) — VARCHAR
  • Field (status) — VARCHAR
  • Field (total_cost) — INT

Untitled (menu)

  • Key (id) — INT — Primary key — NOT NULL
  • Key (store_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — VARCHAR(255)
  • Field (price) — INT
  • Field (profile) — VARCHAR(255)
  • Field (count) — INT
  • Field (date_order) — DATETIME

Untitled (option)

  • Key (id) — INT — Primary key — NOT NULL
  • Key (menu_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — VARCHAR
  • Field (price) — INT
  • Field (belonging_item) — INT

Untitled (store)

  • Key (id) — INT — Primary key — NOT NULL
  • Field (state)
  • Field (title)
  • Field2 (size)
  • Field3 (sort)
  • Field (address_land)
  • Field (address_road)
  • Field4 (post)
  • Field (latitude) — LONG
  • Field (longitude) — LONG
  • Field (minimum_price) — INT
  • Field (payment_option)
  • Field (info)
  • Field (hours)

Untitled (review)

  • Key (id) — INT — Primary key — NOT NULL
  • Key (user_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (store_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (star) — INT
  • Field (content) — VARCHAR(1000)
  • Field (date_post) — DATETIME

Untitled (category)

  • Key (id) — INT — Primary key — NOT NULL
  • Field (title) — VARCHAR
  • Field (name) — VARCHAR
  • Field (image) — VARCHAR
  • Field (file) — VARCHAR