Skip to content

Latest commit

 

History

History
95 lines (65 loc) · 3.03 KB

CHANGELOG_Data.md

File metadata and controls

95 lines (65 loc) · 3.03 KB

Changelog

All notable data structure changes to this project will be documented in this file.

This includes both schema and data workflow changes.

The format is based on Keep a Changelog, and this project adheres to Semantic Versioning.

3.0.0

  • Updated .NET version from 6.0 to 8.0

2.1.0

  • Index added to ExternalDonorCode column in Donors table.

1.6.1

  • Indexes on several tables have been add/amended to improve performance, based on Azure recommendations.
    • Existing index on DonorManagementLogs table will be dropped and recreated via EF migration.
    • New indexes on matching HLA tables will only be added during the next run of data refresh.

1.6.0

Donors

New columns have been added

  • ExternalDonorCode - unique identifier for donors provided by the consumer. String - can be numeric but does not need to be.
  • EthnicityCode - string representation of donor ethnicity
  • RegistryCode - string representation of donor source registry

<= 1.5.0

Prior to v1.5 of Atlas, no Changelog was actively updated. A snapshot of the schema at this time has been documented here, and all future changes should be documented against the appropriate version.

Donors

Copy of donor store from the persistent donor table, allowing for FK relationships to pre-processed search data

  • Id - PK, unique to matching component. Should not leave matching algorithm
  • DonorId - Internal Atlas id of a donor. (NOT external donor id - this must be looked up in the master donor store before leaving Atlas)
  • DonorType - Adult or Cord
  • IsAvailableForSearch - allows "soft-deletion" of donors, which is more efficient than removal in bulk
  • HLA Data
  • A_1
  • A_2
  • B_1
  • B_2
  • C_1
  • C_2
  • DPB1_1
  • DPB1_2
  • DQB1_1
  • DQB1_2
  • DRB1_1
  • DRB1_2

DonorManagementLogs

Log of when donors were last updated, to enforce donor updates are applied in strict order.

  • Id
  • DonorId - matching algorithm assigned donor id from Donors
  • SequenceNumberOfLastUpdate - id from service bus message triggering the latest update for the donor (not used in practice)
  • LastUpdateDateTime - time this donor was last updated

PGroupNames

Normalisation of P-Group strings

  • Id- internal matching algorithm specific id for a p-group
  • Name - name used by official nomenclature for this p-group

HlaNames

Normalisation of HLA names seen in all donor typings

  • Id- internal matching algorithm specific id for a hla name
  • Name - name used by official nomenclature for this hla name

MatchingHlaAtX

One table per supported locus. Used for relating a donor's HLA at each position to the denormalised hla name table

  • Id
  • TypePosition - position within locus - 1 or 2
  • DonorId - FK to Donors
  • HlaNameId - FK to HlaNames

HlaNamePGroupRelationAtX

One table per supported locus. Used to relate all known hla names to one or more possible P-groups.

  • Id
  • HlaNameId - FK to HlaNames
  • PGroupId - FK to PGroupNames