test

Tables (9)

Hotels (호텔)

  • 호텔아이디 (hotel_id) — NOTNULL — Primary key — NOT NULL
  • 호텔이름 (name) — NOTNULL

Rooms (룸)

  • 룸아이디 (room_id) — NOTNULL — Primary key — NOT NULL
  • 룸이름 (name) — NOTNULL
  • 용량 (capacity) — NOTNULL
  • 층수 (floor) — NOTNULL
  • 욕조 (bathtub_flag) — NOTNULL
  • 생성일자 (created_at) — NOTNULL
  • 호텔아이디 (hotel_id) — NOTNULL — Foreign key → Hotels.호텔아이디 — NOT NULL
  • 뷰타입 (view_type) — NOTNULL

holidays (성수기)

  • 성수기 (holiday_id) — NOTNULL — Primary key — NOT NULL
  • 날짜 (date) — NOTNULL
  • 이름 (name) — NOTNULL

point_transactions (포인트내역)

  • 포인트내역 (point_tx_id) — NOTNULL — Primary key — NOT NULL
  • 타입 (type) — NOTNULL
  • 포인트 (points) — NOTNULL
  • 상태 (status) — NOTNULL
  • 획득날짜 (earned_at) — NOTNULL
  • 만료날짜 (expires_at) — NULL
  • 예약 (reservation_id) — NOTNULL — Foreign key → reservations.예약 — NOT NULL
  • 리뷰 (review_id) — NOTNULL — Foreign key → reviews.리뷰 — NOT NULL
  • 유저아이디 (user_id) — NOTNULL

reservations (에약)

  • 예약 (reservation_id) — NOTNULL — Primary key — NOT NULL
  • 예약번호 (reservation_code) — NOTNULL
  • 체크인 (check_in) — NOTNULL
  • 체크아웃 (check_out) — NOTNULL
  • 인원수 (guest_count) — NOTNULL
  • 예약상태 (status) — NOTNULL
  • 생성일자 (created_at) — NOTNULL
  • 취소일자 (canceled_at) — NULL
  • 룸아이디 (room_id) — NOTNULL — Foreign key → Rooms.룸아이디 — NOT NULL
  • 유저아이디 (user_id) — NOTNULL

review_images (리뷰이미지)

  • 리뷰이미지 (review_image_id) — NOTNULL — Primary key — NOT NULL
  • 이미지경로 (image_url) — NOTNULL
  • 정렬용 (sort_order) — NOTNULL
  • 리뷰 (review_id) — NOTNULL — Foreign key → reviews.리뷰 — NOT NULL

reviews (리뷰)

  • 리뷰 (review_id) — NOTNULL — Primary key — NOT NULL
  • 리뷰내용 (content) — NOTNULL
  • 별점 (rating) — NULL
  • 관리자노출여부 (is_visible) — NOTNULL
  • 생성일자 (created_at) — NOTNULL
  • 예약 (reservation_id) — NOTNULL — Foreign key → reservations.예약 — NOT NULL

room_images (룸이미지)

  • 객실이미지 (room_image_id) — NOTNULL — Primary key — NOT NULL
  • 이미지 url (image_url) — NOTNULL
  • 정렬용 (sort_order) — NOTNULL
  • 룸아이디 (room_id) — NOTNULL — Foreign key → Rooms.룸아이디 — NOT NULL

room_prices (룸가격)

  • 객실가격 (room_price_id) — NOTNULL — Primary key — NOT NULL
  • 시즌 (season_type) — NOTNULL
  • 1박가격 (price) — NOTNULL
  • 룸아이디 (room_id) — NOTNULL — Foreign key → Rooms.룸아이디 — NOT NULL