exam_16

Tables (5)

hotels

  • hotel_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL

reservations

  • reservation_id — bigint — NOT NULL
  • user_id — bigint — Foreign key → users.user_id — NOT NULL
  • room_id — bigint — Foreign key → rooms.room_id — NOT NULL
  • hotel_id — bigint — Foreign key → hotels.hotel_id — NOT NULL
  • people — tinyint — NOT NULL
  • checkin_date — datetime — NOT NULL
  • checkout_date — datetime — NOT NULL
  • created_at — datetime — NOT NULL

reviews

  • review_id — bigint — NOT NULL
  • reservation_id — bigint — Foreign key → reservations.reservation_id — NOT NULL
  • review_score — tinyint — NOT NULL
  • review_content — varchar(500) — NOT NULL
  • created_at — datetime — NOT NULL

rooms

  • room_id — BIGINT — Primary key — NOT NULL
  • hotel_id — BIGINT — Foreign key → 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
  • isreserved — tinyint(1)
  • INDEX — `fk_Rooms_hotels_idx`
  • INDEX — `uk_hotel_roomname`

users

  • user_id — bigint — NOT NULL
  • password — varchar(15) — NOT NULL
  • nickname — varchar(15) — NOT NULL
  • name — varchar(30) — NOT NULL
  • phone_number — varchar(30) — NOT NULL
  • email — varchar(30) — NOT NULL
  • address — varchar(100) — NOT NULL