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),
"home_phone" VARCHAR(20),
"cell_number" VARCHAR(20),
PRIMARY KEY ("owner_id")
);

CREATE TABLE "Professionals" (
"professional_id" INT,
"email_address" VARCHAR(50),
"home_phone" VARCHAR(20),
"cell_number" VARCHAR(20),
PRIMARY KEY ("professional_id")
);





INSERT INTO "Owners" VALUES ("1", "john.doe@example.com", "555-123-4567", "555-987-6543");
INSERT INTO "Owners" VALUES ("2", "jane.smith@example.com", "555-234-5678", "555-876-5432");
INSERT INTO "Owners" VALUES ("3", "bob.johnson@example.com", "555-345-6789", "555-765-4321");
INSERT INTO "Owners" VALUES ("4", "alice.williams@example.com", "555-456-7890", "555-654-3210");
INSERT INTO "Owners" VALUES ("5", "charlie.brown@example.com", "555-567-8901", "555-543-2109");
INSERT INTO "Professionals" VALUES ("1", "vet1@example.com", "555-111-2222", "555-333-4444");
INSERT INTO "Professionals" VALUES ("2", "trainer2@example.com", "555-555-6666", "555-777-8888");
INSERT INTO "Professionals" VALUES ("3", "groomer3@example.com", "555-999-0000", "555-101-2020");
INSERT INTO "Professionals" VALUES ("4", "vet4@example.com", "NULL", "555-212-3232");
INSERT INTO "Professionals" VALUES ("5", "trainer5@example.com", "555-434-5454", "NULL");
INSERT INTO "Professionals" VALUES ("6", "groomer6@example.com", "NULL", "NULL");