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,
"email_address" VARCHAR(50),
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", "alice@example.com");
INSERT INTO "Owners" VALUES ("2", "bob@example.com");
INSERT INTO "Owners" VALUES ("3", "carol@example.com");
INSERT INTO "Owners" VALUES ("4", "dave@example.com");
INSERT INTO "Owners" VALUES ("5", "eve@example.com");
INSERT INTO "Professionals" VALUES ("1", "Vet", "123 Westview Dr", "Westminster", "California");
INSERT INTO "Professionals" VALUES ("2", "Groomer", "456 Eastside Ave", "Eastville", "New York");
INSERT INTO "Professionals" VALUES ("3", "Trainer", "789 West End Blvd", "Westport", "Connecticut");
INSERT INTO "Professionals" VALUES ("4", "Walker", "101 North St", "Northfield", "Illinois");
INSERT INTO "Professionals" VALUES ("5", "Vet", "202 Westlake Rd", "Lakewood", "Ohio");
INSERT INTO "Professionals" VALUES ("6", "Groomer", "303 South St", "Southtown", "Texas");
INSERT INTO "Professionals" VALUES ("7", "Trainer", "404 Westfield Ln", "Westfield", "Massachusetts");
INSERT INTO "Professionals" VALUES ("8", "Walker", "505 Central Ave", "Central City", "Colorado");
INSERT INTO "Professionals" VALUES ("9", "Vet", "606 Westside St", "Westside", "Florida");
INSERT INTO "Professionals" VALUES ("10", "Groomer", "707 Oldtown Rd", "Oldtown", "Maine");