8000 Postgres buildmimic scripts update for MIMIC-IV v2.0 by alexmbennett2 · Pull Request #1328 · MIT-LCP/mimic-code · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content
/ mimic-code Public

Postgres buildmimic scripts update for MIMIC-IV v2.0 #1328

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Merged
merged 8 commits into from
Jul 7, 2022
Merged

Postgres buildmimic scripts update for MIMIC-IV v2.0 #1328

merged 8 commits into from
Jul 7, 2022

Conversation

alexmbennett2
Copy link
Contributor

I updated the scripts to load MIMIC-IV v2.0 into Postgres. The main changes were:

  • Swapping out mimic_core for mimic_hosp
  • adding omr and ingredientevents
  • adding additional columns to pre-existing tables
  • removed columns if they had been dropped in this version of MIMIC-IV

Potential still to do

  • index and constraints for the two new tables omr and ingredientevents
    • left blank for now since not super clear to me what to put for the index/constraint

ghost
ghost suggested changes Jul 6, 2022
View reviewed changes
Copy link
@ghost ghost left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

From Line 195 on down you missed some mimic_core changes that have to be made.

@alistairewj alistairewj force-pushed the mimic_iv_postgres_create_updatev2 branch from 18034f7 to f67e5f0 Compare July 7, 2022 12:39
@alistairewj alistairewj merged commit 15ab4a2 into MIT-LCP:main Jul 7, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.
2 participants
@alexmbennett2 @alistairewj
0