ERD-hard-exam-hotel
Tables (8)
Customer (고객)
- customer_id (PK) — BIGINT — Primary key — NOT NULL
- login_id (로그인아이디) — VARCHAR
- password (비밀번호) — VARCHAR
Hotel (호텔)
- hotel_id (PK) — BIGINT — Primary key — NOT NULL
- name (이름) — VARCHAR
Point (포인트)
- point_id (PK) — BIGINT — Primary key — NOT NULL
- customer_id (FK) — BIGINT — Foreign key → Customer.customer_id — NOT NULL
- value (적립값) — BIGINT
- point_type (적립유형) — TINYINT
- created_at (생성일) — DATETIME
Reservation (예약)
- reservation_code (PK) — VARCHAR — Primary key — NOT NULL
- customer_id (FK) — BIGINT — Foreign key → Customer.customer_id — NOT NULL
- room_id (FK2) — BIGINT — Foreign key → Room.room_id — NOT NULL
- reservation_user_id (예약자) — BIGINT
- reservation_capacity (예약인원) — TINYINT
- check_in (체크인) — DATETIME
- check_out (체크아웃) — DATETIME
Review (리뷰)
- review_id (PK) — BIGINT — Primary key — NOT NULL
- reservation_id (FK) — BIGINT — Foreign key → Reservation.reservation_code — NOT NULL
- content (내용) — VARCHAR
- exposure (노출여부) — TINIYINT(1)
ReviewImage (리뷰사진)
- review_image_id (PK) — BIGINT — Primary key — NOT NULL
- review_id (FK) — BIGINT — Foreign key → Review.review_id — NOT NULL
- uuid_filename (가공파일명) — VARCHAR
- original_filename (원본파일명) — VARCHAR
- file_path (파일경로) — VARCHAR
Room (객실)
- room_id (PK) — BIGINT — Primary key — NOT NULL
- hotel_id (FK) — BIGINT — Foreign key → Hotel.hotel_id — NOT NULL
- name (이름) — VARCHAR
- capacity (수용인원) — TINYINT
- floor (층수) — TINYINT
- bathtub_flag (욕조여부) — TINYINT(1)
- view_type (전망유형) — TINYINT
- created_at (생성일) — DATETIME
RoomImage (객실사진)
- room_image_id (PK) — BIGINT — Primary key — NOT NULL
- room_id (FK) — BIGINT — Foreign key → Room.room_id — NOT NULL
- uuid_filename (가공파일명) — VARCHAR
- original_filename (원본파일명) — VARCHAR
- file_path (파일경로) — VARCHAR