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 "Dogs" (
"dog_id" INT,
"name" VARCHAR(50),
PRIMARY KEY ("dog_id")
);

CREATE TABLE "Owners" (
"owner_id" INT,
"first_name" VARCHAR(50),
"last_name" 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 "Dogs" VALUES ("1", "Buddy");
INSERT INTO "Dogs" VALUES ("2", "Lucy");
INSERT INTO "Dogs" VALUES ("3", "Max");
INSERT INTO "Dogs" VALUES ("4", "Daisy");
INSERT INTO "Dogs" VALUES ("5", "Charlie");
INSERT INTO "Dogs" VALUES ("6", "Bella");
INSERT INTO "Dogs" VALUES ("7", "Rocky");
INSERT INTO "Dogs" VALUES ("8", "Luna");
INSERT INTO "Dogs" VALUES ("9", "Cooper");
INSERT INTO "Dogs" VALUES ("10", "Zoe");
INSERT INTO "Owners" VALUES ("1", "John", "Doe");
INSERT INTO "Owners" VALUES ("2", "Jane", "Smith");
INSERT INTO "Owners" VALUES ("3", "Peter", "Jones");
INSERT INTO "Owners" VALUES ("4", "Alice", "Brown");
INSERT INTO "Owners" VALUES ("5", "Robert", "Davis");
INSERT INTO "Owners" VALUES ("6", "Emily", "Wilson");
INSERT INTO "Owners" VALUES ("7", "Michael", "Miller");
INSERT INTO "Owners" VALUES ("8", "Sarah", "Moore");
INSERT INTO "Owners" VALUES ("9", "David", "Taylor");
INSERT INTO "Owners" VALUES ("10", "Jessica", "Anderson");
INSERT INTO "Professionals" VALUES ("1", "VET", "123 Main St", "Westwood", "CA");
INSERT INTO "Professionals" VALUES ("2", "TRAINER", "456 Oak Ave", "Eastville", "NY");
INSERT INTO "Professionals" VALUES ("3", "GROOMER", "789 Pine Ln", "North West City", "TX");
INSERT INTO "Professionals" VALUES ("4", "VET", "101 Elm Rd", "Southtown", "FL");
INSERT INTO "Professionals" VALUES ("5", "TRAINER", "202 Maple Dr", "West Palm Beach", "FL");
INSERT INTO "Professionals" VALUES ("6", "GROOMER", "303 Birch Ct", "Central City", "IL");
INSERT INTO "Professionals" VALUES ("7", "VET", "404 Cedar Blvd", "Westburg", "WA");
INSERT INTO "Professionals" VALUES ("8", "TRAINER", "505 Willow Way", "Greenville", "GA");
INSERT INTO "Professionals" VALUES ("9", "GROOMER", "606 Poplar Pl", "Westford", "MA");
INSERT INTO "Professionals" VALUES ("10", "VET", "707 Spruce St", "Springfield", "VA");
INSERT INTO "Professionals" VALUES ("11", "TRAINER", "808 Fir Ave", "West Lafayette", "IN");
INSERT INTO "Professionals" VALUES ("12", "GROOMER", "909 Redwood Dr", "New York", "NY");
INSERT INTO "Professionals" VALUES ("13", "VET", "111 Aspen Ct", "Westlake Village", "CA");
INSERT INTO "Professionals" VALUES ("14", "TRAINER", "222 Cypress Ln", "Westborough", "MA");
INSERT INTO "Professionals" VALUES ("15", "GROOMER", "333 Dogwood Rd", "West Mifflin", "PA");