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