PRAGMA foreign_keys = ON;

PRAGMA writable_schema = 1;
DELETE FROM sqlite_master WHERE type IN ("table", "index", "trigger");
PRAGMA writable_schema = 0;
VACUUM;

CREATE TABLE "Other_Available_Features" (
"feature_id" INT UNIQUE,
"feature_type_code" VARCHAR(20),
PRIMARY KEY ("feature_id")
);

CREATE TABLE "Other_Property_Features" (
"feature_id" INT,
"property_feature_description" VARCHAR(80),
FOREIGN KEY ("feature_id") REFERENCES "Other_Available_Features"("feature_id")
);

CREATE TABLE "Properties" (
"property_id" INT UNIQUE,
PRIMARY KEY ("property_id")
);





INSERT INTO "Other_Available_Features" VALUES ("1", "Pool");
INSERT INTO "Other_Available_Features" VALUES ("2", "Garage");
INSERT INTO "Other_Available_Features" VALUES ("3", "Fireplace");
INSERT INTO "Other_Available_Features" VALUES ("4", "Garden");
INSERT INTO "Other_Available_Features" VALUES ("5", "Solar Panels");
INSERT INTO "Other_Available_Features" VALUES ("6", "Smart Home");
INSERT INTO "Other_Available_Features" VALUES ("7", "Basement");
INSERT INTO "Other_Available_Features" VALUES ("8", "Balcony");
INSERT INTO "Other_Available_Features" VALUES ("9", "Security System");
INSERT INTO "Other_Available_Features" VALUES ("10", "Home Theater");
INSERT INTO "Other_Available_Features" VALUES ("11", "Wine Cellar");
INSERT INTO "Other_Available_Features" VALUES ("12", "Sauna");
INSERT INTO "Other_Available_Features" VALUES ("13", "Elevator");
INSERT INTO "Other_Available_Features" VALUES ("14", "Guest House");
INSERT INTO "Other_Available_Features" VALUES ("15", "None");
INSERT INTO "Other_Property_Features" VALUES ("1", "Outdoor heated pool with lighting");
INSERT INTO "Other_Property_Features" VALUES ("2", "Two-car garage with automatic doors");
INSERT INTO "Other_Property_Features" VALUES ("3", "Stone fireplace in living room");
INSERT INTO "Other_Property_Features" VALUES ("4", "Landscaped garden with irrigation system");
INSERT INTO "Other_Property_Features" VALUES ("5", "Roof-mounted solar panels with battery storage");
INSERT INTO "Other_Property_Features" VALUES ("6", "Smart thermostat and lighting control");
INSERT INTO "Other_Property_Features" VALUES ("7", "Finished basement with recreation room");
INSERT INTO "Other_Property_Features" VALUES ("8", "Balcony with city view");
INSERT INTO "Other_Property_Features" VALUES ("9", "24/7 monitored security system");
INSERT INTO "Other_Property_Features" VALUES ("10", "Built-in home theater with surround sound");
INSERT INTO "Other_Property_Features" VALUES ("11", "Climate-controlled wine cellar");
INSERT INTO "Other_Property_Features" VALUES ("12", "Sauna room with steam generator");
INSERT INTO "Other_Property_Features" VALUES ("13", "Elevator access to all floors");
INSERT INTO "Other_Property_Features" VALUES ("14", "Separate guest house with kitchen");
INSERT INTO "Other_Property_Features" VALUES ("2", "Garage with workshop area");
INSERT INTO "Other_Property_Features" VALUES ("4", "Garden with vegetable patch");
INSERT INTO "Properties" VALUES ("101");
INSERT INTO "Properties" VALUES ("102");
INSERT INTO "Properties" VALUES ("103");
INSERT INTO "Properties" VALUES ("104");
INSERT INTO "Properties" VALUES ("105");
INSERT INTO "Properties" VALUES ("106");
INSERT INTO "Properties" VALUES ("107");
INSERT INTO "Properties" VALUES ("108");
INSERT INTO "Properties" VALUES ("109");
INSERT INTO "Properties" VALUES ("110");