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 "Charges" (
"charge_id" INT,
"charge_type" VARCHAR(10),
"charge_amount" DECIMAL(19, 4),
PRIMARY KEY ("charge_id")
);

CREATE TABLE "Treatments" (
"treatment_id" INT,
"treatment_type_code" VARCHAR(10),
"cost_of_treatment" DECIMAL(19, 4),
PRIMARY KEY ("treatment_id")
);





INSERT INTO "Charges" VALUES ("1", "Boarding", "50.00");
INSERT INTO "Charges" VALUES ("2", "Grooming", "75.50");
INSERT INTO "Charges" VALUES ("3", "Training", "120.00");
INSERT INTO "Charges" VALUES ("4", "Daycare", "30.00");
INSERT INTO "Charges" VALUES ("5", "Vet Visit", "150.75");
INSERT INTO "Charges" VALUES ("6", "Special Care", "200.00");
INSERT INTO "Charges" VALUES ("7", "Food", "45.00");
INSERT INTO "Charges" VALUES ("8", "Medication", "80.25");
INSERT INTO "Charges" VALUES ("9", "Playtime", "25.00");
INSERT INTO "Charges" VALUES ("10", "Hydrotherapy", "180.00");
INSERT INTO "Treatments" VALUES ("1", "BORD", "60.00");
INSERT INTO "Treatments" VALUES ("2", "GROOM", "80.00");
INSERT INTO "Treatments" VALUES ("3", "TRAIN", "130.00");
INSERT INTO "Treatments" VALUES ("4", "DAYC", "35.00");
INSERT INTO "Treatments" VALUES ("5", "VET", "160.00");
INSERT INTO "Treatments" VALUES ("6", "SPCARE", "210.00");
INSERT INTO "Treatments" VALUES ("7", "FOOD", "50.00");
INSERT INTO "Treatments" VALUES ("8", "MEDS", "85.00");
INSERT INTO "Treatments" VALUES ("9", "PLAY", "30.00");
INSERT INTO "Treatments" VALUES ("10", "HYDRO", "190.00");
INSERT INTO "Treatments" VALUES ("11", "MASSAGE", "90.00");
INSERT INTO "Treatments" VALUES ("12", "ACUPUNC", "110.00");