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,
"breed_code" VARCHAR(10),
"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,
"first_name" VARCHAR(50),
"last_name" VARCHAR(50),
PRIMARY KEY ("professional_id")
);





INSERT INTO "Dogs" VALUES ("1", "BC01", "Max");
INSERT INTO "Dogs" VALUES ("2", "GD02", "Bella");
INSERT INTO "Dogs" VALUES ("3", "LB03", "Charlie");
INSERT INTO "Dogs" VALUES ("4", "BG04", "Lucy");
INSERT INTO "Dogs" VALUES ("5", "PT05", "Daisy");
INSERT INTO "Dogs" VALUES ("6", "BD06", "Molly");
INSERT INTO "Dogs" VALUES ("7", "RG07", "Bailey");
INSERT INTO "Dogs" VALUES ("8", "CH08", "Cooper");
INSERT INTO "Dogs" VALUES ("9", "SH09", "Lola");
INSERT INTO "Dogs" VALUES ("10", "GR10", "Sadie");
INSERT INTO "Owners" VALUES ("1", "John", "Smith");
INSERT INTO "Owners" VALUES ("2", "Emily", "Johnson");
INSERT INTO "Owners" VALUES ("3", "Michael", "Williams");
INSERT INTO "Owners" VALUES ("4", "Sarah", "Brown");
INSERT INTO "Owners" VALUES ("5", "David", "Jones");
INSERT INTO "Owners" VALUES ("6", "Anna", "Garcia");
INSERT INTO "Owners" VALUES ("7", "James", "Miller");
INSERT INTO "Owners" VALUES ("8", "Laura", "Davis");
INSERT INTO "Owners" VALUES ("9", "Robert", "Martinez");
INSERT INTO "Owners" VALUES ("10", "Linda", "Hernandez");
INSERT INTO "Professionals" VALUES ("1", "Mark", "Wilson");
INSERT INTO "Professionals" VALUES ("2", "Jessica", "Moore");
INSERT INTO "Professionals" VALUES ("3", "Daniel", "Taylor");
INSERT INTO "Professionals" VALUES ("4", "Karen", "Anderson");
INSERT INTO "Professionals" VALUES ("5", "Paul", "Thomas");
INSERT INTO "Professionals" VALUES ("6", "Nancy", "Jackson");
INSERT INTO "Professionals" VALUES ("7", "Steven", "White");
INSERT INTO "Professionals" VALUES ("8", "Betty", "Harris");
INSERT INTO "Professionals" VALUES ("9", "George", "Martin");
INSERT INTO "Professionals" VALUES ("10", "Susan", "Thompson");