ㅍㅍ
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 — 찜한 시각