Closed khalif-FiqiNaleye closed 6 months ago
--Create Amenities Table CREATE TABLE Amenities ( amenity_id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(100) );
-- Create Property_Amenities Table (to represent the amenities associated with each property) CREATE TABLE Property_Amenities ( property_id INT, amenity_id INT, PRIMARY KEY (property_id, amenity_id), FOREIGN KEY (property_id) REFERENCES Properties(property_id), FOREIGN KEY (amenity_id) REFERENCES Amenities(amenity_id) );
-- Create Neighborhoods Table CREATE TABLE Neighborhoods ( neighborhood_id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(100) );
-- Create Property_Neighborhoods Table (to represent the neighborhoods associated with each property) CREATE TABLE Property_Neighborhoods ( property_id INT, neighborhood_id INT, PRIMARY KEY (property_id, neighborhood_id), FOREIGN KEY (property_id) REFERENCES Properties(property_id), FOREIGN KEY (neighborhood_id) REFERENCES Neighborhoods(neighborhood_id) );
--Create Amenities Table CREATE TABLE Amenities ( amenity_id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(100) );
-- Create Property_Amenities Table (to represent the amenities associated with each property) CREATE TABLE Property_Amenities ( property_id INT, amenity_id INT, PRIMARY KEY (property_id, amenity_id), FOREIGN KEY (property_id) REFERENCES Properties(property_id), FOREIGN KEY (amenity_id) REFERENCES Amenities(amenity_id) );
-- Create Neighborhoods Table CREATE TABLE Neighborhoods ( neighborhood_id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(100) );
-- Create Property_Neighborhoods Table (to represent the neighborhoods associated with each property) CREATE TABLE Property_Neighborhoods ( property_id INT, neighborhood_id INT, PRIMARY KEY (property_id, neighborhood_id), FOREIGN KEY (property_id) REFERENCES Properties(property_id), FOREIGN KEY (neighborhood_id) REFERENCES Neighborhoods(neighborhood_id) );