배민
테이블 (5)
Menu
- menuid — bigint(20) — 기본 키 — NOT NULL
- name — varchar(50) — NOT NULL
- price — int — NOT NULL
- description — varchar(255)
- status — ENUM('Available', 'Unavailable') — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- restaurantid — bigint(20) — NOT NULL
Order
- orderid — bigint(20) — 기본 키 — NOT NULL
- orderdate — date — NOT NULL
- totalamount — int — NOT NULL
- status — ENUM('Pending', 'Completed', 'Cancelled') — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- userid — bigint(20) — NOT NULL
- restaurantid — bigint(20) — NOT NULL
OrderItem
- orderitemid — bigint(20) — 기본 키 — NOT NULL
- quantity — int — NOT NULL
- price — int — NOT NULL
- status — ENUM('Pending', 'Prepared', 'Delivered') — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- menuid — bigint(20) — NOT NULL
- orderid — bigint(20) — NOT NULL
Restaurant
- restaurantid — bigint(20) — 기본 키 — NOT NULL
- name — varchar(50) — NOT NULL
- location — varchar(200) — NOT NULL
- phone — varchar(50)
- category — varchar(50)
- min_order_amount — int — NOT NULL
- status — ENUM('Open', 'Closed') — NOT NULL
- created_at — timestamp
- updated_at — timestamp
User
- userId — bigint(20) — 기본 키 — NOT NULL
- name — varchar(50) — NOT NULL
- password — varchar(200) — NOT NULL
- phone — varchar(50) — NOT NULL
- current_address — varchar(200)
- email — varchar(200) — NOT NULL
- status — ENUM('Active', 'Inactive') — NOT NULL
- created_at — timestamp
- updated_at — timestamp