Changed column widths to import data without truncating

MIT-LCP / mimic-code

MIMIC Code Repository: Code shared by the research community for the MIMIC family of databases

https://mimic.mit.edu

MIT License

2.41k stars 1.5k forks source link

Closed KenjiOhtsuka closed 7 months ago

KenjiOhtsuka commented 11 months ago

CHARTEVENTS VALUENUM
- From DECIMAL(22, 10) to DECIMAL(30, 23).
- Actual data contains 7 integer digits and 23 decimal places at most.
INPUTEVENTS_MV ORDERCOMPONENTTYPEDESCRIPTION
- From VARCHAR(20) to VARCHAR(200).
- Actual data contains 100 characters at most.
- MIMIC-III data definition page says ORDERCOMPONENTTYPEDESCRIPTION is VARCHAR(200).