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,
"aCL IgM" FLOAT,
"ANA Pattern" TEXT,
"Thrombosis" INT,
FOREIGN KEY ("ID") REFERENCES "Patient"("ID")
);

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



INSERT INTO "Patient" VALUES ("1");
INSERT INTO "Patient" VALUES ("2");
INSERT INTO "Patient" VALUES ("3");
INSERT INTO "Patient" VALUES ("4");
INSERT INTO "Patient" VALUES ("5");
INSERT INTO "Patient" VALUES ("6");
INSERT INTO "Patient" VALUES ("7");
INSERT INTO "Patient" VALUES ("8");
INSERT INTO "Patient" VALUES ("9");
INSERT INTO "Patient" VALUES ("10");
INSERT INTO "Patient" VALUES ("11");
INSERT INTO "Patient" VALUES ("12");
INSERT INTO "Patient" VALUES ("13");
INSERT INTO "Patient" VALUES ("14");
INSERT INTO "Patient" VALUES ("15");
INSERT INTO "Examination" VALUES ("1", "10.0", "S", "1");
INSERT INTO "Examination" VALUES ("2", "15.0", "S", "2");
INSERT INTO "Examination" VALUES ("3", "20.0", "S", "2");
INSERT INTO "Examination" VALUES ("4", "25.0", "S", "3");
INSERT INTO "Examination" VALUES ("5", "30.0", "S", "2");
INSERT INTO "Examination" VALUES ("6", "12.0", "P", "2");
INSERT INTO "Examination" VALUES ("7", "18.0", "S", "1");
INSERT INTO "Examination" VALUES ("8", "22.0", "S", "2");
INSERT INTO "Examination" VALUES ("9", "28.0", "S", "2");
INSERT INTO "Examination" VALUES ("10", "35.0", "S", "3");
INSERT INTO "Examination" VALUES ("11", "16.0", "S", "2");
INSERT INTO "Examination" VALUES ("12", "21.0", "S", "2");
INSERT INTO "Examination" VALUES ("13", "14.0", "P", "1");
INSERT INTO "Examination" VALUES ("14", "26.0", "S", "2");
INSERT INTO "Examination" VALUES ("15", "19.0", "S", "2");