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