ㅇ

Tables (6)

customer

  • customer_id — INT
  • name — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL

payment

  • payment_id — INT
  • reservation_id — INT — NOT NULL
  • payment_date — DATE — NOT NULL
  • payment_method — VARCHAR(30) — NOT NULL

product

  • product_id — INT
  • name — VARCHAR(100) — NOT NULL
  • price — INT — NOT NULL
  • product_type — ENUM('DESSERT', 'CAKE', 'SET') — NOT NULL

product_set_item

  • set_id — INT — Primary key — NOT NULL
  • dessert_id — INT — Primary key — NOT NULL
  • quantity — INT — NOT NULL

reservation

  • reservation_id — INT
  • customer_id — INT — NOT NULL
  • reservation_date — DATE — NOT NULL
  • pickup_time — TIME — NOT NULL

reservation_item

  • reservation_item_id — INT
  • reservation_id — INT — NOT NULL
  • product_id — INT — NOT NULL
  • quantity — INT — NOT NULL