prac1

Tables (8)

Untitled (menu_order)

  • Key (menu_order_id) — INT — Primary key — NOT NULL
  • Field (menu) — varchar
  • Field2 (price) — varchar
  • order_id (order_id2) — BIGINT — Foreign key → order.order_id — NOT NULL

boss

  • boss_id — INT — Primary key — NOT NULL
  • business_number — varchar

menu (menu_store)

  • menu_id — INT — Primary key — NOT NULL
  • menu — INT
  • price — varchar
  • store_id — INT — Foreign key → store.store_id — NOT NULL

option

  • option_id (Key) — INT — Primary key — NOT NULL
  • option — varchar
  • Key (menu_order_id) — INT — Foreign key → Untitled.Key — NOT NULL

order

  • order_id — BIGINT — Primary key — NOT NULL
  • Key (rider_id) — INT — Foreign key → rider.Key — NOT NULL
  • user_id — INT — Foreign key → users.user_id — NOT NULL
  • store_id — INT — Foreign key → store.store_id — NOT NULL

rider

  • Key (rider_id) — INT — Primary key — NOT NULL
  • Field (phone) — varchar
  • Field (vehicle) — varchar

store

  • store_id — INT — Primary key — NOT NULL
  • name — varchar
  • addr — varchar
  • boss_id — INT — Foreign key → boss.boss_id — NOT NULL

users

  • user_id — INT — Primary key — NOT NULL
  • phone — varchar
  • Field (addr) — varcahr