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