OHDSI / OHDSI/CommonDataModel

Death table PK

Open
#741 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
HTML
Stars
1.1k
Forks
508
Avg merge
1h 30m
Merged PRs (30d)
3

Description

Death table in Postgres 5.4 has no primary key constraint. Strangly enough, the ER model also has no PK for death table, making the relationship between Person and Death of type one-to-many. This must be a mistake I assume?

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Inspect the Postgres 5.4 Death table definition and the corresponding ER model, then compare them with the stated Person–Death relationship. Confirm whether the missing primary key is unintended; done means the schema and ER model agree on the intended relationship and the issue's conclusion is documented or corrected.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgres
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.