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