CREATE TABLE Examination
(
    ID                 INTEGER          null,
    `Examination Date` DATE         null,
    `aCL IgG`          REAL        null,
    `aCL IgM`          REAL        null,
    ANA                INTEGER          null,
    `ANA Pattern`      TEXT null,
    `aCL IgA`          INTEGER          null,
    Diagnosis          TEXT null,
    KCT                TEXT null,
    RVVT              TEXT null,
    LAC                TEXT null,
    Symptoms           TEXT null,
    Thrombosis         INTEGER          null,
    foreign key (ID) references Patient (ID)
            on update cascade on delete cascade
);
Examination
CREATE TABLE Patient
(
    ID           INTEGER default 0 not null
        primary key,
    SEX          TEXT  null,
    Birthday     DATE          null,
    Description  DATE          null,
    `First Date` DATE          null,
    Admission    TEXT  null,
    Diagnosis    TEXT  null
);
Patient
CREATE TABLE Laboratory
(
    ID        INTEGER  default 0            not null,
    Date      DATE default '0000-00-00' not null,
    GOT       INTEGER                       null,
    GPT       INTEGER                        null,
    LDH       INTEGER                        null,
    ALP       INTEGER                        null,
    TP        REAL             null,
    ALB       REAL             null,
    UA        REAL             null,
    UN        INTEGER                       null,
    CRE       REAL             null,
    `T-BIL`   REAL             null,
    `T-CHO`   INTEGER                       null,
    TG        INTEGER                       null,
    CPK       INTEGER                       null,
    GLU       INTEGER                       null,
    WBC       REAL             null,
    RBC       REAL             null,
    HGB       REAL             null,
    HCT       REAL             null,
    PLT       INTEGER                       null,
    PT        REAL             null,
    APTT      INTEGER                       null,
    FG        REAL             null,
    PIC       INTEGER                       null,
    TAT       INTEGER                       null,
    TAT2      INTEGER                       null,
    `U-PRO`   TEXT              null,
    IGG       INTEGER                       null,
    IGA       INTEGER                       null,
    IGM       INTEGER                       null,
    CRP       TEXT              null,
    RA        TEXT              null,
    RF        TEXT              null,
    C3        INTEGER                       null,
    C4        INTEGER                       null,
    RNP       TEXT              null,
    SM        TEXT              null,
    SC170     TEXT              null,
    SSA       TEXT              null,
    SSB       TEXT              null,
    CENTROMEA TEXT              null,
    DNA       TEXT              null,
    `DNA-II`  INTEGER                       null,
    primary key (ID, Date),
        foreign key (ID) references Patient (ID)
            on update cascade on delete cascade
);
Laboratory
original_column_name,column_name,column_description,data_format,value_description
ID,,identification of the patient,integer,
Examination Date,,Examination Date,date ,
aCL IgG,anti-Cardiolipin antibody (IgG) ,anti-Cardiolipin antibody (IgG) concentration,real,
aCL IgM,anti-Cardiolipin antibody (IgM) ,anti-Cardiolipin antibody (IgM) concentration,real,
ANA,anti-nucleus antibody ,anti-nucleus antibody concentration,integer,
ANA Pattern,pattern observed in the sheet of ANA examination,pattern observed in the sheet of ANA examination,text,
aCL IgA,anti-Cardiolipin antibody (IgA) concentration,anti-Cardiolipin antibody (IgA) concentration,integer,
Diagnosis,,disease names,text,
KCT,measure of degree of coagulation,measure of degree of coagulation,text,"+: positive

-: negative"
RVVT,measure of degree of coagulation,measure of degree of coagulation,text,"+: positive

-: negative"
LAC,measure of degree of coagulation,measure of degree of coagulation,text,"+: positive

-: negative"
Symptoms,,other symptoms observed,text,
Thrombosis,,degree of thrombosis,integer,"0: negative (no thrombosis)
1: positive (the most severe one)
2: positive (severe)3: positive (mild)"
Examination
original_column_name,column_name,column_description,data_format,value_description
ID,,identification of the patient,integer,
Date,,Date of the laboratory tests (YYMMDD),date,
GOT,AST glutamic oxaloacetic transaminase,AST glutamic oxaloacetic transaminase,integer,"Commonsense evidence:

Normal range: N < 60"
GPT,ALT glutamic pyruvic transaminase,ALT glutamic pyruvic transaminase,integer,"Commonsense evidence:

Normal range: N < 60"
LDH,lactate dehydrogenase,lactate dehydrogenase,integer,"Commonsense evidence:

Normal range: N < 500"
ALP,alkaliphophatase,alkaliphophatase,integer,"Commonsense evidence:

Normal range: N < 300"
TP,total protein,total protein,real,"Commonsense evidence:

Normal range: 6.0 < N < 8.5"
ALB,albumin,albumin,real,"Commonsense evidence:

Normal range: 3.5 < N < 5.5"
UA,uric acid,uric acid,real,"Commonsense evidence:

Normal range: N > 8.0 (Male)N > 6.5 (Female)"
UN,urea nitrogen,urea nitrogen,integer,"Commonsense evidence:

Normal range: N < 30"
CRE,creatinine,creatinine,real,"Commonsense evidence:

Normal range: N < 1.5"
T-BIL,total bilirubin,total bilirubin,real,"Commonsense evidence:

Normal range: N < 2.0"
T-CHO,total cholesterol,total cholesterol,integer,"Commonsense evidence:
Normal range: N < 250"
TG,triglyceride,triglyceride,integer,"Commonsense evidence:

Normal range: N < 200"
CPK,creatinine phosphokinase,creatinine phosphokinase,integer,"Commonsense evidence:
Normal range: N < 250"
GLU,blood glucose,blood glucose,integer,"Commonsense evidence:
Normal range: N < 180"
WBC,White blood cell,White blood cell,real,"Commonsense evidence:
Normal range: 3.5 < N < 9.0"
RBC,Red blood cell,Red blood cell,real,"Commonsense evidence:

Normal range: 3.5 < N < 6.0"
HGB,Hemoglobin,Hemoglobin,real,"Commonsense evidence:

Normal range: 10 < N < 17"
HCT,Hematoclit,Hematoclit,real,"Commonsense evidence:
Normal range: 29 < N < 52"
PLT,platelet,platelet,integer,"Commonsense evidence:

Normal range: 100 < N < 400"
PT,prothrombin time,prothrombin time,real,"Commonsense evidence:

Normal range: N < 14"
APTT,activated partial prothrombin time,activated partial prothrombin time,integer,"Commonsense evidence:

Normal range: N < 45"
FG,fibrinogen,fibrinogen,real,"Commonsense evidence:

Normal range: 150 < N < 450"
PIC,,,,
TAT,,,,
TAT2,,,,
U-PRO,proteinuria,proteinuria,text,"Commonsense evidence:

Normal range: 0 < N < 30"
IGG,Ig G,Ig G,integer,"Commonsense evidence:

Normal range: 900 < N < 2000"
IGA,Ig A,Ig A,integer,"Commonsense evidence:

Normal range: 80 < N < 500"
IGM,Ig M,Ig M,integer,"Commonsense evidence:

Normal range: 40 < N < 400"
CRP,C-reactive protein,C-reactive protein,text,"Commonsense evidence:

Normal range: N= -, +-, or N < 1.0"
RA,Rhuematoid Factor,Rhuematoid Factor,text,"Commonsense evidence:

Normal range: N= -, +-"
RF,RAHA,RAHA,text,"Commonsense evidence:

Normal range: N < 20"
C3,complement 3,complement 3,integer,"Commonsense evidence:

Normal range: N > 35"
C4,complement 4,complement 4,integer,"Commonsense evidence:

Normal range: N > 10"
RNP,anti-ribonuclear protein,anti-ribonuclear protein,text,"Commonsense evidence:

Normal range: N= -, +-"
SM,anti-SM,anti-SM,text,"Commonsense evidence:

Normal range: N= -, +-"
SC170,anti-scl70,anti-scl70,text,"Commonsense evidence:

Normal range: N= -, +-"
SSA,anti-SSA,anti-SSA,text,"Commonsense evidence:

Normal range: N= -, +-"
SSB,anti-SSB,anti-SSB,text,"Commonsense evidence:

Normal range: N= -, +-"
CENTROMEA,anti-centromere,anti-centromere,text,"Commonsense evidence:

Normal range: N= -, +-"
DNA,anti-DNA,anti-DNA,text,"Commonsense evidence:

Normal range: N < 8"
DNA-II,anti-DNA,anti-DNA,integer,"Commonsense evidence:

Normal range: N < 8"
Laboratory
original_column_name,column_name,column_description,data_format,value_description
ID,,identification of the patient,integer,
SEX,,Sex,text,F: female; M: male
Birthday,,Birthday,date,
Description,,the first date when a patient data was recorded,date,null or empty: not recorded
First Date,,the date when a patient came to the hospital,date,
Admission,,patient was admitted to the hospital (+) or followed at the outpatient clinic (-),text,patient was admitted to the hospital (+) or followed at the outpatient clinic (-)
Diagnosis,,disease names,text,
Patient