delivery
Tables (5)
Delivery (Untitled3)
- id (pk) — int — Primary key — NOT NULL
- city (도시) — char
- street (도로명) — char
- zipcode (우편번호) — char
Food (Untitled5)
- id (pk) — int — Primary key — NOT NULL
- name (이름) — char
- price (가격) — int
- amount (수량) — int
- category (분류) — char
Member (Untitled)
- id (pk) — int — Primary key — NOT NULL
- name (이름) — char
- city (도시) — char
- street (도로명) — char
- zipcode (우편번호) — char
Order_Food (Untitled4)
- id (pk) — int — Primary key — NOT NULL
- order_id (fk) — int — Foreign key → Orders.id — NOT NULL
- food_id (fk2) — int — Foreign key → Food.id — NOT NULL
- order_pice (주문금액) — int
- count (주문수량) — int
- Field
Orders (Untitled2)
- id (pk) — int — Primary key — NOT NULL
- member_id (fk) — int — Foreign key → Member.id — NOT NULL
- delivery_id (fk2) — int — Foreign key → Delivery.id — NOT NULL
- order_date (주문날짜) — date
- status (주문상태) — char