...
Set the STUDY_ID field to not allow nulls, and to type VARCHAR length 32:
The ICD_CODE should be set to a string: VARCHAR, length 32 should be fine.
ENCOUNTER_ID to BIGINT.
...
Access (obsolete for larger datasets)
...
...
Set the STUDY_ID field to not allow nulls, and to type VARCHAR length 32:
The ICD_CODE should be set to a string: VARCHAR, length 32 should be fine.
ENCOUNTER_ID to BIGINT.
...
...