Hotel-ERD

테이블 (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 — TINYINT(1) — NOT NULL
  • view_type — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • is_reservation — TINYiNT(1)
  • high_season_price — INT
  • low_season_price — INT

리뷰 (reviews)

  • review_id — BIGINT — 기본 키 — NOT NULL
  • room_id — BIGINT — 외래 키 → 객실.room_id — NOT NULL
  • user_id — BIGINT
  • show — TINYiNT(1)

사진 (images)

  • image_id — BIGINT — 기본 키 — NOT NULL
  • room_id — BIGINT — 외래 키 → 객실.room_id — NOT NULL
  • review_id — BIGINT — 외래 키 → 리뷰.review_id — NOT NULL
  • image_path — VARCHAR(20)

예약 (reservations)

  • reservation_id — BIGINT — 기본 키 — NOT NULL
  • room_id — BIGINT — 외래 키 → 객실.room_id — NOT NULL
  • hotel_id — BIGINT — 외래 키 → 호텔.hotel_id — NOT NULL
  • user_id — BIGINT
  • check_in — DATETIME
  • check_out — DATETIME
  • people_count — INT
  • createdAt — DATETIME

포인트 (points)

  • point_id — BIGINT — 기본 키 — NOT NULL
  • reservation_id — BIGINT — 외래 키 → 예약.reservation_id — NOT NULL
  • user_id — BIGINT
  • earn — BIGINT

호텔 (hotels)

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