ㅇㅇ2

테이블 (9)

customers

  • customer_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255)
  • email — VARCHAR(150) — NOT NULL
  • phone — VARCHAR(15) — NOT NULL

hotels

  • hotel_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL

points

  • point_id — BIGINT — 기본 키 — NOT NULL
  • customer_id — BIGINT — 외래 키 → customers.customer_id — NOT NULL
  • points — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

reservations

  • reservation_id — BIGINT — 기본 키 — NOT NULL
  • customer_id — BIGINT — 외래 키 → customers.customer_id — NOT NULL
  • room_id — BIGINT — 외래 키 → rooms.room_id — NOT NULL
  • check_in — DATE — NOT NULL
  • check_out — DATE — NOT NULL
  • created_at — DATETIME — NOT NULL

reviews

  • review_id — BIGINT — 기본 키 — NOT NULL
  • customer_id — BIGINT — 외래 키 → customers.customer_id — NOT NULL
  • room_id — BIGINT — 외래 키 → rooms.room_id — NOT NULL
  • rating — TINYINT — NOT NULL
  • comment — TEXT
  • created_at — DATETIME — NOT NULL

rooms

  • room_id — BIGINT — 기본 키 — NOT NULL
  • hotel_id — BIGINT — 외래 키 → hotels.hotel_id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • capacity — TINYINT — NOT NULL
  • floor — TINYINT — NOT NULL
  • bathtub_flag — TINYINT(1) — NOT NULL
  • view_type — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL

객실 이미지 (roomImage)

  • roomImage_id — BIGINT — 기본 키 — NOT NULL
  • room_id — BIGINT — 외래 키 → rooms.room_id — NOT NULL
  • image_id — BIGINT — 외래 키 → 이미지.image_id — NOT NULL

리뷰이미지 (reviewImage)

  • reviewImage_id — BIGINT — 기본 키 — NOT NULL
  • image_id — BIGINT — 외래 키 → 이미지.image_id — NOT NULL
  • review_id — BIGINT — 외래 키 → reviews.review_id — NOT NULL

이미지 (Image)

  • image_id — BIGINT — 기본 키 — NOT NULL
  • 이미지url (image_url) — VARCHAR(255)