hotel_exam
Tables (8)
Hotels (Untitled)
- hotel_id (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — VARCHAR(100)
Points (Untitled9)
- poin_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → Users.user_id — NOT NULL
- reserve_id (Key3) — BIGINT — Foreign key → Rerservation.reserve_id — NOT NULL
- review_id (Key4) — BIGINT — Foreign key → Review.review_id — NOT NULL
- amount (포인트 적립액) — INT
- status (사용, 소멸 상태) — ENUM('VALID', 'CANCELLED')
- earn_at (적립날짜) — DATETIME
- expired_at (소멸 날짜) — DATETIME
Rerservation (Untitled5)
- reserve_id (Key) — BIGINT — Primary key — NOT NULL
- check_in (체크인날짜) — DATETIME
- check_out (체크아웃 날짜) — DATETIME
- head_count (인원 수) — TINYINT
- reserve_num (예약번호) — VARCHAR(100)
- reserve_status (예약 상태) — ENUM('COMPLETED', 'CANCELLED')
- room_id (Key2) — BIGINT — Foreign key → Rooms.room_id — NOT NULL
- user_id (Key3) — BIGINT — Foreign key → Users.user_id — NOT NULL
Review (Untitled7)
- review_id (Key) — BIGINT — Primary key — NOT NULL
- rating (평점) — DECIMAL(2,1)
- is_visible (리뷰보이게) — boolean
- reserve_id (Key2) — BIGINT — Foreign key → Rerservation.reserve_id — NOT NULL
Review_Images (Untitled8)
- review_image_id (Key) — BIGINT — Primary key — NOT NULL
- image_url (Field) — VARCHAR(255)
- review_id (Key2) — BIGINT — Foreign key → Review.review_id — NOT NULL
Room_images (Untitled6)
- room_image_id (Key) — BIGINT — Primary key — NOT NULL
- image_url (Field) — VARCHAR(255)
- room_id (Key2) — BIGINT — Foreign key → Rooms.room_id — NOT NULL
Rooms (Untitled2)
- room_id (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — VARCHAR(100)
- hotel_id (Key2) — BIGINT — Foreign key → Hotels.hotel_id — NOT NULL
- capacity (수용인원) — TINYINT
- floor (층수) — TINYINT
- has_bathtub (욕조 유무) — TINYINT(1)
- view_type (뷰 타입) — TINYINT
- created_at (Field6) — DATETIME
Users (Untitled4)
- user_id (Key) — BIGINT — Primary key — NOT NULL
- name (사용자 이름) — VARCHAR(100)