
CREATE TABLE "Features" (
	"Feature_ID" INTEGER NOT NULL, 
	"Feature_Details" VARCHAR(255), 
	PRIMARY KEY ("Feature_ID")
)


CREATE TABLE "Hotels" (
	hotel_id INTEGER NOT NULL, 
	star_rating_code CHAR(15) NOT NULL, 
	pets_allowed_yn CHAR(1), 
	price_range REAL, 
	other_hotel_details VARCHAR(255), 
	PRIMARY KEY (hotel_id), 
	FOREIGN KEY(star_rating_code) REFERENCES "Ref_Hotel_Star_Ratings" (star_rating_code)
)


CREATE TABLE "Locations" (
	"Location_ID" INTEGER NOT NULL, 
	"Location_Name" VARCHAR(255), 
	"Address" VARCHAR(255), 
	"Other_Details" VARCHAR(255), 
	PRIMARY KEY ("Location_ID")
)


CREATE TABLE "Museums" (
	"Museum_ID" INTEGER NOT NULL, 
	"Museum_Details" VARCHAR(255), 
	PRIMARY KEY ("Museum_ID"), 
	FOREIGN KEY("Museum_ID") REFERENCES "Tourist_Attractions" ("Tourist_Attraction_ID")
)


CREATE TABLE "Photos" (
	"Photo_ID" INTEGER NOT NULL, 
	"Tourist_Attraction_ID" INTEGER NOT NULL, 
	"Name" VARCHAR(255), 
	"Description" VARCHAR(255), 
	"Filename" VARCHAR(255), 
	"Other_Details" VARCHAR(255), 
	PRIMARY KEY ("Photo_ID"), 
	FOREIGN KEY("Tourist_Attraction_ID") REFERENCES "Tourist_Attractions" ("Tourist_Attraction_ID")
)


CREATE TABLE "Ref_Attraction_Types" (
	"Attraction_Type_Code" CHAR(15) NOT NULL, 
	"Attraction_Type_Description" VARCHAR(255), 
	PRIMARY KEY ("Attraction_Type_Code"), 
	UNIQUE ("Attraction_Type_Code")
)


CREATE TABLE "Ref_Hotel_Star_Ratings" (
	star_rating_code CHAR(15) NOT NULL, 
	star_rating_description VARCHAR(80), 
	PRIMARY KEY (star_rating_code), 
	UNIQUE (star_rating_code)
)


CREATE TABLE "Royal_Family" (
	"Royal_Family_ID" INTEGER NOT NULL, 
	"Royal_Family_Details" VARCHAR(255), 
	PRIMARY KEY ("Royal_Family_ID"), 
	FOREIGN KEY("Royal_Family_ID") REFERENCES "Tourist_Attractions" ("Tourist_Attraction_ID")
)


CREATE TABLE "Shops" (
	"Shop_ID" INTEGER NOT NULL, 
	"Shop_Details" VARCHAR(255), 
	PRIMARY KEY ("Shop_ID"), 
	FOREIGN KEY("Shop_ID") REFERENCES "Tourist_Attractions" ("Tourist_Attraction_ID")
)


CREATE TABLE "Staff" (
	"Staff_ID" INTEGER NOT NULL, 
	"Tourist_Attraction_ID" INTEGER NOT NULL, 
	"Name" VARCHAR(40), 
	"Other_Details" VARCHAR(255), 
	PRIMARY KEY ("Staff_ID"), 
	FOREIGN KEY("Tourist_Attraction_ID") REFERENCES "Tourist_Attractions" ("Tourist_Attraction_ID")
)


CREATE TABLE "Street_Markets" (
	"Market_ID" INTEGER NOT NULL, 
	"Market_Details" VARCHAR(255), 
	PRIMARY KEY ("Market_ID"), 
	FOREIGN KEY("Market_ID") REFERENCES "Tourist_Attractions" ("Tourist_Attraction_ID")
)


CREATE TABLE "Theme_Parks" (
	"Theme_Park_ID" INTEGER NOT NULL, 
	"Theme_Park_Details" VARCHAR(255), 
	PRIMARY KEY ("Theme_Park_ID"), 
	FOREIGN KEY("Theme_Park_ID") REFERENCES "Tourist_Attractions" ("Tourist_Attraction_ID")
)


CREATE TABLE "Tourist_Attraction_Features" (
	"Tourist_Attraction_ID" INTEGER NOT NULL, 
	"Feature_ID" INTEGER NOT NULL, 
	PRIMARY KEY ("Tourist_Attraction_ID", "Feature_ID"), 
	FOREIGN KEY("Tourist_Attraction_ID") REFERENCES "Tourist_Attractions" ("Tourist_Attraction_ID"), 
	FOREIGN KEY("Feature_ID") REFERENCES "Features" ("Feature_ID")
)


CREATE TABLE "Tourist_Attractions" (
	"Tourist_Attraction_ID" INTEGER NOT NULL, 
	"Attraction_Type_Code" CHAR(15) NOT NULL, 
	"Location_ID" INTEGER NOT NULL, 
	"How_to_Get_There" VARCHAR(255), 
	"Name" VARCHAR(255), 
	"Description" VARCHAR(255), 
	"Opening_Hours" VARCHAR(255), 
	"Other_Details" VARCHAR(255), 
	PRIMARY KEY ("Tourist_Attraction_ID"), 
	FOREIGN KEY("Location_ID") REFERENCES "Locations" ("Location_ID"), 
	FOREIGN KEY("Attraction_Type_Code") REFERENCES "Ref_Attraction_Types" ("Attraction_Type_Code")
)


CREATE TABLE "Visitors" (
	"Tourist_ID" INTEGER NOT NULL, 
	"Tourist_Details" VARCHAR(255), 
	PRIMARY KEY ("Tourist_ID"), 
	UNIQUE ("Tourist_ID")
)


CREATE TABLE "Visits" (
	"Visit_ID" INTEGER NOT NULL, 
	"Tourist_Attraction_ID" INTEGER NOT NULL, 
	"Tourist_ID" INTEGER NOT NULL, 
	"Visit_Date" DATETIME NOT NULL, 
	"Visit_Details" VARCHAR(40) NOT NULL, 
	PRIMARY KEY ("Visit_ID"), 
	FOREIGN KEY("Tourist_Attraction_ID") REFERENCES "Tourist_Attractions" ("Tourist_Attraction_ID"), 
	FOREIGN KEY("Tourist_ID") REFERENCES "Visitors" ("Tourist_ID")
)

CREATE TABLE "Features" (
	"Feature_ID" INTEGER NOT NULL, 
	"Feature_Details" VARCHAR(255), 
	PRIMARY KEY ("Feature_ID")
)

/*
2 rows from Features table:
Feature_ID	Feature_Details
523	cafe
528	park
*/


CREATE TABLE "Hotels" (
	hotel_id INTEGER NOT NULL, 
	star_rating_code CHAR(15) NOT NULL, 
	pets_allowed_yn CHAR(1), 
	price_range REAL, 
	other_hotel_details VARCHAR(255), 
	PRIMARY KEY (hotel_id), 
	FOREIGN KEY(star_rating_code) REFERENCES "Ref_Hotel_Star_Ratings" (star_rating_code)
)

/*
2 rows from Hotels table:
hotel_id	star_rating_code	pets_allowed_yn	price_range	other_hotel_details
123	5	1	2914989.571	None
144	4			None
*/


CREATE TABLE "Locations" (
	"Location_ID" INTEGER NOT NULL, 
	"Location_Name" VARCHAR(255), 
	"Address" VARCHAR(255), 
	"Other_Details" VARCHAR(255), 
	PRIMARY KEY ("Location_ID")
)

/*
2 rows from Locations table:
Location_ID	Location_Name	Address	Other_Details
333	Astro Orbiter	660 Shea Crescent	None
368	African Animals	254 Ottilie Junction	None
*/


CREATE TABLE "Museums" (
	"Museum_ID" INTEGER NOT NULL, 
	"Museum_Details" VARCHAR(255), 
	PRIMARY KEY ("Museum_ID"), 
	FOREIGN KEY("Museum_ID") REFERENCES "Tourist_Attractions" ("Tourist_Attraction_ID")
)

/*
2 rows from Museums table:
Museum_ID	Museum_Details
2113	Yale Center for British Art
2701	The Metropolitan Museum of Art
*/


CREATE TABLE "Photos" (
	"Photo_ID" INTEGER NOT NULL, 
	"Tourist_Attraction_ID" INTEGER NOT NULL, 
	"Name" VARCHAR(255), 
	"Description" VARCHAR(255), 
	"Filename" VARCHAR(255), 
	"Other_Details" VARCHAR(255), 
	PRIMARY KEY ("Photo_ID"), 
	FOREIGN KEY("Tourist_Attraction_ID") REFERENCES "Tourist_Attractions" ("Tourist_Attraction_ID")
)

/*
2 rows from Photos table:
Photo_ID	Tourist_Attraction_ID	Name	Description	Filename	Other_Details
211	8449	game1	None	702	None
280	7067	game2	None	762	None
*/


CREATE TABLE "Ref_Attraction_Types" (
	"Attraction_Type_Code" CHAR(15) NOT NULL, 
	"Attraction_Type_Description" VARCHAR(255), 
	PRIMARY KEY ("Attraction_Type_Code"), 
	UNIQUE ("Attraction_Type_Code")
)

/*
2 rows from Ref_Attraction_Types table:
Attraction_Type_Code	Attraction_Type_Description
2	park
3	garden
*/


CREATE TABLE "Ref_Hotel_Star_Ratings" (
	star_rating_code CHAR(15) NOT NULL, 
	star_rating_description VARCHAR(80), 
	PRIMARY KEY (star_rating_code), 
	UNIQUE (star_rating_code)
)

/*
2 rows from Ref_Hotel_Star_Ratings table:
star_rating_code	star_rating_description
1	star
2	star
*/


CREATE TABLE "Royal_Family" (
	"Royal_Family_ID" INTEGER NOT NULL, 
	"Royal_Family_Details" VARCHAR(255), 
	PRIMARY KEY ("Royal_Family_ID"), 
	FOREIGN KEY("Royal_Family_ID") REFERENCES "Tourist_Attractions" ("Tourist_Attraction_ID")
)

/*
2 rows from Royal_Family table:
Royal_Family_ID	Royal_Family_Details
9561	None
9919	None
*/


CREATE TABLE "Shops" (
	"Shop_ID" INTEGER NOT NULL, 
	"Shop_Details" VARCHAR(255), 
	PRIMARY KEY ("Shop_ID"), 
	FOREIGN KEY("Shop_ID") REFERENCES "Tourist_Attractions" ("Tourist_Attraction_ID")
)

/*
2 rows from Shops table:
Shop_ID	Shop_Details
8429	soup
8449	coffee
*/


CREATE TABLE "Staff" (
	"Staff_ID" INTEGER NOT NULL, 
	"Tourist_Attraction_ID" INTEGER NOT NULL, 
	"Name" VARCHAR(40), 
	"Other_Details" VARCHAR(255), 
	PRIMARY KEY ("Staff_ID"), 
	FOREIGN KEY("Tourist_Attraction_ID") REFERENCES "Tourist_Attractions" ("Tourist_Attraction_ID")
)

/*
2 rows from Staff table:
Staff_ID	Tourist_Attraction_ID	Name	Other_Details
170	6476	Whitney	None
219	6476	Kaela	None
*/


CREATE TABLE "Street_Markets" (
	"Market_ID" INTEGER NOT NULL, 
	"Market_Details" VARCHAR(255), 
	PRIMARY KEY ("Market_ID"), 
	FOREIGN KEY("Market_ID") REFERENCES "Tourist_Attractions" ("Tourist_Attraction_ID")
)

/*
2 rows from Street_Markets table:
Market_ID	Market_Details
6852	Broadway
7067	Fish Farm Market
*/


CREATE TABLE "Theme_Parks" (
	"Theme_Park_ID" INTEGER NOT NULL, 
	"Theme_Park_Details" VARCHAR(255), 
	PRIMARY KEY ("Theme_Park_ID"), 
	FOREIGN KEY("Theme_Park_ID") REFERENCES "Tourist_Attractions" ("Tourist_Attraction_ID")
)

/*
2 rows from Theme_Parks table:
Theme_Park_ID	Theme_Park_Details
5265	Disney
6476	Sea World
*/


CREATE TABLE "Tourist_Attraction_Features" (
	"Tourist_Attraction_ID" INTEGER NOT NULL, 
	"Feature_ID" INTEGER NOT NULL, 
	PRIMARY KEY ("Tourist_Attraction_ID", "Feature_ID"), 
	FOREIGN KEY("Tourist_Attraction_ID") REFERENCES "Tourist_Attractions" ("Tourist_Attraction_ID"), 
	FOREIGN KEY("Feature_ID") REFERENCES "Features" ("Feature_ID")
)

/*
2 rows from Tourist_Attraction_Features table:
Tourist_Attraction_ID	Feature_ID
5076	528
5076	681
*/


CREATE TABLE "Tourist_Attractions" (
	"Tourist_Attraction_ID" INTEGER NOT NULL, 
	"Attraction_Type_Code" CHAR(15) NOT NULL, 
	"Location_ID" INTEGER NOT NULL, 
	"How_to_Get_There" VARCHAR(255), 
	"Name" VARCHAR(255), 
	"Description" VARCHAR(255), 
	"Opening_Hours" VARCHAR(255), 
	"Other_Details" VARCHAR(255), 
	PRIMARY KEY ("Tourist_Attraction_ID"), 
	FOREIGN KEY("Location_ID") REFERENCES "Locations" ("Location_ID"), 
	FOREIGN KEY("Attraction_Type_Code") REFERENCES "Ref_Attraction_Types" ("Attraction_Type_Code")
)

/*
2 rows from Tourist_Attractions table:
Tourist_Attraction_ID	Attraction_Type_Code	Location_ID	How_to_Get_There	Name	Description	Opening_Hours	Other_Details
2113	2	579	bus	art museum	None	None	None
2701	6	417	walk	UK gallery	None	None	None
*/


CREATE TABLE "Visitors" (
	"Tourist_ID" INTEGER NOT NULL, 
	"Tourist_Details" VARCHAR(255), 
	PRIMARY KEY ("Tourist_ID"), 
	UNIQUE ("Tourist_ID")
)

/*
2 rows from Visitors table:
Tourist_ID	Tourist_Details
164	Toney
189	Graciela
*/


CREATE TABLE "Visits" (
	"Visit_ID" INTEGER NOT NULL, 
	"Tourist_Attraction_ID" INTEGER NOT NULL, 
	"Tourist_ID" INTEGER NOT NULL, 
	"Visit_Date" DATETIME NOT NULL, 
	"Visit_Details" VARCHAR(40) NOT NULL, 
	PRIMARY KEY ("Visit_ID"), 
	FOREIGN KEY("Tourist_Attraction_ID") REFERENCES "Tourist_Attractions" ("Tourist_Attraction_ID"), 
	FOREIGN KEY("Tourist_ID") REFERENCES "Visitors" ("Tourist_ID")
)

/*
2 rows from Visits table:
Visit_ID	Tourist_Attraction_ID	Tourist_ID	Visit_Date	Visit_Details
183	6653	377	2004-08-21 03:06:14	
268	5076	204	2013-08-06 05:35:51	
*/
What is the name and detail of each staff member?
SELECT Name ,  Other_Details FROM Staff
[{'Name': 'Whitney', 'Other_Details': None}, {'Name': 'Kaela', 'Other_Details': None}, {'Name': 'Eunice', 'Other_Details': None}, {'Name': 'Kiarra', 'Other_Details': None}, {'Name': 'Phoebe', 'Other_Details': None}, {'Name': 'Vickie', 'Other_Details': None}, {'Name': 'Jannie', 'Other_Details': None}, {'Name': 'Lenore', 'Other_Details': None}, {'Name': 'Asia', 'Other_Details': None}, {'Name': 'Janet', 'Other_Details': None}, {'Name': 'Elouise', 'Other_Details': None}, {'Name': 'Gina', 'Other_Details': None}, {'Name': 'Beth', 'Other_Details': None}, {'Name': 'Ruthie', 'Other_Details': None}, {'Name': 'Aurore', 'Other_Details': None}, {'Name': 'Cortney', 'Other_Details': None}, {'Name': 'Astrid', 'Other_Details': None}, {'Name': 'Shemar', 'Other_Details': None}, {'Name': 'Trinity', 'Other_Details': None}, {'Name': 'Carmella', 'Other_Details': None}]