Chado icon indicating copy to clipboard operation
Chado copied to clipboard

V1.3.3.013 Add type_id and rank to all linker tables

Open laceysanderson opened this issue 1 month ago • 0 comments

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

laceysanderson avatar May 06 '24 19:05 laceysanderson