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 "Examination" (
"ID" INT,
"Diagnosis" TEXT,
"Symptoms" TEXT,
"Thrombosis" INT,
FOREIGN KEY ("ID") REFERENCES "Patient"("ID")
);

CREATE TABLE "Laboratory" (
"ID" INT,
"Date" DATE,
"LDH" INT,
"CRE" FLOAT,
"CRP" TEXT,
PRIMARY KEY ("ID", "Date"),
FOREIGN KEY ("ID") REFERENCES "Patient"("ID")
);

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



INSERT INTO "Patient" VALUES ("1", "M", "2023-01-10");
INSERT INTO "Patient" VALUES ("2", "F", "2023-02-15");
INSERT INTO "Patient" VALUES ("3", "M", "2023-03-20");
INSERT INTO "Patient" VALUES ("4", "F", "2023-04-01");
INSERT INTO "Patient" VALUES ("5", "M", "2023-05-05");
INSERT INTO "Patient" VALUES ("6", "F", "2023-06-12");
INSERT INTO "Patient" VALUES ("7", "M", "2023-07-01");
INSERT INTO "Patient" VALUES ("8", "F", "2023-08-08");
INSERT INTO "Patient" VALUES ("9", "M", "2023-09-19");
INSERT INTO "Patient" VALUES ("10", "F", "2023-10-25");
INSERT INTO "Examination" VALUES ("1", "Common Cold", "Cough", "0");
INSERT INTO "Examination" VALUES ("2", "PSS", "Fatigue", "1");
INSERT INTO "Examination" VALUES ("3", "Influenza", "Fever", "0");
INSERT INTO "Examination" VALUES ("4", "PSS", "Joint Pain", "1");
INSERT INTO "Examination" VALUES ("5", "Bronchitis", "Shortness of Breath", "0");
INSERT INTO "Examination" VALUES ("6", "PSS", "Skin Rash", "1");
INSERT INTO "Examination" VALUES ("7", "Pneumonia", "Chest Pain", "0");
INSERT INTO "Examination" VALUES ("8", "PSS", "Muscle Weakness", "1");
INSERT INTO "Examination" VALUES ("9", "Allergy", "Sneezing", "0");
INSERT INTO "Examination" VALUES ("10", "PSS", "Dry Mouth", "1");
INSERT INTO "Laboratory" VALUES ("1", "2023-01-11", "100", "0.8", "1+");
INSERT INTO "Laboratory" VALUES ("2", "2023-02-16", "123", "1.0", "2+");
INSERT INTO "Laboratory" VALUES ("3", "2023-03-21", "150", "1.2", "3+");
INSERT INTO "Laboratory" VALUES ("4", "2023-04-02", "130", "1.1", "1+");
INSERT INTO "Laboratory" VALUES ("5", "2023-05-06", "110", "0.9", "2+");
INSERT INTO "Laboratory" VALUES ("6", "2023-06-13", "123", "1.0", "2+");
INSERT INTO "Laboratory" VALUES ("7", "2023-07-02", "160", "1.3", "3+");
INSERT INTO "Laboratory" VALUES ("8", "2023-08-09", "123", "1.0", "2+");
INSERT INTO "Laboratory" VALUES ("9", "2023-09-20", "90", "0.7", "1+");
INSERT INTO "Laboratory" VALUES ("10", "2023-10-26", "123", "1.0", "2+");
INSERT INTO "Laboratory" VALUES ("2", "2023-02-17", "120", "0.9", "1+");
INSERT INTO "Laboratory" VALUES ("4", "2023-04-03", "125", "1.0", "2+");
INSERT INTO "Laboratory" VALUES ("6", "2023-06-14", "130", "1.1", "3+");
INSERT INTO "Laboratory" VALUES ("8", "2023-08-10", "115", "0.9", "1+");
INSERT INTO "Laboratory" VALUES ("10", "2023-10-27", "120", "1.0", "2+");