CREATE TABLE bookings (
id INT AUTO_INCREMENT PRIMARY KEY,
hotel_id INT,
room_id INT,
guest_id INT,
checkin_date DATE,
checkout_date DATE,
status ENUM('hold','book','confirm'),
advance_payment DECIMAL(10,2),
remaining_amount DECIMAL(10,2)
);