푸드코드앱

테이블 (5)

Customer

  • CustomerID — INT
  • CustomerName — VARCHAR(255)

FoodCorner

  • CornerID — INT
  • CornerName — VARCHAR(255)

FoodOrder

  • OrderID — INT
  • OrderNumber — INT
  • CustomerID — INT — 외래 키 → Customer.CustomerID

Menu

  • MenuID — INT
  • CornerID — INT — 외래 키 → FoodCorner.CornerID
  • MenuName — VARCHAR(255)
  • Price — DECIMAL(10, 2)

OrderDetail

  • OrderDetailID — INT
  • OrderID — INT — 외래 키 → FoodOrder.OrderID
  • MenuID — INT — 외래 키 → Menu.MenuID