...
Set the STUDY_ID field to not allow nulls, and to type VARCHAR length 32:
ENCOUNTER_ID to BIGINT.
ICD_CODE should be set to a string: VARCHAR, length 32 should be fine.ENCOUNTER_ID to
BIGINTICD_DESCR should be set to 255 length; it may default to 150, which is not long enough.
ENCOUNTERS => encounter
Set STUDY_ID to VARCHAR length 32, do not allow nulls.
...