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 "Owners" (
"owner_id" INT,
"street" VARCHAR(50),
"city" VARCHAR(50),
"state" VARCHAR(20),
PRIMARY KEY ("owner_id")
);

CREATE TABLE "Professionals" (
"professional_id" INT,
"role_code" VARCHAR(10),
"street" VARCHAR(50),
"city" VARCHAR(50),
"state" VARCHAR(20),
PRIMARY KEY ("professional_id")
);





INSERT INTO "Owners" VALUES ("1", "123 Main St", "Springfield", "IL");
INSERT INTO "Owners" VALUES ("2", "456 Oak Ave", "Westwood", "CA");
INSERT INTO "Owners" VALUES ("3", "789 Pine Ln", "Eastville", "NY");
INSERT INTO "Owners" VALUES ("4", "101 Elm Rd", "North West City", "TX");
INSERT INTO "Owners" VALUES ("5", "202 Maple Dr", "Southtown", "FL");
INSERT INTO "Owners" VALUES ("6", "303 Birch Ct", "West Bend", "WI");
INSERT INTO "Owners" VALUES ("7", "404 Cedar Blvd", "Central City", "OH");
INSERT INTO "Owners" VALUES ("8", "505 Spruce Pkwy", "West Palm Beach", "FL");
INSERT INTO "Owners" VALUES ("9", "606 Willow Way", "Rivertown", "GA");
INSERT INTO "Owners" VALUES ("10", "707 Poplar Cir", "Westford", "MA");
INSERT INTO "Professionals" VALUES ("1", "VET", "10 Main St", "Springfield", "IL");
INSERT INTO "Professionals" VALUES ("2", "TRAINER", "20 Oak Ave", "Westwood", "CA");
INSERT INTO "Professionals" VALUES ("3", "GROOMER", "30 Pine Ln", "Eastville", "NY");
INSERT INTO "Professionals" VALUES ("4", "VET", "40 Elm Rd", "North West City", "TX");
INSERT INTO "Professionals" VALUES ("5", "TRAINER", "50 Maple Dr", "Southtown", "FL");
INSERT INTO "Professionals" VALUES ("6", "GROOMER", "60 Birch Ct", "West Bend", "WI");
INSERT INTO "Professionals" VALUES ("7", "VET", "70 Cedar Blvd", "Central City", "OH");
INSERT INTO "Professionals" VALUES ("8", "TRAINER", "80 Spruce Pkwy", "West Palm Beach", "FL");
INSERT INTO "Professionals" VALUES ("9", "GROOMER", "90 Willow Way", "Rivertown", "GA");
INSERT INTO "Professionals" VALUES ("10", "VET", "100 Poplar Cir", "Westford", "MA");
INSERT INTO "Professionals" VALUES ("11", "TRAINER", "110 Lake Rd", "Lake West", "CO");
INSERT INTO "Professionals" VALUES ("12", "GROOMER", "120 Hill St", "Hillside", "WA");
INSERT INTO "Professionals" VALUES ("13", "VET", "130 River Dr", "West Riverton", "OR");
INSERT INTO "Professionals" VALUES ("14", "TRAINER", "140 Mountain Ave", "Mountain View", "AZ");
INSERT INTO "Professionals" VALUES ("15", "GROOMER", "150 Valley Blvd", "Valley West", "NV");