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