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,
"owner_id" INT,
"breed_code" VARCHAR(10),
"name" VARCHAR(50),
PRIMARY KEY ("dog_id"),
FOREIGN KEY ("owner_id") REFERENCES "Owners"("owner_id")
);

CREATE TABLE "Owners" (
"owner_id" INT UNIQUE,
"first_name" VARCHAR(50),
"last_name" VARCHAR(50),
PRIMARY KEY ("owner_id")
);

CREATE TABLE "Professionals" (
"professional_id" INT,
PRIMARY KEY ("professional_id")
);





INSERT INTO "Owners" VALUES ("1", "Alice", "Smith");
INSERT INTO "Owners" VALUES ("2", "Bob", "Johnson");
INSERT INTO "Owners" VALUES ("3", "Charlie", "Brown");
INSERT INTO "Owners" VALUES ("4", "Diana", "Prince");
INSERT INTO "Owners" VALUES ("5", "Eve", "Adams");
INSERT INTO "Owners" VALUES ("6", "Frank", "White");
INSERT INTO "Owners" VALUES ("7", "Grace", "Davis");
INSERT INTO "Dogs" VALUES ("1", "1", "Labrador", "Buddy");
INSERT INTO "Dogs" VALUES ("2", "1", "Golden Retriever", "Max");
INSERT INTO "Dogs" VALUES ("3", "1", "Beagle", "Lucy");
INSERT INTO "Dogs" VALUES ("4", "2", "German Shepherd", "Rocky");
INSERT INTO "Dogs" VALUES ("5", "2", "Poodle", "Daisy");
INSERT INTO "Dogs" VALUES ("6", "3", "Bulldog", "Duke");
INSERT INTO "Dogs" VALUES ("7", "4", "Dachshund", "Bella");
INSERT INTO "Dogs" VALUES ("8", "4", "Siberian Husky", "Luna");
INSERT INTO "Dogs" VALUES ("9", "5", "Chihuahua", "Milo");
INSERT INTO "Dogs" VALUES ("10", "6", "Boxer", "Bailey");
INSERT INTO "Dogs" VALUES ("11", "7", "Rottweiler", "Shadow");
INSERT INTO "Dogs" VALUES ("12", "1", "Pug", "Oscar");
INSERT INTO "Dogs" VALUES ("13", "2", "Shih Tzu", "Coco");
INSERT INTO "Dogs" VALUES ("14", "3", "Border Collie", "Zoe");
INSERT INTO "Dogs" VALUES ("15", "4", "Australian Shepherd", "Cooper");
INSERT INTO "Dogs" VALUES ("16", "1", "Yorkshire Terrier", "Sophie");
INSERT INTO "Dogs" VALUES ("17", "1", "French Bulldog", "Leo");
INSERT INTO "Dogs" VALUES ("18", "1", "Shetland Sheepdog", "Penny");
INSERT INTO "Professionals" VALUES ("101");
INSERT INTO "Professionals" VALUES ("102");
INSERT INTO "Professionals" VALUES ("103");