Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

This tool can import the UCRex csv files without problem.

DEMOGRAPHICS => Patient

The STUDY_ID field is the key, so edit the type to set to primary key. However, it is in hex format. The type should be changed to VARCHAR with length 32. The default type is BLOB, but this can't be used as a primary key (see why).

DIAGNOSES => Diagnosis

Set the STUDY_ID field to not allow nulls, and to type VARCHAR length 32:



...

Access (obsolete for larger datasets)

...