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 "Laboratory" (
"ID" INT,
"Date" DATE,
"WBC" FLOAT,
"RBC" FLOAT,
"HGB" FLOAT,
"HCT" FLOAT,
PRIMARY KEY ("ID", "Date"),
FOREIGN KEY ("ID") REFERENCES "Patient"("ID")
);

CREATE TABLE "Patient" (
"ID" INT UNIQUE,
"SEX" TEXT,
PRIMARY KEY ("ID")
);



INSERT INTO "Patient" VALUES ("1", "F");
INSERT INTO "Patient" VALUES ("2", "M");
INSERT INTO "Patient" VALUES ("3", "F");
INSERT INTO "Patient" VALUES ("4", "F");
INSERT INTO "Patient" VALUES ("5", "M");
INSERT INTO "Patient" VALUES ("6", "F");
INSERT INTO "Patient" VALUES ("7", "M");
INSERT INTO "Patient" VALUES ("8", "F");
INSERT INTO "Laboratory" VALUES ("1", "2024-01-10", "3.4", "4.5", "13.2", "40.1");
INSERT INTO "Laboratory" VALUES ("1", "2024-02-10", "3.6", "4.6", "13.5", "41.0");
INSERT INTO "Laboratory" VALUES ("2", "2024-01-15", "4.0", "4.8", "14.0", "42.0");
INSERT INTO "Laboratory" VALUES ("3", "2024-01-20", "3.2", "4.4", "12.8", "39.5");
INSERT INTO "Laboratory" VALUES ("3", "2024-02-20", "3.0", "4.3", "12.5", "38.9");
INSERT INTO "Laboratory" VALUES ("4", "2024-01-25", "3.7", "4.7", "13.8", "41.5");
INSERT INTO "Laboratory" VALUES ("5", "2024-01-30", "3.3", "4.9", "14.2", "43.0");
INSERT INTO "Laboratory" VALUES ("6", "2024-02-05", "3.1", "4.2", "12.9", "39.0");
INSERT INTO "Laboratory" VALUES ("7", "2024-02-10", "3.8", "4.6", "13.6", "40.5");
INSERT INTO "Laboratory" VALUES ("8", "2024-02-15", "3.4", "4.5", "13.1", "40.0");
INSERT INTO "Laboratory" VALUES ("8", "2024-03-15", "3.9", "4.7", "13.7", "41.2");