ㅁ
Tables (7)
hotel
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
member
- id — BIGINT — Primary key — NOT NULL
- login_id — VARCHAR(100) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20)
- email — VARCHAR(30)
- birth_date — DATE
point
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- reservation_id — BIGINT — Foreign key → reservation.id
- review_id — BIGINT — Foreign key → review.id
- amount — INT — NOT NULL — 적립 포인트 (100: 예약, 200: 리뷰)
- expire_date — DATE — NOT NULL — 소멸일 (적립일 + 60일)
- status — VARCHAR(20) — NOT NULL — 상태: ACTIVE(사용가능), USED(사용됨), EXPIRED(소멸됨), REVOKED(회수됨)
- created_at — DATETIME — NOT NULL — 적립일
- INDEX — `idx_point_member_id`
- INDEX — `idx_point_reservation_id`
- INDEX — `idx_point_review_id`
- INDEX — `idx_point_status`
- INDEX — `idx_point_expire_date`
reservation
- id — BIGINT — Primary key — NOT NULL
- reserve_id — BIGINT — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- hotel_id — BIGINT — Foreign key → hotel.id — NOT NULL
- check_in_date — DATE — NOT NULL
- check_out_date — DATE — NOT NULL
- guest_count — BIGINT — NOT NULL
- room_id — BIGINT — Foreign key → room.id — NOT NULL
- INDEX — `idx_reserve_member_id`
- INDEX — `idx_reserve_hotel_id`
- INDEX — `reservation_room_fk`
review
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- room_id — BIGINT — Foreign key → room.id — NOT NULL
- reservation_id — BIGINT — Foreign key → reservation.id — 예약 정보 (선택사항)
- content — TEXT — NOT NULL — 리뷰 내용
- rating — INT — 평점 (1-5)
- is_approved — TINYINT(1) — NOT NULL — 관리자 승인 여부 (0: 미승인, 1: 승인)
- created_at — DATETIME — NOT NULL — 작성일
- updated_at — DATETIME — 수정일
- INDEX — `idx_review_member_id`
- INDEX — `idx_review_room_id`
- INDEX — `idx_review_reservation_id`
- INDEX — `idx_review_is_approved`
- INDEX — `idx_review_created_at`
review_image
- id — BIGINT — Primary key — NOT NULL
- review_id — BIGINT — Foreign key → review.id — NOT NULL
- image_url — VARCHAR(500) — NOT NULL — 이미지 URL
- image_order — INT — NOT NULL — 이미지 순서
- created_at — DATETIME — NOT NULL
- INDEX — `idx_review_image_review_id`
room
- id — BIGINT — Primary key — NOT NULL
- hotel_id — BIGINT — Foreign key → hotel.id — NOT NULL
- room_name — VARCHAR(100) — NOT NULL
- number — INT — NOT NULL
- floor — INT
- view — VARCHAR(100)
- bath — TINYINT(1)
- image_url — VARCHAR(100)
- INDEX — `idx_room_hotel_id`