hotelDB
테이블 (28)
Booking
- booking_id — INT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 — NOT NULL
- booking_date — DATETIME — NOT NULL
- checkin_date — DATE — NOT NULL
- checkout_date — DATE — NOT NULL
- room_id — INT — 외래 키 → room.room_id — NOT NULL
Coupon
- coupon_id — INT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 — NOT NULL
- coupon_code — VARCHAR(50) — NOT NULL
- discount_rate — DECIMAL(5, 2) — NOT NULL
- valid_from — DATE — NOT NULL
- valid_to — DATE
Payment
- payment_id — INT — 기본 키 — NOT NULL
- booking_id — INT — 외래 키 → Booking.booking_id — NOT NULL
- user_id — INT — 외래 키 — NOT NULL
- coupon_id — INT — 외래 키 → Coupon.coupon_id
- original_price — DECIMAL(10, 2)
- total_price — DECIMAL(10, 2) — NOT NULL
- payment_date — DATETIME — NOT NULL
- payment_method_id — INT — 외래 키 — NOT NULL
event
- event_id — INT — 기본 키 — NOT NULL
- event_name — VARCHAR(255) — NOT NULL
- event_date — DATETIME — NOT NULL
- event_description — TEXT
- hotel_id — INT — 외래 키 → hotel.hotel_id — NOT NULL
hotel
- hotel_id — INT — 기본 키 — NOT NULL
- hotel_name — VARCHAR(255) — NOT NULL
- rating_avg — DECIMAL(2,1)
- price_range — VARCHAR(50)
- location_id — INT — NOT NULL
- hotel_type_id — VARCHAR(255) — NOT NULL
hotel_description
- hotel_description_id — INT — 기본 키 — NOT NULL
- hotel_id — INT — 외래 키 → hotel.hotel_id — NOT NULL
- hotel_description — TEXT — NOT NULL
hotel_image
- hotel_image_id — INT — 기본 키 — NOT NULL
- hotel_id — INT — 외래 키 → hotel.hotel_id — NOT NULL
- hotel_image_url — VARCHAR(255)
hotel_type
- hotel_type_id — VARCHAR(255) — 기본 키 — NOT NULL
- hotel_type_name — VARCHAR(255)
location
- location_id — INT — 기본 키 — NOT NULL
- city_name — VARCHAR(255) — NOT NULL
- country_name — VARCHAR(255) — NOT NULL
review
- review_id — INT — 기본 키 — NOT NULL
- rating — INT — NOT NULL
- comment — TEXT
- review_date — DATETIME — NOT NULL
- booking_id — INT — 외래 키 → Booking.booking_id — NOT NULL
- user_id — INT — 외래 키 — NOT NULL
room
- room_id — INT — 기본 키 — NOT NULL
- hotel_id — INT — 외래 키 → hotel.hotel_id — NOT NULL
- room_number — VARCHAR(255)
- is_reserved — TINYINT(1)
- room_type_id — VARCHAR(255) — 외래 키 → room_type.room_type_id — NOT NULL
room_amenities
- amenities_id — INT — 기본 키 — NOT NULL
- room_type_id — VARCHAR(255) — 외래 키 → room_type.room_type_id — NOT NULL
- is_refrigerator — TINYINT(1)
- is_television — TINYINT(1)
- is_internet — TINYINT(1)
room_image
- room_image_id — INT — 기본 키 — NOT NULL
- room_type_id — VARCHAR(255) — 외래 키 → room_type.room_type_id — NOT NULL
- room_image_url — VARCHAR(255)
room_type
- room_type_id — VARCHAR(255) — 기본 키 — NOT NULL
- room_name — VARCHAR(255)
- room_price — DECIMAL(10, 2)
사용자 (User)
- Key — 기본 키 — NOT NULL
- Field
- Field2