hotel
Tables (9)
Hotels (hotels)
- Key (hotel_id) — bigint — Primary key — NOT NULL
- Field (name) — varchar(100) — NOT NULL
Point (point)
- Key (id) — bigint — Primary key — NOT NULL
- Key (user_id) — bigint — Foreign key → User.Key — NOT NULL
- Key (point_history_id) — bigint — Foreign key → Point_History.Key — NOT NULL
Point_History (point_history)
- Key (id) — bigint — Primary key — NOT NULL
- Field (point) — bigint — NOT NULL
- Field (created_at) — datetime — NOT NULL
Reservation (reservation)
- Key (id) — bigint — Primary key — NOT NULL
- Field (check_in) — datetime — NOT NULL
- Field (check_out) — datetime — NOT NULL
- Field (headcount) — tinyint — NOT NULL
- Key (user_id) — bigint — Foreign key → User.Key — NOT NULL
- Field (created_at) — datetime — NOT NULL
- Key (room_id) — bigint — Foreign key → Rooms.Key — NOT NULL
Review (review)
- Key (id) — bigint — Primary key — NOT NULL
- Key (user_id) — bigint — Foreign key → User.Key — NOT NULL
- Key (room_id) — bigint — Foreign key → Rooms.Key — NOT NULL
- Field (text) — text — NOT NULL
Review_Image (review_image)
- Key (id) — bigint — Primary key — NOT NULL
- Field (image_name) — varchar(255) — NOT NULL
- Key (review_id) — bigint — Foreign key → Review.Key — NOT NULL
- Field (view_flag) — tinyint(1) — NOT NULL
Rooms (rooms)
- Key (room_id) — bigint — Primary key — NOT NULL
- Key (hotel_id) — bigint — Foreign key → Hotels.Key — NOT NULL
- Field (name) — varchar(100) — NOT NULL
- Field (capacity) — tinyint — NOT NULL
- Field (floor) — tinyint — NOT NULL
- Field (bathtub_flag) — tinyint(1) — NOT NULL
- Field (view_type) — tinyint — NOT NULL
- Field (created_at) — datetime — NOT NULL
Rooms_Image (rooms_image)
- Key (id) — bigint — Primary key — NOT NULL
- Field (image_name) — varchar(255) — NOT NULL
- Key (room_id) — bigint — Foreign key → Rooms.Key — NOT NULL
User (user)
- Key (id) — bigint — Primary key — NOT NULL
- Field (username) — varchar(150) — NOT NULL
- Field2 (password) — varchar(150) — NOT NULL