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,
"street" VARCHAR(50),
"city" 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")
);

CREATE TABLE "Treatment_Types" (
"treatment_type_code" VARCHAR(10),
"treatment_type_description" VARCHAR(80),
PRIMARY KEY ("treatment_type_code")
);





INSERT INTO "Owners" VALUES ("1", "123 Maple St", "Westfield");
INSERT INTO "Owners" VALUES ("2", "456 Oak St", "Eastville");
INSERT INTO "Owners" VALUES ("3", "789 Pine St", "Northwest");
INSERT INTO "Owners" VALUES ("4", "321 Birch St", "Southtown");
INSERT INTO "Owners" VALUES ("5", "654 Cedar St", "Westport");
INSERT INTO "Owners" VALUES ("6", "987 Elm St", "Central City");
INSERT INTO "Professionals" VALUES ("1", "VET", "12 West Ave", "Westfield", "California");
INSERT INTO "Professionals" VALUES ("2", "GROOM", "34 East Blvd", "Eastville", "Texas");
INSERT INTO "Professionals" VALUES ("3", "TRAIN", "56 Northwest Rd", "Northwest", "Oregon");
INSERT INTO "Professionals" VALUES ("4", "VET", "78 South St", "Southtown", "Florida");
INSERT INTO "Professionals" VALUES ("5", "GROOM", "90 Westport Ln", "Westport", "New York");
INSERT INTO "Professionals" VALUES ("6", "TRAIN", "11 Central Pkwy", "Central City", "Nevada");
INSERT INTO "Professionals" VALUES ("7", "VET", "22 Westside Dr", "Westside", "Washington");
INSERT INTO "Professionals" VALUES ("8", "GROOM", "33 West End", "West End", "Illinois");
INSERT INTO "Treatment_Types" VALUES ("T01", "Vaccination");
INSERT INTO "Treatment_Types" VALUES ("T02", "Deworming");
INSERT INTO "Treatment_Types" VALUES ("T03", "Dental Cleaning");
INSERT INTO "Treatment_Types" VALUES ("T04", "Surgery");
INSERT INTO "Treatment_Types" VALUES ("T05", "Grooming");
INSERT INTO "Treatment_Types" VALUES ("T06", "Training");