erd1
Tables (6)
Hotel (호텔)
- Key (hotel_id) — int — Primary key — NOT NULL
- 호텔 이름 (title) — string
- 호텔 설명 (description) — string
- 호텔 위치 (Field) — int
Reserve (예약)
- Key (reserve_id) — int — Primary key — NOT NULL
- Key (room_id) — int — Foreign key → Room.Key — NOT NULL
- Key (user_id) — int — Foreign key → User.Key — NOT NULL
- 체크인 (check_in) — datetime
- 체크아웃 (check_out) — datetime
- 예약날짜 (reserve_date) — timestamp
- 결제금액 (pay_amount) — string
- 결제타입 (pay_type) — enum
Review (리뷰)
- Key (review_id) — int — Primary key — NOT NULL
- Key (user_id) — int — Foreign key → User.Key — NOT NULL
- Key (hotel_id) — int — Foreign key → Hotel.Key — NOT NULL
- 상세 평가 (description) — string
- 별점 (starRating) — int
Room (룸)
- Key (room_id) — int — Primary key — NOT NULL
- Key (hotel_id) — int — Foreign key → Hotel.Key — NOT NULL
- 룸 이름 (name) — string
- 요금 (fee) — string
User (회원)
- Key (user_id) — int — Primary key — NOT NULL
- 비밀번호 (password) — string
- 주소 (point x ,y) — int
- 이름 (name) — string
- 폰번호 (phone_num) — string
- 가입날짜 (join_date) — timestamp
- 상태 (user_status) — enum
WatchList (찜)
- Key (watch_list_id) — int — Primary key — NOT NULL
- Key (user_id) — int — Foreign key → User.Key — NOT NULL
- Key (hotel_id) — int — Foreign key → Hotel.Key — NOT NULL