-
Primary RD3 tables were moved up an level and reference tables were moved to a nested folder. Referenced tables IDs are now formatted like so:
rd3_lookups_<table>
-
Pluralized all primary tables:
subjects
,samples
, andfiles
. The tablesubjectinfo
andlabinfo
remains the same. -
All ref entities were changed to
rd3_lookups-*
-
Added ontology tags where possible; preparation for Beacon integration
-
renamed
patch
topartOfRelease
-
removed
patch_comment
as this should go in thereleases
lookup -
added compound attribute for row-level metadata to all tables, i.e.,
recordMetadata
that has the columnscomments
,dateRecordCreated
,recordCreatedBy
,dateRecordUpdated
,wasUpdatedBy
-
ERNs are now stored in the
organisations
reference table. Please userd3_lookups_organisations
-
subjects table updates: removed
id
;subjectID
is now the primary key -
subjects table updates: renamed
phenopacketID
tomostRecentPhenopacketFile
-
subjectinfo updates: removed
id
;subjectID
is now the primary key -
subjectinfo updates: renamed
dateofBirth
todateOfBirth
-
subjectinfo updates: renamed
ageOfDeath
toageAtDeath
-
subjectinfo updates: renamed
ageOfDiagnosis
toageAtDiagnosis
-
subjectinfo updates: renamed
Country_of_origin
tocountryOfBirth
-
samples updates: removed
id
;sampleID
is now the primary key -
samples updates: renamed
anatomicalLocation
toanatomicallocation
-
labinfo updates: removed
id
;experimentID
is now the primary key -
labinfo updates: changed data type of
sequencingCenter
fromstring
toxref
-
files updates: renamed
typeFile
tofileFormat
-
files updates: added
subjectID
: referencerd3_subjects
-
files updates: added
sampleID
: referencesrd3_samples
-
files updates: added
experimentID
: referencesrd3_labinfo
-
files updates: renamed
filepath_sandbox
tofenderFilePath
-
files updates: added
gearshiftFilePath
-
files updates: renamed
extraInfo
tocomments
and moved torecordMetadata
-
lookups: renamed
organisation
toorganisations
;ERNs
are now stored in organisations -
lookups: expanded
tissueTypes
table to link values to ontologies -
lookups: split variant entities into a new nested package
rd3_variants
-
lookups: split RD3 specific lookups into
rd3_info