ㅁ

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`