책배달 연습

테이블 (5)

BookMenus

  • MenuID — INT
  • EstablishmentID — INT
  • ImageURL — VARCHAR(255)
  • BookName — VARCHAR(255) — NOT NULL
  • Price — DECIMAL(10, 2) — NOT NULL

Establishments

  • EstablishmentID — INT
  • OwnerID — INT
  • Name — VARCHAR(255) — NOT NULL

Orders

  • OrderID — INT
  • CustomerID — INT
  • MenuID — INT
  • OrderStatus — VARCHAR(20)

Reviews

  • ReviewID — INT
  • CustomerID — INT
  • EstablishmentID — INT
  • ReviewText — TEXT
  • Rating — INT

Users

  • UserID — INT
  • UserType — VARCHAR(10) — NOT NULL
  • Email — VARCHAR(255) — NOT NULL
  • Points — INT