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