Hotel
Tables (8)
hotels
- hotel_id — bigint — Primary key — NOT NULL — AUTO_INCREMENT
- name — varchar(100) — NOT NULL
images
- image_id — bigint — Primary key — NOT NULL
- content — varchar(100)
reservations
- reservation_id — bigint — Primary key — NOT NULL — auto_increment
- user_id — bigint — Foreign key → users.user_id — NOT NULL
- room_id — bigint — Foreign key → rooms.room_id — NOT NULL
- start_date — date
- end_date — date
- num_people — int
review_image
- review_image_id — bigint — Primary key — NOT NULL
- review_id — bigint — Foreign key → reviews.review_id — NOT NULL
- image_id (image_id2) — bigint — Foreign key → images.image_id — NOT NULL
reviews
- review_id — bigint — Primary key — NOT NULL
- reservation_id — bigint — Foreign key → reservations.reservation_id — NOT NULL — auto_increment
- content — text
- approved_flag — tinyint(1)
- created_at — datetime
room_image
- room_image_id — bigint — Primary key — NOT NULL
- room_id — bigint — Foreign key → rooms.room_id — NOT NULL
- image_id — bigint — Foreign key → images.image_id — NOT NULL
rooms
- room_id — bigint — Primary key — NOT NULL
- hotel_id — bigint — Foreign key → hotels.hotel_id — NOT NULL — AUTO_INCREMENT
- name — varchar(100)
- capacity — tinyint
- floor — tinyint
- bathtub_flag — tinyint(1)
- view_type — tinyint
- created_at — datetime
users
- user_id — bigint — Primary key — NOT NULL
- username — varchar(100)
- password — varchar(100)
- point — bigint