...
ICD_CODE should be set to a string: VARCHAR, length 32 should be fine.
ENCOUNTER_ID to BIGINT.
ENCOUNTERS => encounter
Set STUDY_ID to VARCHAR length 32, do not allow nulls.
ENCOUNTER_D to BIGINT, do not allow nulls.
...
Access (obsolete for larger datasets)
...