BackOfiice
Tables (6)
menu (Untitled4)
- id (Key) — BIGINT — Primary key — NOT NULL
- store_id (Key2) — BIGINT — Foreign key → store.id — NOT NULL
- menu_name (Field) — VARCHAR(50) — NOT NULL
- price (Field2) — BIGINT — NOT NULL
- created_at (Field3) — DATETIME — NOT NULL
- modified_at (Field4) — DATETIME — NOT NULL
order_menu (Untitled5)
- id (Key) — BIGINT — Primary key — NOT NULL
- orders_id (Key2) — BIGINT — Foreign key → orders.id — NOT NULL
- menu_id (Key3) — BIGINT — Foreign key → menu.id — NOT NULL
- quantity (Field) — INT — NOT NULL
orders (Untitled2)
- id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → user.id — NOT NULL
- store_id (Key3) — BIGINT — Foreign key → store.id — NOT NULL
- status (Field) — ENUM — NOT NULL
- total_price (Field2) — BIGINT — NOT NULL
- created_at (Field3) — DATETIME — NOT NULL
- modified_at (Field4) — DATETIME — NOT NULL
- delivery_at (Field5) — DATETIME
review (Untitled3)
- review_id (Key) — BIGINT — Primary key — NOT NULL
- customer_id (Key2) — BIGINT — Foreign key → user.id — NOT NULL
- store_id (Key3) — BIGINT — Foreign key → store.id — NOT NULL
- rating (Field) — INT — NOT NULL
- comment (Field2) — VARCHAR(255) — NOT NULL
- created_at (Field3) — DATETIME — NOT NULL
- modified_at (Field4) — DATETIME — NOT NULL
store (Untitled)
- id (Key) — BIGINT — Primary key — NOT NULL
- owner_id (Key2) — BIGINT — Foreign key → user.id — NOT NULL
- store_name (Field) — VARCHAR(255) — NOT NULL
- address (Field2) — VARCHAR(255) — NOT NULL
- created_at (Field3) — DATETIME — NOT NULL
- modified_at (Field4) — DATETIME — NOT NULL
user (사용자)
- id (Key) — BIGINT — Primary key — NOT NULL
- email (Field) — VARCHAR(255) — NOT NULL
- password (Field2) — VARCHAR(255) — NOT NULL
- username (Field3) — VARCHAR(255) — NOT NULL
- points (Field7) — BIGINT
- role (Field4) — ENUM — NOT NULL
- created_at (Field5) — DATETIME — NOT NULL
- modified_at (Field6) — DATETIME — NOT NULL