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,
"treatment_type_code" VARCHAR(10),
"cost_of_treatment" DECIMAL(19, 4),
PRIMARY KEY ("treatment_id"),
FOREIGN KEY ("treatment_type_code") REFERENCES "Treatment_Types"("treatment_type_code")
);





INSERT INTO "Charges" VALUES ("1", "Boarding", "50.00");
INSERT INTO "Charges" VALUES ("2", "Grooming", "75.00");
INSERT INTO "Charges" VALUES ("3", "Training", "120.00");
INSERT INTO "Charges" VALUES ("4", "Medical", "200.00");
INSERT INTO "Charges" VALUES ("5", "Daycare", "30.00");
INSERT INTO "Charges" VALUES ("6", "Special", "250.00");
INSERT INTO "Charges" VALUES ("7", "Vaccine", "80.00");
INSERT INTO "Charges" VALUES ("8", "Dental", "150.00");
INSERT INTO "Charges" VALUES ("9", "Consult", "90.00");
INSERT INTO "Charges" VALUES ("10", "Emergency", "300.00");
INSERT INTO "Treatment_Types" VALUES ("BOARD", "Daily boarding services");
INSERT INTO "Treatment_Types" VALUES ("GROOM", "Full grooming services including bath and trim");
INSERT INTO "Treatment_Types" VALUES ("TRAIN", "Basic obedience training sessions");
INSERT INTO "Treatment_Types" VALUES ("MEDIC", "Medical examination and minor procedures");
INSERT INTO "Treatment_Types" VALUES ("DAYCR", "Daycare services for dogs");
INSERT INTO "Treatment_Types" VALUES ("SPCL", "Specialized care for specific conditions");
INSERT INTO "Treatment_Types" VALUES ("VACC", "Vaccination services");
INSERT INTO "Treatment_Types" VALUES ("DENT", "Dental cleaning and check-up");
INSERT INTO "Treatment_Types" VALUES ("CONS", "Consultation with a veterinarian");
INSERT INTO "Treatment_Types" VALUES ("EMERG", "Emergency medical services");
INSERT INTO "Treatments" VALUES ("101", "BOARD", "45.00");
INSERT INTO "Treatments" VALUES ("102", "GROOM", "70.00");
INSERT INTO "Treatments" VALUES ("103", "TRAIN", "110.00");
INSERT INTO "Treatments" VALUES ("104", "MEDIC", "190.00");
INSERT INTO "Treatments" VALUES ("105", "DAYCR", "28.00");
INSERT INTO "Treatments" VALUES ("106", "SPCL", "240.00");
INSERT INTO "Treatments" VALUES ("107", "VACC", "75.00");
INSERT INTO "Treatments" VALUES ("108", "DENT", "145.00");
INSERT INTO "Treatments" VALUES ("109", "CONS", "85.00");
INSERT INTO "Treatments" VALUES ("110", "EMERG", "290.00");
INSERT INTO "Treatments" VALUES ("111", "MEDIC", "210.00");
INSERT INTO "Treatments" VALUES ("112", "SPCL", "260.00");