exam-hotel
Tables (3)
hotels
- hotel_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
reservations
- reservation_id — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
- user_id — VARCHAR(100) — NOT NULL
- reservation_start_at — DATE — NOT NULL
- reservation_end_at — DATE — NOT NULL
- guest_count (guest_coount) — INT — 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