hotel
Tables (4)
Booking (예약)
- Key (booking_id) — Primary key — NOT NULL
- 체크인 (check_in_date)
- 체크아웃 (check_out_date)
- 생성일 (created_at)
- Key (user_id) — Foreign key → User.Key — NOT NULL
- Key (room_id) — Foreign key → Room.Key — NOT NULL
Hotel (호텔)
- Key (hotel_id) — Primary key — NOT NULL
- 호텔명 (name)
- 위치 (location)
- 생성일 (created_at)
- 이미지 (image)
Room (객실)
- Key (room_id) — Primary key — NOT NULL
- 룸타입 (room_type)
- 1박가격 (price_per_night)
- 이용가능 (is_available)
- Key (hotel_id) — Foreign key → Hotel.Key — NOT NULL
User (사용자)
- Key (user_id) — Primary key — NOT NULL
- 이름 (name)
- 이메일 (email)
- 전화번호 (phone)
- 생성일 (created_at)
- Field