DeliveryApp
Tables (5)
Menu (메뉴)
- id (Key) — big int auto increment — Primary key — NOT NULL
- store_id (storeId) — big int auto increment — Foreign key → Store.id — NOT NULL
- name — varchar(100) — NOT NULL
- price — int — NOT NULL
- is_deleted (isDeleted) — varchar — NOT NULL
- created_at (createAt) — datetime — NOT NULL
- modified_at (modifyAt) — datetime
Order (주문)
- id (Key) — big int auto increment — Primary key — NOT NULL
- user_id (userId) — big int auto increment — Foreign key → User.id — NOT NULL
- menu_id (menuId) — big int auto increment — Foreign key → Menu.id — NOT NULL
- order_status (orderStatus) — varchar — NOT NULL
- created_at (createAt) — datetime — NOT NULL
- modified_at (modifyAt) — datetime
Review (리뷰)
- id (Key) — big int auto increment — Primary key — NOT NULL
- order_id (orderId) — big int auto increment — Foreign key → Order.id — NOT NULL
- star_point (starPoint) — int — NOT NULL
- content — varchar(300) — NOT NULL
- created_at (createAt) — datetime — NOT NULL
- modified_at (modifyAt) — datetime
Store (가게)
- id (Key) — big int auto increment — Primary key — NOT NULL
- user_id (userId) — big int auto increment — Foreign key → User.id — NOT NULL
- name — varchar(30) — NOT NULL
- store_status (storeStatus) — varchar — NOT NULL
- minimum_order_price (minimumOrderPrice) — int — NOT NULL
- open_time (openTime) — time — NOT NULL
- close_time (closeTime) — time — NOT NULL
- created_at (createAt) — datetime — NOT NULL
- modified_at (modifyAt) — datetime
User (사용자)
- id (Key) — big int auto increment — Primary key — NOT NULL
- email (emial) — varchar(50) — NOT NULL
- password — varchar(20) — NOT NULL
- authority — varchar — NOT NULL
- user_withdraw (userWithdraw) — varchar — NOT NULL
- created_at (createAt) — datetime — NOT NULL
- modified_at (modifyAt) — datetime