kmit db

Tables (5)

OptionItem

  • option_id — INT
  • name — VARCHAR(100)
  • description — TEXT
  • price — DECIMAL(10,2)

Payment

  • payment_id — INT
  • reservation_id — INT — NOT NULL
  • payment_method — VARCHAR(50)
  • amount — DECIMAL(10,2)
  • payment_status — ENUM('성공', '실패', '보류')
  • paid_at — TIMESTAMP

Reservation

  • reservation_id — INT
  • customer_id — INT — NOT NULL
  • room_id — INT — NOT NULL
  • checkin_date — DATE — NOT NULL
  • checkout_date — DATE — NOT NULL
  • guest_count — INT
  • total_price — DECIMAL(10,2)
  • status — ENUM('예약', '취소', '완료')
  • created_at — TIMESTAMP

ReservationOption

  • reservation_id — INT — Primary key — NOT NULL
  • option_id — INT — Primary key — NOT NULL

Review

  • review_id — INT
  • reservation_id — INT — NOT NULL
  • customer_id — INT — NOT NULL
  • rating — INT
  • comment — TEXT — EX
  • created_at — TIMESTAMP