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),
"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.0000");
INSERT INTO "Charges" VALUES ("3", "Training", "60.0000");
INSERT INTO "Charges" VALUES ("4", "Vaccination", "30.0000");
INSERT INTO "Charges" VALUES ("5", "Medication", "15.0000");
INSERT INTO "Charges" VALUES ("6", "Emergency", "150.0000");
INSERT INTO "Charges" VALUES ("7", "Consultation", "50.0000");
INSERT INTO "Charges" VALUES ("8", "Dental", "80.0000");
INSERT INTO "Charges" VALUES ("9", "Exercise", "20.0000");
INSERT INTO "Charges" VALUES ("10", "Special Care", "100.0000");
INSERT INTO "Treatments" VALUES ("1", "Boarding", "2024-01-10 09:00:00", "25.0000");
INSERT INTO "Treatments" VALUES ("2", "Grooming", "2024-01-11 10:30:00", "40.0000");
INSERT INTO "Treatments" VALUES ("3", "Training", "2024-01-12 14:00:00", "60.0000");
INSERT INTO "Treatments" VALUES ("4", "Vaccination", "2024-01-13 08:45:00", "30.0000");
INSERT INTO "Treatments" VALUES ("5", "Medication", "2024-01-14 11:15:00", "15.0000");
INSERT INTO "Treatments" VALUES ("6", "Emergency", "2024-01-15 22:00:00", "150.0000");
INSERT INTO "Treatments" VALUES ("7", "Consultation", "2024-01-16 13:00:00", "50.0000");
INSERT INTO "Treatments" VALUES ("8", "Dental", "2024-01-17 09:30:00", "80.0000");
INSERT INTO "Treatments" VALUES ("9", "Exercise", "2024-01-18 07:00:00", "20.0000");
INSERT INTO "Treatments" VALUES ("10", "Special Care", "2024-01-19 15:00:00", "100.0000");
INSERT INTO "Treatments" VALUES ("11", "Boarding", "2024-02-01 09:00:00", "25.0000");
INSERT INTO "Treatments" VALUES ("12", "Grooming", "2024-02-02 10:30:00", "40.0000");
INSERT INTO "Treatments" VALUES ("13", "Training", "2024-02-03 14:00:00", "60.0000");
INSERT INTO "Treatments" VALUES ("14", "Vaccination", "2024-02-04 08:45:00", "30.0000");
INSERT INTO "Treatments" VALUES ("15", "Medication", "2024-02-05 11:15:00", "15.0000");
INSERT INTO "Treatments" VALUES ("16", "Emergency", "2024-02-06 22:00:00", "150.0000");
INSERT INTO "Treatments" VALUES ("17", "Consultation", "2024-02-07 13:00:00", "50.0000");
INSERT INTO "Treatments" VALUES ("18", "Dental", "2024-02-08 09:30:00", "80.0000");
INSERT INTO "Treatments" VALUES ("19", "Exercise", "2024-02-09 07:00:00", "20.0000");
INSERT INTO "Treatments" VALUES ("20", "Special Care", "2024-02-10 15:00:00", "100.0000");