아웃소싱
테이블 (6)
Menus
- id — BIGINT
- store_id — BIGINT — NOT NULL
- name — VARCHAR(100)
- price — INT — NOT NULL
- description — TEXT
- is_sold_out — BOOLEAN
- image_url — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
OrderItems
- id — BIGINT
- order_id — BIGINT — NOT NULL
- menu_id — BIGINT — NOT NULL
- quantity — INT — NOT NULL
- price — INT — NOT NULL
Orders
- id — BIGINT
- customer_id — BIGINT — NOT NULL
- store_id — BIGINT — NOT NULL
- status — ENUM('ORDERED', 'CONFIRMED', 'COOKING', 'DELIVERING', 'COMPLETED', 'CANCELED')
- total_price — INT — NOT NULL
- delivery_address — VARCHAR(255)
- ordered_at — TIMESTAMP
- completed_at — TIMESTAMP
Reviews
- id — BIGINT
- order_id — BIGINT — NOT NULL
- customer_id — BIGINT — NOT NULL
- rating — INT
- content — TEXT
- created_at — TIMESTAMP
Stores
- id — BIGINT
- owner_id — BIGINT — NOT NULL
- name — VARCHAR(100)
- category — VARCHAR(50)
- description — TEXT
- address — VARCHAR(255)
- phone — VARCHAR(20)
- status — ENUM('OPEN', 'CLOSED_TEMPORARILY', 'TERMINATED')
- min_order_price — INT
- delivery_fee — INT
- thumbnail_url — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
Users
- id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255)
- name — VARCHAR(100)
- phone — VARCHAR(20)
- role — ENUM('CUSTOMER', 'OWNER', 'ADMIN') — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP