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,
"LAC" TEXT,
"Thrombosis" INT
);

CREATE TABLE "Laboratory" (
"ID" INT,
"Date" DATE,
"SM" TEXT,
"SSA" TEXT,
"SSB" TEXT,
PRIMARY KEY ("ID", "Date")
);



INSERT INTO "Examination" VALUES ("1", "positive", "0");
INSERT INTO "Examination" VALUES ("2", "negative", "0");
INSERT INTO "Examination" VALUES ("3", "negative", "1");
INSERT INTO "Examination" VALUES ("4", "positive", "0");
INSERT INTO "Examination" VALUES ("5", "negative", "0");
INSERT INTO "Examination" VALUES ("6", "positive", "1");
INSERT INTO "Examination" VALUES ("7", "negative", "0");
INSERT INTO "Examination" VALUES ("8", "positive", "0");
INSERT INTO "Examination" VALUES ("9", "negative", "1");
INSERT INTO "Examination" VALUES ("10", "positive", "0");
INSERT INTO "Laboratory" VALUES ("1", "2024-01-10", "-", "SSA1", "SSB1");
INSERT INTO "Laboratory" VALUES ("2", "2024-01-11", "0", "SSA2", "SSB2");
INSERT INTO "Laboratory" VALUES ("3", "2024-01-12", "+", "SSA3", "SSB3");
INSERT INTO "Laboratory" VALUES ("4", "2024-01-13", "1", "SSA4", "SSB4");
INSERT INTO "Laboratory" VALUES ("5", "2024-01-14", "-", "SSA5", "SSB5");
INSERT INTO "Laboratory" VALUES ("6", "2024-01-15", "+", "SSA6", "SSB6");
INSERT INTO "Laboratory" VALUES ("7", "2024-01-16", "0", "SSA7", "SSB7");
INSERT INTO "Laboratory" VALUES ("8", "2024-01-17", "-", "SSA8", "SSB8");
INSERT INTO "Laboratory" VALUES ("9", "2024-01-18", "1", "SSA9", "SSB9");
INSERT INTO "Laboratory" VALUES ("10", "2024-01-19", "0", "SSA10", "SSB10");