아웃소싱

테이블 (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