
CREATE TABLE hotels(
 id INT AUTO_INCREMENT PRIMARY KEY,
 hotel_name VARCHAR(255),
 city VARCHAR(100),
 total_rooms INT
);

CREATE TABLE users(
 id INT AUTO_INCREMENT PRIMARY KEY,
 name VARCHAR(255),
 email VARCHAR(255),
 password VARCHAR(255),
 role VARCHAR(50),
 hotel_id INT
);

CREATE TABLE monthly_data(
 id INT AUTO_INCREMENT PRIMARY KEY,
 hotel_id INT,
 financial_year VARCHAR(20),
 month_name VARCHAR(20),
 revenue DECIMAL(12,2),
 room_nights INT,
 adr DECIMAL(10,2),
 revpar DECIMAL(10,2),
 occupancy DECIMAL(5,2),
 pickup_revenue DECIMAL(12,2),
 pickup_rn INT,
 budget DECIMAL(12,2),
 forecast DECIMAL(12,2)
);
