covid19
Tables (8)
Untitled (patient_table_variable)
- Key (no) — int — Foreign key → patient_table_unvariable.Key — NOT NULL
- Field (id) — int
- Field (contact) — tinyint
- Field (visit) — tinyint
- Field (smoking) — tinyint
- Field (family_self_isolation) — tinyint
- Field (family_diagnose) — tinyint
- Field (antipyretics) — tinyint
- Field (pneumonia) — tinyint
- Field (dyspnea) — tinyint
- Field (feverish) — tinyint
- Field (chill) — tinyint
- Field (myalgia) — tinyint
- Field (headache) — tinyint
- Field (fatigue_lethargy) — tinyint
- Field (sore_throat) — tinyint
- Field (cough) — tinyint
- Field (sputum) — tinyint
- Field (rhinorrhea) — tinyint
- Field (anosmia) — tinyint
- Field (chest_pain) — tinyint
- Field (diarrhea) — tinyint
- Field (nausea_vomiting) — tinyint
- Field (temp_capable) — tinyint
- Field (temp) — float
Untitled (doctor_table_demographic)
- Key (no) — int — Primary key — NOT NULL
- Field (patientid) — int
- Field (doctorid) — int
- Field (COVID_test) — tinyint
- Field (COVID_test_time) — datetime
- Field (hypertension) — tinyint
- Field (DM) — tinyint
- Field (CVD) — tinyint
- Field (CKD) — tinyint
- Field (COPD) — tinyint
- Field (asthma) — tinyint
- Field (chronic_liver_disease) — tinyint
- Field (pregnancy) — tinyint
- Field (chemotherapy) — tinyint
- Field (hematologic_malignancy) — tinyint
- Field (HIV) — tinyint
- Field (autoimmune_disease) — tinyint
- Field (transplantation) — tinyint
- Field (immunosuppress_agent) — tinyint
Untitled (doctor_table_vital)
- Key (no) — int — Primary key — NOT NULL
- Field (patientid) — int
- Field (doctorid) — int
- Field (vital_sbp) — int
- Field (vital_sbp_time) — datetime
- Field (vital_dbp) — int
- Field (vital_dbp_time) — datetime
- Field (vital_pr) — int
- Field (vital_pr_time) — datetime
- Field (vital_rr) — int
- Field (vital_rr_time) — datetime
- Field (vital_temp) — float
- Field (vital_temp_time) — datetime
- Field (vital_mental) — tinyint
- Field (vital_mental_time) — datetime
- Field (oxygen) — tinyint
- Field (oxygen_time) — datetime
- Field (oxy_con) — int
- Field (oxy_con_time) — datetime
- Field (high_oxy_con) — int
- Field (high_oxy_con_time) — datetime
- Field (saturation) — tinyint
- Field (saturation_time) — datetime
Untitled (doctor_table_lab)
- Key (no) — int — Primary key — NOT NULL
- Field (patientid) — int
- Field (doctorid) — int
- Field (COVID_test) — tinyint
- Field (COVID_test_time) — datetime
- Field (WBC_check) — tinyint
- Field (WBC) — float
- Field (WBC_time) — datetime
- Field (neutrophil_check) — tinyint
- Field (neutrophil) — float
- Field (neutrophil_time) — datetime
- Field (lymphocyte_check) — tinyint
- Field (lymphocyte) — float
- Field (lymphocyte_time) — datetime
- Field (hb_check) — tinyint
- Field (hb) — float
- Field (hb_time) — datetime
- Field (hct_check) — tinyint
- Field (hct) — float
- Field (hct_time) — datetime
- Field (plt_check) — tinyint
- Field (plt) — float
- Field (plt_time) — datetime
- Field (BUN_check) — tinyint
- Field (BUN) — float
- Field (BUN_time) — datetime
- Field (cr_check) — tinyint
- Field (cr) — float
- Field (cr_time) — datetime
- Field (alb_check) — tinyint
- Field (alb) — float
- Field (alb_time) — datetime
- Field (protein_check) — tinyint
- Field (protein) — float
- Field (protein_time) — datetime
- Field (AST_check) — tinyint
- Field (AST) — float
- Field (AST_time) — datetime
- Field (ALT_check) — tinyint
- Field (ALT) — float
- Field (ALT_time) — datetime
- Field (bilirubin_check) — tinyint
- Field (bilirubin) — float
- Field (bilirubin_date) — datetime
- Field (na_check) — tinyint
- Field (na) — float
- Field (na_time) — datetime
- Field (K_check) — tinyint
- Field (K) — float
- Field (K_time) — datetime
- Field (cl_check) — tinyint
- Field (cl) — float
- Field (cl_time) — datetime
- Field (HCO3_check) — tinyint
- Field (HCO3) — float
- Field (HCO3_time) — datetime
- Field (NT_proBNP_check) — tinyint
- Field (NT_proBNP) — float
- Field (NT_proBNP_time) — datetime
- Field (PT_check) — tinyint
- … +20
Untitled (doctor_table_image)
- Key (no) — int — Primary key — NOT NULL
- Field (patientid) — int
- Field (doctorid) — int
- Field (consolidation) — tinyint
- Field (consolidation_time) — datetime
- Field (GGO) — tinyint
- Field (GGO_time) — datetime
- Field (bilateral) — tinyint
- Field (bilateral_time) — datetime
- Field (pleural_effusion) — tinyint
- Field (pleural_effusion_time) — datetime
Untitled (doctor_table_treatment)
- Key (no) — int — Primary key — NOT NULL
- Field (patientid) — int
- Field (doctorid) — int
- Field (antiviral) — tinyint
- Field (antiviral_time) — datetime
- Field (antibiotics) — tinyint
- Field (antibiotics_time) — datetime
- Field (corticosteroid) — tinyint
- Field (corticosteroid_time) — datetime
- Field (IVIG) — tinyint
- Field (IVIG_time) — datetime
- Field (ECMO) — tinyint
- Field (ECMO_time) — datetime
- Field (CRRT) — tinyint
- Field (CRRT_time) — datetime
doctor_login
- no — int — Primary key — NOT NULL
- id — varchar(20)
- password — varchar(20)
- Field (doctorid) — int
- Field (nation) — varchar(20)
- Field (hospital) — varchar(50)
- email — varchar(30)
patient_table_unvariable
- Key (no) — int — Primary key — NOT NULL
- Field (id) — int
- Field (latitude) — float
- Field (longitude) — float
- Field (birth) — datetime
- Field (sex) — tinyint
- Field (height) — float
- Field (weight) — float
- Field (PS) — tinyint
- Field (CVD) — tinyint
- Field (CKD) — tinyint
- Field (COPD) — tinyint
- Field (asthma) — tinyint
- Field (chronic_liver_disease) — tinyint
- Field (pregnancy) — tinyint
- Field (chemotherapy) — tinyint
- Field (hematologic_malignancy) — tinyint
- Field (HIV) — tinyint
- Field (autoimmune_disease) — tinyint
- Field (transplantation) — tinyint
- Field (immunosuppress_agent) — tinyint