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