test
Tables (4)
Member
- member_id — INT — Primary key
- member_name — INT
- member_adress — INT — NOT NULL
- member_phone
Menu
- menu_id — INT — Primary key
- menu_name — VARCHAR(255) — NOT NULL
- menu_price — DECIMAL(10, 2) — NOT NULL
- restaurant_id — INT — Foreign key → Restaurant.restaurant_id
Order_baemin
- order_id — INT — Primary key
- 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 — Foreign key → Menu.menu_id
- member_id (member_id2) — INT — Foreign key → Member.member_id
Restaurant
- restaurant_id — INT — Primary key
- restaurant_name — VARCHAR(255) — NOT NULL
- restaurant_address — VARCHAR(255) — NOT NULL
- restaurant_tel — VARCHAR(20) — NOT NULL