ㅇㅇ

테이블 (6)

객실 (rooms)

  • room_id — BIGINT — 기본 키 — NOT NULL
  • hotel_id — BIGINT — 외래 키 → 호텔.hotel_id — NOT NULL
  • 객실명 (name) — VARCHAR(100) — NOT NULL
  • 숙박인원 (capacity) — TINYINT — NOT NULL
  • 층 (floor) — TINYINT — NOT NULL
  • 욕조존재여부 (bathtub_flag) — Boolean — NOT NULL
  • 전망 (view_type) — TINYINT — NOT NULL
  • 예약날짜 (created_at) — DATETIME — NOT NULL
  • INDEX — `fk_Rooms_hotels_idx`

고객 (customers)

  • customer_id — BIGINT — 기본 키 — NOT NULL
  • username (name) — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255)
  • email — VARCHAR(150) — NOT NULL
  • phone — VARCHAR(15) — NOT NULL

리뷰 (reviews)

  • review_id — BIGINT — 기본 키 — NOT NULL
  • customer_id — BIGINT — 외래 키 → 고객.customer_id — NOT NULL
  • room_id — BIGINT — NOT NULL
  • rating — TINYINT — NOT NULL
  • comment — TEXT
  • created_at — DATETIME — NOT NULL

예약 (reservations)

  • reservation_id — BIGINT — 기본 키 — NOT NULL
  • customer_id — BIGINT — 외래 키 → 고객.customer_id — NOT NULL
  • room_id — BIGINT — NOT NULL
  • check_in — DATE — NOT NULL
  • check_out — DATE — NOT NULL
  • created_at — DATETIME — NOT NULL

포인트 (points)

  • point_id — BIGINT — 기본 키 — NOT NULL
  • customer_id — BIGINT — 외래 키 → 고객.customer_id — NOT NULL
  • points — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

호텔 (hotels)

  • hotel_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL