1118
Tables (11)
Hotels (hotels)
- hotel_id — bigint — Primary key — NOT NULL
- name — varchar(100)
Point (points)
- point_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → Users.user_id — NOT NULL
- amount — decimal
- expired_at — datetime
Price (prices)
- price_id — bigint — Primary key — NOT NULL
- amount — decimal
- room_id — bigint — Foreign key → Rooms.room_id — NOT NULL
Reservation (reservations)
- reservation_id — bigint — Primary key — NOT NULL
- room_id — bigint — Foreign key → Rooms.room_id — NOT NULL
- user_id — bigint — Foreign key → Users.user_id — NOT NULL
- headcount — tinyint
- checkin_at — datetime
- reserved_at — datetime
- checkout_at — datetime
Reservation_Point (reservation_points)
- point_id — bigint — Foreign key → Point.point_id — NOT NULL
- reservation_id — bigint — Foreign key → Reservation.reservation_id — NOT NULL
Review (reviews)
- review_id — bigint — Primary key — NOT NULL
- room_id — bigint — Foreign key → Rooms.room_id — NOT NULL
- user_id — bigint — Foreign key → Users.user_id — NOT NULL
- reservation_id — bigint — Foreign key → Reservation.reservation_id — NOT NULL
- content — text
- expose_flag — tinyint
- created_at (create_at) — datetime
Review_Point (review_points)
- point_id — bigint — Foreign key → Point.point_id — NOT NULL
- review_id — bigint — Foreign key → Review.review_id — NOT NULL
Room_Images (room_images)
- image_id — bigint — Primary key — NOT NULL
- room_id — bigint — Foreign key → Rooms.room_id — NOT NULL
- path — varchar(100)
Rooms (rooms)
- room_id — bigint — Primary key — NOT NULL
- hotel_id — bigint — Foreign key → Hotels.hotel_id — NOT NULL
- name — varchar(100)
- capacity — tinyint
- floor — tinyint
- bathtub_flag (view_type) — tinyint
- created_at — datetime
State (states)
- state_id — bigint — Primary key — NOT NULL
- room_id — bigint — Foreign key → Rooms.room_id — NOT NULL
- name — varchar(100)
Users (users)
- user_id — bigint — Primary key — NOT NULL
- username — varchar(100)
- password — varchar(100)