exam-hotel
Tables (8)
Hotels (호텔)
- hotel_id (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — varchar(100)
Images (이미지)
- image_id (Key) — BIGINT — Primary key — NOT NULL
- review_id (Key2) — BIGINT — Foreign key → Reviews.review_id — NOT NULL
- room_id (Key3) — BIGINT — Foreign key → Rooms.room_id — NOT NULL
- url (Field) — varchar(255)
- created_at (Field2) — LocalDateTime
Point (포인트)
- point_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key2) — varchar(100) — Foreign key → Users.user_id — NOT NULL
- point_history (Field) — int
- created_at (Field2) — LocalDateTime
Reservations (예약)
- reservation_id (Key) — BIGINT — Primary key — NOT NULL
- room_id (Key3) — BIGINT — Foreign key → Rooms.room_id — NOT NULL
- user_id (Key2) — varchar(100) — Foreign key → Users.user_id — NOT NULL
- check_in (Field) — LocalDate
- check_out (Field2) — LocalDate
- capacity (Field3) — int
- total_price (Field4) — int
- status (Field5) — boolean
- created_at (Field6) — LocalDate
Reviews (리뷰)
- review_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key2) — varchar(100) — Foreign key → Users.user_id — NOT NULL
- room_id (Key3) — BIGINT — Foreign key → Rooms.room_id — NOT NULL
- review_content (Field) — TEXT
- rating (Field2) — int
- created_at (Field3) — LocalDateTime
- is_visible (Field4) — boolean
RoomPrices (객실가격표)
- room_price_id (Key) — BIGINT — Primary key — NOT NULL
- room_id (Key2) — BIGINT — Foreign key → Rooms.room_id — NOT NULL
- season_type (Field) — enum
- price (Field2) — int
Rooms (객실)
- room_id (Key) — BIGINT — Primary key — NOT NULL
- hotel_id (Key2) — BIGINT — Foreign key → Hotels.hotel_id — NOT NULL
- name (Field) — varchar(100)
- capacity (Field2) — TINYINT
- floor (Field3) — TINYINT
- bathtub_flag (Field4) — TINYINT(1)
- view_type (Field5) — TINYINT
- created_at (Field6) — DATETIME
Users (고객)
- user_id (Key) — varchar(100) — Primary key — NOT NULL
- user_name (Field) — varchar(20)
- password (Field2) — varchar(20)
- point (Field3) — int
- created_at (Field4) — DATETIME