Chado
Chado copied to clipboard
V1.3.3.013 Add type_id and rank to all linker tables
DRAFT / NOT COMPLETE
This PR is not complete plus it is dependant on #143.
Description
This PR adds a nullable type_id and rank column to all linker tables. The unique constraint is added via a Postgresql procedure in order to use the UNIQUE NULLS NOT DISTINCT
provided by PostgreSQL 15+ if available. It is backwards compatible because these columns are nullable.
Tables updated:
- [x] _contact linkers: feature_contact, featuremap_contact, library_contact, nd_experiment_contact, project_contact, pubauthor_contact.
- [ ] _analysis linkers
- [ ] _project linkers
- [ ] _pub linkers
- [ ] _synonym linkers
- [ ] _cvterm linkers
- [ ] _dbxref linkers
- [ ] _db linkers
- [ ] _feature linkers
- [ ] _stock linkers
- [ ] _organism linkers
- [ ] _expression linkers
- [ ] _assay linkers