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 "Treatment_Types" (
"treatment_type_code" VARCHAR(10),
"treatment_type_description" VARCHAR(80),
PRIMARY KEY ("treatment_type_code")
);

CREATE TABLE "Treatments" (
"treatment_id" INT,
"date_of_treatment" DATETIME,
"cost_of_treatment" DECIMAL(19, 4),
PRIMARY KEY ("treatment_id")
);





INSERT INTO "Charges" VALUES ("1", "Boarding", "25.0000");
INSERT INTO "Charges" VALUES ("2", "Grooming", "40.5000");
INSERT INTO "Charges" VALUES ("3", "Vaccines", "0.0000");
INSERT INTO "Charges" VALUES ("4", "Boarding", "30.0000");
INSERT INTO "Charges" VALUES ("5", "Special$Care", "150.7500");
INSERT INTO "Charges" VALUES ("6", "Training", "1000.0000");
INSERT INTO "Charges" VALUES ("7", "Grooming", "35.0000");
INSERT INTO "Charges" VALUES ("8", "Emergency", "5000.0000");
INSERT INTO "Charges" VALUES ("9", "Dental", "200.0000");
INSERT INTO "Charges" VALUES ("10", "Vaccines", "20.0000");
INSERT INTO "Charges" VALUES ("11", "Boarding", "0.0000");
INSERT INTO "Charges" VALUES ("12", "X-Ray", "300.0000");
INSERT INTO "Charges" VALUES ("13", "Training", "950.0000");
INSERT INTO "Charges" VALUES ("14", "Special_Care", "150.7500");
INSERT INTO "Charges" VALUES ("15", "Emergency", "0.0000");