21321123213
Tables (4)
Member
- member_id — INT
- member_name — INT
- member_adress — INT — NOT NULL
- member_phone — VARCHAR(255)
Menu
- menu_id — INT
- menu_name — VARCHAR(255) — NOT NULL
- menu_price — DECIMAL(10, 2) — NOT NULL
- restaurant_id — INT
Order_baemin
- order_id — INT
- member_id — INT — NOT NULL
- order_address — VARCHAR(255) — NOT NULL
- order_request — TEXT
- total_amount — DECIMAL(10, 2) — NOT NULL
- order_type — ENUM('포장', '배달') — NOT NULL
- payment_status — BOOLEAN — NOT NULL
- order_time — DATETIME — NOT NULL
- menu_id — INT
- member_id2 — INT
Restaurant
- restaurant_id — INT
- restaurant_name — VARCHAR(255) — NOT NULL
- restaurant_address — VARCHAR(255) — NOT NULL
- restaurant_tel — VARCHAR(20) — NOT NULL