hotel

Tables (9)

hotels

  • hotel_id — BIGINT — Primary key — NOT NULL
  • name — BIGINT — NOT NULL

member

  • member_id — VARCHAR(100) — Primary key — NOT NULL
  • password — VARCHAR(100) — NOT NULL

pointHistory

  • point_id — BIGINT — Primary key — NOT NULL
  • member_id — VARCHAR(100) — Foreign key → member.member_id — NOT NULL
  • points — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL

pricing

  • pricing_id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
  • price — BIGINT — NOT NULL

reservation

  • reservation_id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
  • member_id — VARCHAR(100) — Foreign key → rooms.member_id — NOT NULL
  • check_in_date — DATETIME — NOT NULL
  • check_out_date — DATETIME — NOT NULL
  • number_of_people — BIGINT — NOT NULL
  • reservation_code — VARCHAR(100) — NOT NULL
  • status (Field) — VARCHAR(100) — NOT NULL

review

  • review_id — BIGINT — Primary key — NOT NULL
  • member_id — VARCHAR(100) — Foreign key → member.member_id — NOT NULL
  • reservation_id — BIGINT — Foreign key → reservation.reservation_id — NOT NULL
  • content — VARCHAR(100)
  • created_at — VARCHAR(100) — NOT NULL

reviewImage

  • review_image_id — BIGINT — Primary key — NOT NULL
  • review_id — BIGINT — Foreign key → review.review_id — NOT NULL
  • image_url — VARCHAR(100)

roomImage

  • image_id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
  • image_url — VARCHAR(100)

rooms

  • room_id — BIGINT — Primary key — NOT NULL
  • hotel_id — BIGINT — Foreign key → hotels.hotel_id — NOT NULL
  • member_id — VARCHAR(100) — Foreign key → member.member_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