Skip to content
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.

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

Replace column failed_iuid VARCHAR(4000) by completeness INTEGER in study and series table #609

Closed
gunterze opened this issue Mar 29, 2017 · 0 comments
Assignees
Labels
enhancement New feature or request
Milestone

Comments

@gunterze
Copy link
Member

alter table study add completeness int4;
alter table study drop failed_iuids;
alter table series add completeness int4;
alter table series drop failed_iuids;
  • avoid problems with DBs concerning indexing large VARCHAR columns
  • allow to distinguish between unknown completeness (=0) and known incompleteness (=1) caused by failed retrieves from the Fallback C-Move SCP without having to consider also column failed_retrieves
public enum Completeness {
    UNKNOWN, PARTIAL, COMPLETE
}
@gunterze gunterze added the enhancement New feature or request label Mar 29, 2017
@gunterze gunterze added this to the 5.10.0 milestone Mar 29, 2017
@gunterze gunterze self-assigned this Mar 29, 2017
gunterze added a commit to dcm4che/dcm4che that referenced this issue Mar 29, 2017
gunterze added a commit to dcm4che-dockerfiles/postgres-dcm4chee that referenced this issue Mar 29, 2017
gunterze added a commit to dcm4che-dockerfiles/postgres-dcm4chee that referenced this issue Mar 29, 2017
gunterze added a commit that referenced this issue Mar 30, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant