숙박 예약 설계하기

테이블 (5)

객실 (rooms)

  • Room (idx) — INT — 기본 키 — NOT NULL
  • Place (place_id) — INT — 외래 키 → 숙소.Place — NOT NULL
  • name — VARCHAR(30)
  • onedayprice (price) — INT
  • Discount (discount) — INT
  • State (state) — BOOLEAN

결제 (payments)

  • Payment (idx) — INT — 기본 키 — NOT NULL
  • Reservation (reservation_id) — INT — 외래 키 → 예약.Reservation — NOT NULL
  • Name (name) — VARCHAR(30)
  • Category (category) — VARCHAR(30)
  • totalprice — INT
  • Payment amount (payment) — INT

고객 (customers)

  • Customer (idx) — INT — 기본 키 — NOT NULL
  • Email (email) — VARCHAR(30)
  • Name (name) — VARCHAR(30)
  • Phone (number) — INT

숙소 (places)

  • Place (idx) — INT — 기본 키 — NOT NULL
  • Name (name) — VARCHAR(30)
  • Address (address) — VARCHAR(30)
  • Number (number) — VARCHAR(30)

예약 (reservations)

  • Reservation (idx) — INT — 기본 키 — NOT NULL
  • Room (room_id) — INT — 외래 키 → 객실.Room — NOT NULL
  • Customer (customer_id) — INT — 외래 키 → 고객.Customer — NOT NULL
  • Startdate (startdate) — DATE
  • Enddate (enddate) — DATE
  • totalprice — INT