Hotel

Tables (8)

hotels

  • hotel_id — bigint — Primary key — NOT NULL — AUTO_INCREMENT
  • name — varchar(100) — NOT NULL

images

  • image_id — bigint — Primary key — NOT NULL
  • content — varchar(100)

reservations

  • reservation_id — bigint — Primary key — NOT NULL — auto_increment
  • user_id — bigint — Foreign key → users.user_id — NOT NULL
  • room_id — bigint — Foreign key → rooms.room_id — NOT NULL
  • start_date — date
  • end_date — date
  • num_people — int

review_image

  • review_image_id — bigint — Primary key — NOT NULL
  • review_id — bigint — Foreign key → reviews.review_id — NOT NULL
  • image_id (image_id2) — bigint — Foreign key → images.image_id — NOT NULL

reviews

  • review_id — bigint — Primary key — NOT NULL
  • reservation_id — bigint — Foreign key → reservations.reservation_id — NOT NULL — auto_increment
  • content — text
  • approved_flag — tinyint(1)
  • created_at — datetime

room_image

  • room_image_id — bigint — Primary key — NOT NULL
  • room_id — bigint — Foreign key → rooms.room_id — NOT NULL
  • image_id — bigint — Foreign key → images.image_id — NOT NULL

rooms

  • room_id — bigint — Primary key — NOT NULL
  • hotel_id — bigint — Foreign key → hotels.hotel_id — NOT NULL — AUTO_INCREMENT
  • name — varchar(100)
  • capacity — tinyint
  • floor — tinyint
  • bathtub_flag — tinyint(1)
  • view_type — tinyint
  • created_at — datetime

users

  • user_id — bigint — Primary key — NOT NULL
  • username — varchar(100)
  • password — varchar(100)
  • point — bigint