ㅍㅍ

Tables (9)

coupon

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • code — VARCHAR(255) — NOT NULL
  • discount_type — ENUM('percentage', 'fixed_amount') — NOT NULL
  • discount_value — INT — NOT NULL
  • min_spend — INT — NOT NULL
  • valid_from — TIMESTAMP — NOT NULL
  • valid_until — TIMESTAMP — NOT NULL
  • is_active — BOOLEAN — NOT NULL

hotel

  • id — INT — Primary key — NOT NULL
  • owner_id — INT — Foreign key → user.id — NOT NULL — 사업자 회원의 ID (user.id)
  • name — VARCHAR(50) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • star_rating — INT — NOT NULL
  • description — TEXT
  • amenity — VARCHAR(255) — 부대시설 (수영장, 피트니스 등)
  • image — TEXT

payment

  • id — INT — Primary key — NOT NULL
  • reservation_id — INT — Foreign key → reservation.id — NOT NULL
  • payment_method — VARCHAR(50) — NOT NULL
  • base_price — INT — NOT NULL
  • discount — INT — NOT NULL
  • tax — INT — NOT NULL
  • total_price — INT — NOT NULL
  • status — ENUM('completed', 'cancelled', 'refunded') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • canceled_at — TIMESTAMP
  • refunded_at — TIMESTAMP
  • receipt_url — TEXT

reservation

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.id — NOT NULL
  • room_id — INT — Foreign key → room.id — NOT NULL
  • adult — TINYINT — NOT NULL
  • kid — TINYINT — NOT NULL
  • start_date — TIMESTAMP — NOT NULL
  • end_date — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • status — ENUM('pending', 'confirmed', 'cancelled', 'completed') — NOT NULL
  • expires_at — TIMESTAMP — 결제 대기 만료 시간

review

  • id — INT — Primary key — NOT NULL
  • reservation_id — INT — Foreign key → reservation.id — NOT NULL — 중복 작성 방지 및 이용자 확인용
  • wrote_on — TIMESTAMP — NOT NULL
  • star_rating — INT — NOT NULL
  • content — TEXT
  • image — TEXT

room

  • id — INT — Primary key — NOT NULL
  • hotel_id — INT — Foreign key → hotel.id — NOT NULL
  • name — VARCHAR(50) — NOT NULL — 스위트룸, 디럭스룸 등
  • room_size — VARCHAR(50) — NOT NULL — ex) 30m²
  • capacity_min — TINYINT — NOT NULL
  • capacity_max — TINYINT — NOT NULL
  • check_in_time — TIME — NOT NULL
  • check_out_time — TIME — NOT NULL
  • amenity — VARCHAR(255) — 객실 내 편의시설 (침대 사이즈, 욕조 등)
  • image — TEXT

room_prices

  • id — INT — Primary key — NOT NULL
  • room_id — INT — Foreign key → room.id — NOT NULL
  • price — INT — NOT NULL — 해당 조건에 적용될 가격
  • start_date — DATE — NOT NULL — 가격 적용 시작일
  • end_date — DATE — NOT NULL — 가격 적용 종료일
  • day_type — ENUM('weekday', 'weekend', 'holiday') — NOT NULL — 평일, 주말, 공휴일

user

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(13) — NOT NULL
  • email — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • created_on — TIMESTAMP — NOT NULL
  • role — ENUM('user', 'admin', 'business') — NOT NULL

wishlist

  • user_id — INT — Primary key — NOT NULL — 회원 테이블의 ID (FK)
  • hotel_id — INT — Primary key — NOT NULL — 호텔 테이블의 ID (FK)
  • created_at — TIMESTAMP — NOT NULL — 찜한 시각