test

Tables (3)

Hotels

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

Reservation

  • reservationId — bit int — Primary key — NOT NULL
  • room_id — bigint — Foreign key → Rooms.room_id
  • Field

Rooms

  • room_id — bigint — Primary key
  • hotel_id — 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