digital-twin

Tables (14)

ADNI (ADNIMERGE)

  • PTID (Field2) — VARCHAR(20) — Primary key
  • RID (Field) — INT
  • VISCODE (Field3) — VARCHAR(50)
  • SITE (Field4) — VARCHAR(50)
  • COLPROT (Field5) — VARCHAR(50)
  • ORIGPROT (Field6) — VARCHAR(50)
  • EXAMDATE (Field7) — DATE
  • DX_bl (Field8) — VARCHAR(50)
  • AGE (Field9) — VARCHAR(10)
  • PTGENDER (Field10) — VARCHAR(50)
  • TAU_bl (Field11) — VARCHAR(50)
  • PTAU_bl (Field12) — VARCHAR(50)
  • FDG_bl (Field13) — VARCHAR(50)
  • PIB_bl (Field14) — VARCHAR(50)
  • AV45_bl (Field15) — VARCHAR(50)
  • Years_bl (Field16) — VARCHAR(50)
  • Month_bl (Field17) — VARCHAR(50)
  • Month (Field18) — VARCHAR(50)
  • M (Field19) — VARCHAR(50)
  • update_stamp (Field20) — DATE
  • Field21

ADNI (LABDATA_11Oct2023)

  • PTID (Field) — VARCHAR(20) — Primary key
  • BAT126 (Field2) — INT

ADNI (ADNI_Selected)

  • USUBJID (CODR) — VARCHAR(10) — Foreign key → CODR.USUBJID
  • PTID (Field22) — VARCHAR(20) — Foreign key → ADNI.PTID
  • ADAS11 (Field) — Float
  • CDRSB (Field2) — Float
  • MMSE (Field3) — Float
  • AGE (Field4) — Float
  • PTGENDER (Field5) — VARCHAR(10)
  • PTEDUCAT (Field6) — INT
  • APOE4 (Field7) — Float
  • TAU_bl (Field8) — Float
  • PTAU_bl (Field9) — Float
  • ADAS11_bl (Field10) — Float
  • CDRSB_bl (Field11) — Float
  • MMSE_bl (Field12) — INT
  • RID (Field13) — INT
  • M (Field15) — Float
  • VISCODE (Field16) — Float
  • BAT126 (Field17) — VARCHAR(10)
  • PTID (NACCID) — VARCHAR(20) — Foreign key → NACC.NACCID

ADNI (ADNI_Selected_merged_df)

  • PTID (Field18) — VARCHAR(20) — Foreign key → ADNI.PTID
  • PTID (Field22) — VARCHAR(20) — Foreign key → ADNI.PTID
  • ADAS11 (Field) — Float
  • CDRSB (Field2) — Float
  • MMSE (Field3) — Float
  • AGE (Field4) — Float
  • PTGENDER (Field5) — VARCHAR(10)
  • PTEDUCAT (Field6) — INT
  • APOE4 (Field7) — Float
  • TAU_bl (Field8) — Float
  • PTAU_bl (Field9) — Float
  • ADAS11_bl (Field10) — Float
  • CDRSB_bl (Field11) — Float
  • MMSE_bl (Field12) — INT
  • RID (Field13) — INT
  • M (Field15) — Float
  • VISCODE (Field16) — Float
  • BAT126 (Field17) — VARCHAR(10)

CODR (qs.csv)

  • VISITDY (Field5) — INT — Primary key
  • VISITNUM (Field32) — INT — Foreign key → CODR.VISITNUM
  • USUBJID (Field) — VARCHAR(10) — Foreign key → CODR.USUBJID
  • ADAS (Field3) — VARCHAR(10)
  • MMSE (Field4) — VARCHAR(10)

CODR (dm.csv.)

  • USUBJID (Field) — VARCHAR(10) — Primary key
  • AGE (Field2) — INT
  • SEX (Field3) — VARCHAR(2)

CODR (sc.csv)

  • USUBJID (Field) — VARCHAR(10) — Foreign key → CODR.USUBJID
  • SCORRES (Field2) — VARCHAR(20)

CODR (pf.csv)

  • VISITNUM (Field3) — INT — Primary key
  • USUBJID (Field) — VARCHAR(10) — Foreign key → CODR.USUBJID
  • PFORRES (Field2) — VARCHAR(10)

CODR (lb.csv)

  • VISITNUM (Field3) — INT — Foreign key → CODR.VISITNUM
  • USUBJID (Field) — VARCHAR(10) — Foreign key → CODR.USUBJID
  • LBORRES (Field2) — VARCHAR(10)

CODR (CODR_merged_df)

  • VISITDY (Field52) — INT — Foreign key → CODR.VISITDY
  • VISITNUM (Field32) — INT — Foreign key → CODR.VISITNUM
  • USUBJID (Field8) — VARCHAR(10) — Foreign key → CODR.USUBJID
  • ADAS11 (Field) — Float
  • CDRSB (Field2) — Float
  • MMSE (Field3) — Float
  • AGE (Field4) — Float
  • PTGENDER (Field5) — VARCHAR(10)
  • PTEDUCAT (Field6) — INT
  • APOE4 (Field7) — Float
  • ADAS11_bl (Field10) — Float
  • MMSE_bl (Field12) — INT
  • RID (Field13) — INT
  • M (Field15) — Float
  • VISCODE (Field16) — Float
  • BAT126 (Field9) — INT

INPUT (Untitled)

  • USUBJID (Field82) — VARCHAR(10) — Foreign key → ADNI.USUBJID
  • PTID (Field22) — VARCHAR(20) — Foreign key → ADNI.PTID
  • ADAS11_t0 (Field) — Float
  • CDRSB_t0 (Field2) — Float
  • MMSE_t0 (Field3) — Float
  • ADAS11_t1 (Field4) — Float
  • CDRSB_t1 (Field5) — Float
  • MMSE_t1 (Field6) — Float
  • AGE (Field7) — Float
  • PTEDUCAT (Field8) — INT
  • APOE4 (Field9) — Float
  • TAU_bl (Field10) — Float
  • CDRSB_bl (Field11) — Float
  • ADAS11_bl (Field12) — Float
  • MMSE_bl (Field13) — Float
  • BAT126 (Field14) — INT
  • RID (Field15) — INT
  • M (Field17) — Float
  • VISCODE (Field18) — VARCHAR(20)
  • severity (Field19) — VARCHAR(20)
  • NEW_GENDER (Field20) — INT

NACC (LBD modules)

  • NACCID — VARCHAR(20) — Primary key
  • VISITYR — INT(20) — Primary key
  • NACCMMSE (Field2) — Float
  • CDRSUM (Field3) — INT
  • SEX (Field4) — INT
  • EDUC (Field5) — INT
  • NACCAPOE (Field6) — INT
  • NACCAGE (Field7) — VARCHAR(10)
  • VISITMO (Field) — INT
  • NACCTMCI (Field8) — Float
  • NACCETPR (Field9) — Float

NACC (CSF link)

  • NACCID (Field) — VARCHAR(20) — Primary key
  • CSFLPYR (Field4) — Float — Primary key
  • CSFPTAU (Field2) — Float
  • CSFTTAU (Field3) — Float
  • CSFLPMO (Field5) — INT

NACC (merged_df)

  • NACCID (LBD modules) — VARCHAR(20) — Foreign key → NACC.NACCID
  • NACCID (CSF link) — VARCHAR(20) — Foreign key → NACC.NACCID
  • NACCMMSE (Field) — Float
  • CDRSUM (Field2) — Float
  • SEX (Field3) — Float
  • EDUC (Field4) — Float
  • NACCAPOE (Field5) — Float
  • NACCAGE (Field6) — Float
  • severity (Field7) — VARCHAR(10)
  • CSFPTAU (Field11) — Float
  • CSFTTAU (Field12) — Float